DBA Data[Home] [Help]

APPS.CSP_EXCESS_PARTS_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 1638: po_requisition_headers_all poh,

1634: INVENTORY_ITEM_ID, ORDER_QUANTITY_UOM, Nvl(ordered_quantity,0)) -
1635: get_shipped_qty(p_organization_id,p_inventory_item_id, so.line_id))
1636: into l_total_demand_qty
1637: from oe_order_lines_all so,
1638: po_requisition_headers_all poh,
1639: po_requisition_lines_all pol
1640: where so.ORIG_SYS_DOCUMENT_REF = poh.segment1
1641: and poh.requisition_header_id = pol .requisition_header_id
1642: and so.orig_sys_line_ref = pol.line_num