APPS.EAM_ACTIVITYASSOCIATION_PVT dependencies on MTL_PARAMETERS

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

1096: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Type = 3
1097: THEN
1098: -- type = 3, id is cii.instance_id
1099: SELECT count(cii.instance_id) into l_count
1100: FROM csi_item_instances cii, mtl_system_items_b msi, mtl_parameters mp
1101: WHERE cii.instance_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Id
1102: AND mp.organization_id = cii.last_vld_organization_id
1103: AND mp.maint_organization_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Organization_Id
1104: AND cii.last_vld_organization_id = msi.organization_id

Line 1133: FROM mtl_system_items_b msi, mtl_parameters mp

1129: ELSIF l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Type = 2
1130: THEN
1131: -- type = 2
1132: SELECT count(inventory_item_id) into l_count
1133: FROM mtl_system_items_b msi, mtl_parameters mp
1134: WHERE msi.inventory_item_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Id
1135: AND mp.maint_organization_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Organization_Id
1136: AND mp.organization_id = msi.organization_id
1137: AND msi.eam_item_type in (1,3);

Line 1653: FROM csi_item_instances cii, mtl_parameters mp

1649: -- I: Find out the inventory_item_id
1650: BEGIN
1651: SELECT cii.inventory_item_id, mp.maint_organization_id
1652: INTO l_inventory_item_id, l_organization_id
1653: FROM csi_item_instances cii, mtl_parameters mp
1654: WHERE cii.instance_id = p_maintenance_object_id
1655: AND mp.organization_id = cii.last_vld_organization_id ;
1656: EXCEPTION
1657: WHEN OTHERS THEN