View: HRI_CL_LOW_BAND_X_V

Product:	HRI - Human Resources Intelligence
Description:
Implementation/DBA Data:	APPS.HRI_CL_LOW_BAND_X_V

View Text

SELECT BNDS.BAND_MIN_TOTAL_YEARS || '-' || BNDS.BAND_MIN_TOTAL_MONTHS || '-' || BNDS.BAND_MIN_TOTAL_WEEKS || '-' || BNDS.BAND_MIN_TOTAL_DAYS || '-' || NVL(TO_CHAR(BNDS.BAND_MAX_TOTAL_YEARS)
, 'NA_EDW') || '-' || NVL(TO_CHAR(BNDS.BAND_MAX_TOTAL_MONTHS)
, 'NA_EDW') || '-' || NVL(TO_CHAR(BNDS.BAND_MAX_TOTAL_WEEKS)
, 'NA_EDW') || '-' || NVL(TO_CHAR(BNDS.BAND_MAX_TOTAL_DAYS)
, 'NA_EDW') ID
, RTRIM(DECODE(BNDS.BAND_MIN_TOTAL_YEARS + BNDS.BAND_MIN_TOTAL_MONTHS + BNDS.BAND_MIN_TOTAL_WEEKS + BNDS.BAND_MIN_TOTAL_DAYS
, 0
, '0 '
, NULL) || DECODE(BNDS.BAND_MIN_TOTAL_YEARS
, 0
, NULL
, 1
, BNDS.BAND_MIN_TOTAL_YEARS || ' ' || HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, 'Y') || ' '
, BNDS.BAND_MIN_TOTAL_YEARS || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'Y') || ' ') || DECODE(BNDS.BAND_MIN_TOTAL_MONTHS
, 0
, NULL
, 1
, BNDS.BAND_MIN_TOTAL_MONTHS || ' ' || HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, 'M') || ' '
, BNDS.BAND_MIN_TOTAL_MONTHS || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'M') || ' ') || DECODE(BNDS.BAND_MIN_TOTAL_WEEKS
, 0
, NULL
, 1
, BNDS.BAND_MIN_TOTAL_WEEKS || ' ' || HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, 'W') || ' '
, BNDS.BAND_MIN_TOTAL_WEEKS || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'W') || ' ') || DECODE(BNDS.BAND_MIN_TOTAL_DAYS
, 0
, NULL
, 1
, BNDS.BAND_MIN_TOTAL_DAYS || ' ' || HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, 'D') || ' '
, BNDS.BAND_MIN_TOTAL_DAYS || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'D') || ' ') || ' - ' || DECODE(BNDS.BAND_MAX_TOTAL_YEARS
, TO_NUMBER(NULL)
, NULL
, 0
, NULL
, 1
, BNDS.BAND_MAX_TOTAL_YEARS || ' ' || HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, 'Y') || ' '
, BNDS.BAND_MAX_TOTAL_YEARS || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'Y') || ' ') || DECODE(BNDS.BAND_MAX_TOTAL_MONTHS
, TO_NUMBER(NULL)
, NULL
, 0
, NULL
, 1
, BNDS.BAND_MAX_TOTAL_MONTHS || ' ' || HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, 'M') || ' '
, BNDS.BAND_MAX_TOTAL_MONTHS || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'M') || ' ') || DECODE(BNDS.BAND_MAX_TOTAL_WEEKS
, TO_NUMBER(NULL)
, NULL
, 0
, NULL
, 1
, BNDS.BAND_MAX_TOTAL_WEEKS || ' ' || HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, 'W') || ' '
, BNDS.BAND_MAX_TOTAL_WEEKS || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'W') || ' ') || DECODE(BNDS.BAND_MAX_TOTAL_DAYS
, TO_NUMBER(NULL)
, NULL
, 0
, NULL
, 1
, BNDS.BAND_MAX_TOTAL_DAYS || ' ' || HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, 'D')
, BNDS.BAND_MAX_TOTAL_DAYS || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'D'))) VALUE
, HR_GENERAL.START_OF_TIME DATE_FROM
, HR_GENERAL.END_OF_TIME DATE_TO
, BNDS.BAND_MAX_TOTAL_YEARS LOW_LENGTH_MAX_YEAR
, BNDS.BAND_MAX_TOTAL_MONTHS LOW_LENGTH_MAX_MONTH
, BNDS.BAND_MAX_TOTAL_WEEKS LOW_LENGTH_MAX_WEEK
, BNDS.BAND_MAX_TOTAL_DAYS LOW_LENGTH_MAX_DAY
, BNDS.BAND_MIN_TOTAL_YEARS LOW_LENGTH_MIN_YEAR
, BNDS.BAND_MIN_TOTAL_MONTHS LOW_LENGTH_MIN_MONTH
, BNDS.BAND_MIN_TOTAL_WEEKS LOW_LENGTH_MIN_WEEK
, BNDS.BAND_MIN_TOTAL_DAYS LOW_LENGTH_MIN_DAY
, FLOOR(BNDS.BAND_MIN_TOTAL_YEARS * 365.25 + BNDS.BAND_MIN_TOTAL_MONTHS * 365.25/12 + BNDS.BAND_MIN_TOTAL_WEEKS * 7 + BNDS.BAND_MIN_TOTAL_DAYS) ORDER_BY_COL
FROM HRI_SERVICE_BANDS BNDS
WHERE BAND_MIN_TOTAL_YEARS IS NOT NULL
AND BAND_MIN_TOTAL_MONTHS IS NOT NULL
AND BAND_MIN_TOTAL_WEEKS IS NOT NULL
AND BAND_MIN_TOTAL_DAYS IS NOT NULL WITH READ ONLY

Columns