VIEW: APPS.PER_DISABILITIES_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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