APPS.OE_CONFIG_SCHEDULE_PVT dependencies on OE_ORDER_LINES

Line 294: FROM oe_order_lines

290: schedule_arrival_date, request_date
291: INTO l_model_sch_status_code, l_model_ship_from,
292: l_model_demand_class, l_model_ship_date,
293: l_model_arrival_date, l_model_request_date
294: FROM oe_order_lines
295: WHERE line_id = p_line_rec.top_model_line_id;
296:
297: IF l_model_sch_status_code is NOT NULL THEN
298: l_sch_action := OE_Schedule_Util.OESCH_ACT_RESCHEDULE;

Line 2497: From oe_order_lines_all

2493:
2494:
2495: Select override_atp_date_code
2496: Into p_x_line_rec.override_atp_date_code
2497: From oe_order_lines_all
2498: Where header_id = p_x_line_rec.header_id
2499: And ato_line_id = p_x_line_rec.ato_line_id
2500: And override_atp_date_code = 'Y'
2501: AND rownum < 2;

Line 2530: From oe_order_lines_all

2526:
2527:
2528: Select override_atp_date_code
2529: Into p_x_line_rec.override_atp_date_code
2530: From oe_order_lines_all
2531: Where header_id = p_x_line_rec.header_id
2532: And line_id = p_x_line_rec.link_to_line_id;
2533:
2534: EXCEPTION

Line 2668: FROM oe_order_lines

2664: p_old_line_tbl(I).shipping_method_code,
2665: p_old_line_tbl(I).demand_class_code,
2666: p_old_line_tbl(I).planning_priority,
2667: p_old_line_tbl(I).delivery_lead_time
2668: FROM oe_order_lines
2669: WHERE line_id = p_x_line_tbl(I).line_id;
2670:
2671: END IF;-- 4052648
2672:

Line 3303: UPDATE OE_ORDER_LINES

3299: END IF;
3300: -- End 2806483
3301:
3302: -- Pack J -Promise Date added to reflect changes
3303: UPDATE OE_ORDER_LINES
3304: SET ship_from_org_id = p_x_line_rec.ship_from_org_id
3305: ,schedule_ship_date = p_x_line_rec.schedule_ship_date
3306: ,schedule_arrival_date = p_x_line_rec.schedule_arrival_date
3307: ,delivery_lead_time = p_x_line_rec.delivery_lead_time

Line 3583: FROM oe_order_lines

3579: I NUMBER;
3580:
3581: CURSOR inc_parents is
3582: SELECT line_id
3583: FROM oe_order_lines
3584: WHERE item_type_code IN ('MODEL', 'CLASS', 'KIT')
3585: AND ato_line_id is NULL
3586: AND explosion_date is NULL
3587: AND header_id = p_header_id

Line 3887: FROM OE_ORDER_LINES

3883: ,x_line_rec.MODEL_REMNANT_FLAG
3884: ,x_line_rec.TOP_MODEL_LINE_ID
3885: ,x_line_rec.UPGRADED_FLAG
3886: ,x_line_rec.LOCK_CONTROL
3887: FROM OE_ORDER_LINES
3888: WHERE LINE_ID = P_LINE_ID;
3889: EXCEPTION
3890: WHEN OTHERS THEN
3891: IF l_debug_level > 0 THEN

Line 3956: FROM oe_order_lines

3952: IF p_request_type = 'SCHEDULE_ATO' THEN
3953:
3954: SELECT ship_from_org_id
3955: INTO l_num_id
3956: FROM oe_order_lines
3957: WHERE line_id = p_line_rec.ato_line_id;
3958:
3959: IF l_num_id is NULL AND
3960: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE