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 186: from oe_order_lines_all

182:
183: begin
184: select header_id
185: into l_header_id
186: from oe_order_lines_all
187: where line_id = p_line_id;
188: exception when no_data_found then
189: null;
190: end;

Line 3167: FROM OE_ORDER_LINES_ALL

3163: THEN
3164: BEGIN
3165: SELECT calculate_price_flag
3166: INTO l_orig_line_calc_price_flag
3167: FROM OE_ORDER_LINES_ALL
3168: WHERE LINE_ID = p_x_line_rec.split_from_line_id;
3169: EXCEPTION
3170: WHEN OTHERS THEN
3171: l_orig_line_calc_price_flag := NULL;

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

10339: , REVREC_SIGNATURE_DATE
10340: , ACCEPTED_BY
10341: , REVREC_REFERENCE_DOCUMENT
10342: , REVREC_IMPLICIT_FLAG
10343: FROM OE_ORDER_LINES_ALL -- Fix for FP bug 3391622
10344: WHERE LINE_ID = p_line_id;
10345:
10346: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
10347:

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

11160: ,REVREC_SIGNATURE_DATE
11161: ,ACCEPTED_BY
11162: ,REVREC_REFERENCE_DOCUMENT
11163: ,REVREC_IMPLICIT_FLAG
11164: FROM OE_ORDER_LINES_ALL -- Fix for FP bug 3391622
11165: WHERE HEADER_ID = p_header_id
11166: ORDER BY LINE_NUMBER,SHIPMENT_NUMBER,OPN, CPN, SVN;
11167:
11168:

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

11534: ,REVREC_SIGNATURE_DATE
11535: ,ACCEPTED_BY
11536: ,REVREC_REFERENCE_DOCUMENT
11537: ,REVREC_IMPLICIT_FLAG
11538: FROM OE_ORDER_LINES_ALL -- Fix for FP bug 3391622
11539: WHERE LINE_SET_ID = p_line_set_id
11540: ORDER BY LINE_NUMBER,SHIPMENT_NUMBER,OPN, CPN, SVN;
11541:
11542: l_OPN NUMBER;

Line 12439: FROM oe_order_lines_all

12435: /* bug 4344310 */
12436: CURSOR C_Lock (c_top_model_line_id NUMBER ,
12437: c_line_id NUMBER ) IS
12438: SELECT line_id ,lock_control
12439: FROM oe_order_lines_all
12440: WHERE line_id IN (c_top_model_line_id, c_line_id)
12441: FOR UPDATE NOWAIT ;
12442: --
12443: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

12484: /* IF p_line_id <> FND_API.G_MISS_NUM THEN
12485:
12486: SELECT top_model_line_id
12487: INTO l_top_model_line_id
12488: FROM OE_ORDER_LINES_ALL -- Fix for FP bug 3391622
12489: WHERE line_id = l_line_id;
12490: ELSE
12491: l_top_model_line_id := p_x_line_rec.top_model_line_id;
12492: END IF; */

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

12499: END IF ;
12500: ELSE
12501: SELECT top_model_line_id
12502: INTO l_top_model_line_id
12503: FROM OE_ORDER_LINES_ALL -- Fix for FP bug 3391622
12504: WHERE line_id = l_line_id;
12505:
12506: IF l_debug_level > 0 THEN
12507: oe_debug_pub.add('get top_model_line_id from the query' );

Line 12529: FROM oe_order_lines_all

12525:
12526: -- changes for bug 4344310
12527: /* SELECT line_id
12528: INTO l_dummy
12529: FROM oe_order_lines_all
12530: WHERE line_id = l_top_model_line_id
12531: FOR UPDATE NOWAIT; */
12532:
12533: FOR I IN c_lock(l_top_model_line_id ,l_line_id ) LOOP

Line 12543: FROM oe_order_lines_all

12539:
12540: ELSE
12541: SELECT line_id,lock_control
12542: INTO l_line_id,l_db_lock_control
12543: FROM oe_order_lines_all
12544: WHERE line_id = l_line_id
12545: FOR UPDATE NOWAIT;
12546: END IF;
12547: --end bug 4344310

Line 12588: FROM oe_order_lines_all

12584:
12585: --commented out for bug 4344310
12586: /*SELECT line_id,lock_control
12587: INTO l_line_id,l_db_lock_control
12588: FROM oe_order_lines_all
12589: WHERE line_id = l_line_id
12590: FOR UPDATE NOWAIT; */
12591:
12592: IF l_debug_level > 0 THEN

Line 12755: FROM oe_order_lines_all

