VIEW: XTR.XTR_A_REVALUATION_DETAILS#

Source

View Text - Preformatted

select ACTION_CODE ACTION_CODE, AUDIT_DATE_STORED AUDIT_DATE_STORED, AUDIT_INDICATOR AUDIT_INDICATOR, COMPANY_CODE COMPANY_CODE, CONTRACT_CODE CONTRACT_CODE, CROSS_REF_TO_POSTING CROSS_REF_TO_POSTING, CURRENCYA CURRENCYA, CURRENCYB CURRENCYB, CURRENCY_INDICATOR CURRENCY_INDICATOR, DEAL_NO DEAL_NO, DEAL_SUBTYPE DEAL_SUBTYPE, DEAL_TYPE DEAL_TYPE, EFFECTIVE_DATE EFFECTIVE_DATE, EFFECTIVE_DAYS EFFECTIVE_DAYS, ENTERED_BY ENTERED_BY, ENTERED_ON ENTERED_ON, FACE_VALUE FACE_VALUE, FXO_SELL_REF_AMOUNT FXO_SELL_REF_AMOUNT, FX_REVAL_PRINCIPAL_BAL FX_REVAL_PRINCIPAL_BAL, PERIOD_FROM PERIOD_FROM, PERIOD_TO PERIOD_TO, PORTFOLIO_CODE PORTFOLIO_CODE, PRODUCT_TYPE PRODUCT_TYPE, RATE_ERROR RATE_ERROR, REALISED_PL REALISED_PL, REVAL_CCY REVAL_CCY, REVAL_HCE_AMOUNT REVAL_HCE_AMOUNT, REVAL_RATE REVAL_RATE, REVAL_VALUE REVAL_VALUE, TRANSACTION_NO TRANSACTION_NO, TRANSACTION_PERIOD TRANSACTION_PERIOD, TRANSACTION_RATE TRANSACTION_RATE, UNIQUE_REF_NUM UNIQUE_REF_NUM, UNREALISED_PL UNREALISED_PL, UPDATED_BY UPDATED_BY, UPDATED_ON UPDATED_ON, YEAR_BASIS YEAR_BASIS, CREATED_BY CREATED_BY, CREATED_ON CREATED_ON, AUTHORIZE_JOURNAL_CREATION AUTHORIZE_JOURNAL_CREATION, JOURNAL_CREATED JOURNAL_CREATED, BATCH_ID BATCH_ID, REVALUATION_DETAILS_ID REVALUATION_DETAILS_ID, SWAP_REF SWAP_REF, COMPLETE_FLAG COMPLETE_FLAG, OVERWRITE_TYPE OVERWRITE_TYPE, OVERWRITE_VALUE OVERWRITE_VALUE, OVERWRITE_REASON OVERWRITE_REASON, FAIR_VALUE FAIR_VALUE, REALIZED_FLAG REALIZED_FLAG, ACCOUNT_NO ACCOUNT_NO, CUMM_GAIN_LOSS_AMOUNT CUMM_GAIN_LOSS_AMOUNT, CURR_GAIN_LOSS_AMOUNT CURR_GAIN_LOSS_AMOUNT, SOB_FV_GAIN_LOSS_AMOUNT SOB_FV_GAIN_LOSS_AMOUNT, SOB_FAIR_VALUE_AMOUNT SOB_FAIR_VALUE_AMOUNT, REVAL_CURR_FV_AMOUNT REVAL_CURR_FV_AMOUNT, CTR_CURR_SOB_CURR_FWD_RATE CTR_CURR_SOB_CURR_FWD_RATE, EXCHANGE_RATE_ONE EXCHANGE_RATE_ONE, EXCHANGE_RATE_TWO EXCHANGE_RATE_TWO, NI_DISC_AMOUNT NI_DISC_AMOUNT, AMOUNT_TYPE AMOUNT_TYPE from "XTR"."XTR_A_REVALUATION_DETAILS"

View Text - HTML Formatted

