Payables and Cash Management - EBS (MOSC)

MOSC Banner

Alert when Supplier Bank Account details are updated

edited Jan 19, 2016 10:04AM in Payables and Cash Management - EBS (MOSC) 8 commentsAnswered

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center