USP_DATAFORMTEMPLATE_VIEW_MERCHANDISEPRODUCTINSTANCEHISTORYDETAIL

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MERCHANDISEPRODUCTINSTANCEHISTORYDETAIL
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @CURRENTAPPUSERID uniqueidentifier = null,
    @COMMENTS nvarchar(255) = null output,
    @REASON nvarchar(100) = null output,
    @SOURCETYPECODE tinyint = null output,
    @ACTIONTYPECODE tinyint = null output,
    @BATCHDESCRIPTION nvarchar(1000) = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    declare @ISSYSADMIN bit = dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID)

    select 
        @DATALOADED = 1,
        @COMMENTS = mpih.COMMENTS,
        @REASON = marc.DESCRIPTION,
        @SOURCETYPECODE = mpih.SOURCETYPECODE,
        @ACTIONTYPECODE = mpih.ACTIONTYPECODE,
        @BATCHDESCRIPTION = BATCH.DESCRIPTION    
    from dbo.MERCHANDISEPRODUCTINSTANCEHISTORY as mpih
    left outer join dbo.MERCHANDISEADJUSTMENTREASONCODE as marc
        on mpih.MERCHANDISEADJUSTMENTREASONCODEID = marc.ID
    left outer join dbo.BATCH
        on mpih.BATCHID = BATCH.ID
    where (mpih.ID = @ID)
        and ((@ISSYSADMIN = 1) or (dbo.UFN_SECURITY_APPUSER_GRANTED_CODETABLEENTRY(@CURRENTAPPUSERID, mpih.MERCHANDISEADJUSTMENTREASONCODEID) = 1))

    return 0;