SELECT WR.NAME,
nvl(WRT.DISPLAY_NAME, WR.DISPLAY_NAME) DISPLAY_NAME,
nvl(WRT.DESCRIPTION, WR.DESCRIPTION) DESCRIPTION,
WR.NOTIFICATION_PREFERENCE,
WR.LANGUAGE,
WR.TERRITORY,
WR.EMAIL_ADDRESS,
WR.FAX,
WR.ORIG_SYSTEM,
WR.ORIG_SYSTEM_ID,
WR.START_DATE,
WR.STATUS,
WR.EXPIRATION_DATE,
WR.OWNER_TAG,
WR.CREATED_BY,
WR.CREATION_DATE,
WR.LAST_UPDATED_BY,
WR.LAST_UPDATE_DATE,
WR.LAST_UPDATE_LOGIN,
WR.PARTITION_ID
from WF_LOCAL_ROLES wr, WF_LOCAL_ROLES_TL wrt
WHERE WR.partition_id <> 3 /*Excluding PER_ROLE */
and wr.orig_system = wrt.orig_system (+)
and wr.orig_system_id = wrt.orig_system_id (+)
and wr.name = wrt.name (+)
and wr.partition_id = wrt.partition_id (+)
and wrt.language (+) = userenv('LANG')
SELECT WR.NAME
,
NVL(WRT.DISPLAY_NAME
, WR.DISPLAY_NAME) DISPLAY_NAME
,
NVL(WRT.DESCRIPTION
, WR.DESCRIPTION) DESCRIPTION
,
WR.NOTIFICATION_PREFERENCE
,
WR.LANGUAGE
,
WR.TERRITORY
,
WR.EMAIL_ADDRESS
,
WR.FAX
,
WR.ORIG_SYSTEM
,
WR.ORIG_SYSTEM_ID
,
WR.START_DATE
,
WR.STATUS
,
WR.EXPIRATION_DATE
,
WR.OWNER_TAG
,
WR.CREATED_BY
,
WR.CREATION_DATE
,
WR.LAST_UPDATED_BY
,
WR.LAST_UPDATE_DATE
,
WR.LAST_UPDATE_LOGIN
,
WR.PARTITION_ID
FROM WF_LOCAL_ROLES WR
, WF_LOCAL_ROLES_TL WRT
WHERE WR.PARTITION_ID <> 3 /*EXCLUDING PER_ROLE */
AND WR.ORIG_SYSTEM = WRT.ORIG_SYSTEM (+)
AND WR.ORIG_SYSTEM_ID = WRT.ORIG_SYSTEM_ID (+)
AND WR.NAME = WRT.NAME (+)
AND WR.PARTITION_ID = WRT.PARTITION_ID (+)
AND WRT.LANGUAGE (+) = USERENV('LANG')
|
|
|