VIEW: APPS.CE_INTRA_STMT_HDRS_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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