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 is count(*) from po_vendors(any table)?

0 Answers  

What is ment by Global Templates in Oracle.

1 Answers   IBM,

Can you explain the difference between architecture followed in 10g & 11g?

0 Answers  

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

1 Answers   BirlaSoft,

what type of testing u r doing?

2 Answers   Convergys,

WHAT IS THE USE OF SKIP WHERE U WILL GIVE?

3 Answers  

In developer Reports::there are 3 parameters.can you pass the paramter1+paratmeter2 value to the third parameter??

1 Answers  

How to print multi currency,multi language in xml?

1 Answers  

Name the different Cursor Attributes.

2 Answers   Satyam,

i have 100 pages output. i want to print 10 records per page in Template?

2 Answers   Sierra Atlantica,

Is it possible calling from one report to another? if possible means tell me ?

3 Answers   Intelligroup, Satyam,

where to define interorganization transaction charges and what are the different options?

0 Answers   Scan Steel,