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
- 13493 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
How to support projects life cycles details?
Explain Customer Creation and Maintenance Process. Provide samples of customer master records with Payment Terms.
difference between tds and income tax (India)
What is the use of gl set of books name, while configure multiorg?
What is the procedure for requition import?
What are register in India localisation?
How to Reconciliation AP to CM ? How to Reconciliation AR to CM ?
Charge Back Setups ?
difference between 11i&r12
What is Work Flow of AP,AR, Sales & Purchase
Define the activities of the Configuration Manager (AP,GL,FA) in the team. Give examples
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.
How do write a discoverer report to identify zero dollar suppliers/invoices where the supplier is on hold?
How do you adjust receivables?
I have created an invoice and made the payment in Accounts payable. Now the payment status is Negotiable and accounting status is processed. I reconciled the transaction in Cash Mgmt, The status changed from negotiable to Reconciled in CM. I checked the payment status for the invoice in payment window(AP), the payment status changed to RECONCILED UNACCOUNTED i.e correct but the accounting status is remain processed which is not the correct. I hope the transaction will be correct if the accounting status would have changed to PERTIAL . Please suggest any solution for the above query.
