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 800: FROM oe_order_lines_all

796: BEGIN
797:
798: SELECT 'Y'
799: INTO l_overridden
800: FROM oe_order_lines_all
801: WHERE top_model_line_id = p_top_model_line_id
802: AND open_flag = 'Y'
803: AND override_atp_date_code = 'Y'
804: AND rownum < 2;

Line 835: FROM oe_order_lines_all

831:
832:
833: SELECT 'Y'
834: INTO l_overridden
835: FROM oe_order_lines_all
836: WHERE header_id = p_header_id
837: AND (ship_set_id = p_ship_set_id
838: OR arrival_set_id = p_arrival_set_id)
839: AND override_atp_date_code = 'Y'

Line 1234: FROM oe_order_lines_all a,

1230: IF p_set_type = 'SHIP_SET' THEN
1231:
1232: SELECT count(a.line_id)
1233: INTO l_count
1234: FROM oe_order_lines_all a,
1235: oe_order_lines_all b
1236: WHERE a.top_model_line_id = p_top_model_line_id
1237: AND a.top_model_line_id = b.top_model_line_id
1238: AND a.override_atp_date_code = 'Y'

Line 1235: oe_order_lines_all b

1231:
1232: SELECT count(a.line_id)
1233: INTO l_count
1234: FROM oe_order_lines_all a,
1235: oe_order_lines_all b
1236: WHERE a.top_model_line_id = p_top_model_line_id
1237: AND a.top_model_line_id = b.top_model_line_id
1238: AND a.override_atp_date_code = 'Y'
1239: AND b.override_atp_date_code = 'Y'

Line 1246: FROM oe_order_lines_all a,

1242: ELSIF p_set_type = 'ARRIVAL_SET' THEN
1243:
1244: SELECT count(a.line_id)
1245: INTO l_count
1246: FROM oe_order_lines_all a,
1247: oe_order_lines_all b
1248: WHERE a.top_model_line_id = p_top_model_line_id
1249: AND a.top_model_line_id = b.top_model_line_id
1250: AND a.override_atp_date_code = 'Y'

Line 1247: oe_order_lines_all b

1243:
1244: SELECT count(a.line_id)
1245: INTO l_count
1246: FROM oe_order_lines_all a,
1247: oe_order_lines_all b
1248: WHERE a.top_model_line_id = p_top_model_line_id
1249: AND a.top_model_line_id = b.top_model_line_id
1250: AND a.override_atp_date_code = 'Y'
1251: AND b.override_atp_date_code = 'Y'

Line 2000: Update oe_order_lines_all

1996: l_shipping_method_code) THEN
1997:
1998: BEGIN
1999:
2000: Update oe_order_lines_all
2001: Set shipping_method_code = l_shipping_method_code
2002: where header_id = p_line_rec.header_id
2003: and line_id = p_line_rec.line_id;
2004: EXCEPTION

Line 2960: from oe_order_lines_all

2956: --Check if the line has service
2957: BEGIN
2958: Select 'EXISTS' into
2959: l_service_exists
2960: from oe_order_lines_all
2961: where service_reference_line_id = p_x_line_rec.line_id;
2962: IF l_debug_level > 0 THEN
2963: oe_debug_pub.add( 'The line has a service line split. Do not split.' , 1 ) ;
2964: END IF;

Line 3119: update oe_order_lines_all

3115:
3116: --update the order line so that in the DB it is scheduled
3117: --doing the update later so that the default_attributes above
3118: --takes the item_id from the original line
3119: update oe_order_lines_all
3120: SET schedule_ship_date = p_atp_rec.ship_date(J),
3121: schedule_arrival_date = p_atp_rec.arrival_date(J),
3122: schedule_status_code = 'SCHEDULED',
3123: ship_from_org_id = p_atp_rec.Source_Organization_Id(J),

Line 3899: Update oe_order_lines_all

