Skip Rule for Supplier Registration based on DFF

Summary:

We have a attribute1 called CR number in the supplier Profile, same attribute1 is available in supplier registration external as well.

We have created a auto rejected rule in the below stage and normal rule based on prospective and spend authorized in the next stage.

Now we have created skip rule in the first stage with below SQL

oraext:query-database(SELECT     CASE         WHEN t1.attribute1 = t2.attribute1 THEN 'Yes'         ELSE 'No'     END AS matchstatusFROM     poz_suppliers t1,     poz_supplier_registrations t2WHERE     t1.vendor_id (+) = t2.vendor_id     AND t2.last_update_date = (         SELECT             MAX(a.last_update_date)         FROM             poz_supplier_registrations a ))='No'