VIEW: APPS.HRI_CL_LOW_BAND_V

Source

View Text - Preformatted

SELECT tbd.band_min_value ID , RTRIM(DECODE(tbd.band_min_value, 0,'0 ', NULL) || DECODE(tbd.band_min_year_comp, 0, NULL, 1, tbd.band_min_year_comp || ' ' || hr_general.decode_lookup('FREQUENCY','Y') || ' ', tbd.band_min_year_comp || ' ' || hr_general.decode_lookup('QUALIFYING_UNITS','Y') || ' ') || DECODE(tbd.band_min_month_comp, 0, NULL, 1, tbd.band_min_month_comp || ' ' || hr_general.decode_lookup('FREQUENCY','M') || ' ', tbd.band_min_month_comp || ' ' || hr_general.decode_lookup('QUALIFYING_UNITS','M') || ' ') || DECODE(tbd.band_min_week_comp, 0, NULL, 1, tbd.band_min_week_comp || ' ' || hr_general.decode_lookup('FREQUENCY','W') || ' ', tbd.band_min_week_comp || ' ' || hr_general.decode_lookup('QUALIFYING_UNITS','W') || ' ') || DECODE(tbd.band_min_day_comp, 0, NULL, 1, tbd.band_min_day_comp || ' ' || hr_general.decode_lookup('FREQUENCY','D') || ' ', tbd.band_min_day_comp || ' ' || hr_general.decode_lookup('QUALIFYING_UNITS','D') || ' ') || ' - ' || DECODE(tbd.band_max_year_comp, TO_NUMBER(NULL),NULL, 0, NULL, 1, tbd.band_max_year_comp || ' ' || hr_general.decode_lookup('FREQUENCY','Y') || ' ', tbd.band_max_year_comp || ' ' || hr_general.decode_lookup('QUALIFYING_UNITS','Y') || ' ') || DECODE(tbd.band_max_month_comp, TO_NUMBER(NULL),NULL, 0, NULL, 1, tbd.band_max_month_comp || ' ' || hr_general.decode_lookup('FREQUENCY','M') || ' ', tbd.band_max_month_comp || ' ' || hr_general.decode_lookup('QUALIFYING_UNITS','M') || ' ') || DECODE(tbd.band_max_week_comp, TO_NUMBER(NULL),NULL, 0, NULL, 1, tbd.band_max_week_comp || ' ' || hr_general.decode_lookup('FREQUENCY','W') || ' ', tbd.band_max_week_comp || ' ' || hr_general.decode_lookup('QUALIFYING_UNITS','W') || ' ') || DECODE(tbd.band_max_day_comp, TO_NUMBER(NULL),NULL, 0, NULL, 1, tbd.band_max_day_comp || ' ' || hr_general.decode_lookup('FREQUENCY','D'), tbd.band_max_day_comp || ' ' || hr_general.decode_lookup('QUALIFYING_UNITS','D'))) value , hr_general.start_of_time start_date , hr_general.end_of_time end_date /*Parent Ids*/ /*Other Ids*/ , tbd.band_max_year_comp low_length_max_year , tbd.band_max_month_comp low_length_max_month , tbd.band_max_week_comp low_length_max_week , tbd.band_max_day_comp low_length_max_day , tbd.band_min_year_comp low_length_min_year , tbd.band_min_month_comp low_length_min_month , tbd.band_min_week_comp low_length_min_week , tbd.band_min_day_comp low_length_min_day , tbd.band_min_value band_min_value , tbd.band_max_value band_max_value FROM hri_time_bands tbd WHERE type = 'LOW' WITH READ ONLY

View Text - HTML Formatted

SELECT TBD.BAND_MIN_VALUE ID
, RTRIM(DECODE(TBD.BAND_MIN_VALUE
, 0
, '0 '
, NULL) || DECODE(TBD.BAND_MIN_YEAR_COMP
, 0
, NULL
, 1
, TBD.BAND_MIN_YEAR_COMP || ' ' || HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, 'Y') || ' '
, TBD.BAND_MIN_YEAR_COMP || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'Y') || ' ') || DECODE(TBD.BAND_MIN_MONTH_COMP
, 0
, NULL
, 1
, TBD.BAND_MIN_MONTH_COMP || ' ' || HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, 'M') || ' '
, TBD.BAND_MIN_MONTH_COMP || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'M') || ' ') || DECODE(TBD.BAND_MIN_WEEK_COMP
, 0
, NULL
, 1
, TBD.BAND_MIN_WEEK_COMP || ' ' || HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, 'W') || ' '
, TBD.BAND_MIN_WEEK_COMP || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'W') || ' ') || DECODE(TBD.BAND_MIN_DAY_COMP
, 0
, NULL
, 1
, TBD.BAND_MIN_DAY_COMP || ' ' || HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, 'D') || ' '
, TBD.BAND_MIN_DAY_COMP || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'D') || ' ') || ' - ' || DECODE(TBD.BAND_MAX_YEAR_COMP
, TO_NUMBER(NULL)
, NULL
, 0
, NULL
, 1
, TBD.BAND_MAX_YEAR_COMP || ' ' || HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, 'Y') || ' '
, TBD.BAND_MAX_YEAR_COMP || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'Y') || ' ') || DECODE(TBD.BAND_MAX_MONTH_COMP
, TO_NUMBER(NULL)
, NULL
, 0
, NULL
, 1
, TBD.BAND_MAX_MONTH_COMP || ' ' || HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, 'M') || ' '
, TBD.BAND_MAX_MONTH_COMP || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'M') || ' ') || DECODE(TBD.BAND_MAX_WEEK_COMP
, TO_NUMBER(NULL)
, NULL
, 0
, NULL
, 1
, TBD.BAND_MAX_WEEK_COMP || ' ' || HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, 'W') || ' '
, TBD.BAND_MAX_WEEK_COMP || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'W') || ' ') || DECODE(TBD.BAND_MAX_DAY_COMP
, TO_NUMBER(NULL)
, NULL
, 0
, NULL
, 1
, TBD.BAND_MAX_DAY_COMP || ' ' || HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, 'D')
, TBD.BAND_MAX_DAY_COMP || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'D'))) VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE /*PARENT IDS*/ /*OTHER IDS*/
, TBD.BAND_MAX_YEAR_COMP LOW_LENGTH_MAX_YEAR
, TBD.BAND_MAX_MONTH_COMP LOW_LENGTH_MAX_MONTH
, TBD.BAND_MAX_WEEK_COMP LOW_LENGTH_MAX_WEEK
, TBD.BAND_MAX_DAY_COMP LOW_LENGTH_MAX_DAY
, TBD.BAND_MIN_YEAR_COMP LOW_LENGTH_MIN_YEAR
, TBD.BAND_MIN_MONTH_COMP LOW_LENGTH_MIN_MONTH
, TBD.BAND_MIN_WEEK_COMP LOW_LENGTH_MIN_WEEK
, TBD.BAND_MIN_DAY_COMP LOW_LENGTH_MIN_DAY
, TBD.BAND_MIN_VALUE BAND_MIN_VALUE
, TBD.BAND_MAX_VALUE BAND_MAX_VALUE
FROM HRI_TIME_BANDS TBD
WHERE TYPE = 'LOW' WITH READ ONLY