3895: -- Bug3361870 (commenting this piece of code. Not required)
3896: /* IF INV_GMI_RSV_BRANCH.Process_Branch -- INVCONV - delete this
3897: (p_organization_id => p_old_line_rec.ship_from_org_id)
3898: THEN
3899: Update oe_order_lines_all
3900: Set ordered_quantity = 0,
3901: ordered_quantity2 = 0
3902: Where line_id=p_old_line_rec.line_id;
3903: END IF; */

Line 4670: From oe_order_lines_all

4666: BEGIN
4667:
4668: Select line_id
4669: Into l_config_line_id
4670: From oe_order_lines_all
4671: Where ato_line_id = p_line_tbl(cnt).ato_line_id
4672: And item_type_code = 'CONFIG';
4673:
4674: EXCEPTION

Line 6172: From oe_order_lines_all

6168: BEGIN
6169:
6170: Select 'Y'
6171: Into l_config_exists
6172: From oe_order_lines_all
6173: Where header_id = p_x_line_tbl(I).header_id
6174: And ato_line_id = p_x_line_tbl(I).ato_line_id
6175: And item_type_code = OE_GLOBALS.G_ITEM_CONFIG;
6176:

Line 6774: UPDATE OE_ORDER_LINES_ALL

6770: IF p_line_rec.ato_line_id IS NOT NULL AND
6771: NOT (p_line_rec.ato_line_id = p_line_rec.line_id AND
6772: p_line_rec.item_type_code = 'OPTION') THEN
6773:
6774: UPDATE OE_ORDER_LINES_ALL
6775: SET override_atp_date_code = Null
6776: WHERE header_id = p_line_rec.header_id
6777: AND ato_line_id = p_line_rec.ato_line_id;
6778:

Line 6784: UPDATE OE_ORDER_LINES_ALL

6780: OR p_line_rec.item_type_code = 'MODEL'
6781: OR p_line_rec.item_type_code = 'KIT'
6782: THEN
6783:
6784: UPDATE OE_ORDER_LINES_ALL
6785: SET override_atp_date_code = Null
6786: WHERE header_id = p_line_rec.header_id
6787: AND link_to_line_id = p_line_rec.line_id
6788: AND item_type_code = 'INCLUDED';

Line 7053: l_fulfillment_base oe_order_lines_all.fulfillment_base%type;

7049: l_on_hand_qty2 NUMBER; -- INVCONV
7050: l_avail_to_reserve2 NUMBER; -- INVCONV
7051:
7052: --ER#14763609
7053: l_fulfillment_base oe_order_lines_all.fulfillment_base%type;
7054: l_secondary_uom_code mtl_system_items_b.secondary_uom_code%type;
7055: l_primary_uom_code mtl_system_items_b.primary_uom_code%type;
7056: l_on_hand_ord_qty NUMBER ;
7057: l_avail_to_reserve_ord NUMBER ;

Line 9706: Update oe_order_lines_all

9702: AND p_x_line_rec.operation = 'UPDATE' THEN
9703:
9704: IF p_x_line_rec.ship_model_complete_flag = 'Y'
9705: THEN
9706: Update oe_order_lines_all
9707: Set firm_demand_flag = p_x_line_rec.firm_demand_flag
9708: Where top_model_line_id = p_x_line_rec.top_model_line_id;
9709:
9710: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

Line 9718: Update oe_order_lines_all

9714: OE_GLOBALS.G_ITEM_OPTION,
9715: OE_GLOBALS.G_ITEM_INCLUDED)) --9775352
9716: THEN
9717:
9718: Update oe_order_lines_all
9719: Set firm_demand_flag = p_x_line_rec.firm_demand_flag
9720: Where ato_line_id = p_x_line_rec.ato_line_id;
9721:
9722: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

Line 9841: Update oe_order_lines_all

9837: oe_debug_pub.add( 'GLOBAL SHIP_set is : ' || OE_ORDER_UTIL.G_LINE_TBL (L_INDEX).line_id , 1 ) ;
9838: END IF;
9839: END IF; /*l_index is not null check*/
9840:
9841: Update oe_order_lines_all
9842: Set arrival_set_id = Null,
9843: ship_set_id = Null
9844: Where Line_id = p_x_line_rec.line_id;
9845:

