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