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

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 3514: FROM oe_order_lines

3510: BEGIN
3511:
3512: Select 'Y'
3513: INTO l_is_model
3514: FROM oe_order_lines
3515: WHERE line_id = p_x_line_rec.service_reference_line_id
3516: AND item_type_code in ('INCLUDED', 'MODEL', 'CLASS', 'OPTION', 'KIT') ; -- Included KIT Item Type Code for bug 2938790
3517:
3518: EXCEPTION

Line 3534: FROM oe_order_lines l

3530: end if;
3531: BEGIN
3532: Select 'Y'
3533: INTO l_is_model
3534: FROM oe_order_lines l
3535: WHERE top_model_line_id = p_x_line_rec.service_reference_line_id
3536: AND item_type_code = 'INCLUDED'
3537: AND exists (select null from mtl_system_items mtl where
3538: mtl.inventory_item_id = l.inventory_item_id and

Line 3631: from oe_order_lines

3627: IF l_serviceable_item = 'Y' THEN
3628: BEGIN
3629: select distinct 'Y'
3630: into l_serviced_model
3631: from oe_order_lines
3632: where item_type_code = 'SERVICE'
3633: and service_reference_line_id = p_x_line_rec.top_model_line_id
3634: and service_reference_type_code = 'ORDER';
3635:

Line 4204: FROM oe_order_lines

4200: BEGIN
4201:
4202: Select 'Y'
4203: INTO l_is_model
4204: FROM oe_order_lines
4205: WHERE line_id = p_x_line_rec.service_reference_line_id
4206: AND item_type_code in ('INCLUDED', 'MODEL', 'CLASS', 'OPTION') ;
4207:
4208: EXCEPTION

Line 8164: FROM oe_order_lines

8160: --Commented for MOAC end
8161:
8162: SELECT lock_control
8163: INTO l_lock_control
8164: FROM oe_order_lines
8165: WHERE line_id = p_line_rec.line_id;
8166:
8167: l_lock_control := l_lock_control + 1;
8168:

Line 8205: UPDATE OE_ORDER_LINES

8201: oe_debug_pub.add('shipset-'||to_char(p_line_rec.ship_set_id), 1);
8202: end if;
8203: -- OPM 02/JUN/00 - Include process columns
8204: -- (ordered_quantity2,ordered_quantity_uom2,preferred_grade)
8205: UPDATE OE_ORDER_LINES
8206: SET ACCOUNTING_RULE_ID = p_line_rec.accounting_rule_id
8207: , ACCOUNTING_RULE_DURATION = p_line_rec.accounting_rule_duration
8208: , CALCULATE_PRICE_FLAG = p_line_rec.calculate_price_flag
8209: , ACTUAL_ARRIVAL_DATE = p_line_rec.actual_arrival_date

Line 8674: INSERT INTO OE_ORDER_LINES

8670:
8671: -- OPM 02/JUN/00 - Include process columns
8672: -- (ordered_quantity2,ordered_quantity_uom2,preferred_grade)
8673: -- =======================================================================
8674: INSERT INTO OE_ORDER_LINES
8675: ( ACCOUNTING_RULE_ID
8676: , ACCOUNTING_RULE_DURATION
8677: , ACTUAL_ARRIVAL_DATE
8678: , ACTUAL_SHIPMENT_DATE

Line 9495: FROM OE_ORDER_LINES

9491: line_category_code, schedule_status_code,
9492: shipping_interfaced_flag,
9493: ordered_quantity, price_request_code
9494: ,transaction_phase_code
9495: FROM OE_ORDER_LINES
9496: WHERE HEADER_ID = p_header_id;
9497: /*AND NVL(ORG_ID,NVL(l_org_id,0))= NVL(l_org_id,0);*/
9498:
9499: -- added for notification framework

Line 9504: FROM OE_ORDER_LINES

9500: l_new_line_rec OE_Order_PUB.Line_Rec_Type;
9501: l_index NUMBER;
9502: CURSOR svc_line IS
9503: SELECT line_id, item_type_code
9504: FROM OE_ORDER_LINES
9505: WHERE service_reference_line_id = p_line_id
9506: AND service_reference_type_code = 'ORDER'; --bug 3056313
9507:
9508: BEGIN

Line 9588: DELETE FROM OE_ORDER_LINES_HISTORY

9584:
9585: END LOOP; -- all the lines in a header.
9586:
9587: /* Start Audit Trail */
9588: DELETE FROM OE_ORDER_LINES_HISTORY
9589: WHERE HEADER_ID = p_header_id;
9590: /* End Audit Trail */
9591:
9592: DELETE FROM OE_ORDER_LINES

Line 9592: DELETE FROM OE_ORDER_LINES

9588: DELETE FROM OE_ORDER_LINES_HISTORY
9589: WHERE HEADER_ID = p_header_id;
9590: /* End Audit Trail */
9591:
9592: DELETE FROM OE_ORDER_LINES
9593: WHERE HEADER_ID = p_header_id;
9594: /* AND NVL(ORG_ID,NVL(l_org_id,0))= NVL(l_org_id,0);*/
9595:
9596: ELSE -- header_id is missing.

Line 9615: from oe_order_lines

9611: lsqlstmt := 'Select line_id, item_type_code, line_category_code,
9612: config_header_id, config_rev_nbr,
9613: schedule_status_code, shipping_interfaced_flag,
9614: ordered_quantity, price_request_code
9615: from oe_order_lines
9616: where top_model_line_id = :x and
9617: line_id <> :y';
9618:
9619:

Line 9668: from oe_order_lines

9664: lsqlstmt := 'Select line_id, item_type_code, line_category_code,
9665: config_header_id, config_rev_nbr,
9666: schedule_status_code, shipping_interfaced_flag,
9667: ordered_quantity, price_request_code
9668: from oe_order_lines
9669: where service_reference_type_code = ' || '''' || 'ORDER' || ''' ' ||
9670: 'AND service_reference_line_id = :x'; --bug 3056313
9671:
9672: OPEN llinetbl_svc

Line 9703: DELETE FROM OE_ORDER_LINES

9699: END LOOP; -- loop of the service lines.
9700:
9701: CLOSE llinetbl_svc;
9702:
9703: DELETE FROM OE_ORDER_LINES
9704: WHERE SERVICE_REFERENCE_LINE_ID = l_tmp_line_id
9705: AND SERVICE_REFERENCE_TYPE_CODE = 'ORDER'; -- bug 3056313
9706:
9707: END IF; -- if service lines exist, for bug 2408321

Line 9716: 'Delete oe_order_lines where top_model_line_id = :x

9712: CLOSE llinetbl;
9713:
9714: IF lvariable1 = 'TOP_MODEL' THEN
9715: EXECUTE IMMEDIATE
9716: 'Delete oe_order_lines where top_model_line_id = :x
9717: and line_id <> :y'
9718: USING
9719: p_line_id,
9720: p_line_id;

Line 9764: from oe_order_lines

9760: lsqlstmt := 'Select line_id, item_type_code, line_category_code,
9761: config_header_id, config_rev_nbr,
9762: schedule_status_code, shipping_interfaced_flag,
9763: ordered_quantity,price_request_code
9764: from oe_order_lines
9765: where service_reference_type_code = ' || '''' || 'ORDER' || ''' ' ||
9766: 'and service_reference_line_id = :x'; -- bug 3056313
9767:
9768: OPEN llinetbl

Line 9803: DELETE FROM OE_ORDER_LINES_HISTORY

9799:
9800: END IF; -- if service lines exist
9801:
9802: /* Start Audit Trail (modified for 11.5.10) */
9803: DELETE FROM OE_ORDER_LINES_HISTORY
9804: WHERE LINE_ID = p_line_id
9805: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
9806: AND NVL(VERSION_FLAG, 'N') = 'N'
9807: AND NVL(PHASE_CHANGE_FLAG, 'N') = 'N';

Line 9809: UPDATE OE_ORDER_LINES_HISTORY

9805: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
9806: AND NVL(VERSION_FLAG, 'N') = 'N'
9807: AND NVL(PHASE_CHANGE_FLAG, 'N') = 'N';
9808:
9809: UPDATE OE_ORDER_LINES_HISTORY
9810: SET AUDIT_FLAG = 'N'
9811: WHERE LINE_ID = p_line_id
9812: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
9813: AND (NVL(VERSION_FLAG, 'N') = 'Y'

Line 9846: DELETE FROM OE_ORDER_LINES

9842: END IF; /*code_release_level*/
9843: -- notification framework end
9844:
9845:
9846: DELETE FROM OE_ORDER_LINES
9847: WHERE LINE_ID = p_line_id;
9848: /* AND NVL(ORG_ID,NVL(l_org_id,0))= NVL(l_org_id,0);*/
9849:
9850:

Line 9881: DELETE FROM OE_ORDER_LINES

9877: END IF; /*code_release_level*/
9878: -- notification framework end
9879:
9880: -- For the Multiple service for Standard Line
9881: DELETE FROM OE_ORDER_LINES
9882: WHERE SERVICE_REFERENCE_LINE_ID = p_line_id
9883: AND SERVICE_REFERENCE_TYPE_CODE = 'ORDER'; -- bug 3056313
9884: /* AND NVL(ORG_ID,NVL(l_org_id,0))= NVL(l_org_id,0);*/
9885:

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 14498: FROM OE_ORDER_LINES

14494: ELSIF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
14495:
14496: SELECT SOLD_TO_ORG_ID
14497: INTO l_sold_to_org_id
14498: FROM OE_ORDER_LINES
14499: WHERE LINE_ID = p_x_line_rec.line_id;
14500:
14501: END IF;
14502:

Line 14663: FROM OE_ORDER_LINES

14659: THEN
14660:
14661: SELECT SHIP_TO_ORG_ID, INVOICE_TO_ORG_ID, DELIVER_TO_ORG_ID
14662: INTO l_sold_to_org_id, l_invoice_to_org_id, l_deliver_to_org_id
14663: FROM OE_ORDER_LINES
14664: WHERE LINE_ID = p_x_line_rec.line_id;
14665:
14666: IF p_x_line_rec.ship_to_org_id <> FND_API.G_MISS_NUM THEN
14667: l_ship_to_org_id := p_x_line_rec.ship_to_org_id;

Line 15024: from oe_order_lines

15020: )IS
15021: BEGIN
15022:
15023: Select header_id into x_header_id
15024: from oe_order_lines
15025: where line_id = p_line_id;
15026: IF sql%notfound then
15027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15028: 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 15509: from oe_order_lines

15505: **
15506: IF p_line_rec.reference_line_id is not null THEN
15507:
15508: select nvl(upgraded_flag,'-') into l_upgraded_flag
15509: from oe_order_lines
15510: where line_id = p_line_rec.reference_line_id;
15511:
15512: IF l_upgraded_flag in ('Y','P') THEN
15513: return FALSE;

Line 15537: oe_order_lines b

15533: IF C2.line_set_id is not null THEN
15534: select distinct reference_line_id
15535: into l_ref_line_id
15536: from oe_line_sets a,
15537: oe_order_lines b
15538: where a.set_id = C2.line_set_id
15539: and a.line_id = b.line_id
15540: and b.booked_flag = 'Y'
15541: and b.line_id <> p_line_rec.line_id

Line 15546: from oe_order_lines

15542: and b.cancelled_flag <> 'Y';
15543: ELSE
15544: select reference_line_id
15545: into l_ref_line_id
15546: from oe_order_lines
15547: where line_id = C2.line_id
15548: and line_id <> p_line_rec.line_id
15549: and booked_flag = 'Y'
15550: and cancelled_flag <> 'Y';

Line 15561: FROM oe_order_lines

15557:
15558: oe_debug_pub.ADD('Before checking the total for the Outbound line',1);
15559: SELECT sum(nvl(ordered_quantity, 0))
15560: INTO l_total
15561: FROM oe_order_lines
15562: WHERE reference_line_id = p_line_rec.reference_line_id
15563: AND ((booked_flag = 'Y' and header_id <> p_line_rec.header_id)
15564: OR (header_id = p_line_rec.header_id))
15565: AND cancelled_flag <> 'Y'

Line 15576: FROM oe_order_lines

15572: -- bug# 6617423 : Start -----------
15573: /*
15574: SELECT nvl(ordered_quantity, 0)
15575: INTO l_orig_quantity
15576: FROM oe_order_lines
15577: WHERE line_id = p_line_rec.reference_line_id;
15578: */
15579:
15580: oe_debug_pub.add( ' p_line_rec.org_id = '|| p_line_rec.org_id, 5 ) ;

Line 15592: FROM oe_order_lines

15588:
15589: IF l_overship_invoice_basis = 'SHIPPED' then
15590: SELECT nvl(shipped_quantity, ordered_quantity) --- get from ord_qty if original line not shipped/invoiced....
15591: INTO l_orig_quantity
15592: FROM oe_order_lines
15593: WHERE line_id = p_line_rec.reference_line_id;
15594: ELSE
15595: SELECT nvl(ordered_quantity, 0)
15596: INTO l_orig_quantity

Line 15597: FROM oe_order_lines

15593: WHERE line_id = p_line_rec.reference_line_id;
15594: ELSE
15595: SELECT nvl(ordered_quantity, 0)
15596: INTO l_orig_quantity
15597: FROM oe_order_lines
15598: WHERE line_id = p_line_rec.reference_line_id;
15599: end if;
15600: -- bug# 6617423: End -------
15601:

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 17205: from oe_order_lines a

17201: --lchen rewrite cursor standard_line_number to fix performance bug 1869179
17202:
17203: CURSOR STANDARD_LINE_NUMBER IS
17204: select /*MOAC_SQL_CHANGES*/ a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number
17205: from oe_order_lines a
17206: where a.service_reference_line_id= p_line_id
17207: UNION
17208: select a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number
17209: from oe_order_lines a

Line 17209: from oe_order_lines a

17205: from oe_order_lines a
17206: where a.service_reference_line_id= p_line_id
17207: UNION
17208: select a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number
17209: from oe_order_lines a
17210: where a.line_set_id = p_line_set_id
17211: UNION
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

Line 17213: from oe_order_lines a

17209: from oe_order_lines a
17210: where a.line_set_id = p_line_set_id
17211: UNION
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

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 17228: FROM oe_order_lines

17224:
17225: CURSOR MODEL_LINE_NUMBER IS
17226: SELECT /*MOAC_SQL_CHANGES*/ line_id, header_id,line_number,shipment_number,
17227: option_number,service_number
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

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:

Line 17297: FROM oe_order_lines

17293:
17294: BEGIN
17295: SELECT line_id
17296: INTO l_dummy
17297: FROM oe_order_lines
17298: WHERE line_id=l_line_id
17299: FOR UPDATE OF line_number NOWAIT;
17300: EXCEPTION
17301: WHEN OTHERS THEN

Line 17308: UPDATE oe_order_lines

17304:
17305: oe_debug_pub.add('l_line_id= ' || l_line_id);
17306: oe_debug_pub.add('In the loop of standard_line_number, update child service line numbers');
17307:
17308: UPDATE oe_order_lines
17309: Set line_number = p_line_number,
17310: lock_control = lock_control + 1
17311: WHERE line_id=l_line_id;
17312:

Line 17351: UPDATE oe_order_lines

17347:
17348: oe_debug_pub.add('l_cursor_flag= ' ||l_cursor_flag );
17349: -- Update line number on the child option/service/class lines
17350:
17351: UPDATE oe_order_lines
17352: Set line_number = p_line_number,
17353: lock_control = lock_control + 1
17354: WHERE (top_model_line_id = p_line_id
17355: OR line_set_id = p_line_set_id

Line 17357: FROM oe_order_lines

17353: lock_control = lock_control + 1
17354: WHERE (top_model_line_id = p_line_id
17355: OR line_set_id = p_line_set_id
17356: OR top_model_line_id in (SELECT line_id
17357: FROM oe_order_lines
17358: WHERE header_id = p_header_id
17359: AND line_set_id = p_line_set_id))
17360: AND line_id <> p_line_id
17361: AND header_id = p_header_id; -- 2508099

Line 17409: FROM oe_order_lines

17405:
17406: BEGIN
17407: SELECT line_id
17408: INTO l_dummy
17409: FROM oe_order_lines
17410: WHERE line_id=l_line_id
17411: FOR UPDATE OF line_number NOWAIT;
17412: EXCEPTION
17413: WHEN OTHERS THEN

Line 17420: UPDATE oe_order_lines

17416:
17417: oe_debug_pub.add('l_line_id = ' ||l_dummy);
17418: oe_debug_pub.add('in service_line_number loop, update service line number');
17419:
17420: UPDATE oe_order_lines
17421: Set line_number = p_line_number,
17422: lock_control = lock_control + 1
17423: WHERE line_id=l_line_id;
17424: END LOOP;

Line 18221: FROM oe_order_lines

18217: oe_debug_pub.add('cancel or delete, call smc shipping', 1);
18218:
18219: SELECT count(*)
18220: INTO l_count
18221: FROM oe_order_lines
18222: WHERE top_model_line_id = p_x_line_tbl(I).top_model_line_id
18223: AND shipping_interfaced_flag = 'Y';
18224:
18225: IF l_count = 0 THEN

Line 18254: FROM oe_order_lines L

18250: BEGIN
18251:
18252: SELECT 'N'
18253: INTO l_valid_line_number
18254: FROM oe_order_lines L
18255: WHERE L.line_number = p_x_line_tbl(I).line_number
18256: AND L.header_id = p_x_line_tbl(I).header_id
18257: AND L.line_id <> p_x_line_tbl(I).line_id
18258: AND ( L.item_type_code = 'STANDARD'

Line 18427: FROM oe_order_lines

18423: and p_line_rec.reference_line_id is not null THEN
18424:
18425: SELECT item_type_code
18426: INTO l_item_type_code
18427: FROM oe_order_lines
18428: WHERE line_id = p_line_rec.reference_line_id;
18429:
18430: RETURN l_item_type_code;
18431: ELSE

Line 19518: FROM oe_order_lines

19514:
19515: BEGIN
19516: SELECT line_id
19517: INTO l_num
19518: FROM oe_order_lines
19519: WHERE ato_line_id = p_x_line_rec.ato_line_id
19520: AND top_model_line_id = p_x_line_rec.top_model_line_id
19521: AND item_type_code = OE_GLOBALS.G_ITEM_CONFIG;
19522:

Line 19849: FROM oe_order_lines

19845:
19846: BEGIN
19847: SELECT 1
19848: INTO l_num
19849: FROM oe_order_lines
19850: WHERE line_id = p_x_line_rec.top_model_line_id
19851: AND top_model_line_id = nvl(ato_line_id, -1);
19852:
19853: EXCEPTION

Line 19938: FROM oe_order_lines

19934:
19935: BEGIN
19936: SELECT 1
19937: INTO l_num
19938: FROM oe_order_lines
19939: WHERE line_id = p_x_line_rec.split_from_line_id
19940: AND ato_line_id = line_id
19941: AND item_type_code = 'CLASS';
19942:

Line 20001: FROM oe_order_lines

19997: IF OE_Code_Control.Code_Release_Level < '110510' THEN
19998: BEGIN
19999: SELECT line_id
20000: INTO l_num
20001: FROM oe_order_lines
20002: WHERE top_model_line_id = p_x_line_rec.top_model_line_id
20003: AND item_type_code = OE_GLOBALS.G_ITEM_CONFIG;
20004:
20005: l_flag := TRUE;

Line 20131: FROM oe_order_lines

20127:
20128: BEGIN
20129: SELECT config_header_id, config_rev_nbr, configuration_id
20130: INTO l_config_header_id,l_config_rev_nbr, l_configuration_id
20131: FROM oe_order_lines
20132: WHERE line_id = p_x_line_rec.split_from_line_id;
20133: EXCEPTION
20134: WHEN no_data_found THEN
20135: if l_debug_level > 0 then

Line 20176: FROM oe_order_lines

20172:
20173: IF p_x_line_rec.line_id <> p_x_line_rec.top_model_line_id THEN
20174: SELECT open_flag, ordered_item, fulfilled_flag
20175: INTO l_model_open_flag, l_model_item, l_fulfilled_flag
20176: FROM oe_order_lines
20177: WHERE line_id = p_x_line_rec.top_model_line_id;
20178: END IF;
20179:
20180: ---------------------- deletes ----------------------------------

Line 20862: FROM oe_order_lines

20858:
20859: BEGIN
20860: SELECT 1
20861: INTO l_num
20862: FROM oe_order_lines
20863: WHERE top_model_line_id = p_x_line_rec.top_model_line_id
20864: AND link_to_line_id = p_x_line_rec.line_id
20865: AND item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
20866: AND rownum = 1;

Line 22554: FROM oe_order_lines Line,

22550: END IF;
22551:
22552: SELECT nvl(bic.required_for_revenue, 0)
22553: INTO l_is_rfr
22554: FROM oe_order_lines Line,
22555: bom_inventory_components bic
22556: WHERE Line.line_id = p_line_id
22557: AND Line.open_flag = 'N'
22558: AND bic.component_sequence_id = Line.component_sequence_id

Line 22568: FROM oe_order_lines Line,

22564: END IF;
22565:
22566: SELECT count(1)
22567: INTO l_open_rfr_lines
22568: FROM oe_order_lines Line,
22569: bom_inventory_components bic
22570: WHERE Line.line_id <> p_line_id
22571: AND Line.top_model_line_id = p_top_model_line_id
22572: AND Line.link_to_line_id = p_link_to_line_id

Line 22624: Update oe_order_lines

22620: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
22621: IF l_debug_level > 0 THEN
22622: oe_debug_pub.add( 'Updating Line Flow Status and pushing WF ');
22623: END IF;
22624: Update oe_order_lines
22625: Set flow_status_code = 'INVOICED'
22626: Where line_id = p_link_to_line_id;
22627:
22628: BEGIN