View: OKC_STATUSES_V

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

View Text

SELECT STSB.ROWID ROW_ID
, STSB.CODE CODE
, STSB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, STST.SFWT_FLAG SFWT_FLAG
, STSB.STE_CODE STE_CODE
, STST.MEANING MEANING
, STST.DESCRIPTION DESCRIPTION
, STSB.DEFAULT_YN DEFAULT_YN
, STSB.START_DATE START_DATE
, STSB.END_DATE END_DATE
, STSB.CREATED_BY CREATED_BY
, STSB.CREATION_DATE CREATION_DATE
, STSB.LAST_UPDATED_BY LAST_UPDATED_BY
, STSB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, STSB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_STATUSES_B STSB
, OKC_STATUSES_TL STST
WHERE STSB.CODE = STST.CODE
AND STST.LANGUAGE = USERENV('LANG')

Columns