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

Line 387: FROM OE_ORDER_LINES

383: IF p_hold_entity_code = 'O' THEN
384:
385: SELECT 'Valid Entity'
386: INTO l_dummy
387: FROM OE_ORDER_LINES
388: WHERE LINE_ID = p_line_id
389: AND HEADER_ID = p_hold_entity_id
390: AND nvl(TRANSACTION_PHASE_CODE,'F') = 'F';
391:

Line 396: FROM OE_ORDER_LINES

392: ELSIF p_hold_entity_code = 'I' THEN
393:
394: SELECT 'Valid Entity'
395: INTO l_dummy
396: FROM OE_ORDER_LINES
397: WHERE LINE_ID = p_line_id
398: AND INVENTORY_ITEM_ID = p_hold_entity_id
399: AND nvl(TRANSACTION_PHASE_CODE,'F') = 'F';
400:

Line 407: FROM OE_ORDER_LINES l,

403: -- Added Exception Handling through 13895629
404: BEGIN
405: SELECT 'Valid Entity'
406: INTO l_dummy
407: FROM OE_ORDER_LINES l,
408: mtl_item_categories ic
409: WHERE l.LINE_ID = p_line_id
410: AND ic.category_id = p_hold_entity_id
411: AND l.INVENTORY_ITEM_ID = ic.inventory_item_id

Line 427: FROM OE_ORDER_LINES l

423: ELSIF p_hold_entity_code IN('EC','EN') THEN
424:
425: SELECT 'Valid Entity'
426: INTO l_dummy
427: FROM OE_ORDER_LINES l
428: WHERE l.LINE_ID = p_line_id
429: AND l.end_customer_id =p_hold_entity_id
430: AND nvl(l.TRANSACTION_PHASE_CODE,'F') = 'F';
431: --ER 12571983 end

Line 454: FROM OE_ORDER_LINES

450: IF p_hold_entity_code2 = 'O' THEN
451:
452: SELECT 'Valid Entity'
453: INTO l_dummy
454: FROM OE_ORDER_LINES
455: WHERE LINE_ID = p_line_id
456: AND HEADER_ID = p_hold_entity_id2
457: AND nvl(TRANSACTION_PHASE_CODE,'F') = 'F';
458:

Line 463: FROM OE_ORDER_LINES

459: ELSIF p_hold_entity_code2 = 'I' THEN
460:
461: SELECT 'Valid Entity'
462: INTO l_dummy
463: FROM OE_ORDER_LINES
464: WHERE LINE_ID = p_line_id
465: AND INVENTORY_ITEM_ID = p_hold_entity_id2
466: AND nvl(TRANSACTION_PHASE_CODE,'F') = 'F';
467:

Line 473: FROM OE_ORDER_LINES l

469: ELSIF p_hold_entity_code2 IN('EC','EN') THEN
470:
471: SELECT 'Valid Entity'
472: INTO l_dummy
473: FROM OE_ORDER_LINES l
474: WHERE l.LINE_ID = p_line_id
475: AND l.end_customer_id =p_hold_entity_id2
476: AND nvl(l.TRANSACTION_PHASE_CODE,'F') = 'F';
477:

Line 482: FROM OE_ORDER_LINES l

478: ELSIF p_hold_entity_code2 IN('EL') THEN
479:
480: SELECT 'Valid Entity'
481: INTO l_dummy
482: FROM OE_ORDER_LINES l
483: WHERE l.LINE_ID = p_line_id
484: AND l.end_customer_id =p_hold_entity_id
485: AND l.end_customer_site_use_id =p_hold_entity_id2
486: AND nvl(l.TRANSACTION_PHASE_CODE,'F') = 'F';

Line 922: FROM OE_ORDER_LINES

918: RAISE FND_API.G_EXC_ERROR;
919: ELSIF p_order_tbl(j).header_id is NULL THEN
920: SELECT header_id
921: INTO l_header_id
922: FROM OE_ORDER_LINES
923: WHERE LINE_ID = p_order_tbl(j).line_id;
924: l_order_tbl(j).header_id := l_header_id;
925: l_order_tbl(j).line_id := p_order_tbl(j).line_id;
926: ELSE

Line 1139: FROM OE_ORDER_LINES

1135: RAISE FND_API.G_EXC_ERROR;
1136: ELSIF p_header_id IS NULL THEN
1137: SELECT header_id
1138: INTO l_header_id
1139: FROM OE_ORDER_LINES
1140: WHERE LINE_ID = p_line_id;
1141: ELSE
1142: l_header_id := p_header_id;
1143: END IF;

Line 1320: ** the table OE_ORDER_LINES_ALL was avoided as the header_id was being

