[Home] [Help]
View: ENG_CHANGE_STATUSES_VL
View Text
SELECT ECS.ROWID ROW_ID
, ECS.STATUS_CODE
, ECS.SORT_SEQUENCE_NUM
, ECS.DISABLE_DATE
, ECS.SEEDED_FLAG
, ECS.LAST_UPDATE_DATE
, ECS.LAST_UPDATED_BY
, ECS.LAST_UPDATE_LOGIN
, ECS.CREATED_BY
, ECS.CREATION_DATE
, ECSTL.STATUS_NAME
, ECSTL.DESCRIPTION
, ECS.STATUS_TYPE
, ECS.OBJECT_NAME
FROM ENG_CHANGE_STATUSES ECS
, ENG_CHANGE_STATUSES_TL ECSTL
WHERE ECS.STATUS_CODE = ECSTL.STATUS_CODE
AND ECSTL.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
STATUS_CODE |
SORT_SEQUENCE_NUM |
DISABLE_DATE |
SEEDED_FLAG |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |
STATUS_NAME |
DESCRIPTION |
STATUS_TYPE |
OBJECT_NAME |