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 do you mean by Category Set ? and what is its Relevance ?

2056


Explain Customization process?

1589


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.

1245


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

775


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

2092






Write Test Scripts for a telecummunication project on the basis of priority with some examples with regard to AP,GL,FA.

1850


What are the types of setups in apps inventory module

1979


what is the difference between bonus reserve and bonus expense

4116


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

839


Re: what are the Issue that we face in Gl,PO and AP while Supporting

1921


what is VAT claim process?

2200


We have both consumption tax and With Holding Tax on each invoice, will there be any conflict involved?

1626


difference between tds and income tax (India)

1464


When we run a GL Reconciliation Report, we also see the void payments in that report. Even though i disable the option of Show Void payments, its appearing in the report.How do i proceed so that i dont see those void payments in the GL Reconciliation Report?

2554


How to support projects life cycles details?

754