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_OBI_CL_PRFM_PERFBAND_V

Source

View Text - Preformatted


SELECT 3 pfbd_perfband_pk, bbt.range3_name pfbd_perfband_name, bbt.range3_name pfbd_perfband_name_unq, 1 pfbd_order_by, b.uom pfbd_measure_unit, bb.range3_low pfbd_low_band_range, bb.range3_high pfbd_high_band_range, bbt.range3_name pfbd_perfband_name_shrt, bbt.range3_name pfbd_perfband_name_long 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 pfbd_perfband_pk, bbt.range2_name pfbd_perfband_name, bbt.range2_name pfbd_perfband_name_unq, 2 pfbd_order_by, b.uom pfbd_measure_unit, bb.range2_low pfbd_low_band_range, bb.range2_high pfbd_high_band_range, bbt.range2_name pfbd_perfband_name_shrt, bbt.range2_name pfbd_perfband_name_long 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 pfbd_perfband_pk, bbt.range1_name pfbd_perfband_name, bbt.range1_name pfbd_perfband_name_unq, 3 pfbd_order_by, b.uom pfbd_measure_unit, bb.range1_low pfbd_low_band_range, bb.range1_high pfbd_high_band_range, bbt.range1_name pfbd_perfband_name_shrt, bbt.range1_name pfbd_perfband_name_long 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 pfbd_perfband_pk, hri_oltp_view_message.get_notrated_msg pfbd_perfband_name, hri_oltp_view_message.get_notrated_msg pfbd_perfband_name_unq, 4 pfbd_order_by, NULL pfbd_measure_unit, NULL pfbd_low_band_range, NULL pfbd_high_band_range, hri_oltp_view_message.get_notrated_msg pfbd_perfband_name_shrt, hri_oltp_view_message.get_notrated_msg pfbd_perfband_name_long FROM hri_unassigned WITH READ ONLY

View Text - HTML Formatted

SELECT 3 PFBD_PERFBAND_PK
, BBT.RANGE3_NAME PFBD_PERFBAND_NAME
, BBT.RANGE3_NAME PFBD_PERFBAND_NAME_UNQ
, 1 PFBD_ORDER_BY
, B.UOM PFBD_MEASURE_UNIT
, BB.RANGE3_LOW PFBD_LOW_BAND_RANGE
, BB.RANGE3_HIGH PFBD_HIGH_BAND_RANGE
, BBT.RANGE3_NAME PFBD_PERFBAND_NAME_SHRT
, BBT.RANGE3_NAME PFBD_PERFBAND_NAME_LONG
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 PFBD_PERFBAND_PK
, BBT.RANGE2_NAME PFBD_PERFBAND_NAME
, BBT.RANGE2_NAME PFBD_PERFBAND_NAME_UNQ
, 2 PFBD_ORDER_BY
, B.UOM PFBD_MEASURE_UNIT
, BB.RANGE2_LOW PFBD_LOW_BAND_RANGE
, BB.RANGE2_HIGH PFBD_HIGH_BAND_RANGE
, BBT.RANGE2_NAME PFBD_PERFBAND_NAME_SHRT
, BBT.RANGE2_NAME PFBD_PERFBAND_NAME_LONG
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 PFBD_PERFBAND_PK
, BBT.RANGE1_NAME PFBD_PERFBAND_NAME
, BBT.RANGE1_NAME PFBD_PERFBAND_NAME_UNQ
, 3 PFBD_ORDER_BY
, B.UOM PFBD_MEASURE_UNIT
, BB.RANGE1_LOW PFBD_LOW_BAND_RANGE
, BB.RANGE1_HIGH PFBD_HIGH_BAND_RANGE
, BBT.RANGE1_NAME PFBD_PERFBAND_NAME_SHRT
, BBT.RANGE1_NAME PFBD_PERFBAND_NAME_LONG
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 PFBD_PERFBAND_PK
, HRI_OLTP_VIEW_MESSAGE.GET_NOTRATED_MSG PFBD_PERFBAND_NAME
, HRI_OLTP_VIEW_MESSAGE.GET_NOTRATED_MSG PFBD_PERFBAND_NAME_UNQ
, 4 PFBD_ORDER_BY
, NULL PFBD_MEASURE_UNIT
, NULL PFBD_LOW_BAND_RANGE
, NULL PFBD_HIGH_BAND_RANGE
, HRI_OLTP_VIEW_MESSAGE.GET_NOTRATED_MSG PFBD_PERFBAND_NAME_SHRT
, HRI_OLTP_VIEW_MESSAGE.GET_NOTRATED_MSG PFBD_PERFBAND_NAME_LONG
FROM HRI_UNASSIGNED WITH READ ONLY