VIEW: APPLSYS.WF_LOCAL_USER_ROLES_STAGE#

Source

View Text - Preformatted

select USER_NAME USER_NAME, ROLE_NAME ROLE_NAME, USER_ORIG_SYSTEM USER_ORIG_SYSTEM, USER_ORIG_SYSTEM_ID USER_ORIG_SYSTEM_ID, ROLE_ORIG_SYSTEM ROLE_ORIG_SYSTEM, ROLE_ORIG_SYSTEM_ID ROLE_ORIG_SYSTEM_ID, START_DATE START_DATE, EXPIRATION_DATE EXPIRATION_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, PARTITION_ID PARTITION_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, ASSIGNMENT_TYPE ASSIGNMENT_TYPE, PARENT_ORIG_SYSTEM PARENT_ORIG_SYSTEM, PARENT_ORIG_SYSTEM_ID PARENT_ORIG_SYSTEM_ID, USER_START_DATE USER_START_DATE, ROLE_START_DATE ROLE_START_DATE, USER_END_DATE USER_END_DATE, ROLE_END_DATE ROLE_END_DATE, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, ASSIGNMENT_REASON ASSIGNMENT_REASON from "APPLSYS"."WF_LOCAL_USER_ROLES_STAGE"

View Text - HTML Formatted

SELECT USER_NAME USER_NAME
, ROLE_NAME ROLE_NAME
, USER_ORIG_SYSTEM USER_ORIG_SYSTEM
, USER_ORIG_SYSTEM_ID USER_ORIG_SYSTEM_ID
, ROLE_ORIG_SYSTEM ROLE_ORIG_SYSTEM
, ROLE_ORIG_SYSTEM_ID ROLE_ORIG_SYSTEM_ID
, START_DATE START_DATE
, EXPIRATION_DATE EXPIRATION_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, PARTITION_ID PARTITION_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
, ASSIGNMENT_TYPE ASSIGNMENT_TYPE
, PARENT_ORIG_SYSTEM PARENT_ORIG_SYSTEM
, PARENT_ORIG_SYSTEM_ID PARENT_ORIG_SYSTEM_ID
, USER_START_DATE USER_START_DATE
, ROLE_START_DATE ROLE_START_DATE
, USER_END_DATE USER_END_DATE
, ROLE_END_DATE ROLE_END_DATE
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, ASSIGNMENT_REASON ASSIGNMENT_REASON
FROM "APPLSYS"."WF_LOCAL_USER_ROLES_STAGE"