APPS.OE_ORDER_SCH_UTIL dependencies on OE_ORDER_LINES

Line 534: -- of included_items in the oe_order_lines table.

530: END IF;
531:
532: -- Calling Process_Included_Items. This procedure
533: -- will take care of explosions and updateing the picture
534: -- of included_items in the oe_order_lines table.
535:
536: IF l_debug_level > 0 THEN
537: oe_debug_pub.add( 'CALLING PROCESS_INCLUDED_ITEMS' , 1 ) ;
538: END IF;

Line 5643: , OE_ORDER_LINES OL

5639: , db_model_item_id
5640: , db_line_unit_code
5641: , primary_model_qty
5642: FROM MTL_SYSTEM_ITEMS MSI
5643: , OE_ORDER_LINES OL
5644: WHERE MSI.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID
5645: AND MSI.ORGANIZATION_ID = p_ship_from_org_id
5646: AND OL.LINE_ID = p_ato_line_id ;
5647:

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

Line 9411: from oe_order_lines where

9407: IS select header_id,
9408: line_id ,
9409: ordered_quantity,
9410: shipped_quantity
9411: from oe_order_lines where
9412: split_from_line_id = p_reserved_line_id;
9413:
9414: --
9415: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 9424: from oe_order_lines

9420:
9421: BEGIN
9422: SELECT header_id, ship_from_org_id
9423: into l_p_header_id, l_ship_from_org_id
9424: from oe_order_lines
9425: where line_id = p_reserved_line_id;
9426: EXCEPTION
9427: WHEN NO_DATA_FOUND THEN
9428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9550: oe_order_lines table.

9546: mrp_line_tbl_type, which is table of mrp_line_rec_type.
9547: This record is created with only those fields whose values
9548: we can get back from MRP's form. We take the field values
9549: from this record and update the lines information in
9550: oe_order_lines table.
9551: -------------------------------------------------------------------------- */
9552: Procedure Update_Results_from_backlog_wb
9553: ( p_mrp_line_tbl IN mrp_line_tbl_type
9554: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER