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_POW_POWBAND_V

Source

View Text - Preformatted


SELECT pow.pow_band_sk_pk AS POW_POWBAND_PK, (CASE WHEN pow.band_sequence = 1 THEN bbct.range1_name WHEN pow.band_sequence = 2 THEN bbct.range2_name WHEN pow.band_sequence = 3 THEN bbct.range3_name WHEN pow.band_sequence = 4 THEN bbct.range4_name WHEN pow.band_sequence = 5 THEN bbct.range5_name WHEN pow.band_sequence = 6 THEN bbct.range6_name WHEN pow.band_sequence = 7 THEN bbct.range7_name WHEN pow.band_sequence = 8 THEN bbct.range8_name WHEN pow.band_sequence = 9 THEN bbct.range9_name ELSE bbct.range10_name END) AS POW_POWBAND_NAME, (CASE WHEN pow.band_sequence = 1 THEN bbct.range1_name WHEN pow.band_sequence = 2 THEN bbct.range2_name WHEN pow.band_sequence = 3 THEN bbct.range3_name WHEN pow.band_sequence = 4 THEN bbct.range4_name WHEN pow.band_sequence = 5 THEN bbct.range5_name WHEN pow.band_sequence = 6 THEN bbct.range6_name WHEN pow.band_sequence = 7 THEN bbct.range7_name WHEN pow.band_sequence = 8 THEN bbct.range8_name WHEN pow.band_sequence = 9 THEN bbct.range9_name ELSE bbct.range10_name END) ||'('||pow.wkth_wktyp_sk_fk||')' AS POW_POWBAND_NAME_UNQ, pow.band_sequence AS POW_ORDER_BY, pow.wkth_wktyp_sk_fk AS POW_WORKER_TYPE_FK, pow.set_uom AS POW_MEASURE_UNIT, pow.band_range_low AS POW_LOW_BAND_RANGE, pow.band_range_high AS POW_HIGH_BAND_RANGE, pow.band_sequence AS POW_BAND FROM hri_cs_pow_band_ct pow, bis_bucket_customizations_tl bbct WHERE pow.set_bucket_custom_id = bbct.id AND bbct.LANGUAGE = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT POW.POW_BAND_SK_PK AS POW_POWBAND_PK
, (CASE WHEN POW.BAND_SEQUENCE = 1 THEN BBCT.RANGE1_NAME WHEN POW.BAND_SEQUENCE = 2 THEN BBCT.RANGE2_NAME WHEN POW.BAND_SEQUENCE = 3 THEN BBCT.RANGE3_NAME WHEN POW.BAND_SEQUENCE = 4 THEN BBCT.RANGE4_NAME WHEN POW.BAND_SEQUENCE = 5 THEN BBCT.RANGE5_NAME WHEN POW.BAND_SEQUENCE = 6 THEN BBCT.RANGE6_NAME WHEN POW.BAND_SEQUENCE = 7 THEN BBCT.RANGE7_NAME WHEN POW.BAND_SEQUENCE = 8 THEN BBCT.RANGE8_NAME WHEN POW.BAND_SEQUENCE = 9 THEN BBCT.RANGE9_NAME ELSE BBCT.RANGE10_NAME END) AS POW_POWBAND_NAME
, (CASE WHEN POW.BAND_SEQUENCE = 1 THEN BBCT.RANGE1_NAME WHEN POW.BAND_SEQUENCE = 2 THEN BBCT.RANGE2_NAME WHEN POW.BAND_SEQUENCE = 3 THEN BBCT.RANGE3_NAME WHEN POW.BAND_SEQUENCE = 4 THEN BBCT.RANGE4_NAME WHEN POW.BAND_SEQUENCE = 5 THEN BBCT.RANGE5_NAME WHEN POW.BAND_SEQUENCE = 6 THEN BBCT.RANGE6_NAME WHEN POW.BAND_SEQUENCE = 7 THEN BBCT.RANGE7_NAME WHEN POW.BAND_SEQUENCE = 8 THEN BBCT.RANGE8_NAME WHEN POW.BAND_SEQUENCE = 9 THEN BBCT.RANGE9_NAME ELSE BBCT.RANGE10_NAME END) ||'('||POW.WKTH_WKTYP_SK_FK||')' AS POW_POWBAND_NAME_UNQ
, POW.BAND_SEQUENCE AS POW_ORDER_BY
, POW.WKTH_WKTYP_SK_FK AS POW_WORKER_TYPE_FK
, POW.SET_UOM AS POW_MEASURE_UNIT
, POW.BAND_RANGE_LOW AS POW_LOW_BAND_RANGE
, POW.BAND_RANGE_HIGH AS POW_HIGH_BAND_RANGE
, POW.BAND_SEQUENCE AS POW_BAND
FROM HRI_CS_POW_BAND_CT POW
, BIS_BUCKET_CUSTOMIZATIONS_TL BBCT
WHERE POW.SET_BUCKET_CUSTOM_ID = BBCT.ID
AND BBCT.LANGUAGE = USERENV('LANG') WITH READ ONLY