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
Can I do a payment of 50 bills on a post date. If yes, then how?
What is multi org? What is difference between 11i and 12i multi org structure?
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.
What is gap analysis, how do you defined?
What do you mean by Category Set ? and what is its Relevance ?
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.
what is the difference between before pages trigger and after parameter trigger in reports ?
Can Adjustments be imported?
What is meaning of deprecation?
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.
What is Work Flow of AP,AR, Sales & Purchase
What is the meaning holding tax?
What is gap analysis, what are the pre-requisities?
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.
Charge Back Setups ?