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


Please Help Members By Posting Answers For Below Questions

In hierarchical structure of a database? we have write query from where we should start?

1708


What does appl_top directory contain?

647


what is the differences between internal requisition and internal sales order?

2158


Are you familiar with internet architecture of oracle apps 11i?

630


Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

637






In sequence i want to 11 and 15th values how we will write?

1573


Can you define an erp system?

681


how can develope the po variance and po summary report? with tables mandatory columns and query please?

1976


How can we import the data into a database using sql * loader?

681


What do you understand by soa and what are the benefits of using this architecture?

619


Is soa a part of oracle fusion middleware?

607


List the types of flexfield?

605


What is count(*) from po_vendors(any table)?

644


In oracle application how do you debug or trace errors?

639


What is instead of trigger in where we will use?

677