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.

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

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')

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.

What is the interface?

3 Answers  

---

what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?

1 Answers   IBM,

---

what do u mean by debit/credit memo invoices?

3 Answers   ACC, Convergys, Mascon,

---

Can we create tables in apps schema?

0 Answers  

---

which parameters passed in report in oracle developer how to pass

3 Answers  

---

Can you have two stored functions with in the same name?

3 Answers  

---

Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?

7 Answers   Satyam,

---

tell me the scenarios of between pages in reports

5 Answers  

---

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

0 Answers   Satyam,

---

What are triggers?

3 Answers  

---

How is choreography different from orchestration?

0 Answers  

---

how to change the logo in template dynamically?

2 Answers   Sierra Atlantica,

---