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.

VIEW: APPLSYS.WF_LOCAL_ROLES#

Source

View Text - Preformatted


select NAME NAME, DISPLAY_NAME DISPLAY_NAME, DESCRIPTION DESCRIPTION, NOTIFICATION_PREFERENCE NOTIFICATION_PREFERENCE, LANGUAGE LANGUAGE, TERRITORY TERRITORY, EMAIL_ADDRESS EMAIL_ADDRESS, FAX FAX, ORIG_SYSTEM ORIG_SYSTEM, ORIG_SYSTEM_ID ORIG_SYSTEM_ID, START_DATE START_DATE, STATUS STATUS, EXPIRATION_DATE EXPIRATION_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, USER_FLAG USER_FLAG, PARTITION_ID PARTITION_ID, PARENT_ORIG_SYSTEM PARENT_ORIG_SYSTEM, PARENT_ORIG_SYSTEM_ID PARENT_ORIG_SYSTEM_ID, OWNER_TAG OWNER_TAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "APPLSYS"."WF_LOCAL_ROLES"

View Text - HTML Formatted

SELECT NAME NAME
, DISPLAY_NAME DISPLAY_NAME
, DESCRIPTION DESCRIPTION
, NOTIFICATION_PREFERENCE NOTIFICATION_PREFERENCE
, LANGUAGE LANGUAGE
, TERRITORY TERRITORY
, EMAIL_ADDRESS EMAIL_ADDRESS
, FAX FAX
, ORIG_SYSTEM ORIG_SYSTEM
, ORIG_SYSTEM_ID ORIG_SYSTEM_ID
, START_DATE START_DATE
, STATUS STATUS
, EXPIRATION_DATE EXPIRATION_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, USER_FLAG USER_FLAG
, PARTITION_ID PARTITION_ID
, PARENT_ORIG_SYSTEM PARENT_ORIG_SYSTEM
, PARENT_ORIG_SYSTEM_ID PARENT_ORIG_SYSTEM_ID
, OWNER_TAG OWNER_TAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "APPLSYS"."WF_LOCAL_ROLES"