View: WF_ALL_ROLES_VL

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.WF_ALL_ROLES_VL

View Text

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')