233333
--指标：2500143 SELECT nvl(SUM(N_VALUE),0) AS N_VALUE FROM ( SELECT SUM(A.N_HLDMKV_LOCL) AS N_VALUE FROM T_FINANCIAL_VAL A JOIN T_SUBJ_SEC_PLATE B ON A.C_SEC_CODE = B.C_SEC_CODE WHERE A.C_PA_CODE IN ( SELECT REGEXP_SUBSTR(A.PA_CODES, '[^,]+', 1, LEVEL, 'i') AS STR FROM ( SELECT CASE WHEN VP1.C_DV_PARAMS_VALUE = '是' AND VP2.C_PARAMS = '是' THEN 'ZQTZ_CB,YSLX_ZRQ,JZZB' ELSE 'ZQTZ_CB' END AS PA_CODES FROM VB_PORT_BASEINFO A LEFT JOIN VB_AO_PARAMS VP1 ON A.C_PORT_CODE = VP1.C_PORT_CODE AND VP1.C_DSP_CODE = 'AO_QT_IFRS9_001' LEFT JOIN T_PARAMETER VP2 ON VP2.N_KEY = '112' AND VP2.C_VALUE = '4000' WHERE A.C_PORT_CODE = 'SJV284' ) A CONNECT BY LEVEL <= LENGTH(A.PA_CODES) - LENGTH(REGEXP_REPLACE(A.PA_CODES, ',', ''))+1) AND A.C_MKT_CODE IN (select c_key1 from table(GET_PARAMS_SET_DATA('SJV284','GPBKHYSC','smjj_jb_bz','MKT_CODE'))) AND A.C_PORT_CODE = 'SJV284' AND A.D_BIZ = GETWORKDATE('20230331') and b.c_plate_fl= (SELECT GETPLATEFL('SJV284', 'smjj_jb_bz') from dual) AND B.D_DATE = TO_DATE('20230331','YYYYMMDD') and b.c_plate_code in (SELECT c_plate_code FROM T_SUBJ_PLATE_INFO F WHERE F.C_PLATE_CODE_P = 'C' AND F.c_plate_fl= (SELECT GETPLATEFL('SJV284', 'smjj_jb_bz') from dual)) UNION ALL SELECT SUM(A.N_HLDMKV_LOCL) AS N_VALUE FROM T_FINANCIAL_VAL A JOIN ( select XXZQDM,XXHYZL from ( select XXZQDM, XXHYZL, row_number() over(partition by XXZQDM order by max(d_date) desc) as rn from T_D_OD_XSBZQXX where d_date between trunc(to_date('20230331','YYYYMMDD'),'Q') and to_date('20230331','YYYYMMDD') AND XXHYZL LIKE 'C%' group by XXZQDM,XXHYZL) where rn =1 ) s ON SUBSTR(A.C_SEC_CODE,0,6) = S.XXZQDM WHERE A.C_PA_CODE IN ( SELECT REGEXP_SUBSTR(A.PA_CODES, '[^,]+', 1, LEVEL, 'i') AS STR FROM ( SELECT CASE WHEN VP1.C_DV_PARAMS_VALUE = '是' AND VP2.C_PARAMS = '是' THEN 'ZQTZ_CB,YSLX_ZRQ,JZZB' ELSE 'ZQTZ_CB' END AS PA_CODES FROM VB_PORT_BASEINFO A LEFT JOIN VB_AO_PARAMS VP1 ON A.C_PORT_CODE = VP1.C_PORT_CODE AND VP1.C_DSP_CODE = 'AO_QT_IFRS9_001' LEFT JOIN T_PARAMETER VP2 ON VP2.N_KEY = '112' AND VP2.C_VALUE = '4000' WHERE A.C_PORT_CODE = 'SJV284' ) A CONNECT BY LEVEL <= LENGTH(A.PA_CODES) - LENGTH(REGEXP_REPLACE(A.PA_CODES, ',', ''))+1) AND A.C_MKT_CODE IN (select c_key1 from table(GET_PARAMS_SET_DATA('SJV284','GPBKHYSC','smjj_jb_bz','MKT_CODE'))) AND A.C_PORT_CODE = 'SJV284' and a.d_biz = GETWORKDATE('20230331'));