eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.HR_DE_WORK_INCIDENTS_REPORT

Object Details

Object Name:	HR_DE_WORK_INCIDENTS_REPORT
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HR_DE_WORK_INCIDENTS_REPORT
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View for German Work Incidents reporting based on PER_WORK_INCIDENTS and server side functions

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ASSIGNMENT_ID	NUMBER	(10)	Yes	Refer to Base table
INCIDENT_ID	NUMBER	(10)	Yes	Refer to Base table
PARTY_ID	NUMBER	(15)		Derived value from per_all_people_f
PERSON_ID	NUMBER	(10)	Yes	Derived value from per_all_people_f
LAST_NAME	VARCHAR2	(150)	Yes	Derived value from per_all_people_f
FIRST_NAME	VARCHAR2	(150)		Derived value from per_all_people_f
DATE_OF_BIRTH	DATE			Derived value from per_all_people_f
SOCIAL_INSURANCE_NUMBER	VARCHAR2	(30)		Derived value from per_all_people_f
GENDER	VARCHAR2	(30)		Derived value from per_all_people_f
MARITAL_STATUS	VARCHAR2	(30)		Derived value from per_all_people_f
NATIONALITY	VARCHAR2	(30)		Derived value from per_all_people_f
PRIMARY_FLAG	VARCHAR2	(30)	Yes	Derived value from per_all_assignments_f
ASSGT_ORG_ID	NUMBER	(15)	Yes	Derived value from per_all_assignments_f
ASSGT_ORG_NAME	VARCHAR2	(240)	Yes	Derived value from per_all_assignments_f
SUP_OFF_ID	VARCHAR2	(4000)		Derived value from server side function
SUP_OFF_NAME	VARCHAR2	(4000)		Derived value from server side function
LIAB_PROV_ID	VARCHAR2	(4000)		Derived value from server side function
LIAB_PROV_NAME	VARCHAR2	(4000)		Derived value from server side function
MEMBERSHIP_NO	VARCHAR2	(4000)		Derived value from server side function
LOC_ID_OF_LIAB_PROV	VARCHAR2	(15)		Derived value from server side function
ADDRESS_LINE_1	VARCHAR2	(4000)		Derived value from server side function
ADDRESS_LINE_2	VARCHAR2	(4000)		Derived value from server side function
ADDRESS_LINE_3	VARCHAR2	(4000)		Derived value from server side function
TOWN_OR_CITY	VARCHAR2	(4000)		Derived value from server side function
COUNTRY	VARCHAR2	(4000)		Derived value from server side function
POSTAL_CODE	VARCHAR2	(4000)		Derived value from server side function
BETRIEBSNUMBER	VARCHAR2	(30)		Derived value from server side function
BODY_PART	VARCHAR2	(2000)		Refer to base table
INJURY_TYPE	VARCHAR2	(30)		Refer to base table
DOCTOR_NAME	VARCHAR2	(60)		Refer to base table
INCIDENT_TYPE	VARCHAR2	(30)	Yes	Refer to base table
D_INCIDENT_TYPE	VARCHAR2	(4000)		Derived lookup value for display
INCIDENT_REFERENCE	VARCHAR2	(30)	Yes	Refer to base table
HOSPITAL_DETAILS	VARCHAR2	(2000)		Refer to base table
INCIDENT_DATE	DATE		Yes	Refer to base table
INCIDENT_TIME	VARCHAR2	(5)		Refer to base table
LOCATION_OF_INCIDENT	VARCHAR2	(30)		Refer to base table
REMEDIAL_HS_ACTION	VARCHAR2	(2000)		Refer to base table
WITNESS_DETAILS	VARCHAR2	(2000)		Refer to base table
DESCRIPTION	VARCHAR2	(2000)		Refer to base table
NO_OF_CHILDREN	VARCHAR2	(150)		Refer to base table
JOB_TYPE	VARCHAR2	(150)		Refer to base table
JOB_START_DATE	VARCHAR2	(150)		Refer to base table
PART_OF_COMPANY	VARCHAR2	(150)		Refer to base table
LOANED_EMPLOYEE	VARCHAR2	(150)		Refer to base table
D_LOANED_EMP	VARCHAR2	(4000)		Derived lookup value for display
UNDERAGE_OR_LEGALLY_INCAPABLE	VARCHAR2	(150)		Refer to base table
D_UNDERAGE	VARCHAR2	(4000)		Derived lookup value for display
SUPERVISING_EMPLOYEE	VARCHAR2	(150)		Refer to base table
RELATIONSHIP_TO_OWNER	VARCHAR2	(150)		Refer to base table
D_RELATION	VARCHAR2	(4000)		Derived lookup value for display
DUR_OF_PAYMENT_ENT	VARCHAR2	(150)		Refer to base table
DATE_OF_STOPPING_WORK	VARCHAR2	(150)		Refer to base table
DATE_OF_RESUMING_WORK	VARCHAR2	(150)		Refer to base table
ADDR_OF_DOC_FIRST_CON	VARCHAR2	(150)		Refer to base table
INF_13	VARCHAR2	(150)		Refer to base table
ADDR_OF_CURR_DOC	VARCHAR2	(150)		Refer to base table
START_OF_WORK_TIME	VARCHAR2	(150)		Refer to base table
END_OF_WORK_TIME	VARCHAR2	(150)		Refer to base table
MAKE_OF_MACHINE	VARCHAR2	(150)		Refer to base table
TYPE_OF_MACHINE	VARCHAR2	(150)		Refer to base table
DATE_OF_MACHINE_BUILD	VARCHAR2	(150)		Refer to base table
TECHNICAL_SAFETY_ADV	VARCHAR2	(150)		Refer to base table
PERSONAL_SAFETY_ADV	VARCHAR2	(150)		Refer to base table
INF_22	VARCHAR2	(150)		Refer to base table
INF_23	VARCHAR2	(150)		Refer to base table
INF_24	VARCHAR2	(150)		Refer to base table
INF_25	VARCHAR2	(150)		Refer to base table
INF_26	VARCHAR2	(150)		Refer to base table
INF_27	VARCHAR2	(150)		Refer to base table
INF_28	VARCHAR2	(150)		Refer to base table
INF_29	VARCHAR2	(150)		Refer to base table
INF_30	VARCHAR2	(150)		Refer to base table

