select
v_txcs.x_unit "Jednostka"
,v_txcs.x_name "Segment"
,v_txcs.x_category_desc "Kategoria"
,v_tbo.x_nipunique "NIP"
,v_tbo.org_id "NG"
,v_ts.name "Firma"
,v_ts.site_id "Numer konta"
,v_ts.x_netia_company "Spółka"
,v_tsp.instance_name "Nazwa usługi"
,v_tsp.x_cupii "Cupii"
,v_tsp.part_status "Status"
,decode( v_tsp.level_to_part , 1 , 'Usługa główna' , 'Podusługa' ) "Rodzaj usługi"
,to_char( v_tsp.ship_date , 'yyyy-mm-dd' ) "Data aktywacji"
,v_tsp.x_technology "Technologia"
,v_tsp.quantity "Ilość"
,v_ta.zipcode "Kod pocztowy"
,v_ta.city "Miasto"
,v_ta.x_street "Ulica"
,v_ta.x_house "Nr domu"
,v_tsp.x_p_line_no
,v_tsp.x_line_no
,v_tsp.x_invoice_desc "Opis na Fakturze"
from
table_site_part v_tsp
join table_site v_ts on v_ts.objid = v_tsp.all_site_part2site
join table_bus_org v_tbo on v_tbo.objid = v_ts.primary2bus_org
join table_x_cust_seg v_txcs on v_txcs.objid = v_tbo.x_bus_org2cust_seg
left join table_sit_prt_role v_tspr on v_tsp.objid = v_tspr.Prt_Role2site_Part
left join table_site v_ts1 on v_ts1.objid = v_tspr.prt_role2site
left join table_address v_ta on v_ts1.CUST_SHIPADDR2ADDRESS = v_ta.objid
where
v_tsp.instance_name = 'Usługa Bezpieczeństwa'
and v_tsp.part_status = 'Aktywny'
and v_txcs.x_unit = 'B2B'
order by
v_tbo.x_nipunique
,v_tbo.org_id
,v_ts.site_id
,v_tsp.x_p_line_no
,v_tsp.x_line_no