DBA Data[Home] [Help]

APPS.OE_GRP_SCH_UTIL dependencies on OE_ORDER_LINES_ALL

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 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 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);