Day end unit stock view

CREATE OR REPLACE FORCE VIEW ST_DAYEND_UNIT_STOCK_V
AS
   SELECT DISTINCT
          'P' store_type,
          p.sv_dt,
          c.item_code,
          p.st_unit_no,
          SUM (
             CASE
                WHEN p.sv_type IN
                        ('GRR', 'IDR', 'IPR', 'OPN', 'PIA', 'DRR', 'DSR')
                THEN
                   NVL (c.retail_qnty, 0)
                WHEN p.sv_type IN ('DSI', 'EXP', 'IDI', 'IPI', 'GRN')
                THEN
                   - (NVL (c.retail_qnty, 0))
                ELSE
                   0
             END)
          OVER (PARTITION BY c.item_code, st_unit_no
                ORDER BY TRUNC (p.sv_dt))
             closing_qnty,
          SUM (
             CASE
                WHEN p.sv_type IN
                        ('GRR', 'IDR', 'IPR', 'OPN', 'PIA', 'DRR', 'DSR')
                THEN
                     (NVL (c.retail_qnty, 0) * NVL (c.prate, 0))
                   + NVL (c.adj_amnt, 0)
                WHEN p.sv_type IN ('DSI', 'EXP', 'IDI', 'IPI', 'GRN')
                THEN
                   - (NVL (c.retail_qnty, 0)) * NVL (c.prate, 0)
                ELSE
                   0
             END)
          OVER (PARTITION BY c.item_code, st_unit_no
                ORDER BY TRUNC (p.sv_dt))
             closing_amnt
     FROM ph_st_voucher p, ph_st_item c
    WHERE p.sv_no = c.sv_no