APPS.OE_SHIPPING_INTEGRATION_PVT dependencies on OE_ORDER_LINES_ALL

Line 2884: UPDATE OE_ORDER_LINES_ALL

2880: IF nvl(l_line_tbl(l_top_model_index).ship_tolerance_below,0) <> 0 OR
2881: nvl(l_line_tbl(l_top_model_index).ship_tolerance_above,0) <> 0 THEN
2882:
2883:
2884: UPDATE OE_ORDER_LINES_ALL
2885: SET SHIP_TOLERANCE_BELOW = 0,
2886: SHIP_TOLERANCE_ABOVE = 0
2887: WHERE TOP_MODEL_LINE_ID = l_line_tbl(l_top_model_index).line_id;
2888:

Line 4856: FROM OE_ORDER_LINES_ALL

4852: l_item_type_code,
4853: l_header_id,
4854: l_model_remnant_flag,
4855: l_ship_from_org_id
4856: FROM OE_ORDER_LINES_ALL
4857: WHERE LINE_ID = p_line_id;
4858:
4859: END IF; -- bulk mode switch
4860:

Line 5705: FROM oe_order_lines_all oe

5701:
5702: CURSOR split_lines IS
5703: SELECT /* MOAC_SQL_CHANGE */ line_id, line_set_id, ordered_quantity, ordered_quantity2,
5704: order_quantity_uom, ordered_quantity_uom2, inventory_item_id
5705: FROM oe_order_lines_all oe
5706: WHERE line_id in
5707: (SELECT line_id
5708: FROM oe_order_lines_all
5709: WHERE line_set_id = p_line_rec.line_set_id

Line 5708: FROM oe_order_lines_all

5704: order_quantity_uom, ordered_quantity_uom2, inventory_item_id
5705: FROM oe_order_lines_all oe
5706: WHERE line_id in
5707: (SELECT line_id
5708: FROM oe_order_lines_all
5709: WHERE line_set_id = p_line_rec.line_set_id
5710: AND line_id <> p_line_rec.line_id)
5711: AND open_flag = 'Y'
5712: AND shipped_quantity is NULL