UFN_QUERY_ATTRIBUTEFORMEXTENSION_LISTBUILDER

CREATE function dbo.[UFN_QUERY_ATTRIBUTEFORMEXTENSION_LISTBUILDER]()
returns @ATTRIBUTEFORMEXTENSION table
(
    [ID] uniqueidentifier,                         
    [EXTENDEDFORMNAME] nvarchar(100), 
    [TABCAPTION]  nvarchar(100), 
    [RECORDTYPE]  nvarchar(50),
    [ENABLED] bit,
    [RENDERSTYLE]  nvarchar(25)
)
with execute as caller as
begin

    with xmlnamespaces ('bb_appfx_commontypes' as common)
    insert into @ATTRIBUTEFORMEXTENSION (
        [ID],
        [EXTENDEDFORMNAME],
        [TABCAPTION],
        [RECORDTYPE],
        [ENABLED],
        [RENDERSTYLE]
    )
    select 
    ATTRIBUTEFORMEXTENSION.ID, 
        EXTENDEDINSTANCE.UINAME EXTENDEDFORMNAME,
        ATTRIBUTEFORMEXTENSION.TABCAPTION,
        RECORDTYPE.NAME RECORDTYPE,
        DATAFORMEXTENSION.ENABLED,
    coalesce(EXTENSIONTEMPLATE.TEMPLATESPECXML.value('(//common:DataFormExtension/@RenderStyle)[1]', 'nvarchar(11)'), 'Tab') RENDERSTYLE
    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
    order by EXTENDEDINSTANCE.UINAME;

    return;
end