My Portfolio

AP Table Relation Oracle Apps ORACLE PAYABLE TABLE RELATION Source Table Dependent Table Condition AP_INVOICE_LINES_ALL AIL ZX_LINES_SUMMARY ZLS AIL.invoice_id = ZLS.trx_id and  ZLS.application_id  = 200 and  ZLS.entity_code  = 'AP_INVOICES' and  ZLS.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and  AIL.summary_tax_line_id = ZLS.summary_tax_line_id AP_INVOICE_LINES_ALL AIL ZX_LINES ZL AIL.invoice_id = ZL.trx_id and  ZL.application_id  = 200 and  ZL.entity_code  = 'AP_INVOICES' and  ZL.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and  AIL.line_number = ZL.trx_line_number AP_INVOICE_DISTRIBUTIONS_ALL AID ZX_REC_NREC_DIST ZD AID.invoice_id = ZD.trx_id and  ZD.application_id  = 200 and  ZD.entity_code  = 'AP_INVOICES' and  ZD.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and...

When you say Link I'm presuming you mean BACKTRACK or REFER TO=20  In Metalink look for:=20  NOTE 130542.1  Note 1011799.6 - 'How Does Oracle Payables Populate References Columns  In GL_IMPORT_REFERENCES' helps at all.=20  The reference fields are used in different ways by each subledger.  Following is the use that Oracle Accounts Payable gives to these fields:  USER_JE_CATEGORY_NAME: Payments  USER_JE_SOURCE_NAME: Payables  Reference21 Supplier name  Reference22 Internal Invoice identification  Reference23 Internal Check identification  Reference24 External check number  Reference25 Paid invoice number  Reference26 'AP Invoices'  Reference27 Payment number  Reference29 Paid invoice identification  Reference30 'CASH' or 'DISCOUNT' or 'LIABILITY'  - 19 -  USER_JE_CATEGORY_NAME: Purchase Invoices  USER_JE_SOURCE_NAME: Payables  Reference21 Supplier Name  Reference22 Internal invoi...

Draft Revenue -- draft revenue against project headers   SELECT   ppa.segment1       , ppa. name       , pdra.draft_revenue_num rev_num       , pdra.creation_date       , pdra.transfer_status_code       , pdra.transferred_date       , pdra.transfer_rejection_reason       , pdra.*    FROM   pa.pa_draft_revenues_all pdra       , pa.pa_projects_all ppa   WHERE   pdra.project_id = ppa.project_id        AND   pdra.creation_date >=  '26-FEB-2013' ;   -- draft revenue against tasks   SELECT   ppa.segment1       , ppa. name       , pdri.creation_date       , pdri.amount       , pdri.draft_revenue_num rev_num ...