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.EAM_OPERATIONS_JSP dependencies on MTL_SYSTEM_ITEMS_KFV

Line 2339: and moq.inventory_item_id = (select inventory_item_id from mtl_system_items_kfv

2335: where moq.organization_id=msinv.organization_id
2336: and nvl(msinv.disable_date, sysdate+2) > sysdate
2337: and moq.subinventory_code = msinv.secondary_inventory_name
2338: and msinv.organization_id = p_organization_id
2339: and moq.inventory_item_id = (select inventory_item_id from mtl_system_items_kfv
2340: where organization_id = p_organization_id
2341: and concatenated_segments =p_concatenated_segments)
2342: group by msinv.secondary_inventory_name, moq.inventory_item_id, msinv.organization_id, msinv.description, msinv.locator_type
2343: order by msinv.secondary_inventory_name;

Line 2610: from mtl_system_items_kfv

2606:
2607: -- Get Inventory Item Id
2608: select inventory_item_id
2609: into l_inventory_item_id
2610: from mtl_system_items_kfv
2611: where concatenated_segments = p_concatenated_segments
2612: and organization_id = p_organization_id;
2613:
2614: begin

Line 2618: from wip_requirement_operations wro, mtl_system_items_kfv msikfv

2614: begin
2615:
2616: select 1, wro.operation_seq_num,wro.department_id,msikfv.description
2617: into l_material_exists, l_existing_operation, l_existing_department, l_existing_description
2618: from wip_requirement_operations wro, mtl_system_items_kfv msikfv
2619: where wro.inventory_item_id = l_inventory_item_id
2620: and wro.organization_id = p_organization_id
2621: and wro.wip_entity_id = p_wip_entity_id
2622: and wro.organization_id = msikfv.organization_id