Siebel CRM little blog

select ' OR "' || w.name || '"' from siebel.S_VIEW_WTMPL_IT wti,
	   	 	  siebel.S_VIEW_WEB_TMPL wt,
			  siebel.S_VIEW w
	   where
	   		 wti.applet_name in ('IOM Account Entry Applet', 'IOM Account Entry Applet RO', 'IOM Account Entry Applet ZIU')
	   		 and wti.VIEW_WEB_TMPL_ID = wt.row_id
	   		 and wt.view_id = w.row_id
			 and w.repository_id = '1-1N4Y-1'
	   group by w.name
	   order by w.name