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: AMS.AMS_LIST_ENTRY_USAGES#

Source

View Text - Preformatted


select LIST_ENTRY_USAGE_ID LIST_ENTRY_USAGE_ID, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LIST_ENTRY_ID LIST_ENTRY_ID, LIST_HEADER_ID LIST_HEADER_ID, CAMPAIGN_ID CAMPAIGN_ID, ASSIGNED_PERSON_ID ASSIGNED_PERSON_ID, DUE_DATE DUE_DATE, DUE_TIME DUE_TIME, STATUS STATUS, USER_DEFINED1 USER_DEFINED1, USER_DEFINED2 USER_DEFINED2, USER_DEFINED3 USER_DEFINED3, USER_DEFINED4 USER_DEFINED4, USER_DEFINED5 USER_DEFINED5, USER_DEFINED6 USER_DEFINED6, USER_DEFINED7 USER_DEFINED7, USER_DEFINED8 USER_DEFINED8, USER_DEFINED9 USER_DEFINED9, USER_DEFINED10 USER_DEFINED10, USER_DEFINED11 USER_DEFINED11, USER_DEFINED12 USER_DEFINED12, USER_DEFINED13 USER_DEFINED13, USER_DEFINED14 USER_DEFINED14, USER_DEFINED15 USER_DEFINED15, USER_COMMENTS USER_COMMENTS, SECURITY_GROUP_ID SECURITY_GROUP_ID from "AMS"."AMS_LIST_ENTRY_USAGES"

View Text - HTML Formatted

SELECT LIST_ENTRY_USAGE_ID LIST_ENTRY_USAGE_ID
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LIST_ENTRY_ID LIST_ENTRY_ID
, LIST_HEADER_ID LIST_HEADER_ID
, CAMPAIGN_ID CAMPAIGN_ID
, ASSIGNED_PERSON_ID ASSIGNED_PERSON_ID
, DUE_DATE DUE_DATE
, DUE_TIME DUE_TIME
, STATUS STATUS
, USER_DEFINED1 USER_DEFINED1
, USER_DEFINED2 USER_DEFINED2
, USER_DEFINED3 USER_DEFINED3
, USER_DEFINED4 USER_DEFINED4
, USER_DEFINED5 USER_DEFINED5
, USER_DEFINED6 USER_DEFINED6
, USER_DEFINED7 USER_DEFINED7
, USER_DEFINED8 USER_DEFINED8
, USER_DEFINED9 USER_DEFINED9
, USER_DEFINED10 USER_DEFINED10
, USER_DEFINED11 USER_DEFINED11
, USER_DEFINED12 USER_DEFINED12
, USER_DEFINED13 USER_DEFINED13
, USER_DEFINED14 USER_DEFINED14
, USER_DEFINED15 USER_DEFINED15
, USER_COMMENTS USER_COMMENTS
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "AMS"."AMS_LIST_ENTRY_USAGES"