Hi folks,
need help to put validation .
when udf field is yes then related proerty should check.and tick while add /update bp master vendor.
IF :object_type = '2' AND (:transaction_type='A' or :transaction_type='U') THEN
select
(
SELECT 1
FROM OCRD T0
WHERE T0."CardCode"=:list_of_cols_val_tab_del
AND IFNULL(T0."U_MSME",'')='YES') AND T0."QryGroup64"='N' INTO cnt FROM DUMMY;
IF :cnt > 0 THEN
error := -4002;
error_message := 'Please Select Property';
END IF;
END IF;
