/* GL SUMMARY TEMPLATE DEFINITIONS
Written by Daniel North,  ORAFINAPPS Limited, Copyright 2007 
Small script showing summary template configuration across multiple books, 
(Tested on Vision 11.5.10.2 Jul-2007 ) */
select sob.name
,	   st.template_name
,	   st.concatenated_description
,	   st.account_category_code"Cat"
,	   st.START_ACTUALS_PERIOD_NAME "From"
,	   st.segment1_type||'-'||st.segment2_type||'-'||st.segment3_type||'-'||st.segment4_type||'-'||st.segment5_type||'-'||
	   st.segment6_type||'-'||st.segment7_type||'-'||st.segment8_type||'-'||st.segment9_type||'-'||st.segment10_type "Segment Type"
from GL_SUMMARY_TEMPLATES st, GL_SETS_OF_BOOKS sob
where st.SET_OF_BOOKS_ID = sob.SET_OF_BOOKS_ID
--and substr(sob.name,1,2) in ('ES','BE','LU')