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_REBUILDS_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 78: from mtl_system_items_b_kfv msi, mtl_parameters mp

74: and rownum = 1;
75: elsif (p_rebuild_item_name is not null) then
76: select inventory_item_id, serial_number_control_code
77: into p_rebuild_item_id, l_serial_control_code
78: from mtl_system_items_b_kfv msi, mtl_parameters mp
79: where msi.concatenated_segments = p_rebuild_item_name
80: and msi.organization_id = mp.organization_id
81: and mp.maint_organization_id = p_organization_id
82: and eam_item_type = 3

Line 191: from mtl_system_items_b_kfv

187:
188: begin
189: if (p_rebuild_activity_id is not null) then
190: select inventory_item_id into l_dummy_num
191: from mtl_system_items_b_kfv
192: where inventory_item_id = p_rebuild_activity_id
193: and organization_id = p_organization_id
194: and eam_item_type = 2;
195: elsif (p_rebuild_activity_name is not null) then

Line 197: from mtl_system_items_b_kfv

193: and organization_id = p_organization_id
194: and eam_item_type = 2;
195: elsif (p_rebuild_activity_name is not null) then
196: select inventory_item_id into p_rebuild_activity_id
197: from mtl_system_items_b_kfv
198: where concatenated_segments = p_rebuild_activity_name
199: and organization_id = p_organization_id
200: and eam_item_type = 2;
201: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then