What multi org tables . example - difference between app
table non all table . Po_header and po_headers_all

Answer Posted / askvenki

-all is multiorgtable which contains all orgnization
information
po_hedear is the view which contains information abt
particular organization of user is login
-- little tricy to understand how it works
how view get particular organization data
select * from po_headers where org_id=:client_info
client_info holds the org_id which user logged
if any dout askvenki@gmail.com i will respond

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

761


How is choreography different from orchestration?

757


What is instead of trigger in where we will use?

755


What is sca and how is it useful?

746


What are the different components of soa suite?

817






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

2260


In oracle application how do you debug or trace errors?

729


How can you achieve loose coupling in soa framework?

827


What is oracle soa suite and what are its different components?

742


Do you know what are user profiles in apps. Any examples you can give?

749


how can i print random rows in plsql table

2034


please send me forms, xml pulisher questions,answers

1772


Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2232


Explain oracle apps architecture.

851


Can u give the Documentation of Custom.pll in oracle apps

3105