View: IBY_PAYEE_ALL_BANKACCT_V

Product:	IBY - Payments
Description:
Implementation/DBA Data:	APPS.IBY_PAYEE_ALL_BANKACCT_V

View Text

SELECT OWNER.ACCOUNT_OWNER_PARTY_ID PARTY_ID
, BANKACCT.EXT_BANK_ACCOUNT_ID EXT_BANK_ACCOUNT_ID
, BANKACCT.COUNTRY_CODE COUNTRY_CODE
, BANKACCT.BRANCH_ID BRANCH_ID
, BANKACCT.BANK_ID BANK_ID
, BANKACCT.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, BANKACCT.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, BANKACCT.CURRENCY_CODE CURRENCY_CODE
, BANKACCT.IBAN IBAN
, BANKACCT.CHECK_DIGITS CHECK_DIGITS
, BANKACCT.BANK_ACCOUNT_NAME_ALT BANK_ACCOUNT_NAME_ALT
, BANKACCT.BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE
, BANKACCT.ACCOUNT_SUFFIX ACCOUNT_SUFFIX
, BANKACCT.DESCRIPTION DESCRIPTION
, BANKACCT.AGENCY_LOCATION_CODE AGENCY_LOCATION_CODE
, BANKACCT.PAYMENT_FACTOR_FLAG PAYMENT_FACTOR_FLAG
, BANKACCT.FOREIGN_PAYMENT_USE_FLAG FOREIGN_PAYMENT_USE_FLAG
, BANKACCT.EXCHANGE_RATE_AGREEMENT_NUM EXCHANGE_RATE_AGREEMENT_NUM
, BANKACCT.EXCHANGE_RATE_AGREEMENT_TYPE EXCHANGE_RATE_AGREEMENT_TYPE
, BANKACCT.EXCHANGE_RATE EXCHANGE_RATE
, BANKACCT.START_DATE START_DATE
, BANKACCT.END_DATE END_DATE
, BANKINFO.BANK_NAME BANK_NAME
, BANKINFO.BANK_NUMBER BANK_NUMBER
, BANKINFO.BANK_BRANCH_NAME BRANCH_NAME
, BANKINFO.BRANCH_NUMBER BRANCH_NUMBER
, BANKACCT.IBAN BIC_NUMBER
, BANKINFO.BANK_NAME_ALT BANK_NAME_ALT
, BANKINFO.BANK_BRANCH_NAME_ALT BANK_BRANCH_NAME_ALT
, BANKINFO.BANK_INSTITUTION_TYPE BANK_INSTITUTION_TYPE
, BANKACCT.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, BANKACCT.ATTRIBUTE1 ATTRIBUTE1
, BANKACCT.ATTRIBUTE2 ATTRIBUTE2
, BANKACCT.ATTRIBUTE3 ATTRIBUTE3
, BANKACCT.ATTRIBUTE4 ATTRIBUTE4
, BANKACCT.ATTRIBUTE5 ATTRIBUTE5
, BANKACCT.ATTRIBUTE6 ATTRIBUTE6
, BANKACCT.ATTRIBUTE7 ATTRIBUTE7
, BANKACCT.ATTRIBUTE8 ATTRIBUTE8
, BANKACCT.ATTRIBUTE9 ATTRIBUTE9
, BANKACCT.ATTRIBUTE10 ATTRIBUTE10
, BANKACCT.ATTRIBUTE11 ATTRIBUTE11
, BANKACCT.ATTRIBUTE12 ATTRIBUTE12
, BANKACCT.ATTRIBUTE13 ATTRIBUTE13
, BANKACCT.ATTRIBUTE14 ATTRIBUTE14
, BANKACCT.ATTRIBUTE15 ATTRIBUTE15
, BANKACCT.CREATED_BY CREATED_BY
, BANKACCT.CREATION_DATE CREATION_DATE
, BANKACCT.LAST_UPDATED_BY LAST_UPDATED_BY
, BANKACCT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, BANKACCT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IBY_EXT_BANK_ACCOUNTS BANKACCT
, CE_BANK_BRANCHES_V BANKINFO
, IBY_ACCOUNT_OWNERS OWNER
WHERE BANKINFO.BANK_PARTY_ID(+) = BANKACCT.BANK_ID
AND BANKINFO.BRANCH_PARTY_ID(+) = BANKACCT.BRANCH_ID
AND OWNER.EXT_BANK_ACCOUNT_ID=BANKACCT.EXT_BANK_ACCOUNT_ID

Columns