APPS.CSP_EXCESS_PARTS_PVT dependencies on OE_ORDER_LINES_ALL

Line 1681: from oe_order_lines_all ool

1677: select SUM(INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY(SHIP_FROM_ORG_ID,
1678: INVENTORY_ITEM_ID, ORDER_QUANTITY_UOM, Nvl(ordered_quantity,0)) -
1679: get_shipped_qty(p_organization_id,p_inventory_item_id, ool.line_id))
1680: into l_total_demand_qty
1681: from oe_order_lines_all ool
1682: where ship_from_org_id = p_organization_id
1683: and open_flag = 'Y'
1684: and INVENTORY_ITEM_ID = p_inventory_item_id
1685: and schedule_ship_date <= sysdate + p_demand_cutoff

Line 1758: from oe_order_lines_all so,

1754: select SUM(INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY(SHIP_FROM_ORG_ID,
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

Line 1790: from mtl_reservations md, oe_order_lines_all so,

1786: (nvl(p_net_reserved,0) <> 1 and nvl(p_net_unreserved,0) <> 1)) then
1787: -- Include the reserved demand from mtl_reservations
1788: select sum(PRIMARY_RESERVATION_QUANTITY)
1789: into l_total_reserve_qty
1790: from mtl_reservations md, oe_order_lines_all so,
1791: po_req_distributions_all pod,
1792: po_requisition_lines_all pol
1793: where md.DEMAND_SOURCE_LINE_ID = so.LINE_ID
1794: and so.ORIG_SYS_LINE_REF = pod.DISTRIBUTION_ID