Product: | PER - Human Resources |
---|---|
Description: | Selects all work incidents for a particular person |
Implementation/DBA Data: | APPS.PER_WORK_INCIDENTS_V |
SELECT INC.INCIDENT_ID
, PER.BUSINESS_GROUP_ID
, PER.PERSON_ID
, INC.ASSIGNMENT_ID
, HR_GENERAL.DECODE_JOB(ASG.JOB_ID)
, INC.INCIDENT_REFERENCE
, INC.INCIDENT_TYPE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('INCIDENT_TYPE'
, INC.INCIDENT_TYPE)
, 1
, 30)
, INC.INCIDENT_DATE
, TO_DATE(INC.INCIDENT_TIME
, 'HH24:MI')
, INC.ORG_NOTIFIED_DATE
, INC.LOCATION
, INC.AT_WORK_FLAG
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('AT_WORK_FLAG'
, INC.AT_WORK_FLAG)
, 1
, 30)
, INC.REPORT_DATE
, TO_DATE(INC.REPORT_TIME
, 'HH24:MI')
, INC.REPORT_METHOD
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('PER_CM_MTHD'
, INC.REPORT_METHOD)
, 1
, 30)
, INC.PERSON_REPORTED_BY
, SUBSTR(HR_GENERAL.DECODE_PERSON_NAME(INC.PERSON_REPORTED_BY)
, 1
, 60)
, INC.PERSON_REPORTED_TO
, INC.WITNESS_DETAILS
, INC.DESCRIPTION
, INC.INJURY_TYPE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('INJURY_TYPE'
, INC.INJURY_TYPE)
, 1
, 30)
, INC.DISEASE_TYPE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('DISEASE_TYPE'
, INC.DISEASE_TYPE)
, 1
, 30)
, INC.HAZARD_TYPE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('HAZARD_TYPE'
, INC.HAZARD_TYPE)
, 1
, 30)
, INC.BODY_PART
, INC.TREATMENT_RECEIVED_FLAG
, INC.HOSPITAL_DETAILS
, INC.HOSPITAL_ADDRESS
, INC.ACTIVITY_AT_TIME_OF_WORK
, INC.OBJECTS_INVOLVED
, INC.HOSPITALIZED_FLAG
, INC.PRIVACY_ISSUE
, INC.EMERGENCY_CODE
, INC.DAYS_RESTRICTED_WORK
, INC.DAYS_AWAY_FROM_WORK
, TO_DATE(INC.WORK_START_TIME
, 'HH24:MI')
, INC.REPORT_COMPLETED_BY
, INC.REPORTING_PERSON_TITLE
, INC.REPORTING_PERSON_PHONE
, INC.DATE_OF_DEATH
, INC.DOCTOR_NAME
, INC.COMPENSATION_DATE
, INC.COMPENSATION_CURRENCY
, INC.COMPENSATION_AMOUNT
, INC.REMEDIAL_HS_ACTION
, INC.NOTIFIED_HSREP_ID
, SUBSTR(HR_GENERAL.DECODE_PERSON_NAME(INC.NOTIFIED_HSREP_ID)
, 1
, 60)
, INC.NOTIFIED_HSREP_DATE
, INC.NOTIFIED_REP_ID
, SUBSTR(HR_GENERAL.DECODE_PERSON_NAME(INC.NOTIFIED_REP_ID)
, 1
, 60)
, INC.NOTIFIED_REP_DATE
, INC.NOTIFIED_REP_ORG_ID
, ORG.NAME
, INC.RELATED_INCIDENT_ID
, PER_INC_BUS.GET_INCIDENT_REFERENCE(INC.RELATED_INCIDENT_ID)
, INC.ABSENCE_EXISTS_FLAG
, INC.OVER_TIME_FLAG
, INC.INC_INFORMATION_CATEGORY
, INC.INC_INFORMATION1
, INC.INC_INFORMATION2
, INC.INC_INFORMATION3
, INC.INC_INFORMATION4
, INC.INC_INFORMATION5
, INC.INC_INFORMATION6
, INC.INC_INFORMATION7
, INC.INC_INFORMATION8
, INC.INC_INFORMATION9
, INC.INC_INFORMATION10
, INC.INC_INFORMATION11
, INC.INC_INFORMATION12
, INC.INC_INFORMATION13
, INC.INC_INFORMATION14
, INC.INC_INFORMATION15
, INC.INC_INFORMATION16
, INC.INC_INFORMATION17
, INC.INC_INFORMATION18
, INC.INC_INFORMATION19
, INC.INC_INFORMATION20
, INC.INC_INFORMATION21
, INC.INC_INFORMATION22
, INC.INC_INFORMATION23
, INC.INC_INFORMATION24
, INC.INC_INFORMATION25
, INC.INC_INFORMATION26
, INC.INC_INFORMATION27
, INC.INC_INFORMATION28
, INC.INC_INFORMATION29
, INC.INC_INFORMATION30
, INC.ATTRIBUTE_CATEGORY
, INC.ATTRIBUTE1
, INC.ATTRIBUTE2
, INC.ATTRIBUTE3
, INC.ATTRIBUTE4
, INC.ATTRIBUTE5
, INC.ATTRIBUTE6
, INC.ATTRIBUTE7
, INC.ATTRIBUTE8
, INC.ATTRIBUTE9
, INC.ATTRIBUTE10
, INC.ATTRIBUTE11
, INC.ATTRIBUTE12
, INC.ATTRIBUTE13
, INC.ATTRIBUTE14
, INC.ATTRIBUTE15
, INC.ATTRIBUTE16
, INC.ATTRIBUTE17
, INC.ATTRIBUTE18
, INC.ATTRIBUTE19
, INC.ATTRIBUTE20
, INC.ATTRIBUTE21
, INC.ATTRIBUTE22
, INC.ATTRIBUTE23
, INC.ATTRIBUTE24
, INC.ATTRIBUTE25
, INC.ATTRIBUTE26
, INC.ATTRIBUTE27
, INC.ATTRIBUTE28
, INC.ATTRIBUTE29
, INC.ATTRIBUTE30
, INC.LAST_UPDATE_DATE
, INC.LAST_UPDATED_BY
, INC.LAST_UPDATE_LOGIN
, INC.CREATED_BY
, INC.CREATION_DATE
, INC.OBJECT_VERSION_NUMBER
FROM PER_WORK_INCIDENTS INC
, PER_PEOPLE_F PER
, PER_ASSIGNMENTS_F ASG
, HR_ALL_ORGANIZATION_UNITS ORG
, FND_SESSIONS SES
WHERE INC.PERSON_ID = PER.PERSON_ID
AND SES.EFFECTIVE_DATE BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND INC.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID (+)
AND INC.INCIDENT_DATE BETWEEN NVL(ASG.EFFECTIVE_START_DATE
, HR_GENERAL.START_OF_TIME)
AND NVL(ASG.EFFECTIVE_END_DATE
, HR_GENERAL.END_OF_TIME)
AND INC.NOTIFIED_REP_ORG_ID = ORG.ORGANIZATION_ID (+)
AND SES.SESSION_ID = USERENV('SESSIONID')