Alert when Supplier Bank Account details are updated
Hello Experts
We have a requirement to let few people know when the supplier bank account details are updated. For this I created an alert but it is not working. I got the query from my techie and struggling to find out what the error is with the query.
Select distinct s.vendor_id, S.PAYMENT_METHOD_LOOKUP_CODE, SS.PAYMENT_METHOD_LOOKUP_CODE,s.vendor_name, s.segment1 as "Supplier_Code", s.enabled_flag,
s.vendor_type_lookup_code, s.start_date_active, s.end_date_active, s.vat_registration_num,
ss.vendor_site_code, eb.bank_name, ebb.bank_branch_name, ebb.branch_number,