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.

VIEW: APPS.HRFV_ADA_DIS_ACCOMMODATIONS

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 description ,pac.segment2 date_requested ,hr_bis.bis_decode_lookup('US_ADA_STATUSES',pac.segment3) status ,pac.segment4 confirmed_by ,pac.segment5 date_confirmed ,pac.segment6 date_provided ,pac.segment7 cost ,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 hr_all_organization_units_tl bgrt ,per_person_analyses ppa ,per_analysis_criteria pac ,per_people_x peo 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 = 50130 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 DESCRIPTION
, PAC.SEGMENT2 DATE_REQUESTED
, HR_BIS.BIS_DECODE_LOOKUP('US_ADA_STATUSES'
, PAC.SEGMENT3) STATUS
, PAC.SEGMENT4 CONFIRMED_BY
, PAC.SEGMENT5 DATE_CONFIRMED
, PAC.SEGMENT6 DATE_PROVIDED
, PAC.SEGMENT7 COST
, 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 HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_PERSON_ANALYSES PPA
, PER_ANALYSIS_CRITERIA PAC
, PER_PEOPLE_X PEO
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 = 50130
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