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

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

Line 556: FROM oe_order_lines_all

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

Line 567: FROM oe_order_lines_all

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

Line 580: FROM oe_order_lines_all

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

Line 1487: From oe_order_lines_all

1483: l_source_type_code,l_link_to_line_id,
1484: l_orig_sys_document_ref, l_orig_sys_line_ref, l_orig_sys_shipment_ref,
1485: l_source_document_type_id, l_change_sequence, l_source_document_id,
1486: l_source_document_line_id, l_order_source_id
1487: From oe_order_lines_all
1488: Where line_id = l_line_id;
1489:
1490: EXCEPTION
1491: WHEN OTHERS THEN

Line 1864: From oe_order_lines_all

1860: l_source_type_code,l_link_to_line_id,
1861: l_orig_sys_document_ref, l_orig_sys_line_ref, l_orig_sys_shipment_ref,
1862: l_source_document_type_id, l_change_sequence, l_source_document_id,
1863: l_source_document_line_id, l_order_source_id
1864: From oe_order_lines_all
1865: Where line_id = l_line_id;
1866:
1867: OE_MSG_PUB.set_msg_context
1868: ( p_entity_code => 'LINE'

Line 2264: From oe_order_lines_all

2260: l_shipping_interfaced_flag,l_source_type_code,l_link_to_line_id,
2261: l_orig_sys_document_ref, l_orig_sys_line_ref, l_orig_sys_shipment_ref,
2262: l_source_document_type_id, l_change_sequence, l_source_document_id,
2263: l_source_document_line_id, l_order_source_id
2264: From oe_order_lines_all
2265: Where line_id = l_line_id;
2266:
2267: OE_MSG_PUB.set_msg_context
2268: ( p_entity_code => 'LINE'

Line 2597: From oe_order_lines_all

2593: l_source_type_code,l_link_to_line_id,
2594: l_orig_sys_document_ref, l_orig_sys_line_ref, l_orig_sys_shipment_ref,
2595: l_source_document_type_id, l_change_sequence, l_source_document_id,
2596: l_source_document_line_id, l_order_source_id
2597: From oe_order_lines_all
2598: Where line_id = l_line_id;
2599:
2600: OE_MSG_PUB.set_msg_context
2601: ( p_entity_code => 'LINE'

Line 2752: FROM oe_order_lines_all

2748: BEGIN
2749:
2750: SELECT line_id
2751: INTO l_config_id
2752: FROM oe_order_lines_all
2753: WHERE header_id = l_header_id
2754: AND ato_line_id = l_ato_line_id
2755: AND item_type_code = 'CONFIG';
2756:

Line 3175: From oe_order_lines_all

3171: l_source_type_code,l_link_to_line_id,
3172: l_orig_sys_document_ref, l_orig_sys_line_ref, l_orig_sys_shipment_ref,
3173: l_source_document_type_id, l_change_sequence, l_source_document_id,
3174: l_source_document_line_id, l_order_source_id
3175: From oe_order_lines_all
3176: Where line_id = l_line_id;
3177:
3178: OE_MSG_PUB.set_msg_context
3179: ( p_entity_code => 'LINE'

Line 4005: from oe_order_lines_all

4001:
4002: -- 3870895
4003: CURSOR C5 IS
4004: Select line_id, shipping_interfaced_flag
4005: from oe_order_lines_all
4006: where top_model_line_id = l_top_model_line_id
4007: and open_flag = 'Y'
4008: and shipping_interfaced_flag = 'Y';
4009: --

Line 4052: From oe_order_lines_all

4048: l_ato_line_id,
4049: l_header_id,
4050: l_ship_set_id,
4051: l_arrival_set_id
4052: From oe_order_lines_all
4053: Where line_id = p_sch_set_tbl(I).entity_id;
4054: EXCEPTION
4055: WHEN OTHERS THEN
4056: IF l_debug_level > 0 THEN

Line 4083: Update oe_order_lines_all l

4079: -- 3870895
4080: IF l_top_model_line_id is not null
4081: AND l_top_model_line_id = p_sch_set_tbl(I).entity_id THEN
4082:
4083: Update oe_order_lines_all l
4084: Set arrival_set_id = Null,
4085: ship_set_id = Null
4086: Where top_model_line_id = l_top_model_line_id
4087: And open_flag = 'Y';

Line 4360: UPDATE OE_ORDER_LINES_ALL

4356: AND l_arrival_set_id IS null THEN
4357: FOR I IN 1..l_iline_tbl.count LOOP
4358: IF l_iline_tbl(I).schedule_status_code IS NULL THEN
4359:
4360: UPDATE OE_ORDER_LINES_ALL
4361: SET SCHEDULE_SHIP_DATE = Null,
4362: SCHEDULE_ARRIVAL_DATE = Null,
4363: SHIP_FROM_ORG_ID = decode(re_source_flag,'N',ship_from_org_id,null),
4364: SHIP_SET_ID = Null,

Line 4370: UPDATE OE_ORDER_LINES_ALL

4366: override_atp_date_code = Null
4367: WHERE line_id = l_iline_tbl(I).line_id;
4368:
4369: ELSE
4370: UPDATE OE_ORDER_LINES_ALL
4371: SET
4372: SCHEDULE_SHIP_DATE = p_sch_set_tbl(I).date_param1,
4373: SCHEDULE_ARRIVAL_DATE = p_sch_set_tbl(I).date_param2,
4374: SHIP_FROM_ORG_ID = p_sch_set_tbl(I).param4,

Line 4717: UPDATE OE_ORDER_LINES_ALL

4713:
4714: IF l_line_tbl(I).schedule_status_code IS NULL
4715: THEN
4716:
4717: UPDATE OE_ORDER_LINES_ALL
4718: SET SCHEDULE_SHIP_DATE = Null,
4719: SCHEDULE_ARRIVAL_DATE = Null,
4720: SHIP_FROM_ORG_ID = decode(re_source_flag,'N',ship_from_org_id,null),
4721: SHIP_SET_ID = Null,

Line 4730: UPDATE OE_ORDER_LINES_ALL

4726: ELSE
4727: -- fix for 3557779
4728: -- update schedule_status_code and visible_demand_flag fields in
4729: -- addition to previously updated fields
4730: UPDATE OE_ORDER_LINES_ALL
4731: SET
4732: SCHEDULE_STATUS_CODE = l_old_line_tbl(I).schedule_status_code,
4733: VISIBLE_DEMAND_FLAG = l_old_line_tbl(I).visible_demand_flag,
4734: SCHEDULE_SHIP_DATE = l_old_line_tbl(I).schedule_ship_date,

Line 4944: From OE_ORDER_LINES_ALL

4940: Ship_set_id,arrival_Set_id
4941: Into l_Schedule_ship_date, l_Schedule_arrival_date,
4942: l_ship_to_org_id, l_ship_from_org_id, l_request_date,
4943: l_ship_set_id,l_arrival_set_id
4944: From OE_ORDER_LINES_ALL
4945: Where line_id = l_line_id;
4946:
4947: -- Schedule set lines is called it will have param4 as
4948: -- set date, use the same to schedule the line.

Line 4959: Select 1 into l_count from OE_ORDER_LINES_ALL

4955: BEGIN
4956:
4957: IF p_request_rec.param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET THEN
4958:
4959: Select 1 into l_count from OE_ORDER_LINES_ALL
4960: WHERE header_id = l_header_id and arrival_Set_id = p_request_rec.param1
4961: AND rownum = 1;
4962:
4963: ELSIF p_request_rec.param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET THEN

Line 4965: Select 1 into l_count from OE_ORDER_LINES_ALL

4961: AND rownum = 1;
4962:
4963: ELSIF p_request_rec.param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET THEN
4964:
4965: Select 1 into l_count from OE_ORDER_LINES_ALL
4966: WHERE header_id = l_header_id and ship_set_id = p_request_rec.param1
4967: AND rownum = 1;
4968:
4969: END IF;

Line 5246: From oe_order_lines_all

5242: BEGIN
5243:
5244: Select override_atp_date_code
5245: Into l_line_tbl(I).override_atp_date_code
5246: From oe_order_lines_all
5247: Where header_id = l_line_tbl(I).header_id
5248: And ato_line_id = l_line_tbl(I).ato_line_id
5249: And override_atp_date_code = 'Y'
5250: And rownum < 2;

Line 5271: From oe_order_lines_all

5267:
5268:
5269: Select override_atp_date_code
5270: Into l_line_tbl(I).override_atp_date_code
5271: From oe_order_lines_all
5272: Where header_id = l_line_tbl(I).header_id
5273: And line_id = l_line_tbl(I).link_to_line_id;
5274:
5275: IF l_debug_level > 0 THEN

Line 5783: UPDATE OE_ORDER_LINES_ALL

5779: AND l_line_tbl(I).top_model_line_id <> l_line_tbl(I).line_id
5780: AND Not_part_of_set(l_line_tbl(I).top_model_line_id))
5781: THEN
5782:
5783: UPDATE OE_ORDER_LINES_ALL
5784: SET SCHEDULE_SHIP_DATE = Null,
5785: SCHEDULE_ARRIVAL_DATE = Null,
5786: SHIP_FROM_ORG_ID = decode(re_source_flag,'N',ship_from_org_id,null),
5787: SHIP_SET_ID = Null,

Line 5863: From oe_order_lines_all

5859: Freight_Carrier_Code,shipment_priority_code
5860: INTO l_ship_from_org_id,l_ship_to_org_id,l_schedule_ship_date,
5861: l_schedule_arrival_date,l_Shipping_Method_Code,
5862: l_Freight_Carrier_Code,l_shipment_priority_code
5863: From oe_order_lines_all
5864: Where line_id = l_line_tbl(1).line_id;
5865:
5866: IF l_debug_level > 0 THEN
5867: oe_debug_pub.add( 'CALLING UPDATE SET' ) ;

Line 5996: From oe_order_lines_all

5992: BEGIN
5993:
5994: Select 'Y'
5995: Into l_set_exists
5996: From oe_order_lines_all
5997: Where header_id = p_sch_set_tbl(I).param2
5998: And (ship_set_id = p_sch_set_tbl(I).entity_id
5999: Or arrival_set_id = p_sch_set_tbl(I).entity_id)
6000: And open_flag = 'Y'

Line 6104: From oe_order_lines_all

6100: schedule_arrival_date
6101: Into l_sch_line_tbl(l_count).override_atp_date_code,
6102: l_sch_line_tbl(l_count).schedule_ship_date,
6103: l_sch_line_tbl(l_count).schedule_arrival_date
6104: From oe_order_lines_all
6105: Where header_id = l_line_tbl(J).header_id
6106: And ato_line_id = l_line_tbl(J).ato_line_id
6107: And override_atp_date_code = 'Y'
6108: And rownum < 2;

Line 6156: UPDATE OE_ORDER_LINES_ALL

6152: END IF;
6153:
6154: IF p_sch_set_tbl(I).param4 is null
6155: THEN
6156: UPDATE OE_ORDER_LINES_ALL
6157: SET SCHEDULE_SHIP_DATE = Null,
6158: SCHEDULE_ARRIVAL_DATE = Null,
6159: SHIP_FROM_ORG_ID = decode(re_source_flag,'N',ship_from_org_id,null),
6160: SHIP_SET_ID = Null,

Line 6166: UPDATE OE_ORDER_LINES_ALL

6162: OVERRIDE_ATP_DATE_CODE = Null
6163: WHERE line_id = p_sch_set_tbl(I).param3;
6164: ELSE
6165:
6166: UPDATE OE_ORDER_LINES_ALL
6167: SET SCHEDULE_SHIP_DATE = Null,
6168: SCHEDULE_ARRIVAL_DATE = Null,
6169: SHIP_FROM_ORG_ID = decode(re_source_flag,'N',ship_from_org_id,null),
6170: SHIP_SET_ID = Null,

Line 6233: UPDATE OE_ORDER_LINES_ALL

6229: IF l_sch_line_tbl(I).schedule_status_code IS NULL
6230: THEN
6231:
6232: IF l_sch_line_tbl(I).top_model_line_id is NULL THEN
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 6242: UPDATE OE_ORDER_LINES_ALL

6238: ARRIVAL_SET_ID = Null,
6239: OVERRIDE_ATP_DATE_CODE = Null
6240: WHERE line_id = l_sch_line_tbl(I).line_id;
6241: ELSE
6242: UPDATE OE_ORDER_LINES_ALL
6243: SET SCHEDULE_SHIP_DATE = Null,
6244: SCHEDULE_ARRIVAL_DATE = Null,
6245: SHIP_FROM_ORG_ID = decode(re_source_flag,'N',ship_from_org_id,null),
6246: SHIP_SET_ID = Null,

Line 6284: UPDATE OE_ORDER_LINES_ALL

6280: AND l_sch_line_tbl(I).top_model_line_id <> l_sch_line_tbl(I).line_id
6281: AND Not_part_of_set(l_sch_line_tbl(I).top_model_line_id))
6282: THEN
6283:
6284: UPDATE OE_ORDER_LINES_ALL
6285: SET SCHEDULE_SHIP_DATE = Null,
6286: SCHEDULE_ARRIVAL_DATE = Null,
6287: SHIP_FROM_ORG_ID = decode(re_source_flag,'N',ship_from_org_id,null),
6288: SHIP_SET_ID = Null,