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 the difference between varchar and varchar(2)?

4 Answers  

diff between key and descriptive flexfield.

4 Answers   Convergys,

What is ERP? Architecture of apps?

3 Answers   TCS,

please send me forms, xml pulisher questions,answers

0 Answers   Zensar,

HOW U DISPLAY THE FLEXFIELD DATA IN APPS?

2 Answers  

How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?

2 Answers   Oracle,

what is meant by bind parameter?

2 Answers   Satyam,

how do you describe O2C along with tables

0 Answers   TCS,

for report i have to parameters those are from_date and to_date ,so to_date should be greater when compare to from_date ,if we are giving to_date is less then it must shows some error how we willmake

3 Answers  

mention the interface tables for item open interface and open transaction interface and also their respective production tables.

1 Answers   Scan Steel,

Can you have two functions with the same name in a pl/sql block?

5 Answers   TCS,

Need Training & Internship with guaranteed Job in ERP - Oracle Apps Tech?

4 Answers   Zensar,