DBA Data[Home] [Help]

VIEW: APPS.AR_CUSTOMER_BANK_ACCOUNTS_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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