VIEW: APPS.XTR_SETTLEMENTS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'