VIEW: APPS.XTR_INTRADAY_STATEMENTS_V

Source

View Text - Preformatted

SELECT a.STATEMENT_HEADER_ID, a.BANK_ACCOUNT_ID, a.STATEMENT_NUMBER, a.STATEMENT_DATE, a.HEADER_CREATED_BY, a.HEADER_CREATION_DATE, a.HEADER_LAST_UPDATED_BY, a.HEADER_LAST_UPDATE_DATE, a.AUTO_LOADED_FLAG, a.GL_DATE, a.CONTROL_BEGIN_BALANCE, a.CONTROL_TOTAL_DR, a.CONTROL_TOTAL_CR, a.CONTROL_END_BALANCE, a.CONTROL_DR_LINE_COUNT, a.CONTROL_CR_LINE_COUNT, a.HEADER_CURRENCY_CODE, a.HEADER_LAST_UPDATE_LOGIN, a.HEADER_ATTRIBUTE_CATEGORY, a.HEADER_ATTRIBUTE1, a.HEADER_ATTRIBUTE2, a.HEADER_ATTRIBUTE3, a.HEADER_ATTRIBUTE4, a.HEADER_ATTRIBUTE5, a.HEADER_ATTRIBUTE6, a.HEADER_ATTRIBUTE7, a.HEADER_ATTRIBUTE8, a.HEADER_ATTRIBUTE9, a.HEADER_ATTRIBUTE10, a.HEADER_ATTRIBUTE11, a.HEADER_ATTRIBUTE12, a.HEADER_ATTRIBUTE13, a.HEADER_ATTRIBUTE14, a.HEADER_ATTRIBUTE15, a.STATEMENT_COMPLETE_FLAG, a.DOC_SEQUENCE_ID, a.DOC_SEQUENCE_VALUE, a.CHECK_DIGITS, a.CASHFLOW_BALANCE, a.INT_CALC_BALANCE, a.STATEMENT_LINE_ID, a.LINE_NUMBER, a.TRX_DATE, a.TRX_TYPE, a.AMOUNT, a.SIGNED_AMOUNT, a.STATUS, a.LINE_CREATED_BY, a.LINE_CREATION_DATE, a.LINE_LAST_UPDATED_BY, a.LINE_LAST_UPDATE_DATE, a.TRX_CODE_ID, a.EFFECTIVE_DATE, a.BANK_TRX_NUMBER, a.TRX_TEXT, a.CUSTOMER_TEXT, a.INVOICE_TEXT, a.BANK_ACCOUNT_TEXT, a.LINE_CURRENCY_CODE, a.EXCHANGE_RATE_TYPE, a.EXCHANGE_RATE, a.EXCHANGE_RATE_DATE, a.ORIGINAL_AMOUNT, a.CHARGES_AMOUNT, a.LINE_LAST_UPDATE_LOGIN, a.RECONCILE_TO_STATEMENT_FLAG, a.LINE_ATTRIBUTE_CATEGORY, a.LINE_ATTRIBUTE1, a.LINE_ATTRIBUTE2, a.LINE_ATTRIBUTE3, a.LINE_ATTRIBUTE4, a.LINE_ATTRIBUTE5, a.LINE_ATTRIBUTE6, a.LINE_ATTRIBUTE7, a.LINE_ATTRIBUTE8, a.LINE_ATTRIBUTE9, a.LINE_ATTRIBUTE10, a.LINE_ATTRIBUTE11, a.LINE_ATTRIBUTE12, a.LINE_ATTRIBUTE13, a.LINE_ATTRIBUTE14, a.LINE_ATTRIBUTE15, a.BANK_ACCOUNT_NUM, a.BANK_ACCOUNT_NAME, a.BANK_ACCOUNT_CURRENCY_CODE, a.BANK_NAME, a.BANK_BRANCH_NAME, a.BANK_BRANCH_ID, a.TRX_TYPE_DSP, a.TRX_CODE, a.TRX_CODE_DESC, a.STATEMENT_TYPE, b.ACCOUNT_NUMBER, b.PARTY_CODE, NVL(a.EFFECTIVE_DATE, a.TRX_DATE) AS TRANSACTION_DATE From CE_INTRA_STMT_HDRS_LINES_V a, Xtr_Bank_Accounts b WHERE a.BANK_ACCOUNT_ID = b.CE_BANK_ACCOUNT_ID And b.Party_Type = 'C' And b.Party_Code in (Select c.PARTY_CODE From XTR_COMPANY_AUTHORITIES c, XTR_DEALER_CODES d Where b.PARTY_CODE = c.PARTY_CODE And c.DEALER_CODE = d.DEALER_CODE And c.COMPANY_AUTHORISED_FOR_INPUT = 'Y' And d.USER_ID = fnd_global.user_id )

View Text - HTML Formatted

SELECT A.STATEMENT_HEADER_ID
, A.BANK_ACCOUNT_ID
, A.STATEMENT_NUMBER
, A.STATEMENT_DATE
, A.HEADER_CREATED_BY
, A.HEADER_CREATION_DATE
, A.HEADER_LAST_UPDATED_BY
, A.HEADER_LAST_UPDATE_DATE
, A.AUTO_LOADED_FLAG
, A.GL_DATE
, A.CONTROL_BEGIN_BALANCE
, A.CONTROL_TOTAL_DR
, A.CONTROL_TOTAL_CR
, A.CONTROL_END_BALANCE
, A.CONTROL_DR_LINE_COUNT
, A.CONTROL_CR_LINE_COUNT
, A.HEADER_CURRENCY_CODE
, A.HEADER_LAST_UPDATE_LOGIN
, A.HEADER_ATTRIBUTE_CATEGORY
, A.HEADER_ATTRIBUTE1
, A.HEADER_ATTRIBUTE2
, A.HEADER_ATTRIBUTE3
, A.HEADER_ATTRIBUTE4
, A.HEADER_ATTRIBUTE5
, A.HEADER_ATTRIBUTE6
, A.HEADER_ATTRIBUTE7
, A.HEADER_ATTRIBUTE8
, A.HEADER_ATTRIBUTE9
, A.HEADER_ATTRIBUTE10
, A.HEADER_ATTRIBUTE11
, A.HEADER_ATTRIBUTE12
, A.HEADER_ATTRIBUTE13
, A.HEADER_ATTRIBUTE14
, A.HEADER_ATTRIBUTE15
, A.STATEMENT_COMPLETE_FLAG
, A.DOC_SEQUENCE_ID
, A.DOC_SEQUENCE_VALUE
, A.CHECK_DIGITS
, A.CASHFLOW_BALANCE
, A.INT_CALC_BALANCE
, A.STATEMENT_LINE_ID
, A.LINE_NUMBER
, A.TRX_DATE
, A.TRX_TYPE
, A.AMOUNT
, A.SIGNED_AMOUNT
, A.STATUS
, A.LINE_CREATED_BY
, A.LINE_CREATION_DATE
, A.LINE_LAST_UPDATED_BY
, A.LINE_LAST_UPDATE_DATE
, A.TRX_CODE_ID
, A.EFFECTIVE_DATE
, A.BANK_TRX_NUMBER
, A.TRX_TEXT
, A.CUSTOMER_TEXT
, A.INVOICE_TEXT
, A.BANK_ACCOUNT_TEXT
, A.LINE_CURRENCY_CODE
, A.EXCHANGE_RATE_TYPE
, A.EXCHANGE_RATE
, A.EXCHANGE_RATE_DATE
, A.ORIGINAL_AMOUNT
, A.CHARGES_AMOUNT
, A.LINE_LAST_UPDATE_LOGIN
, A.RECONCILE_TO_STATEMENT_FLAG
, A.LINE_ATTRIBUTE_CATEGORY
, A.LINE_ATTRIBUTE1
, A.LINE_ATTRIBUTE2
, A.LINE_ATTRIBUTE3
, A.LINE_ATTRIBUTE4
, A.LINE_ATTRIBUTE5
, A.LINE_ATTRIBUTE6
, A.LINE_ATTRIBUTE7
, A.LINE_ATTRIBUTE8
, A.LINE_ATTRIBUTE9
, A.LINE_ATTRIBUTE10
, A.LINE_ATTRIBUTE11
, A.LINE_ATTRIBUTE12
, A.LINE_ATTRIBUTE13
, A.LINE_ATTRIBUTE14
, A.LINE_ATTRIBUTE15
, A.BANK_ACCOUNT_NUM
, A.BANK_ACCOUNT_NAME
, A.BANK_ACCOUNT_CURRENCY_CODE
, A.BANK_NAME
, A.BANK_BRANCH_NAME
, A.BANK_BRANCH_ID
, A.TRX_TYPE_DSP
, A.TRX_CODE
, A.TRX_CODE_DESC
, A.STATEMENT_TYPE
, B.ACCOUNT_NUMBER
, B.PARTY_CODE
, NVL(A.EFFECTIVE_DATE
, A.TRX_DATE) AS TRANSACTION_DATE
FROM CE_INTRA_STMT_HDRS_LINES_V A
, XTR_BANK_ACCOUNTS B
WHERE A.BANK_ACCOUNT_ID = B.CE_BANK_ACCOUNT_ID
AND B.PARTY_TYPE = 'C'
AND B.PARTY_CODE IN (SELECT C.PARTY_CODE
FROM XTR_COMPANY_AUTHORITIES C
, XTR_DEALER_CODES D
WHERE B.PARTY_CODE = C.PARTY_CODE
AND C.DEALER_CODE = D.DEALER_CODE
AND C.COMPANY_AUTHORISED_FOR_INPUT = 'Y'
AND D.USER_ID = FND_GLOBAL.USER_ID )