what is difference between po_headers_all and po_headers
Answer Posted / 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 |
Post New Answer View All Answers
In hierarchical structure of a database? we have write query from where we should start?
What does appl_top directory contain?
what is the differences between internal requisition and internal sales order?
Are you familiar with internet architecture of oracle apps 11i?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
In sequence i want to 11 and 15th values how we will write?
Can you define an erp system?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
How can we import the data into a database using sql * loader?
What do you understand by soa and what are the benefits of using this architecture?
Is soa a part of oracle fusion middleware?
List the types of flexfield?
What is count(*) from po_vendors(any table)?
In oracle application how do you debug or trace errors?
What is instead of trigger in where we will use?