Query to Get Supplier Header Bank Account Details in Oracle Fusion - Orapoint

This query is useful to get supplier header level bank details with certain columns like Supplier name, bank name, bank account number, bank branch and basic details in Oracle Fusion Application

Supplier Important Table

POZ_SUPPLIERS_V
IBY_EXTERNAL_PAYEES_ALL
IBY_PMT_INSTR_USES_ALL
IBY_EXT_BANK_ACCOUNTS
ce_banks_v
ce_bank_BRANCHES_V
POZ_SUPPLIER_SITES_V

select 	DISTINCT
		aps.VENDOR_NAME,
		IEBA.BANK_ACCOUNT_NUM,
		IBAN,
		IEBA.BANK_ACCOUNT_NAME,
		cbv.BANK_NAME,
		cbv.ADDRESS_LINE1 BANK_ADDRESS_1,
		CBV.COUNTRY BANK_COUNTRY,
		CBV.CITY BANK_CITY,
		CBBV.BANK_BRANCH_NAME,
		CBBV.ADDRESS_LINE1 BRANCH_ADDRESS_1,
		CBBV.CITY BRANCH_CITY,
		CBBV.COUNTRY BRANCH_COUNTRY,
		CBBV.BRANCH_NUMBER,
		CBBV.EFT_SWIFT_CODE BIC ,
		FOREIGN_PAYMENT_USE_FLAG
from 	POZ_SUPPLIERS_V APS,
		IBY_EXTERNAL_PAYEES_ALL IEPA,
		IBY_PMT_INSTR_USES_ALL IPIUA,
		IBY_EXT_BANK_ACCOUNTS IEBA,
		ce_banks_v cbv, 
		ce_bank_BRANCHES_V CBBV, 
		POZ_SUPPLIER_SITES_V ass
where 	1=1
	AND APS.VENDOR_ID=ASS.VENDOR_ID
	AND IEPA.PAYEE_PARTY_ID=APS.PARTY_ID
	AND IPIUA.EXT_PMT_PARTY_ID(+)=IEPA.EXT_PAYEE_ID
	AND IEBA.EXT_BANK_ACCOUNT_ID(+)=IPIUA.INSTRUMENT_ID
	AND IEBA.BANK_ID=cbv.BANK_PARTY_ID(+)
	AND IEBA.BRANCH_ID=CBBV.BRANCH_PARTY_ID(+)