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_UTIL dependencies on OE_ORDER_LINES_ALL

Line 91: l_hook_pricing_uom OE_ORDER_LINES_ALL.PRICING_QUANTITY_UOM%TYPE;

87: RETURN VARCHAR2
88: IS
89:
90: l_item_rec OE_ORDER_CACHE.ITEM_REC_TYPE;
91: l_hook_pricing_uom OE_ORDER_LINES_ALL.PRICING_QUANTITY_UOM%TYPE;
92: l_primary_catch_weight VARCHAR2(1) := NULL;
93: l_secondary_catch_weight VARCHAR2(1) := NULL;
94: l_ref_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
95: TYPE uom_class_tbl IS TABLE of MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE index by MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

Line 369: from oe_order_lines_all

365:
366: begin
367: select header_id
368: into l_header_id
369: from oe_order_lines_all
370: where line_id = p_line_id;
371: exception when no_data_found then
372: null;
373: end;

Line 3732: FROM OE_ORDER_LINES_ALL

3728: THEN
3729: BEGIN
3730: SELECT calculate_price_flag
3731: INTO l_orig_line_calc_price_flag
3732: FROM OE_ORDER_LINES_ALL
3733: WHERE LINE_ID = p_x_line_rec.split_from_line_id;
3734: EXCEPTION
3735: WHEN OTHERS THEN
3736: l_orig_line_calc_price_flag := NULL;

Line 11622: FROM OE_ORDER_LINES_ALL -- Fix for FP bug 3391622

11618: , SERVICE_FIRST_PERIOD_AMOUNT
11619: , SERVICE_FIRST_PERIOD_ENDDATE
11620: -- sol_ord_er #16014165 end
11621: , FULFILLMENT_BASE--ER#14763609
11622: FROM OE_ORDER_LINES_ALL -- Fix for FP bug 3391622
11623: WHERE LINE_ID = p_line_id;
11624:
11625: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
11626:

Line 12466: FROM OE_ORDER_LINES_ALL -- Fix for FP bug 3391622

12462: , SERVICE_FIRST_PERIOD_AMOUNT
12463: , SERVICE_FIRST_PERIOD_ENDDATE
12464: -- sol_ord_er #16014165
12465: ,FULFILLMENT_BASE --ER#14763609
12466: FROM OE_ORDER_LINES_ALL -- Fix for FP bug 3391622
12467: WHERE HEADER_ID = p_header_id
12468: ORDER BY LINE_NUMBER,SHIPMENT_NUMBER,OPN, CPN, SVN;
12469:
12470:

Line 12850: FROM OE_ORDER_LINES_ALL -- Fix for FP bug 3391622

12846: , SERVICE_FIRST_PERIOD_AMOUNT
12847: , SERVICE_FIRST_PERIOD_ENDDATE
12848: -- sol_ord_er #16014165 end
12849: ,FULFILLMENT_BASE --ER#14763609
12850: FROM OE_ORDER_LINES_ALL -- Fix for FP bug 3391622
12851: WHERE LINE_SET_ID = p_line_set_id
12852: ORDER BY LINE_NUMBER,SHIPMENT_NUMBER,OPN, CPN, SVN;
12853:
12854: l_OPN NUMBER;

Line 13771: FROM oe_order_lines_all

13767: /* bug 4344310 */
13768: CURSOR C_Lock (c_top_model_line_id NUMBER ,
13769: c_line_id NUMBER ) IS
13770: SELECT line_id ,lock_control
13771: FROM oe_order_lines_all
13772: WHERE line_id IN (c_top_model_line_id, c_line_id)
13773: FOR UPDATE NOWAIT ;
13774: --
13775: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 13820: FROM OE_ORDER_LINES_ALL -- Fix for FP bug 3391622

13816: /* IF p_line_id <> FND_API.G_MISS_NUM THEN
13817:
13818: SELECT top_model_line_id
13819: INTO l_top_model_line_id
13820: FROM OE_ORDER_LINES_ALL -- Fix for FP bug 3391622
13821: WHERE line_id = l_line_id;
13822: ELSE
13823: l_top_model_line_id := p_x_line_rec.top_model_line_id;
13824: END IF; */

Line 13835: FROM OE_ORDER_LINES_ALL -- Fix for FP bug 3391622

