VIEW: APPS.GHR_BREAKDOWN_V

Source

View Text - Preformatted

SELECT BREAKDOWN_CRITERIA_ID , FOR_CLAUSE , WITHIN_CLAUSE , BY_CLAUSE , LINE, COUNT(DECODE(LINE,'#',1,NULL)) TOTAL_ALL, COUNT(DECODE(RSLT.SEX,'F',1,NULL)) / DECODE(LINE,'#',1,COUNT(*) / 100) TOTAL_WOMEN , COUNT( DECODE(RSLT.SEX, 'M', 1, NULL)) / DECODE( LINE, '#', 1, COUNT(*) / 100 ) TOTAL_MEN , COUNT(DECODE(RSLT.SEX, 'F', DECODE(RSLT.ETHNIC_ORIGIN, 'E', 1, NULL), NULL)) / DECODE(LINE, '#', 1, COUNT(*) / 100) WHITE_WOMEN , COUNT(DECODE(RSLT.SEX, 'M', DECODE(RSLT.ETHNIC_ORIGIN, 'E', 1, NULL), NULL)) / DECODE(LINE, '#', 1, COUNT(*) / 100) WHITE_MEN , COUNT(DECODE(RSLT.SEX, 'F', DECODE(RSLT.ETHNIC_ORIGIN, 'C', 1, NULL), NULL)) / DECODE(LINE, '#', 1, COUNT(*) / 100) BLACK_WOMEN , COUNT(DECODE(RSLT.SEX, 'M', DECODE(RSLT.ETHNIC_ORIGIN, 'C', 1, NULL), NULL)) / DECODE(LINE, '#', 1, COUNT(*) / 100) BLACK_MEN , COUNT(DECODE(RSLT.SEX, 'F', DECODE(RSLT.ETHNIC_ORIGIN, 'D', 1, NULL), NULL)) / DECODE(LINE, '#', 1, COUNT(*) / 100) HISPANIC_WOMEN , COUNT(DECODE(RSLT.SEX, 'M', DECODE(RSLT.ETHNIC_ORIGIN, 'D', 1, NULL), NULL)) / DECODE(LINE, '#', 1, COUNT(*) / 100) HISPANIC_MEN , COUNT(DECODE(RSLT.SEX, 'F', DECODE(INSTR('BFGHIJKLMNPQ', NVL(RSLT.ETHNIC_ORIGIN, '*')), 0, NULL, 1), NULL)) / DECODE(LINE, '#', 1, COUNT(*) / 100) PAC_ISLANDER_WOMEN , COUNT(DECODE(RSLT.SEX, 'M', DECODE(INSTR('BFGHIJKLMNPQ', NVL(RSLT.ETHNIC_ORIGIN, '*')), 0, NULL, 1), NULL)) / DECODE(LINE, '#', 1, COUNT(*) / 100) PAC_ISLANDER_MEN , COUNT(DECODE(RSLT.SEX, 'F', DECODE(RSLT.ETHNIC_ORIGIN, 'A', 1, NULL), NULL)) / DECODE(LINE, '#', 1, COUNT(*) / 100) AMERINDIAN_ALASKAN_WOMEN , COUNT(DECODE(RSLT.SEX, 'M', DECODE(RSLT.ETHNIC_ORIGIN, 'A', 1, NULL), NULL)) / DECODE(LINE, '#', 1, COUNT(*) / 100) AMERINDIAN_ALASKAN_MEN FROM GHR_BREAKDOWN_RESULTS RSLT , (SELECT '#' LINE FROM DUAL UNION SELECT '%' LINE FROM DUAL) WHERE RSLT.SESSION_ID = USERENV('SESSIONID') GROUP BY BREAKDOWN_CRITERIA_ID ,FOR_CLAUSE ,WITHIN_CLAUSE ,BY_CLAUSE ,LINE

View Text - HTML Formatted

