Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE charge (customer_id, service_dt_tm, item_price, charge_type_cd, bill_item_id, charge_description) AS
  SELECT 1, TO_DATE('1970-01-01 12:34:56', 'YYYY-MM-DD HH24:MI:SS'), 2.15, 1577, 363803, 'Oil Change' FROM DUAL UNION ALL
  SELECT 1, TO_DATE('1970-01-01 12:34:56', 'YYYY-MM-DD HH24:MI:SS'), -2.15, 1576, 363803, 'Oil Change' FROM DUAL UNION ALL
  SELECT 1, TO_DATE('1970-01-01 12:34:56', 'YYYY-MM-DD HH24:MI:SS'), 2.15, 1577, 363803, 'Oil Change' FROM DUAL UNION ALL
  SELECT 1, TO_DATE('1970-01-01 12:34:56', 'YYYY-MM-DD HH24:MI:SS'), 2.15, 1577, 363803, 'Oil Change' FROM DUAL;
4 rows affected

CREATE TABLE customer (customer_id, active_ind, customer_type_cd, garage_loc_cd) AS
  SELECT 1, 1, 9489, 8473 FROM DUAL;
1 rows affected

SELECT service_dt_tm AS "Service Date",
       item_price,
       charge_type_cd
FROM   (
  SELECT c.service_dt_tm,
         c.item_price,
         c.charge_type_cd,
         ROW_NUMBER() OVER (
           PARTITION BY c.customer_id,
                        c.service_dt_tm,
                        ABS(c.item_price),
                        c.charge_type_cd
           ORDER BY     NULL
         ) AS rn,
         LEAST(
           COUNT(CASE c.charge_type_cd WHEN 1577 THEN 1 END) OVER (
             PARTITION BY c.customer_id, c.service_dt_tm, ABS(c.item_price)
             ORDER BY NULL
           ),
           COUNT(CASE c.charge_type_cd WHEN 1576 THEN 1 END) OVER (
             PARTITION BY c.customer_id, c.service_dt_tm, ABS(c.item_price)
             ORDER BY NULL
           )
         ) AS num_matched
  FROM   charge c
         INNER JOIN customer e
         ON c.customer_id = e.customer_id
  WHERE  c.bill_item_id = 363803
  AND    c.charge_description = 'Oil Change'
  AND    e.active_ind = 1
  AND    e.customer_type_cd IN (9489, 9480, 9488)
  AND    e.garage_loc_cd = 8473
)
WHERE  rn > num_matched;


Service Date
ITEM_PRICE
CHARGE_TYPE_CD


1970-01-01 12:34:56
2.15
1577

1970-01-01 12:34:56
2.15
1577