Interested to Buy Any Domain ? << Click Here >> for more details...
Can anyone tell me why in some tables in AR , AP, GL modules
they r using int_all after every table
- 2 Answers
- 13667 Views
- Accenture, I also Faced
- E-Mail Answers
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
what is the difference between before pages trigger and after parameter trigger in reports ?
What is the db number of a particular customer TCA?
There is employee X and employee Y (who is supervisor of X); when Y submits expenses how will the system ensures that this should not go to X even if he has the approval authority.
Hi I'm new in ERP - Oracle Application i appriciate if any one help me in this issue i need SQL to get badeget balance Acutal Balance Encumbrance Balance fund Avalable thanx ahmed
What is Reporting of financial data in a project.
Anyone provide the oracle fin/scm definetions
What is the use of hr: user type, while configure multiorg?
How do u bridge the gaps in functional understanding of AP,GL,FA. explain with some live examples.
Re: what are the Issue that we face in Gl,PO and AP while Supporting
What is the use of gl set of books name, while configure multiorg?
We have both consumption tax and With Holding Tax on each invoice, will there be any conflict involved?
Give examples & explain the below mentioned activity. "Analyzing the documents provided by the client and thereby identifying the test cases to be tested for the application assigned (FA, AP and GL)"
What is the meaning holding tax?
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.
encumbrence set ups?
