View: PER_ROLE_ROLES_V

Product:	PER - Human Resources
Description:	Used for WorkFlow Directory Service
Implementation/DBA Data:	APPS.PER_ROLE_ROLES_V

View Text

SELECT 'PER_ROLE:'||PER.PERSON_ID NAME
, DECODE((SELECT PROFILE_OPTION_VALUE
FROM FND_PROFILE_OPTION_VALUES V
, FND_PROFILE_OPTIONS O
WHERE V.PROFILE_OPTION_ID = O.PROFILE_OPTION_ID
AND O.PROFILE_OPTION_NAME = 'HR_INFORMAL_NAME_FORMAT'
AND V.LEVEL_VALUE = 0
AND V.APPLICATION_ID = O.APPLICATION_ID
AND V.LEVEL_ID = 10001)
, NULL
, PER.FULL_NAME
, REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(REPLACE(REPLACE( ((SELECT PROFILE_OPTION_VALUE
FROM FND_PROFILE_OPTION_VALUES V
, FND_PROFILE_OPTIONS O
WHERE V.PROFILE_OPTION_ID = O.PROFILE_OPTION_ID
AND O.PROFILE_OPTION_NAME = 'HR_INFORMAL_NAME_FORMAT'
AND V.LEVEL_VALUE = 0
AND V.APPLICATION_ID = O.APPLICATION_ID
AND V.LEVEL_ID = 10001) )
, '$FI'
, PER.FIRST_NAME)
, '$MI'
, PER.MIDDLE_NAMES)
, '$LA'
, PER.LAST_NAME)
, '$PR'
, PER.PRE_NAME_ADJUNCT)
, '$SU'
, PER.SUFFIX)
, '$TI'
, PER.TITLE)
, '$FU'
, PER.FULL_NAME)
, '$KN'
, PER.KNOWN_AS)
, '$IF'
, SUBSTR(LTRIM(PER.FIRST_NAME)
, 1
, 1))
, '$IM'
, SUBSTR(LTRIM(PER.MIDDLE_NAMES)
, 1
, 1)) DISPLAY_NAME
, PER.FULL_NAME DESCRIPTION
, 'MAILHTML' NOTIFICATION_REFEARENCE
, NULL LANGUAGE
, NULL TERRITORRY
, PER.EMAIL_ADDRESS EMAIL_ADDRESS
, NULL FAX
, 'PER_ROLE' ORIG_SYSTEM
, PER.PERSON_ID ORIG_SYSTEM_ID
, TO_DATE(NULL) START_DATE
, 'ACTIVE' STATUS
, TO_DATE(NULL) EXPIRATION_DATE
, NULL SECURITY_GROUP_ID
, 'N' USER_FLAG
, TO_NUMBER('3') PARTITION_ID
FROM PER_ALL_PEOPLE_F PER
WHERE TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE

Columns