[Home] [Help]
View: 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
| PARTY_ID |
| EXT_BANK_ACCOUNT_ID |
| COUNTRY_CODE |
| BRANCH_ID |
| BANK_ID |
| BANK_ACCOUNT_NAME |
| BANK_ACCOUNT_NUM |
| CURRENCY_CODE |
| IBAN |
| CHECK_DIGITS |
| BANK_ACCOUNT_NAME_ALT |
| BANK_ACCOUNT_TYPE |
| ACCOUNT_SUFFIX |
| DESCRIPTION |
| AGENCY_LOCATION_CODE |
| PAYMENT_FACTOR_FLAG |
| FOREIGN_PAYMENT_USE_FLAG |
| EXCHANGE_RATE_AGREEMENT_NUM |
| EXCHANGE_RATE_AGREEMENT_TYPE |
| EXCHANGE_RATE |
| START_DATE |
| END_DATE |
| BANK_NAME |
| BANK_NUMBER |
| BRANCH_NAME |
| BRANCH_NUMBER |
| BIC_NUMBER |
| BANK_NAME_ALT |
| BANK_BRANCH_NAME_ALT |
| BANK_INSTITUTION_TYPE |
| ATTRIBUTE_CATEGORY |
| ATTRIBUTE1 |
| ATTRIBUTE2 |
| ATTRIBUTE3 |
| ATTRIBUTE4 |
| ATTRIBUTE5 |
| ATTRIBUTE6 |
| ATTRIBUTE7 |
| ATTRIBUTE8 |
| ATTRIBUTE9 |
| ATTRIBUTE10 |
| ATTRIBUTE11 |
| ATTRIBUTE12 |
| ATTRIBUTE13 |
| ATTRIBUTE14 |
| ATTRIBUTE15 |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |
| Name |
APPS.IBY_PAYEE_ALL_BANKACCT_V