APPS.OE_SCHEDULE_GRP dependencies on OE_ORDER_LINES_ALL

Line 64: FROM oe_order_lines_all ol

60: CURSOR ship_set(p_ship_set number) IS
61: SELECT ol.line_id,
62: ol.inventory_item_id,
63: ol.ordered_quantity
64: FROM oe_order_lines_all ol
65: WHERE ship_set_id=p_ship_set;
66:
67:
68: CURSOR arrival_set(p_arrival_set number) IS

Line 72: FROM oe_order_lines_all ol

68: CURSOR arrival_set(p_arrival_set number) IS
69: SELECT ol.line_id ,
70: ol.inventory_item_id,
71: ol.ordered_quantity
72: FROM oe_order_lines_all ol
73: WHERE arrival_set_id=p_arrival_set;
74: --9187335 End
75: BEGIN
76:

Line 119: FROM oe_order_lines_all

115:
116: BEGIN
117: SELECT ship_set_id, arrival_set_id
118: INTO l_ship_set_id, l_arrival_set_id
119: FROM oe_order_lines_all
120: WHERE line_id=p_x_sch_tbl(I).line_id;
121:
122: oe_debug_pub.add('Ship Set '||l_ship_set_id||' Arrival Set '||l_arrival_set_id,1);
123: EXCEPTION

Line 1346: From oe_order_lines_all

1342: IS
1343:
1344: Cursor line_ship_set IS
1345: Select line_id,ato_line_id,item_type_code
1346: From oe_order_lines_all
1347: Where ship_set_id = p_ship_set_id;
1348:
1349: Cursor line_arrival_set IS
1350: Select line_id,ato_line_id,item_type_code

Line 1351: From oe_order_lines_all

1347: Where ship_set_id = p_ship_set_id;
1348:
1349: Cursor line_arrival_set IS
1350: Select line_id,ato_line_id,item_type_code
1351: From oe_order_lines_all
1352: Where arrival_set_id = p_arrival_set_id;
1353:
1354: Cursor line_smc IS
1355: Select line_id,ato_line_id,item_type_code

Line 1356: From oe_order_lines_all

1352: Where arrival_set_id = p_arrival_set_id;
1353:
1354: Cursor line_smc IS
1355: Select line_id,ato_line_id,item_type_code
1356: From oe_order_lines_all
1357: Where top_model_line_id = p_top_model_line_id;
1358:
1359: l_result Boolean := TRUE;
1360: l_index Number;