Product: | PER - Human Resources |
---|---|
Description: | Dutch WAO List View |
Implementation/DBA Data: | APPS.PER_NL_WAO_LIST_V |
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 PD.EFFECTIVE_END_DATE BETWEEN PAP.EFFECTIVE_START_DATE
AND PAP.EFFECTIVE_END_DATE