Query Text

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


SELECT ASSIGNMENT_ID
,      INCIDENT_ID
,      PARTY_ID
,      PERSON_ID
,      LAST_NAME
,      FIRST_NAME
,      DATE_OF_BIRTH
,      SOCIAL_INSURANCE_NUMBER
,      GENDER
,      MARITAL_STATUS
,      NATIONALITY
,      PRIMARY_FLAG
,      ASSGT_ORG_ID
,      ASSGT_ORG_NAME
,      SUP_OFF_ID
,      SUP_OFF_NAME
,      LIAB_PROV_ID
,      LIAB_PROV_NAME
,      MEMBERSHIP_NO
,      LOC_ID_OF_LIAB_PROV
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      TOWN_OR_CITY
,      COUNTRY
,      POSTAL_CODE
,      BETRIEBSNUMBER
,      BODY_PART
,      INJURY_TYPE
,      DOCTOR_NAME
,      INCIDENT_TYPE
,      D_INCIDENT_TYPE
,      INCIDENT_REFERENCE
,      HOSPITAL_DETAILS
,      INCIDENT_DATE
,      INCIDENT_TIME
,      LOCATION_OF_INCIDENT
,      REMEDIAL_HS_ACTION
,      WITNESS_DETAILS
,      DESCRIPTION
,      NO_OF_CHILDREN
,      JOB_TYPE
,      JOB_START_DATE
,      PART_OF_COMPANY
,      LOANED_EMPLOYEE
,      D_LOANED_EMP
,      UNDERAGE_OR_LEGALLY_INCAPABLE
,      D_UNDERAGE
,      SUPERVISING_EMPLOYEE
,      RELATIONSHIP_TO_OWNER
,      D_RELATION
,      DUR_OF_PAYMENT_ENT
,      DATE_OF_STOPPING_WORK
,      DATE_OF_RESUMING_WORK
,      ADDR_OF_DOC_FIRST_CON
,      INF_13
,      ADDR_OF_CURR_DOC
,      START_OF_WORK_TIME
,      END_OF_WORK_TIME
,      MAKE_OF_MACHINE
,      TYPE_OF_MACHINE
,      DATE_OF_MACHINE_BUILD
,      TECHNICAL_SAFETY_ADV
,      PERSONAL_SAFETY_ADV
,      INF_22
,      INF_23
,      INF_24
,      INF_25
,      INF_26
,      INF_27
,      INF_28
,      INF_29
,      INF_30
FROM APPS.HR_DE_WORK_INCIDENTS_REPORT;

Dependencies

[top of page]

APPS.HR_DE_WORK_INCIDENTS_REPORT references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; HR_DE_ORG_INFO - show dependent code; HR_GENERAL - show dependent code; HR_LOCATIONS_ALL; PER_ALL_ASSIGNMENTS_F; PER_ALL_PEOPLE_F; PER_WORK_INCIDENTS

APPS.HR_DE_WORK_INCIDENTS_REPORT is referenced by following:

APPS: HR_DE_WORK_INCIDENT_REPORT - show dependent code
PUBLIC: HR_DE_WORK_INCIDENTS_REPORT