VIEW: APPS.OKL_FE_RESI_CAT_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')