USP_BUSINESSPROCESSVIEW_GETVIEWINFORMATION

            CREATE procedure USP_BUSINESSPROCESSVIEW_GETVIEWINFORMATION(@ID as uniqueidentifier)
            with execute as caller
            as 
            begin
                set nocount on

                select
                    QUERYVIEW.OBJECTNAME, 
                    BUSINESSPROCESSVIEW.JOINFIELD,
                    QUERYVIEW.QUERYVIEWSPEC
                from
                    dbo.BUSINESSPROCESSVIEW
                    inner join dbo.QUERYVIEWCATALOG as QUERYVIEW ON QUERYVIEW.ID = BUSINESSPROCESSVIEW.QUERYVIEWCATALOGID
                where
                    BUSINESSPROCESSVIEW.ID = @ID

                return 0
            end