View: OKL_FE_RESI_CAT_V

Product:	OKL - Leasing and Finance Management
Description:	Residual Category Set MLS support View
Implementation/DBA Data:	APPS.OKL_FE_RESI_CAT_V

View Text

SELECT RCS_B.RESI_CATEGORY_SET_ID RESI_CATEGORY_SET_ID
, RCS_B.ORIG_RESI_CAT_SET_ID ORIG_RESI_CAT_SET_ID
, RCS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RCS_B.ORG_ID ORG_ID
, RCS_B.SOURCE_CODE SOURCE_CODE
, RCS_B.STS_CODE STS_CODE
, RCS_B.RESI_CAT_NAME RESI_CAT_NAME
, RCS_TL.RESI_CAT_DESC RESI_CAT_DESC
, RCS_TL.SFWT_FLAG SFWT_FLAG
, RCS_B.CREATED_BY CREATED_BY
, RCS_B.CREATION_DATE CREATION_DATE
, RCS_B.LAST_UPDATED_BY LAST_UPDATED_BY
, RCS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RCS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_FE_RESI_CAT_ALL_TL RCS_TL
, OKL_FE_RESI_CAT_B RCS_B
WHERE RCS_B.RESI_CATEGORY_SET_ID = RCS_TL.RESI_CATEGORY_SET_ID
AND RCS_TL.LANGUAGE = USERENV('LANG')

Columns