View: OKC_SUBCLASSES_V

Product:	OKC - Contracts Core
Description:	View for table OKC_SUB_CLASSES_B
Implementation/DBA Data:	APPS.OKC_SUBCLASSES_V

View Text

SELECT SCSB.ROWID ROW_ID
, SCSB.CODE CODE
, SCSB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SCST.SFWT_FLAG SFWT_FLAG
, SCSB.CLS_CODE CLS_CODE
, SCST.MEANING MEANING
, SCST.DESCRIPTION DESCRIPTION
, SCSB.START_DATE START_DATE
, SCSB.END_DATE END_DATE
, SCSB.CREATED_BY CREATED_BY
, SCSB.CREATION_DATE CREATION_DATE
, SCSB.LAST_UPDATED_BY LAST_UPDATED_BY
, SCSB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SCSB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SCSB.CREATE_OPP_YN CREATE_OPP_YN
, SCSB.ACCESS_LEVEL ACCESS_LEVEL
FROM OKC_SUBCLASSES_B SCSB
, OKC_SUBCLASSES_TL SCST
WHERE SCSB.CODE = SCST.CODE
AND SCST.LANGUAGE = USERENV('LANG')

Columns