为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:7.6.0.139
【操作系统】：
【CPU】:
【问题描述】*：
执行sql语句报错，提示不能在相关子查询中使用rownum，sql语句如下：
WITH ORG AS (
SELECT ORG_ID
, (
SELECT ID
FROM OSP.ISC_BASEORG ORG
WHERE ORG.FUNC_TYPE = ‘03’
START WITH ORG.ID = ORGTEMP.ORG_ID
CONNECT BY ORG.ID = PRIOR ORG.PARENT_ID
) AS XGS_ORG_ID
, (
SELECT ID
FROM OSP.ISC_BASEORG ORG
WHERE ORG.FUNC_TYPE = ‘02’
START WITH ORG.ID = ORGTEMP.ORG_ID
CONNECT BY ORG.ID = PRIOR ORG.PARENT_ID
) AS SGS_ORG_ID
FROM (
SELECT DISTINCT ORGID AS ORG_ID
FROM OSP.DEVICE_AUTH_MANAGE
WHERE DEVICETYPE = ‘13505’
) ORGTEMP
)
SELECT TR.id AS TR_ID, ORG.ORG_ID, ORG.XGS_ORG_ID, ORG.SGS_ORG_ID, TR.FEEDER_ID
FROM D5000.DMS_TR_DEVICE TR
LEFT JOIN OSP.DEVICE_AUTH_MANAGE MANAGE ON MANAGE.DEVICEID = TR.ID
AND MANAGE.DEVICETYPE = ‘13505’
LEFT JOIN ORG ON MANAGE.ORGID = ORG.ORG_ID

我在其他环境上（达梦7.6.0.95）是可以执行这条sql的，请教专家这个要怎么处理