Line 11681: FROM OE_ORDER_LINES_ALL

11677:
11678: BEGIN
11679: SELECT line_Id
11680: INTO l_config_id
11681: FROM OE_ORDER_LINES_ALL
11682: WHERE header_id = p_line_rec.header_id
11683: AND (ato_line_id =p_line_rec.ato_line_id OR
11684: (top_model_line_id = p_line_rec.top_model_line_id AND
11685: Ship_model_complete_flag = 'Y'))

Line 11861: FROM oe_order_lines_all

11857:
11858:
11859: SELECT count('x')
11860: INTO l_override
11861: FROM oe_order_lines_all
11862: WHERE header_id = p_line_rec.header_id
11863: AND (ship_set_id = p_line_rec.ship_set_id
11864: OR arrival_set_id = p_line_rec.arrival_set_id)
11865: AND override_atp_date_code = 'Y';

Line 11927: FROM oe_order_lines_all

11923: THEN
11924: BEGIN
11925: SELECT 'Y'
11926: INTO l_overridden
11927: FROM oe_order_lines_all
11928: WHERE header_id = p_line_rec.header_id
11929: AND line_id <> p_line_rec.line_id
11930: AND ship_set_id = p_line_rec.ship_set_id
11931: AND override_atp_date_code = 'Y'

Line 11944: FROM oe_order_lines_all

11940: THEN
11941: BEGIN
11942: SELECT 'Y'
11943: INTO l_overridden
11944: FROM oe_order_lines_all
11945: WHERE header_id = p_line_rec.header_id
11946: AND line_id <> p_line_rec.line_id
11947: AND arrival_set_id = p_line_rec.arrival_set_id
11948: AND override_atp_date_code = 'Y'

Line 12416: FROM OE_ORDER_LINES_ALL

12412: AND p_sch_action IN (OESCH_ACT_RESCHEDULE,OESCH_ACT_RESERVE) THEN
12413:
12414: SELECT shipping_interfaced_flag,firm_demand_flag,lock_control
12415: INTO l_shipping_interfaced_flag,l_firm_demand_flag,l_lock_control
12416: FROM OE_ORDER_LINES_ALL
12417: WHERE LINE_ID=p_x_line_rec.line_id;
12418:
12419: p_x_line_rec.shipping_interfaced_flag := l_shipping_interfaced_flag;
12420: p_x_line_rec.firm_demand_flag := l_firm_demand_flag;

Line 14040: l_fulfillment_base oe_order_lines_all.fulfillment_base%type;

14036: l_on_hand_qty2 NUMBER; -- INVCONV
14037: l_avail_to_reserve2 NUMBER; -- invconv
14038: l_process_flag VARCHAR2(1) := FND_API.G_FALSE;
14039: --ER#14763609
14040: l_fulfillment_base oe_order_lines_all.fulfillment_base%type;
14041: l_secondary_uom_code mtl_system_items_b.secondary_uom_code%type;
14042: l_primary_uom_code mtl_system_items_b.primary_uom_code%type;
14043: l_on_hand_ord_qty NUMBER ;
14044: l_avail_to_reserve_ord NUMBER ;

Line 14169: FROM oe_order_lines_all

14165: END IF;
14166:
14167: SELECT Nvl(fulfillment_base,'P')
14168: INTO l_fulfillment_base
14169: FROM oe_order_lines_all
14170: WHERE line_id = g_atp_tbl(K).line_id;
14171: IF l_debug_level > 0 THEN
14172: oe_debug_pub.add( '2. fulfillment_base: '|| l_fulfillment_base , 1 ) ;
14173: END IF;

Line 14587: From oe_order_lines_all

14583: BEGIN
14584:
14585: Select 'Y'
14586: Into l_ato_exists
14587: From oe_order_lines_all
14588: Where line_id = l_line_rec.ato_line_id;
14589: EXCEPTION
14590:
14591: WHEN OTHERS THEN

Line 15160: From oe_order_lines_all

