APPS.PSA_BC_XML_REPORT_PUB dependencies on PO_REQ_DISTRIBUTIONS

Line 1540: PO_REQ_DISTRIBUTIONS PRD,

1536: PO_VENDORS PV,
1537: PO_VENDOR_SITES PVS,
1538: PO_REQUISITION_HEADERS PRH,
1539: PO_REQUISITION_LINES PRL,
1540: PO_REQ_DISTRIBUTIONS PRD,
1541: PSA_BC_REPORT_EVENTS_GT PBRE
1542: WHERE PBRV.ledger_id = p_para_rec.ledger_id AND
1543: PBRV.source_distribution_id_num_1 = PBD.distribution_id AND
1544: PBRV.event_id = PBD.ae_event_id AND

Line 1711: 'REQUISITION', 'PO_REQ_DISTRIBUTIONS_ALL',

1707: PSA_BC_REPORT_EVENTS_GT PBRE
1708: WHERE PBRV.ledger_id = p_para_rec.ledger_id AND
1709: PBRV.source_distribution_id_num_1 = PBD.distribution_id AND
1710: decode(pbd.distribution_type,
1711: 'REQUISITION', 'PO_REQ_DISTRIBUTIONS_ALL',
1712: 'PO_DISTRIBUTIONS_ALL') = xdl.source_distribution_type AND
1713: pbd.ae_event_id = xdl.event_id AND
1714: NVL(PBD.applied_to_dist_id_2, pbd.distribution_id) = XDL.ALLOC_TO_DIST_ID_NUM_1 AND
1715: PBRV.event_id = PBD.ae_event_id AND