[Home] [Help]
| Product: | ENG - Engineering |
|---|---|
| Description: | |
| Implementation/DBA Data: |
APPS.ENG_CHANGE_LOGS_VL
|
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')