DBA Data[Home] [Help]

APPS.INV_RESERVATION_AVAIL_PVT dependencies on OE_ORDER_LINES_ALL

Line 1033: FROM oe_order_lines_all

1029: --Bug#7481265.Added overship tolerance in below sql .
1030: BEGIN
1031: SELECT ordered_quantity + (ordered_quantity * ship_tolerance_above/100), order_quantity_uom
1032: INTO l_available_quantity, l_order_quantity_uom_code
1033: FROM oe_order_lines_all
1034: WHERE line_id = p_demand_source_line_id
1035: AND nvl(project_id, -99) = nvl(p_project_id, -99)
1036: AND nvl(task_id, -99) = nvl(p_task_id, -99);
1037: EXCEPTION