DBA Data[Home] [Help]

VIEW: APPS.HZ_PARTY_WF_USER_ROLES_V

Source

View Text - Preformatted

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)
View Text - HTML Formatted

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)