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: AHL.AHL_DOC_REVISIONS_B#

Source

View Text - Preformatted


select DOC_REVISION_ID DOC_REVISION_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, 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, DOCUMENT_ID DOCUMENT_ID, REVISION_NO REVISION_NO, APPROVED_BY_PARTY_ID APPROVED_BY_PARTY_ID, REVISION_TYPE_CODE REVISION_TYPE_CODE, REVISION_STATUS_CODE REVISION_STATUS_CODE, REVISION_DATE REVISION_DATE, APPROVED_DATE APPROVED_DATE, EFFECTIVE_DATE EFFECTIVE_DATE, OBSOLETE_DATE OBSOLETE_DATE, ISSUE_DATE ISSUE_DATE, RECEIVED_DATE RECEIVED_DATE, URL URL, MEDIA_TYPE_CODE MEDIA_TYPE_CODE, VOLUME VOLUME, ISSUE ISSUE, ISSUE_NUMBER ISSUE_NUMBER, SECURITY_GROUP_ID SECURITY_GROUP_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ENIGMA_DOC_ID ENIGMA_DOC_ID, ENIGMA_MODEL_CODE ENIGMA_MODEL_CODE from "AHL"."AHL_DOC_REVISIONS_B"

View Text - HTML Formatted

SELECT DOC_REVISION_ID DOC_REVISION_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 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
, DOCUMENT_ID DOCUMENT_ID
, REVISION_NO REVISION_NO
, APPROVED_BY_PARTY_ID APPROVED_BY_PARTY_ID
, REVISION_TYPE_CODE REVISION_TYPE_CODE
, REVISION_STATUS_CODE REVISION_STATUS_CODE
, REVISION_DATE REVISION_DATE
, APPROVED_DATE APPROVED_DATE
, EFFECTIVE_DATE EFFECTIVE_DATE
, OBSOLETE_DATE OBSOLETE_DATE
, ISSUE_DATE ISSUE_DATE
, RECEIVED_DATE RECEIVED_DATE
, URL URL
, MEDIA_TYPE_CODE MEDIA_TYPE_CODE
, VOLUME VOLUME
, ISSUE ISSUE
, ISSUE_NUMBER ISSUE_NUMBER
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ENIGMA_DOC_ID ENIGMA_DOC_ID
, ENIGMA_MODEL_CODE ENIGMA_MODEL_CODE
FROM "AHL"."AHL_DOC_REVISIONS_B"