VIEW: APPS.IGS_PE_PERS_DISABLTY_V

Source

View Text - Preformatted

SELECT PD.ROWID ROW_ID, PD.IGS_PE_PERS_DISABLTY_ID, PD.PERSON_ID, PD.DISABILITY_TYPE, CC1.MEANING SPECIAL_NEED_ALLOW, PD. SPECIAL_ALLOW_CD, CC2.MEANING ADDITIONAL_SUP_LEVEL, PD. SUPPORT_LEVEL_CD, PD.ELIG_EARLY_REG_IND, PD.START_DATE, PD.END_DATE, PD.INFO_SOURCE, HP.FULL_NAME INTERVIEWER_FN, PD.INTERVIEWER_ID, HP.PERSON_NUMBER, PD.INTERVIEWER_DATE, PD.ATTRIBUTE_CATEGORY, PD.ATTRIBUTE1, PD.ATTRIBUTE2, PD.ATTRIBUTE3, PD.ATTRIBUTE4, PD.ATTRIBUTE5, PD.ATTRIBUTE6, PD.ATTRIBUTE7, PD.ATTRIBUTE8, PD.ATTRIBUTE9, PD.ATTRIBUTE10, PD.ATTRIBUTE11, PD.ATTRIBUTE12, PD.ATTRIBUTE13, PD.ATTRIBUTE14, PD.ATTRIBUTE15, PD.ATTRIBUTE16, PD.ATTRIBUTE17, PD.ATTRIBUTE18, PD.ATTRIBUTE19, PD.ATTRIBUTE20, PD.CREATED_BY, PD.CREATION_DATE, PD.LAST_UPDATED_BY, PD.LAST_UPDATE_DATE, PD.LAST_UPDATE_LOGIN, DT.DESCRIPTION FROM IGS_PE_PERS_DISABLTY PD, IGS_LOOKUP_VALUES CC1, IGS_LOOKUP_VALUES CC2, IGS_PE_PERSON_BASE_V HP, IGS_AD_DISBL_TYPE DT WHERE CC1.LOOKUP_CODE(+) = PD.SPECIAL_ALLOW_CD AND CC1.LOOKUP_TYPE(+) = 'PE_SN_ALLOW' AND CC2.LOOKUP_CODE(+) = PD.SUPPORT_LEVEL_CD AND CC2.LOOKUP_TYPE(+) = 'PE_SN_ADD_SUP_LVL' AND HP.PERSON_ID(+) = PD.INTERVIEWER_ID AND DT.DISABILITY_TYPE = PD.DISABILITY_TYPE

View Text - HTML Formatted

SELECT PD.ROWID ROW_ID
, PD.IGS_PE_PERS_DISABLTY_ID
, PD.PERSON_ID
, PD.DISABILITY_TYPE
, CC1.MEANING SPECIAL_NEED_ALLOW
, PD. SPECIAL_ALLOW_CD
, CC2.MEANING ADDITIONAL_SUP_LEVEL
, PD. SUPPORT_LEVEL_CD
, PD.ELIG_EARLY_REG_IND
, PD.START_DATE
, PD.END_DATE
, PD.INFO_SOURCE
, HP.FULL_NAME INTERVIEWER_FN
, PD.INTERVIEWER_ID
, HP.PERSON_NUMBER
, PD.INTERVIEWER_DATE
, PD.ATTRIBUTE_CATEGORY
, PD.ATTRIBUTE1
, PD.ATTRIBUTE2
, PD.ATTRIBUTE3
, PD.ATTRIBUTE4
, PD.ATTRIBUTE5
, PD.ATTRIBUTE6
, PD.ATTRIBUTE7
, PD.ATTRIBUTE8
, PD.ATTRIBUTE9
, PD.ATTRIBUTE10
, PD.ATTRIBUTE11
, PD.ATTRIBUTE12
, PD.ATTRIBUTE13
, PD.ATTRIBUTE14
, PD.ATTRIBUTE15
, PD.ATTRIBUTE16
, PD.ATTRIBUTE17
, PD.ATTRIBUTE18
, PD.ATTRIBUTE19
, PD.ATTRIBUTE20
, PD.CREATED_BY
, PD.CREATION_DATE
, PD.LAST_UPDATED_BY
, PD.LAST_UPDATE_DATE
, PD.LAST_UPDATE_LOGIN
, DT.DESCRIPTION
FROM IGS_PE_PERS_DISABLTY PD
, IGS_LOOKUP_VALUES CC1
, IGS_LOOKUP_VALUES CC2
, IGS_PE_PERSON_BASE_V HP
, IGS_AD_DISBL_TYPE DT
WHERE CC1.LOOKUP_CODE(+) = PD.SPECIAL_ALLOW_CD
AND CC1.LOOKUP_TYPE(+) = 'PE_SN_ALLOW'
AND CC2.LOOKUP_CODE(+) = PD.SUPPORT_LEVEL_CD
AND CC2.LOOKUP_TYPE(+) = 'PE_SN_ADD_SUP_LVL'
AND HP.PERSON_ID(+) = PD.INTERVIEWER_ID
AND DT.DISABILITY_TYPE = PD.DISABILITY_TYPE