View: CE_INTRA_STMT_HDRS_LINES_V

Product:	CE - Cash Management
Description:	The CE_INTRA_STMT_HDRS_LINES_V view contains intra-day bank statement headers and lines information. This view is used in cash positioning.
Implementation/DBA Data:	APPS.CE_INTRA_STMT_HDRS_LINES_V

View Text

SELECT ISH.STATEMENT_HEADER_ID
, ISH.BANK_ACCOUNT_ID
, ISH.STATEMENT_NUMBER
, ISH.STATEMENT_DATE
, ISH.CREATED_BY
, ISH.CREATION_DATE
, ISH.LAST_UPDATED_BY
, ISH.LAST_UPDATE_DATE
, ISH.AUTO_LOADED_FLAG
, ISH.GL_DATE
, ISH.CONTROL_BEGIN_BALANCE
, ISH.CONTROL_TOTAL_DR
, ISH.CONTROL_TOTAL_CR
, ISH.CONTROL_END_BALANCE
, ISH.CONTROL_DR_LINE_COUNT
, ISH.CONTROL_CR_LINE_COUNT
, ISH.CURRENCY_CODE
, ISH.LAST_UPDATE_LOGIN
, ISH.ATTRIBUTE_CATEGORY
, ISH.ATTRIBUTE1
, ISH.ATTRIBUTE2
, ISH.ATTRIBUTE3
, ISH.ATTRIBUTE4
, ISH.ATTRIBUTE5
, ISH.ATTRIBUTE6
, ISH.ATTRIBUTE7
, ISH.ATTRIBUTE8
, ISH.ATTRIBUTE9
, ISH.ATTRIBUTE10
, ISH.ATTRIBUTE11
, ISH.ATTRIBUTE12
, ISH.ATTRIBUTE13
, ISH.ATTRIBUTE14
, ISH.ATTRIBUTE15
, ISH.STATEMENT_COMPLETE_FLAG
, ISH.DOC_SEQUENCE_ID
, ISH.DOC_SEQUENCE_VALUE
, ISH.CHECK_DIGITS
, ISH.CASHFLOW_BALANCE
, ISH.INT_CALC_BALANCE
, ISL.STATEMENT_LINE_ID
, ISL.LINE_NUMBER
, ISL.TRX_DATE
, ISL.TRX_TYPE
, ISL.AMOUNT
, DECODE(ISL.TRX_TYPE
, 'CREDIT'
, ISL.AMOUNT
, 'DEBIT'
, -ISL.AMOUNT
, 'MISC_CREDIT'
, ISL.AMOUNT
, 'MISC_DEBIT'
, -ISL.AMOUNT
, 'NSF'
, -ISL.AMOUNT
, 'REJECTED'
, -ISL.AMOUNT
, 'STOP'
, ISL.AMOUNT
, ISL.AMOUNT)
, ISL.STATUS
, ISL.CREATED_BY
, ISL.CREATION_DATE
, ISL.LAST_UPDATED_BY
, ISL.LAST_UPDATE_DATE
, ISL.TRX_CODE_ID
, ISL.EFFECTIVE_DATE
, ISL.BANK_TRX_NUMBER
, ISL.TRX_TEXT
, ISL.CUSTOMER_TEXT
, ISL.INVOICE_TEXT
, ISL.BANK_ACCOUNT_TEXT
, ISL.CURRENCY_CODE
, ISL.EXCHANGE_RATE_TYPE
, ISL.EXCHANGE_RATE
, ISL.EXCHANGE_RATE_DATE
, ISL.ORIGINAL_AMOUNT
, ISL.CHARGES_AMOUNT
, ISL.LAST_UPDATE_LOGIN
, ISL.RECONCILE_TO_STATEMENT_FLAG
, ISL.ATTRIBUTE_CATEGORY
, ISL.ATTRIBUTE1
, ISL.ATTRIBUTE2
, ISL.ATTRIBUTE3
, ISL.ATTRIBUTE4
, ISL.ATTRIBUTE5
, ISL.ATTRIBUTE6
, ISL.ATTRIBUTE7
, ISL.ATTRIBUTE8
, ISL.ATTRIBUTE9
, ISL.ATTRIBUTE10
, ISL.ATTRIBUTE11
, ISL.ATTRIBUTE12
, ISL.ATTRIBUTE13
, ISL.ATTRIBUTE14
, ISL.ATTRIBUTE15
, ABA.BANK_ACCOUNT_NUM
, ABA.BANK_ACCOUNT_NAME
, ABA.CURRENCY_CODE
, ABB.BANK_NAME
, ABB.BANK_BRANCH_NAME
, ABB.BRANCH_PARTY_ID
, CEL.MEANING
, CTC.TRX_CODE
, CTC.DESCRIPTION
, 'INTRA-DAY'
FROM CE_INTRA_STMT_HEADERS ISH
, CE_INTRA_STMT_LINES ISL
, CE_BANK_ACCOUNTS ABA
, CE_BANK_BRANCHES_V ABB
, CE_LOOKUPS CEL
, CE_TRANSACTION_CODES CTC
WHERE ISH.STATEMENT_HEADER_ID = ISL.STATEMENT_HEADER_ID AND ISH.BANK_ACCOUNT_ID = ABA.BANK_ACCOUNT_ID AND ABA.BANK_BRANCH_ID = ABB.BRANCH_PARTY_ID AND CEL.LOOKUP_TYPE = 'BANK_TRX_TYPE' AND CEL.LOOKUP_CODE = ISL.TRX_TYPE AND CTC.TRANSACTION_CODE_ID(+) = ISL.TRX_CODE_ID

Columns