View: XTR_A_REVALUATION_DETAILS_V

Product:	XTR - Treasury
Description:
Implementation/DBA Data:	APPS.XTR_A_REVALUATION_DETAILS_V

View Text

SELECT UNIQUE_REF_NUM
, COMPANY_CODE
, PERIOD_FROM
, PERIOD_TO
, DEAL_TYPE
, DEAL_SUBTYPE
, PRODUCT_TYPE
, CURRENCYA
, TRANSACTION_PERIOD
, FACE_VALUE
, ENTERED_ON
, ENTERED_BY
, DEAL_NO
, TRANSACTION_NO
, TRANSACTION_RATE
, EFFECTIVE_DATE
, EFFECTIVE_DAYS
, CURRENCY_INDICATOR
, CURRENCYB
, PORTFOLIO_CODE
, CONTRACT_CODE
, REVAL_RATE
, REVAL_VALUE
, REALISED_PL
, UNREALISED_PL
, RATE_ERROR
, FX_REVAL_PRINCIPAL_BAL
, FXO_SELL_REF_AMOUNT
, UPDATED_BY
, UPDATED_ON
, YEAR_BASIS
, REVAL_CCY
, CROSS_REF_TO_POSTING
, ACTION_CODE
, REVAL_HCE_AMOUNT
, AUDIT_INDICATOR
, AUDIT_DATE_STORED
, CREATED_BY
, CREATED_ON
, AUTHORIZE_JOURNAL_CREATION
, JOURNAL_CREATED
FROM XTR_A_REVALUATION_DETAILS

Columns