VIEW: APPS.IGS_PE_RES_DTLS_V

Source

View Text - Preformatted

SELECT RD.ROWID ROW_ID, RD.RESIDENT_DETAILS_ID, RD.PERSON_ID, PE.PERSON_NUMBER, RD.RESIDENCY_CLASS_CD residency_class, CC1.meaning residency_class_desc, RD.RESIDENCY_STATUS_CD residency_status, CC2.meaning residency_status_desc, RD.EVALUATION_DATE, RD.EVALUATOR , CI.start_dt, CI.end_dt, RD.COMMENTS, RD.ATTRIBUTE_CATEGORY, RD.ATTRIBUTE1, RD.ATTRIBUTE2, RD.ATTRIBUTE3, RD.ATTRIBUTE4, RD.ATTRIBUTE5, RD.ATTRIBUTE6, RD.ATTRIBUTE7, RD.ATTRIBUTE8, RD.ATTRIBUTE9, RD.ATTRIBUTE10, RD.ATTRIBUTE11, RD.ATTRIBUTE12, RD.ATTRIBUTE13, RD.ATTRIBUTE14, RD.ATTRIBUTE15, RD.ATTRIBUTE16, RD.ATTRIBUTE17, RD.ATTRIBUTE18, RD.ATTRIBUTE19, RD.ATTRIBUTE20, RD.CREATED_BY, RD.CREATION_DATE, RD.LAST_UPDATED_BY, RD.LAST_UPDATE_DATE, RD.LAST_UPDATE_LOGIN, RD.CAL_TYPE, RD.SEQUENCE_NUMBER, CI.DESCRIPTION CALENDAR_DESC FROM IGS_PE_RES_DTLS RD, IGS_LOOKUP_VALUES CC1, IGS_LOOKUP_VALUES CC2, IGS_PE_PERSON_BASE_V PE, IGS_CA_INST_ALL CI WHERE RD.RESIDENCY_CLASS_CD = CC1.lookup_code AND cc1.lookup_type = 'PE_RES_CLASS' AND RD.RESIDENCY_STATUS_CD = CC2.lookup_code AND cc2.lookup_type = 'PE_RES_STATUS' AND RD.PERSON_ID = PE.PERSON_ID AND RD.CAL_TYPE = CI.CAL_TYPE AND RD.SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER

View Text - HTML Formatted

SELECT RD.ROWID ROW_ID
, RD.RESIDENT_DETAILS_ID
, RD.PERSON_ID
, PE.PERSON_NUMBER
, RD.RESIDENCY_CLASS_CD RESIDENCY_CLASS
, CC1.MEANING RESIDENCY_CLASS_DESC
, RD.RESIDENCY_STATUS_CD RESIDENCY_STATUS
, CC2.MEANING RESIDENCY_STATUS_DESC
, RD.EVALUATION_DATE
, RD.EVALUATOR
, CI.START_DT
, CI.END_DT
, RD.COMMENTS
, RD.ATTRIBUTE_CATEGORY
, RD.ATTRIBUTE1
, RD.ATTRIBUTE2
, RD.ATTRIBUTE3
, RD.ATTRIBUTE4
, RD.ATTRIBUTE5
, RD.ATTRIBUTE6
, RD.ATTRIBUTE7
, RD.ATTRIBUTE8
, RD.ATTRIBUTE9
, RD.ATTRIBUTE10
, RD.ATTRIBUTE11
, RD.ATTRIBUTE12
, RD.ATTRIBUTE13
, RD.ATTRIBUTE14
, RD.ATTRIBUTE15
, RD.ATTRIBUTE16
, RD.ATTRIBUTE17
, RD.ATTRIBUTE18
, RD.ATTRIBUTE19
, RD.ATTRIBUTE20
, RD.CREATED_BY
, RD.CREATION_DATE
, RD.LAST_UPDATED_BY
, RD.LAST_UPDATE_DATE
, RD.LAST_UPDATE_LOGIN
, RD.CAL_TYPE
, RD.SEQUENCE_NUMBER
, CI.DESCRIPTION CALENDAR_DESC
FROM IGS_PE_RES_DTLS RD
, IGS_LOOKUP_VALUES CC1
, IGS_LOOKUP_VALUES CC2
, IGS_PE_PERSON_BASE_V PE
, IGS_CA_INST_ALL CI
WHERE RD.RESIDENCY_CLASS_CD = CC1.LOOKUP_CODE
AND CC1.LOOKUP_TYPE = 'PE_RES_CLASS'
AND RD.RESIDENCY_STATUS_CD = CC2.LOOKUP_CODE
AND CC2.LOOKUP_TYPE = 'PE_RES_STATUS'
AND RD.PERSON_ID = PE.PERSON_ID
AND RD.CAL_TYPE = CI.CAL_TYPE
AND RD.SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER