DBA Data[Home] [Help]

APPS.EAM_PROCESS_ISOLATION_PVT dependencies on CSI_ITEM_INSTANCES

Line 681: FROM csi_item_instances

677: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking asset existence for establishment'); end if;
678:
679: SELECT COUNT(*)
680: INTO l_count
681: FROM csi_item_instances
682: WHERE instance_id = l_establish_iso_rec.maintenance_object_id
683: AND (last_vld_organization_id = p_organization_id
684: OR last_vld_organization_id IN (SELECT organization_id from mtl_parameters where MAINT_ORGANIZATION_ID = p_organization_id));
685: