17,086
社区成员
发帖
与我相关
我的任务
分享
---第一字段
(select decode(Scope,'2','大型企业','3','中型企业','4','小型企业','5','微型企业','')
from customer_info ci where ei.customerid=ci.customerid and ci.customertype<>'0107'),
--第二字段
(SELECT nvl(COGNRESULT, nvl(COGNRESULT3,COGNRESULT4))
FROM EVALUATE_RECORD ER
WHERE ER.OBJECTTYPE = 'Customer'
AND ER.EVALUATEPERIOD = '01'
AND ER.EFFFLAG = '1'
and ER.INVALIDATEDATE > to_char(sysdate,'yyyy/mm/dd')
and ER.Objectno = ei.customerid and rownum = 1),
---第三字段
(select decode(max(classifyresult),'A1','正常类1','A2','正常类2','B1',
'关注类1','B2','关注类2','B3','关注类3','C1','次级类1','C2','次级类2',
'D','可疑','E','损失','') from
cl_info cl where
classifyresult is not null
and cl.customerid=ei.customerid