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 2437: From oe_order_lines_all

2433:
2434:
2435: Select override_atp_date_code
2436: Into p_x_line_rec.override_atp_date_code
2437: From oe_order_lines_all
2438: Where header_id = p_x_line_rec.header_id
2439: And ato_line_id = p_x_line_rec.ato_line_id
2440: And override_atp_date_code = 'Y'
2441: AND rownum < 2;

Line 2470: From oe_order_lines_all

2466:
2467:
2468: Select override_atp_date_code
2469: Into p_x_line_rec.override_atp_date_code
2470: From oe_order_lines_all
2471: Where header_id = p_x_line_rec.header_id
2472: And line_id = p_x_line_rec.link_to_line_id;
2473:
2474: EXCEPTION

Line 2608: FROM oe_order_lines

2604: p_old_line_tbl(I).shipping_method_code,
2605: p_old_line_tbl(I).demand_class_code,
2606: p_old_line_tbl(I).planning_priority,
2607: p_old_line_tbl(I).delivery_lead_time
2608: FROM oe_order_lines
2609: WHERE line_id = p_x_line_tbl(I).line_id;
2610:
2611: END IF;-- 4052648
2612:

Line 3213: UPDATE OE_ORDER_LINES

3209: END IF;
3210: -- End 2806483
3211:
3212: -- Pack J -Promise Date added to reflect changes
3213: UPDATE OE_ORDER_LINES
3214: SET ship_from_org_id = p_x_line_rec.ship_from_org_id
3215: ,schedule_ship_date = p_x_line_rec.schedule_ship_date
3216: ,schedule_arrival_date = p_x_line_rec.schedule_arrival_date
3217: ,delivery_lead_time = p_x_line_rec.delivery_lead_time

Line 3493: FROM oe_order_lines

3489: I NUMBER;
3490:
3491: CURSOR inc_parents is
3492: SELECT line_id
3493: FROM oe_order_lines
3494: WHERE item_type_code IN ('MODEL', 'CLASS', 'KIT')
3495: AND ato_line_id is NULL
3496: AND explosion_date is NULL
3497: AND header_id = p_header_id

Line 3766: FROM OE_ORDER_LINES

3762: ,x_line_rec.MODEL_REMNANT_FLAG
3763: ,x_line_rec.TOP_MODEL_LINE_ID
3764: ,x_line_rec.UPGRADED_FLAG
3765: ,x_line_rec.LOCK_CONTROL
3766: FROM OE_ORDER_LINES
3767: WHERE LINE_ID = P_LINE_ID;
3768: EXCEPTION
3769: WHEN OTHERS THEN
3770: IF l_debug_level > 0 THEN

Line 3835: FROM oe_order_lines

3831: IF p_request_type = 'SCHEDULE_ATO' THEN
3832:
3833: SELECT ship_from_org_id
3834: INTO l_num_id
3835: FROM oe_order_lines
3836: WHERE line_id = p_line_rec.ato_line_id;
3837:
3838: IF l_num_id is NULL AND
3839: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE