DBA Data[Home] [Help]

APPS.CSP_EXCESS_PARTS_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 1759: po_requisition_headers_all poh,

1755: INVENTORY_ITEM_ID, ORDER_QUANTITY_UOM, Nvl(ordered_quantity,0)) -
1756: get_shipped_qty(p_organization_id,p_inventory_item_id, so.line_id))
1757: into l_total_demand_qty
1758: from oe_order_lines_all so,
1759: po_requisition_headers_all poh,
1760: po_requisition_lines_all pol
1761: where so.ORIG_SYS_DOCUMENT_REF = poh.segment1
1762: and poh.requisition_header_id = pol .requisition_header_id
1763: and so.orig_sys_line_ref = pol.line_num