526互联

AND (NVL(VP1.C_DV_PARAMS_VALUE,' ') <> '是' OR NVL(VP2.C_PARAMS,' ') <> '是')

发布时间 2023-08-17 12:50:19作者: Mr.king℡

SELECT A.C_PA_CODE
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 = TO_DATE('20230331', 'YYYYMMDD')
AND A.C_PORT_CODE = 'SJP873'
-- AND A.C_PA_CODE LIKE 'YSLX%'
AND (NVL(VP1.C_DV_PARAMS_VALUE,' ') <> '是' OR NVL(VP2.C_PARAMS,' ') <> '是')
AND A.N_HLDMKV_LOCL =709000;