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 AND (l.invalidate_date IS NULL OR…

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 = l.risk_class_code) ) AND NOT EXISTS…

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_rims_treaty_prop_section_t AS…

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 from rims_treaty_prop_coverage_t ttt…