Query to find Supplier Bank Details
Oracle apps EBS sql to find Supplier Bank Details
--
SELECT /*Supplier Information*/
aps.segment1 oracle_supplier_number,
aps.vendor_id,
aps.vendor_name supplier_name,
aps.party_id supplier_party_id,
iepa.remit_advice_fax remit_advice_fax,
iepa.remit_advice_email remit_advice_email/* Supplier Site Information */
,
assa.vendor_site_id,
assa.party_site_id supplier_party_site_id,
assa.vendor_site_code vendor_site_code,
assa.pay_site_flag pay_site_flag,
assa.purchasing_site_flag purchasing_site_flag,
assa.rfq_only_site_flag rfq_only_site_flag/* Bank Information*/
,
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/* Bank Address */
,
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/* Bank Branch Address */
,
hp1.address1 branch_address_line1,
hp1.address2 branch_address_line2,
hp1.address3 branch_address_line3,
hp1.city branch_address_city,
hp1.state branch_address_state,
hp1.postal_code branch_address_zip,
hp1.country branch_address_country
FROM ap_supplier_sites_all assa,
hz_parties hp,
iby_ext_bank_accounts ieba,
iby_external_payees_all iepa,
iby_pmt_instr_uses_all ipiua,
ap_suppliers aps,
hz_parties hp1
WHERE assa.vendor_site_id = iepa.supplier_site_id
AND hp.party_id = ieba.bank_id
AND ipiua.instrument_id = ieba.ext_bank_account_id
AND ipiua.ext_pmt_party_id = iepa.ext_payee_id
AND assa.vendor_id = aps.vendor_id
AND ieba.branch_id = hp1.party_id
AND ipiua.instrument_type = 'BANKACCOUNT'
AND ipiua.payment_flow = 'DISBURSEMENTS'
AND ipiua.order_of_preference = 1
Related posts:
- How to Retrieve Period to Date (PTD) and Year to Date (YTD) Balances of GL Account in Oracle R12
- Supervisor Hierarchy and Approval Limits in Oracle EBS R12
- Query to find all Expense report entry delegations
- Query to find vacation rules in Oracle R12
- Purchase Order Receipt details query in Oracle apps
- Oracle apps query to find approval limits
- View accounting query in oracle apps R12
- Query to get AR invoice SLA and GL details
- Accounting entries not transferred to the General Ledger
- Query to find all APIs of Oracle Apps modules
- R12 AR cash receipt SLA and GL details query
- Oracle apps AR Applications and SLA details
- Oracle EBS query to get AP Invoice SLA Details
- Oracle EBS query to get AR Invoice SLA Details
- Oracle AR Remit to address query
- Oracle Apps iExpense credit card details query
- Query to get customer tax registration details in R12
- Purchase Requisition Vertex debug xml query in Oracle EBS
- Purchase Order Vertex debug xml query in Oracle EBS
- AP Invoice Vertex debug xml query in Oracle EBS
- AR Invoice Vertex debug xml query in Oracle EBS
- Query to find AP invoice workflow item key in oracle apps
- Query to find serial number material transactions details
- Query to find period status for Inventory General Ledger Purchasing Payables Receivables Fixed Assets
- Oracle apps EBS sql to get Fixed Asset (FA) details with Net Book Value (NBV) and Depreciation
- Query to find Sales Orders that are shipped but not invoiced
- Query to get Customer Bank Account Details
- Query to get description of GL Code Combination
- Query to find Purchase Order and Invoice Details
- Query to find AP Invoices matched with receipts
- Query to find Supplier Bank Details
- Query to find Credit Memos on an AP invoice
- Query to find the AP invoices that are applied to multiple Purchase Orders
- AR Invoice grouping rule from RA_INTERFACE_LINES_ALL
- Query to find shipset and fulfilment set