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

Line 38: FROM csi_item_instances cii, mtl_system_items msi, mtl_parameters mp,eam_org_maint_defaults eomd

34: asset_group_id,
35: asset_number,
36: low_level_code)
37: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1
38: FROM csi_item_instances cii, mtl_system_items msi, mtl_parameters mp,eam_org_maint_defaults eomd
39: WHERE msi.eam_item_type = 1 AND msi.inventory_item_id = cii.inventory_item_id
40: AND msi.organization_id = cii.last_vld_organization_id AND msi.serial_number_control_code <> 1
41: AND nvl(cii.active_start_date, sysdate-1) <= sysdate AND nvl(cii.active_end_date, sysdate+1) >= sysdate
42: AND msi.organization_id = mp.organization_id AND mp.maint_organization_id = p_org_id

Line 70: FROM csi_item_instances cii, mtl_system_items msi, mtl_parameters mp,

66: asset_group_id,
67: asset_number,
68: low_level_code)
69: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1
70: FROM csi_item_instances cii, mtl_system_items msi, mtl_parameters mp,
71: (select * from eam_org_maint_defaults where organization_id = p_org_id) eomd
72: WHERE msi.eam_item_type = 1
73: AND msi.inventory_item_id = cii.inventory_item_id
74: AND msi.organization_id = cii.last_vld_organization_id

Line 280: FROM csi_item_instances cii, mtl_system_items msi, mtl_parameters mp,eam_org_maint_defaults eomd

276: asset_group_id,
277: asset_number,
278: low_level_code)
279: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1
280: FROM csi_item_instances cii, mtl_system_items msi, mtl_parameters mp,eam_org_maint_defaults eomd
281: WHERE msi.eam_item_type in (1,3) AND msi.inventory_item_id = cii.inventory_item_id
282: AND msi.organization_id = cii.last_vld_organization_id AND msi.serial_number_control_code <> 1
283: AND nvl(cii.active_start_date, sysdate-1) <= sysdate AND nvl(cii.active_end_date, sysdate+1) >= sysdate
284: AND msi.organization_id = mp.organization_id AND mp.maint_organization_id = p_org_id

Line 314: FROM csi_item_instances cii, mtl_system_items msi, mtl_parameters mp,

310: asset_group_id,
311: asset_number,
312: low_level_code)
313: SELECT eam_asset_explosion_temp_s.currval, cii.inventory_item_id, cii.serial_number, 1
314: FROM csi_item_instances cii, mtl_system_items msi, mtl_parameters mp,
315: (select * from eam_org_maint_defaults where organization_id = p_org_id) eomd
316: WHERE msi.eam_item_type in (1,3) AND msi.inventory_item_id = cii.inventory_item_id
317: AND msi.organization_id = cii.last_vld_organization_id AND msi.serial_number_control_code <> 1
318: AND nvl(cii.active_start_date, sysdate-1) <= sysdate AND nvl(cii.active_end_date, sysdate+1) >= sysdate