R12 E-Business Suite Suppliers Query - SQL to join Suppliers, Contacts, Banks In the Oracle E-Business Suite (EBS) Release 12 the data model of Suppliers has become much more complex. The base tables have changed (Suppliers, Sites, Bank Accounts, Contacts) and some of the fields have become obsolete. Here is a query to bring many of the Supplier attributes together, with focus on banks / bank accounts, payment methods, contacts, remittance delivery (email, notification method). Please post comments if you find any issues! Adjust the WHERE clause on the first WITH query to return the suppliers that you need to report on. Hope this query helps someone out. Add additional fields to the final query (or WITH queries as required.) with vendors as ( select vendor_id from ap_suppliers where 1=1 /* COMMENT / UNCOMMENT and UPDATE THE NEXT 5 LINES AS YOU REQUIRE */ --and vendor_type_lookup_code = 'VENDOR' --and upper( vendor_name ) like 'VIRTUATE%' and
Posts
Showing posts from May, 2014