View: CEBV_BANK_STATEMENTS

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

View Text

SELECT SH.STATEMENT_HEADER_ID
, 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
, SH.CURRENCY_CODE
, SH.STATEMENT_COMPLETE_FLAG
, SH.DOC_SEQUENCE_VALUE
, SH.BANK_ACCOUNT_ID
, SH.ORG_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
WHERE -- SH.BANK_ACCOUNT_ID = BAL.BANK_ACCOUNT_ID(+)
AND -- SH.STATEMENT_DATE = BAL.BALANCE_DATE(+)
AND '_SEC:SH.ORG_ID' IS NOT NULL WITH READ ONLY

Columns