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.

Types of cursors?

3 Answers  

---

What is profile and what is level of profile option and it's hierarchy

1 Answers   IBM,

---

in procedure how to return a value

2 Answers   Wipro,

---

Tell me how to find the custom directory in front end?

0 Answers  

---

What are documents and test cases u followed.

2 Answers   Accenture,

---

Which is the best website to learn Oracle Apps?

2 Answers  

---

we have select statement in that two exceptions that returns no value. In that which exception will raise?

2 Answers  

---

how to get the on hand quantity of an item across all organizations? name the underlying tables.

2 Answers   Ranves IT Solutions, Scan Steel,

---

Can we create tables in apps schema?

0 Answers  

---

where is setup of business group done?

2 Answers   TCS,

---

i have 100 pages output. i want to print 10 records per page in Template?

2 Answers   Sierra Atlantica,

---

What is secuirity's in R12 features.

1 Answers   KPIT,

---