View: PER_DISABILITIES_D

Product:	PER - Human Resources
Description:	Used by Datetrack History
Implementation/DBA Data:	APPS.PER_DISABILITIES_D

View Text

SELECT DIS.DISABILITY_ID
, DIS.EFFECTIVE_START_DATE
, DIS.EFFECTIVE_END_DATE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('DISABILITY_CATEGORY'
, DIS.CATEGORY)
, 1
, 80)
, DIS.QUOTA_FTE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('DISABILITY_STATUS'
, DIS.STATUS)
, 1
, 80)
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('DISABILITY_REASON'
, DIS.REASON)
, 1
, 80)
, DIS.DEGREE
, INC.INCIDENT_REFERENCE
, INC.INCIDENT_DATE
, MEA.CONSULTATION_DATE
, DIS.DESCRIPTION
, DIS.WORK_RESTRICTION
, ORG.NAME
, DIS.REGISTRATION_ID
, DIS.REGISTRATION_DATE
, DIS.REGISTRATION_EXP_DATE
, DIS.LAST_UPDATE_DATE
, USR.USER_NAME
FROM PER_DISABILITIES_F DIS
, PER_WORK_INCIDENTS INC
, PER_MEDICAL_ASSESSMENTS MEA
, HR_ALL_ORGANIZATION_UNITS ORG
, FND_USER USR
WHERE DIS.INCIDENT_ID = INC.INCIDENT_ID (+)
AND DIS.DISABILITY_ID = MEA.DISABILITY_ID (+)
AND MEA.CONSULTATION_RESULT (+) = 'DI'
AND DIS.ORGANIZATION_ID = ORG.ORGANIZATION_ID (+)
AND DIS.LAST_UPDATED_BY = USR.USER_ID (+) WITH READ ONLY

Columns