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_SCHEDULE_UTIL dependencies on OE_ORDER_LINES

Line 775: FROM oe_order_lines_all

771: BEGIN
772:
773: SELECT 'Y'
774: INTO l_overridden
775: FROM oe_order_lines_all
776: WHERE top_model_line_id = p_top_model_line_id
777: AND open_flag = 'Y'
778: AND override_atp_date_code = 'Y'
779: AND rownum < 2;

Line 810: FROM oe_order_lines_all

806:
807:
808: SELECT 'Y'
809: INTO l_overridden
810: FROM oe_order_lines_all
811: WHERE header_id = p_header_id
812: AND (ship_set_id = p_ship_set_id
813: OR arrival_set_id = p_arrival_set_id)
814: AND override_atp_date_code = 'Y'

Line 1187: FROM oe_order_lines_all a,

1183: IF p_set_type = 'SHIP_SET' THEN
1184:
1185: SELECT count(a.line_id)
1186: INTO l_count
1187: FROM oe_order_lines_all a,
1188: oe_order_lines_all b
1189: WHERE a.top_model_line_id = p_top_model_line_id
1190: AND a.top_model_line_id = b.top_model_line_id
1191: AND a.override_atp_date_code = 'Y'

Line 1188: oe_order_lines_all b

1184:
1185: SELECT count(a.line_id)
1186: INTO l_count
1187: FROM oe_order_lines_all a,
1188: oe_order_lines_all b
1189: WHERE a.top_model_line_id = p_top_model_line_id
1190: AND a.top_model_line_id = b.top_model_line_id
1191: AND a.override_atp_date_code = 'Y'
1192: AND b.override_atp_date_code = 'Y'

Line 1199: FROM oe_order_lines_all a,

1195: ELSIF p_set_type = 'ARRIVAL_SET' THEN
1196:
1197: SELECT count(a.line_id)
1198: INTO l_count
1199: FROM oe_order_lines_all a,
1200: oe_order_lines_all b
1201: WHERE a.top_model_line_id = p_top_model_line_id
1202: AND a.top_model_line_id = b.top_model_line_id
1203: AND a.override_atp_date_code = 'Y'

Line 1200: oe_order_lines_all b

1196:
1197: SELECT count(a.line_id)
1198: INTO l_count
1199: FROM oe_order_lines_all a,
1200: oe_order_lines_all b
1201: WHERE a.top_model_line_id = p_top_model_line_id
1202: AND a.top_model_line_id = b.top_model_line_id
1203: AND a.override_atp_date_code = 'Y'
1204: AND b.override_atp_date_code = 'Y'

Line 1937: Update oe_order_lines_all

1933: l_shipping_method_code) THEN
1934:
1935: BEGIN
1936:
1937: Update oe_order_lines_all
1938: Set shipping_method_code = l_shipping_method_code
1939: where header_id = p_line_rec.header_id
1940: and line_id = p_line_rec.line_id;
1941: EXCEPTION

Line 3011: Update oe_order_lines_all

3007: -- Bug3361870 (commenting this piece of code. Not required)
3008: /* IF INV_GMI_RSV_BRANCH.Process_Branch -- INVCONV - delete this
3009: (p_organization_id => p_old_line_rec.ship_from_org_id)
3010: THEN
3011: Update oe_order_lines_all
3012: Set ordered_quantity = 0,
3013: ordered_quantity2 = 0
3014: Where line_id=p_old_line_rec.line_id;
3015: END IF; */

Line 3751: From oe_order_lines_all

3747: BEGIN
3748:
3749: Select line_id
3750: Into l_config_line_id
3751: From oe_order_lines_all
3752: Where ato_line_id = p_line_tbl(cnt).ato_line_id
3753: And item_type_code = 'CONFIG';
3754:
3755: EXCEPTION

Line 5099: From oe_order_lines_all

5095: BEGIN
5096:
5097: Select 'Y'
5098: Into l_config_exists
5099: From oe_order_lines_all
5100: Where header_id = p_x_line_tbl(I).header_id
5101: And ato_line_id = p_x_line_tbl(I).ato_line_id
5102: And item_type_code = OE_GLOBALS.G_ITEM_CONFIG;
5103:

Line 5388: from oe_order_lines

