USP_DATALIST_MAPENTITIESFORAPPUSER

                    CREATE procedure USP_DATALIST_MAPENTITIESFORAPPUSER(
                        @CURRENTAPPUSERID uniqueidentifier
                    ) as

                        set nocount on;

                        select distinct
                            MEC.ID,
                            MEC.UINAME NAME,
                            MEC.DESCRIPTION,
                            FROMREC.NAME FROMRECORDTYPE,
                            MAPPEDREC.NAME MAPPEDRECORDTYPE,
                            ADDRESSREC.NAME ADDRESSRECORDTYPE,
                            MEC.RETURNSMULTIPLE,
                            MEC.IDISSELECTIONID,
                            MEC.SEARCHLISTID,
                            MEC.ADDDATAFORMINSTANCEID,
                            MEC.IMAGEKEY,
                            MEC.NAVIGATIONPAGEID
                        from
                            APPUSER AU
                        left join SYSTEMROLEAPPUSER SRAU
                            on SRAU.APPUSERID = AU.ID and AU.ISSYSADMIN = 0
                        left join SYSTEMROLE SR
                            on SR.ID = SRAU.SYSTEMROLEID
                        left join SYSTEMROLEPERM_MAPENTITY SRPME
                            on SRPME.SYSTEMROLEID = SR.ID
                        left join MAPENTITYCATALOG MEC
                            on MEC.ID = SRPME.MAPENTITYCATALOGID or AU.ISSYSADMIN = 1
                        left join RECORDTYPE FROMREC
                            on MEC.FROMRECORDTYPEID = FROMREC.ID
                        left join RECORDTYPE ADDRESSREC
                            on MEC.ADDRESSRECORDTYPEID = ADDRESSREC.ID
                        left join RECORDTYPE MAPPEDREC
                            on MEC.MAPPEDRECORDTYPEID = MAPPEDREC.ID
                        where
                            AU.ID = @CURRENTAPPUSERID and MEC.ID is not null
                            and
                            -- Map entity allowed by product flags.

                            1 = dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED
                            (
                                MEC.MAPENTITYXML.query
                                    (
                                        'declare namespace common="bb_appfx_commontypes";
                                        /*/common:InstalledProductList'
                                    )
                            )