View: IRC_REGISTERED_USERS

Product:	PER - Human Resources
Description:
Implementation/DBA Data:	APPS.IRC_REGISTERED_USERS

View Text

SELECT HPP.PERSON_FIRST_NAME
, HPP.PERSON_LAST_NAME
, HPP.PERSON_NAME_PHONETIC
, HPP.PERSON_LAST_NAME_PHONETIC
, HPP.PERSON_FIRST_NAME_PHONETIC
, HPP.PERSON_MIDDLE_NAME
, HPP.PERSON_NAME_SUFFIX
, HPP.PERSON_PREVIOUS_LAST_NAME
, HPP.KNOWN_AS
, TO_NUMBER(HPP.PERSON_IDENTIFIER) PERSON_ID
, HPP.DATE_OF_BIRTH
, HPP.PLACE_OF_BIRTH
, HPP.DATE_OF_DEATH
, HPP.MARITAL_STATUS
, HPP.PERSON_PRE_NAME_ADJUNCT
FROM HZ_PERSON_PROFILES HPP
, IRC_NOTIFICATION_PREFERENCES INP
WHERE INP.ALLOW_ACCESS = 'Y'
AND HPP.PARTY_ID = INP.PARTY_ID

Columns