VIEW: APPS.PER_KR_RESIDENT_REG_NUMBER_V

Source

View Text - Preformatted

SELECT ppf.person_id person_id, ppf.person_id cont_person_id, ppf.national_identifier national_identifier, ppf.FULL_NAME full_name, ppf.effective_start_date cont_effective_start_date, ppf.effective_end_date cont_effective_end_date, ppf.effective_start_date person_effective_start_date, ppf.effective_end_date person_effective_end_date, to_date(NULL) relationship_start_date, to_date(NULL) relationship_end_date, NULL relationship_end_reason from per_all_people_f ppf UNION ALL select ppf1.person_id person_id, ppf2.person_id cont_person_id, ppf2.national_identifier national_identifier, ppf2.FULL_NAME full_name, ppf2.effective_start_date cont_effective_start_date, ppf2.effective_end_date cont_effective_end_date, ppf1.effective_start_date person_effective_start_date, ppf1.effective_end_date person_effective_end_date, pcr.date_start relationship_start_date, pcr.date_end relationship_end_date, pcr.cont_information9 relationship_end_reason from per_all_people_f ppf1, per_contact_relationships pcr, per_all_people_f ppf2 where ppf1.person_id = pcr.person_id and pcr.contact_person_id = ppf2.person_id and pcr.cont_information_category = 'KR'

View Text - HTML Formatted

SELECT PPF.PERSON_ID PERSON_ID
, PPF.PERSON_ID CONT_PERSON_ID
, PPF.NATIONAL_IDENTIFIER NATIONAL_IDENTIFIER
, PPF.FULL_NAME FULL_NAME
, PPF.EFFECTIVE_START_DATE CONT_EFFECTIVE_START_DATE
, PPF.EFFECTIVE_END_DATE CONT_EFFECTIVE_END_DATE
, PPF.EFFECTIVE_START_DATE PERSON_EFFECTIVE_START_DATE
, PPF.EFFECTIVE_END_DATE PERSON_EFFECTIVE_END_DATE
, TO_DATE(NULL) RELATIONSHIP_START_DATE
, TO_DATE(NULL) RELATIONSHIP_END_DATE
, NULL RELATIONSHIP_END_REASON
FROM PER_ALL_PEOPLE_F PPF UNION ALL SELECT PPF1.PERSON_ID PERSON_ID
, PPF2.PERSON_ID CONT_PERSON_ID
, PPF2.NATIONAL_IDENTIFIER NATIONAL_IDENTIFIER
, PPF2.FULL_NAME FULL_NAME
, PPF2.EFFECTIVE_START_DATE CONT_EFFECTIVE_START_DATE
, PPF2.EFFECTIVE_END_DATE CONT_EFFECTIVE_END_DATE
, PPF1.EFFECTIVE_START_DATE PERSON_EFFECTIVE_START_DATE
, PPF1.EFFECTIVE_END_DATE PERSON_EFFECTIVE_END_DATE
, PCR.DATE_START RELATIONSHIP_START_DATE
, PCR.DATE_END RELATIONSHIP_END_DATE
, PCR.CONT_INFORMATION9 RELATIONSHIP_END_REASON
FROM PER_ALL_PEOPLE_F PPF1
, PER_CONTACT_RELATIONSHIPS PCR
, PER_ALL_PEOPLE_F PPF2
WHERE PPF1.PERSON_ID = PCR.PERSON_ID
AND PCR.CONTACT_PERSON_ID = PPF2.PERSON_ID
AND PCR.CONT_INFORMATION_CATEGORY = 'KR'