APPS.EAM_ACTIVITYASSOCIATION_PVT dependencies on CSI_ITEM_INSTANCES

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 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