VIEW: APPS.PER_ROLE_ROLES_V

Source

View Text - Preformatted

SELECT /*+ index_ffs(PER,PER_PEOPLE_F_PK) */ 'PER_ROLE:'||PER.PERSON_ID NAME , nvl(PER.GLOBAL_NAME,PER.LAST_NAME||', '||NVL(PER.KNOWN_AS, PER.FIRST_NAME)) 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 , PER.START_DATE START_DATE , 'ACTIVE' STATUS , NULL EXPIRATION_DATE , NULL SECURITY_GROUP_ID , 'N' USER_FLAG , to_number('3') PARTITION_ID ,PARTY_ID PERSON_PARTY_ID FROM PER_ALL_PEOPLE_F PER WHERE trunc(sysdate) between PER.effective_start_date and PER.effective_end_date+(1-1/86400)

View Text - HTML Formatted

SELECT /*+ INDEX_FFS(PER
, PER_PEOPLE_F_PK) */ 'PER_ROLE:'||PER.PERSON_ID NAME
, NVL(PER.GLOBAL_NAME
, PER.LAST_NAME||'
, '||NVL(PER.KNOWN_AS
, PER.FIRST_NAME)) 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
, PER.START_DATE START_DATE
, 'ACTIVE' STATUS
, NULL EXPIRATION_DATE
, NULL SECURITY_GROUP_ID
, 'N' USER_FLAG
, TO_NUMBER('3') PARTITION_ID
, PARTY_ID PERSON_PARTY_ID
FROM PER_ALL_PEOPLE_F PER
WHERE TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE+(1-1/86400)