DBA Data[Home] [Help]

APPS.OE_SERVICE_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 896: mtl_system_items m

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'));
900:

Line 947: mtl_system_items m

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'));
951: END IF;

Line 1653: mtl_system_items m

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'));
1657:

Line 2843: AND exists (select null from mtl_system_items mtl where

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
2845: mtl.serviceable_product_flag = 'Y');
2846:
2847: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;