GL Summary Templates

Description
Categories: Enginatics, Toolkit - Operations
Repository: Github
Master data report showing GL summary and concatenation templates based on ledger, company, department, account, sub-account, and product segments, and including information for the group, ledger set, ledger, ledger category, currency and chart of accounts.
Run GL Summary Templates and other Oracle EBS reports with Blitz Report™ on our demo environment
select
gl.name ledger,
gst.template_name,
gst.description,
&segment_columns
gst.concatenated_description,
gst.start_actuals_period_name earliest_period,
xxen_util.meaning(gst.status,'SUMMARY_STATUS',101) status,
xxen_util.user_name(gst.created_by) created_by,
gst.creation_date,
xxen_util.user_name(gst.last_updated_by) last_updated_by,
gst.last_update_date,
gst.template_id
from
gl_ledgers gl,
gl_summary_templates gst
where
1=1 and
gl.ledger_id=gst.ledger_id
order by
gl.name,
gst.template_name
Parameter Name SQL text Validation
Chart of Accounts
select
'gst.'||lower(fifsv.application_column_name)||'_type "'||substrb(fifsv.form_left_prompt,1,30)||'",' text
from
fnd_id_flex_segments_vl fifsv
where
fifsv.application_id=101 and
fifsv.id_flex_code='GL#' and
fifsv.id_flex_num=(select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_structure_name=:chart_of_accounts)
order by
fifsv.segment_num
LOV