5384: source_document_line_id, source_document_type_id, header_id
5385: into l_order_source_id, l_orig_sys_document_ref, l_orig_sys_line_ref,
5386: l_orig_sys_shipment_ref, l_change_sequence, l_source_document_id,
5387: l_source_document_line_id, l_source_document_type_id, l_header_id
5388: from oe_order_lines
5389: where line_id = p_line_id;
5390: END IF;
5391:
5392: OE_MSG_PUB.set_msg_context(

Line 5693: UPDATE OE_ORDER_LINES_ALL

5689: IF p_line_rec.ato_line_id IS NOT NULL AND
5690: NOT (p_line_rec.ato_line_id = p_line_rec.line_id AND
5691: p_line_rec.item_type_code = 'OPTION') THEN
5692:
5693: UPDATE OE_ORDER_LINES_ALL
5694: SET override_atp_date_code = Null
5695: WHERE header_id = p_line_rec.header_id
5696: AND ato_line_id = p_line_rec.ato_line_id;
5697:

Line 5703: UPDATE OE_ORDER_LINES_ALL

5699: OR p_line_rec.item_type_code = 'MODEL'
5700: OR p_line_rec.item_type_code = 'KIT'
5701: THEN
5702:
5703: UPDATE OE_ORDER_LINES_ALL
5704: SET override_atp_date_code = Null
5705: WHERE header_id = p_line_rec.header_id
5706: AND link_to_line_id = p_line_rec.line_id
5707: AND item_type_code = 'INCLUDED';

Line 7889: FROM oe_order_lines

7885: l_return_status VARCHAR2(1);
7886:
7887: CURSOR ato_options IS
7888: SELECT line_id
7889: FROM oe_order_lines
7890: WHERE top_model_line_id = p_x_line_rec.top_model_line_id
7891: AND ato_line_id = p_x_line_rec.ato_line_id
7892: AND open_flag = 'Y'
7893: AND source_type_code = 'EXTERNAL';

Line 8358: Update oe_order_lines_all

8354: AND p_x_line_rec.operation = 'UPDATE' THEN
8355:
8356: IF p_x_line_rec.ship_model_complete_flag = 'Y'
8357: THEN
8358: Update oe_order_lines_all
8359: Set firm_demand_flag = p_x_line_rec.firm_demand_flag
8360: Where top_model_line_id = p_x_line_rec.top_model_line_id;
8361:
8362: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

Line 8369: Update oe_order_lines_all

8365: AND p_x_line_rec.item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
8366: OE_GLOBALS.G_ITEM_OPTION))
8367: THEN
8368:
8369: Update oe_order_lines_all
8370: Set firm_demand_flag = p_x_line_rec.firm_demand_flag
8371: Where ato_line_id = p_x_line_rec.ato_line_id;
8372:
8373: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

Line 8492: Update oe_order_lines_all

8488: oe_debug_pub.add( 'GLOBAL SHIP_set is : ' || OE_ORDER_UTIL.G_LINE_TBL (L_INDEX).line_id , 1 ) ;
8489: END IF;
8490: END IF; /*l_index is not null check*/
8491:
8492: Update oe_order_lines_all
8493: Set arrival_set_id = Null,
8494: ship_set_id = Null
8495: Where Line_id = p_x_line_rec.line_id;
8496:

Line 10099: FROM OE_ORDER_LINES_ALL

10095:
10096: BEGIN
10097: SELECT line_Id
10098: INTO l_config_id
10099: FROM OE_ORDER_LINES_ALL
10100: WHERE header_id = p_line_rec.header_id
10101: AND (ato_line_id =p_line_rec.ato_line_id OR
10102: (top_model_line_id = p_line_rec.top_model_line_id AND
10103: Ship_model_complete_flag = 'Y'))

Line 10250: FROM oe_order_lines

10246: NVL(p_line_rec.ordered_quantity, 0) > p_old_line_rec.ordered_quantity)
10247: THEN
10248: BEGIN
10249: SELECT 'Y' INTO l_found
10250: FROM oe_order_lines
10251: WHERE top_model_line_id = p_line_rec.top_model_line_id
10252: AND override_atp_date_code = 'Y'
10253: AND rownum <2;
10254: EXCEPTION

Line 10279: FROM oe_order_lines_all

10275:
10276:
10277: SELECT count('x')
10278: INTO l_override
10279: FROM oe_order_lines_all
10280: WHERE header_id = p_line_rec.header_id
10281: AND (ship_set_id = p_line_rec.ship_set_id
10282: OR arrival_set_id = p_line_rec.arrival_set_id)
10283: AND override_atp_date_code = 'Y';

Line 10345: FROM oe_order_lines_all

10341: THEN
10342: BEGIN
10343: SELECT 'Y'
10344: INTO l_overridden
10345: FROM oe_order_lines_all
10346: WHERE header_id = p_line_rec.header_id
10347: AND line_id <> p_line_rec.line_id
10348: AND ship_set_id = p_line_rec.ship_set_id
10349: AND override_atp_date_code = 'Y'

Line 10362: FROM oe_order_lines_all

10358: THEN
10359: BEGIN
10360: SELECT 'Y'
10361: INTO l_overridden
10362: FROM oe_order_lines_all
10363: WHERE header_id = p_line_rec.header_id
10364: AND line_id <> p_line_rec.line_id
10365: AND arrival_set_id = p_line_rec.arrival_set_id
10366: AND override_atp_date_code = 'Y'

Line 10984: , OE_ORDER_LINES OL

10980: , db_model_item_id
10981: , db_line_unit_code
10982: , primary_model_qty
10983: FROM MTL_SYSTEM_ITEMS MSI
10984: , OE_ORDER_LINES OL
10985: WHERE MSI.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID
10986: AND MSI.ORGANIZATION_ID = p_ship_from_org_id
10987: AND OL.LINE_ID = p_ato_line_id ;
10988:

Line 11593: UPDATE OE_ORDER_LINES

