How to derive Basic Height from ADAS_LINK_GEOMETRY?

The Basic Height table has been discontinued but I still need to calculate this for our current products.

Oracle SQL Query Example below will derive Basic Height.

WITH REF_NODE_HEIGHT AS (SELECT LINK_ID,
Z_COORD as REF_NODE_ZCOORD
FROM ADAS_LINK_GEOMETRY
WHERE SEQ_NUM =0),

NON_REF_HEIGHT AS (SELECT LINK_ID,
Z_COORD AS NREF_NODE_ZCOORD
FROM ADAS_LINK_GEOMETRY
WHERE SEQ_NUM = 999999),

LINK_STATS AS (SELECT LINK_ID,
MIN(Z_COORD) AS LINK_MINIMUM_HEIGHT,
MAX(Z_COORD) AS LINK_MAXIMUM_HEIGHT,
ROUND(AVG(Z_COORD),0) LINK_AVERAGE_HEIGHT
FROM ADAS_LINK_GEOMETRY LG
WHERE NOT EXISTS (SELECT LINK_ID FROM ADAS_LINK_GEOMETRY LG2 WHERE LG2.LINK_ID = LG.LINK_ID AND LG2.Z_COORD IS NULL)
GROUP BY LINK_ID)

SELECT L.LINK_ID,
R.REF_NODE_ZCOORD,
N.NREF_NODE_ZCOORD,
L.LINK_MINIMUM_HEIGHT,
L.LINK_MAXIMUM_HEIGHT,
L.LINK_AVERAGE_HEIGHT
FROM REF_NODE_HEIGHT R,
NON_REF_HEIGHT N,
LINK_STATS L
WHERE L.LINK_ID = R.LINK_ID
AND L.LINK_ID = N.LINK_ID;