DBA Data[Home] [Help]

VIEW: APPS.XTR_TMP_FX_EXPOSURE_V

Source

View Text - Preformatted

SELECT UNIQUE_REF_NUMBER ,COMPANY ,CURRENCY ,CREATED_BY ,CREATED_ON ,BASE_CURRENCY ,SELECTED_BASE_CURRENCY ,SELECTED_CCY ,SELECTED_PORTFOLIO ,YIELD_CURVE ,PORTFOLIO ,INCL_FX_OPTIONS ,INCL_INDIC_EXPOSURES ,DISCOUNT_RATE ,FX_ORIGINAL_REVAL_RATE ,PERIOD_NAME ,PERIOD_DESC ,FX_PERCENT_MAX ,FX_PERCENT_MIN ,FX_AMOUNT ,EXP_AMOUNT ,NET_EXPOSURE ,COVER_TO_FORECAST ,MAX_AMOUNT ,MIN_AMOUNT ,PERIOD_FROM ,PERIOD_TO from XTR_TMP_FX_EXPOSURE
View Text - HTML Formatted

SELECT UNIQUE_REF_NUMBER
, COMPANY
, CURRENCY
, CREATED_BY
, CREATED_ON
, BASE_CURRENCY
, SELECTED_BASE_CURRENCY
, SELECTED_CCY
, SELECTED_PORTFOLIO
, YIELD_CURVE
, PORTFOLIO
, INCL_FX_OPTIONS
, INCL_INDIC_EXPOSURES
, DISCOUNT_RATE
, FX_ORIGINAL_REVAL_RATE
, PERIOD_NAME
, PERIOD_DESC
, FX_PERCENT_MAX
, FX_PERCENT_MIN
, FX_AMOUNT
, EXP_AMOUNT
, NET_EXPOSURE
, COVER_TO_FORECAST
, MAX_AMOUNT
, MIN_AMOUNT
, PERIOD_FROM
, PERIOD_TO
FROM XTR_TMP_FX_EXPOSURE