[Home] [Help]
View: HZ_PARTY_WF_USER_ROLES_V
View Text
SELECT NAME USER_NAME
, ORIG_SYSTEM USER_ORIG_SYSTEM
, ORIG_SYSTEM_ID USER_ORIG_SYSTEM_ID
, NAME ROLE_NAME
, ORIG_SYSTEM ROLE_ORIG_SYSTEM
, ORIG_SYSTEM_ID ROLE_ORIG_SYSTEM_ID
, START_DATE
, EXPIRATION_DATE
, NULL SECURITY_GROUP_ID
, 9 PARTITION_ID
FROM WF_LOCAL_ROLES PARTITION (HZ_PARTY)
Columns
Name |
USER_NAME |
USER_ORIG_SYSTEM |
USER_ORIG_SYSTEM_ID |
ROLE_NAME |
ROLE_ORIG_SYSTEM |
ROLE_ORIG_SYSTEM_ID |
START_DATE |
EXPIRATION_DATE |
SECURITY_GROUP_ID |
PARTITION_ID |