VIEW: APPS.OKL_FE_STD_RT_TMP_VERS_V

Source

View Text - Preformatted

SELECT VER.STD_RATE_TMPL_VER_ID, VER.OBJECT_VERSION_NUMBER, VER.VERSION_NUMBER, VER.STD_RATE_TMPL_ID, VER.EFFECTIVE_FROM_DATE, VER.EFFECTIVE_TO_DATE, VER.STS_CODE, VER.ADJ_MAT_VERSION_ID, VER.SRT_RATE, VER.SPREAD, VER.DAY_CONVENTION_CODE, VER.MIN_ADJ_RATE, VER.MAX_ADJ_RATE, HDR.CURRENCY_CODE, HDR.RATE_CARD_YN, HDR.PRICING_ENGINE_CODE, HDR.ORIG_STD_RATE_TMPL_ID, HDR.RATE_TYPE_CODE, HDR.FREQUENCY_CODE, HDR.INDEX_ID, HDR.STS_CODE HDR_STS_CODE, HDR.EFFECTIVE_FROM_DATE HDR_EFFECTIVE_FROM_DATE, HDR.EFFECTIVE_TO_DATE HDR_EFFECTIVE_TO_DATE, HDR.SRT_RATE HDR_SRT_RATE, HDR.TEMPLATE_NAME, HDR.TEMPLATE_DESC FROM OKL_FE_STD_RT_TMP_VERS VER,OKL_FE_STD_RT_TMP_V HDR WHERE HDR.STD_RATE_TMPL_ID= VER.STD_RATE_TMPL_ID

View Text - HTML Formatted

SELECT VER.STD_RATE_TMPL_VER_ID
, VER.OBJECT_VERSION_NUMBER
, VER.VERSION_NUMBER
, VER.STD_RATE_TMPL_ID
, VER.EFFECTIVE_FROM_DATE
, VER.EFFECTIVE_TO_DATE
, VER.STS_CODE
, VER.ADJ_MAT_VERSION_ID
, VER.SRT_RATE
, VER.SPREAD
, VER.DAY_CONVENTION_CODE
, VER.MIN_ADJ_RATE
, VER.MAX_ADJ_RATE
, HDR.CURRENCY_CODE
, HDR.RATE_CARD_YN
, HDR.PRICING_ENGINE_CODE
, HDR.ORIG_STD_RATE_TMPL_ID
, HDR.RATE_TYPE_CODE
, HDR.FREQUENCY_CODE
, HDR.INDEX_ID
, HDR.STS_CODE HDR_STS_CODE
, HDR.EFFECTIVE_FROM_DATE HDR_EFFECTIVE_FROM_DATE
, HDR.EFFECTIVE_TO_DATE HDR_EFFECTIVE_TO_DATE
, HDR.SRT_RATE HDR_SRT_RATE
, HDR.TEMPLATE_NAME
, HDR.TEMPLATE_DESC
FROM OKL_FE_STD_RT_TMP_VERS VER
, OKL_FE_STD_RT_TMP_V HDR
WHERE HDR.STD_RATE_TMPL_ID= VER.STD_RATE_TMPL_ID