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

Line 824: FROM oe_order_lines_all l, oe_order_headers h

820: , l_inventory_item_id
821: , l_blanket_number
822: , l_cust_po_number
823: , l_fulfilled_quantity --5699215
824: FROM oe_order_lines_all l, oe_order_headers h
825: WHERE h.order_number = p_x_line_rec.service_ref_order_number
826: AND l.line_number = p_x_line_rec.service_ref_line_number
827: AND l.shipment_number = p_x_line_rec.service_ref_shipment_number
828: AND NVL(l.option_number,0) = NVL(p_x_line_rec.service_ref_option_number, 0)

Line 854: FROM oe_order_lines_all l, oe_order_headers h

850: , l_header_id
851: , l_line_id
852: , l_inventory_item_id
853: , l_fulfilled_quantity --5699215
854: FROM oe_order_lines_all l, oe_order_headers h
855: WHERE h.order_number = p_x_line_rec.service_ref_order_number
856: AND l.line_number = p_x_line_rec.service_ref_line_number
857: AND l.shipment_number = p_x_line_rec.service_ref_shipment_number
858: AND NVL(l.option_number,0) = NVL(p_x_line_rec.service_ref_option_number, 0)

Line 901: FROM oe_order_lines l,

897: , l_serviceable -- 2331301
898: , l_blanket_number
899: , l_cust_po_number
900: , l_fulfilled_quantity --5699215
901: FROM oe_order_lines l,
902: mtl_system_items m
903: WHERE l.line_id = p_x_line_rec.service_reference_line_id
904: AND l.inventory_item_id = m.inventory_item_id
905: AND m.organization_id = to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));

Line 920: FROM oe_order_lines where line_id = l_top_model_id;

916: --if unable to get from currently referenced option item
917: IF l_blanket_number is NULL AND l_top_model_id is NOT NULL THEN
918: BEGIN
919: SELECT blanket_number into l_blanket_number
920: FROM oe_order_lines where line_id = l_top_model_id;
921: EXCEPTION
922: WHEN OTHERS THEN
923: l_blanket_number := null;
924: END;

Line 960: FROM oe_order_lines l,

956: , l_inventory_item_id
957: , l_top_model_id -- 2331301
958: , l_serviceable -- 2331301
959: , l_fulfilled_quantity --5699215
960: FROM oe_order_lines l,
961: mtl_system_items m
962: WHERE l.line_id = p_x_line_rec.service_reference_line_id
963: AND l.inventory_item_id = m.inventory_item_id
964: AND m.organization_id = to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));

Line 1149: from oe_order_lines

1145: end if;
1146:
1147: select nvl(max(service_number)+1,1)
1148: into l_service_number
1149: from oe_order_lines
1150: where header_id = l_header_id
1151: and line_number = l_line_number
1152: and shipment_number = l_shipment_number
1153: and nvl(option_number,0) = nvl(l_option_number,0)

Line 1683: FROM oe_order_lines l,

1679: , l_inventory_item_id
1680: , l_top_model_id -- 2331301
1681: , l_serviceable
1682: , l_fulfilled_quantity --5699215
1683: FROM oe_order_lines l,
1684: mtl_system_items m
1685: WHERE l.line_id = p_line_rec.service_reference_line_id
1686: AND l.inventory_item_id = m.inventory_item_id
1687: AND m.organization_id = to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));

Line 1809: from oe_order_lines

1805: x_line_rec.ordered_quantity := l_service_qty;
1806:
1807: select nvl(max(service_number)+1,1)
1808: into l_service_number
1809: from oe_order_lines
1810: where header_id = l_header_id
1811: and line_number = l_line_number
1812: and shipment_number = l_shipment_number
1813: and option_number = l_option_number

Line 1824: FROM oe_order_lines l

1820: BEGIN
1821: -- aksingh this has to be changed during testing -- see above comment also
1822: SELECT NVL(MAX(l.line_number)+1,1)
1823: INTO l_line_number
1824: FROM oe_order_lines l
1825: WHERE l.header_id = p_line_rec.header_id;
1826: END;
1827:
1828: x_line_rec.service_reference_line_id := l_line_id;

Line 2047: FROM oe_order_lines_all l, oe_order_headers h

2043: p_shipment_number is not null Then
2044:
2045: SELECT /* MOAC_SQL_CHANGE */ l.line_id
2046: INTO x_reference_line_id
2047: FROM oe_order_lines_all l, oe_order_headers h
2048: WHERE h.order_number = p_order_number
2049: AND h.header_id = l.header_id
2050: AND l.line_number = p_line_number
2051: AND l.shipment_number = p_shipment_number

Line 2683: from oe_order_lines_all

2679: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2680: BEGIN
2681: Select 'EXISTS' into
2682: l_exists
2683: from oe_order_lines_all
2684: where service_reference_line_id = l_line_id;
2685: p_result := 1;
2686:
2687: EXCEPTION

Line 2717: FROM oe_order_lines

2713: l_cascade_request_flag BOOLEAN := FALSE; -- for bug 2366503
2714:
2715: CURSOR order_lines (p_service_reference_line_id NUMBER) IS
2716: SELECT line_id
2717: FROM oe_order_lines
2718: WHERE p_service_reference_line_id = service_reference_line_id
2719: ORDER BY line_id;
2720: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2721: BEGIN

Line 2886: FROM oe_order_lines l

2882: -- to get the line_id for all childern for the model
2883:
2884: CURSOR model_children IS
2885: SELECT l.line_id
2886: FROM oe_order_lines l
2887: WHERE l.top_model_line_id = l_service_reference_line_id
2888: AND l.item_type_code in ('INCLUDED','CLASS','OPTION')
2889: AND exists (select null from mtl_system_items mtl where
2890: mtl.inventory_item_id = l.inventory_item_id and

Line 2957: FROM OE_ORDER_LINES

2953: EXIT when model_children%NOTFOUND;
2954: BEGIN
2955: SELECT LINE_ID
2956: INTO l_line_id
2957: FROM OE_ORDER_LINES
2958: WHERE INVENTORY_ITEM_ID = l_inventory_item_id
2959: AND service_reference_line_id = child_line_id
2960: AND item_type_code = 'SERVICE'
2961: -- AND ordered_item IS NULL This AND commented for 2556516

Line 3206: FROM oe_order_lines

3202: ( p_top_model_line_id IN NUMBER )
3203: IS
3204: CURSOR option_lines IS
3205: SELECT line_id, option_number
3206: FROM oe_order_lines
3207: WHERE top_model_line_id = p_top_model_line_id;
3208: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3209:
3210: TYPE num_tbl IS TABLE OF NUMBER;

Line 3226: UPDATE oe_order_lines_all

3222: FETCH option_lines BULK COLLECT INTO l_line_ids, l_option_numbers;
3223: CLOSE option_lines;
3224:
3225: FORALL i IN 1..l_line_ids.count
3226: UPDATE oe_order_lines_all
3227: SET option_number = l_option_numbers(i)
3228: WHERE service_reference_line_id = l_line_ids(i)
3229: AND service_reference_type_code = l_ref_type_code; -- For Bug 3087370
3230: