Product: | XTR - Treasury |
---|---|
Description: | view joins the cash management view CE_INTRA_STMT_HDRS_LINES_V with treasury table XTR_BANK_ACCOUNTS and thus provides CE, XTR details |
Implementation/DBA Data: | APPS.XTR_INTRADAY_STATEMENTS_V |
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 )