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_WORKORDERS_JSP dependencies on CSI_ITEM_INSTANCES

Line 1262: from csi_item_instances cii, mtl_system_items_b_kfv msikfv, mtl_parameters mp

1258: if(p_asset_number is not null) then
1259: select nvl(cii.active_start_date, sysdate-1),
1260: nvl(cii.active_start_date, sysdate-1),msikfv.eam_item_type
1261: into l_start_date, l_end_date, l_eam_item_type
1262: from csi_item_instances cii, mtl_system_items_b_kfv msikfv, mtl_parameters mp
1263: where cii.inventory_item_id =msikfv.inventory_item_id
1264: and cii.last_vld_organization_id =msikfv.organization_id --Bug 2157979
1265: and cii.last_vld_organization_id = mp.organization_id
1266: and mp.maint_organization_id = p_organization_id

Line 1298: from csi_item_instances cii, mtl_system_items_b_kfv msikfv,

1294: if (p_asset_number is not null) then
1295: select cii.inventory_item_id , eomd.ACCOUNTING_CLASS_CODE,
1296: cii.instance_id, msikfv.eam_item_type , eomd.area_id
1297: into l_asset_group_id, l_asset_class, l_maintenance_object_id, l_eam_item_type , l_eam_location_id
1298: from csi_item_instances cii, mtl_system_items_b_kfv msikfv,
1299: mtl_parameters mp, eam_org_maint_defaults eomd
1300: where cii.inventory_item_id =msikfv.inventory_item_id
1301: and cii.last_vld_organization_id =msikfv.organization_id --Bug 2157979
1302: and cii.last_vld_organization_id = mp.organization_id