Инструкция для новых абонентов

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

COMMIT