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.

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

what are the difference between oracle discoverer and report6i

1 Answers  

---

When you run he report you have to get only that particular organization po numbers or item number how can do it?

2 Answers   IBM,

---

A file has both header and corresponding lines. Explain design to load this data into respective interface tables.

1 Answers   Satyam,

---

what is the difference between procedure and function

3 Answers   Wipro,

---

what is pick selection list generation report.

3 Answers  

---

which API to return the parameters & valuesets etc

1 Answers   GE, TCS,

---

what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(any table)? what is count(0) from po_vendors(any table) the out put is same what is the difference

4 Answers   IBM,

---

What is the autonomous transaction?give me example?

2 Answers   Cap Gemini,

---

In report we have to show two Layout? how it is and how we can see from where it?

3 Answers   IBM,

---

Which module is not in multiorg

6 Answers   HCL, Wipro,

---

what are the prerequisites for costing transactions?

0 Answers   Scan Steel,

---

Can function be overload?

4 Answers  

---