VIEW: APPS.ENG_CHANGE_LOGS_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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