GL Summary Templates

➜ Back to Library
Description
Categories: Enginatics
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,xxen_report.max_column_length)||'",' text
from
(select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv
where
fifsv.application_id=101 and
fifsv.id_flex_code='GL#' and
fifsv.enabled_flag='Y' and
fifsv.id_flex_num=(select fifsv0.id_flex_num from fnd_id_flex_structures_vl fifsv0 where fifsv0.application_id=101 and fifsv0.id_flex_code='GL#' and fifsv0.id_flex_structure_name=:chart_of_accounts)
order by
fifsv.segment_num
 LOV
Download
 
Related Blitz Reports
GL Balance by Account Hierarchy AP Supplier Upload GL Chart of Accounts - Account Hierarchy AR Open Balances Revaluation CST Period Close Subinventory Value Summary CAC Margin Analysis Summary CAC Inventory Organization Summary XLA Distribution Links Summary FA Asset Book Details
Blitz Report™

Blitz Report™ provides multiple benefits: