为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:源端8.1.4.6 Packl，目标端:8.1.4.80 Pack42
【操作系统】：麒麟
【CPU】: 海光
【问题描述】*：
CREATE OR REPLACE VIEW "CQENT"."ANALYSE_QY_CHILD_VIEW"
AS
WITH TMP_1 AS (
SELECT ENT_NAME, UNISC_ID, P_ENT_NAME, P_REG_NO
FROM DZZW_QY_INFO
WHERE P_ENT_NAME IS NOT NULL AND P_ENT_NAME != ENT_NAME AND P_REG_NO != REG_NO
), TMP_2 AS (
SELECT a.inv, a.cer_no, b.ent_name, b.unisc_id,
nvl(b.cbrs, 0) cbrs, ROUND(NVL(b.YYSR,0)/10000,2) YYSR,ROUND(NVL(b.ZCZE,0)/10000,2) ZCZE
FROM DZZW_QY_TZF_NEW a LEFT JOIN mv_analyse_qy_eco B
ON a.JBXX_ID = b.prip_id
WHERE a.CER_NO != b.unisc_id AND a.TYPE = 1 and a.SUB_CON_PROP >= '0.5' AND a.CER_NO LIKE '9%'
)
SELECT QY."P_ENT_NAME",QY."P_UNISC_ID",QY."ENT_NAME",QY."UNISC_ID",QY."CHILD_LEVEL", nvl(ECO.CBRS, 0) CBRS, ROUND(NVL(ECO.YYSR,0)/10000,2) YYSR, ROUND(NVL(ECO.ZCZE,0)/10000,2) ZCZE
FROM(
SELECT A.ENT_NAME P_ENT_NAME, A.UNISC_ID P_UNISC_ID, TMP_1.ENT_NAME, TMP_1.UNISC_ID, 1 CHILD_LEVEL
FROM DZZW_QY_INFO A JOIN TMP_1
ON (A.ENT_NAME = TMP_1.P_ENT_NAME OR A.REG_NO = TMP_1.P_REG_NO OR A.UNISC_ID = TMP_1.P_REG_NO)
) QY
LEFT JOIN MV_ANALYSE_QY_ECO ECO ON QY.UNISC_ID = ECO.UNISC_ID
UNION ALL
SELECT CONNECT_BY_ROOT TMP_2.inv P_ENT_NAME, CONNECT_BY_ROOT TMP_2.cer_no P_UNISC_ID, TMP_2.ent_name, TMP_2.unisc_id,
LEVEL child_level, TMP_2.cbrs, TMP_2.yysr, TMP_2.zcze
FROM TMP_2
CONNECT BY NOCYCLE PRIOR TMP_2.unisc_id = TMP_2.CER_NO;