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.

IN GL,AP,PO,AR WHICH MODULE DOESNOT HAVE _ALL TABLES THEN WHY?

7 Answers   Accenture,

---

hi gurus my name is ramesh i was completed orcale apps technical trainning i wnt to put 3+yrs experience is it correct r not ,if any freshers jobs are available in market pls suggest me. my mail id rameshmcaou@gmail.com and contact no is 9000342411

3 Answers   Oracle,

---

how do you describe O2C along with tables

0 Answers   TCS,

---

What are do's and dont's of Interface?

0 Answers  

---

what is the difference between multiorg views and multiorg tables

2 Answers   Immense Source, Intelligroup, TCS,

---

can we execute one concurrent program through another concurrent program?

1 Answers   KPIT,

---

why r u move in the cus_top only why not move another top

4 Answers  

---

what are version control tools used in oracle apps?

1 Answers   Cap Gemini, Sony,

---

Which oracle apps version you are very confident in?

0 Answers  

---

explain o2c cycle? what are the table reflected for this process?

1 Answers   BirlaSoft,

---

Difference between Bind and Lexical parameters?

3 Answers  

---

How will you get the concurrent program output as email?

3 Answers   IBM, KPIT,

---