12751: )
12752: IS
12753: CURSOR lock_lines(p_header_id NUMBER) IS
12754: SELECT line_id
12755: FROM oe_order_lines_all
12756: WHERE header_id = p_header_id
12757: FOR UPDATE NOWAIT;
12758:
12759: l_line_id NUMBER;

Line 12786: FROM OE_ORDER_LINES_ALL

12782: IF p_line_id <> FND_API.G_MISS_NUM THEN
12783:
12784: SELECT line_id
12785: INTO l_line_id
12786: FROM OE_ORDER_LINES_ALL
12787: WHERE line_id = p_line_id
12788: FOR UPDATE NOWAIT;
12789:
12790: END IF;

Line 15093: From oe_order_lines_all

15089: -- Start 2346233
15090: BEGIN
15091: Select order_quantity_uom, inventory_item_id
15092: Into l_order_quantity_uom, l_inventory_item_id
15093: From oe_order_lines_all
15094: Where line_id = p_line_id;
15095:
15096: EXCEPTION
15097: WHEN OTHERS THEN

Line 15213: From oe_order_lines_all

15209: -- Start 2346233
15210: BEGIN
15211: Select order_quantity_uom, inventory_item_id
15212: Into l_order_quantity_uom, l_inventory_item_id
15213: From oe_order_lines_all
15214: Where line_id = p_line_id;
15215:
15216: EXCEPTION
15217: WHEN OTHERS THEN

Line 15396: From oe_order_lines_all

15392: BEGIN
15393:
15394: Select order_quantity_uom, inventory_item_id
15395: Into l_order_quantity_uom, l_inventory_item_id
15396: From oe_order_lines_all
15397: Where line_id = p_line_id;
15398:
15399: EXCEPTION
15400: WHEN OTHERS THEN

Line 16048: from oe_order_lines_all

16044:
16045: begin
16046: select source_document_type_id
16047: into l_parent_document_type_id
16048: from oe_order_lines_all
16049: where line_id = p_x_line_rec.top_model_line_id;
16050:
16051: exception
16052: when NO_DATA_FOUND then NULL;

Line 17216: from oe_order_lines_all b

17212: select a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number
17213: from oe_order_lines a
17214: where exists
17215: (select 'x'
17216: from oe_order_lines_all b
17217: where a.service_reference_line_id=b.line_id
17218: and b.line_set_id = p_line_set_id)
17219: and a.line_Id <> p_line_id;
17220:

Line 17232: FROM oe_order_lines_all

17228: FROM oe_order_lines
17229: WHERE (top_model_line_id = p_line_id
17230: OR line_set_id = p_line_set_id
17231: OR top_model_line_id in (SELECT line_id
17232: FROM oe_order_lines_all
17233: WHERE header_id = p_header_id
17234: AND line_set_id = p_line_set_id))
17235: AND line_id <> p_line_id
17236: AND header_id = p_header_id

Line 17247: from oe_order_lines a, oe_order_lines_all b

17243: --lchen rewrite cursor service_line_number to fix performance bug 1869179
17244:
17245: CURSOR SERVICE_LINE_NUMBER IS
17246: select /*MOAC_SQL_CHANGES*/ a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number
17247: from oe_order_lines a, oe_order_lines_all b
17248: where a.service_reference_line_id=b.line_id
17249: and b.line_set_id = p_line_set_id
17250: UNION
17251: select a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number

Line 17252: from oe_order_lines a, oe_order_lines_all b

17248: where a.service_reference_line_id=b.line_id
17249: and b.line_set_id = p_line_set_id
17250: UNION
17251: select a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number
17252: from oe_order_lines a, oe_order_lines_all b
17253: Where a.service_reference_line_id=b.line_id
17254: and b.top_model_line_id= p_line_id
17255: UNION
17256: select a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number

Line 17257: from oe_order_lines a, oe_order_lines_all b

17253: Where a.service_reference_line_id=b.line_id
17254: and b.top_model_line_id= p_line_id
17255: UNION
17256: select a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number
17257: from oe_order_lines a, oe_order_lines_all b
17258: Where a.service_reference_line_id=b.line_id
17259: and EXISTS (select 'X'
17260: from oe_order_lines_all c
17261: where line_set_id = p_line_set_id

Line 17260: from oe_order_lines_all c

17256: select a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number
17257: from oe_order_lines a, oe_order_lines_all b
17258: Where a.service_reference_line_id=b.line_id
17259: and EXISTS (select 'X'
17260: from oe_order_lines_all c
17261: where line_set_id = p_line_set_id
17262: and c.line_id = b.top_model_line_id);
17263:
17264: