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

370: IF p_hold_entity_code = 'O' THEN
371:
372: SELECT 'Valid Entity'
373: INTO l_dummy
374: FROM OE_ORDER_LINES
375: WHERE LINE_ID = p_line_id
376: AND HEADER_ID = p_hold_entity_id
377: AND nvl(TRANSACTION_PHASE_CODE,'F') = 'F';
378:

Line 383: FROM OE_ORDER_LINES

379: ELSIF p_hold_entity_code = 'I' THEN
380:
381: SELECT 'Valid Entity'
382: INTO l_dummy
383: FROM OE_ORDER_LINES
384: WHERE LINE_ID = p_line_id
385: AND INVENTORY_ITEM_ID = p_hold_entity_id
386: AND nvl(TRANSACTION_PHASE_CODE,'F') = 'F';
387:

Line 408: FROM OE_ORDER_LINES

404: IF p_hold_entity_code2 = 'O' THEN
405:
406: SELECT 'Valid Entity'
407: INTO l_dummy
408: FROM OE_ORDER_LINES
409: WHERE LINE_ID = p_line_id
410: AND HEADER_ID = p_hold_entity_id2
411: AND nvl(TRANSACTION_PHASE_CODE,'F') = 'F';
412:

Line 417: FROM OE_ORDER_LINES

413: ELSIF p_hold_entity_code2 = 'I' THEN
414:
415: SELECT 'Valid Entity'
416: INTO l_dummy
417: FROM OE_ORDER_LINES
418: WHERE LINE_ID = p_line_id
419: AND INVENTORY_ITEM_ID = p_hold_entity_id2
420: AND nvl(TRANSACTION_PHASE_CODE,'F') = 'F';
421:

Line 837: FROM OE_ORDER_LINES

833: RAISE FND_API.G_EXC_ERROR;
834: ELSIF p_order_tbl(j).header_id is NULL THEN
835: SELECT header_id
836: INTO l_header_id
837: FROM OE_ORDER_LINES
838: WHERE LINE_ID = p_order_tbl(j).line_id;
839: l_order_tbl(j).header_id := l_header_id;
840: l_order_tbl(j).line_id := p_order_tbl(j).line_id;
841: ELSE

Line 1051: FROM OE_ORDER_LINES

1047: RAISE FND_API.G_EXC_ERROR;
1048: ELSIF p_header_id IS NULL THEN
1049: SELECT header_id
1050: INTO l_header_id
1051: FROM OE_ORDER_LINES
1052: WHERE LINE_ID = p_line_id;
1053: ELSE
1054: l_header_id := p_header_id;
1055: END IF;

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

1227:
1228: /*
1229: ** Fix Bug # 1920064
1230: ** The SQL below was modified. To improve the performance, the scan on
1231: ** the table OE_ORDER_LINES_ALL was avoided as the header_id was being
1232: ** passed as a parameter to this procedure. The UNION was removed and
1233: ** the whole SQL was re-written as below.
1234: ** Fix Bug # 2984023
1235: ** Modified the query to check for only line level holds

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

1370: SELECT /* MOAC_SQL_CHANGE */ 'ANY_ATO_LINE_HOLD'
1371: INTO l_dummy
1372: FROM oe_order_holds_all oh
1373: WHERE oh.header_id = p_hdr_id
1374: and oh.line_id in (select ol.line_id from oe_order_lines_all ol
1375: where ol.header_id = oh.header_id
1376: and ol.ato_line_id = p_ato_line_id
1377: and ol.top_model_line_id = p_top_model_line_id)
1378: and oh.hold_release_id is null

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

1497: SELECT /* MOAC_SQL_CHANGE */ 'ANY_SMC_LINE_HOLD'
1498: INTO l_dummy
1499: FROM oe_order_holds_all oh
1500: WHERE oh.header_id = p_hdr_id
1501: and oh.line_id in (select ol.line_id from oe_order_lines_all ol
1502: where ol.header_id = oh.header_id
1503: and ol.top_model_line_id = p_top_model_line_id)
1504: and oh.hold_release_id is null
1505: AND EXISTS

Line 1736: from oe_order_lines_all

1732: p_hdr_id NUMBER;
1733:
1734: CURSOR ato_model_lines IS
1735: select line_id
1736: from oe_order_lines_all
1737: where ato_line_id = l_ato_line_id
1738: and top_model_line_id = l_top_model_line_id;
1739:
1740: CURSOR smc_lines IS

Line 1742: from oe_order_lines_all

1738: and top_model_line_id = l_top_model_line_id;
1739:
1740: CURSOR smc_lines IS
1741: select line_id
1742: from oe_order_lines_all
1743: where top_model_line_id = l_top_model_line_id;
1744: --
1745: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1746: --

Line 1782: FROM oe_order_lines_all

1778: IF p_header_id IS NULL THEN
1779: Begin
1780: SELECT header_id
1781: INTO p_hdr_id
1782: FROM oe_order_lines_all
1783: WHERE line_id = p_line_id;
1784: EXCEPTION
1785: WHEN NO_DATA_FOUND THEN
1786: x_result_out := FND_API.G_FALSE;

Line 1920: FROM oe_order_lines_all

1916: SHIP_MODEL_COMPLETE_FLAG, ITEM_TYPE_CODE,
1917: LINK_TO_LINE_ID
1918: INTO l_ato_line_id, l_top_model_line_id,
1919: l_smc_flag, l_item_type_code, l_link_to_line_id
1920: FROM oe_order_lines_all
1921: WHERE line_id = p_line_id;
1922: EXCEPTION
1923: WHEN NO_DATA_FOUND THEN
1924: x_result_out := FND_API.G_FALSE;

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

2637:
2638: --ER#7479609 start
2639: CURSOR line_hold_opt_item(p_top_model_line_id NUMBER,p_inventory_item_id NUMBER) IS
2640: SELECT OH.order_hold_id, NVL(OH.hold_release_id,0)
2641: FROM OE_ORDER_HOLDS OH,OE_HOLD_SOURCES HS,OE_ORDER_LINES OL
2642: WHERE OH.LINE_ID = p_top_model_line_id
2643: AND OH.LINE_ID = OL.LINE_ID
2644: AND OH.hold_source_id=HS.hold_source_id
2645: AND HS.hold_entity_id=OL.inventory_item_id

Line 2648: l_top_model_line_id OE_ORDER_LINES_ALL.TOP_MODEL_LINE_ID%TYPE;

2644: AND OH.hold_source_id=HS.hold_source_id
2645: AND HS.hold_entity_id=OL.inventory_item_id
2646: AND HS.hold_entity_id2=p_inventory_item_id;
2647:
2648: l_top_model_line_id OE_ORDER_LINES_ALL.TOP_MODEL_LINE_ID%TYPE;
2649: l_inventory_item_id OE_ORDER_LINES_ALL.INVENTORY_ITEM_ID%TYPE;
2650: --ER#7479609 end
2651:
2652: --

Line 2649: l_inventory_item_id OE_ORDER_LINES_ALL.INVENTORY_ITEM_ID%TYPE;

2645: AND HS.hold_entity_id=OL.inventory_item_id
2646: AND HS.hold_entity_id2=p_inventory_item_id;
2647:
2648: l_top_model_line_id OE_ORDER_LINES_ALL.TOP_MODEL_LINE_ID%TYPE;
2649: l_inventory_item_id OE_ORDER_LINES_ALL.INVENTORY_ITEM_ID%TYPE;
2650: --ER#7479609 end
2651:
2652: --
2653: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2780: from oe_order_lines

2776: --ER#7479609 start
2777: BEGIN
2778: select top_model_line_id,inventory_item_id
2779: into l_top_model_line_id,l_inventory_item_id
2780: from oe_order_lines
2781: where line_id=p_line_id
2782: and item_type_code in ('OPTION','CLASS','INCLUDED');
2783:
2784: OPEN line_hold_opt_item(l_top_model_line_id,l_inventory_item_id);

Line 2974: l_line_rec OE_ORDER_LINES_ALL%rowtype;

2970: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2971: --
2972: --ER#7479609 start
2973: l_header_rec OE_ORDER_HEADERS_ALL%rowtype;
2974: l_line_rec OE_ORDER_LINES_ALL%rowtype;
2975: TYPE entity_rec IS RECORD (entity_code oe_hold_sources_all.hold_entity_code%TYPE,
2976: entity_id oe_hold_sources_all.hold_entity_id%TYPE);
2977:
2978: TYPE entity_tab IS TABLE OF entity_rec INDEX BY BINARY_INTEGER;

