[Home] [Help]
View: WF_ROLES
Product: | FND - Application Object Library |
Description: | Public view for Workflow Directory Service Roles |
Implementation/DBA Data: |
APPS.WF_ROLES
|
View Text
SELECT WR.NAME
, NVL(WRT.DISPLAY_NAME
, WR.DISPLAY_NAME)
, NVL(WRT.DESCRIPTION
, WR.DISPLAY_NAME)
, 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
FROM WF_LOCAL_ROLES WR
, WF_LOCAL_ROLES_TL WRT
WHERE WR.PARTITION_ID <> 3 /*EXCLUDING PER_ROLE */
AND NVL(WR.EXPIRATION_DATE
, SYSDATE+1) > SYSDATE
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')
Columns
Name |
NAME |
DISPLAY_NAME |
DESCRIPTION |
NOTIFICATION_PREFERENCE |
LANGUAGE |
TERRITORY |
EMAIL_ADDRESS |
FAX |
ORIG_SYSTEM |
ORIG_SYSTEM_ID |
START_DATE |
STATUS |
EXPIRATION_DATE |