[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 |
APPS.ENG_CHANGE_STATUSES_VL