Line 3035: FROM oe_order_headers OH,oe_order_lines OL

3031: END IF;
3032: --ER#7479609 start
3033: BEGIN
3034: SELECT OH.* INTO l_header_rec
3035: FROM oe_order_headers OH,oe_order_lines OL
3036: WHERE OH.header_id=OL.header_id
3037: AND OL.line_id=l_line_id;
3038:
3039: l_header_id := l_header_rec.header_id;

Line 3070: FROM oe_order_lines

3066: l_line_number,
3067: l_blanket_number,
3068: l_blanket_line_number,
3069: l_header_id
3070: FROM oe_order_lines
3071: WHERE line_id = l_line_id;
3072: ER#7479609 end*/
3073:
3074: --ER#7479609 start

Line 3076: FROM oe_order_lines

3072: ER#7479609 end*/
3073:
3074: --ER#7479609 start
3075: SELECT * INTO l_line_rec
3076: FROM oe_order_lines
3077: WHERE line_id = l_line_id;
3078: --ER#7479609 end
3079:
3080: --OE_LINE_UTIL.Query_Row(p_line_id => l_line_id,

Line 3623: -- FROM OE_ORDER_LINES

3619: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3620: -- Get the line number from the line record
3621: --SELECT line_number
3622: -- INTO l_line_number
3623: -- FROM OE_ORDER_LINES
3624: -- WHERE LINE_ID = p_entity_id;
3625: --FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3626: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3627: OE_MSG_PUB.ADD;

Line 3892: -- FROM OE_ORDER_LINES

3888: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3889: -- Get the line number from the line record
3890: --SELECT line_number
3891: -- INTO l_line_number
3892: -- FROM OE_ORDER_LINES
3893: -- WHERE LINE_ID = p_entity_id;
3894: --FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3895: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3896: OE_MSG_PUB.ADD;

Line 4267: l_line_rec OE_ORDER_LINES_ALL%rowtype;

4263: AND HS.HOLD_ENTITY_CODE <> 'O';
4264: */
4265: --ER#7479609 start
4266: l_header_rec OE_ORDER_HEADERS_ALL%rowtype;
4267: l_line_rec OE_ORDER_LINES_ALL%rowtype;
4268: TYPE entity_rec IS RECORD (entity_code oe_hold_sources_all.hold_entity_code%TYPE,
4269: entity_id oe_hold_sources_all.hold_entity_id%TYPE);
4270:
4271: TYPE entity_tab IS TABLE OF entity_rec INDEX BY BINARY_INTEGER;

Line 4326: FROM oe_order_headers OH,oe_order_lines OL

4322:
4323: --ER#7479609 start
4324: BEGIN
4325: SELECT OH.* INTO l_header_rec
4326: FROM oe_order_headers OH,oe_order_lines OL
4327: WHERE OH.header_id=OL.header_id
4328: AND OL.line_id=l_line_id;
4329:
4330: EXCEPTION

Line 4359: FROM oe_order_lines

4355: l_line_number,
4356: l_blanket_number,
4357: l_blanket_line_number,
4358: l_header_id
4359: FROM oe_order_lines
4360: WHERE line_id = l_line_id;
4361: ER#7479609 end*/
4362: --ER#7479609 start
4363: SELECT * INTO l_line_rec

Line 4364: FROM oe_order_lines

4360: WHERE line_id = l_line_id;
4361: ER#7479609 end*/
4362: --ER#7479609 start
4363: SELECT * INTO l_line_rec
4364: FROM oe_order_lines
4365: WHERE line_id = l_line_id;
4366: --ER#7479609 end
4367:
4368: EXCEPTION

Line 4920: -- FROM OE_ORDER_LINES

4916: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4917: -- Get the line number from the line record
4918: --SELECT line_number
4919: -- INTO l_line_number
4920: -- FROM OE_ORDER_LINES
4921: -- WHERE LINE_ID = p_entity_id;
4922: --FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
4923: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
4924: OE_MSG_PUB.ADD;