APPS.OE_SERVICE_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 902: mtl_system_items m

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

Line 961: mtl_system_items m

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

Line 1684: mtl_system_items m

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

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

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
2891: mtl.serviceable_product_flag = 'Y');
2892:
2893: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;