View: CE_STATEMENT_HEADERS_V

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

View Text

SELECT SH.ROWID ROW_ID
, BA.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, BA.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, BA.BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, BA.CURRENCY_CODE CURRENCY_CODE
, NULL TRX_CURRENCY_TYPE
, BA.MULTI_CURRENCY_ALLOWED_FLAG MULTI_CURRENCY_FLAG
, BA.ASSET_CODE_COMBINATION_ID ASSET_CODE_COMBINATION_ID
, BB.BANK_NAME BANK_NAME
, BB.BANK_BRANCH_NAME BANK_BRANCH_NAME
, SH.STATEMENT_HEADER_ID STATEMENT_HEADER_ID
, SH.STATEMENT_NUMBER STATEMENT_NUMBER
, SH.STATEMENT_DATE STATEMENT_DATE
, SH.CONTROL_BEGIN_BALANCE CONTROL_BEGIN_BALANCE
, SH.CONTROL_END_BALANCE CONTROL_END_BALANCE
, SH.CONTROL_TOTAL_DR CONTROL_TOTAL_DR
, SH.CONTROL_TOTAL_CR CONTROL_TOTAL_CR
, SH.CONTROL_DR_LINE_COUNT CONTROL_DR_LINE_COUNT
, SH.CONTROL_CR_LINE_COUNT CONTROL_CR_LINE_COUNT
, SH.CREATED_BY CREATED_BY
, SH.CREATION_DATE CREATION_DATE
, SH.LAST_UPDATED_BY LAST_UPDATED_BY
, SH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SH.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, SH.ATTRIBUTE1 ATTRIBUTE1
, SH.ATTRIBUTE2 ATTRIBUTE2
, SH.ATTRIBUTE3 ATTRIBUTE3
, SH.ATTRIBUTE4 ATTRIBUTE4
, SH.ATTRIBUTE5 ATTRIBUTE5
, SH.ATTRIBUTE6 ATTRIBUTE6
, SH.ATTRIBUTE7 ATTRIBUTE7
, SH.ATTRIBUTE8 ATTRIBUTE8
, SH.ATTRIBUTE9 ATTRIBUTE9
, SH.ATTRIBUTE10 ATTRIBUTE10
, SH.ATTRIBUTE11 ATTRIBUTE11
, SH.ATTRIBUTE12 ATTRIBUTE12
, SH.ATTRIBUTE13 ATTRIBUTE13
, SH.ATTRIBUTE14 ATTRIBUTE14
, SH.ATTRIBUTE15 ATTRIBUTE15
, SH.AUTO_LOADED_FLAG AUTO_LOADED_FLAG
, SH.STATEMENT_COMPLETE_FLAG STATEMENT_COMPLETE_FLAG
, SH.GL_DATE GL_DATE
, SH.DOC_SEQUENCE_ID DOC_SEQUENCE_ID
, SH.DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
, BA.BANK_BRANCH_ID BANK_BRANCH_ID
, SH.CHECK_DIGITS
, SH.CASHFLOW_BALANCE CASHFLOW_BALANCE
, SH.INT_CALC_BALANCE INT_CALC_BALANCE
, SH.ONE_DAY_FLOAT ONE_DAY_FLOAT
, SH.TWO_DAY_FLOAT TWO_DAY_FLOAT
, SH.GLOBAL_ATTRIBUTE_CATEGORY
, SH.GLOBAL_ATTRIBUTE1
, SH.GLOBAL_ATTRIBUTE2
, SH.GLOBAL_ATTRIBUTE3
, SH.GLOBAL_ATTRIBUTE4
, SH.GLOBAL_ATTRIBUTE5
, SH.GLOBAL_ATTRIBUTE6
, SH.GLOBAL_ATTRIBUTE7
, SH.GLOBAL_ATTRIBUTE8
, SH.GLOBAL_ATTRIBUTE9
, SH.GLOBAL_ATTRIBUTE10
, SH.GLOBAL_ATTRIBUTE11
, SH.GLOBAL_ATTRIBUTE12
, SH.GLOBAL_ATTRIBUTE13
, SH.GLOBAL_ATTRIBUTE14
, SH.GLOBAL_ATTRIBUTE15
, SH.GLOBAL_ATTRIBUTE16
, SH.GLOBAL_ATTRIBUTE17
, SH.GLOBAL_ATTRIBUTE18
, SH.GLOBAL_ATTRIBUTE19
, SH.GLOBAL_ATTRIBUTE20
FROM CE_BANK_BRANCHES_V BB
, CE_BANK_ACCTS_GT_V BA
, CE_STATEMENT_HEADERS SH
WHERE BA.BANK_ACCOUNT_ID = SH.BANK_ACCOUNT_ID
AND BA.BANK_BRANCH_ID = BB.BRANCH_PARTY_ID

Columns