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_LINE_UTIL dependencies on MTL_SYSTEM_ITEMS

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

4164: INTO l_is_model
4165: FROM oe_order_lines l
4166: WHERE top_model_line_id = p_x_line_rec.service_reference_line_id
4167: AND item_type_code = 'INCLUDED'
4168: AND exists (select null from mtl_system_items mtl where
4169: mtl.inventory_item_id = l.inventory_item_id and
4170: mtl.serviceable_product_flag = 'Y' and
4171: mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID') )
4172: AND ROWNUM = 1;

Line 4277: from mtl_system_items mtl

4273: end if;
4274: BEGIN
4275: select distinct 'Y'
4276: into l_serviceable_item
4277: from mtl_system_items mtl
4278: where mtl.inventory_item_id = p_x_line_rec.inventory_item_id
4279: and mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID')
4280: and mtl.serviceable_product_flag='Y';
4281: -- lchen added check for organizations to fix bug 2039304