DBA Data[Home] [Help]

APPS.PSA_BC_XML_REPORT_PUB dependencies on PO_DISTRIBUTIONS

Line 1283: PO_DISTRIBUTIONS PD,

1279: PO_VENDORS PV,
1280: PO_VENDOR_SITES PVS,
1281: PO_HEADERS PH,
1282: PO_LINES PL,
1283: PO_DISTRIBUTIONS PD,
1284: PO_LINE_LOCATIONS PLL
1285: WHERE PBRV.ledger_id = p_para_rec.ledger_id AND
1286: PBRV.source_distribution_id_num_1 = PBD.distribution_id AND
1287: PBRV.event_id = PBD.ae_event_id AND

Line 1615: PO_DISTRIBUTIONS PD,

1611: PO_VENDOR_SITES PVS,
1612: PO_HEADERS PH,
1613: PO_RELEASES PR,
1614: PO_LINES PL,
1615: PO_DISTRIBUTIONS PD,
1616: PO_LINE_LOCATIONS PLL
1617: WHERE PBRV.ledger_id = p_para_rec.ledger_id AND
1618: PBRV.source_distribution_id_num_1 = PBD.distribution_id AND
1619: decode(pbd.distribution_type,

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

1617: WHERE PBRV.ledger_id = p_para_rec.ledger_id AND
1618: PBRV.source_distribution_id_num_1 = PBD.distribution_id AND
1619: decode(pbd.distribution_type,
1620: 'REQUISITION', 'PO_REQ_DISTRIBUTIONS_ALL',
1621: 'PO_DISTRIBUTIONS_ALL') = xdl.source_distribution_type AND
1622: pbd.ae_event_id = xdl.event_id AND
1623: NVL(PBD.applied_to_dist_id_2, pbd.distribution_id) = XDL.ALLOC_TO_DIST_ID_NUM_1 AND
1624: PBRV.event_id = PBD.ae_event_id AND
1625: PBRV.application_id = XDL.application_id AND