APPS.PSA_BC_XML_REPORT_PUB dependencies on XLA_DISTRIBUTION_LINKS

Line 319: xla_distribution_links xdl

315: sum(decode(event_class_code, 'REQUISITION', 1, 0)) REQ,
316: sum(decode(event_class_code, 'RELEASE', 1, 0)) RELEASE
317: FROM ( SELECT distinct xdl.event_class_code
318: FROM psa_bc_report_events_gt psagt,
319: xla_distribution_links xdl
320: WHERE xdl.application_id = p_para_rec.application_id AND
321: xdl.event_id = psagt.event_id
322: );
323:

Line 943: XLA_DISTRIBUTION_LINKS XDL,

939: BULK COLLECT INTO l_dump
940: FROM PSA_BC_REPORT_V PBRV,
941: AP_INVOICE_DISTRIBUTIONS AID,
942: AP_BATCHES APB,
943: XLA_DISTRIBUTION_LINKS XDL,
944: AP_INVOICES AI,
945: AP_INVOICE_LINES AIL,
946: PO_VENDORS PV,
947: PO_VENDOR_SITES PVS

Line 1106: XLA_DISTRIBUTION_LINKS XDL,

1102: FROM PSA_BC_REPORT_V PBRV,
1103: AP_INVOICE_DISTRIBUTIONS AID,
1104: AP_PREPAY_APP_DISTS APD,
1105: AP_BATCHES APB,
1106: XLA_DISTRIBUTION_LINKS XDL,
1107: AP_INVOICES AI,
1108: AP_INVOICE_LINES AIL,
1109: PO_VENDORS PV,
1110: PO_VENDOR_SITES PVS

Line 1278: XLA_DISTRIBUTION_LINKS XDL,

1274: NULL DOCUMENT_STATUS
1275: BULK COLLECT INTO l_dump
1276: FROM PSA_BC_REPORT_V PBRV,
1277: PO_BC_DISTRIBUTIONS PBD,
1278: XLA_DISTRIBUTION_LINKS XDL,
1279: PO_VENDORS PV,
1280: PO_VENDOR_SITES PVS,
1281: PO_HEADERS PH,
1282: PO_LINES PL,

Line 1441: XLA_DISTRIBUTION_LINKS XDL,

1437: NULL DOCUMENT_STATUS
1438: BULK COLLECT INTO l_dump
1439: FROM PSA_BC_REPORT_V PBRV,
1440: PO_BC_DISTRIBUTIONS PBD,
1441: XLA_DISTRIBUTION_LINKS XDL,
1442: PO_VENDORS PV,
1443: PO_VENDOR_SITES PVS,
1444: PO_REQUISITION_HEADERS PRH,
1445: PO_REQUISITION_LINES PRL,

Line 1609: XLA_DISTRIBUTION_LINKS XDL,

1605: NULL DOCUMENT_STATUS
1606: BULK COLLECT INTO l_dump
1607: FROM PSA_BC_REPORT_V PBRV,
1608: PO_BC_DISTRIBUTIONS PBD,
1609: XLA_DISTRIBUTION_LINKS XDL,
1610: PO_VENDORS PV,
1611: PO_VENDOR_SITES PVS,
1612: PO_HEADERS PH,
1613: PO_RELEASES PR,

Line 1907: XLA_DISTRIBUTION_LINKS XLADIST,

1903: PBRV.CURRENT_FUNDS_AVAILABLE,
1904: NULL DOCUMENT_STATUS
1905: BULK COLLECT INTO l_dump
1906: FROM PSA_BC_REPORT_V PBRV,
1907: XLA_DISTRIBUTION_LINKS XLADIST,
1908: FV_BE_TRX_HDRS BE,
1909: FV_BE_TRX_DTLS BET,
1910: FV_BE_RPR_TRANSACTIONS RPR
1911: WHERE PBRV.ledger_id = p_para_rec.ledger_id AND

Line 2480: XLA_DISTRIBUTION_LINKS XDL

2476: NULL DOCUMENT_STATUS
2477: BULK COLLECT INTO l_dump
2478: FROM PSA_BC_REPORT_V PBRV,
2479: XLA_AE_HEADERS XAH,
2480: XLA_DISTRIBUTION_LINKS XDL
2481: WHERE PBRV.application_id = XDL.application_id AND
2482: PBRV.event_id = XDL.event_id AND
2483: PBRV.ae_header_id = XDL.ae_header_id AND
2484: PBRV.ae_line_num = XDL.ae_line_num AND