Answer / sangeetha

po_headers is a VIEW
while po_headers_all is a TABLE

Answer / sanjoy mukhopadhyay, cesc ltd,

Po_headers_all is a table which stores org_id as a column.
But Po_headers is a multi-org sensitive view of
po_headers_all.
Actually , any table in oracle apps , having _all in its
name at last position is a table with org_id and without
this _all is a view of that table which shows data
pertaining to the org_id through which apps uaser has
logged in ( based on profile set up , reponsibility level )

Answer / prasanth

PO_HEADERS IS A VIEW WHERE AS
PO_HEADERS_ALL IS A TABLE ,The difference is po_headers_all contains all operating units information, where as po_headers contains particular operating unit information.so po_headers is the best.because of security.if any person login he can see only that particular operating unit information.he cant see all operating unit information

Answer / devi nossam

here we can see clearly
po_headers_all is base table(multi org table)
po_lines_all is view(multi org view)

difference is

when we create a report in report builder,we can directly
run the report with out executing the some api's

where it is in view means we have to run api's in [pl/sql )
the api's are

begin
fnd_profile.get('org_id');
end;

Answer / mry

both are related to purchase module.

-all table is multiorg level table

What are the Standard Reports and Forms in HRMS?

0 Answers  

In xml report, how to print the headings in every page?

1 Answers   Sierra Atlantica,

Can function be overload?

4 Answers  

What is menu.

2 Answers   Accenture,

Define MultiOrg Structure

5 Answers   Convergys,

what is user exit and wat program do we write in user exit?

4 Answers   iGate,

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

0 Answers  

How you will Diaplay the Company LOGO In report.Can anyone knows please give solution

8 Answers   TCS,

what is meant by lexical parameter

1 Answers   Wipro,

Is there any limitations on responsibility assigned to a apps user?

6 Answers   ESS,

explain registration steps of a concurrent program.

1 Answers   TCS,

how to customize the report,please tell me customization steps

5 Answers   Accenture,