DBA Data[Home] [Help]

VIEW: XTR.XTR_A_REVALUATION_RATES#

Source

View Text - Preformatted

select AUDIT_DATE_STORED AUDIT_DATE_STORED, AUDIT_INDICATOR AUDIT_INDICATOR, COMPANY_CODE COMPANY_CODE, CURRENCYA CURRENCYA, CURRENCYB CURRENCYB, DAY_MTH DAY_MTH, ENTERED_BY ENTERED_BY, ENTERED_ON ENTERED_ON, NUMBER_OF_DAYS NUMBER_OF_DAYS, PERIOD_FROM PERIOD_FROM, PERIOD_REF1 PERIOD_REF1, PERIOD_REF2 PERIOD_REF2, PERIOD_TO PERIOD_TO, RATE_DATE RATE_DATE, REVAL_PRODUCT_TYPE REVAL_PRODUCT_TYPE, REVAL_RATE REVAL_RATE, REVAL_SUBTYPE REVAL_SUBTYPE, REVAL_TYPE REVAL_TYPE, UNIQUE_REF_NUM UNIQUE_REF_NUM, UPDATED_BY UPDATED_BY, UPDATED_ON UPDATED_ON, VOLATILITY_OR_RATE VOLATILITY_OR_RATE, CREATED_BY CREATED_BY, CREATED_ON CREATED_ON, BATCH_ID BATCH_ID, BID BID, BID_OVERWRITE BID_OVERWRITE, ASK ASK, ASK_OVERWRITE ASK_OVERWRITE, DAY_COUNT_BASIS DAY_COUNT_BASIS from "XTR"."XTR_A_REVALUATION_RATES"
View Text - HTML Formatted

SELECT AUDIT_DATE_STORED AUDIT_DATE_STORED
, AUDIT_INDICATOR AUDIT_INDICATOR
, COMPANY_CODE COMPANY_CODE
, CURRENCYA CURRENCYA
, CURRENCYB CURRENCYB
, DAY_MTH DAY_MTH
, ENTERED_BY ENTERED_BY
, ENTERED_ON ENTERED_ON
, NUMBER_OF_DAYS NUMBER_OF_DAYS
, PERIOD_FROM PERIOD_FROM
, PERIOD_REF1 PERIOD_REF1
, PERIOD_REF2 PERIOD_REF2
, PERIOD_TO PERIOD_TO
, RATE_DATE RATE_DATE
, REVAL_PRODUCT_TYPE REVAL_PRODUCT_TYPE
, REVAL_RATE REVAL_RATE
, REVAL_SUBTYPE REVAL_SUBTYPE
, REVAL_TYPE REVAL_TYPE
, UNIQUE_REF_NUM UNIQUE_REF_NUM
, UPDATED_BY UPDATED_BY
, UPDATED_ON UPDATED_ON
, VOLATILITY_OR_RATE VOLATILITY_OR_RATE
, CREATED_BY CREATED_BY
, CREATED_ON CREATED_ON
, BATCH_ID BATCH_ID
, BID BID
, BID_OVERWRITE BID_OVERWRITE
, ASK ASK
, ASK_OVERWRITE ASK_OVERWRITE
, DAY_COUNT_BASIS DAY_COUNT_BASIS
FROM "XTR"."XTR_A_REVALUATION_RATES"