237: PO_LINE_LOCATIONS_ALL POLL,
238: PO_LINES_ALL POL,
239: PO_HEADERS_ALL POH,
240: XLA_AE_HEADERS XAH,
241: XLA_AE_LINES XAL,
242: XLA_DISTRIBUTION_LINKS XDL,
243: CST_PAC_ACCRUAL_ACCOUNTS_TEMP CAA
244: WHERE CAA.ACCRUAL_ACCOUNT_ID = XAL.CODE_COMBINATION_ID
245: AND XAH.APPLICATION_ID = 200
393: PO_LINE_LOCATIONS_ALL POLL,
394: PO_LINES_ALL POL,
395: PO_HEADERS_ALL POH,
396: XLA_AE_HEADERS XAH,
397: XLA_AE_LINES XAL,
398: XLA_DISTRIBUTION_LINKS XDL,
399: CST_PAC_ACCRUAL_ACCOUNTS_TEMP CAA
400: WHERE CAA.ACCRUAL_ACCOUNT_ID = XAL.CODE_COMBINATION_ID
401: AND XAH.APPLICATION_ID = 200
554: PO_LINE_LOCATIONS_ALL POLL,
555: PO_LINES_ALL POL,
556: PO_HEADERS_ALL POH,
557: XLA_AE_HEADERS XAH,
558: XLA_AE_LINES XAL,
559: XLA_DISTRIBUTION_LINKS XDL,
560: CST_PAC_ACCRUAL_ACCOUNTS_TEMP CAA
561: WHERE CAA.ACCRUAL_ACCOUNT_ID = XAL.CODE_COMBINATION_ID
562: AND XAH.APPLICATION_ID = 200
720: PO_LINES_ALL POL,
721: PO_LINE_LOCATIONS_ALL POLL,
722: PO_HEADERS_ALL POH,
723: XLA_AE_HEADERS XAH,
724: XLA_AE_LINES XAL,
725: XLA_DISTRIBUTION_LINKS XDL,
726: CST_PAC_ACCRUAL_ACCOUNTS_TEMP CAA
727: WHERE CAA.ACCRUAL_ACCOUNT_ID = XAL.CODE_COMBINATION_ID
728: AND XAH.APPLICATION_ID = 200
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,
886: CST_PAC_ACCRUAL_ACCOUNTS_TEMP CAA
887: WHERE CAA.ACCRUAL_ACCOUNT_ID = XAL.CODE_COMBINATION_ID