Viewing profile — noipnoid

(p.treaty_no, '^RT(TR|02)')) AND l.risk_level_status = '03' AND EXISTS ( SELECT 1 FROM rims_treaty_t t WHERE (t.treaty_no = p.treaty_no AND t.treaty_begin_date > l.effective_date A…

AND EXISTS ( SELECT 1 FROM rims_treaty_prop_risk_plan rp WHERE (rp.treaty_no = p.treaty_no AND rp.id_rims_treaty_prop_section = p.id_rims_treaty_prop_section AND rp.risk_class_code…

沙发

SELECT sr.*, nvl(sp.idx, 0) AS "idx" , nvl(sp.min_idx, 0) AS "minIdx" , nvl(sp.max_idx, 0) AS "maxIdx" , nvl(sp.risk_class_name_tail, '') AS "riskClassNameTail" FROM ( SELECT p.id_…

6666

select ttt.updated_date, ttt.plan_code, ttt.risk_level, ttt.treaty_no, ttt.indemnity_limit_type, ttt.indemnity_limit, (ttt.risk_class_code)风险等级代码, ttt.id_rims_treaty_prop_section f…

http://peimc-smp.paic.com.cn:8080/peimcnl/innovateVote/index...