[Home] [Help]
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
Name |
ROW_ID |
CODE |
OBJECT_VERSION_NUMBER |
SFWT_FLAG |
STE_CODE |
MEANING |
DESCRIPTION |
DEFAULT_YN |
START_DATE |
END_DATE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |