WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?
Answers were Sorted based on User's Feedback
Answer / kumar
In apps you will find n number of views
During the creation of view based on the Base table in the
where clause ,below condition will be mentioned.
So that it will take the value of profile MO:Operating Unit
and display the values of corresponding Org_id.
WHERE NVL (org_id,
NVL (TO_NUMBER (DECODE (SUBSTRB (USERENV
('CLIENT_INFO'),
1,
1
),
' ', NULL,
SUBSTRB (USERENV
('CLIENT_INFO'),
1,
10
)
)),
-99)) =
NVL (TO_NUMBER (DECODE (SUBSTRB (USERENV
('CLIENT_INFO'),
1,
1
),
' ', NULL,
SUBSTRB (USERENV
('CLIENT_INFO'),
1,
10
)
)),
-99);
if you simply select from the view without setting the apps
environment , no output will be displayed.
To set the apps environment,
The following block of code has to be executed.
BEGIN
DBMS_APPLICTION_INFO.SET_CLIENT_INFO('ORG_ID');
END;
OR
BEGIN
FND_CLIENT_INFO.SET_ORG_CONTEXT('ORG_ID');
END;
THE VALUES OF ORG_ID DEPENDS ON YOUR REQUIREMENTS.
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / roshan
view is a virtual object,After creating a table in a schema
and then creating view then grant to apps.we use views as
to display data in reports.
hope the answer.
roshan
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / viswa
view is one of the object, it is like as a table ,it will
created based on table,it has no data,using this we can
retrieve particular organization information
syntax
create view<view name> as select *from <table name> where
org_id=userenv('client_info')
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / sreekanth reddy.b
View is a database object, views are created for security purpose and reduce complexity. A View is based on more than one table.
Is This Answer Correct ? | 1 Yes | 0 No |
what are the match approvals in PO?
what is meant by Table space?
Who information?s?
Is there any limitations on responsibility assigned to a apps user?
how many sections are there in report?
Registering parametric report?
can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(same parameters)
Hi, can anybody tell me where is the requirement of Oracle Apps (functional+technical) in industry,Iwant to join there,If possible than call me---9313174232
Form development process?
where we find the status of order information.
Oder of firing triggers in form
What is the difference between base table and multi-org table?