DBA Data[Home] [Help]

APPS.PSA_BC_XML_REPORT_PUB dependencies on PO_REQ_DISTRIBUTIONS

Line 1446: PO_REQ_DISTRIBUTIONS PRD

1442: PO_VENDORS PV,
1443: PO_VENDOR_SITES PVS,
1444: PO_REQUISITION_HEADERS PRH,
1445: PO_REQUISITION_LINES PRL,
1446: PO_REQ_DISTRIBUTIONS PRD
1447: WHERE PBRV.ledger_id = p_para_rec.ledger_id AND
1448: PBRV.source_distribution_id_num_1 = PBD.distribution_id AND
1449: PBRV.event_id = PBD.ae_event_id AND
1450: PBRV.application_id = XDL.application_id AND

Line 1620: 'REQUISITION', 'PO_REQ_DISTRIBUTIONS_ALL',

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,
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