Item Master And BP block Querry or Restriction

----------------------------------/* Validation on @mitm@* Report Impact/---------------------

IF @object_type = '4' AND @transaction_type in('A','U')

BEGIN
If exists
(
Select ItemCode  From OITM
Where ItemCode =@list_of_cols_val_tab_del  
)

BEGIN
SELECT @Error = -0407
SELECT @error_message = 'Select Default WH [Message 173-9]'


END
end



--------------------/*Validation On @mbpm@* Report Impact/---------------
IF @object_type = '2'AND @transaction_type in('A','U')

BEGIN
If exists
(
Select cardcode From ocrd
Where cardcode =@list_of_cols_val_tab_del
)

BEGIN
SELECT @Error = -0406
SELECT @error_message = 'Invalid Code [Message 173-9]'


END
end