--指标：2500350
SELECT 0 AS N_VALUE,
TO_CHAR(replace(ZH_CONCAT(C_VALUE_CODE), ',', '')) AS C_VALUE_CODE
FROM (SELECT AA.C_NAME || '#' || TO_CHAR(SUM(AA.N_HLDMKV_LOCL), 'FM999999999990.00') || '；' AS C_VALUE_CODE
FROM (
SELECT CASE WHEN A.C_PA_CODE = 'YSK_SGK' THEN '应收申购款'
WHEN A.C_PA_CODE = 'YSK_QTK' THEN '其他应收款'
WHEN A.C_PA_CODE LIKE 'DTFY%' THEN '待摊费用'
WHEN A.C_PA_CODE LIKE 'YSK_GL%' THEN '应收股利'
END AS C_NAME,
A.N_HLDMKV_LOCL
FROM T_FINANCIAL_VAL A
WHERE A.D_BIZ = GETWORKDATE('20230331')
AND A.C_PORT_CODE = 'SEN276'
AND A.C_PA_CODE IN (SELECT C_KEY1 FROM TABLE(GET_PARAMS_SET_DATA('SEN276','YSK_SGK,YSK_QTK,YSK_GL,DTFY','smjj_yxjcb_bz','PA_CODE')))
UNION ALL
SELECT '应收利息' AS C_NAME,
A.N_HLDMKV_LOCL
FROM T_FINANCIAL_VAL A
LEFT JOIN VB_AO_PARAMS VP1 ON VP1.C_PORT_CODE = A.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.D_BIZ = GETWORKDATE('20230331')
AND A.C_PORT_CODE = 'SEN276'
AND A.C_PA_CODE LIKE 'YSLX%'
AND (NVL(VP1.C_DV_PARAMS_VALUE,' ') <> '是' OR NVL(VP2.C_PARAMS,' ') <> '是')
UNION ALL
SELECT '应收利息' AS C_NAME,
A.N_HLDMKV_LOCL
FROM T_FINANCIAL_VAL A
LEFT JOIN VB_AO_PARAMS VP1 ON VP1.C_PORT_CODE = A.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.D_BIZ = GETWORKDATE('20230331')
AND A.C_PORT_CODE = 'SEN276'
AND A.C_PA_CODE LIKE 'YSWSLX%'
AND VP1.C_DV_PARAMS_VALUE = '是'
AND VP2.C_PARAMS = '是'
UNION ALL
SELECT '应收债权（违约债）' AS C_NAME,
A.N_HLDMKV_LOCL
FROM T_FINANCIAL_VAL A
WHERE A.D_BIZ = GETWORKDATE('20230331')
AND A.C_PORT_CODE = 'SEN276'
AND A.C_PA_CODE IN ('ZQTZ_CB','YSLX_ZQ')
AND A.C_SEC_CODE IN (SELECT c_key1 FROM table(GET_SECMAP_DATA('SEN276','smjj_yxjcb_bz','LC_ZQ',TO_DATE('20230331','YYYYMMDD'))))
UNION ALL
SELECT '证券清算款' AS C_NAME,
SUM(N_HLDMKV_LOCL) AS N_HLDMKV_LOCL
FROM (
SELECT SUM(A.N_HLDMKV_LOCL) AS N_HLDMKV_LOCL
FROM T_FINANCIAL_VAL A
WHERE A.C_PORT_CODE = 'SEN276'
AND A.D_BIZ = TO_DATE('20230331', 'YYYYMMDD')
AND A.C_PA_CODE IN (SELECT C_KEY1 FROM TABLE(GET_PARAMS_SET_DATA('SEN276','ZQQSK','smjj_yxjcb_bz','PA_CODE')))
AND A.C_MKT_CODE NOT IN (SELECT C_KEY1 FROM TABLE(GET_PARAMS_SET_DATA('SEN276','ZQQSKJYSC','smjj_yxjcb_bz','MKT_CODE')))
GROUP BY A.C_MKT_CODE HAVING SUM(A.N_HLDMKV_LOCL) >0)
UNION ALL
SELECT '其他资产' AS C_NAME,SUM(N_VALUE) AS N_HLDMKV_LOCL
FROM T_REPORT_RESULT
WHERE N_DATE='20230331' AND C_PORT_CODE='SEN276' AND C_QUERY_ID='SEN276;smjj_jb_bz489'
AND N_SET_ID IN (2503143)
) AA GROUP BY AA.C_NAME HAVING SUM(AA.N_HLDMKV_LOCL) <> 0
);