View: CE_BANK_ACCT_USES_LE_V

Product:	CE - Cash Management
Description:	This view stores bank account uses information for legal entities.
Implementation/DBA Data:	APPS.CE_BANK_ACCT_USES_LE_V

View Text

SELECT BAU.BANK_ACCT_USE_ID
, BAU.BANK_ACCOUNT_ID
, BAU.LAST_UPDATE_DATE
, BAU.LAST_UPDATED_BY
, BAU.CREATION_DATE
, BAU.CREATED_BY
, BAU.LAST_UPDATE_LOGIN
, BAU.PRIMARY_FLAG
, BAU.ATTRIBUTE_CATEGORY
, BAU.ATTRIBUTE1
, BAU.ATTRIBUTE2
, BAU.ATTRIBUTE3
, BAU.ATTRIBUTE4
, BAU.ATTRIBUTE5
, BAU.ATTRIBUTE6
, BAU.ATTRIBUTE7
, BAU.ATTRIBUTE8
, BAU.ATTRIBUTE9
, BAU.ATTRIBUTE10
, BAU.ATTRIBUTE11
, BAU.ATTRIBUTE12
, BAU.ATTRIBUTE13
, BAU.ATTRIBUTE14
, BAU.ATTRIBUTE15
, BAU.REQUEST_ID
, BAU.PROGRAM_APPLICATION_ID
, BAU.PROGRAM_ID
, BAU.PROGRAM_UPDATE_DATE
, BAU.ORG_ID
, BAU.ORG_PARTY_ID
, BAU.AP_USE_ENABLE_FLAG
, BAU.AR_USE_ENABLE_FLAG
, BAU.XTR_USE_ENABLE_FLAG
, BAU.PAY_USE_ENABLE_FLAG
, BAU.EDISC_RECEIVABLES_TRX_ID
, BAU.UNEDISC_RECEIVABLES_TRX_ID
, BAU.POOLED_FLAG
, BAU.END_DATE
, BAU.BR_STD_RECEIVABLES_TRX_ID
, BAU.INVESTMENT_LIMIT_CODE
, BAU.FUNDING_LIMIT_CODE
, BAU.LEGAL_ENTITY_ID
, BAU.AP_DEFAULT_SETTLEMENT_FLAG
, BAU.XTR_DEFAULT_SETTLEMENT_FLAG
, BAU.PAYROLL_BANK_ACCOUNT_ID
FROM CE_BANK_ACCT_USES_ALL BAU
, CE_SECURITY_PROFILES_V LE
WHERE BAU.XTR_USE_ENABLE_FLAG = 'Y'
AND BAU.LEGAL_ENTITY_ID IS NOT NULL
AND SYSDATE <= NVL(BAU.END_DATE
, SYSDATE)
AND BAU.LEGAL_ENTITY_ID = LE.ORGANIZATION_ID
AND LE.ORGANIZATION_TYPE = 'LEGAL_ENTITY'
AND EXISTS (SELECT 'X'
FROM CE_BANK_ACCOUNTS BA
WHERE BA.BANK_ACCOUNT_ID = BAU.BANK_ACCOUNT_ID
AND SYSDATE >= NVL(BA.START_DATE
, SYSDATE)
AND SYSDATE <= NVL(BA.END_DATE
, SYSDATE) )

Columns