VIEW: APPS.IBY_PAYEE_ALL_BANKACCT_V

Source

View Text - Preformatted

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, BankInfo.eft_swift_code 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

View Text - HTML Formatted

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
, BANKINFO.EFT_SWIFT_CODE 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