APPS.CSP_EXCESS_PARTS_PVT dependencies on OE_ORDER_LINES_ALL

Line 1560: from oe_order_lines_all ool

1556: select SUM(INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY(SHIP_FROM_ORG_ID,
1557: INVENTORY_ITEM_ID, ORDER_QUANTITY_UOM, Nvl(ordered_quantity,0)) -
1558: get_shipped_qty(p_organization_id,p_inventory_item_id, ool.line_id))
1559: into l_total_demand_qty
1560: from oe_order_lines_all ool
1561: where ship_from_org_id = p_organization_id
1562: and open_flag = 'Y'
1563: and INVENTORY_ITEM_ID = p_inventory_item_id
1564: and schedule_ship_date <= sysdate + p_demand_cutoff

Line 1637: from oe_order_lines_all so,

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

Line 1669: from mtl_reservations md, oe_order_lines_all so,

1665: (nvl(p_net_reserved,0) <> 1 and nvl(p_net_unreserved,0) <> 1)) then
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