<cmpDataSet name="DS_JURSTORE_IN" activateoncreate="false">
        <![CDATA[
-- приходы
select
  v.DATE_OPER,
  v.N_DATE_OPER,
  v.D_DATE_OPER,
  v.WH_NAME,
  v.MOD_NAME,
  v.SIGNATURE,
  v.MAIN_MEASURE_CODE,
  v.QUANT_OUT,
  v.QUANT_REST,
  sum(v.QUANT_IN) as QUANT_IN -- суммарн. приход
from (
       select
         to_char(jst.DATE_OPER, 'DD.MM.YYYY') as DATE_OPER,
         jst.DATE_OPER as D_DATE_OPER,
         to_char(jst.DATE_OPER, 'YYYYMMDD') as N_DATE_OPER,

         (select
            st0.WH_NAME
          from D_V_JURSTORE jst0
            join D_V_GOODSSUPPLY gs0 on gs0.ID = jst0.GOODSSUPPLY
            join D_V_GOODPARTY gp0 on gp0.ID = gs0.PID
            join D_V_NOMMODIF nm0 on nm0.ID = gp0.NOMMODIF_ID
            join D_V_NOMBASE nb0 on nb0.ID = nm0.PID
            join D_V_STORE_OPER so0 on so0.ID = jst0.STORYOPER_ID and so0.SO_TYPE = 1 -- расход
            join D_V_STORE st0 on st0.ID = gs0.STORE_ID
          where jst0.DATE_OPER = jst.DATE_OPER
                and jst0.DOCNUM = jst.DOCNUM
                and nb0.ID = nb.ID
         ) as WH_NAME, -- склад-отправитель

         nm.MOD_NAME,
         D_PKG_STR_TOOLS.FIO(ag.SURNAME, ag.FIRSTNAME, ag.LASTNAME) as SIGNATURE,

         jst.QUANT as QUANT_IN,

         nm.MAIN_MEASURE_CODE,

         (select
            sum(jst0.QUANT)
          from D_V_JURSTORE jst0
            join D_V_GOODSSUPPLY gs0 on gs0.ID = jst0.GOODSSUPPLY
            join D_V_GOODPARTY gp0 on gp0.ID = gs0.PID
            join D_V_NOMMODIF nm0 on nm0.ID = gp0.NOMMODIF_ID
            join D_V_NOMBASE nb0 on nb0.ID = nm0.PID
            join D_V_STORE_OPER so0 on so0.ID = jst0.STORYOPER_ID and so0.SO_TYPE = 1 -- расход
          where jst0.DATE_OPER = jst.DATE_OPER
                and nb0.ID = nb.ID
                and gs0.STORE_ID = gs.STORE_ID
         ) as QUANT_OUT, -- суммарн. расход этой же номенклатуры в данную дату на данном складе

         D_PKG_JURSTORE.GET_DEP_FULL_RESTS_ON_DATE(nm.ID, :LPU, jst.DATE_OPER, :DEP, 1) as QUANT_REST -- остаток

       from D_V_JURSTORE jst
         join D_V_GOODSSUPPLY gs on gs.ID = jst.GOODSSUPPLY
         join D_V_GOODPARTY gp on gp.ID = gs.PID
         join D_V_NOMMODIF nm on nm.ID = gp.NOMMODIF_ID
         join D_V_NOMBASE nb on nb.ID = nm.PID
         join D_V_STORE_OPER so on so.ID = jst.STORYOPER_ID and so.SO_TYPE = 0 -- приход
         join D_V_STORE st on st.ID = gs.STORE_ID
         join D_V_STORE_PERSON sp on sp.PID = st.ID
         join D_V_AGENTS_BASE ag on ag.ID = sp.AGENT_ID
       where trunc(jst.DATE_OPER) >= to_date(:DATE_BEGIN, 'DD.MM.YYYY')
             and (:DATE_END is null or trunc(jst.DATE_OPER) <= to_date(:DATE_END, 'DD.MM.YYYY'))
             and gs.STORE_ID = :STORE
             and instr (';'||:NOMBASE||';', ';'||nb.ID||';') > 0
     ) v
group by v.DATE_OPER, v.N_DATE_OPER,  v.D_DATE_OPER, v.WH_NAME, v.MOD_NAME, v.SIGNATURE, v.MAIN_MEASURE_CODE, v.QUANT_OUT, v.QUANT_REST
order by v.D_DATE_OPER
        ]]>
        <cmpDataSetVar name="DATE_BEGIN" src="DATE_BEGIN" srctype="var" get="DATE_BEGIN"/>
        <cmpDataSetVar name="DATE_END" src="DATE_END" srctype="var" get="DATE_END"/>
        <cmpDataSetVar name="STORE" src="STORE" srctype="var" get="STORE"/>
        <cmpDataSetVar name="NOMBASE" src="NOMBASE" srctype="var" get="NOMBASE"/>
        <cmpDataSetVar name="DEP" src="DEP" srctype="var"/>
        <cmpDataSetVar name="LPU" src="STORE_LPU" srctype="var"/>
    </cmpDataSet>