VPD Restrict Data Access
Summary
VPD Restrict Data AccessContent
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
0