FND Design Data [Home] [Help]

View: ENG_CHANGE_LOGS_VL

Product: ENG - Engineering
Description:
Implementation/DBA Data: ViewAPPS.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