13831: END IF ;
13832: ELSE
13833: SELECT top_model_line_id
13834: INTO l_top_model_line_id
13835: FROM OE_ORDER_LINES_ALL -- Fix for FP bug 3391622
13836: WHERE line_id = l_line_id;
13837:
13838: IF l_debug_level > 0 THEN
13839: oe_debug_pub.add('get top_model_line_id from the query' );

Line 13861: FROM oe_order_lines_all

13857:
13858: -- changes for bug 4344310
13859: /* SELECT line_id
13860: INTO l_dummy
13861: FROM oe_order_lines_all
13862: WHERE line_id = l_top_model_line_id
13863: FOR UPDATE NOWAIT; */
13864:
13865: FOR I IN c_lock(l_top_model_line_id ,l_line_id ) LOOP

Line 13875: FROM oe_order_lines_all

13871:
13872: ELSE
13873: SELECT line_id,lock_control
13874: INTO l_line_id,l_db_lock_control
13875: FROM oe_order_lines_all
13876: WHERE line_id = l_line_id
13877: FOR UPDATE NOWAIT;
13878: END IF;
13879: --end bug 4344310

Line 13920: FROM oe_order_lines_all

13916:
13917: --commented out for bug 4344310
13918: /*SELECT line_id,lock_control
13919: INTO l_line_id,l_db_lock_control
13920: FROM oe_order_lines_all
13921: WHERE line_id = l_line_id
13922: FOR UPDATE NOWAIT; */
13923:
13924: IF l_debug_level > 0 THEN

Line 14087: FROM oe_order_lines_all

14083: )
14084: IS
14085: CURSOR lock_lines(p_header_id NUMBER) IS
14086: SELECT line_id
14087: FROM oe_order_lines_all
14088: WHERE header_id = p_header_id
14089: FOR UPDATE NOWAIT;
14090:
14091: l_line_id NUMBER;

Line 14118: FROM OE_ORDER_LINES_ALL

14114: IF p_line_id <> FND_API.G_MISS_NUM THEN
14115:
14116: SELECT line_id
14117: INTO l_line_id
14118: FROM OE_ORDER_LINES_ALL
14119: WHERE line_id = p_line_id
14120: FOR UPDATE NOWAIT;
14121:
14122: END IF;

Line 16537: From oe_order_lines_all

16533: -- Start 2346233
16534: BEGIN
16535: Select order_quantity_uom, inventory_item_id
16536: Into l_order_quantity_uom, l_inventory_item_id
16537: From oe_order_lines_all
16538: Where line_id = p_line_id;
16539:
16540: EXCEPTION
16541: WHEN OTHERS THEN

Line 16657: From oe_order_lines_all

16653: -- Start 2346233
16654: BEGIN
16655: Select order_quantity_uom, inventory_item_id
16656: Into l_order_quantity_uom, l_inventory_item_id
16657: From oe_order_lines_all
16658: Where line_id = p_line_id;
16659:
16660: EXCEPTION
16661: WHEN OTHERS THEN

Line 16840: From oe_order_lines_all

16836: BEGIN
16837:
16838: Select order_quantity_uom, inventory_item_id
16839: Into l_order_quantity_uom, l_inventory_item_id
16840: From oe_order_lines_all
16841: Where line_id = p_line_id;
16842:
16843: EXCEPTION
16844: WHEN OTHERS THEN

Line 17560: from oe_order_lines_all

17556:
17557: begin
17558: select source_document_type_id
17559: into l_parent_document_type_id
17560: from oe_order_lines_all
17561: where line_id = p_x_line_rec.top_model_line_id;
17562:
17563: exception
17564: when NO_DATA_FOUND then NULL;

Line 18921: from oe_order_lines_all b

18917: select a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number
18918: from oe_order_lines a
18919: where exists
18920: (select 'x'
18921: from oe_order_lines_all b
18922: where a.service_reference_line_id=b.line_id
18923: and b.line_set_id = p_line_set_id)
18924: and a.line_Id <> p_line_id;
18925:

Line 18937: FROM oe_order_lines_all

18933: FROM oe_order_lines
18934: WHERE (top_model_line_id = p_line_id
18935: OR line_set_id = p_line_set_id
18936: OR top_model_line_id in (SELECT line_id
18937: FROM oe_order_lines_all
18938: WHERE header_id = p_header_id
18939: AND line_set_id = p_line_set_id))
18940: AND line_id <> p_line_id
18941: AND header_id = p_header_id

