APPS.OE_ORDER_SCH_UTIL dependencies on OE_ORDER_LINES_ALL

Line 6206: Update oe_order_lines_all

6202: l_old_line_rec.demand_class_code;
6203:
6204: /*L.G. OPM bug 1828340 jul 19,01*/
6205: IF ( INV_GMI_RSV_BRANCH.Process_Branch(p_organization_id => l_old_line_rec.ship_from_org_id) ) THEN
6206: Update oe_order_lines_all
6207: Set ordered_quantity = 0,
6208: ordered_quantity2 = 0
6209: Where line_id=l_old_line_rec.line_id;
6210: END IF;

Line 7336: From oe_order_lines_all

7332: BEGIN
7333:
7334: Select 'Y'
7335: Into l_config_exists
7336: From oe_order_lines_all
7337: Where header_id = p_x_line_tbl(I).header_id
7338: And ato_line_id = p_x_line_tbl(I).ato_line_id
7339: And item_type_code = OE_GLOBALS.G_ITEM_CONFIG;
7340:

Line 8457: From oe_order_lines_all

8453: Begin
8454:
8455: Select ato_line_id
8456: Into l_ato_line_id
8457: From oe_order_lines_all
8458: Where line_id = p_x_line_tbl(I).line_id;
8459: EXCEPTION
8460:
8461: WHEN OTHERS THEN