DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PER_WORK_INCIDENTS_V

Object Details
Object Name: PER_WORK_INCIDENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.PER_WORK_INCIDENTS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
INCIDENT_ID NUMBER (10) Yes Refer to base table.
BUSINESS_GROUP_ID NUMBER (15) Yes Refer to base table.
PERSON_ID NUMBER (10) Yes Refer to base table.
ASSIGNMENT_ID NUMBER (10)
Refer to base table.
D_JOB VARCHAR2 (4000)
Refer to base table.
INCIDENT_REFERENCE VARCHAR2 (30) Yes Refer to base table.
INCIDENT_TYPE VARCHAR2 (30) Yes Refer to base table.
D_INCIDENT_TYPE VARCHAR2 (30)
Refer to base table.
INCIDENT_DATE DATE
Yes Refer to base table.
INCIDENT_TIME DATE

Refer to base table.
ORG_NOTIFIED_DATE DATE

Refer to base table.
LOCATION VARCHAR2 (30)
Refer to base table.
AT_WORK_FLAG VARCHAR2 (30)
Refer to base table.
D_AT_WORK_FLAG VARCHAR2 (30)
Refer to base table.
REPORT_DATE DATE

Refer to base table.
REPORT_TIME DATE

Refer to base table.
REPORT_METHOD VARCHAR2 (30)
Refer to base table.
D_REPORT_METHOD VARCHAR2 (30)
Refer to base table.
PERSON_REPORTED_BY NUMBER (10)
Refer to base table.
D_PERSON_REPORTED_BY VARCHAR2 (60)
Refer to base table.
PERSON_REPORTED_TO VARCHAR2 (2000)
Refer to base table.
WITNESS_DETAILS VARCHAR2 (2000)
Refer to base table.
DESCRIPTION VARCHAR2 (2000)
Refer to base table.
INJURY_TYPE VARCHAR2 (30)
Refer to base table.
D_INJURY_TYPE VARCHAR2 (30)
Refer to base table.
DISEASE_TYPE VARCHAR2 (30)
Refer to base table.
D_DISEASE_TYPE VARCHAR2 (30)
Refer to base table.
HAZARD_TYPE VARCHAR2 (30)
Refer to base table.
D_HAZARD_TYPE VARCHAR2 (30)
Refer to base table.
BODY_PART VARCHAR2 (2000)
Refer to base table.
TREATMENT_RECEIVED_FLAG VARCHAR2 (1)
Refer to base table.
HOSPITAL_DETAILS VARCHAR2 (2000)
Refer to base table.
HOSPITAL_ADDRESS VARCHAR2 (240)
Refer to base table.
ACTIVITY_AT_TIME_OF_WORK VARCHAR2 (240)
Refer to base table.
OBJECTS_INVOLVED VARCHAR2 (240)
Refer to base table.
HOSPITALIZED_FLAG VARCHAR2 (30)
Refer to base table.
PRIVACY_ISSUE VARCHAR2 (30)
Refer to base table.
EMERGENCY_CODE VARCHAR2 (30)
Refer to base table.
DAYS_RESTRICTED_WORK NUMBER (10)
Refer to base table.
DAYS_AWAY_FROM_WORK NUMBER (10)
Refer to base table.
WORK_START_TIME DATE

Refer to base table.
REPORT_COMPLETED_BY VARCHAR2 (60)
Refer to base table.
REPORTING_PERSON_TITLE VARCHAR2 (30)
Refer to base table.
REPORTING_PERSON_PHONE VARCHAR2 (30)
Refer to base table.
DATE_OF_DEATH DATE

Refer to base table.
DOCTOR_NAME VARCHAR2 (60)
Refer to base table.
COMPENSATION_DATE DATE

Refer to base table.
COMPENSATION_CURRENCY VARCHAR2 (30)
Refer to base table.
COMPENSATION_AMOUNT NUMBER

Refer to base table.
REMEDIAL_HS_ACTION VARCHAR2 (2000)
Refer to base table.
NOTIFIED_HSREP_ID NUMBER (10)
Refer to base table.
D_NOTIFIED_HSREP VARCHAR2 (60)
Refer to base table.
NOTIFIED_HSREP_DATE DATE

Refer to base table.
NOTIFIED_REP_ID NUMBER (10)
Refer to base table.
D_NOTIFIED_REP VARCHAR2 (60)
Refer to base table.
NOTIFIED_REP_DATE DATE

