Вход

[select] select 1 isskd, sg.inner_par_service_group_id skd_siteid_sg_id,<br />
plx_get.service_group_param(sg.service_group_id,'SG_SKD_RAD_NAS_IP_ADDRESS') skd_rad_nas_ip_address<br />
from client_wires cw, service_groups sg, client_wires_ext cwe<br />
where sg.contract_id = '1225'<br />
and sg.service_class = 'I'<br />
and cw.wire_type = 'P'<br />
and ip_to_num('3.238.112.41') between cwe.range_from and cwe.range_to <br />
and cw.begin_dt <= sysdate<br />
and (cw.end_dt is null or cw.end_dt > sysdate)<br />
and cw.service_group_id = sg.service_group_id<br />
and cwe.wire_id = cw.wire_id<br />
and rownum < 2

COMMIT