View: OKL_FE_STD_RT_TMP_VERS_V

Product:	OKL - Lease and Finance Management
Description:	Standard Rate Template version view
Implementation/DBA Data:	APPS.OKL_FE_STD_RT_TMP_VERS_V

View Text

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

Columns