USP_DATALIST_BILLINGGENERATETRANSACTIONSPROCESS

List of generate transactions business processes.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_BILLINGGENERATETRANSACTIONSPROCESS
(
    @CURRENTAPPUSERID uniqueidentifier = null
)
as
    set nocount on;

    select PROCESS.ID,
           PROCESS.TRANSACTIONTYPECODE,
           PROCESS.TRANSACTIONTYPE,
           PROCESS.NAME,
           PROCESS.DESCRIPTION,
           PROCESS.OUTPUTSELECTIONNAME,
           PROCESS.EXCEPTIONSELECTIONNAME
    from dbo.BILLINGGENERATETRANSACTIONSPROCESS PROCESS
        left join dbo.BUSINESSPROCESSINSTANCE BPI on PROCESS.ID = BPI.BUSINESSPROCESSPARAMETERSETID
    where 
        dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, PROCESS.ID) = 1
    order by PROCESS.TRANSACTIONTYPECODE, PROCESS.NAME