1316:
1317: /*
1318: ** Fix Bug # 1920064
1319: ** The SQL below was modified. To improve the performance, the scan on
1320: ** the table OE_ORDER_LINES_ALL was avoided as the header_id was being
1321: ** passed as a parameter to this procedure. The UNION was removed and
1322: ** the whole SQL was re-written as below.
1323: ** Fix Bug # 2984023
1324: ** Modified the query to check for only line level holds

Line 1463: and oh.line_id in (select ol.line_id from oe_order_lines_all ol

1459: SELECT /* MOAC_SQL_CHANGE */ 'ANY_ATO_LINE_HOLD'
1460: INTO l_dummy
1461: FROM oe_order_holds_all oh
1462: WHERE oh.header_id = p_hdr_id
1463: and oh.line_id in (select ol.line_id from oe_order_lines_all ol
1464: where ol.header_id = oh.header_id
1465: and ol.ato_line_id = p_ato_line_id
1466: and ol.top_model_line_id = p_top_model_line_id)
1467: and oh.hold_release_id is null

Line 1590: and oh.line_id in (select ol.line_id from oe_order_lines_all ol

1586: SELECT /* MOAC_SQL_CHANGE */ 'ANY_SMC_LINE_HOLD'
1587: INTO l_dummy
1588: FROM oe_order_holds_all oh
1589: WHERE oh.header_id = p_hdr_id
1590: and oh.line_id in (select ol.line_id from oe_order_lines_all ol
1591: where ol.header_id = oh.header_id
1592: and ol.top_model_line_id = p_top_model_line_id)
1593: and oh.hold_release_id is null
1594: AND EXISTS

Line 1825: from oe_order_lines_all

1821: p_hdr_id NUMBER;
1822:
1823: CURSOR ato_model_lines IS
1824: select line_id
1825: from oe_order_lines_all
1826: where ato_line_id = l_ato_line_id
1827: and top_model_line_id = l_top_model_line_id;
1828:
1829: CURSOR smc_lines IS

Line 1831: from oe_order_lines_all

1827: and top_model_line_id = l_top_model_line_id;
1828:
1829: CURSOR smc_lines IS
1830: select line_id
1831: from oe_order_lines_all
1832: where top_model_line_id = l_top_model_line_id;
1833: --
1834: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1835: --

Line 1871: FROM oe_order_lines_all

1867: IF p_header_id IS NULL THEN
1868: Begin
1869: SELECT header_id
1870: INTO p_hdr_id
1871: FROM oe_order_lines_all
1872: WHERE line_id = p_line_id;
1873: EXCEPTION
1874: WHEN NO_DATA_FOUND THEN
1875: x_result_out := FND_API.G_FALSE;

Line 2009: FROM oe_order_lines_all

2005: SHIP_MODEL_COMPLETE_FLAG, ITEM_TYPE_CODE,
2006: LINK_TO_LINE_ID
2007: INTO l_ato_line_id, l_top_model_line_id,
2008: l_smc_flag, l_item_type_code, l_link_to_line_id
2009: FROM oe_order_lines_all
2010: WHERE line_id = p_line_id;
2011: EXCEPTION
2012: WHEN NO_DATA_FOUND THEN
2013: x_result_out := FND_API.G_FALSE;

Line 2733: FROM OE_ORDER_HOLDS OH,OE_HOLD_SOURCES HS,OE_ORDER_LINES OL

2729:
2730: --ER#7479609 start
2731: CURSOR line_hold_opt_item(p_top_model_line_id NUMBER,p_inventory_item_id NUMBER) IS
2732: SELECT OH.order_hold_id, NVL(OH.hold_release_id,0)
2733: FROM OE_ORDER_HOLDS OH,OE_HOLD_SOURCES HS,OE_ORDER_LINES OL
2734: WHERE OH.LINE_ID = p_top_model_line_id
2735: AND OH.LINE_ID = OL.LINE_ID
2736: AND OH.hold_source_id=HS.hold_source_id
2737: AND HS.hold_entity_id=OL.inventory_item_id

Line 2740: l_top_model_line_id OE_ORDER_LINES_ALL.TOP_MODEL_LINE_ID%TYPE;

2736: AND OH.hold_source_id=HS.hold_source_id
2737: AND HS.hold_entity_id=OL.inventory_item_id
2738: AND HS.hold_entity_id2=p_inventory_item_id;
2739:
2740: l_top_model_line_id OE_ORDER_LINES_ALL.TOP_MODEL_LINE_ID%TYPE;
2741: l_inventory_item_id OE_ORDER_LINES_ALL.INVENTORY_ITEM_ID%TYPE;
2742: --ER#7479609 end
2743:
2744: --

Line 2741: l_inventory_item_id OE_ORDER_LINES_ALL.INVENTORY_ITEM_ID%TYPE;

2737: AND HS.hold_entity_id=OL.inventory_item_id
2738: AND HS.hold_entity_id2=p_inventory_item_id;
2739:
2740: l_top_model_line_id OE_ORDER_LINES_ALL.TOP_MODEL_LINE_ID%TYPE;
2741: l_inventory_item_id OE_ORDER_LINES_ALL.INVENTORY_ITEM_ID%TYPE;
2742: --ER#7479609 end
2743:
2744: --
2745: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2872: from oe_order_lines

2868: --ER#7479609 start
2869: BEGIN
2870: select top_model_line_id,inventory_item_id
2871: into l_top_model_line_id,l_inventory_item_id
2872: from oe_order_lines
2873: where line_id=p_line_id
2874: and item_type_code in ('OPTION','CLASS','INCLUDED');
2875:
2876: OPEN line_hold_opt_item(l_top_model_line_id,l_inventory_item_id);

Line 3080: l_line_rec OE_ORDER_LINES_ALL%rowtype;

3076: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3077: --
3078: --ER#7479609 start
3079: l_header_rec OE_ORDER_HEADERS_ALL%rowtype;
3080: l_line_rec OE_ORDER_LINES_ALL%rowtype;
3081: TYPE entity_rec IS RECORD (entity_code oe_hold_sources_all.hold_entity_code%TYPE,
3082: entity_id oe_hold_sources_all.hold_entity_id%TYPE);
3083:
3084: TYPE entity_tab IS TABLE OF entity_rec INDEX BY BINARY_INTEGER;

Line 3159: FROM oe_order_headers OH,oe_order_lines OL

3155: END IF;
3156: --ER#7479609 start
3157: BEGIN
3158: SELECT OH.* INTO l_header_rec
3159: FROM oe_order_headers OH,oe_order_lines OL
3160: WHERE OH.header_id=OL.header_id
3161: AND OL.line_id=l_line_id;
3162:
3163: l_header_id := l_header_rec.header_id;

Line 3194: FROM oe_order_lines

3190: l_line_number,
3191: l_blanket_number,
3192: l_blanket_line_number,
3193: l_header_id
3194: FROM oe_order_lines
3195: WHERE line_id = l_line_id;
3196: ER#7479609 end*/
3197:
3198: --ER#7479609 start

Line 3200: FROM oe_order_lines

3196: ER#7479609 end*/
3197:
3198: --ER#7479609 start
3199: SELECT * INTO l_line_rec
3200: FROM oe_order_lines
3201: WHERE line_id = l_line_id;
3202: --ER#7479609 end
3203:
3204: --OE_LINE_UTIL.Query_Row(p_line_id => l_line_id,

Line 3818: -- FROM OE_ORDER_LINES

3814: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3815: -- Get the line number from the line record
3816: --SELECT line_number
3817: -- INTO l_line_number
3818: -- FROM OE_ORDER_LINES
3819: -- WHERE LINE_ID = p_entity_id;
3820: --FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3821: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_rec.line_number); --8254521
3822: OE_MSG_PUB.ADD;

Line 4150: -- FROM OE_ORDER_LINES

4146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4147: -- Get the line number from the line record
4148: --SELECT line_number
4149: -- INTO l_line_number
4150: -- FROM OE_ORDER_LINES
4151: -- WHERE LINE_ID = p_entity_id;
4152: --FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
4153: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_rec.line_number); --8254521
4154: OE_MSG_PUB.ADD;

