eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_GROUP_SCH_UTIL dependencies on OE_ORDER_LINES_ALL

Line 399: From oe_order_lines_all

395: BEGIN
396:
397: Select nvl(arrival_set_id,ship_set_id)
398: Into l_set_id
399: From oe_order_lines_all
400: Where line_id = p_top_model_line_id;
401:
402: IF l_set_id is null THEN
403: g_part_of_set := TRUE;

Line 557: FROM oe_order_lines_all

553: l_rsv_update BOOLEAN := FALSE;
554:
555: CURSOR Process_inc is
556: SELECT line_id
557: FROM oe_order_lines_all
558: WHERE header_id = p_header_id
559: AND open_flag = 'Y'
560: AND ato_line_id is NULL
561: AND item_type_code IN ('MODEL', 'CLASS', 'KIT')

Line 568: FROM oe_order_lines_all

564:
565: CURSOR l_line_csr IS
566: SELECT line_id,schedule_status_code,
567: shippable_flag
568: FROM oe_order_lines_all
569: WHERE header_id = p_header_id
570: AND open_flag = 'Y'
571: AND line_category_code <> 'RETURN'
572: AND item_type_code <> 'SERVICE'

Line 584: FROM oe_order_lines_all

580: SELECT line_id,ship_set_id,arrival_set_id, shippable_flag,
581: shipping_interfaced_flag,orig_sys_document_ref, orig_sys_line_ref,
582: orig_sys_shipment_ref, change_sequence, source_document_type_id,
583: source_document_id, source_document_line_id, order_source_id
584: FROM oe_order_lines_all
585: WHERE header_id = p_header_id
586: AND open_flag = 'Y'
587: AND line_category_code <> 'RETURN'
588: AND schedule_status_code IS NOT NULL

Line 1499: From oe_order_lines_all

1495: l_orig_sys_document_ref, l_orig_sys_line_ref, l_orig_sys_shipment_ref,
1496: l_source_document_type_id, l_change_sequence, l_source_document_id,
1497: l_source_document_line_id, l_order_source_id,
1498: l_subscription_enable_flag --sol_ord_er #16014165
1499: From oe_order_lines_all
1500: Where line_id = l_line_id;
1501:
1502: EXCEPTION
1503: WHEN OTHERS THEN

Line 1910: From oe_order_lines_all

