DBA Data[Home] [Help]

APPS.PA_FAXFACE dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 199: ap_invoice_distributions_all apid,

195: mtlsi.asset_category_id
196: INTO
197: asset_category_id
198: FROM
199: ap_invoice_distributions_all apid,
200: po_distributions pod,
201: po_lines pol,
202: financials_system_parameters fsp,
203: mtl_system_items mtlsi

Line 676: from ap_invoice_distributions_all

672: BEGIN
673:
674: select DISTRIBUTION_LINE_NUMBER, INVOICE_LINE_NUMBER
675: into l_ap_distribution_line_number, l_invoice_line_number
676: from ap_invoice_distributions_all
677: where INVOICE_ID = x_invoice_id
678: and INVOICE_DISTRIBUTION_ID = x_invoice_distribution_id;
679:
680: EXCEPTION

Line 1556: ap_invoice_distributions_all APID,

1552: x_invoice_created_by,
1553: x_invoice_updated_by,
1554: x_payables_batch_name
1555: FROM ap_invoices_all API ,
1556: ap_invoice_distributions_all APID,
1557: ap_batches_all APB ,
1558: po_vendors POV ,
1559: po_headers_all POH ,
1560: po_distributions_all POD

Line 2297: FROM ap_invoice_distributions_all apd

2293: else
2294:
2295: SELECT NVL(apd.po_distribution_id,-99)
2296: INTO curr_inv_pod
2297: FROM ap_invoice_distributions_all apd
2298: WHERE apd.invoice_distribution_id = cdlrec.document_distribution_id;
2299:
2300: end if;
2301:

Line 3306: from ap_invoice_distributions_all

3302: BEGIN
3303:
3304: select DISTRIBUTION_LINE_NUMBER, INVOICE_LINE_NUMBER
3305: into l_ap_distribution_line_number, l_invoice_line_number
3306: from ap_invoice_distributions_all
3307: where INVOICE_ID = x_invoice_id
3308: and INVOICE_DISTRIBUTION_ID = x_invoice_distribution_id;
3309:
3310: EXCEPTION