Line 4564: l_line_rec OE_ORDER_LINES_ALL%rowtype;

4560: AND HS.HOLD_ENTITY_CODE <> 'O';
4561: */
4562: --ER#7479609 start
4563: l_header_rec OE_ORDER_HEADERS_ALL%rowtype;
4564: l_line_rec OE_ORDER_LINES_ALL%rowtype;
4565: TYPE entity_rec IS RECORD (entity_code oe_hold_sources_all.hold_entity_code%TYPE,
4566: entity_id oe_hold_sources_all.hold_entity_id%TYPE);
4567:
4568: TYPE entity_tab IS TABLE OF entity_rec INDEX BY BINARY_INTEGER;

Line 4629: FROM oe_order_headers OH,oe_order_lines OL

4625:
4626: --ER#7479609 start
4627: BEGIN
4628: SELECT OH.* INTO l_header_rec
4629: FROM oe_order_headers OH,oe_order_lines OL
4630: WHERE OH.header_id=OL.header_id
4631: AND OL.line_id=l_line_id;
4632:
4633: EXCEPTION

Line 4662: FROM oe_order_lines

4658: l_line_number,
4659: l_blanket_number,
4660: l_blanket_line_number,
4661: l_header_id
4662: FROM oe_order_lines
4663: WHERE line_id = l_line_id;
4664: ER#7479609 end*/
4665: --ER#7479609 start
4666: SELECT * INTO l_line_rec

Line 4667: FROM oe_order_lines

4663: WHERE line_id = l_line_id;
4664: ER#7479609 end*/
4665: --ER#7479609 start
4666: SELECT * INTO l_line_rec
4667: FROM oe_order_lines
4668: WHERE line_id = l_line_id;
4669: --ER#7479609 end
4670:
4671: EXCEPTION

Line 5452: -- FROM OE_ORDER_LINES

5448: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5449: -- Get the line number from the line record
5450: --SELECT line_number
5451: -- INTO l_line_number
5452: -- FROM OE_ORDER_LINES
5453: -- WHERE LINE_ID = p_entity_id;
5454: --FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
5455: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_rec.line_number); --8254521
5456: OE_MSG_PUB.ADD;