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

Can I do a payment of 50 bills on a post date. If yes, then how?

1301


What is multi org? What is difference between 11i and 12i multi org structure?

631


I am working on PPR process to print checks. Currently the checks are printing for each supplier, supplier site and payment method group. My requirement is the invoice level one DFF is available (like A and B are the input values). Please let me know how include this DFF at invoice grouping level.

1097


What is gap analysis, how do you defined?

634


What do you mean by Category Set ? and what is its Relevance ?

1968






I have a requirement where during the consolidation into USD (from GBP books) I want use two different exchange rates for two consolidations. Child SOB is same but the Parent SOB's are different. How can this be done in Oracle Financials? Answers will be Appreciable. Thank You.

1442


what is the difference between before pages trigger and after parameter trigger in reports ?

1942


Can Adjustments be imported?

1693


What is meaning of deprecation?

601


In Subinventories Form, how to enable the Locator Control. A message displayed when changing the drop down list "FRM-40200: Field is protected against update.

2392


What is Work Flow of AP,AR, Sales & Purchase

1983


What is the meaning holding tax?

645


What is gap analysis, what are the pre-requisities?

713


While assigning the security by book in oracle assets..i am unable ot get the asset org in security profile form.This asset org was already defined in org description window.

2278


Charge Back Setups ?

1695