SELECT *

WITH test AS
(
/*INVEN:100*/
SELECT 'REQ' cate
     , 1000 tw1, 1600 tw2,  800 tw3, 1000 tw4, 1000 tw5
     , 1200  w1, 1200  w2, 1200  w3, 1200  w4, 1200  w5
  FROM dual
)
, tmp AS
(
SELECT w
     , r req
     , c custom
     , d diff
     , SUM(d_) OVER(PARTITION BY p ORDER BY w) app
  FROM (SELECT w
             , r
             , c
             , c - r d
             , GREATEST(c - r, 0) d_
             , SUM(CASE WHEN c - r <= 0 THEN 1 END) OVER(ORDER BY w) p
          FROM (SELECT w
                     , DECODE(w, 1, tw1, 2, tw2, 3, tw3, 4, tw4, 5, tw5) r
                     , DECODE(w, 1,  w1, 2,  w2, 3,  w3, 4,  w4, 5,  w5) c
                  FROM test
                     , (SELECT LEVEL w FROM dual CONNECT BY LEVEL <= 5)
                )
        )
)
SELECT *
  FROM tmp
 UNPIVOT (v FOR cate IN (req, custom, diff, app))
 PIVOT (MIN(v) FOR w IN (1 w1, 2 w2, 3 w3, 4 w4, 5 w5))
 ORDER BY DECODE(cate, 'REQ', 1, 'CUSTOM', 2, 'DIFF', 3, 'APP', 4)
;