Can anyone tell me why in some tables in AR , AP, GL modules
they r using int_all after every table

Answer Posted / sugam ghosh

All _all tables are having org_id column by which you can
extract all information kept in that table for a particular
org.
For example, in PO_HEADERS_ALL table if you wish to extract
all header level information of all POs created for org 89,
you just have to run,

select * from PO_HEADERS_ALL where org_id=89;

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is VAT claim process?

2102


Charge Back Setups ?

1704


What is Difference between Auto Copy Journal and recurring journal?

1300


What is meaning of deprecation?

618


encumbrence set ups?

2080






What is the use of hr: user type, while configure multiorg?

702


How to support projects life cycles details?

672


Re: While you are in implemenation what are u faced the issues ? tell me what some ap & GL issues?

1952


What do you mean by controlling buyers workload?

8922


What is the use of operating unit, while configure multiorg?

687


What is the procedure for requition import?

1890


What is the Process of Reconciliation Between AP to GL

1163


What are the inventory report to check inventory status.

2004


What kind of budgets have you worked on?

1881


what is the difference between bonus reserve and bonus expense

3991