Suppliers Bank Details in Oracle APPS R12

SELECT (SELECT VENDOR_NAME

FROM PO_VENDORS POV

WHERE POV.VENDOR_ID=PVS.VENDOR_ID ) SUPPLIER_NAME,PVS.VENDOR_ID,(SELECT SEGMENT1 FROM

PO_VENDORS POV

WHERE POV.VENDOR_ID=PVS.VENDOR_ID )

VENDOR_NUMBER,PVS.VENDOR_SITE_CODE,BANKACCT.BANK_ACCOUNT_NAME,BANKACCT.BANK_ACCOUNT_NUM

FROM IBY_PMT_INSTR_USES_ALL INSTR_ASSIGN,IBY_EXTERNAL_PAYEES_ALL

PAYEE,IBY_EXT_BANK_ACCOUNTS BANKACCT,CE_BANK_BRANCHES_V CEBRANCH,PO_VENDOR_SITES_ALL

PVS,IBY_ACCOUNT_OWNERS IAOWHERE INSTR_ASSIGN.INSTRUMENT_ID = BANKACCT.EXT_BANK_ACCOUNT_ID

AND INSTR_ASSIGN.EXT_PMT_PARTY_ID = PAYEE.EXT_PAYEE_ID

AND INSTR_ASSIGN.INSTRUMENT_TYPE = 'BANKACCOUNT'AND INSTR_ASSIGN.PAYMENT_FLOW =

'DISBURSEMENTS'AND BANKACCT.BRANCH_ID = CEBRANCH.BRANCH_PARTY_ID(+)AND

IAO.EXT_BANK_ACCOUNT_ID= BANKACCT.EXT_BANK_ACCOUNT_ID

AND IAO.ACCOUNT_OWNER_PARTY_ID =PAYEE_PARTY_ID

AND PAYEE.SUPPLIER_SITE_ID =PVS.VENDOR_SITE_ID

AND PAY_SITE_FLAG ='Y'

AND BANKACCT.BANK_ACCOUNT_NUM='00266471' (Pass Banks Account or leave blank)