ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 11E6ECC71104254CE06362FB0905DB9DY 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' US andy test - gcc distribution :l_coa_id :l_ledger_id :p_period_name