GL Summary Templates

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.

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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