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_ACTIVITYASSOCIATION_PVT dependencies on MTL_PARAMETERS

Line 1019: FROM csi_item_instances cii, mtl_system_items_b msi, mtl_parameters mp

1015: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Type = 3
1016: THEN
1017: -- type = 3, id is cii.instance_id
1018: SELECT count(cii.instance_id) into l_count
1019: FROM csi_item_instances cii, mtl_system_items_b msi, mtl_parameters mp
1020: WHERE cii.instance_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Id
1021: AND mp.organization_id = cii.last_vld_organization_id
1022: AND mp.maint_organization_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Organization_Id
1023: AND cii.last_vld_organization_id = msi.organization_id

Line 1052: FROM mtl_system_items_b msi, mtl_parameters mp

1048: ELSIF l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Type = 2
1049: THEN
1050: -- type = 2
1051: SELECT count(inventory_item_id) into l_count
1052: FROM mtl_system_items_b msi, mtl_parameters mp
1053: WHERE msi.inventory_item_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Id
1054: AND mp.maint_organization_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Organization_Id
1055: AND mp.organization_id = msi.organization_id
1056: AND msi.eam_item_type in (1,3);

Line 1565: FROM csi_item_instances cii, mtl_parameters mp

1561: -- I: Find out the inventory_item_id
1562: BEGIN
1563: SELECT cii.inventory_item_id, mp.maint_organization_id
1564: INTO l_inventory_item_id, l_organization_id
1565: FROM csi_item_instances cii, mtl_parameters mp
1566: WHERE cii.instance_id = p_maintenance_object_id
1567: AND mp.organization_id = cii.last_vld_organization_id ;
1568: EXCEPTION
1569: WHEN OTHERS THEN