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 390: AP_INVOICE_DISTRIBUTIONS_ALL AID,

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

Line 427: AP_INVOICE_DISTRIBUTIONS_ALL AIDA

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

Line 551: AP_INVOICE_DISTRIBUTIONS_ALL AID,

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

Line 592: AP_INVOICE_DISTRIBUTIONS_ALL AIDA

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

Line 716: AP_INVOICE_DISTRIBUTIONS_ALL AID,

712: P_LEGAL_ENTITY,
713: P_PERIOD
714: FROM
715: AP_INVOICES_ALL API,
716: AP_INVOICE_DISTRIBUTIONS_ALL AID,
717: PO_VENDORS POV,
718: RCV_TRANSACTIONS RT,
719: RCV_SHIPMENT_HEADERS RSH,
720: PO_LINES_ALL POL,

Line 881: AP_INVOICE_DISTRIBUTIONS_ALL AID,

877: P_LEGAL_ENTITY,
878: P_PERIOD
879: FROM
880: AP_INVOICES_ALL API,
881: AP_INVOICE_DISTRIBUTIONS_ALL AID,
882: XLA_AE_HEADERS XAH,
883: XLA_AE_LINES XAL,
884: XLA_DISTRIBUTION_LINKS XDL,
885: PO_VENDORS POV,