Translate

Saturday, August 20, 2016

Query to get Supplier Bank

SELECT DISTINCT ieb.bank_name
               FROM ap.ap_supplier_sites_all apss,
                    apps.iby_ext_bank_accounts ieba,
                    apps.iby_account_owners iao,
                    apps.iby_ext_banks_v ieb
              WHERE     apss.vendor_id = 123
                    AND iao.account_owner_party_id = ac.party_id
                    AND ieba.ext_bank_account_id = iao.ext_bank_account_id
                    AND ieba.bank_id = ieb.bank_party_id
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Featured Post

To Add user Responsibility like another user

DECLARE    lc_user_name              VARCHAR2 (100) := 'ALI';    lc_resp_appl_short_name   VARCHAR2 (100) := 'SYSADMIN'; ...

  • Query to get Customer Contact
    SELECT hcasa.org_id,        role_acct.account_number,        hcasa.orig_system_reference,        rel.subject_id,        rel.object_id, ...
  • Query to get Customer Information
    SELECT party.party_type customer_type,          party.party_name organization_name,          acct.account_number,          acct.account_...
  • Query to get GL drill down to AP
    SELECT 'AP' source,                asup.segment1 vendor_number,                asup.vendor_name,                h.je_category, ...