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 |
Is that Possible To create package without Specification , If Yes Give any Examples
what is instead of trigger in where u will use?
what is the defference between credit memo and debit memo
What is profile and what is level of profile option and it's hierarchy
In Per_all_people_f table what is the significance of '_f ' ?
how can we return morethan one parameters in procedure?
where the accounting related data is stored ? all type of accounting related data costing etc...
What is Value Set?
What is Formula Column?
In which directory your flatfile is given?if u connected different instance where it is find?
What are the Major differences bteween key flexfields ,descriptive flexfields
4 Answers Sierra Atlantica, TechBulls,
what is difference between po_headers_all and po_headers