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

Line 296: FROM OE_ORDER_LINES_ALL

292: UNIT_SELLING_PRICE,
293: INVENTORY_ITEM_ID,
294: ORDER_FIRMED_DATE,
295: ACTUAL_SHIPMENT_DATE
296: FROM OE_ORDER_LINES_ALL
297: WHERE SERVICE_REFERENCE_LINE_ID = p_line_id
298: AND SERVICE_REFERENCE_TYPE_CODE = 'ORDER' -- added in 115.46
299: AND HEADER_ID = l_header_id -- 1717444
300: AND TOP_MODEL_LINE_ID IS NULL; --3449588

Line 312: FROM oe_order_lines

308: IF p_header_id IS NULL OR -- This IF introduced for 1717444
309: p_header_id = FND_API.G_MISS_NUM THEN
310: SELECT header_id
311: INTO l_header_id
312: FROM oe_order_lines
313: WHERE line_id = p_line_id;
314: ELSE
315: l_header_id := p_header_id;
316: END IF;

Line 478: FROM oe_order_lines

474:
475: --5699215
476: SELECT fulfilled_quantity
477: INTO l_parent_line_fulfilled_qty
478: FROM oe_order_lines
479: WHERE line_id = p_line_id;
480: --5699215
481:
482: /* Add service lines to l_fulfill_tbl for fulfillment */

Line 750: from oe_order_lines

746: service_period,
747: service_duration,
748: service_coterminate_flag,
749: item_type_code -- this one added for 2417601
750: from oe_order_lines
751: where line_id = l_line_rec.line_id;
752: --
753: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
754: --

Line 983: UPDATE OE_ORDER_LINES_ALL

979: -- notification framework end
980: END IF; /* aso installed*/
981:
982:
983: UPDATE OE_ORDER_LINES_ALL
984: SET FULFILLED_FLAG = 'Y',
985: FULFILLED_QUANTITY = l_fulfilled_quantity,
986: FULFILLED_QUANTITY2 = l_fulfilled_quantity2, -- 5126873
987: FULFILLMENT_DATE = SYSDATE,

Line 1268: UPDATE OE_ORDER_LINES_ALL

1264: OR p_line_tbl(l_index).subscription_enable_flag = 'Y' THEN -- sol_ord_er #16014165 (for Model)
1265: /* 2417601 uses a different update statements for service line */
1266:
1267:
1268: UPDATE OE_ORDER_LINES_ALL
1269: SET FULFILLED_FLAG = p_line_tbl(l_index).fulfilled_flag,
1270: FULFILLED_QUANTITY = p_line_tbl(l_index).fulfilled_quantity,
1271: FULFILLED_QUANTITY2 = p_line_tbl(l_index).fulfilled_quantity2, -- 5126873
1272: FULFILLMENT_DATE = p_line_tbl(l_index).fulfillment_date,

Line 1331: UPDATE OE_ORDER_LINES_ALL

1327:
1328:
1329: ELSE -- 2417601
1330:
1331: UPDATE OE_ORDER_LINES_ALL
1332: SET FULFILLED_FLAG = p_line_tbl(l_index).fulfilled_flag,
1333: FULFILLED_QUANTITY = p_line_tbl(l_index).fulfilled_quantity,
1334: FULFILLED_QUANTITY2 = p_line_tbl(l_index).fulfilled_quantity2, -- 5126873
1335: FULFILLMENT_DATE = p_line_tbl(l_index).fulfillment_date,

Line 1613: FROM oe_order_lines

