APPS.INV_RESERVATION_AVAIL_PVT dependencies on OE_ORDER_LINES_ALL

Line 838: FROM oe_order_lines_all

834: AND lot_number is not null;
835:
836: CURSOR get_order_line_uom IS
837: SELECT order_quantity_uom
838: FROM oe_order_lines_all
839: WHERE line_id = p_demand_source_line_id;
840:
841: --Bug 12978409: end
842: BEGIN

Line 1502: FROM oe_order_lines_all

1498: SELECT ordered_quantity , order_quantity_uom
1499: ,ordered_quantity2 , ordered_quantity_uom2
1500: INTO l_available_quantity, l_order_quantity_uom_code
1501: ,l_available_quantity2, l_order_quantity_uom2
1502: FROM oe_order_lines_all
1503: WHERE line_id = p_demand_source_line_id; --Bug14629017
1504: --AND nvl(project_id, -99) = nvl(p_project_id, -99)
1505: --AND nvl(task_id, -99) = nvl(p_task_id, -99);
1506: EXCEPTION

Line 1528: FROM oe_order_lines_all

1524: END IF;
1525: IF ( NVL(INV_CACHE.org_rec.wms_enabled_flag,'N') = 'Y' ) THEN
1526: BEGIN
1527: SELECT nvl((ordered_quantity * ship_tolerance_above/100),0) INTO l_over_shippable_qty
1528: FROM oe_order_lines_all
1529: WHERE line_id = p_demand_source_line_id
1530: AND nvl(project_id, -99) = nvl(p_project_id, -99)
1531: AND nvl(task_id, -99) = nvl(p_task_id, -99)
1532: AND NOT EXISTS (SELECT 1 FROM MTL_RESERVATIONS MR