Skip to Content
0
Former Member
May 18, 2016 at 07:23 AM

How to Block Batch Released

94 Views

Hi Experts,

I have configured user 16 for QC and only QC has to released the Batch.

I have the below SP, but its not working.

IF (@transaction_type in (N'U')) and (Object_Type='10000044')

Begin

if Exsist (select T0.AbsEntry from OBTN T0 Where T0.Status=0 and T0.UserSign2 Not IN (16) and

T0.AbsEntry = @list_of_cols_val_tab_del)

Begin

Set @error=1

Set @error_message='Only QC will released the Batch'

End

End

Thanks in Advance

Datta kharat