SELECT ACTION_CODE ACTION_CODE
, AUDIT_DATE_STORED AUDIT_DATE_STORED
, AUDIT_INDICATOR AUDIT_INDICATOR
, COMPANY_CODE COMPANY_CODE
, CONTRACT_CODE CONTRACT_CODE
, CROSS_REF_TO_POSTING CROSS_REF_TO_POSTING
, CURRENCYA CURRENCYA
, CURRENCYB CURRENCYB
, CURRENCY_INDICATOR CURRENCY_INDICATOR
, DEAL_NO DEAL_NO
, DEAL_SUBTYPE DEAL_SUBTYPE
, DEAL_TYPE DEAL_TYPE
, EFFECTIVE_DATE EFFECTIVE_DATE
, EFFECTIVE_DAYS EFFECTIVE_DAYS
, ENTERED_BY ENTERED_BY
, ENTERED_ON ENTERED_ON
, FACE_VALUE FACE_VALUE
, FXO_SELL_REF_AMOUNT FXO_SELL_REF_AMOUNT
, FX_REVAL_PRINCIPAL_BAL FX_REVAL_PRINCIPAL_BAL
, PERIOD_FROM PERIOD_FROM
, PERIOD_TO PERIOD_TO
, PORTFOLIO_CODE PORTFOLIO_CODE
, PRODUCT_TYPE PRODUCT_TYPE
, RATE_ERROR RATE_ERROR
, REALISED_PL REALISED_PL
, REVAL_CCY REVAL_CCY
, REVAL_HCE_AMOUNT REVAL_HCE_AMOUNT
, REVAL_RATE REVAL_RATE
, REVAL_VALUE REVAL_VALUE
, TRANSACTION_NO TRANSACTION_NO
, TRANSACTION_PERIOD TRANSACTION_PERIOD
, TRANSACTION_RATE TRANSACTION_RATE
, UNIQUE_REF_NUM UNIQUE_REF_NUM
, UNREALISED_PL UNREALISED_PL
, UPDATED_BY UPDATED_BY
, UPDATED_ON UPDATED_ON
, YEAR_BASIS YEAR_BASIS
, CREATED_BY CREATED_BY
, CREATED_ON CREATED_ON
, AUTHORIZE_JOURNAL_CREATION AUTHORIZE_JOURNAL_CREATION
, JOURNAL_CREATED JOURNAL_CREATED
, BATCH_ID BATCH_ID
, REVALUATION_DETAILS_ID REVALUATION_DETAILS_ID
, SWAP_REF SWAP_REF
, COMPLETE_FLAG COMPLETE_FLAG
, OVERWRITE_TYPE OVERWRITE_TYPE
, OVERWRITE_VALUE OVERWRITE_VALUE
, OVERWRITE_REASON OVERWRITE_REASON
, FAIR_VALUE FAIR_VALUE
, REALIZED_FLAG REALIZED_FLAG
, ACCOUNT_NO ACCOUNT_NO
, CUMM_GAIN_LOSS_AMOUNT CUMM_GAIN_LOSS_AMOUNT
, CURR_GAIN_LOSS_AMOUNT CURR_GAIN_LOSS_AMOUNT
, SOB_FV_GAIN_LOSS_AMOUNT SOB_FV_GAIN_LOSS_AMOUNT
, SOB_FAIR_VALUE_AMOUNT SOB_FAIR_VALUE_AMOUNT
, REVAL_CURR_FV_AMOUNT REVAL_CURR_FV_AMOUNT
, CTR_CURR_SOB_CURR_FWD_RATE CTR_CURR_SOB_CURR_FWD_RATE
, EXCHANGE_RATE_ONE EXCHANGE_RATE_ONE
, EXCHANGE_RATE_TWO EXCHANGE_RATE_TWO
, NI_DISC_AMOUNT NI_DISC_AMOUNT
, AMOUNT_TYPE AMOUNT_TYPE
FROM "XTR"."XTR_A_REVALUATION_DETAILS"