View: AR_CUSTOMER_BANK_ACCOUNTS_V

Product:	AR - Receivables
Description:	(Release 10SC Only)
Implementation/DBA Data:	APPS.AR_CUSTOMER_BANK_ACCOUNTS_V

View Text

SELECT BAUSES.ROWID
, BAUSES.BANK_ACCOUNT_USES_ID
, BAUSES.LAST_UPDATE_DATE
, BAUSES.LAST_UPDATED_BY
, BAUSES.CREATION_DATE
, BAUSES.CREATED_BY
, BAUSES.LAST_UPDATE_LOGIN
, BAUSES.REQUEST_ID
, BAUSES.PROGRAM_APPLICATION_ID
, BAUSES.PROGRAM_ID
, BAUSES.PROGRAM_UPDATE_DATE
, BAUSES.CUSTOMER_ID
, BAUSES.CUSTOMER_SITE_USE_ID
, BAUSES.EXTERNAL_BANK_ACCOUNT_ID
, BAUSES.START_DATE
, BAUSES.END_DATE
, BAUSES.PRIMARY_FLAG
, BAUSES.ATTRIBUTE_CATEGORY
, BAUSES.ATTRIBUTE1
, BAUSES.ATTRIBUTE2
, BAUSES.ATTRIBUTE3
, BAUSES.ATTRIBUTE4
, BAUSES.ATTRIBUTE5
, BAUSES.ATTRIBUTE6
, BAUSES.ATTRIBUTE7
, BAUSES.ATTRIBUTE8
, BAUSES.ATTRIBUTE9
, BAUSES.ATTRIBUTE10
, BAUSES.ATTRIBUTE11
, BAUSES.ATTRIBUTE12
, BAUSES.ATTRIBUTE13
, BAUSES.ATTRIBUTE14
, BAUSES.ATTRIBUTE15
, BBNCH.BANK_NUMBER
, BBNCH.BANK_NAME
, BBNCH.BANK_BRANCH_NAME
, BBNCH.BANK_NUM
, BBNCH.DESCRIPTION
, BACCT.BANK_ACCOUNT_NAME
, DECODE (NVL(FND_PROFILE.VALUE('AR_MASK_BANK_ACCOUNT_NUMBERS')
, 'F')
, 'N'
, BACCT.BANK_ACCOUNT_NUM
, 'F'
, RPAD(SUBSTR(BACCT.BANK_ACCOUNT_NUM
, 1
, 4)
, LENGTH(BACCT.BANK_ACCOUNT_NUM)
, '*')
, 'L'
, LPAD(SUBSTR(BACCT.BANK_ACCOUNT_NUM
, -4)
, LENGTH(BACCT.BANK_ACCOUNT_NUM)
, '*'))
, BACCT.DESCRIPTION
, BACCT.CURRENCY_CODE
, BACCT.BANK_ACCOUNT_ID
, BBNCH.BANK_BRANCH_ID
FROM AP_BANK_ACCOUNT_USES BAUSES
, AP_BANK_BRANCHES BBNCH
, AP_BANK_ACCOUNTS BACCT
WHERE BAUSES.EXTERNAL_BANK_ACCOUNT_ID = BACCT.BANK_ACCOUNT_ID
AND BACCT.BANK_BRANCH_ID = BBNCH.BANK_BRANCH_ID

Columns