andy test - gcc distribution

Description

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 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'