How to find Supplier and Bank Details in Oracle Apps R12


SELECT        aps.vendor_name                    “Supplier Name”
             ,aps.vendor_id

             ,aps.segment1                       “Supplier Number”
             ,aps.party_id                       “Supplier Party_id”
             ,iepa.remit_advice_email            “Remit Advice Email”
             ,assa.vendor_site_id

             ,assa.party_site_id                 “Supplier Party_Site_id”
             ,assa.vendor_site_code              “Vendor Site Code”
             ,assa.purchasing_site_flag          “purchasing_site_flag“
             ,ieba.ext_bank_account_id

             ,hp.party_name                      “Bank_party_name“
             ,ieba.bank_account_num              “Bank_account_num“
             ,ieba.bank_account_name             “Bank_account_name“
             ,ieba.country_code                  “Bank_acct_country_code“
             ,ieba.currency_code                 “Bank_acct_currency_code“
             ,hp.address1                        “Bank_address_line1“
             ,hp.address2                        “Bank_address_line2“
             ,hp.address3                        “Bank_address_line3“
             ,hp.city                            “Bank_address_city“
             ,hp.state                           “Bank_address_state“
             ,hp.postal_code                     “Bank_address_zip“
             ,hp.country                         “Bank_address_country“
             ,hps.address1                       “Branch_address_line1“
             ,hps.address2                       “Branch_address_line2“
             ,hps.address3                       “Branch_address_line3“
             ,hps.city                           “Branch_address_city“
             ,hps.state                          “Branch_address_state“
             ,hps.postal_code                    “Branch_address_zip“
             ,hps.country                        “Branch_address_country“
FROM         ap_supplier_sites_all              assa

             ,hz_parties                         hp
 ,hz_parties                         hps                      

             ,iby_ext_bank_accounts              ieba

             ,iby_external_payees_all            iepa

             ,iby_pmt_instr_uses_all             ipiua            

             ,ap_suppliers                       aps

WHERE        assa.vendor_site_id         =      iepa.supplier_site_id

AND          ipiua.instrument_id         =      ieba.ext_bank_account_id

AND          ieba.branch_id              =      hps.party_id

AND          hp.party_id                 =      ieba.bank_id

AND          ipiua.ext_pmt_party_id      =      iepa.ext_payee_id

AND          assa.vendor_id              =      aps.vendor_id




Labels: , ,

2 comments:

Subscribe to: Post Comments (Atom)

How to find all cancel Requisitions

SELECT prha . *   FROM po_Requisition_headers_all prha , po_action_history pah   WHERE      1 = 1        AND pah . object_id ...

  • AP Invoice Interface
    This interface helps us to import vendor invoices into Oracle applications from external systems into Oracle Applications. Interface t...
  • ACCOUNT PAYABLES (AP) TABLES IN ORACLE APPS
    ACCOUNT PAYABLES (AP) TABLES  Payables: Defining Bank accounts (supplier bank a/c and our internal bank a/c) Defining Supplier D...