eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: ENG.ENG_ATTACHMENT_CHANGES#

Source

View Text - Preformatted


select CHANGE_ID CHANGE_ID, REVISED_ITEM_SEQUENCE_ID REVISED_ITEM_SEQUENCE_ID, ATTACHMENT_ID ATTACHMENT_ID, CHANGE_DOCUMENT_ID CHANGE_DOCUMENT_ID, ACTION_TYPE ACTION_TYPE, FILE_NAME FILE_NAME, SOURCE_MEDIA_ID SOURCE_MEDIA_ID, SOURCE_VERSION_LABEL SOURCE_VERSION_LABEL, SOURCE_PATH SOURCE_PATH, DEST_MEDIA_ID DEST_MEDIA_ID, DEST_VERSION_LABEL DEST_VERSION_LABEL, DEST_PATH DEST_PATH, CATEGORY_ID CATEGORY_ID, ATTACHED_USER_ID ATTACHED_USER_ID, PREVIOUS_STATUS PREVIOUS_STATUS, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, FAMILY_ID FAMILY_ID, REPOSITORY_ID REPOSITORY_ID, DM_TYPE DM_TYPE, ENTITY_NAME ENTITY_NAME, PK1_VALUE PK1_VALUE, PK2_VALUE PK2_VALUE, PK3_VALUE PK3_VALUE, PK4_VALUE PK4_VALUE, PK5_VALUE PK5_VALUE, NEW_FILE_NAME NEW_FILE_NAME, DESCRIPTION DESCRIPTION, NEW_DESCRIPTION NEW_DESCRIPTION, SOURCE_DOCUMENT_ID SOURCE_DOCUMENT_ID, DEST_DOCUMENT_ID DEST_DOCUMENT_ID, NEW_CATEGORY_ID NEW_CATEGORY_ID, DATATYPE_ID DATATYPE_ID from "ENG"."ENG_ATTACHMENT_CHANGES"

View Text - HTML Formatted

SELECT CHANGE_ID CHANGE_ID
, REVISED_ITEM_SEQUENCE_ID REVISED_ITEM_SEQUENCE_ID
, ATTACHMENT_ID ATTACHMENT_ID
, CHANGE_DOCUMENT_ID CHANGE_DOCUMENT_ID
, ACTION_TYPE ACTION_TYPE
, FILE_NAME FILE_NAME
, SOURCE_MEDIA_ID SOURCE_MEDIA_ID
, SOURCE_VERSION_LABEL SOURCE_VERSION_LABEL
, SOURCE_PATH SOURCE_PATH
, DEST_MEDIA_ID DEST_MEDIA_ID
, DEST_VERSION_LABEL DEST_VERSION_LABEL
, DEST_PATH DEST_PATH
, CATEGORY_ID CATEGORY_ID
, ATTACHED_USER_ID ATTACHED_USER_ID
, PREVIOUS_STATUS PREVIOUS_STATUS
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FAMILY_ID FAMILY_ID
, REPOSITORY_ID REPOSITORY_ID
, DM_TYPE DM_TYPE
, ENTITY_NAME ENTITY_NAME
, PK1_VALUE PK1_VALUE
, PK2_VALUE PK2_VALUE
, PK3_VALUE PK3_VALUE
, PK4_VALUE PK4_VALUE
, PK5_VALUE PK5_VALUE
, NEW_FILE_NAME NEW_FILE_NAME
, DESCRIPTION DESCRIPTION
, NEW_DESCRIPTION NEW_DESCRIPTION
, SOURCE_DOCUMENT_ID SOURCE_DOCUMENT_ID
, DEST_DOCUMENT_ID DEST_DOCUMENT_ID
, NEW_CATEGORY_ID NEW_CATEGORY_ID
, DATATYPE_ID DATATYPE_ID
FROM "ENG"."ENG_ATTACHMENT_CHANGES"