APPS.EAM_REBUILD dependencies on MTL_PARAMETERS

Line 210: from csi_item_instances cii, mtl_parameters mp

206: --find maintenance object type,id,source
207: if (l_rebuild_item_id is not null and l_rebuild_serial_number is not null) then
208: BEGIN
209: select cii.instance_id into l_maintenance_object_id
210: from csi_item_instances cii, mtl_parameters mp
211: where cii.inventory_item_id = l_rebuild_item_id and cii.serial_number = l_rebuild_serial_number
212: and mp.organization_id = cii.last_vld_organization_id
213: and mp.maint_organization_id =l_org_id;
214:

Line 223: FROM mtl_system_items msi, mtl_parameters mp

219: END;
220: else
221: BEGIN
222: SELECT msi.inventory_item_id into l_maintenance_object_id
223: FROM mtl_system_items msi, mtl_parameters mp
224: WHERE msi.inventory_item_id = l_rebuild_item_id
225: and mp.organization_id = msi.organization_id
226: and mp.maint_organization_id =l_org_id
227: and rownum = 1;