with a1 as (select a.lcs_item_code, 
   SUM(DECODE(a.lcs_locn_code,001,(Nvl(a.lcs_stk_qty_bu,0) + Nvl(a.lcs_rcvd_qty_bu,0)) - Nvl(a.lcs_issd_qty_bu,0))) THRM, 
   SUM(DECODE(a.lcs_locn_code,002,(Nvl(a.lcs_stk_qty_bu,0) + Nvl(a.lcs_rcvd_qty_bu,0)) - Nvl(a.lcs_issd_qty_bu,0))) TSAB, 
   SUM(DECODE(a.lcs_locn_code,003,(Nvl(a.lcs_stk_qty_bu,0) + Nvl(a.lcs_rcvd_qty_bu,0)) - Nvl(a.lcs_issd_qty_bu,0))) TCLK, 
   SUM(DECODE(a.lcs_locn_code,004,(Nvl(a.lcs_stk_qty_bu,0) + Nvl(a.lcs_rcvd_qty_bu,0)) - Nvl(a.lcs_issd_qty_bu,0))) TALK, 
   SUM(DECODE(a.lcs_locn_code,005,(Nvl(a.lcs_stk_qty_bu,0) + Nvl(a.lcs_rcvd_qty_bu,0)) - Nvl(a.lcs_issd_qty_bu,0))) TAHL 
from dm_locn_stock a
where (Nvl(a.lcs_stk_qty_bu,0) + Nvl(a.lcs_rcvd_qty_bu,0)) - Nvl(a.lcs_issd_qty_bu,0) > 0 
group by a.lcs_item_code),
     c1 as (select c.cd_item_code,
             SUM(DECODE(c.cd_locn_code,001,(c.cd_qty))) HMR,
             SUM(DECODE(c.cd_locn_code,002,(c.cd_qty))) SAB,
             SUM(DECODE(c.cd_locn_code,003,(c.cd_qty))) CLK,
             SUM(DECODE(c.cd_locn_code,004,(c.cd_qty))) ALK,
             SUM(DECODE(c.cd_locn_code,005,(c.cd_qty))) AHL
           from os_cons_detail_date c
               group by c.cd_item_code)
select b.item_anly_code_01, 
         b.item_anly_code_06, 
         b.item_anly_code_02||b.item_anly_code_03||b.item_anly_code_04 item,
         THRM,TSAB,TCLK,TALK,TAHL,HMR,SAB,CLK,ALK,AHL 
   FROM OM_ITEM b left join c1 on (b.item_code = c1.cd_item_code)
       left join a1 on (b.item_code = a1.lcs_item_code)
order by b.item_anly_code_01, 
         b.item_anly_code_06, 
         b.item_anly_code_02||b.item_anly_code_03||b.item_anly_code_04