USP_DATALIST_ATTRIBUTEFORMEXTENSION

CREATE procedure dbo.USP_DATALIST_ATTRIBUTEFORMEXTENSION (@RECORDTYPEID uniqueidentifier = null)
as
    set nocount on;

    with xmlnamespaces ('bb_appfx_commontypes' as common)
    select 
        ATTRIBUTEFORMEXTENSION.ID, 
        EXTENDEDINSTANCE.UINAME EXTENDEDFORMNAME,
        ATTRIBUTEFORMEXTENSION.TABCAPTION,
        RECORDTYPE.NAME RECORDTYPE,
        DATAFORMEXTENSION.ENABLED,
        coalesce(EXTENSIONTEMPLATE.TEMPLATESPECXML.value('(//common:DataFormExtension/@RenderStyle)[1]', 'nvarchar(11)'), 'Tab')
    from dbo.ATTRIBUTEFORMEXTENSION
        left join dbo.DATAFORMINSTANCECATALOG EXTENDEDINSTANCE on ATTRIBUTEFORMEXTENSION.EXTENDEDDATAFORMINSTANCECATALOGID = EXTENDEDINSTANCE.ID
        left join dbo.DATAFORMTEMPLATECATALOG EXTENDEDTEMPLATE on EXTENDEDINSTANCE.DATAFORMTEMPLATECATALOGID = EXTENDEDTEMPLATE.ID
        left join dbo.DATAFORMEXTENSION on ATTRIBUTEFORMEXTENSION.EXTENSIONDATAFORMINSTANCECATALOGID = DATAFORMEXTENSION.ID
        left join dbo.DATAFORMINSTANCECATALOG EXTENSIONINSTANCE on ATTRIBUTEFORMEXTENSION.EXTENSIONDATAFORMINSTANCECATALOGID = EXTENSIONINSTANCE.ID
        left join dbo.DATAFORMTEMPLATECATALOG EXTENSIONTEMPLATE on EXTENSIONINSTANCE.DATAFORMTEMPLATECATALOGID = EXTENSIONTEMPLATE.ID        
        left join dbo.RECORDTYPE on EXTENDEDTEMPLATE.RECORDTYPEID = RECORDTYPE.ID
    where (@RECORDTYPEID is null or EXTENDEDTEMPLATE.RECORDTYPEID = @RECORDTYPEID)
    order by EXTENDEDINSTANCE.UINAME;