11589: END IF;
11590: END IF; /*l_index is not null check*/
11591: END IF; /*code_release_level*/
11592:
11593: UPDATE OE_ORDER_LINES
11594: SET
11595: ship_from_org_id = p_x_line_tbl(I).ship_from_org_id
11596: ,schedule_ship_date = p_x_line_tbl(I).schedule_ship_date
11597: ,schedule_arrival_date = p_x_line_tbl(I).schedule_arrival_date

Line 11803: UPDATE OE_ORDER_LINES

11799: p_x_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
11800: p_x_line_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
11801: p_x_line_rec.lock_control := p_x_line_rec.lock_control + 1;
11802:
11803: UPDATE OE_ORDER_LINES
11804: SET
11805: ship_from_org_id = p_x_line_rec.ship_from_org_id
11806: ,schedule_ship_date = p_x_line_rec.schedule_ship_date
11807: ,schedule_arrival_date = p_x_line_rec.schedule_arrival_date

Line 12062: UPDATE OE_ORDER_LINES

12058: p_x_line_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
12059: p_x_line_rec.lock_control := p_x_line_rec.lock_control + 1;
12060:
12061: -- Pack J: Promise Date is added to the update to reflect any change to promise date
12062: UPDATE OE_ORDER_LINES
12063: SET
12064: ship_from_org_id = p_x_line_rec.ship_from_org_id
12065: ,schedule_ship_date = p_x_line_rec.schedule_ship_date
12066: ,schedule_arrival_date = p_x_line_rec.schedule_arrival_date

Line 12744: From oe_order_lines_all

12740: BEGIN
12741:
12742: Select 'Y'
12743: Into l_ato_exists
12744: From oe_order_lines_all
12745: Where line_id = l_line_rec.ato_line_id;
12746: EXCEPTION
12747:
12748: WHEN OTHERS THEN

Line 13146: From oe_order_lines_all

13142: Begin
13143:
13144: Select ato_line_id
13145: Into l_ato_line_id
13146: From oe_order_lines_all
13147: Where line_id = p_x_line_tbl(I).line_id;
13148: EXCEPTION
13149:
13150: WHEN OTHERS THEN

Line 13961: oe_order_lines table.

13957: mrp_line_tbl_type, which is table of mrp_line_rec_type.
13958: This record is created with only those fields whose values
13959: we can get back from MRP's form. We take the field values
13960: from this record and update the lines information in
13961: oe_order_lines table.
13962: -------------------------------------------------------------------------- */
13963: Procedure Update_Results_from_backlog_wb
13964: ( p_mrp_line_tbl IN mrp_line_tbl_type
13965: , x_msg_count OUT NOCOPY NUMBER

Line 14356: FROM oe_order_lines

14352: s.whse_code = (Select wh.whse_code
14353: from ic_whse_mst wh
14354: where wh.MTL_ORGANIZATION_ID = p_organisation_id) AND
14355: s.qc_grade = (SELECT preferred_grade
14356: FROM oe_order_lines
14357: WHERE line_id = p_line_id);
14358:
14359:
14360: -- Grade ctl cursor

Line 14368: FROM oe_order_lines

14364: WHERE item_id = p_item_id;
14365:
14366: Cursor c_get_grade (p_line_id number) IS
14367: SELECT preferred_grade
14368: FROM oe_order_lines
14369: WHERE line_id = p_line_id;
14370:
14371: --
14372: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 14797: FROM oe_order_lines_all

14793: P_header_id IN NUMBER DEFAULT NULL)
14794: IS
14795: CURSOR order_header_id IS
14796: SELECT header_id
14797: FROM oe_order_lines_all
14798: WHERE line_id = p_x_line_rec.line_id;
14799:
14800: l_promise_date_flag VARCHAR2(2);
14801: l_order_date_type_code VARCHAR2(15);

Line 14953: FROM OE_ORDER_LINES_ALL

14949: item_type_code,
14950: top_model_line_id,
14951: component_sequence_id,
14952: component_code
14953: FROM OE_ORDER_LINES_ALL
14954: where header_id = p_header_id AND
14955: (arrival_set_id = p_arrival_set_id OR
14956: ship_set_id = p_ship_set_id OR
14957: top_model_line_id = p_top_model_line_id OR

Line 15021: FROM oe_order_lines_all

15017: l_item_type_code,
15018: l_link_to_line_id,
15019: l_component_code,
15020: l_component_sequence_id
15021: FROM oe_order_lines_all
15022: WHERE line_id = p_line_id;
15023:
15024: l_line_id := p_line_id;
15025:

Line 15156: From oe_order_lines_all

15152: BEGIN
15153:
15154: Select line_id
15155: Into l_config_line_id
15156: From oe_order_lines_all
15157: Where ato_line_id = l_line_id
15158: And item_type_code = 'CONFIG';
15159:
15160: EXCEPTION

Line 15484: From oe_order_lines_all

15480: BEGIN
15481:
15482: Select line_id
15483: Into l_config_line_id
15484: From oe_order_lines_all
15485: Where ato_line_id = l_line_id
15486: And item_type_code = 'CONFIG';
15487:
15488: EXCEPTION