USP_DATALIST_ADHOCQUERYDEPENDENCYOTHER

CREATE procedure dbo.USP_DATALIST_ADHOCQUERYDEPENDENCYOTHER
(
    @ID uniqueidentifier
)
as
    set nocount on;

    select
        ADHOCQUERYDEPENDENCY.ID as ID,
        ADHOCQUERYDEPENDENCY.RECORDID as DEPENDENCYID, 
        ADHOCQUERYDEPENDENCY.TABLENAME as NAME,
        ADHOCQUERYDEPENDENCY.TABLENAME as OBJECTTYPE,
        case when ADHOCQUERYDEPENDENCY.DELETEREFERENTIALACTIONDESCRIPTION = 'NO_ACTION' then 1 else 0 end ACTION,
        ADHOCQUERYDEPENDENCY.TABLEDESCRIPTION as ADDITIONALINFO
    from dbo.ADHOCQUERYDEPENDENCY
    where ADHOCQUERYDEPENDENCY.DBTABLENAME not in ('ADHOCQUERYIDSETDEPENDENCY', 'EXPORTPROCESS', 'SMARTQUERYINSTANCE','SMARTFIELD','TASKCATALOG') --Other dependencies

    and ADHOCQUERYDEPENDENCY.ADHOCQUERYID = @ID  
    order by ACTION desc