[Home] [Help] [Dependency Information]

VIEW: APPS.PER_WORK_INCIDENTS1_DFV

Object Details

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      CONTEXT_VALUE
,      NUMBER_OF_CHILDREN
,      JOB_TYPE
,      JOB_START_DATE
,      ORGANIZATION
,      LOANED_EMPLOYEE
,      UNDERAGE_LEGALLY_INCAPABLE
,      SUPERVISING_EMPLOYEE
,      RELATIONSHIP_TO_OWNER
,      DURATION_OF_PAYMENT
,      WORK_STOPPING_DATE
,      WORK_RESUMPTION_DATE
,      ADDR_OF_1ST_CONTACT_DOCTOR
,      ADDR_OF_CURRENT_DOCTOR
,      START_OF_WORK_TIME
,      END_OF_WORK_TIME
,      MAKE_OF_MACHINE
,      TYPE_OF_MACHINE
,      DATE_WHEN_MACHINE_BUILT
,      TECHNICAL_SAFETY_ADVICE_TAKEN
,      PERSONAL_SAFETY_ADVICE_TAKEN
,      DK_COMP_ACT
,      DK_MARRIED_EMPLOYER
,      DK_RELATIVE_EMPLOYER
,      DK_HIRED_INFORMER
,      DK_PLACE_ACCIDENT
,      DK_KIND_WORK
,      DK_GLASS_ACCIDENT
,      DK_PURPOSE_GLASS
,      DK_PLACE_GLASS
,      DK_GLASS_BROKEN
,      DK_HAPPEN_GLASS
,      DK_PURCHASE_GLASS
,      DK_PRICE_GLASS
,      DK_OPTICIAN_NAME
,      CLASSIFICATION_FOR_PAYROLL
,      PAYROLL_CLASSIFICATION_DATE
,      RECLASSIFICATION_DATE
,      RECLASSIFICATION_REASON
,      INTERNAL_WITNESS_NAME
,      POLICE_REPORTING
,      THIRD_PARTY_NAME
,      THIRD_PARTY_ADDRESS
,      THIRD_PARTY_INSURANCE_PROVIDER
,      OTHER_PERSONS_INJURED
,      NATURE_OF_INJURY
,      DISABLEMENT_LEVEL
,      LENGTH_OF_TREATMENT
,      UNITS
,      TYPE_OF_RISK
,      DATE_REPORTED_TO_SSO
,      DATE_REPORTED_TO_LIA
,      EQUIPMENT_USED
,      EQUIPMENT_NAME
,      TYPE
,      TRADEMARK
,      YEAR
,      PRODUCER
,      ALCOHOLIC_OR_NARCOTIC
,      LEVEL_OF_INTOXICATION
,      INVESTIGATION_COMMITTEE
,      ORGANIZATION_NAME
,      SAFETY_RULES_ENFORCER
,      SECONDARY_REASON
,      DATE_OF_ORGANIZATION_WAGE_STOP
,      PATIENT_NUMBER
,      ADMISSION_DATE
,      HOSPITALISED_FROM
,      HOSPITALISED_TO
,      REST_AT_HOME_FROM
,      REST_AT_HOME_TO
,      NUMBER_OF_EXTERNAL_VISITS
,      DAYS_VIOLATED_THE_MEDICATION
,      TYPE_OF_VIOLATION
,      DAYS_REQUIRED_TO_BE_ESCORTED
,      DATE_COMMENCED_THE_WORK
,      EMPLOYMENT_CATEGORY
,      COVERAGE_COMMENCEMENT_DATE
,      COVERAGE_EXPIRY_DATE
,      PERSONNEL_CATEGORY
,      MAIN_DUTIES
,      VESSEL_REGISTRATION_NUMBER
,      MAIN_ACTIVITY
,      ACCIDENT_SITE_WORKPLACE
,      ACCIDENT_SITE_EMPLOYER
,      EQUIPMENT_MATERIALS
,      MANUFACTURING_DETAILS
,      PURPOSE_FOR_USING_CHEMICAL
,      CHEMICAL_OR_EQUIPMENT_NAME
,      CIRCUMSTANCES_AND_CAUSE
,      TYPE_OF_INJURY_OR_ILLNESS
,      AFFECTED_AREAS_OF_BODY
,      ESTIMATED_PERIOD_OF_ABSENCE
,      NUMBER_OF_SICK_PAY_DAYS
,      SAFETY_DELEGATE_NOTIFIED_
,      REASON_FOR_NOT_NOTIFYING
,      OSHA_RECORDABLE
,      CONCATENATED_SEGMENTS
FROM APPS.PER_WORK_INCIDENTS1_DFV;

Dependencies

[top of page]

APPS

FND_NUMBER - show dependent code

PER_WORK_INCIDENTS

APPS.PER_WORK_INCIDENTS1_DFV is not referenced by any database object