VIEW: APPS.ENG_CHANGE_STATUSES_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')