View: CE_STAT_HDRS_INF_V

Product:	CE - Cash Management
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CE_STAT_HDRS_INF_V

View Text

SELECT I.ROWID ROW_ID
, I.STATEMENT_NUMBER STATEMENT_NUMBER
, I.BANK_NAME BANK_NAME
, I.BANK_BRANCH_NAME BANK_BRANCH_NAME
, I.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, I.STATEMENT_DATE STATEMENT_DATE
, I.CONTROL_BEGIN_BALANCE CONTROL_BEGIN_BALANCE
, I.CONTROL_END_BALANCE CONTROL_END_BALANCE
, I.CONTROL_TOTAL_DR CONTROL_TOTAL_DR
, I.CONTROL_TOTAL_CR CONTROL_TOTAL_CR
, I.CONTROL_DR_LINE_COUNT CONTROL_DR_LINE_COUNT
, I.CONTROL_CR_LINE_COUNT CONTROL_CR_LINE_COUNT
, I.CONTROL_LINE_COUNT CONTROL_LINE_COUNT
, I.RECORD_STATUS_FLAG RECORD_STATUS_FLAG
, I.CURRENCY_CODE CURRENCY_CODE
, I.CREATED_BY CREATED_BY
, I.CREATION_DATE CREATION_DATE
, I.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, I.ATTRIBUTE1 ATTRIBUTE1
, I.ATTRIBUTE10 ATTRIBUTE10
, I.ATTRIBUTE11 ATTRIBUTE11
, I.ATTRIBUTE12 ATTRIBUTE12
, I.ATTRIBUTE13 ATTRIBUTE13
, I.ATTRIBUTE14 ATTRIBUTE14
, I.ATTRIBUTE15 ATTRIBUTE15
, I.ATTRIBUTE2 ATTRIBUTE2
, I.ATTRIBUTE3 ATTRIBUTE3
, I.ATTRIBUTE4 ATTRIBUTE4
, I.ATTRIBUTE5 ATTRIBUTE5
, I.ATTRIBUTE6 ATTRIBUTE6
, I.ATTRIBUTE7 ATTRIBUTE7
, I.ATTRIBUTE8 ATTRIBUTE8
, I.ATTRIBUTE9 ATTRIBUTE9
, I.LAST_UPDATED_BY LAST_UPDATED_BY
, I.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DECODE(I.RECORD_STATUS_FLAG
, NULL
, NULL
, L.MEANING) RECORD_STATUS_DSP
, I.CHECK_DIGITS
, I.CASHFLOW_BALANCE CASHFLOW_BALANCE
, I.INT_CALC_BALANCE INT_CALC_BALANCE
, NVL(I.INTRA_DAY_FLAG
, 'N') INTRA_DAY_FLAG
, ONE_DAY_FLOAT
, TWO_DAY_FLOAT
, I.AVERAGE_CLOSE_LEDGER_MTD AVERAGE_CLOSE_LEDGER_MTD
, I.AVERAGE_CLOSE_LEDGER_YTD AVERAGE_CLOSE_LEDGER_YTD
, I.AVERAGE_CLOSE_AVAILABLE_MTD AVERAGE_CLOSE_AVAILABLE_MTD
, I.AVERAGE_CLOSE_AVAILABLE_YTD AVERAGE_CLOSE_AVAILABLE_YTD
, I.SUBSIDIARY_FLAG SUBSIDIARY_FLAG
FROM CE_STATEMENT_HEADERS_INT I
, CE_LOOKUPS L
WHERE L.LOOKUP_TYPE = 'HEADER_INTERFACE_STATUS'
AND L.LOOKUP_CODE(+) = NVL(I.RECORD_STATUS_FLAG
, 'N')
AND I.BANK_ACCOUNT_NUM IN (SELECT BA.BANK_ACCOUNT_NUM
FROM CE_BANK_ACCOUNTS_V BA)

Columns