View: XTR_SETTLEMENTS_V

Product:	XTR - Treasury
Description:	Settlement transactions of Treasury deals
Implementation/DBA Data:	APPS.XTR_SETTLEMENTS_V

View Text

SELECT A.DEAL_NUMBER
, A.TRANSACTION_NUMBER
, NVL(A.ACTUAL_SETTLEMENT_DATE
, A.AMOUNT_DATE) AMOUNT_DATE
, A.ACTUAL_SETTLEMENT_DATE - A.AMOUNT_DATE DAY_VARIANCE
, A.GOOD_VALUE_CLAIM
, A.CURRENCY
, A.AMOUNT_TYPE TYPE_OF_AMOUNT
, A.AMOUNT
, A.CASHFLOW_AMOUNT
, A.COMPANY_CODE COMPANY
, A.CPARTY_CODE CPARTY
, A.CLIENT_CODE CLIENT
, A.DEALER_CODE DEALER
, A.DEAL_TYPE CONTRACT_TYPE
, A.DEAL_SUBTYPE SUBTYPE
, A.PRODUCT_TYPE PRODUCT
, A.PORTFOLIO_CODE PORTFOLIO
, A.CODE_COMBINATION_ID
, A.TRANSACTION_RATE RATE
, A.ACCOUNT_NO COMPANY_ACCOUNT
, A.HCE_AMOUNT
, A.STATUS_CODE CONTRACT_STATUS
, A.DIARY_NOTE DIARY_NOTE_DETAILS
, A.DUAL_AUTHORISATION_BY AUTHORISED_BY
, A.DUAL_AUTHORISATION_ON AUTHORISED_ON
, A.SETTLE
, A.CPARTY_ACCOUNT_NO CPARTY_ACCOUNT
, A.DIRECT_DEBIT
, A.CHQ_REQD
, A.COMMENTS
, A.ACTION_CODE
, A.ATTACHMENT_EXISTS
, A.CURRENCY_COMBINATION
, A.BENEFICIARY_PARTY
, A.BENEFICIARY_ACCOUNT_NO BENEFICIARY_ACCOUNT
, A.SETTLEMENT_NUMBER
, A.LIMIT_PARTY
FROM XTR_DEAL_DATE_AMOUNTS_V A
WHERE A.CASHFLOW_AMOUNT <> 0
AND A.AMOUNT_TYPE NOT IN('FXOBUY'
, 'FXOSELL')
AND NVL(A.EXP_SETTLE_REQD
, 'Y') = 'Y'
AND NVL(A.MULTIPLE_SETTLEMENTS
, 'N') = 'N'
AND A.STATUS_CODE <> 'CANCELLED'
AND A.DEAL_SUBTYPE <> 'INDIC'

Columns