VPD Restrict Data Access

Summary

VPD Restrict Data Access

Content

Hello,

I'm working on OTM  V 6.4.2 and I want to make it required that, when a service provider declines a tender, he needs to fill a reason code.

Thus i'm creating a VPD for service providers and it has to have this structure (can't change it):

"select * from tablename where ...."

but after the where I don't know what to put as I am a newbie in SQL. I want to say "if acceptance_code = 'D' then decline_reason_code can't be null "

Thanks