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

q)what are the validations in sql*loader

0 Answers   Accenture,

how to get the on hand quantity of an item across all organizations? name the underlying tables.

2 Answers   Ranves IT Solutions, Scan Steel,

How to send the e-mail notification in XML Pub Report?

2 Answers   Accenture, Oracle,

what is the defference between credit memo and debit memo

3 Answers   Wipro,

IN GL,AP,PO,AR WHICH MODULE DOESNOT HAVE _ALL TABLES THEN WHY?

7 Answers   Accenture,

what are the sql attributes?

2 Answers  

how to create requst set in oracle apps and how to send muliple requests at a time,

1 Answers   Genpact,

What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?

2 Answers   TCS,

while registering executable and concurent program we register both with application name|<oracle purchasing>? so my question is why we are defining in both concurent program and executable?

9 Answers  

what is the prerequisite for defining unit of measure?

1 Answers   Scan Steel, TCS,

how to enable Zoom function and steps?

1 Answers   Patni,

which is the table for storing organization information?

9 Answers   Infosys, Scan Steel,