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 744: from oe_order_lines

740: service_period,
741: service_duration,
742: service_coterminate_flag,
743: item_type_code -- this one added for 2417601
744: from oe_order_lines
745: where line_id = l_line_rec.line_id;
746: --
747: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
748: --

Line 962: UPDATE OE_ORDER_LINES_ALL

958: -- notification framework end
959: END IF; /* aso installed*/
960:
961:
962: UPDATE OE_ORDER_LINES_ALL
963: SET FULFILLED_FLAG = 'Y',
964: FULFILLED_QUANTITY = l_fulfilled_quantity,
965: FULFILLED_QUANTITY2 = l_fulfilled_quantity2, -- 5126873
966: FULFILLMENT_DATE = SYSDATE,

Line 1207: UPDATE OE_ORDER_LINES_ALL

1203: IF p_line_tbl(l_index).item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN --3471423
1204: /* 2417601 uses a different update statements for service line */
1205:
1206:
1207: UPDATE OE_ORDER_LINES_ALL
1208: SET FULFILLED_FLAG = p_line_tbl(l_index).fulfilled_flag,
1209: FULFILLED_QUANTITY = p_line_tbl(l_index).fulfilled_quantity,
1210: FULFILLED_QUANTITY2 = p_line_tbl(l_index).fulfilled_quantity2, -- 5126873
1211: FULFILLMENT_DATE = p_line_tbl(l_index).fulfillment_date,

Line 1255: UPDATE OE_ORDER_LINES_ALL

1251:
1252:
1253: ELSE -- 2417601
1254:
1255: UPDATE OE_ORDER_LINES_ALL
1256: SET FULFILLED_FLAG = p_line_tbl(l_index).fulfilled_flag,
1257: FULFILLED_QUANTITY = p_line_tbl(l_index).fulfilled_quantity,
1258: FULFILLED_QUANTITY2 = p_line_tbl(l_index).fulfilled_quantity2, -- 5126873
1259: FULFILLMENT_DATE = p_line_tbl(l_index).fulfillment_date,

Line 1532: FROM oe_order_lines

