[FIX] query POS

SELECT
                                unit,
                                no_pos,
                                uraian,
                                no_skao,
                                penetapan,
                                disburse,
                                COALESCE ( SUM ( terbayar ), 0 ) AS terbayar
                            FROM
                            (
                                (
                                    SELECT
                                        unit_code AS unit,
                                        code AS no_pos,
                                        lookup_name AS uraian,
                                        a.nomor AS no_skao,
                                        penetapan,
                                        ako AS disburse,
                                        COALESCE ( SUM ( b.rptagihan ), 0 ) AS terbayar
                                    FROM
                                        oltp.prk_labarugi_ebudget e
                                        LEFT JOIN oltp.view_unit_induk w ON e.unit_code = w.kdwil_ebudget --ambil dari view wilayah
                                        LEFT JOIN oltp.a2k_ski_sko a ON e.year = a.year AND a.kdwil = w.kdwil AND a.type = 'AO' AND a.status = 't' --ambil dari view wilayah
                                        LEFT JOIN oltp.a2k_realisasi_operasi b ON e.code = b.prk AND e.year = b.year AND w.unitap = b.unit --ambil dari view wilayah
                                    WHERE
                                        $wheres
                                    GROUP BY
                                        e.code,
                                        e.unit_code,
                                        e.lookup_name,
                                        a.nomor,
                                        e.penetapan,
                                        e.ako
                                    ORDER BY
                                        e.code
                                )
                                UNION
                                (
                                    SELECT
                                        unit_code AS unit,
                                        code AS no_pos,
                                        lookup_name AS uraian,
                                        a.nomor AS no_skao,
                                        penetapan,
                                        ako AS disburse,
                                        COALESCE ( SUM ( rp.nilai_bayar ), 0 ) AS terbayar
                                    FROM
                                        oltp.prk_labarugi_ebudget e
                                        LEFT JOIN oltp.view_unit_induk w ON e.unit_code = w.kdwil_ebudget --ambil dari view wilayah
                                        LEFT JOIN oltp.a2k_ski_sko a ON e.year = a.year AND a.kdwil = w.kdwil AND a.type = 'AO' AND a.status = 't' --ambil dari view wilayah
                                        LEFT JOIN (
                                            SELECT
                                                r.kdwil,
                                                r.nilai_bayar,
                                                r.YEAR,
                                                T.pos --  sum(r.nilai_bayar)

                                            FROM
                                                oltp.a2k_realisasi_pengalihan r
                                                LEFT JOIN oltp.a2k_plafon_mou_detail T ON r.ref_id = T.period_id
                                            WHERE
                                                r.isactive
                                                AND r.TYPE = 'AO'
                                                AND category = 'MOU'
                                        UNION
                                            SELECT
                                                r.kdwil,
                                                r.nilai_bayar,
                                                r.YEAR,
                                                T.pos -- r.* ,t.* --  sum(r.nilai_bayar)

                                            FROM
                                                oltp.a2k_realisasi_pengalihan r
                                                LEFT JOIN oltp.a2k_plafon_nonmou_detail T ON r.ref_id = T.period_id
                                            WHERE
                                                r.isactive
                                                AND r.TYPE = 'AO'
                                                AND category = 'NON MOU'
                                        ) rp ON w.kdwil = rp.kdwil
                                        AND e.YEAR :: INT = rp.YEAR :: INT
                                        AND e.code :: int2 = rp.pos :: int2 -- total realisasi pengalihan

                                    WHERE
                                        $wheres

                                    GROUP BY
                                        e.code,
                                        e.unit_code,
                                        e.lookup_name,
                                        a.nomor,
                                        e.penetapan,
                                        e.ako
                                    ORDER BY
                                        e.code
                                )
                                UNION -- PPJ
                                (
                                    SELECT
                                    --LEFT ( e.kdwil, 3 ) || '1' AS unit,
                                    r.unit as unit,
                                    '998' AS no_pos,
                                    'BPUJL, PPJ & Bea Meterai' AS uraian,
                                    e.nomor AS no_skao,
                                    SUM ( DISTINCT A.ppj ) AS penetapan,
                                    SUM ( DISTINCT ppj ) AS disburse,
                                    SUM ( r.rptagihan ) AS terbayar
                                FROM
                                    oltp.a2k_ski_sko e
                                    LEFT JOIN oltp.view_unit_induk w ON e.kdwil = w.kdwil --ambil dari view wilayah
                                    LEFT JOIN (
                                    SELECT
                                        r.kdwil,
                                        r.YEAR,
                                        SUM ( ppn ) AS ppj
                                    FROM
                                        oltp.a2k_plafon_penetapan r
                                    WHERE
                                        TYPE = 'AO'
                                        AND isactive = 1
                                    GROUP BY
                                        YEAR,
                                        kdwil
                                    ) A ON e.YEAR = A.YEAR
                                    AND e.kdwil = A.kdwil
                                    LEFT JOIN (
                                    SELECT
                                        r.unit,
                                        r.YEAR,
                                        SUM ( rptagihan ) AS rptagihan
                                    FROM
                                        oltp.a2k_realisasi_operasi r
                                    WHERE
                                        prk = '998'
                                        AND deleted_at IS NULL
                                    GROUP BY
                                        YEAR,
                                        unit
                                    ) r ON e.YEAR = r.YEAR
                                    AND w.unitap = r.unit
                                WHERE
                                    $wheres
                                    AND e.status = 't'
                                    AND e.TYPE = 'AO'
                                GROUP BY
                                    e.kdwil,r.unit,
                                    no_skao
                                )
                            )	AS uni
                            GROUP BY
                                unit,
                                no_pos,
                                uraian,
                                no_skao,
                                penetapan,
                                disburse
                            ORDER BY
                                no_skao, no_pos