DBA Data[Home] [Help]

APPS.CSP_EXCESS_PARTS_PVT dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 1670: po_req_distributions_all pod,

1666: -- Include the reserved demand from mtl_reservations
1667: select sum(PRIMARY_RESERVATION_QUANTITY)
1668: into l_total_reserve_qty
1669: from mtl_reservations md, oe_order_lines_all so,
1670: po_req_distributions_all pod,
1671: po_requisition_lines_all pol
1672: where md.DEMAND_SOURCE_LINE_ID = so.LINE_ID
1673: and so.ORIG_SYS_LINE_REF = pod.DISTRIBUTION_ID
1674: and pod.REQUISITION_LINE_ID = pol.REQUISITION_LINE_ID