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_ALL

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 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 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 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 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 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