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.

SQL 22 lines

Parameters 2

ParameterTypeList of values SQL
Chart of AccountsLOV
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
Non Rollup Group OnlyLOV
nvl(gst.segment1_type,'D') in ('D','T') and
nvl(gst.segment2_type,'D') in ('D','T') and
nvl(gst.segment3_type,'D') in ('D','T') and
nvl(gst.segment4_type,'D') in ('D','T') and
nvl(gst.segment5_type,'D') in ('D','T') and
nvl(gst.segment6_type,'D') in ('D','T') and
nvl(gst.segment7_type,'D') in ('D','T') and
nvl(gst.segment8_type,'D') in ('D','T') and
nvl(gst.segment9_type,'D') in ('D','T') and
nvl(gst.segment10_type,'D') in ('D','T') and
nvl(gst.segment11_type,'D') in ('D','T') and
nvl(gst.segment12_type,'D') in ('D','T') and
nvl(gst.segment13_type,'D') in ('D','T') and
nvl(gst.segment14_type,'D') in ('D','T') and
nvl(gst.segment15_type,'D') in ('D','T') and
nvl(gst.segment16_type,'D') in ('D','T') and
nvl(gst.segment17_type,'D') in ('D','T') and
nvl(gst.segment18_type,'D') in ('D','T') and
nvl(gst.segment19_type,'D') in ('D','T') and
nvl(gst.segment20_type,'D') in ('D','T')