APPS.OE_SHIPPING_INTEGRATION_PVT dependencies on OE_ORDER_LINES_ALL

Line 2896: UPDATE OE_ORDER_LINES_ALL

2892: IF nvl(l_line_tbl(l_top_model_index).ship_tolerance_below,0) <> 0 OR
2893: nvl(l_line_tbl(l_top_model_index).ship_tolerance_above,0) <> 0 THEN
2894:
2895:
2896: UPDATE OE_ORDER_LINES_ALL
2897: SET SHIP_TOLERANCE_BELOW = 0,
2898: SHIP_TOLERANCE_ABOVE = 0
2899: WHERE TOP_MODEL_LINE_ID = l_line_tbl(l_top_model_index).line_id;
2900:

Line 4874: FROM OE_ORDER_LINES_ALL

4870: l_item_type_code,
4871: l_header_id,
4872: l_model_remnant_flag,
4873: l_ship_from_org_id
4874: FROM OE_ORDER_LINES_ALL
4875: WHERE LINE_ID = p_line_id;
4876:
4877: END IF; -- bulk mode switch
4878:

Line 5730: FROM oe_order_lines_all oe

5726:
5727: CURSOR split_lines IS
5728: SELECT /* MOAC_SQL_CHANGE */ line_id, line_set_id, ordered_quantity, ordered_quantity2,
5729: order_quantity_uom, ordered_quantity_uom2, inventory_item_id
5730: FROM oe_order_lines_all oe
5731: WHERE line_id in
5732: (SELECT line_id
5733: FROM oe_order_lines_all
5734: WHERE line_set_id = p_line_rec.line_set_id

Line 5733: FROM oe_order_lines_all

5729: order_quantity_uom, ordered_quantity_uom2, inventory_item_id
5730: FROM oe_order_lines_all oe
5731: WHERE line_id in
5732: (SELECT line_id
5733: FROM oe_order_lines_all
5734: WHERE line_set_id = p_line_rec.line_set_id
5735: AND line_id <> p_line_rec.line_id)
5736: AND open_flag = 'Y'
5737: AND shipped_quantity is NULL