APPS.PSA_BC_XML_REPORT_PUB dependencies on XLA_DISTRIBUTION_LINKS

Line 334: xla_distribution_links xdl

330: sum(decode(event_class_code, 'REQUISITION', 1, 0)) REQ,
331: sum(decode(event_class_code, 'RELEASE', 1, 0)) RELEASE
332: FROM ( SELECT distinct xdl.event_class_code
333: FROM psa_bc_report_events_gt psagt,
334: xla_distribution_links xdl
335: WHERE xdl.application_id = p_para_rec.application_id AND
336: xdl.event_id = psagt.event_id
337: );
338:

Line 1048: XLA_DISTRIBUTION_LINKS XDL,

1044: BULK COLLECT INTO l_dump
1045: FROM PSA_BC_REPORT_V PBRV,
1046: AP_INVOICE_DISTRIBUTIONS AID,
1047: AP_BATCHES APB,
1048: XLA_DISTRIBUTION_LINKS XDL,
1049: AP_INVOICES AI,
1050: AP_INVOICE_LINES AIL,
1051: PO_VENDORS PV,
1052: PO_VENDOR_SITES PVS,

Line 1207: XLA_DISTRIBUTION_LINKS XDL,

1203: FROM PSA_BC_REPORT_V PBRV,
1204: AP_INVOICE_DISTRIBUTIONS AID,
1205: AP_PREPAY_APP_DISTS APD,
1206: AP_BATCHES APB,
1207: XLA_DISTRIBUTION_LINKS XDL,
1208: AP_INVOICES AI,
1209: AP_INVOICE_LINES AIL,
1210: PO_VENDORS PV,
1211: PO_VENDOR_SITES PVS,

Line 1375: XLA_DISTRIBUTION_LINKS XDL,

1371: NULL DOCUMENT_STATUS
1372: BULK COLLECT INTO l_dump
1373: FROM PSA_BC_REPORT_V PBRV,
1374: PO_BC_DISTRIBUTIONS PBD,
1375: XLA_DISTRIBUTION_LINKS XDL,
1376: PO_VENDORS PV,
1377: PO_VENDOR_SITES PVS,
1378: PO_HEADERS PH,
1379: PO_LINES PL,

Line 1535: XLA_DISTRIBUTION_LINKS XDL,

1531: NULL DOCUMENT_STATUS
1532: BULK COLLECT INTO l_dump
1533: FROM PSA_BC_REPORT_V PBRV,
1534: PO_BC_DISTRIBUTIONS PBD,
1535: XLA_DISTRIBUTION_LINKS XDL,
1536: PO_VENDORS PV,
1537: PO_VENDOR_SITES PVS,
1538: PO_REQUISITION_HEADERS PRH,
1539: PO_REQUISITION_LINES PRL,

Line 1699: XLA_DISTRIBUTION_LINKS XDL,

1695: NULL DOCUMENT_STATUS
1696: BULK COLLECT INTO l_dump
1697: FROM PSA_BC_REPORT_V PBRV,
1698: PO_BC_DISTRIBUTIONS PBD,
1699: XLA_DISTRIBUTION_LINKS XDL,
1700: PO_VENDORS PV,
1701: PO_VENDOR_SITES PVS,
1702: PO_HEADERS PH,
1703: PO_RELEASES PR,

Line 1992: XLA_DISTRIBUTION_LINKS XLADIST,

1988: PBRV.CURRENT_FUNDS_AVAILABLE,
1989: NULL DOCUMENT_STATUS
1990: BULK COLLECT INTO l_dump
1991: FROM PSA_BC_REPORT_V PBRV,
1992: XLA_DISTRIBUTION_LINKS XLADIST,
1993: FV_BE_TRX_HDRS BE,
1994: FV_BE_TRX_DTLS BET,
1995: FV_BE_RPR_TRANSACTIONS RPR,
1996: PSA_BC_REPORT_EVENTS_GT PBRE

Line 2556: XLA_DISTRIBUTION_LINKS XDL,

2552: NULL DOCUMENT_STATUS
2553: BULK COLLECT INTO l_dump
2554: FROM PSA_BC_REPORT_V PBRV,
2555: XLA_AE_HEADERS XAH,
2556: XLA_DISTRIBUTION_LINKS XDL,
2557: PSA_BC_REPORT_EVENTS_GT PBRE
2558: WHERE PBRV.application_id = XDL.application_id AND
2559: PBRV.event_id = XDL.event_id AND
2560: PBRV.ae_header_id = XDL.ae_header_id AND