SELECT A.TSTCLS, A.HOGI, A.MIP, A.STEP, A.STEPNAME,
  A.ITEM,
  TO_CHAR(A.TOTCNT) AS TOTCNT,
  TO_CHAR(A.NGCNT) AS NGCNT, A.RATE AS RATE, 'DATA' AS DATA,
  ROWNUM AS TOP
FROM
  (
    SELECT  A.TSTCLS, A.HOGI, A.MIP, A.STEP, A.COMMENT1 AS STEPNAME,
      A.ITEM,
      COUNT(*) AS TOTCNT,
      SUM(DECODE(A.JUDGE, '0', 1, 0)) AS NGCNT,
      ROUND(SUM(DECODE(A.JUDGE, '0', 1, 0)) * 100 / COUNT(*),
        2) AS RATE
    FROM QWK_UPDETAIL A
      INNER JOIN QWK_UPHEAD B ON A.PLANT = B.PLANT
      AND A.TSTCLS = B.TSTCLS AND A.HOGI = B.HOGI AND A.MIP = B.MIP
      AND A.DBKEY = B.DBKEY
    WHERE B.PLANT = 'E'
      AND B.TSTCLS = 'VB'
      AND B.DBKEY >= '201508170759'
      AND B.DBKEY <= '201508180759'
      AND NOT EXISTS (
        SELECT 'X'
        FROM QCD_STAND
        WHERE PLANT = B.PLANT
          AND TSTCLS = B.TSTCLS
          AND A.ITEM = ITEM
          AND SLT01 = '1'
        )
      AND B.TMCODE NOT IN (
        SELECT SNO
        FROM QCD_MASTER
        WHERE PLANT = B.PLANT
          AND TSTCLS = B.TSTCLS
        )
      AND B.INSPCHASU = '1'
    GROUP BY A.TSTCLS, A.HOGI, A.MIP, A.STEP, A.COMMENT1,
      A.ITEM
  )A
WHERE ROWNUM <= 50
  AND A.NGCNT != 0



----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| Id  | Operation                          | Name             | Starts | E-Rows |E-Bytes| Cost (%CPU)| E-Time   | A-Rows |   A-Time   | Buffers |  OMem |  1Mem | Used-Mem |
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                   |                  |      1 |        |       |    11 (100)|          |     50 |00:00:01.17 |   68760 |       |       |          |
|*  1 |  COUNT STOPKEY                     |                  |      1 |        |       |            |          |     50 |00:00:01.17 |   68760 |       |       |          |
|   2 |   VIEW                             |                  |      1 |      1 |   132 |    11  (10)| 00:00:01 |     50 |00:00:01.17 |   68760 |       |       |          |
|*  3 |    FILTER                          |                  |      1 |        |       |            |          |     50 |00:00:01.17 |   68760 |       |       |          |
|   4 |     HASH GROUP BY                  |                  |      1 |      1 |   124 |    11  (10)| 00:00:01 |   1533 |00:00:01.17 |   68760 |   828K|   828K| 1331K (0)|
|*  5 |      FILTER                        |                  |      1 |        |       |            |          |    214K|00:00:00.91 |   68760 |       |       |          |
|   6 |       NESTED LOOPS ANTI            |                  |      1 |      1 |   124 |     9   (0)| 00:00:01 |    214K|00:00:00.74 |   66749 |       |       |          |
|   7 |        NESTED LOOPS                |                  |      1 |      1 |   111 |     7   (0)| 00:00:01 |    214K|00:00:00.63 |   66687 |       |       |          |
|*  8 |         TABLE ACCESS BY INDEX ROWID| QWK_UPHEAD       |      1 |      1 |    46 |     4   (0)| 00:00:01 |   2011 |00:00:00.01 |     976 |       |       |          |
|*  9 |          INDEX RANGE SCAN          | QWK_UPHEAD_IDX04 |      1 |      1 |       |     3   (0)| 00:00:01 |   2176 |00:00:00.01 |      20 |       |       |          |
|  10 |         TABLE ACCESS BY INDEX ROWID| QWK_UPDETAIL     |   2011 |      1 |    65 |     5   (0)| 00:00:01 |    214K|00:00:00.53 |   65711 |       |       |          |
|* 11 |          INDEX RANGE SCAN          | IDX_SCMR_010     |   2011 |      1 |       |     4   (0)| 00:00:01 |    214K|00:00:00.20 |   11231 |       |       |          |
|* 12 |        INDEX RANGE SCAN            | TEST_IDX         |     31 |     54 |   702 |     2   (0)| 00:00:01 |      0 |00:00:00.01 |      62 |       |       |          |
|* 13 |       INDEX RANGE SCAN             | XPKQCD_MASTER    |   2011 |      1 |    18 |     1   (0)| 00:00:01 |      0 |00:00:00.01 |    2011 |       |       |          |
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------