APPS.OE_GRP_SCH_UTIL dependencies on OE_ORDER_LINES

Line 684: FROM oe_order_lines

680: schedule_status_code,
681: shipping_method_code,
682: sold_to_org_id,
683: top_model_line_id
684: FROM oe_order_lines
685: WHERE header_id = p_header_id
686: AND item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED;
687:
688: --

Line 1175: FROM oe_order_lines_all

1171: -- Query the ATO line Id,Ship Set Id and Arrival Set Id from the line.
1172:
1173: SELECT ato_line_id , ship_set_id, arrival_set_id
1174: INTO l_ato_line_id,l_ship_set_id,l_arrival_set_id
1175: FROM oe_order_lines_all
1176: WHERE line_id = l_line_id;
1177:
1178: IF l_debug_level > 0 THEN
1179: oe_debug_pub.add( 'WAREHOUSE IS ' || P_GROUP_REQ_REC.SHIP_FROM_ORG_ID , 1 ) ;

Line 1227: FROM OE_ORDER_LINES_ALL

1223: -- item is created.
1224: BEGIN
1225: SELECT line_Id
1226: INTO l_config_id
1227: FROM OE_ORDER_LINES_ALL
1228: WHERE ato_line_id=l_model_line_rec.line_id
1229: AND top_model_line_id =l_model_line_rec.top_model_line_id
1230: AND item_type_code = 'CONFIG';
1231:

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

1647: x_line_tbl(J).item_type_code = OE_GLOBALS.G_ITEM_KIT) THEN
1648:
1649: -- Calling Process_Included_Items. This procedure
1650: -- will take care of exploding and updating the picture
1651: -- of included_items in the oe_order_lines table.
1652:
1653: l_old_recursion_mode := OE_GLOBALS.G_RECURSION_MODE;
1654: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';
1655:

Line 1829: FROM OE_ORDER_LINES_ALL

1825: -- item is created.
1826: BEGIN
1827: SELECT line_Id
1828: INTO l_config_id
1829: FROM OE_ORDER_LINES_ALL
1830: WHERE top_model_line_id = l_line_tbl(1).top_model_line_id
1831: AND item_type_code = 'CONFIG';
1832:
1833: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNSCH_CONFIG_EXISTS');

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

2446: p_x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_KIT) THEN
2447:
2448: -- Calling Process_Included_Items. This procedure
2449: -- will take care of exploding and updating the picture
2450: -- of included_items in the oe_order_lines table.
2451:
2452: IF l_debug_level > 0 THEN
2453: oe_debug_pub.add( 'CALLING PROCESS_INCLUDED_ITEMS ' , 1 ) ;
2454: END IF;

Line 3751: FROM OE_ORDER_LINES_ALL

3747: l_org_id NUMBER;
3748:
3749: CURSOR l_line_csr IS
3750: SELECT LINE_ID
3751: FROM OE_ORDER_LINES_ALL
3752: WHERE
3753: HEADER_ID = p_header_id
3754: AND item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED
3755: ORDER BY arrival_set_id,ship_set_id,line_number,shipment_number,nvl(option_number,-1);