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: ViewPER.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:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
PL/SQL PackageHR_DE_ORG_INFO - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F
SynonymPER_WORK_INCIDENTS
APPS.HR_DE_WORK_INCIDENTS_REPORT is referenced by following:

SchemaAPPS
Package BodyHR_DE_WORK_INCIDENT_REPORT - show dependent code