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 819: FROM oe_order_lines_all l, oe_order_headers h

815: , l_inventory_item_id
816: , l_blanket_number
817: , l_cust_po_number
818: , l_fulfilled_quantity --5699215
819: FROM oe_order_lines_all l, oe_order_headers h
820: WHERE h.order_number = p_x_line_rec.service_ref_order_number
821: AND l.line_number = p_x_line_rec.service_ref_line_number
822: AND l.shipment_number = p_x_line_rec.service_ref_shipment_number
823: AND NVL(l.option_number,0) = NVL(p_x_line_rec.service_ref_option_number, 0)

Line 849: FROM oe_order_lines_all l, oe_order_headers h

845: , l_header_id
846: , l_line_id
847: , l_inventory_item_id
848: , l_fulfilled_quantity --5699215
849: FROM oe_order_lines_all l, oe_order_headers h
850: WHERE h.order_number = p_x_line_rec.service_ref_order_number
851: AND l.line_number = p_x_line_rec.service_ref_line_number
852: AND l.shipment_number = p_x_line_rec.service_ref_shipment_number
853: AND NVL(l.option_number,0) = NVL(p_x_line_rec.service_ref_option_number, 0)

Line 895: FROM oe_order_lines l,

891: , l_serviceable -- 2331301
892: , l_blanket_number
893: , l_cust_po_number
894: , l_fulfilled_quantity --5699215
895: FROM oe_order_lines l,
896: mtl_system_items m
897: WHERE l.line_id = p_x_line_rec.service_reference_line_id
898: AND l.inventory_item_id = m.inventory_item_id
899: AND m.organization_id = to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));

Line 906: FROM oe_order_lines where line_id = l_top_model_id;

902: --if unable to get from currently referenced option item
903: IF l_blanket_number is NULL AND l_top_model_id is NOT NULL THEN
904: BEGIN
905: SELECT blanket_number into l_blanket_number
906: FROM oe_order_lines where line_id = l_top_model_id;
907: EXCEPTION
908: WHEN OTHERS THEN
909: l_blanket_number := null;
910: END;

Line 946: FROM oe_order_lines l,

942: , l_inventory_item_id
943: , l_top_model_id -- 2331301
944: , l_serviceable -- 2331301
945: , l_fulfilled_quantity --5699215
946: FROM oe_order_lines l,
947: mtl_system_items m
948: WHERE l.line_id = p_x_line_rec.service_reference_line_id
949: AND l.inventory_item_id = m.inventory_item_id
950: AND m.organization_id = to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));

Line 1135: from oe_order_lines

1131: end if;
1132:
1133: select nvl(max(service_number)+1,1)
1134: into l_service_number
1135: from oe_order_lines
1136: where header_id = l_header_id
1137: and line_number = l_line_number
1138: and shipment_number = l_shipment_number
1139: and nvl(option_number,0) = nvl(l_option_number,0)

Line 1652: FROM oe_order_lines l,

1648: , l_inventory_item_id
1649: , l_top_model_id -- 2331301
1650: , l_serviceable
1651: , l_fulfilled_quantity --5699215
1652: FROM oe_order_lines l,
1653: mtl_system_items m
1654: WHERE l.line_id = p_line_rec.service_reference_line_id
1655: AND l.inventory_item_id = m.inventory_item_id
1656: AND m.organization_id = to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));

Line 1774: from oe_order_lines

1770: x_line_rec.ordered_quantity := l_service_qty;
1771:
1772: select nvl(max(service_number)+1,1)
1773: into l_service_number
1774: from oe_order_lines
1775: where header_id = l_header_id
1776: and line_number = l_line_number
1777: and shipment_number = l_shipment_number
1778: and option_number = l_option_number

Line 1789: FROM oe_order_lines l

1785: BEGIN
1786: -- aksingh this has to be changed during testing -- see above comment also
1787: SELECT NVL(MAX(l.line_number)+1,1)
1788: INTO l_line_number
1789: FROM oe_order_lines l
1790: WHERE l.header_id = p_line_rec.header_id;
1791: END;
1792:
1793: x_line_rec.service_reference_line_id := l_line_id;

Line 2007: FROM oe_order_lines_all l, oe_order_headers h

2003: p_shipment_number is not null Then
2004:
2005: SELECT /* MOAC_SQL_CHANGE */ l.line_id
2006: INTO x_reference_line_id
2007: FROM oe_order_lines_all l, oe_order_headers h
2008: WHERE h.order_number = p_order_number
2009: AND h.header_id = l.header_id
2010: AND l.line_number = p_line_number
2011: AND l.shipment_number = p_shipment_number

Line 2637: from oe_order_lines_all

2633: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2634: BEGIN
2635: Select 'EXISTS' into
2636: l_exists
2637: from oe_order_lines_all
2638: where service_reference_line_id = l_line_id;
2639: p_result := 1;
2640:
2641: EXCEPTION

Line 2671: FROM oe_order_lines

2667: l_cascade_request_flag BOOLEAN := FALSE; -- for bug 2366503
2668:
2669: CURSOR order_lines (p_service_reference_line_id NUMBER) IS
2670: SELECT line_id
2671: FROM oe_order_lines
2672: WHERE p_service_reference_line_id = service_reference_line_id
2673: ORDER BY line_id;
2674: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2675: BEGIN

Line 2840: FROM oe_order_lines l

2836: -- to get the line_id for all childern for the model
2837:
2838: CURSOR model_children IS
2839: SELECT l.line_id
2840: FROM oe_order_lines l
2841: WHERE l.top_model_line_id = l_service_reference_line_id
2842: AND l.item_type_code in ('INCLUDED','CLASS','OPTION')
2843: AND exists (select null from mtl_system_items mtl where
2844: mtl.inventory_item_id = l.inventory_item_id and

Line 2911: FROM OE_ORDER_LINES

2907: EXIT when model_children%NOTFOUND;
2908: BEGIN
2909: SELECT LINE_ID
2910: INTO l_line_id
2911: FROM OE_ORDER_LINES
2912: WHERE INVENTORY_ITEM_ID = l_inventory_item_id
2913: AND service_reference_line_id = child_line_id
2914: AND item_type_code = 'SERVICE'
2915: -- AND ordered_item IS NULL This AND commented for 2556516

Line 3160: FROM oe_order_lines

3156: ( p_top_model_line_id IN NUMBER )
3157: IS
3158: CURSOR option_lines IS
3159: SELECT line_id, option_number
3160: FROM oe_order_lines
3161: WHERE top_model_line_id = p_top_model_line_id;
3162: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3163:
3164: TYPE num_tbl IS TABLE OF NUMBER;

Line 3180: UPDATE oe_order_lines_all

3176: FETCH option_lines BULK COLLECT INTO l_line_ids, l_option_numbers;
3177: CLOSE option_lines;
3178:
3179: FORALL i IN 1..l_line_ids.count
3180: UPDATE oe_order_lines_all
3181: SET option_number = l_option_numbers(i)
3182: WHERE service_reference_line_id = l_line_ids(i)
3183: AND service_reference_type_code = l_ref_type_code; -- For Bug 3087370
3184: