VIEW: APPS.IRC_REGISTERED_USERS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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