Line 18952: from oe_order_lines a, oe_order_lines_all b

18948: --lchen rewrite cursor service_line_number to fix performance bug 1869179
18949:
18950: CURSOR SERVICE_LINE_NUMBER IS
18951: select /*MOAC_SQL_CHANGES*/ a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number
18952: from oe_order_lines a, oe_order_lines_all b
18953: where a.service_reference_line_id=b.line_id
18954: and b.line_set_id = p_line_set_id
18955: UNION
18956: select a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number

Line 18957: from oe_order_lines a, oe_order_lines_all b

18953: where a.service_reference_line_id=b.line_id
18954: and b.line_set_id = p_line_set_id
18955: UNION
18956: select a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number
18957: from oe_order_lines a, oe_order_lines_all b
18958: Where a.service_reference_line_id=b.line_id
18959: and b.top_model_line_id= p_line_id
18960: UNION
18961: select a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number

Line 18962: from oe_order_lines a, oe_order_lines_all b

18958: Where a.service_reference_line_id=b.line_id
18959: and b.top_model_line_id= p_line_id
18960: UNION
18961: select a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number
18962: from oe_order_lines a, oe_order_lines_all b
18963: Where a.service_reference_line_id=b.line_id
18964: and EXISTS (select 'X'
18965: from oe_order_lines_all c
18966: where line_set_id = p_line_set_id

Line 18965: from oe_order_lines_all c

18961: select a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number
18962: from oe_order_lines a, oe_order_lines_all b
18963: Where a.service_reference_line_id=b.line_id
18964: and EXISTS (select 'X'
18965: from oe_order_lines_all c
18966: where line_set_id = p_line_set_id
18967: and c.line_id = b.top_model_line_id);
18968:
18969:

Line 19383: -- imported and records are posted to OE_Order_Lines_All table

19379: -- Bug 11928288 : End
19380: OR p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS ) THEN
19381: -- Importing Pre Exploded Kit.
19382: -- Log a delayed request for its execution after the whole Kit is
19383: -- imported and records are posted to OE_Order_Lines_All table
19384: -- This request will be logged for Kit model line
19385:
19386: oe_debug_pub.add(' Logging G_PRE_EXPLODED_KIT delayed requests');
19387: OE_delayed_requests_Pvt.log_request(

Line 21212: from oe_order_lines_all

21208: IF p_x_line_rec.split_from_line_id is not null then
21209: --bug 6196000
21210: begin
21211: select shipping_quantity_uom INTO l_shipping_uom
21212: from oe_order_lines_all
21213: where line_id = p_x_line_rec.split_from_line_id;
21214: exception
21215: when no_data_found then
21216: oe_debug_pub.add('setting the uom to null');

Line 24616: from oe_order_lines_all

24612:
24613: BEGIN
24614: select NVL(sold_to_org_id,p_x_line_tbl(l_index).sold_to_org_id)
24615: into l_sold_to_org_id
24616: from oe_order_lines_all
24617: where line_id = p_x_line_tbl(l_index).line_id;
24618:
24619: EXCEPTION
24620: WHEN OTHERS THEN

Line 24797: from oe_order_lines_all

24793: oe_debug_pub.add('Entering Is_Subscription_Service_Line p_line_id = '||p_line_id);
24794: End If;
24795: select subscription_enable_flag
24796: into l_subscription_enable_flag
24797: from oe_order_lines_all
24798: where line_id = p_line_id;
24799: If NVL(l_subscription_enable_flag,'N') = 'Y' THEN
24800: -- Subscription Servcie Line
24801: If l_debug_level > 0 THEN

Line 24838: oe_order_lines_all l,

24834: SELECT a.price_adjustment_id,a.rltd_price_adj_id,prg.list_line_id,p.list_line_id
24835: INTO l_orig_pr_adjustment_id,l_or_rltd_padj_id,l_prg_list_line_id,l_assoc_list_line_id
24836: FROM oe_price_adj_assocs a,
24837: oe_price_adjustments p,
24838: oe_order_lines_all l,
24839: oe_price_adjustments prg
24840: WHERE l.line_id = p.line_id AND p.price_adjustment_id = a.rltd_price_adj_id
24841: AND l.item_type_code = 'SERVICE' AND l.SUBSCRIPTION_ENABLE_FLAG <> 'Y'
24842: AND l.line_id = p_line_id AND prg.price_adjustment_id = a.price_adjustment_id