View: CEFV_BANK_STATEMENTS

Product:	CE - Cash Management
Description:	Business View
Implementation/DBA Data:	APPS.CEFV_BANK_STATEMENTS

View Text

SELECT SH.STATEMENT_HEADER_ID
, BA.BANK_ACCOUNT_NUM
, BA.BANK_ACCOUNT_NAME
, SH.STATEMENT_NUMBER
, SH.STATEMENT_DATE
, SH.CONTROL_BEGIN_BALANCE
, SH.CONTROL_TOTAL_DR
, SH.CONTROL_TOTAL_CR
, SH.CONTROL_END_BALANCE
, SH.CONTROL_DR_LINE_COUNT
, SH.CONTROL_CR_LINE_COUNT
, BA.CURRENCY_CODE
, SH.STATEMENT_COMPLETE_FLAG
, SH.DOC_SEQUENCE_VALUE
, OG.NAME
, BA.BANK_ACCOUNT_ID
, OG.ORGANIZATION_ID
, SH.CREATION_DATE
, SH.CREATED_BY
, SH.LAST_UPDATE_DATE
, SH.LAST_UPDATED_BY
, SH.CHECK_DIGITS
FROM CE_STATEMENT_HEADERS SH
, /*CE_BANK_ACCT_BALANCES BAL
, */ CE_BANK_ACCOUNTS BA
, HR_ALL_ORGANIZATION_UNITS OG
WHERE BA.BANK_ACCOUNT_ID = SH.BANK_ACCOUNT_ID /*AND SH.BANK_ACCOUNT_ID = BAL.BANK_ACCOUNT_ID(+)*/ /*AND SH.STATEMENT_DATE = BAL.BALANCE_DATE(+)*/
AND OG.ORGANIZATION_ID (+) = SH.ORG_ID
AND '_SEC:SH.ORG_ID' IS NOT NULL WITH READ ONLY

Columns