VIEW: APPS.HRFV_OSHA_REPORTABLE_INCIDENTS

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,peo.full_name person_name ,ppa.comments comments ,ppa.date_from start_date ,ppa.date_to end_date ,pac.segment1 case_number ,pac.segment2 category_code ,hr_bis.bis_decode_lookup('US_OSHA_CATEGORY',pac.segment2) category_meaning ,pac.segment3 brief_description ,pac.segment4 incident_date ,pac.segment5 incident_address ,hr_bis.bis_decode_lookup('YES_NO',pac.segment6) employer_premises ,pac.segment7 activity ,pac.segment8 objects_substances_involved ,pac.segment9 body_parts_affected ,hr_bis.bis_decode_lookup('YES_NO',pac.segment10) termination_permanent_transfer ,TO_NUMBER(pac.segment11) days_away_from_work ,TO_NUMBER(pac.segment12) days_of_restricted_work ,pac.segment13 date_deceased ,pac.segment14 physician_name ,pac.segment15 physician_address ,pac.segment16 hospital_name ,pac.segment17 hospital_address ,peo.employee_number employee_number ,ppa.analysis_criteria_id analysis_criteria_id ,ppa.business_group_id business_group_id ,ppa.id_flex_num id_flex_num ,ppa.person_id person_id ,ppa.person_analysis_id person_analysis_id FROM per_person_analyses ppa ,per_analysis_criteria pac ,per_people_x peo ,hr_all_organization_units_tl bgrT WHERE ppa.analysis_criteria_id = pac.analysis_criteria_id AND ppa.id_flex_num = pac.id_flex_num AND ppa.person_id = peo.person_id AND pac.id_flex_num = 50131 AND ppa.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND ppa.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, ppa.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, PPA.COMMENTS COMMENTS
, PPA.DATE_FROM START_DATE
, PPA.DATE_TO END_DATE
, PAC.SEGMENT1 CASE_NUMBER
, PAC.SEGMENT2 CATEGORY_CODE
, HR_BIS.BIS_DECODE_LOOKUP('US_OSHA_CATEGORY'
, PAC.SEGMENT2) CATEGORY_MEANING
, PAC.SEGMENT3 BRIEF_DESCRIPTION
, PAC.SEGMENT4 INCIDENT_DATE
, PAC.SEGMENT5 INCIDENT_ADDRESS
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PAC.SEGMENT6) EMPLOYER_PREMISES
, PAC.SEGMENT7 ACTIVITY
, PAC.SEGMENT8 OBJECTS_SUBSTANCES_INVOLVED
, PAC.SEGMENT9 BODY_PARTS_AFFECTED
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PAC.SEGMENT10) TERMINATION_PERMANENT_TRANSFER
, TO_NUMBER(PAC.SEGMENT11) DAYS_AWAY_FROM_WORK
, TO_NUMBER(PAC.SEGMENT12) DAYS_OF_RESTRICTED_WORK
, PAC.SEGMENT13 DATE_DECEASED
, PAC.SEGMENT14 PHYSICIAN_NAME
, PAC.SEGMENT15 PHYSICIAN_ADDRESS
, PAC.SEGMENT16 HOSPITAL_NAME
, PAC.SEGMENT17 HOSPITAL_ADDRESS
, PEO.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PPA.ANALYSIS_CRITERIA_ID ANALYSIS_CRITERIA_ID
, PPA.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PPA.ID_FLEX_NUM ID_FLEX_NUM
, PPA.PERSON_ID PERSON_ID
, PPA.PERSON_ANALYSIS_ID PERSON_ANALYSIS_ID
FROM PER_PERSON_ANALYSES PPA
, PER_ANALYSIS_CRITERIA PAC
, PER_PEOPLE_X PEO
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE PPA.ANALYSIS_CRITERIA_ID = PAC.ANALYSIS_CRITERIA_ID
AND PPA.ID_FLEX_NUM = PAC.ID_FLEX_NUM
AND PPA.PERSON_ID = PEO.PERSON_ID
AND PAC.ID_FLEX_NUM = 50131
AND PPA.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND PPA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PPA.BUSINESS_GROUP_ID) WITH READ ONLY