VIEW: APPS.HRI_DBI_CL_POW_PLCMNT_BAND_V

Source

View Text - Preformatted

SELECT pow.band_sequence id ,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 value ,pow.band_sequence order_by ,hr_general.start_of_time start_date ,hr_general.end_of_time end_date ,pow.pow_band_sk_pk pow_band_sk_pk ,pow.set_uom uom ,pow.band_range_low range_low ,pow.band_range_high range_high 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') AND pow.wkth_wktyp_sk_fk = 'CWK' WITH READ ONLY

View Text - HTML Formatted

SELECT POW.BAND_SEQUENCE ID
, 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 VALUE
, POW.BAND_SEQUENCE ORDER_BY
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, POW.POW_BAND_SK_PK POW_BAND_SK_PK
, POW.SET_UOM UOM
, POW.BAND_RANGE_LOW RANGE_LOW
, POW.BAND_RANGE_HIGH RANGE_HIGH
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')
AND POW.WKTH_WKTYP_SK_FK = 'CWK' WITH READ ONLY