[Home] [Help]
View: WF_PER_ROLE_ROLES
View Text
SELECT /*+ INDEX_FFS(PER
, PER_PEOPLE_F_PK)
*/ 'PER_ROLE:'||PER.PERSON_ID
, PER.FULL_NAME
, PER.FULL_NAME
, 'MAILHTML'
,
NULL
, NULL
, PER.EMAIL_ADDRESS
, NULL
, 'PER_ROLE'
, PER.PERSON_ID
,
PER.EFFECTIVE_START_DATE
, 'ACTIVE'
, PER.EFFECTIVE_END_DATE
, NULL
, 'N'
, 3
FROM PER_ALL_PEOPLE_F PER
WHERE TRUNC(SYSDATE) BETWEEN
PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
Columns
Name |
NAME |
DISPLAY_NAME |
DESCRIPTION |
NOTIFICATION_PREFERENCE |
LANGUAGE |
TERRITORY |
EMAIL_ADDRESS |
FAX |
ORIG_SYSTEM |
ORIG_SYSTEM_ID |
START_DATE |
STATUS |
EXPIRATION_DATE |
SECURITY_GROUP_ID |
USER_FLAG |
PARTITION_ID |