1528: /*
1529: -- Bug-2791964
1530: SELECT nvl(upgraded_flag,'N')
1531: INTO l_upgraded_flag
1532: FROM oe_order_lines
1533: WHERE line_id = to_number(p_item_key);
1534:
1535: IF l_upgraded_flag = 'N' THEN
1536: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1817: from oe_order_lines_all

1813: END IF;
1814:
1815:
1816: select line_category_code into l_line_category_code
1817: from oe_order_lines_all
1818: where line_id = to_number(p_item_key);
1819:
1820: IF l_line_category_code = 'RETURN' THEN
1821: l_fulfill_attr_name := l_in_fulfill_attr_name;

Line 1906: FROM oe_order_lines

1902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1903: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1904: SELECT nvl(upgraded_flag,'N') -- Bug 3589692
1905: INTO l_upgraded_flag
1906: FROM oe_order_lines
1907: WHERE line_id = to_number(p_item_key);
1908: IF l_upgraded_flag = 'N' THEN
1909: RAISE FND_API.G_EXC_ERROR;
1910: ELSE

Line 1982: FROM OE_ORDER_LINES

1978:
1979: CURSOR C_lines IS
1980: SELECT LINE_ID,
1981: FULFILLED_FLAG
1982: FROM OE_ORDER_LINES
1983: WHERE TOP_MODEL_LINE_ID = l_top_model_line_id
1984: AND OPEN_FLAG = 'Y';
1985:
1986: l_activity_status VARCHAR2(8);

Line 2109: FROM OE_ORDER_LINES

2105: CURSOR C_fulfill_lines IS
2106: SELECT LINE_ID,
2107: HEADER_ID,
2108: FULFILLED_FLAG
2109: FROM OE_ORDER_LINES
2110: WHERE TOP_MODEL_LINE_ID = l_top_model_line_id
2111: AND OPEN_FLAG = 'Y';
2112: BEGIN
2113:

Line 2152: update oe_order_lines

2148:
2149: 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));
2150: -- end CHANGES for AFD
2151:
2152: update oe_order_lines
2153: set fulfilled_flag = l_line_tbl(1).fulfilled_flag,
2154: fulfilled_quantity = l_line_tbl(1).fulfilled_quantity,
2155: fulfillment_date = l_line_tbl(1).fulfillment_date,
2156: actual_fulfillment_date = l_line_tbl(1).actual_fulfillment_date,

Line 2386: FROM OE_ORDER_LINES

2382: l_fulfill_service_index NUMBER :=0;
2383:
2384: CURSOR pto_kit_lines IS
2385: SELECT line_id, item_type_code, shippable_flag, fulfilled_flag
2386: FROM OE_ORDER_LINES
2387: WHERE top_model_line_id = p_top_model_line_id
2388: AND open_flag = 'Y';
2389: --
2390: BEGIN

Line 2413: FROM oe_order_lines

2409: IF NVL(FND_PROFILE.VALUE('ONT_ALLOW_MODEL_FULFILL_WITHOUT_CONFIG'),'N') = 'N' THEN
2410:
2411: SELECT count(*)
2412: INTO l_count
2413: FROM oe_order_lines
2414: WHERE top_model_line_id = p_line_id;
2415:
2416:
2417: IF l_count = 1 THEN

Line 2421: FROM oe_order_lines

2417: IF l_count = 1 THEN
2418:
2419: SELECT item_type_code,ato_line_id
2420: INTO l_item_type_code,l_ato_line_id
2421: FROM oe_order_lines
2422: WHERE line_id = p_line_id;
2423:
2424: IF l_debug_level > 0 THEN
2425: oe_debug_pub.add('No child lines yet for the model' , 1 ) ;

Line 2510: FROM oe_order_lines

2506: IF p_top_model_line_id is not NULL then
2507:
2508: SELECT item_type_code,ato_line_id
2509: INTO l_item_type_code,l_ato_line_id
2510: FROM oe_order_lines
2511: WHERE line_id = p_line_id;
2512:
2513: IF l_Debug_level > 0 THEN
2514: 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 2904: FROM OE_ORDER_LINES_ALL

2900: INVENTORY_ITEM_ID,
2901: -- changes for AFD
2902: ACTUAL_SHIPMENT_DATE,
2903: ORDER_FIRMED_DATE
2904: FROM OE_ORDER_LINES_ALL
2905: WHERE LINE_ID = l_cursor_line_id;
2906:
2907: --
2908: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2993: FROM OE_ORDER_LINES

2989: -- l_line_rec := OE_Line_Util.Query_Row(p_line_id);
2990:
2991: SELECT TOP_MODEL_LINE_ID
2992: INTO l_top_model_line_id
2993: FROM OE_ORDER_LINES
2994: WHERE LINE_ID = p_line_id;
2995:
2996:
2997: IF l_top_model_line_id = nvl(l_process_tbl(l_line_set_index).line_id,0) THEN

Line 3290: FROM OE_ORDER_LINES

3286:
3287: /*
3288: SELECT HEADER_ID
3289: INTO l_header_id
3290: FROM OE_ORDER_LINES
3291: WHERE LINE_ID = l_line_tbl(l_line_tbl_index);
3292: */
3293: OE_Order_WF_Util.Update_Flow_Status_Code
3294: (p_line_id => l_line_tbl(l_line_tbl_index),

Line 3549: FROM oe_order_lines

3545: END IF;
3546:
3547: SELECT line_id, top_model_line_id
3548: INTO l_line_id, l_top_model_line_id
3549: FROM oe_order_lines
3550: WHERE line_id = l_line_rec.top_model_line_id
3551: FOR UPDATE NOWAIT;
3552:
3553: IF l_debug_level > 0 THEN

Line 3569: FROM oe_order_lines

3565: /* First lock the product */
3566:
3567: SELECT top_model_line_id
3568: INTO l_top_model_line_id
3569: FROM oe_order_lines
3570: WHERE line_id = l_line_rec.service_reference_line_id
3571: FOR UPDATE NOWAIT;
3572:
3573: IF nvl(l_top_model_line_id,0) <> 0 THEN

Line 3580: FROM oe_order_lines

3576: END IF;
3577:
3578: SELECT line_id
3579: INTO l_line_id
3580: FROM oe_order_lines
3581: WHERE line_id = l_top_model_line_id
3582: FOR UPDATE NOWAIT;
3583:
3584: ELSE

Line 3590: FROM oe_order_lines

3586: oe_debug_pub.add('locking the parent reference line of this service line '||L_TOP_MODEL_LINE_ID,1);
3587: END IF;
3588: SELECT line_id
3589: INTO l_line_id
3590: FROM oe_order_lines
3591: WHERE line_id = l_line_rec.service_reference_line_id
3592: FOR UPDATE NOWAIT;
3593:
3594: END IF;

Line 3601: FROM oe_order_lines

3597: END IF;
3598:
3599: SELECT line_id
3600: INTO l_line_id
3601: FROM oe_order_lines
3602: WHERE line_id = l_line_rec.line_id
3603: FOR UPDATE NOWAIT;
3604:
3605: IF l_debug_level > 0 THEN

Line 3616: FROM oe_order_lines

3612: END IF;
3613:
3614: SELECT line_id
3615: INTO l_line_id
3616: FROM oe_order_lines
3617: WHERE line_id = l_line_rec.line_id
3618: FOR UPDATE NOWAIT;
3619:
3620: IF l_debug_level > 0 THEN

Line 3786: FROM oe_order_lines

3782:
3783: -- Bug-2376255
3784: SELECT fulfilled_flag
3785: INTO l_fulfilled_flag
3786: FROM oe_order_lines
3787: WHERE Line_id = l_line_rec.line_id;
3788:
3789:
3790:

Line 4280: FROM oe_order_lines

4276: SELECT fulfilled_flag,
4277: header_id -- 1717444
4278: INTO l_fulfilled_flag,
4279: l_ref_header_id -- 1717444
4280: FROM oe_order_lines
4281: WHERE line_id = l_line_rec.service_reference_line_id;
4282:
4283: IF l_debug_level > 0 THEN
4284: oe_debug_pub.add( 'PRODUCT LINE FULFILLED : '||L_FULFILLED_FLAG , 3 ) ;

Line 4602: FROM OE_ORDER_LINES

4598: SELECT TOP_MODEL_LINE_ID,
4599: MODEL_REMNANT_FLAG
4600: INTO l_store_top,
4601: l_store_rem
4602: FROM OE_ORDER_LINES
4603: WHERE LINE_ID = p_line_id;
4604:
4605:
4606: IF l_store_top IS NOT NULL AND

Line 4654: oe_order_lines ol

4650: into l_howmany
4651: from oe_line_sets l1,
4652: oe_line_sets l2,
4653: oe_sets s1,
4654: oe_order_lines ol
4655: where l1.line_id <> p_line_id
4656: and l1.set_id = s1.set_id
4657: and s1.set_type = 'FULFILLMENT_SET'
4658: and s1.set_id <> l_set_id

Line 4681: oe_order_lines ol

4677: from oe_line_sets l1,
4678: oe_line_sets l2,
4679: oe_line_sets l3,
4680: oe_sets s1,
4681: oe_order_lines ol
4682: where l1.line_id = p_line_id
4683: and l1.set_id = s1.set_id
4684: and s1.set_type = 'FULFILLMENT_SET'
4685: and s1.set_id <> l_set_id

Line 4748: FROM OE_ORDER_LINES

4744: SELECT TOP_MODEL_LINE_ID,
4745: MODEL_REMNANT_FLAG
4746: INTO l_top_model_line_id,
4747: l_model_remnant_flag
4748: FROM OE_ORDER_LINES
4749: WHERE LINE_ID = l_set_tbl(l_set_index).line_id;
4750:
4751: IF l_top_model_line_id IS NULL OR
4752: l_top_model_line_id = l_set_tbl(l_set_index).line_id OR

Line 5047: FROM OE_ORDER_LINES

5043: /* Fix for 2560644 */
5044:
5045: SELECT fulfilled_flag
5046: INTO l_fulfilled_flag
5047: FROM OE_ORDER_LINES
5048: WHERE LINE_ID = l_ful_set_tbl(l_ful_set_index).line_id;
5049:
5050: /* If the line is not fulfilled set the fulfillment related
5051: attributes for the line before it goes beyond FULFILL_LINE */

Line 5284: FROM OE_ORDER_LINES

5280: /* Fix for 2560644 */
5281:
5282: SELECT fulfilled_flag
5283: INTO l_fulfilled_flag
5284: FROM OE_ORDER_LINES
5285: WHERE LINE_ID = p_line_id;
5286:
5287: /* If the line is not fulfilled set the fulfillment related
5288: attributes for the line before it goes beyond FULFILL_LINE */

Line 5326: FROM OE_ORDER_LINES

5322: -- l_line_rec := OE_Line_Util.Query_Row(p_line_id);
5323: /*
5324: SELECT HEADER_ID
5325: INTO l_header_id
5326: FROM OE_ORDER_LINES
5327: WHERE LINE_ID = p_line_id;
5328: */
5329: OE_Order_WF_Util.Update_Flow_Status_Code
5330: (p_line_id => p_line_Id,