andy test - gcc distribution

➜ Back to Library
Description
select distinct
count(*) over () total,
count(distinct gcc.segment1) over () segment1_count,
count(distinct gcc.segment2) over () segment2_count,
count(distinct gcc.segment3) over () segment3_count,
count(distinct gcc.segment4) over () segment4,
count(distinct gcc.segment1||'.'||gcc.segment2||'.'||gcc.segment3||'.'||gcc.segment4) over () segs1_2_3_4_count
from
gl_code_combinations gcc,
gl.gl_balances gb
where
gb.period_name=:p_period_name and
gb.translated_flag is null and
gb.ledger_id=:l_ledger_id and
gcc.summary_flag='N' and
gcc.chart_of_accounts_id=:l_coa_id and
gcc.code_combination_id=gb.code_combination_id and
gb.actual_flag='A'
Download
Related Blitz Reports
FSG Drilldown Diagnostic JE Hungarian Asset Movement Schedule: Gross Changes- Not Supported: Reserved For Future Use JE Hungarian Accumulated Depreciation Movement Schedule- Not Supported: Reserved For Future Use GL Balance by Account Hierarchy Mrugesh: GL Balance GL Account Analysis GL Code Combinations AI AP Trial Balance QA: GL Balance XXEUCL FA Asset Cost Insert
Blitz Report™