DBA Data[Home] [Help]

APPS.PSA_BC_XML_REPORT_PUB dependencies on PO_DISTRIBUTIONS

Line 1380: PO_DISTRIBUTIONS PD,

1376: PO_VENDORS PV,
1377: PO_VENDOR_SITES PVS,
1378: PO_HEADERS PH,
1379: PO_LINES PL,
1380: PO_DISTRIBUTIONS PD,
1381: PO_LINE_LOCATIONS PLL,
1382: PSA_BC_REPORT_EVENTS_GT PBRE
1383: WHERE PBRV.ledger_id = p_para_rec.ledger_id AND
1384: PBRV.source_distribution_id_num_1 = PBD.distribution_id AND

Line 1705: PO_DISTRIBUTIONS PD,

1701: PO_VENDOR_SITES PVS,
1702: PO_HEADERS PH,
1703: PO_RELEASES PR,
1704: PO_LINES PL,
1705: PO_DISTRIBUTIONS PD,
1706: PO_LINE_LOCATIONS PLL,
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

Line 1712: 'PO_DISTRIBUTIONS_ALL') = xdl.source_distribution_type AND

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
1716: PBRV.application_id = XDL.application_id AND