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.HRI_CL_PRFMNC_RTNG_X_V

Source

View Text - Preformatted


SELECT 3 ID ,bbT.range3_name VALUE ,hr_general.start_of_time START_DATE ,hr_general.end_of_time END_DATE ,bb.range3_low RANGE_LOW ,bb.range3_high RANGE_HIGH ,1 ORDER_BY ,bbT.range3_name SHORT_NAME ,bbT.range3_name LONG_NAME ,b.uom UOM FROM bis_bucket_customizations bb, bis_bucket_customizations_tl bbT, bis_bucket b WHERE 1=1 AND b.short_name = 'HRI_DBI_PERF_BAND_OVERALL' AND b.bucket_id = bb.bucket_id AND bbT.id = bb.id AND bbT.range3_name is not null AND bbT.language = userenv('LANG') UNION ALL SELECT 2 ID ,bbT.range2_name VALUE ,hr_general.start_of_time START_DATE ,hr_general.end_of_time END_DATE ,bb.range2_low RANGE_LOW ,bb.range2_high RANGE_HIGH ,2 ORDER_BY ,bbT.range2_name SHORT_NAME ,bbT.range2_name LONG_NAME ,b.uom UOM FROM bis_bucket_customizations bb, bis_bucket_customizations_tl bbT, bis_bucket b WHERE 1=1 AND b.short_name = 'HRI_DBI_PERF_BAND_OVERALL' AND b.bucket_id = bb.bucket_id AND bbT.id = bb.id AND bbT.range2_name is not null AND bbT.language = userenv('LANG') UNION ALL SELECT 1 ID ,bbT.range1_name VALUE ,hr_general.start_of_time START_DATE ,hr_general.end_of_time END_DATE ,bb.range1_low RANGE_LOW ,bb.range1_high RANGE_HIGH ,3 ORDER_BY ,bbT.range1_name SHORT_NAME ,bbT.range1_name LONG_NAME ,b.uom UOM FROM bis_bucket_customizations bb, bis_bucket_customizations_tl bbT, bis_bucket b WHERE 1=1 AND b.short_name = 'HRI_DBI_PERF_BAND_OVERALL' AND b.bucket_id = bb.bucket_id AND bbT.id = bb.id AND bbT.range1_name is not null AND bbT.language = userenv('LANG') UNION ALL SELECT hri_bpl_dimension_utilities.get_not_rated_id ID ,hri_oltp_view_message.get_notrated_msg VALUE ,hr_general.start_of_time START_DATE ,hr_general.end_of_time END_DATE ,NULL RANGE_LOW ,NULL RANGE_HIGH ,4 ORDER_BY ,hri_oltp_view_message.get_notrated_msg SHORT_NAME ,hri_oltp_view_message.get_notrated_msg LONG_NAME ,NULL UOM FROM hri_unassigned

View Text - HTML Formatted

SELECT 3 ID
, BBT.RANGE3_NAME VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, BB.RANGE3_LOW RANGE_LOW
, BB.RANGE3_HIGH RANGE_HIGH
, 1 ORDER_BY
, BBT.RANGE3_NAME SHORT_NAME
, BBT.RANGE3_NAME LONG_NAME
, B.UOM UOM
FROM BIS_BUCKET_CUSTOMIZATIONS BB
, BIS_BUCKET_CUSTOMIZATIONS_TL BBT
, BIS_BUCKET B
WHERE 1=1
AND B.SHORT_NAME = 'HRI_DBI_PERF_BAND_OVERALL'
AND B.BUCKET_ID = BB.BUCKET_ID
AND BBT.ID = BB.ID
AND BBT.RANGE3_NAME IS NOT NULL
AND BBT.LANGUAGE = USERENV('LANG') UNION ALL SELECT 2 ID
, BBT.RANGE2_NAME VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, BB.RANGE2_LOW RANGE_LOW
, BB.RANGE2_HIGH RANGE_HIGH
, 2 ORDER_BY
, BBT.RANGE2_NAME SHORT_NAME
, BBT.RANGE2_NAME LONG_NAME
, B.UOM UOM
FROM BIS_BUCKET_CUSTOMIZATIONS BB
, BIS_BUCKET_CUSTOMIZATIONS_TL BBT
, BIS_BUCKET B
WHERE 1=1
AND B.SHORT_NAME = 'HRI_DBI_PERF_BAND_OVERALL'
AND B.BUCKET_ID = BB.BUCKET_ID
AND BBT.ID = BB.ID
AND BBT.RANGE2_NAME IS NOT NULL
AND BBT.LANGUAGE = USERENV('LANG') UNION ALL SELECT 1 ID
, BBT.RANGE1_NAME VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, BB.RANGE1_LOW RANGE_LOW
, BB.RANGE1_HIGH RANGE_HIGH
, 3 ORDER_BY
, BBT.RANGE1_NAME SHORT_NAME
, BBT.RANGE1_NAME LONG_NAME
, B.UOM UOM
FROM BIS_BUCKET_CUSTOMIZATIONS BB
, BIS_BUCKET_CUSTOMIZATIONS_TL BBT
, BIS_BUCKET B
WHERE 1=1
AND B.SHORT_NAME = 'HRI_DBI_PERF_BAND_OVERALL'
AND B.BUCKET_ID = BB.BUCKET_ID
AND BBT.ID = BB.ID
AND BBT.RANGE1_NAME IS NOT NULL
AND BBT.LANGUAGE = USERENV('LANG') UNION ALL SELECT HRI_BPL_DIMENSION_UTILITIES.GET_NOT_RATED_ID ID
, HRI_OLTP_VIEW_MESSAGE.GET_NOTRATED_MSG VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, NULL RANGE_LOW
, NULL RANGE_HIGH
, 4 ORDER_BY
, HRI_OLTP_VIEW_MESSAGE.GET_NOTRATED_MSG SHORT_NAME
, HRI_OLTP_VIEW_MESSAGE.GET_NOTRATED_MSG LONG_NAME
, NULL UOM
FROM HRI_UNASSIGNED