1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Query To Display Vendor wise Remit To Bank Account Number

Discussion in 'Oracle Apps Technical' started by jagadekara, Nov 25, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    This is a Query To Display Vendor wise Remit To Bank Account Number

    Code (SQL):
    SELECT DISTINCT pv.vendor_name,
                ie.masked_bank_account_num,
                invoice_num,
               cb.bank_name
      FROM po_vendors pv,
               ap_invoices_all ap,
               iby_ext_bank_accounts ie,
               apps.ce_bank_branches_v cb
    WHERE ap.vendor_id = pv.vendor_id
          AND ap.external_bank_account_id = ie.ext_bank_account_id(+)
         AND ie.branch_id = cb.branch_party_id(+)
         AND  ie.bank_id = cb.bank_party_id(+)
      --  AND  pv.vendor_name = 'Test'
    --    and invoice_num='ABC1234'