minMax Cat(Null,Null)

SELECT mg.merchangrup_code "Group Code",
       mg.merchangrup_name "Group Name",
       sg.subgrup_code     "SubGroup Code",
       sg.subgrup_name     "SubGroup Name",
       k.kat_code          "Category Code",
       k.kat_name          "Category Name",
       brg.brg_code        PLU,
       brg.brg_name,
       ro.outlet_code      Outlet,
       NULL                "Dsp Loc",
       rsStock.sat_code    Satuan,
       rsStock.sat_name    UOM,
       brg.safety_stock    "Min Stock",
       brg.brg_max_stock   "Max Stock",
       NULL                "Qty At Dsp",
       ls.ls_stock         "Current Stock",
       rsPurchase.sat_code "Stock on Order",
       NULL                "Prj S1 / Dy"
FROM   barang brg
       LEFT OUTER JOIN ref$outlet ro
                    ON brg.ref$outlet_id = ro.ref$outlet_id
       LEFT OUTER JOIN last_stock ls
                    ON brg.barang_id = ls.ls_barang_id
       LEFT OUTER JOIN ref$satuan rsStock
                    ON rsStock.ref$satuan_id = brg.ref$satuan_stock
       LEFT OUTER JOIN ref$satuan rsPurchase
                    ON rsPurchase.ref$satuan_id = brg.ref$satuan_purchase
       INNER JOIN ref$kategori k
               ON brg.ref$kategori_id = k.ref$kategori_id
       INNER JOIN ref$sub_grup sg
               ON k.ref$sub_grup_id = sg.ref$sub_grup_id
       INNER JOIN ref$merchandise_grup mg
               ON sg.ref$merchandise_grup_id = mg.ref$merchandise_grup_id
WHERE  1 = 1
       AND k.kat_code >= (SELECT TOP 1 k.kat_code
                          FROM   ref$kategori k
                                 INNER JOIN ref$sub_grup sg
                                         ON k.ref$sub_grup_id =
                                            sg.ref$sub_grup_id
                          WHERE  sg.subgrup_code = '00.0060'
                          ORDER  BY 1)
       AND k.kat_code <= (SELECT TOP 1 k.kat_code
                          FROM   ref$kategori k
                                 INNER JOIN ref$sub_grup sg
                                         ON k.ref$sub_grup_id =
                                            sg.ref$sub_grup_id
                          WHERE  sg.subgrup_code = '00.0060'
                          ORDER  BY 1 DESC)
ORDER  BY k.kat_code,
          brg.brg_code