View: OKL_FE_ADJ_MAT_VERS_V

Product:	OKL - Lease and Finance Management
Description:	Pricing Adjustment Matrix Version view
Implementation/DBA Data:	APPS.OKL_FE_ADJ_MAT_VERS_V

View Text

SELECT VER.ADJ_MAT_VERSION_ID
, VER.OBJECT_VERSION_NUMBER
, VER.VERSION_NUMBER
, VER.ADJ_MAT_ID
, VER.STS_CODE
, VER.EFFECTIVE_FROM_DATE
, VER.EFFECTIVE_TO_DATE
, HDR.CURRENCY_CODE
, HDR.ADJ_MAT_TYPE_CODE
, HDR.ORIG_ADJ_MAT_ID
, HDR.STS_CODE HDR_STS_CODE
, HDR.EFFECTIVE_FROM_DATE HDR_EFFECTIVE_FROM_DATE
, HDR.EFFECTIVE_TO_DATE HDR_EFFECTIVE_TO_DATE
, HDR.ADJ_MAT_NAME
, HDR.ADJ_MAT_DESC
FROM OKL_FE_ADJ_MAT_VERSIONS VER
, OKL_FE_ADJ_MAT_V HDR
WHERE HDR.ADJ_MAT_ID= VER.ADJ_MAT_ID

Columns