Refer to base table.
NOTIFIED_REP_ORG_ID NUMBER (15)
Refer to base table.
D_NOTIFIED_REP_ORG VARCHAR2 (240)
Refer to base table.
RELATED_INCIDENT_ID NUMBER (10)
Refer to base table.
D_RELATED_INCIDENT VARCHAR2 (4000)
Refer to base table.
ABSENCE_EXISTS_FLAG VARCHAR2 (1)
Refer to base table.
OVER_TIME_FLAG VARCHAR2 (1)
Refer to base table.
INC_INFORMATION_CATEGORY VARCHAR2 (30)
Refer to base table.
INC_INFORMATION1 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION2 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION3 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION4 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION5 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION6 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION7 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION8 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION9 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION10 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION11 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION12 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION13 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION14 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION15 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION16 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION17 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION18 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION19 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION20 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION21 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION22 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION23 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION24 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION25 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION26 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION27 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION28 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION29 VARCHAR2 (150)
Refer to base table.
INC_INFORMATION30 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Refer to base table.
ATTRIBUTE1 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE2 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE3 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE4 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE5 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE6 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE7 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE8 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE9 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE10 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE11 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE12 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE13 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE14 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE15 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE16 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE17 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE18 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE19 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE20 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE21 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE22 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE23 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE24 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE25 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE26 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE27 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE28 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE29 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE30 VARCHAR2 (150)
Refer to base table.
LAST_UPDATE_DATE DATE

Refer to base table.
LAST_UPDATED_BY NUMBER (15)
Refer to base table.
LAST_UPDATE_LOGIN NUMBER (15)
Refer to base table.
CREATED_BY NUMBER (15)
Refer to base table.
CREATION_DATE DATE

Refer to base table.
OBJECT_VERSION_NUMBER NUMBER (9) Yes Refer to base table.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INCIDENT_ID
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      ASSIGNMENT_ID
,      D_JOB
,      INCIDENT_REFERENCE
,      INCIDENT_TYPE
,      D_INCIDENT_TYPE
,      INCIDENT_DATE
,      INCIDENT_TIME
,      ORG_NOTIFIED_DATE
,      LOCATION
,      AT_WORK_FLAG
,      D_AT_WORK_FLAG
,      REPORT_DATE
,      REPORT_TIME
,      REPORT_METHOD
,      D_REPORT_METHOD
,      PERSON_REPORTED_BY
,      D_PERSON_REPORTED_BY
,      PERSON_REPORTED_TO
,      WITNESS_DETAILS
,      DESCRIPTION
,      INJURY_TYPE
,      D_INJURY_TYPE
,      DISEASE_TYPE
,      D_DISEASE_TYPE
,      HAZARD_TYPE
,      D_HAZARD_TYPE
,      BODY_PART
,      TREATMENT_RECEIVED_FLAG
,      HOSPITAL_DETAILS
,      HOSPITAL_ADDRESS
,      ACTIVITY_AT_TIME_OF_WORK
,      OBJECTS_INVOLVED
,      HOSPITALIZED_FLAG
,      PRIVACY_ISSUE
,      EMERGENCY_CODE
,      DAYS_RESTRICTED_WORK
,      DAYS_AWAY_FROM_WORK
,      WORK_START_TIME
,      REPORT_COMPLETED_BY
,      REPORTING_PERSON_TITLE
,      REPORTING_PERSON_PHONE
,      DATE_OF_DEATH
,      DOCTOR_NAME
,      COMPENSATION_DATE
,      COMPENSATION_CURRENCY
,      COMPENSATION_AMOUNT
,      REMEDIAL_HS_ACTION
,      NOTIFIED_HSREP_ID
,      D_NOTIFIED_HSREP
,      NOTIFIED_HSREP_DATE
,      NOTIFIED_REP_ID
,      D_NOTIFIED_REP
,      NOTIFIED_REP_DATE
,      NOTIFIED_REP_ORG_ID
,      D_NOTIFIED_REP_ORG
,      RELATED_INCIDENT_ID
,      D_RELATED_INCIDENT
,      ABSENCE_EXISTS_FLAG
,      OVER_TIME_FLAG
,      INC_INFORMATION_CATEGORY
,      INC_INFORMATION1
,      INC_INFORMATION2
,      INC_INFORMATION3
,      INC_INFORMATION4
,      INC_INFORMATION5
,      INC_INFORMATION6
,      INC_INFORMATION7
,      INC_INFORMATION8
,      INC_INFORMATION9
,      INC_INFORMATION10
,      INC_INFORMATION11
,      INC_INFORMATION12
,      INC_INFORMATION13
,      INC_INFORMATION14
,      INC_INFORMATION15
,      INC_INFORMATION16
,      INC_INFORMATION17
,      INC_INFORMATION18
,      INC_INFORMATION19
,      INC_INFORMATION20
,      INC_INFORMATION21
,      INC_INFORMATION22
,      INC_INFORMATION23
,      INC_INFORMATION24
,      INC_INFORMATION25
,      INC_INFORMATION26
,      INC_INFORMATION27
,      INC_INFORMATION28
,      INC_INFORMATION29
,      INC_INFORMATION30
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
FROM APPS.PER_WORK_INCIDENTS_V;

Dependencies

[top of page]

APPS.PER_WORK_INCIDENTS_V references the following:

SchemaAPPS
SynonymFND_SESSIONS
SynonymHR_ALL_ORGANIZATION_UNITS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPER_ASSIGNMENTS_F
PL/SQL PackagePER_INC_BUS - show dependent code
ViewPER_PEOPLE_F
SynonymPER_WORK_INCIDENTS
APPS.PER_WORK_INCIDENTS_V is referenced by following:

SchemaPUBLIC
SynonymPER_WORK_INCIDENTS_V