View: CE_INTERNAL_BANK_ACCTS_V

Product:	CE - Cash Management
Description:	Public view that shows all internal bank accounts including netting bank accounts.
Implementation/DBA Data:	APPS.CE_INTERNAL_BANK_ACCTS_V

View Text

SELECT DISTINCT BA.BANK_ACCOUNT_ID
, BA.BANK_ACCOUNT_NAME
, BA.LAST_UPDATE_DATE
, BA.LAST_UPDATED_BY
, BA.LAST_UPDATE_LOGIN
, BA.CREATION_DATE
, BA.CREATED_BY
, BA.BANK_ACCOUNT_NUM
, BA.BANK_BRANCH_ID
, BA.BANK_ID
, BA.CURRENCY_CODE
, BA.DESCRIPTION
, BA.ATTRIBUTE_CATEGORY
, BA.ATTRIBUTE1
, BA.ATTRIBUTE2
, BA.ATTRIBUTE3
, BA.ATTRIBUTE4
, BA.ATTRIBUTE5
, BA.ATTRIBUTE6
, BA.ATTRIBUTE7
, BA.ATTRIBUTE8
, BA.ATTRIBUTE9
, BA.ATTRIBUTE10
, BA.ATTRIBUTE11
, BA.ATTRIBUTE12
, BA.ATTRIBUTE13
, BA.ATTRIBUTE14
, BA.ATTRIBUTE15
, BA.REQUEST_ID
, BA.PROGRAM_APPLICATION_ID
, BA.PROGRAM_ID
, BA.PROGRAM_UPDATE_DATE
, BA.CHECK_DIGITS
, BA.BANK_ACCOUNT_NAME_ALT
, BA.ACCOUNT_HOLDER_ID
, BA.EFT_REQUESTER_IDENTIFIER
, BA.SECONDARY_ACCOUNT_REFERENCE
, BA.ACCOUNT_SUFFIX
, BA.DESCRIPTION_CODE1
, BA.DESCRIPTION_CODE2
, BA.IBAN_NUMBER
, BA.SHORT_ACCOUNT_NAME
, BA.ACCOUNT_OWNER_PARTY_ID
, BA.ACCOUNT_OWNER_ORG_ID
, BA.ACCOUNT_CLASSIFICATION
, BA.AP_USE_ALLOWED_FLAG
, BA.AR_USE_ALLOWED_FLAG
, BA.XTR_USE_ALLOWED_FLAG
, BA.PAY_USE_ALLOWED_FLAG
, BA.MULTI_CURRENCY_ALLOWED_FLAG
, BA.PAYMENT_MULTI_CURRENCY_FLAG
, BA.RECEIPT_MULTI_CURRENCY_FLAG
, BA.ZERO_AMOUNT_ALLOWED
, BA.MAX_OUTLAY
, BA.MAX_CHECK_AMOUNT
, BA.MIN_CHECK_AMOUNT
, BA.AP_AMOUNT_TOLERANCE
, BA.AR_AMOUNT_TOLERANCE
, BA.XTR_AMOUNT_TOLERANCE
, BA.PAY_AMOUNT_TOLERANCE
, BA.AP_PERCENT_TOLERANCE
, BA.AR_PERCENT_TOLERANCE
, BA.XTR_PERCENT_TOLERANCE
, BA.PAY_PERCENT_TOLERANCE
, BA.BANK_ACCOUNT_TYPE
, BA.AGENCY_LOCATION_CODE
, BA.START_DATE
, BA.END_DATE
, BA.ACCOUNT_HOLDER_NAME_ALT
, BA.CASHFLOW_DISPLAY_ORDER
, BA.ACCOUNT_HOLDER_NAME
, BA.MASKED_ACCOUNT_NUM
, BA.MASKED_IBAN
, BA.POOLED_FLAG
, BA.MIN_TARGET_BALANCE
, BA.MAX_TARGET_BALANCE
, BA.EFT_USER_NUM
, BA.INTEREST_SCHEDULE_ID
, BA.ASSET_CODE_COMBINATION_ID
, BA.NETTING_ACCT_FLAG
FROM CE_BANK_ACCOUNTS BA
, CE_BANK_ACCT_USES_ALL BAU
WHERE BA.BANK_ACCOUNT_ID = BAU.BANK_ACCOUNT_ID
AND BA.ACCOUNT_CLASSIFICATION = 'INTERNAL'
AND EXISTS (SELECT /*+ NO_UNNEST */ 1
FROM CE_SECURITY_PROFILES_V OU
WHERE ((BAU.ORG_ID = OU.ORGANIZATION_ID
AND OU.ORGANIZATION_TYPE IN ('OPERATING_UNIT'
, 'BUSINESS_GROUP')) OR (BAU.LEGAL_ENTITY_ID = OU.ORGANIZATION_ID
AND OU.ORGANIZATION_TYPE = 'LEGAL_ENTITY')))

Columns