aonestar.public

Parameters

Name	Type	Mode
i_group_booking_id	integer	IN
charge_date	date	IN (DEFAULT NULL)
post_date	date	IN (DEFAULT NULL)
item_id	integer	IN (DEFAULT NULL)

Definition

WITH
status_set AS (
    SELECT unnest(ARRAY['B','I','O']::char(1)[]) AS status
),
bk_rows AS (
    SELECT 'B'::char(1) AS status, b.*
    FROM sp_booking_rates_breakdown(
        i_rate_date         := charge_date,
        i_booking_id        := i_group_booking_id,
        i_booking_item      := item_id,
        only_not_checked_in := true
    ) b
),
ci_rows AS (
    SELECT r.status::char(1) AS status, s.*
    FROM (
        SELECT id, status
        FROM registration
        WHERE booking_id = i_group_booking_id
          AND status IN ('I','O')
          AND (item_id IS NULL OR booking_item = item_id)
    ) r,
    LATERAL sp_rate_schedule_breakdown(
        post_date   := charge_date,
        register_id := r.id,
        status      := NULL
    ) s
),
comp_plans AS (
    SELECT id FROM rate_plan WHERE plan_type = 5
),
-- Per-unit projection: 1 row per (status, booking_item, charge_date) for booking side, multiplied by room_qty;
-- 1 row per (status, register_id, charge_date) for CI side. Both contribute a uniform "units" stream.
units AS (
    SELECT
        status,
        booking_item                                                AS row_key,
        room_qty                                                    AS rooms,
        charge_to_booking,
        (rateplan_id IN (SELECT id FROM comp_plans))                AS is_comp,
        room::numeric                                               AS room_amt,
        extrabed::numeric                                           AS extrabed_amt,
        abf_included::numeric                                       AS abf_inc_amt,
        lunch_included::numeric                                     AS lunch_inc_amt,
        dinner_included::numeric                                    AS dinner_inc_amt,
        abf_extra::numeric                                          AS abf_ext_amt,
        lunch_extra::numeric                                        AS lunch_ext_amt,
        dinner_extra::numeric                                       AS dinner_ext_amt,
        inclusive_items
    FROM bk_rows
    UNION ALL
    SELECT
        status,
        register_id                                                 AS row_key,
        1                                                           AS rooms,
        charge_to_booking,
        (rateplan_id IN (SELECT id FROM comp_plans))                AS is_comp,
        room::numeric                                               AS room_amt,
        extrabed::numeric                                           AS extrabed_amt,
        abf_included::numeric                                       AS abf_inc_amt,
        lunch_included::numeric                                     AS lunch_inc_amt,
        dinner_included::numeric                                    AS dinner_inc_amt,
        abf_extra::numeric                                          AS abf_ext_amt,
        lunch_extra::numeric                                        AS lunch_ext_amt,
        dinner_extra::numeric                                       AS dinner_ext_amt,
        inclusive_items
    FROM ci_rows
),
-- One row per (status, row_key) — collapse the per-day units back to per-room totals.
unit_pr AS (
    SELECT
        status,
        row_key,
        max(rooms)::int                                             AS rooms,
        bool_or(charge_to_booking)                                  AS charge_to_booking,
        bool_or(is_comp)                                            AS is_comp,
        coalesce(sum(room_amt),       0)                            AS room_amt,
        coalesce(sum(extrabed_amt),   0)                            AS extrabed_amt,
        coalesce(sum(abf_inc_amt),    0)                            AS abf_inc_amt,
        coalesce(sum(lunch_inc_amt),  0)                            AS lunch_inc_amt,
        coalesce(sum(dinner_inc_amt), 0)                            AS dinner_inc_amt,
        coalesce(sum(abf_ext_amt),    0)                            AS abf_ext_amt,
        coalesce(sum(lunch_ext_amt),  0)                            AS lunch_ext_amt,
        coalesce(sum(dinner_ext_amt), 0)                            AS dinner_ext_amt
    FROM units
    GROUP BY status, row_key
),
-- Inclusion items pulled from inclusive_items JSON across both bk and ci. Carry rooms multiplier and status.
inc_items AS (
    SELECT
        b.status                                                    AS status,
        coalesce((item->>'inclusion_id')::int, 0)                   AS inclusion_id,
        item->>'name'                                               AS name,
        coalesce((item->>'charge_to_booking')::boolean, false)      AS charge_to_booking,
        coalesce((item->>'qty')::numeric, 0)
          * coalesce((item->>'charge_rate')::numeric, 0)            AS amt_per_room,
        b.room_qty                                                  AS rooms,
        b.booking_item                                              AS row_key
    FROM bk_rows b,
         jsonb_array_elements(b.inclusive_items::jsonb) AS item
    WHERE b.inclusive_items IS NOT NULL
    UNION ALL
    SELECT
        c.status,
        coalesce((item->>'inclusion_id')::int, 0),
        item->>'name',
        coalesce((item->>'charge_to_booking')::boolean, false),
        coalesce((item->>'qty')::numeric, 0)
          * coalesce((item->>'charge_rate')::numeric, 0),
        1,
        c.register_id
    FROM ci_rows c,
         jsonb_array_elements(c.inclusive_items::jsonb) AS item
    WHERE c.inclusive_items IS NOT NULL
),
inc_pr AS (
    SELECT
        status,
        inclusion_id,
        max(name)                                                   AS name,
        max(rooms)::int                                             AS rooms,
        bool_or(charge_to_booking)                                  AS charge_to_booking,
        coalesce(sum(amt_per_room), 0)                              AS amt
    FROM inc_items
    GROUP BY status, inclusion_id, row_key
),
all_inclusions AS (
    SELECT inclusion_id, max(name) AS name
    FROM inc_pr
    GROUP BY inclusion_id
),
inclusion_order AS (
    SELECT inclusion_id, name,
           30 + (row_number() OVER (ORDER BY inclusion_id))::int    AS display_order
    FROM all_inclusions
),
-- Requirement items pulled from ci other_items only (booking-side has no requirements).
-- Filter by post_date against the item's charge_date when post_date is given.
req_items AS (
    SELECT
        c.status                                                    AS status,
        coalesce((item->>'inclusion_id')::int, 0)                   AS inclusion_id,
        item->>'name'                                               AS name,
        coalesce((item->>'charge_to_booking')::boolean, false)      AS charge_to_booking,
        coalesce((item->>'qty')::numeric, 0)
          * coalesce((item->>'charge_rate')::numeric, 0)            AS amt_per_room,
        1                                                           AS rooms,
        c.register_id                                               AS row_key
    FROM ci_rows c,
         jsonb_array_elements(c.other_items::jsonb) AS item
    WHERE c.other_items IS NOT NULL
      AND (post_date IS NULL OR (item->>'charge_date')::date = post_date)
),
req_pr AS (
    SELECT
        status,
        inclusion_id,
        max(name)                                                   AS name,
        max(rooms)::int                                             AS rooms,
        bool_or(charge_to_booking)                                  AS charge_to_booking,
        coalesce(sum(amt_per_room), 0)                              AS amt
    FROM req_items
    GROUP BY status, inclusion_id, row_key
),
all_requirements AS (
    SELECT inclusion_id, max(name) AS name
    FROM req_pr
    GROUP BY inclusion_id
),
requirement_order AS (
    SELECT inclusion_id, name,
           400 + (row_number() OVER (ORDER BY inclusion_id))::int   AS display_order
    FROM all_requirements
),
-- ============================================================
-- DETAIL ROWS (one row per (row_type, status); 4 numeric fields per row).
-- Static rows are CROSS JOINed with status_set so every (row_type, status) tuple exists
-- (zero-valued when no underlying data). Dynamic inclusion/requirement rows likewise.
-- ============================================================
detail_rows AS (
    SELECT 'room_charge'::text AS row_type, 'inclusive'::text AS section,
           'Room Charge'::text AS description, 10 AS display_order, ss.status,
        coalesce((SELECT sum(rooms)::int     FROM unit_pr WHERE status = ss.status AND charge_to_booking     AND NOT is_comp), 0) AS bookacc_qty,
        coalesce((SELECT sum(room_amt*rooms) FROM unit_pr WHERE status = ss.status AND charge_to_booking),    0)::numeric         AS bookacc_amt,
        coalesce((SELECT sum(rooms)::int     FROM unit_pr WHERE status = ss.status AND NOT charge_to_booking AND NOT is_comp), 0) AS ownacc_qty,
        coalesce((SELECT sum(room_amt*rooms) FROM unit_pr WHERE status = ss.status AND NOT charge_to_booking), 0)::numeric        AS ownacc_amt,
        false AS amt_is_null
    FROM status_set ss

UNION ALL
    SELECT 'comp_room', 'inclusive', 'Complimentary', 11, ss.status,
        coalesce((SELECT sum(rooms)::int FROM unit_pr WHERE status = ss.status AND charge_to_booking     AND is_comp), 0),
        0::numeric,
        coalesce((SELECT sum(rooms)::int FROM unit_pr WHERE status = ss.status AND NOT charge_to_booking AND is_comp), 0),
        0::numeric,
        false
    FROM status_set ss

UNION ALL
    -- total_room: total physical rooms (charge + comp); amount = NULL
    SELECT 'total_room', 'inclusive', 'Total Rooms', 12, ss.status,
        coalesce((SELECT sum(rooms)::int FROM unit_pr WHERE status = ss.status AND charge_to_booking), 0),
        0::numeric,
        coalesce((SELECT sum(rooms)::int FROM unit_pr WHERE status = ss.status AND NOT charge_to_booking), 0),
        0::numeric,
        true
    FROM status_set ss

UNION ALL
    SELECT 'abf', 'inclusive', 'Breakfast', 20, ss.status,
        coalesce((SELECT sum(rooms)::int        FROM unit_pr WHERE status = ss.status AND charge_to_booking     AND abf_inc_amt > 0), 0),
        coalesce((SELECT sum(abf_inc_amt*rooms) FROM unit_pr WHERE status = ss.status AND charge_to_booking),    0)::numeric,
        coalesce((SELECT sum(rooms)::int        FROM unit_pr WHERE status = ss.status AND NOT charge_to_booking AND abf_inc_amt > 0), 0),
        coalesce((SELECT sum(abf_inc_amt*rooms) FROM unit_pr WHERE status = ss.status AND NOT charge_to_booking), 0)::numeric,
        false
    FROM status_set ss

UNION ALL
    SELECT 'lunch', 'inclusive', 'Lunch', 21, ss.status,
        coalesce((SELECT sum(rooms)::int          FROM unit_pr WHERE status = ss.status AND charge_to_booking     AND lunch_inc_amt > 0), 0),
        coalesce((SELECT sum(lunch_inc_amt*rooms) FROM unit_pr WHERE status = ss.status AND charge_to_booking),    0)::numeric,
        coalesce((SELECT sum(rooms)::int          FROM unit_pr WHERE status = ss.status AND NOT charge_to_booking AND lunch_inc_amt > 0), 0),
        coalesce((SELECT sum(lunch_inc_amt*rooms) FROM unit_pr WHERE status = ss.status AND NOT charge_to_booking), 0)::numeric,
        false
    FROM status_set ss

UNION ALL
    SELECT 'dinner', 'inclusive', 'Dinner', 22, ss.status,
        coalesce((SELECT sum(rooms)::int           FROM unit_pr WHERE status = ss.status AND charge_to_booking     AND dinner_inc_amt > 0), 0),
        coalesce((SELECT sum(dinner_inc_amt*rooms) FROM unit_pr WHERE status = ss.status AND charge_to_booking),    0)::numeric,
        coalesce((SELECT sum(rooms)::int           FROM unit_pr WHERE status = ss.status AND NOT charge_to_booking AND dinner_inc_amt > 0), 0),
        coalesce((SELECT sum(dinner_inc_amt*rooms) FROM unit_pr WHERE status = ss.status AND NOT charge_to_booking), 0)::numeric,
        false
    FROM status_set ss

UNION ALL
    -- Dynamic inclusion rows: one per (inclusion_id, status). display_order from inclusion_order.
    SELECT
        'inclusion', 'inclusive', io.name, io.display_order, ss.status,
        coalesce((SELECT sum(rooms)::int FROM inc_pr WHERE status = ss.status AND inclusion_id = io.inclusion_id AND charge_to_booking     AND amt > 0), 0),
        coalesce((SELECT sum(amt*rooms)  FROM inc_pr WHERE status = ss.status AND inclusion_id = io.inclusion_id AND charge_to_booking),    0)::numeric,
        coalesce((SELECT sum(rooms)::int FROM inc_pr WHERE status = ss.status AND inclusion_id = io.inclusion_id AND NOT charge_to_booking AND amt > 0), 0),
        coalesce((SELECT sum(amt*rooms)  FROM inc_pr WHERE status = ss.status AND inclusion_id = io.inclusion_id AND NOT charge_to_booking), 0)::numeric,
        false
    FROM inclusion_order io CROSS JOIN status_set ss

UNION ALL
    SELECT 'extra_bed', 'extra', 'Extra Bed', 200, ss.status,
        coalesce((SELECT sum(rooms)::int         FROM unit_pr WHERE status = ss.status AND charge_to_booking     AND extrabed_amt > 0), 0),
        coalesce((SELECT sum(extrabed_amt*rooms) FROM unit_pr WHERE status = ss.status AND charge_to_booking),    0)::numeric,
        coalesce((SELECT sum(rooms)::int         FROM unit_pr WHERE status = ss.status AND NOT charge_to_booking AND extrabed_amt > 0), 0),
        coalesce((SELECT sum(extrabed_amt*rooms) FROM unit_pr WHERE status = ss.status AND NOT charge_to_booking), 0)::numeric,
        false
    FROM status_set ss

UNION ALL
    SELECT 'extra_abf', 'extra', 'Breakfast', 201, ss.status,
        coalesce((SELECT sum(rooms)::int        FROM unit_pr WHERE status = ss.status AND charge_to_booking     AND abf_ext_amt > 0), 0),
        coalesce((SELECT sum(abf_ext_amt*rooms) FROM unit_pr WHERE status = ss.status AND charge_to_booking),    0)::numeric,
        coalesce((SELECT sum(rooms)::int        FROM unit_pr WHERE status = ss.status AND NOT charge_to_booking AND abf_ext_amt > 0), 0),
        coalesce((SELECT sum(abf_ext_amt*rooms) FROM unit_pr WHERE status = ss.status AND NOT charge_to_booking), 0)::numeric,
        false
    FROM status_set ss

UNION ALL
    SELECT 'extra_lunch', 'extra', 'Lunch', 202, ss.status,
        coalesce((SELECT sum(rooms)::int          FROM unit_pr WHERE status = ss.status AND charge_to_booking     AND lunch_ext_amt > 0), 0),
        coalesce((SELECT sum(lunch_ext_amt*rooms) FROM unit_pr WHERE status = ss.status AND charge_to_booking),    0)::numeric,
        coalesce((SELECT sum(rooms)::int          FROM unit_pr WHERE status = ss.status AND NOT charge_to_booking AND lunch_ext_amt > 0), 0),
        coalesce((SELECT sum(lunch_ext_amt*rooms) FROM unit_pr WHERE status = ss.status AND NOT charge_to_booking), 0)::numeric,
        false
    FROM status_set ss

UNION ALL
    SELECT 'extra_dinner', 'extra', 'Dinner', 203, ss.status,
        coalesce((SELECT sum(rooms)::int           FROM unit_pr WHERE status = ss.status AND charge_to_booking     AND dinner_ext_amt > 0), 0),
        coalesce((SELECT sum(dinner_ext_amt*rooms) FROM unit_pr WHERE status = ss.status AND charge_to_booking),    0)::numeric,
        coalesce((SELECT sum(rooms)::int           FROM unit_pr WHERE status = ss.status AND NOT charge_to_booking AND dinner_ext_amt > 0), 0),
        coalesce((SELECT sum(dinner_ext_amt*rooms) FROM unit_pr WHERE status = ss.status AND NOT charge_to_booking), 0)::numeric,
        false
    FROM status_set ss

UNION ALL
    -- Dynamic requirement rows: one per (inclusion_id, status). display_order from requirement_order.
    SELECT
        'requirement', 'requirement', ro.name, ro.display_order, ss.status,
        coalesce((SELECT sum(rooms)::int FROM req_pr WHERE status = ss.status AND inclusion_id = ro.inclusion_id AND charge_to_booking     AND amt > 0), 0),
        coalesce((SELECT sum(amt*rooms)  FROM req_pr WHERE status = ss.status AND inclusion_id = ro.inclusion_id AND charge_to_booking),    0)::numeric,
        coalesce((SELECT sum(rooms)::int FROM req_pr WHERE status = ss.status AND inclusion_id = ro.inclusion_id AND NOT charge_to_booking AND amt > 0), 0),
        coalesce((SELECT sum(amt*rooms)  FROM req_pr WHERE status = ss.status AND inclusion_id = ro.inclusion_id AND NOT charge_to_booking), 0)::numeric,
        false
    FROM requirement_order ro CROSS JOIN status_set ss
),
-- ============================================================
-- TOTAL ROWS — per-status, derived from detail_rows
-- ============================================================
total_rows AS (
    SELECT 'inclusive_total'::text AS row_type, 'inclusive'::text AS section,
           'Total'::text AS description, 100 AS display_order, status,
        0::int                                                              AS bookacc_qty,
        coalesce(sum(bookacc_amt) FILTER (WHERE row_type IN
            ('room_charge','abf','lunch','dinner','inclusion')), 0)::numeric AS bookacc_amt,
        0::int                                                              AS ownacc_qty,
        coalesce(sum(ownacc_amt)  FILTER (WHERE row_type IN
            ('room_charge','abf','lunch','dinner','inclusion')), 0)::numeric AS ownacc_amt,
        false AS amt_is_null
    FROM detail_rows
    GROUP BY status

UNION ALL
    SELECT 'extra_total', 'extra', 'Total for extra person', 300, status,
        0::int,
        coalesce(sum(bookacc_amt) FILTER (WHERE row_type IN
            ('extra_bed','extra_abf','extra_lunch','extra_dinner')), 0)::numeric,
        0::int,
        coalesce(sum(ownacc_amt)  FILTER (WHERE row_type IN
            ('extra_bed','extra_abf','extra_lunch','extra_dinner')), 0)::numeric,
        false
    FROM detail_rows
    GROUP BY status

UNION ALL
    SELECT 'requirement_total', 'requirement', 'Total', 500, status,
        0::int,
        coalesce(sum(bookacc_amt) FILTER (WHERE row_type = 'requirement'), 0)::numeric,
        0::int,
        coalesce(sum(ownacc_amt)  FILTER (WHERE row_type = 'requirement'), 0)::numeric,
        false
    FROM detail_rows
    GROUP BY status

UNION ALL
    SELECT 'grand_total', 'grand_total', 'Grand Total', 600, status,
        0::int,
        coalesce(sum(bookacc_amt) FILTER (WHERE row_type IN
            ('room_charge','abf','lunch','dinner','inclusion',
             'extra_bed','extra_abf','extra_lunch','extra_dinner',
             'requirement')), 0)::numeric,
        0::int,
        coalesce(sum(ownacc_amt)  FILTER (WHERE row_type IN
            ('room_charge','abf','lunch','dinner','inclusion',
             'extra_bed','extra_abf','extra_lunch','extra_dinner',
             'requirement')), 0)::numeric,
        false
    FROM detail_rows
    GROUP BY status
),
all_rows AS (
    SELECT * FROM detail_rows
    UNION ALL
    SELECT * FROM total_rows
),
-- Pivot: collapse the per-status rows into one row per row_type with three sets of figures.
pivoted AS (
    SELECT
        row_type, section, description, display_order,
        bool_or(amt_is_null) AS amt_is_null,
        coalesce(sum(bookacc_qty) FILTER (WHERE status = 'B'), 0)::int AS b_bookacc_qty,
        coalesce(sum(bookacc_amt) FILTER (WHERE status = 'B'), 0)      AS b_bookacc_amt,
        coalesce(sum(ownacc_qty)  FILTER (WHERE status = 'B'), 0)::int AS b_ownacc_qty,
        coalesce(sum(ownacc_amt)  FILTER (WHERE status = 'B'), 0)      AS b_ownacc_amt,
        coalesce(sum(bookacc_qty) FILTER (WHERE status = 'I'), 0)::int AS i_bookacc_qty,
        coalesce(sum(bookacc_amt) FILTER (WHERE status = 'I'), 0)      AS i_bookacc_amt,
        coalesce(sum(ownacc_qty)  FILTER (WHERE status = 'I'), 0)::int AS i_ownacc_qty,
        coalesce(sum(ownacc_amt)  FILTER (WHERE status = 'I'), 0)      AS i_ownacc_amt,
        coalesce(sum(bookacc_qty) FILTER (WHERE status = 'O'), 0)::int AS o_bookacc_qty,
        coalesce(sum(bookacc_amt) FILTER (WHERE status = 'O'), 0)      AS o_bookacc_amt,
        coalesce(sum(ownacc_qty)  FILTER (WHERE status = 'O'), 0)::int AS o_ownacc_qty,
        coalesce(sum(ownacc_amt)  FILTER (WHERE status = 'O'), 0)      AS o_ownacc_amt
    FROM all_rows
    GROUP BY row_type, section, description, display_order
),
ordered AS (
    SELECT
        row_number() OVER (ORDER BY display_order, description)::int AS row_id,
        p.*
    FROM pivoted p
)
SELECT coalesce(
    json_agg(
        json_build_object(
            'row_id',      row_id,
            'row_type',    row_type,
            'section',     section,
            'description', description,
            'booking', json_build_object(
                'bookacc_qty', b_bookacc_qty,
                'bookacc_amt', CASE WHEN amt_is_null THEN NULL ELSE b_bookacc_amt END,
                'ownacc_qty',  b_ownacc_qty,
                'ownacc_amt',  CASE WHEN amt_is_null THEN NULL ELSE b_ownacc_amt END,
                'total_qty',   b_bookacc_qty + b_ownacc_qty,
                'total_amt',   CASE WHEN amt_is_null THEN NULL ELSE b_bookacc_amt + b_ownacc_amt END
            ),
            'checked_in', json_build_object(
                'bookacc_qty', i_bookacc_qty + o_bookacc_qty,
                'bookacc_amt', CASE WHEN amt_is_null THEN NULL ELSE i_bookacc_amt + o_bookacc_amt END,
                'ownacc_qty',  i_ownacc_qty + o_ownacc_qty,
                'ownacc_amt',  CASE WHEN amt_is_null THEN NULL ELSE i_ownacc_amt + o_ownacc_amt END,
                'total_qty',   i_bookacc_qty + o_bookacc_qty + i_ownacc_qty + o_ownacc_qty,
                'total_amt',   CASE WHEN amt_is_null THEN NULL
                               ELSE i_bookacc_amt + o_bookacc_amt + i_ownacc_amt + o_ownacc_amt END
            ),
            'total', json_build_object(
                'bookacc_qty', b_bookacc_qty + i_bookacc_qty + o_bookacc_qty,
                'bookacc_amt', CASE WHEN amt_is_null THEN NULL
                               ELSE b_bookacc_amt + i_bookacc_amt + o_bookacc_amt END,
                'ownacc_qty',  b_ownacc_qty + i_ownacc_qty + o_ownacc_qty,
                'ownacc_amt',  CASE WHEN amt_is_null THEN NULL
                               ELSE b_ownacc_amt + i_ownacc_amt + o_ownacc_amt END,
                'total_qty',   b_bookacc_qty + i_bookacc_qty + o_bookacc_qty
                             + b_ownacc_qty  + i_ownacc_qty  + o_ownacc_qty,
                'total_amt',   CASE WHEN amt_is_null THEN NULL
                               ELSE b_bookacc_amt + i_bookacc_amt + o_bookacc_amt
                                  + b_ownacc_amt  + i_ownacc_amt  + o_ownacc_amt END
            ),
            'in_house', json_build_object(
                'bookacc_qty', i_bookacc_qty,
                'bookacc_amt', CASE WHEN amt_is_null THEN NULL ELSE i_bookacc_amt END,
                'ownacc_qty',  i_ownacc_qty,
                'ownacc_amt',  CASE WHEN amt_is_null THEN NULL ELSE i_ownacc_amt END,
                'total_qty',   i_bookacc_qty + i_ownacc_qty,
                'total_amt',   CASE WHEN amt_is_null THEN NULL ELSE i_bookacc_amt + i_ownacc_amt END
            ),
            'checked_out', json_build_object(
                'bookacc_qty', o_bookacc_qty,
                'bookacc_amt', CASE WHEN amt_is_null THEN NULL ELSE o_bookacc_amt END,
                'ownacc_qty',  o_ownacc_qty,
                'ownacc_amt',  CASE WHEN amt_is_null THEN NULL ELSE o_ownacc_amt END,
                'total_qty',   o_bookacc_qty + o_ownacc_qty,
                'total_amt',   CASE WHEN amt_is_null THEN NULL ELSE o_bookacc_amt + o_ownacc_amt END
            )
        )
        ORDER BY row_id
    ),
    '[]'::json
)
FROM ordered

sp_group_summary

Description

Parameters

Definition