1609: /*
1610: -- Bug-2791964
1611: SELECT nvl(upgraded_flag,'N')
1612: INTO l_upgraded_flag
1613: FROM oe_order_lines
1614: WHERE line_id = to_number(p_item_key);
1615:
1616: IF l_upgraded_flag = 'N' THEN
1617: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1904: from oe_order_lines_all

1900: END IF;
1901:
1902:
1903: select line_category_code into l_line_category_code
1904: from oe_order_lines_all
1905: where line_id = to_number(p_item_key);
1906:
1907: IF l_line_category_code = 'RETURN' THEN
1908: l_fulfill_attr_name := l_in_fulfill_attr_name;

Line 1993: FROM oe_order_lines

1989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1990: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1991: SELECT nvl(upgraded_flag,'N') -- Bug 3589692
1992: INTO l_upgraded_flag
1993: FROM oe_order_lines
1994: WHERE line_id = to_number(p_item_key);
1995: IF l_upgraded_flag = 'N' THEN
1996: RAISE FND_API.G_EXC_ERROR;
1997: ELSE

Line 2069: FROM OE_ORDER_LINES

2065:
2066: CURSOR C_lines IS
2067: SELECT LINE_ID,
2068: FULFILLED_FLAG
2069: FROM OE_ORDER_LINES
2070: WHERE TOP_MODEL_LINE_ID = l_top_model_line_id
2071: AND OPEN_FLAG = 'Y';
2072:
2073: l_activity_status VARCHAR2(8);

Line 2202: FROM OE_ORDER_LINES

2198: CURSOR C_fulfill_lines IS
2199: SELECT LINE_ID,
2200: HEADER_ID,
2201: FULFILLED_FLAG
2202: FROM OE_ORDER_LINES
2203: WHERE TOP_MODEL_LINE_ID = l_top_model_line_id
2204: AND OPEN_FLAG = 'Y';
2205: BEGIN
2206:

Line 2245: update oe_order_lines

2241:
2242: l_line_tbl(1).actual_fulfillment_date := nvl(l_line_tbl(1).actual_shipment_date,nvl(l_line_tbl(1).order_firmed_date,l_ordered_date));
2243: -- end CHANGES for AFD
2244:
2245: update oe_order_lines
2246: set fulfilled_flag = l_line_tbl(1).fulfilled_flag,
2247: fulfilled_quantity = l_line_tbl(1).fulfilled_quantity,
2248: fulfillment_date = l_line_tbl(1).fulfillment_date,
2249: actual_fulfillment_date = l_line_tbl(1).actual_fulfillment_date,

Line 2514: FROM OE_ORDER_LINES

2510: l_fulfill_service_index NUMBER :=0;
2511:
2512: CURSOR pto_kit_lines IS
2513: SELECT line_id, item_type_code, shippable_flag, fulfilled_flag
2514: FROM OE_ORDER_LINES
2515: WHERE top_model_line_id = p_top_model_line_id
2516: AND open_flag = 'Y';
2517: --
2518: BEGIN

Line 2541: FROM oe_order_lines

2537: IF NVL(FND_PROFILE.VALUE('ONT_ALLOW_MODEL_FULFILL_WITHOUT_CONFIG'),'N') = 'N' THEN
2538:
2539: SELECT count(*)
2540: INTO l_count
2541: FROM oe_order_lines
2542: WHERE top_model_line_id = p_line_id;
2543:
2544:
2545: IF l_count = 1 THEN

Line 2549: FROM oe_order_lines

2545: IF l_count = 1 THEN
2546:
2547: SELECT item_type_code,ato_line_id
2548: INTO l_item_type_code,l_ato_line_id
2549: FROM oe_order_lines
2550: WHERE line_id = p_line_id;
2551:
2552: IF l_debug_level > 0 THEN
2553: oe_debug_pub.add('No child lines yet for the model' , 1 ) ;

Line 2638: FROM oe_order_lines

2634: IF p_top_model_line_id is not NULL then
2635:
2636: SELECT item_type_code,ato_line_id
2637: INTO l_item_type_code,l_ato_line_id
2638: FROM oe_order_lines
2639: WHERE line_id = p_line_id;
2640:
2641: IF l_Debug_level > 0 THEN
2642: oe_Debug_pub.add('item type '||l_item_type_code||','||l_ato_line_id||','||l_fulfilled_flag||','||p_line_id||','||p_top_model_line_id,1);

Line 3058: FROM OE_ORDER_LINES_ALL

3054: INVENTORY_ITEM_ID,
3055: -- changes for AFD
3056: ACTUAL_SHIPMENT_DATE,
3057: ORDER_FIRMED_DATE
3058: FROM OE_ORDER_LINES_ALL
3059: WHERE LINE_ID = l_cursor_line_id;
3060:
3061: --
3062: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3157: FROM OE_ORDER_LINES

3153: -- l_line_rec := OE_Line_Util.Query_Row(p_line_id);
3154:
3155: SELECT TOP_MODEL_LINE_ID
3156: INTO l_top_model_line_id
3157: FROM OE_ORDER_LINES
3158: WHERE LINE_ID = p_line_id;
3159:
3160:
3161: IF l_top_model_line_id = nvl(l_process_tbl(l_line_set_index).line_id,0) THEN

Line 3463: FROM OE_ORDER_LINES

3459:
3460: /*
3461: SELECT HEADER_ID
3462: INTO l_header_id
3463: FROM OE_ORDER_LINES
3464: WHERE LINE_ID = l_line_tbl(l_line_tbl_index);
3465: */
3466: OE_Order_WF_Util.Update_Flow_Status_Code
3467: (p_line_id => l_line_tbl(l_line_tbl_index),

Line 3736: FROM oe_order_lines

3732: END IF;
3733:
3734: SELECT line_id, top_model_line_id
3735: INTO l_line_id, l_top_model_line_id
3736: FROM oe_order_lines
3737: WHERE line_id = l_line_rec.top_model_line_id
3738: FOR UPDATE NOWAIT;
3739:
3740: IF l_debug_level > 0 THEN

Line 3756: FROM oe_order_lines

3752: /* First lock the product */
3753:
3754: SELECT top_model_line_id
3755: INTO l_top_model_line_id
3756: FROM oe_order_lines
3757: WHERE line_id = l_line_rec.service_reference_line_id
3758: FOR UPDATE NOWAIT;
3759:
3760: IF nvl(l_top_model_line_id,0) <> 0 THEN

Line 3767: FROM oe_order_lines

3763: END IF;
3764:
3765: SELECT line_id
3766: INTO l_line_id
3767: FROM oe_order_lines
3768: WHERE line_id = l_top_model_line_id
3769: FOR UPDATE NOWAIT;
3770:
3771: ELSE

Line 3777: FROM oe_order_lines

3773: oe_debug_pub.add('locking the parent reference line of this service line '||L_TOP_MODEL_LINE_ID,1);
3774: END IF;
3775: SELECT line_id
3776: INTO l_line_id
3777: FROM oe_order_lines
3778: WHERE line_id = l_line_rec.service_reference_line_id
3779: FOR UPDATE NOWAIT;
3780:
3781: END IF;

Line 3788: FROM oe_order_lines

3784: END IF;
3785:
3786: SELECT line_id
3787: INTO l_line_id
3788: FROM oe_order_lines
3789: WHERE line_id = l_line_rec.line_id
3790: FOR UPDATE NOWAIT;
3791:
3792: IF l_debug_level > 0 THEN

Line 3803: FROM oe_order_lines

3799: END IF;
3800:
3801: SELECT line_id
3802: INTO l_line_id
3803: FROM oe_order_lines
3804: WHERE line_id = l_line_rec.line_id
3805: FOR UPDATE NOWAIT;
3806:
3807: IF l_debug_level > 0 THEN

Line 3975: FROM oe_order_lines

3971:
3972: -- Bug-2376255
3973: SELECT fulfilled_flag
3974: INTO l_fulfilled_flag
3975: FROM oe_order_lines
3976: WHERE Line_id = l_line_rec.line_id;
3977:
3978:
3979:

Line 4487: FROM oe_order_lines

4483: SELECT fulfilled_flag,
4484: header_id -- 1717444
4485: INTO l_fulfilled_flag,
4486: l_ref_header_id -- 1717444
4487: FROM oe_order_lines
4488: WHERE line_id = l_line_rec.service_reference_line_id;
4489:
4490: IF l_debug_level > 0 THEN
4491: oe_debug_pub.add( 'PRODUCT LINE FULFILLED : '||L_FULFILLED_FLAG , 3 ) ;

Line 4638: FROM oe_order_lines_all

4634: called in this cas and the record is still unlocked */
4635: BEGIN
4636: SELECT '1'
4637: INTO l_dummy
4638: FROM oe_order_lines_all
4639: WHERE line_id = l_line_rec.line_id
4640: FOR update nowait;
4641: EXCEPTION
4642: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

Line 4833: FROM OE_ORDER_LINES

4829: SELECT TOP_MODEL_LINE_ID,
4830: MODEL_REMNANT_FLAG
4831: INTO l_store_top,
4832: l_store_rem
4833: FROM OE_ORDER_LINES
4834: WHERE LINE_ID = p_line_id;
4835:
4836:
4837: IF l_store_top IS NOT NULL AND

Line 4885: oe_order_lines ol

4881: into l_howmany
4882: from oe_line_sets l1,
4883: oe_line_sets l2,
4884: oe_sets s1,
4885: oe_order_lines ol
4886: where l1.line_id <> p_line_id
4887: and l1.set_id = s1.set_id
4888: and s1.set_type = 'FULFILLMENT_SET'
4889: and s1.set_id <> l_set_id

Line 4912: oe_order_lines ol

4908: from oe_line_sets l1,
4909: oe_line_sets l2,
4910: oe_line_sets l3,
4911: oe_sets s1,
4912: oe_order_lines ol
4913: where l1.line_id = p_line_id
4914: and l1.set_id = s1.set_id
4915: and s1.set_type = 'FULFILLMENT_SET'
4916: and s1.set_id <> l_set_id

Line 4979: FROM OE_ORDER_LINES

4975: SELECT TOP_MODEL_LINE_ID,
4976: MODEL_REMNANT_FLAG
4977: INTO l_top_model_line_id,
4978: l_model_remnant_flag
4979: FROM OE_ORDER_LINES
4980: WHERE LINE_ID = l_set_tbl(l_set_index).line_id;
4981:
4982: IF l_top_model_line_id IS NULL OR
4983: l_top_model_line_id = l_set_tbl(l_set_index).line_id OR

Line 5282: FROM OE_ORDER_LINES

5278: /* Fix for 2560644 */
5279:
5280: SELECT fulfilled_flag
5281: INTO l_fulfilled_flag
5282: FROM OE_ORDER_LINES
5283: WHERE LINE_ID = l_ful_set_tbl(l_ful_set_index).line_id;
5284:
5285: /* If the line is not fulfilled set the fulfillment related
5286: attributes for the line before it goes beyond FULFILL_LINE */

Line 5525: FROM OE_ORDER_LINES

5521: /* Fix for 2560644 */
5522:
5523: SELECT fulfilled_flag
5524: INTO l_fulfilled_flag
5525: FROM OE_ORDER_LINES
5526: WHERE LINE_ID = p_line_id;
5527:
5528: /* If the line is not fulfilled set the fulfillment related
5529: attributes for the line before it goes beyond FULFILL_LINE */

Line 5567: FROM OE_ORDER_LINES

5563: -- l_line_rec := OE_Line_Util.Query_Row(p_line_id);
5564: /*
5565: SELECT HEADER_ID
5566: INTO l_header_id
5567: FROM OE_ORDER_LINES
5568: WHERE LINE_ID = p_line_id;
5569: */
5570: OE_Order_WF_Util.Update_Flow_Status_Code
5571: (p_line_id => p_line_Id,