SELECT BREAKDOWN_CRITERIA_ID
, FOR_CLAUSE
, WITHIN_CLAUSE
, BY_CLAUSE
, LINE
, COUNT(DECODE(LINE
, '#'
, 1
, NULL)) TOTAL_ALL
, COUNT(DECODE(RSLT.SEX
, 'F'
, 1
, NULL)) / DECODE(LINE
, '#'
, 1
, COUNT(*) / 100) TOTAL_WOMEN
, COUNT( DECODE(RSLT.SEX
, 'M'
, 1
, NULL)) / DECODE( LINE
, '#'
, 1
, COUNT(*) / 100 ) TOTAL_MEN
, COUNT(DECODE(RSLT.SEX
, 'F'
, DECODE(RSLT.ETHNIC_ORIGIN
, 'E'
, 1
, NULL)
, NULL)) / DECODE(LINE
, '#'
, 1
, COUNT(*) / 100) WHITE_WOMEN
, COUNT(DECODE(RSLT.SEX
, 'M'
, DECODE(RSLT.ETHNIC_ORIGIN
, 'E'
, 1
, NULL)
, NULL)) / DECODE(LINE
, '#'
, 1
, COUNT(*) / 100) WHITE_MEN
, COUNT(DECODE(RSLT.SEX
, 'F'
, DECODE(RSLT.ETHNIC_ORIGIN
, 'C'
, 1
, NULL)
, NULL)) / DECODE(LINE
, '#'
, 1
, COUNT(*) / 100) BLACK_WOMEN
, COUNT(DECODE(RSLT.SEX
, 'M'
, DECODE(RSLT.ETHNIC_ORIGIN
, 'C'
, 1
, NULL)
, NULL)) / DECODE(LINE
, '#'
, 1
, COUNT(*) / 100) BLACK_MEN
, COUNT(DECODE(RSLT.SEX
, 'F'
, DECODE(RSLT.ETHNIC_ORIGIN
, 'D'
, 1
, NULL)
, NULL)) / DECODE(LINE
, '#'
, 1
, COUNT(*) / 100) HISPANIC_WOMEN
, COUNT(DECODE(RSLT.SEX
, 'M'
, DECODE(RSLT.ETHNIC_ORIGIN
, 'D'
, 1
, NULL)
, NULL)) / DECODE(LINE
, '#'
, 1
, COUNT(*) / 100) HISPANIC_MEN
, COUNT(DECODE(RSLT.SEX
, 'F'
, DECODE(INSTR('BFGHIJKLMNPQ'
, NVL(RSLT.ETHNIC_ORIGIN
, '*'))
, 0
, NULL
, 1)
, NULL)) / DECODE(LINE
, '#'
, 1
, COUNT(*) / 100) PAC_ISLANDER_WOMEN
, COUNT(DECODE(RSLT.SEX
, 'M'
, DECODE(INSTR('BFGHIJKLMNPQ'
, NVL(RSLT.ETHNIC_ORIGIN
, '*'))
, 0
, NULL
, 1)
, NULL)) / DECODE(LINE
, '#'
, 1
, COUNT(*) / 100) PAC_ISLANDER_MEN
, COUNT(DECODE(RSLT.SEX
, 'F'
, DECODE(RSLT.ETHNIC_ORIGIN
, 'A'
, 1
, NULL)
, NULL)) / DECODE(LINE
, '#'
, 1
, COUNT(*) / 100) AMERINDIAN_ALASKAN_WOMEN
, COUNT(DECODE(RSLT.SEX
, 'M'
, DECODE(RSLT.ETHNIC_ORIGIN
, 'A'
, 1
, NULL)
, NULL)) / DECODE(LINE
, '#'
, 1
, COUNT(*) / 100) AMERINDIAN_ALASKAN_MEN
FROM GHR_BREAKDOWN_RESULTS RSLT
, (SELECT '#' LINE
FROM DUAL UNION SELECT '%' LINE
FROM DUAL)
WHERE RSLT.SESSION_ID = USERENV('SESSIONID') GROUP BY BREAKDOWN_CRITERIA_ID
, FOR_CLAUSE
, WITHIN_CLAUSE
, BY_CLAUSE
, LINE