APPS.BOM_CSTRACCR_XMLP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 234: AP_INVOICE_DISTRIBUTIONS_ALL AID,

230: P_LEGAL_ENTITY,
231: P_PERIOD
232: FROM
233: AP_INVOICES_ALL API,
234: AP_INVOICE_DISTRIBUTIONS_ALL AID,
235: PO_VENDORS POV,
236: PO_DISTRIBUTIONS_ALL POD,
237: PO_LINE_LOCATIONS_ALL POLL,
238: PO_LINES_ALL POL,

Line 389: AP_INVOICE_DISTRIBUTIONS_ALL AID,

385: P_LEGAL_ENTITY,
386: P_PERIOD
387: FROM
388: AP_INVOICES_ALL API,
389: AP_INVOICE_DISTRIBUTIONS_ALL AID,
390: PO_VENDORS POV,
391: PO_DISTRIBUTIONS_ALL POD,
392: PO_LINE_LOCATIONS_ALL POLL,
393: PO_LINES_ALL POL,

Line 425: AP_INVOICE_DISTRIBUTIONS_ALL AIDA

421: AND EXISTS (
422: SELECT
423: 'X'
424: FROM
425: AP_INVOICE_DISTRIBUTIONS_ALL AIDA
426: WHERE AIDA.RELATED_ID = AID.INVOICE_DISTRIBUTION_ID
427: AND AIDA.LINE_TYPE_LOOKUP_CODE = 'IPV'
428: AND ( ( AIDA.BASE_AMOUNT IS NOT NULL
429: OR AIDA.BASE_AMOUNT <> 0 )

Line 549: AP_INVOICE_DISTRIBUTIONS_ALL AID,

545: P_LEGAL_ENTITY,
546: P_PERIOD
547: FROM
548: AP_INVOICES_ALL API,
549: AP_INVOICE_DISTRIBUTIONS_ALL AID,
550: PO_VENDORS POV,
551: PO_DISTRIBUTIONS_ALL POD,
552: PO_LINE_LOCATIONS_ALL POLL,
553: PO_LINES_ALL POL,

Line 589: AP_INVOICE_DISTRIBUTIONS_ALL AIDA

585: AND EXISTS (
586: SELECT
587: 'X'
588: FROM
589: AP_INVOICE_DISTRIBUTIONS_ALL AIDA
590: WHERE AIDA.RELATED_ID = AID.INVOICE_DISTRIBUTION_ID
591: AND AIDA.LINE_TYPE_LOOKUP_CODE = 'ERV'
592: AND ( AIDA.AMOUNT IS NOT NULL
593: OR AIDA.AMOUNT <> 0 ) )

Line 713: AP_INVOICE_DISTRIBUTIONS_ALL AID,

709: P_LEGAL_ENTITY,
710: P_PERIOD
711: FROM
712: AP_INVOICES_ALL API,
713: AP_INVOICE_DISTRIBUTIONS_ALL AID,
714: PO_VENDORS POV,
715: RCV_TRANSACTIONS RT,
716: RCV_SHIPMENT_HEADERS RSH,
717: PO_LINES_ALL POL,

Line 877: AP_INVOICE_DISTRIBUTIONS_ALL AID,

873: P_LEGAL_ENTITY,
874: P_PERIOD
875: FROM
876: AP_INVOICES_ALL API,
877: AP_INVOICE_DISTRIBUTIONS_ALL AID,
878: XLA_AE_HEADERS XAH,
879: XLA_AE_LINES XAL,
880: XLA_DISTRIBUTION_LINKS XDL,
881: PO_VENDORS POV,