INSERT SHIPMENT REFNUM USING AGENT

HELLO,

currently we've a business need to delete insert shipment refnum using this query

INSERT INTO SHIPMENT_REFNUM (
DOMAIN_NAME,
SHIPMENT_GID,
SHIPMENT_REFNUM_QUAL_GID,
SHIPMENT_REFNUM_VALUE
)
SELECT
shps.DOMAIN_NAME,
shps.SHIPMENT_GID,
m.VALUE AS SHIPMENT_REFNUM_QUAL_GID,
jt.value_num
FROM SHIPMENT shps
CROSS APPLY (
SELECT REPLACE(REPLACE(t.attribute3, ',', '","'), '=', '":') AS json_pairs
FROM IE_SHIPMENTSTATUS t
WHERE t.I_TRANSACTION_NO = $GID
) x
CROSS APPLY (
SELECT
-- key uppercase
UPPER(REPLACE(REGEXP_SUBSTR(keyval, '[^:]+', 1, 1), '"', '')) AS key_name,
REPLACE(REGEXP_SUBSTR(keyval, '[^:]+', 1, 2), '"', '') AS value_num