ZZZ

(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 l.invalidate_date > t.treaty_begin_date)) ) AND NOT EXISTS ( SELECT 1 FROM rims_risk_plan r WHERE (r.plan_code = t.plan_code AND r.risk_class_type = '1' AND r.risk_plan_status = '02') ) AND NOT EXISTS ( SELECT 1 FROM rims_risk_plan r WHERE (r.plan_code = t.plan_code AND r.risk_class_type = '2' AND r.risk_plan_status = '02') )) ) AND p.treaty_no = 'RTTR1802' ) sr, ( SELECT id_rims_treaty_prop_section, risk_class_code, idx, risk_class_name_tail , MIN(idx) OVER (PARTITION BY id_rims_treaty_prop_section, risk_class_code ) AS min_idx, MAX(idx) OVER (PARTITION BY id_rims_treaty_prop_section, risk_class_code ) AS max_idx FROM rims_treaty_prop_risk_plan_t t WHERE t.treaty_no = 'RTTR1802' GROUP BY id_rims_treaty_prop_section, risk_class_code, idx, risk_class_name_tail ) sp WHERE sr."idRimsTreatyPropSection" = sp.id_rims_treaty_prop_section(+) AND sr."riskClassCode" = sp.risk_class_code(+) ORDER BY 'sectionName', 'idx', 'riskClassName' DESC