[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 |
APPS.WF_PER_ROLE_ROLES