1906: l_orig_sys_document_ref, l_orig_sys_line_ref, l_orig_sys_shipment_ref,
1907: l_source_document_type_id, l_change_sequence, l_source_document_id,
1908: l_source_document_line_id, l_order_source_id,
1909: l_subscription_enable_flag --sol_ord_er #16014165
1910: From oe_order_lines_all
1911: Where line_id = l_line_id;
1912:
1913: OE_MSG_PUB.set_msg_context
1914: ( p_entity_code => 'LINE'

Line 2312: From oe_order_lines_all

2308: l_shipping_interfaced_flag,l_source_type_code,l_link_to_line_id,
2309: l_orig_sys_document_ref, l_orig_sys_line_ref, l_orig_sys_shipment_ref,
2310: l_source_document_type_id, l_change_sequence, l_source_document_id,
2311: l_source_document_line_id, l_order_source_id
2312: From oe_order_lines_all
2313: Where line_id = l_line_id;
2314:
2315: OE_MSG_PUB.set_msg_context
2316: ( p_entity_code => 'LINE'

Line 2649: From oe_order_lines_all

2645: l_orig_sys_document_ref, l_orig_sys_line_ref, l_orig_sys_shipment_ref,
2646: l_source_document_type_id, l_change_sequence, l_source_document_id,
2647: l_source_document_line_id, l_order_source_id,
2648: l_subscription_enable_flag --sol_ord_er #16014165
2649: From oe_order_lines_all
2650: Where line_id = l_line_id;
2651:
2652: OE_MSG_PUB.set_msg_context
2653: ( p_entity_code => 'LINE'

Line 2831: FROM oe_order_lines_all

2827: BEGIN
2828:
2829: SELECT line_id
2830: INTO l_config_id
2831: FROM oe_order_lines_all
2832: WHERE header_id = l_header_id
2833: AND ato_line_id = l_ato_line_id
2834: AND item_type_code = 'CONFIG';
2835:

Line 3257: From oe_order_lines_all

3253: l_orig_sys_document_ref, l_orig_sys_line_ref, l_orig_sys_shipment_ref,
3254: l_source_document_type_id, l_change_sequence, l_source_document_id,
3255: l_source_document_line_id, l_order_source_id,
3256: l_subscription_enable_flag --sol_ord_er #16014165
3257: From oe_order_lines_all
3258: Where line_id = l_line_id;
3259:
3260: OE_MSG_PUB.set_msg_context
3261: ( p_entity_code => 'LINE'

Line 4089: from oe_order_lines_all

4085:
4086: -- 3870895
4087: CURSOR C5 IS
4088: Select line_id, shipping_interfaced_flag
4089: from oe_order_lines_all
4090: where top_model_line_id = l_top_model_line_id
4091: and open_flag = 'Y'
4092: and shipping_interfaced_flag = 'Y';
4093: --

Line 4136: From oe_order_lines_all

4132: l_ato_line_id,
4133: l_header_id,
4134: l_ship_set_id,
4135: l_arrival_set_id
4136: From oe_order_lines_all
4137: Where line_id = p_sch_set_tbl(I).entity_id;
4138: EXCEPTION
4139: WHEN OTHERS THEN
4140: IF l_debug_level > 0 THEN

Line 4167: Update oe_order_lines_all l

4163: -- 3870895
4164: IF l_top_model_line_id is not null
4165: AND l_top_model_line_id = p_sch_set_tbl(I).entity_id THEN
4166:
4167: Update oe_order_lines_all l
4168: Set arrival_set_id = Null,
4169: ship_set_id = Null
4170: Where top_model_line_id = l_top_model_line_id
4171: And open_flag = 'Y';

Line 4445: UPDATE OE_ORDER_LINES_ALL

4441: AND l_arrival_set_id IS null THEN
4442: FOR I IN 1..l_iline_tbl.count LOOP
4443: IF l_iline_tbl(I).schedule_status_code IS NULL THEN
4444:
4445: UPDATE OE_ORDER_LINES_ALL
4446: SET SCHEDULE_SHIP_DATE = Null,
4447: SCHEDULE_ARRIVAL_DATE = Null,
4448: SHIP_FROM_ORG_ID = decode(re_source_flag,'N',ship_from_org_id,null),
4449: SHIP_SET_ID = Null,

Line 4455: UPDATE OE_ORDER_LINES_ALL

4451: override_atp_date_code = Null
4452: WHERE line_id = l_iline_tbl(I).line_id;
4453:
4454: ELSE
4455: UPDATE OE_ORDER_LINES_ALL
4456: SET
4457: SCHEDULE_SHIP_DATE = p_sch_set_tbl(I).date_param1,
4458: SCHEDULE_ARRIVAL_DATE = p_sch_set_tbl(I).date_param2,
4459: SHIP_FROM_ORG_ID = p_sch_set_tbl(I).param4,

Line 4802: UPDATE OE_ORDER_LINES_ALL

4798:
4799: IF l_line_tbl(I).schedule_status_code IS NULL
4800: THEN
4801:
4802: UPDATE OE_ORDER_LINES_ALL
4803: SET SCHEDULE_SHIP_DATE = Null,
4804: SCHEDULE_ARRIVAL_DATE = Null,
4805: SHIP_FROM_ORG_ID = decode(re_source_flag,'N',ship_from_org_id,null),
4806: SHIP_SET_ID = Null,

Line 4815: UPDATE OE_ORDER_LINES_ALL

4811: ELSE
4812: -- fix for 3557779
4813: -- update schedule_status_code and visible_demand_flag fields in
4814: -- addition to previously updated fields
4815: UPDATE OE_ORDER_LINES_ALL
4816: SET
4817: SCHEDULE_STATUS_CODE = l_old_line_tbl(I).schedule_status_code,
4818: VISIBLE_DEMAND_FLAG = l_old_line_tbl(I).visible_demand_flag,
4819: SCHEDULE_SHIP_DATE = l_old_line_tbl(I).schedule_ship_date,

Line 5030: From OE_ORDER_LINES_ALL

5026: Ship_set_id,arrival_Set_id, org_id --4241385
5027: Into l_Schedule_ship_date, l_Schedule_arrival_date,
5028: l_ship_to_org_id, l_ship_from_org_id, l_request_date,
5029: l_ship_set_id,l_arrival_set_id,l_org_id
5030: From OE_ORDER_LINES_ALL
5031: Where line_id = l_line_id;
5032:
5033: -- Schedule set lines is called it will have param4 as
5034: -- set date, use the same to schedule the line.

Line 5045: Select 1 into l_count from OE_ORDER_LINES_ALL

5041: BEGIN
5042:
5043: IF p_request_rec.param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET THEN
5044:
5045: Select 1 into l_count from OE_ORDER_LINES_ALL
5046: WHERE header_id = l_header_id and arrival_Set_id = p_request_rec.param1
5047: AND rownum = 1;
5048:
5049: ELSIF p_request_rec.param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET THEN

Line 5051: Select 1 into l_count from OE_ORDER_LINES_ALL

5047: AND rownum = 1;
5048:
5049: ELSIF p_request_rec.param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET THEN
5050:
5051: Select 1 into l_count from OE_ORDER_LINES_ALL
5052: WHERE header_id = l_header_id and ship_set_id = p_request_rec.param1
5053: AND rownum = 1;
5054:
5055: END IF;

Line 5335: From oe_order_lines_all

5331: BEGIN
5332:
5333: Select override_atp_date_code
5334: Into l_line_tbl(I).override_atp_date_code
5335: From oe_order_lines_all
5336: Where header_id = l_line_tbl(I).header_id
5337: And ato_line_id = l_line_tbl(I).ato_line_id
5338: And override_atp_date_code = 'Y'
5339: And rownum < 2;

Line 5360: From oe_order_lines_all

5356:
5357:
5358: Select override_atp_date_code
5359: Into l_line_tbl(I).override_atp_date_code
5360: From oe_order_lines_all
5361: Where header_id = l_line_tbl(I).header_id
5362: And line_id = l_line_tbl(I).link_to_line_id;
5363:
5364: IF l_debug_level > 0 THEN

Line 5846: UPDATE OE_ORDER_LINES_ALL

5842: AND l_line_tbl(I).top_model_line_id <> l_line_tbl(I).line_id
5843: AND Not_part_of_set(l_line_tbl(I).top_model_line_id))
5844: THEN
5845:
5846: UPDATE OE_ORDER_LINES_ALL
5847: SET SCHEDULE_SHIP_DATE = Null,
5848: SCHEDULE_ARRIVAL_DATE = Null,
5849: SHIP_FROM_ORG_ID = decode(re_source_flag,'N',ship_from_org_id,null),
5850: SHIP_SET_ID = Null,

Line 5929: From oe_order_lines_all

5925: Freight_Carrier_Code,shipment_priority_code
5926: INTO l_ship_from_org_id,l_ship_to_org_id,l_schedule_ship_date,
5927: l_schedule_arrival_date,l_Shipping_Method_Code,
5928: l_Freight_Carrier_Code,l_shipment_priority_code
5929: From oe_order_lines_all
5930: Where line_id = l_line_tbl(1).line_id;
5931:
5932: IF l_debug_level > 0 THEN
5933: oe_debug_pub.add( 'CALLING UPDATE SET' ) ;

Line 6062: From oe_order_lines_all

6058: BEGIN
6059:
6060: Select 'Y'
6061: Into l_set_exists
6062: From oe_order_lines_all
6063: Where header_id = p_sch_set_tbl(I).param2
6064: And (ship_set_id = p_sch_set_tbl(I).entity_id
6065: Or arrival_set_id = p_sch_set_tbl(I).entity_id)
6066: And open_flag = 'Y'

Line 6171: From oe_order_lines_all

6167: schedule_arrival_date
6168: Into l_sch_line_tbl(l_count).override_atp_date_code,
6169: l_sch_line_tbl(l_count).schedule_ship_date,
6170: l_sch_line_tbl(l_count).schedule_arrival_date
6171: From oe_order_lines_all
6172: Where header_id = l_line_tbl(J).header_id
6173: And ato_line_id = l_line_tbl(J).ato_line_id
6174: And override_atp_date_code = 'Y'
6175: And rownum < 2;

Line 6223: UPDATE OE_ORDER_LINES_ALL

6219: END IF;
6220:
6221: IF p_sch_set_tbl(I).param4 is null
6222: THEN
6223: UPDATE OE_ORDER_LINES_ALL
6224: SET SCHEDULE_SHIP_DATE = Null,
6225: SCHEDULE_ARRIVAL_DATE = Null,
6226: SHIP_FROM_ORG_ID = decode(re_source_flag,'N',ship_from_org_id,null),
6227: SHIP_SET_ID = Null,

Line 6233: UPDATE OE_ORDER_LINES_ALL

6229: OVERRIDE_ATP_DATE_CODE = Null
6230: WHERE line_id = p_sch_set_tbl(I).param3;
6231: ELSE
6232:
6233: UPDATE OE_ORDER_LINES_ALL
6234: SET SCHEDULE_SHIP_DATE = Null,
6235: SCHEDULE_ARRIVAL_DATE = Null,
6236: SHIP_FROM_ORG_ID = decode(re_source_flag,'N',ship_from_org_id,null),
6237: SHIP_SET_ID = Null,

Line 6300: UPDATE OE_ORDER_LINES_ALL

6296: IF l_sch_line_tbl(I).schedule_status_code IS NULL
6297: THEN
6298:
6299: IF l_sch_line_tbl(I).top_model_line_id is NULL THEN
6300: UPDATE OE_ORDER_LINES_ALL
6301: SET SCHEDULE_SHIP_DATE = Null,
6302: SCHEDULE_ARRIVAL_DATE = Null,
6303: SHIP_FROM_ORG_ID = decode(re_source_flag,'N',ship_from_org_id,null),
6304: SHIP_SET_ID = Null,

Line 6309: UPDATE OE_ORDER_LINES_ALL

6305: ARRIVAL_SET_ID = Null,
6306: OVERRIDE_ATP_DATE_CODE = Null
6307: WHERE line_id = l_sch_line_tbl(I).line_id;
6308: ELSE
6309: UPDATE OE_ORDER_LINES_ALL
6310: SET SCHEDULE_SHIP_DATE = Null,
6311: SCHEDULE_ARRIVAL_DATE = Null,
6312: SHIP_FROM_ORG_ID = decode(re_source_flag,'N',ship_from_org_id,null),
6313: SHIP_SET_ID = Null,

Line 6351: UPDATE OE_ORDER_LINES_ALL

6347: AND l_sch_line_tbl(I).top_model_line_id <> l_sch_line_tbl(I).line_id
6348: AND Not_part_of_set(l_sch_line_tbl(I).top_model_line_id))
6349: THEN
6350:
6351: UPDATE OE_ORDER_LINES_ALL
6352: SET SCHEDULE_SHIP_DATE = Null,
6353: SCHEDULE_ARRIVAL_DATE = Null,
6354: SHIP_FROM_ORG_ID = decode(re_source_flag,'N',ship_from_org_id,null),
6355: SHIP_SET_ID = Null,