DBA Data[Home] [Help]

VIEW: APPS.WF_HZ_PARTY_UR

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 , TO_DATE(NULL) , TO_DATE(NULL) , NULL , 9 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
, TO_DATE(NULL)
, TO_DATE(NULL)
, NULL
, 9
FROM WF_LOCAL_ROLES PARTITION (HZ_PARTY)