Introduction
This Post is about to Supplier details with banks query in oracle r12.
Query for Supplier details with banks.
SELECT
aps.vendor_name|| ‘ ~ ‘|| ass.vendor_site_code “Payee_Identifier”
,accts.ext_bank_account_id “Payee_Bank_Account_Identifier”
,bank.party_name “bank_name”
,branch.bank_branch_name “Branch_Name”
,accts.country_code “account_country_code”
,accts.bank_account_name “Account_Name”
,accts.bank_account_num “Account_Number”
,accts.currency_code “Account_Currency_Code”
,NULL “Allow_International_Payments”
,uses.start_date “Account_start_date”
,uses.end_date “Account_end_date”
,accts.iban “IBAN”
,accts.check_digits “check_digits”
,accts.bank_account_name_alt “Account_Alternate_Name”
,accts.bank_account_type “Bank_account_type”
,accts.account_suffix “Account_Suffix”
,accts.description “DESCRIPTION”
,accts.agency_location_code “Agency_Location_Code”
,accts.exchange_rate_agreement_num “Exchange_Rate_Agreement_Number”
,accts.exchange_rate_agreement_type “Exchange_Rate_Agreement_Type”
,accts.exchange_rate “EXCHANGE_RATE”
,accts.secondary_account_reference “SECONDARY_ACCOUNT_REFERENCE”
FROM ap_suppliers aps
,ap_supplier_sites_all ass
,iby_pmt_instr_uses_all uses
,iby_external_payees_all payee
,iby_ext_bank_accounts accts
,hz_parties bank
,ce_bank_branches_v branch
WHERE uses.instrument_type = ‘BANKACCOUNT’
AND aps.vendor_id = ass.vendor_id
AND aps.party_id = payee.payee_party_id
AND payee.ext_payee_id = uses.ext_pmt_party_id
AND payee.payment_function = ‘PAYABLES_DISB’
AND uses.instrument_id = accts.ext_bank_account_id
AND accts.bank_id = bank.party_id
–AND accts.bank_id = bankprofile.party_id
AND accts.branch_id = branch.branch_party_id
AND aps.end_date_active IS NULL
AND ass.inactive_date IS NULL
What we expect in the script.
This script helps us to comprehend how to review detailed information about Supplier details with banks query. Couple of tables which is being used in the scripts are ap_suppliers aps,ap_supplier_sites_all ass ,iby_pmt_instr_uses_all uses,iby_external_payees_all payee,iby_ext_bank_accounts accts,hz_parties bank ,ce_bank_branches_v branch etc.
Summary
This Post described the script to review detailed information about invoices on hold in Oracle EBS R12.
Got any queries?
Do drop a note by writing us at contact@doyensys.com or use the comment section below to ask your questions.
