VIEW: APPS.PER_NL_WAO_LIST_V

Source

View Text - Preformatted

SELECT pap.full_name ,pap.employee_number ,pap.national_identifier ,pap.person_id ,pd.disability_id ,pd.effective_start_date ,pd.effective_end_date ,pd.quota_fte ,pd.reason ,pd.status ,pwi.incident_reference ,pwi.incident_date ,pd.registration_id ,haou.name ,pd.registration_date ,pd.registration_exp_date ,pd.description ,pd.work_restriction ,pd.dis_information3 ,pd.dis_information1 ,pd.dis_information4 ,pd.dis_information5 ,pd.last_update_date ,pd.last_updated_by ,pd.last_update_login ,pd.created_by ,pd.creation_date ,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.attribute21 ,pd.attribute22 ,pd.attribute23 ,pd.attribute24 ,pd.attribute25 ,pd.attribute26 ,pd.attribute27 ,pd.attribute28 ,pd.attribute29 ,pd.attribute30 from per_all_people_f pap ,per_disabilities_f pd ,per_work_incidents pwi ,hr_all_organization_units haou WHERE pd.person_id= pap.person_id and pd.incident_id= pwi.incident_id and pd.person_id= pwi.person_id and pd.organization_id= haou.organization_id and pd.category= 'NL_WAO' and pap.business_group_id=NVL(hr_general.get_business_group_id,pap.business_group_id) and pd.effective_end_date between pap.effective_start_date and pap.effective_end_date

View Text - HTML Formatted

SELECT PAP.FULL_NAME
, PAP.EMPLOYEE_NUMBER
, PAP.NATIONAL_IDENTIFIER
, PAP.PERSON_ID
, PD.DISABILITY_ID
, PD.EFFECTIVE_START_DATE
, PD.EFFECTIVE_END_DATE
, PD.QUOTA_FTE
, PD.REASON
, PD.STATUS
, PWI.INCIDENT_REFERENCE
, PWI.INCIDENT_DATE
, PD.REGISTRATION_ID
, HAOU.NAME
, PD.REGISTRATION_DATE
, PD.REGISTRATION_EXP_DATE
, PD.DESCRIPTION
, PD.WORK_RESTRICTION
, PD.DIS_INFORMATION3
, PD.DIS_INFORMATION1
, PD.DIS_INFORMATION4
, PD.DIS_INFORMATION5
, PD.LAST_UPDATE_DATE
, PD.LAST_UPDATED_BY
, PD.LAST_UPDATE_LOGIN
, PD.CREATED_BY
, PD.CREATION_DATE
, 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.ATTRIBUTE21
, PD.ATTRIBUTE22
, PD.ATTRIBUTE23
, PD.ATTRIBUTE24
, PD.ATTRIBUTE25
, PD.ATTRIBUTE26
, PD.ATTRIBUTE27
, PD.ATTRIBUTE28
, PD.ATTRIBUTE29
, PD.ATTRIBUTE30
FROM PER_ALL_PEOPLE_F PAP
, PER_DISABILITIES_F PD
, PER_WORK_INCIDENTS PWI
, HR_ALL_ORGANIZATION_UNITS HAOU
WHERE PD.PERSON_ID= PAP.PERSON_ID
AND PD.INCIDENT_ID= PWI.INCIDENT_ID
AND PD.PERSON_ID= PWI.PERSON_ID
AND PD.ORGANIZATION_ID= HAOU.ORGANIZATION_ID
AND PD.CATEGORY= 'NL_WAO'
AND PAP.BUSINESS_GROUP_ID=NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, PAP.BUSINESS_GROUP_ID)
AND PD.EFFECTIVE_END_DATE BETWEEN PAP.EFFECTIVE_START_DATE
AND PAP.EFFECTIVE_END_DATE