what is the difference between multiorg views and multiorg
tables
Answers were Sorted based on User's Feedback
Answer / bhabna
Multi tables generally consists _all with their name.So all
the OU data can be shown through the table.
In Multi org view definition, enviroment is set in such a
way that user can see data respective to the OU which is
already set.
To set the enviroment for an OU user should execute the
following...
fnd_client_info.set_org_context('OU_Value');
so the basic difference is In table we can see all the data
irrespective of OU...But we can see the data for a specific
OU through view.
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / gyan
Multiorg table are those where they having org_id column and
_all in the table name and views which having org_id but
without _all in the table name
| Is This Answer Correct ? | 0 Yes | 8 No |
Tell me how to find the custom directory in front end?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
How to generate XML Report with out using rdf?
6 Answers BirlaSoft, Patni, UST,
How many schemas we have? how many you have used?
WHAT IS THE USE OF SKIP WHERE U WILL GIVE?
Except the SRS window in which we can submit the concurrent program.
Tell me some thing about SQL-LOADER.
What is FORWARD DECLARATION in Packages?
6 Answers British Telecom BT, HCL, Tech Mahindra,
35—how to create ldt lct files? 36—how to tranfor on file from one instance to another instance?
What is set function in sql .E.g.What is difference between union and union all
What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.
AOL?