[Home] [Help]
View: ENG_CHANGE_LOGS_VL
View Text
SELECT B.ROWID ROW_ID
, B.CHANGE_LOG_ID
, B.CHANGE_ID
, B.CHANGE_LINE_ID
, B.LOG_CLASSIFICATION_CODE
, B.LOG_TYPE_CODE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.LOCAL_CHANGE_ID
, B.LOCAL_CHANGE_LINE_ID
, T.LOG_TEXT
, B.LOCAL_REVISED_ITEM_SEQUENCE_ID
, B.REVISED_ITEM_SEQUENCE_ID
, B.LOCAL_ORGANIZATION_ID
, B.CHANGE_PROPAGATION_MAP_ID
FROM ENG_CHANGE_LOGS_B B
, ENG_CHANGE_LOGS_TL T
WHERE B.CHANGE_LOG_ID = T.CHANGE_LOG_ID
AND T.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
CHANGE_LOG_ID |
CHANGE_ID |
CHANGE_LINE_ID |
LOG_CLASSIFICATION_CODE |
LOG_TYPE_CODE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
LOCAL_CHANGE_ID |
LOCAL_CHANGE_LINE_ID |
LOG_TEXT |
LOCAL_REVISED_ITEM_SEQUENCE_ID |
REVISED_ITEM_SEQUENCE_ID |
LOCAL_ORGANIZATION_ID |
CHANGE_PROPAGATION_MAP_ID |