VIEW: APPS.HRI_CL_AGE_BAND_V

Source

View Text - Preformatted

SELECT bds.band_min_value ID , RTRIM(DECODE(bds.band_min_value, 0,'0 ', NULL) || DECODE(bds.age_min_years, 0, NULL, 1, bds.age_min_years || ' ' || hr_bis.bis_decode_lookup('FREQUENCY','Y') || ' ', bds.age_min_years || ' ' || hr_bis.bis_decode_lookup('QUALIFYING_UNITS','Y') || ' ') || DECODE(bds.age_min_months, 0, NULL, 1, bds.age_min_months || ' ' || hr_bis.bis_decode_lookup('FREQUENCY','CM') || ' ', bds.age_min_months || ' ' || hr_bis.bis_decode_lookup('QUALIFYING_UNITS','M') || ' ') || ' - ' || DECODE(bds.age_max_years, TO_NUMBER(NULL),NULL, 0, NULL, 1, bds.age_max_years || ' ' || hr_bis.bis_decode_lookup('FREQUENCY','Y') || ' ', bds.age_max_years || ' ' || hr_general.decode_lookup('QUALIFYING_UNITS','Y') || ' ') || DECODE(bds.age_max_months, TO_NUMBER(NULL),NULL, 0, NULL, 1, bds.age_max_months || ' ' || hr_bis.bis_decode_lookup('FREQUENCY','CM') || ' ', bds.age_max_months || ' ' || hr_bis.bis_decode_lookup('QUALIFYING_UNITS','M') || ' ')) value , hr_general.start_of_time start_date , hr_general.end_of_time end_date /*Other Ids*/ , (bds.age_min_years * 12) + bds.age_min_months age_min , bds.age_min_months age_min_months , bds.age_min_years age_min_years , (bds.age_max_years * 12) + bds.age_max_months age_max , bds.age_max_months age_max_months , bds.age_max_years age_max_years , bds.last_update_date last_update_date FROM (SELECT tbd.band_min_year_comp age_min_years , tbd.band_min_month_comp age_min_months , tbd.band_max_year_comp age_max_years , tbd.band_max_month_comp age_max_months , tbd.band_min_value band_min_value , tbd.band_max_value band_max_value , tbd.last_update_date last_update_date FROM hri_time_bands tbd WHERE tbd.type = 'AGE' ) bds WITH READ ONLY

View Text - HTML Formatted

SELECT BDS.BAND_MIN_VALUE ID
, RTRIM(DECODE(BDS.BAND_MIN_VALUE
, 0
, '0 '
, NULL) || DECODE(BDS.AGE_MIN_YEARS
, 0
, NULL
, 1
, BDS.AGE_MIN_YEARS || ' ' || HR_BIS.BIS_DECODE_LOOKUP('FREQUENCY'
, 'Y') || ' '
, BDS.AGE_MIN_YEARS || ' ' || HR_BIS.BIS_DECODE_LOOKUP('QUALIFYING_UNITS'
, 'Y') || ' ') || DECODE(BDS.AGE_MIN_MONTHS
, 0
, NULL
, 1
, BDS.AGE_MIN_MONTHS || ' ' || HR_BIS.BIS_DECODE_LOOKUP('FREQUENCY'
, 'CM') || ' '
, BDS.AGE_MIN_MONTHS || ' ' || HR_BIS.BIS_DECODE_LOOKUP('QUALIFYING_UNITS'
, 'M') || ' ') || ' - ' || DECODE(BDS.AGE_MAX_YEARS
, TO_NUMBER(NULL)
, NULL
, 0
, NULL
, 1
, BDS.AGE_MAX_YEARS || ' ' || HR_BIS.BIS_DECODE_LOOKUP('FREQUENCY'
, 'Y') || ' '
, BDS.AGE_MAX_YEARS || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'Y') || ' ') || DECODE(BDS.AGE_MAX_MONTHS
, TO_NUMBER(NULL)
, NULL
, 0
, NULL
, 1
, BDS.AGE_MAX_MONTHS || ' ' || HR_BIS.BIS_DECODE_LOOKUP('FREQUENCY'
, 'CM') || ' '
, BDS.AGE_MAX_MONTHS || ' ' || HR_BIS.BIS_DECODE_LOOKUP('QUALIFYING_UNITS'
, 'M') || ' ')) VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE /*OTHER IDS*/
, (BDS.AGE_MIN_YEARS * 12) + BDS.AGE_MIN_MONTHS AGE_MIN
, BDS.AGE_MIN_MONTHS AGE_MIN_MONTHS
, BDS.AGE_MIN_YEARS AGE_MIN_YEARS
, (BDS.AGE_MAX_YEARS * 12) + BDS.AGE_MAX_MONTHS AGE_MAX
, BDS.AGE_MAX_MONTHS AGE_MAX_MONTHS
, BDS.AGE_MAX_YEARS AGE_MAX_YEARS
, BDS.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM (SELECT TBD.BAND_MIN_YEAR_COMP AGE_MIN_YEARS
, TBD.BAND_MIN_MONTH_COMP AGE_MIN_MONTHS
, TBD.BAND_MAX_YEAR_COMP AGE_MAX_YEARS
, TBD.BAND_MAX_MONTH_COMP AGE_MAX_MONTHS
, TBD.BAND_MIN_VALUE BAND_MIN_VALUE
, TBD.BAND_MAX_VALUE BAND_MAX_VALUE
, TBD.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM HRI_TIME_BANDS TBD
WHERE TBD.TYPE = 'AGE' ) BDS WITH READ ONLY