Summary Account Template definition review script

GL : Summary Account Template definition review script:-
--------------------------------------------------------------------

GL SUMMARY TEMPLATE DEFINITIONS

Small script showing summary template configuration across multiple books,

I have tested in 11.5.10.2 Instance. This will work in all the 11i Instances.

I have commented the SOB condition. Check your Instances SOB short-name and provide accordingly if you have multiple SOB in your business Structure.

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 ('HB')