Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between po_headers_all and po_headers
- 5 Answers
- 34803 Views
- Deloitte, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sangeetha
po_headers is a VIEW
while po_headers_all is a TABLE
| Is This Answer Correct ? | 20 Yes | 4 No |
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 )
| Is This Answer Correct ? | 5 Yes | 1 No |
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
| Is This Answer Correct ? | 2 Yes | 0 No |
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;
| Is This Answer Correct ? | 4 Yes | 3 No |
Answer / mry
both are related to purchase module.
-all table is multiorg level table
| Is This Answer Correct ? | 3 Yes | 3 No |
P_CONC_REQUEST_ID mandatory in oracle reports to run in oracle applications or not ( I am not talking about running in report builder or D2k ) or not ?
9 Answers CSC, IBM, KPIT, Oracle,
There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.
Where I can download D2K software?
what are the important table names in purchasing?
in procedure how to return a value
what u did after ur btech(2009) till now? why did u prefer oracle apps technical?
what are the receipt types in Po?
What are triggers?
In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?
where the accounting related data is stored ?
What is template?
How we will receive the work from the client? what type of documents we will develop in the entire implementation project? plz tell me the total scinario?
2 Answers Deloitte, Intelligroup,
Oracle Apps Technical 