15156: Begin
15157:
15158: Select ato_line_id
15159: Into l_ato_line_id
15160: From oe_order_lines_all
15161: Where line_id = p_x_line_tbl(I).line_id;
15162: EXCEPTION
15163:
15164: WHEN OTHERS THEN

Line 15691: FROM OE_ORDER_LINES_ALL

15687: END IF;
15688: SELECT schedule_ship_date,schedule_arrival_date,ship_from_org_id
15689: INTO p_x_line_tbl(I).schedule_ship_date,p_x_line_tbl(I).schedule_arrival_date,
15690: p_x_line_tbl(I).ship_from_org_id
15691: FROM OE_ORDER_LINES_ALL
15692: WHERE line_id=p_x_line_tbl(I).line_id;
15693: END IF;
15694: END LOOP;
15695: FOR I in 1..p_x_line_tbl.count LOOP

Line 15704: FROM OE_ORDER_LINES_ALL

15700: oe_debug_pub.add( 'LINE: ' || P_X_LINE_TBL ( I ) .LINE_ID , 1 ) ;
15701: END IF;
15702: SELECT schedule_ship_date,schedule_arrival_date,ship_from_org_id
15703: INTO p_x_line_tbl(I).schedule_ship_date,p_x_line_tbl(I).schedule_arrival_date,p_x_line_tbl(I).ship_from_org_id
15704: FROM OE_ORDER_LINES_ALL
15705: WHERE line_id=p_x_line_tbl(I).line_id;
15706: END IF;
15707: */
15708: IF p_x_line_tbl(I).operation = OE_GLOBALS.G_OPR_UPDATE AND

Line 17343: FROM oe_order_lines_all

17339: P_header_id IN NUMBER DEFAULT NULL)
17340: IS
17341: CURSOR order_header_id IS
17342: SELECT header_id
17343: FROM oe_order_lines_all
17344: WHERE line_id = p_x_line_rec.line_id;
17345:
17346: l_promise_date_flag VARCHAR2(2);
17347: l_order_date_type_code VARCHAR2(15);

Line 17500: FROM OE_ORDER_LINES_ALL

17496: item_type_code,
17497: top_model_line_id,
17498: component_sequence_id,
17499: component_code
17500: FROM OE_ORDER_LINES_ALL
17501: where header_id = p_header_id AND
17502: (arrival_set_id = p_arrival_set_id OR
17503: ship_set_id = p_ship_set_id OR
17504: top_model_line_id = p_top_model_line_id OR

Line 17568: FROM oe_order_lines_all

17564: l_item_type_code,
17565: l_link_to_line_id,
17566: l_component_code,
17567: l_component_sequence_id
17568: FROM oe_order_lines_all
17569: WHERE line_id = p_line_id;
17570:
17571: l_line_id := p_line_id;
17572:

Line 17703: From oe_order_lines_all

17699: BEGIN
17700:
17701: Select line_id
17702: Into l_config_line_id
17703: From oe_order_lines_all
17704: Where ato_line_id = l_line_id
17705: And item_type_code = 'CONFIG';
17706:
17707: EXCEPTION

Line 18032: From oe_order_lines_all

18028: BEGIN
18029:
18030: Select line_id
18031: Into l_config_line_id
18032: From oe_order_lines_all
18033: Where ato_line_id = l_line_id
18034: And item_type_code = 'CONFIG';
18035:
18036: EXCEPTION

Line 18585: --Bug 8652339 : Initialize l_line_tbl from OE_ORDER_LINES_ALL table

18581: l_line_rec OE_Order_PUB.Line_Rec_Type; --Bug 8652339
18582: BEGIN
18583: oe_debug_pub.add( '6663462 : in schedule_delayed_lines ');
18584:
18585: --Bug 8652339 : Initialize l_line_tbl from OE_ORDER_LINES_ALL table
18586: --using OE_LINE_UTIL.QUERY_ROW instead of following.
18587: --l_line_tbl := OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl;
18588: for j in 1..OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl.count loop
18589: