eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
MATERIALIZED VIEW: APPS.BIL_BI_PIPEC_G_MV

Source


(
SELECT
  		 grp_total_flag,
        		fact.parent_sales_group_id,
  		fact.sales_group_id sales_group_id,
  		fact.salesrep_id,
  		fact.snap_date,
  		fact.product_category_id,
  		fact.item_id,
  		SUM(fact.pipeline_amt_day) pipeline_amt_day,
  		SUM(fact.pipeline_amt_week) pipeline_amt_week,
  		SUM(fact.pipeline_amt_period) pipeline_amt_period,
  		SUM(fact.pipeline_amt_quarter) pipeline_amt_quarter,
  		SUM(fact.pipeline_amt_year) pipeline_amt_year,
		
		SUM(fact.wtd_pipeline_amt_day) wtd_pipeline_amt_day,
  		SUM(fact.wtd_pipeline_amt_week) wtd_pipeline_amt_week,
  		SUM(fact.wtd_pipeline_amt_period) wtd_pipeline_amt_period,
  		SUM(fact.wtd_pipeline_amt_quarter) wtd_pipeline_amt_quarter,
  		SUM(fact.wtd_pipeline_amt_year) wtd_pipeline_amt_year,

  		SUM(fact.open_amt_day) open_amt_day,
  		SUM(fact.open_amt_week) open_amt_week,
  		SUM(fact.open_amt_period) open_amt_period,
  		SUM(fact.open_amt_quarter) open_amt_quarter,
  		SUM(fact.open_amt_year) open_amt_year,
  		SUM(fact.pipeline_amt_day_s) pipeline_amt_day_s,
  		SUM(fact.pipeline_amt_week_s) pipeline_amt_week_s,
  		SUM(fact.pipeline_amt_period_s) pipeline_amt_period_s,
  		SUM(fact.pipeline_amt_quarter_s) pipeline_amt_quarter_s,
  		SUM(fact.pipeline_amt_year_s) pipeline_amt_year_s,
		
		SUM(fact.wtd_pipeline_amt_day_s) wtd_pipeline_amt_day_s,
  		SUM(fact.wtd_pipeline_amt_week_s) wtd_pipeline_amt_week_s,
  		SUM(fact.wtd_pipeline_amt_period_s) wtd_pipeline_amt_period_s,
  		SUM(fact.wtd_pipeline_amt_quarter_s) wtd_pipeline_amt_quarter_s,
  		SUM(fact.wtd_pipeline_amt_year_s) wtd_pipeline_amt_year_s,
  		
  		SUM(fact.open_amt_day_s) open_amt_day_s,
  		SUM(fact.open_amt_week_s) open_amt_week_s,
  		SUM(fact.open_amt_period_s) open_amt_period_s,
  		SUM(fact.open_amt_quarter_s) open_amt_quarter_s,
  		SUM(fact.open_amt_year_s) open_amt_year_s,

		SUM(fact.prvwk_pipe_amt_day) prvwk_pipe_amt_day,
  		SUM(fact.prvwk_pipe_amt_wk) prvwk_pipe_amt_wk,
  		SUM(fact.prvwk_pipe_amt_prd) prvwk_pipe_amt_prd,
  		SUM(fact.prvwk_pipe_amt_qtr) prvwk_pipe_amt_qtr,
  		SUM(fact.prvwk_pipe_amt_yr) prvwk_pipe_amt_yr,
        SUM(fact.prvwk_wtd_pipe_amt_day) prvwk_wtd_pipe_amt_day,
  		SUM(fact.prvwk_wtd_pipe_amt_wk) prvwk_wtd_pipe_amt_wk,
  		SUM(fact.prvwk_wtd_pipe_amt_prd) prvwk_wtd_pipe_amt_prd,
  		SUM(fact.prvwk_wtd_pipe_amt_qtr) prvwk_wtd_pipe_amt_qtr,
  		SUM(fact.prvwk_wtd_pipe_amt_yr) prvwk_wtd_pipe_amt_yr,
  		SUM(fact.prvwk_open_amt_day) prvwk_open_amt_day,
  		SUM(fact.prvwk_open_amt_wk) prvwk_open_amt_wk,
  		SUM(fact.prvwk_open_amt_prd) prvwk_open_amt_prd,
  		SUM(fact.prvwk_open_amt_qtr) prvwk_open_amt_qtr,
  		SUM(fact.prvwk_open_amt_yr) prvwk_open_amt_yr,
  		SUM(fact.prvwk_pipe_amt_day_s) prvwk_pipe_amt_day_s,
  		SUM(fact.prvwk_pipe_amt_wk_s) prvwk_pipe_amt_wk_s,
  		SUM(fact.prvwk_pipe_amt_prd_s) prvwk_pipe_amt_prd_s,
  		SUM(fact.prvwk_pipe_amt_qtr_s) prvwk_pipe_amt_qtr_s,
  		SUM(fact.prvwk_pipe_amt_yr_s) prvwk_pipe_amt_yr_s,
        SUM(fact.prvwk_wtd_pipe_amt_day_s) prvwk_wtd_pipe_amt_day_s,
  		SUM(fact.prvwk_wtd_pipe_amt_wk_s) prvwk_wtd_pipe_amt_wk_s,
  		SUM(fact.prvwk_wtd_pipe_amt_prd_s) prvwk_wtd_pipe_amt_prd_s,
  		SUM(fact.prvwk_wtd_pipe_amt_qtr_s) prvwk_wtd_pipe_amt_qtr_s,
  		SUM(fact.prvwk_wtd_pipe_amt_yr_s) prvwk_wtd_pipe_amt_yr_s,
  		SUM(fact.prvwk_open_amt_day_s) prvwk_open_amt_day_s,
  		SUM(fact.prvwk_open_amt_wk_s) prvwk_open_amt_wk_s,
  		SUM(fact.prvwk_open_amt_prd_s) prvwk_open_amt_prd_s,
  		SUM(fact.prvwk_open_amt_qtr_s) prvwk_open_amt_qtr_s,
  		SUM(fact.prvwk_open_amt_yr_s) prvwk_open_amt_yr_s,
  		  
		SUM(fact.prvprd_pipe_amt_day) prvprd_pipe_amt_day,
  		SUM(fact.prvprd_pipe_amt_wk) prvprd_pipe_amt_wk,
  		SUM(fact.prvprd_pipe_amt_prd) prvprd_pipe_amt_prd,
  		SUM(fact.prvprd_pipe_amt_qtr) prvprd_pipe_amt_qtr,
  		SUM(fact.prvprd_pipe_amt_yr) prvprd_pipe_amt_yr,
        SUM(fact.prvprd_wtd_pipe_amt_day) prvprd_wtd_pipe_amt_day,
  		SUM(fact.prvprd_wtd_pipe_amt_wk) prvprd_wtd_pipe_amt_wk,
  		SUM(fact.prvprd_wtd_pipe_amt_prd) prvprd_wtd_pipe_amt_prd,
  		SUM(fact.prvprd_wtd_pipe_amt_qtr) prvprd_wtd_pipe_amt_qtr,
  		SUM(fact.prvprd_wtd_pipe_amt_yr) prvprd_wtd_pipe_amt_yr,
  		SUM(fact.prvprd_open_amt_day) prvprd_open_amt_day,
  		SUM(fact.prvprd_open_amt_wk) prvprd_open_amt_wk,
  		SUM(fact.prvprd_open_amt_prd) prvprd_open_amt_prd,
  		SUM(fact.prvprd_open_amt_qtr) prvprd_open_amt_qtr,
  		SUM(fact.prvprd_open_amt_yr) prvprd_open_amt_yr,
  		SUM(fact.prvprd_pipe_amt_day_s) prvprd_pipe_amt_day_s,
  		SUM(fact.prvprd_pipe_amt_wk_s) prvprd_pipe_amt_wk_s,
  		SUM(fact.prvprd_pipe_amt_prd_s) prvprd_pipe_amt_prd_s,
  		SUM(fact.prvprd_pipe_amt_qtr_s) prvprd_pipe_amt_qtr_s,
  		SUM(fact.prvprd_pipe_amt_yr_s) prvprd_pipe_amt_yr_s,
        SUM(fact.prvprd_wtd_pipe_amt_day_s) prvprd_wtd_pipe_amt_day_s,
  		SUM(fact.prvprd_wtd_pipe_amt_wk_s) prvprd_wtd_pipe_amt_wk_s,
  		SUM(fact.prvprd_wtd_pipe_amt_prd_s) prvprd_wtd_pipe_amt_prd_s,
  		SUM(fact.prvprd_wtd_pipe_amt_qtr_s) prvprd_wtd_pipe_amt_qtr_s,
  		SUM(fact.prvprd_wtd_pipe_amt_yr_s) prvprd_wtd_pipe_amt_yr_s,
  		SUM(fact.prvprd_open_amt_day_s) prvprd_open_amt_day_s,
  		SUM(fact.prvprd_open_amt_wk_s) prvprd_open_amt_wk_s,
  		SUM(fact.prvprd_open_amt_prd_s) prvprd_open_amt_prd_s,
  		SUM(fact.prvprd_open_amt_qtr_s) prvprd_open_amt_qtr_s,
  		SUM(fact.prvprd_open_amt_yr_s) prvprd_open_amt_yr_s,
  		  
		SUM(fact.prvqtr_pipe_amt_day) prvqtr_pipe_amt_day,
  		SUM(fact.prvqtr_pipe_amt_wk) prvqtr_pipe_amt_wk,
  		SUM(fact.prvqtr_pipe_amt_prd) prvqtr_pipe_amt_prd,
  		SUM(fact.prvqtr_pipe_amt_qtr) prvqtr_pipe_amt_qtr,
  		SUM(fact.prvqtr_pipe_amt_yr) prvqtr_pipe_amt_yr,
        SUM(fact.prvqtr_wtd_pipe_amt_day) prvqtr_wtd_pipe_amt_day,
  		SUM(fact.prvqtr_wtd_pipe_amt_wk) prvqtr_wtd_pipe_amt_wk,
  		SUM(fact.prvqtr_wtd_pipe_amt_prd) prvqtr_wtd_pipe_amt_prd,
  		SUM(fact.prvqtr_wtd_pipe_amt_qtr) prvqtr_wtd_pipe_amt_qtr,
  		SUM(fact.prvqtr_wtd_pipe_amt_yr) prvqtr_wtd_pipe_amt_yr,
  		SUM(fact.prvqtr_open_amt_day) prvqtr_open_amt_day,
  		SUM(fact.prvqtr_open_amt_wk) prvqtr_open_amt_wk,
  		SUM(fact.prvqtr_open_amt_prd) prvqtr_open_amt_prd,
  		SUM(fact.prvqtr_open_amt_qtr) prvqtr_open_amt_qtr,
  		SUM(fact.prvqtr_open_amt_yr) prvqtr_open_amt_yr,
  		SUM(fact.prvqtr_pipe_amt_day_s) prvqtr_pipe_amt_day_s,
  		SUM(fact.prvqtr_pipe_amt_wk_s) prvqtr_pipe_amt_wk_s,
  		SUM(fact.prvqtr_pipe_amt_prd_s) prvqtr_pipe_amt_prd_s,
  		SUM(fact.prvqtr_pipe_amt_qtr_s) prvqtr_pipe_amt_qtr_s,
  		SUM(fact.prvqtr_pipe_amt_yr_s) prvqtr_pipe_amt_yr_s,
        SUM(fact.prvqtr_wtd_pipe_amt_day_s) prvqtr_wtd_pipe_amt_day_s,
  		SUM(fact.prvqtr_wtd_pipe_amt_wk_s) prvqtr_wtd_pipe_amt_wk_s,
  		SUM(fact.prvqtr_wtd_pipe_amt_prd_s) prvqtr_wtd_pipe_amt_prd_s,
  		SUM(fact.prvqtr_wtd_pipe_amt_qtr_s) prvqtr_wtd_pipe_amt_qtr_s,
  		SUM(fact.prvqtr_wtd_pipe_amt_yr_s) prvqtr_wtd_pipe_amt_yr_s,
  		SUM(fact.prvqtr_open_amt_day_s) prvqtr_open_amt_day_s,
  		SUM(fact.prvqtr_open_amt_wk_s) prvqtr_open_amt_wk_s,
  		SUM(fact.prvqtr_open_amt_prd_s) prvqtr_open_amt_prd_s,
  		SUM(fact.prvqtr_open_amt_qtr_s) prvqtr_open_amt_qtr_s,
  		SUM(fact.prvqtr_open_amt_yr_s) prvqtr_open_amt_yr_s,
  		  
		SUM(fact.prvyr_pipe_amt_day) prvyr_pipe_amt_day,
  		SUM(fact.prvyr_pipe_amt_wk) prvyr_pipe_amt_wk,
  		SUM(fact.prvyr_pipe_amt_prd) prvyr_pipe_amt_prd,
  		SUM(fact.prvyr_pipe_amt_qtr) prvyr_pipe_amt_qtr,
  		SUM(fact.prvyr_pipe_amt_yr) prvyr_pipe_amt_yr,
        SUM(fact.prvyr_wtd_pipe_amt_day) prvyr_wtd_pipe_amt_day,
  		SUM(fact.prvyr_wtd_pipe_amt_wk) prvyr_wtd_pipe_amt_wk,
  		SUM(fact.prvyr_wtd_pipe_amt_prd) prvyr_wtd_pipe_amt_prd,
  		SUM(fact.prvyr_wtd_pipe_amt_qtr) prvyr_wtd_pipe_amt_qtr,
  		SUM(fact.prvyr_wtd_pipe_amt_yr) prvyr_wtd_pipe_amt_yr,
  		SUM(fact.prvyr_open_amt_day) prvyr_open_amt_day,
  		SUM(fact.prvyr_open_amt_wk) prvyr_open_amt_wk,
  		SUM(fact.prvyr_open_amt_prd) prvyr_open_amt_prd,
  		SUM(fact.prvyr_open_amt_qtr) prvyr_open_amt_qtr,
  		SUM(fact.prvyr_open_amt_yr) prvyr_open_amt_yr,
  		SUM(fact.prvyr_pipe_amt_day_s) prvyr_pipe_amt_day_s,
  		SUM(fact.prvyr_pipe_amt_wk_s) prvyr_pipe_amt_wk_s,
  		SUM(fact.prvyr_pipe_amt_prd_s) prvyr_pipe_amt_prd_s,
  		SUM(fact.prvyr_pipe_amt_qtr_s) prvyr_pipe_amt_qtr_s,
  		SUM(fact.prvyr_pipe_amt_yr_s) prvyr_pipe_amt_yr_s,
        SUM(fact.prvyr_wtd_pipe_amt_day_s) prvyr_wtd_pipe_amt_day_s,
  		SUM(fact.prvyr_wtd_pipe_amt_wk_s) prvyr_wtd_pipe_amt_wk_s,
  		SUM(fact.prvyr_wtd_pipe_amt_prd_s) prvyr_wtd_pipe_amt_prd_s,
  		SUM(fact.prvyr_wtd_pipe_amt_qtr_s) prvyr_wtd_pipe_amt_qtr_s,
  		SUM(fact.prvyr_wtd_pipe_amt_yr_s) prvyr_wtd_pipe_amt_yr_s,
  		SUM(fact.prvyr_open_amt_day_s) prvyr_open_amt_day_s,
  		SUM(fact.prvyr_open_amt_wk_s) prvyr_open_amt_wk_s,
  		SUM(fact.prvyr_open_amt_prd_s) prvyr_open_amt_prd_s,
  		SUM(fact.prvyr_open_amt_qtr_s) prvyr_open_amt_qtr_s,
  		SUM(fact.prvyr_open_amt_yr_s) prvyr_open_amt_yr_s,	COUNT(PIPELINE_AMT_DAY) PIPELINE_AMT_DAY_XCNT,
  		COUNT(PIPELINE_AMT_WEEK) PIPELINE_AMT_WEEK_XCNT,
  		COUNT(PIPELINE_AMT_PERIOD) PIPELINE_AMT_PERIOD_XCNT ,
  		COUNT(PIPELINE_AMT_Quarter) PIPELINE_AMT_Quarter_XCNT,
  		COUNT(PIPELINE_AMT_YEAR) PIPELINE_AMT_YEAR_XCNT,
		COUNT(WTD_PIPELINE_AMT_DAY) WTD_PIPELINE_AMT_DAY_XCNT,
  		COUNT(WTD_PIPELINE_AMT_WEEK) WTD_PIPELINE_AMT_WEEK_XCNT,
  		COUNT(WTD_PIPELINE_AMT_PERIOD) WTD_PIPELINE_AMT_PERIOD_XCNT ,
  		COUNT(WTD_PIPELINE_AMT_Quarter) WTD_PIPELINE_AMT_Quarter_XCNT,
  		COUNT(WTD_PIPELINE_AMT_YEAR) WTD_PIPELINE_AMT_YEAR_XCNT,
  		
  		COUNT(OPEN_AMT_DAY) OPEN_AMT_DAY_XCNT,
  		COUNT(OPEN_AMT_WEEK) OPEN_AMT_WEEK_XCNT ,
  		COUNT(OPEN_AMT_PERIOD) OPEN_AMT_PERIOD_XCNt ,
  		COUNT(OPEN_AMT_Quarter) OPEN_AMT_Quarter_XCNT,
  		COUNT(OPEN_AMT_YEAR) OPEN_AMT_YEAR_XCNT,
  		COUNT(PIPELINE_AMT_DAY_S) PIPELINE_AMT_DAY_XCNT_S,
  		COUNT(PIPELINE_AMT_WEEK_S) PIPELINE_AMT_WEEK_XCNT_S,
  		COUNT(PIPELINE_AMT_PERIOD_S) PIPELINE_AMT_PERIOD_XCNT_S ,
  		COUNT(PIPELINE_AMT_Quarter_S) PIPELINE_AMT_Quarter_XCNT_S,
  		COUNT(PIPELINE_AMT_YEAR_S) PIPELINE_AMT_YEAR_XCNT_S,
		
		COUNT(WTD_PIPELINE_AMT_DAY_S) WTD_PIPELINE_AMT_DAY_XCNT_S,
  		COUNT(WTD_PIPELINE_AMT_WEEK_S) WTD_PIPELINE_AMT_WEEK_XCNT_S,
  		COUNT(WTD_PIPELINE_AMT_PERIOD_S) WTD_PIPELINE_AMT_PERIOD_XCNT_S ,
  		COUNT(WTD_PIPELINE_AMT_Quarter_S) WTD_PIPELINE_AMT_QTR_XCNT_S,
  		COUNT(WTD_PIPELINE_AMT_YEAR_S) WTD_PIPELINE_AMT_YEAR_XCNT_S,
  		
  		COUNT(OPEN_AMT_DAY_S) OPEN_AMT_DAY_XCNT_S,
  		COUNT(OPEN_AMT_WEEK_S) OPEN_AMT_WEEK_XCNT_S ,
  		COUNT(OPEN_AMT_PERIOD_S) OPEN_AMT_PERIOD_XCNt_S ,
  		COUNT(OPEN_AMT_Quarter_S) OPEN_AMT_Quarter_XCNT_S,
  		COUNT(OPEN_AMT_YEAR_S) OPEN_AMT_YEAR_XCNT_S,
  		
  		COUNT(prvwk_pipe_amt_day) prvwk_pipe_amt_day_xcnt,
  		COUNT(prvwk_pipe_amt_wk) prvwk_pipe_amt_wk_xcnt,
  		COUNT(prvwk_pipe_amt_prd) prvwk_pipe_amt_prd_xcnt,
  		COUNT(prvwk_pipe_amt_qtr) prvwk_pipe_amt_qtr_xcnt,
  		COUNT(prvwk_pipe_amt_yr) prvwk_pipe_amt_yr_xcnt,
        COUNT(prvwk_wtd_pipe_amt_day) prvwk_wtd_pipe_amt_day_xcnt,
  		COUNT(prvwk_wtd_pipe_amt_wk) prvwk_wtd_pipe_amt_wk_xcnt,
  		COUNT(prvwk_wtd_pipe_amt_prd) prvwk_wtd_pipe_amt_prd_xcnt,
  		COUNT(prvwk_wtd_pipe_amt_qtr) prvwk_wtd_pipe_amt_qtr_xcnt,
  		COUNT(prvwk_wtd_pipe_amt_yr) prvwk_wtd_pipe_amt_yr_xcnt,
  		COUNT(prvwk_open_amt_day) prvwk_open_amt_day_xcnt,
  		COUNT(prvwk_open_amt_wk) prvwk_open_amt_wk_xcnt,
  		COUNT(prvwk_open_amt_prd) prvwk_open_amt_prd_xcnt,
  		COUNT(prvwk_open_amt_qtr) prvwk_open_amt_qtr_xcnt,
  		COUNT(prvwk_open_amt_yr) prvwk_open_amt_yr_xcnt,
  		COUNT(prvwk_pipe_amt_day_s) prvwk_pipe_amt_day_xcnt_s,
  		COUNT(prvwk_pipe_amt_wk_s) prvwk_pipe_amt_wk_xcnt_s,
  		COUNT(prvwk_pipe_amt_prd_s) prvwk_pipe_amt_prd_xcnt_s,
  		COUNT(prvwk_pipe_amt_qtr_s) prvwk_pipe_amt_qtr_xcnt_s,
  		COUNT(prvwk_pipe_amt_yr_s) prvwk_pipe_amt_yr_xcnt_s,
        COUNT(prvwk_wtd_pipe_amt_day_s) prvwk_wtd_pipe_amt_day_xcnt_s,
  		COUNT(prvwk_wtd_pipe_amt_wk_s) prvwk_wtd_pipe_amt_wk_xcnt_s,
  		COUNT(prvwk_wtd_pipe_amt_prd_s) prvwk_wtd_pipe_amt_prd_xcnt_s,
  		COUNT(prvwk_wtd_pipe_amt_qtr_s) prvwk_wtd_pipe_amt_qtr_xcnt_s,
  		COUNT(prvwk_wtd_pipe_amt_yr_s) prvwk_wtd_pipe_amt_yr_xcnt_s,
  		COUNT(prvwk_open_amt_day_s) prvwk_open_amt_day_xcnt_s,
  		COUNT(prvwk_open_amt_wk_s) prvwk_open_amt_wk_xcnt_s,
  		COUNT(prvwk_open_amt_prd_s) prvwk_open_amt_prd_xcnt_s,
  		COUNT(prvwk_open_amt_qtr_s) prvwk_open_amt_qtr_xcnt_s,
  		COUNT(prvwk_open_amt_yr_s) prvwk_open_amt_yr_xcnt_s,
  		  
		COUNT(prvprd_pipe_amt_day) prvprd_pipe_amt_day_xcnt,
  		COUNT(prvprd_pipe_amt_wk) prvprd_pipe_amt_wk_xcnt,
  		COUNT(prvprd_pipe_amt_prd) prvprd_pipe_amt_prd_xcnt,
  		COUNT(prvprd_pipe_amt_qtr) prvprd_pipe_amt_qtr_xcnt,
  		COUNT(prvprd_pipe_amt_yr) prvprd_pipe_amt_yr_xcnt,
        COUNT(prvprd_wtd_pipe_amt_day) prvprd_wtd_pipe_amt_day_xcnt,
  		COUNT(prvprd_wtd_pipe_amt_wk) prvprd_wtd_pipe_amt_wk_xcnt,
  		COUNT(prvprd_wtd_pipe_amt_prd) prvprd_wtd_pipe_amt_prd_xcnt,
  		COUNT(prvprd_wtd_pipe_amt_qtr) prvprd_wtd_pipe_amt_qtr_xcnt,
  		COUNT(prvprd_wtd_pipe_amt_yr) prvprd_wtd_pipe_amt_yr_xcnt,
  		COUNT(prvprd_open_amt_day) prvprd_open_amt_day_xcnt,
  		COUNT(prvprd_open_amt_wk) prvprd_open_amt_wk_xcnt,
  		COUNT(prvprd_open_amt_prd) prvprd_open_amt_prd_xcnt,
  		COUNT(prvprd_open_amt_qtr) prvprd_open_amt_qtr_xcnt,
  		COUNT(prvprd_open_amt_yr) prvprd_open_amt_yr_xcnt,
  		COUNT(prvprd_pipe_amt_day_s) prvprd_pipe_amt_day_xcnt_s,
  		COUNT(prvprd_pipe_amt_wk_s) prvprd_pipe_amt_wk_xcnt_s,
  		COUNT(prvprd_pipe_amt_prd_s) prvprd_pipe_amt_prd_xcnt_s,
  		COUNT(prvprd_pipe_amt_qtr_s) prvprd_pipe_amt_qtr_xcnt_s,
  		COUNT(prvprd_pipe_amt_yr_s) prvprd_pipe_amt_yr_xcnt_s,
        COUNT(prvprd_wtd_pipe_amt_day_s) prvprd_wtd_pipe_amt_day_xcnt_s,
  		COUNT(prvprd_wtd_pipe_amt_wk_s) prvprd_wtd_pipe_amt_wk_xcnt_s,
  		COUNT(prvprd_wtd_pipe_amt_prd_s) prvprd_wtd_pipe_amt_prd_xcnt_s,
  		COUNT(prvprd_wtd_pipe_amt_qtr_s) prvprd_wtd_pipe_amt_qtr_xcnt_s,
  		COUNT(prvprd_wtd_pipe_amt_yr_s) prvprd_wtd_pipe_amt_yr_xcnt_s,
  		COUNT(prvprd_open_amt_day_s) prvprd_open_amt_day_xcnt_s,
  		COUNT(prvprd_open_amt_wk_s) prvprd_open_amt_wk_xcnt_s,
  		COUNT(prvprd_open_amt_prd_s) prvprd_open_amt_prd_xcnt_s,
  		COUNT(prvprd_open_amt_qtr_s) prvprd_open_amt_qtr_xcnt_s,
  		COUNT(prvprd_open_amt_yr_s) prvprd_open_amt_yr_xcnt_s,
  		  
		COUNT(prvqtr_pipe_amt_day) prvqtr_pipe_amt_day_xcnt,
  		COUNT(prvqtr_pipe_amt_wk) prvqtr_pipe_amt_wk_xcnt,
  		COUNT(prvqtr_pipe_amt_prd) prvqtr_pipe_amt_prd_xcnt,
  		COUNT(prvqtr_pipe_amt_qtr) prvqtr_pipe_amt_qtr_xcnt,
  		COUNT(prvqtr_pipe_amt_yr) prvqtr_pipe_amt_yr_xcnt,
        COUNT(prvqtr_wtd_pipe_amt_day) prvqtr_wtd_pipe_amt_day_xcnt,
  		COUNT(prvqtr_wtd_pipe_amt_wk) prvqtr_wtd_pipe_amt_wk_xcnt,
  		COUNT(prvqtr_wtd_pipe_amt_prd) prvqtr_wtd_pipe_amt_prd_xcnt,
  		COUNT(prvqtr_wtd_pipe_amt_qtr) prvqtr_wtd_pipe_amt_qtr_xcnt,
  		COUNT(prvqtr_wtd_pipe_amt_yr) prvqtr_wtd_pipe_amt_yr_xcnt,
  		COUNT(prvqtr_open_amt_day) prvqtr_open_amt_day_xcnt,
  		COUNT(prvqtr_open_amt_wk) prvqtr_open_amt_wk_xcnt,
  		COUNT(prvqtr_open_amt_prd) prvqtr_open_amt_prd_xcnt,
  		COUNT(prvqtr_open_amt_qtr) prvqtr_open_amt_qtr_xcnt,
  		COUNT(prvqtr_open_amt_yr) prvqtr_open_amt_yr_xcnt,
  		COUNT(prvqtr_pipe_amt_day_s) prvqtr_pipe_amt_day_xcnt_s,
  		COUNT(prvqtr_pipe_amt_wk_s) prvqtr_pipe_amt_wk_xcnt_s,
  		COUNT(prvqtr_pipe_amt_prd_s) prvqtr_pipe_amt_prd_xcnt_s,
  		COUNT(prvqtr_pipe_amt_qtr_s) prvqtr_pipe_amt_qtr_xcnt_s,
  		COUNT(prvqtr_pipe_amt_yr_s) prvqtr_pipe_amt_yr_xcnt_s,
        COUNT(prvqtr_wtd_pipe_amt_day_s) prvqtr_wtd_pipe_amt_day_xcnt_s,
  		COUNT(prvqtr_wtd_pipe_amt_wk_s) prvqtr_wtd_pipe_amt_wk_xcnt_s,
  		COUNT(prvqtr_wtd_pipe_amt_prd_s) prvqtr_wtd_pipe_amt_prd_xcnt_s,
  		COUNT(prvqtr_wtd_pipe_amt_qtr_s) prvqtr_wtd_pipe_amt_qtr_xcnt_s,
  		COUNT(prvqtr_wtd_pipe_amt_yr_s) prvqtr_wtd_pipe_amt_yr_xcnt_s,
  		COUNT(prvqtr_open_amt_day_s) prvqtr_open_amt_day_xcnt_s,
  		COUNT(prvqtr_open_amt_wk_s) prvqtr_open_amt_wk_xcnt_s,
  		COUNT(prvqtr_open_amt_prd_s) prvqtr_open_amt_prd_xcnt_s,
  		COUNT(prvqtr_open_amt_qtr_s) prvqtr_open_amt_qtr_xcnt_s,
  		COUNT(prvqtr_open_amt_yr_s) prvqtr_open_amt_yr_xcnt_s,
  		  
		COUNT(prvyr_pipe_amt_day) prvyr_pipe_amt_day_xcnt,
  		COUNT(prvyr_pipe_amt_wk) prvyr_pipe_amt_wk_xcnt,
  		COUNT(prvyr_pipe_amt_prd) prvyr_pipe_amt_prd_xcnt,
  		COUNT(prvyr_pipe_amt_qtr) prvyr_pipe_amt_qtr_xcnt,
  		COUNT(prvyr_pipe_amt_yr) prvyr_pipe_amt_yr_xcnt,
        COUNT(prvyr_wtd_pipe_amt_day) prvyr_wtd_pipe_amt_day_xcnt,
  		COUNT(prvyr_wtd_pipe_amt_wk) prvyr_wtd_pipe_amt_wk_xcnt,
  		COUNT(prvyr_wtd_pipe_amt_prd) prvyr_wtd_pipe_amt_prd_xcnt,
  		COUNT(prvyr_wtd_pipe_amt_qtr) prvyr_wtd_pipe_amt_qtr_xcnt,
  		COUNT(prvyr_wtd_pipe_amt_yr) prvyr_wtd_pipe_amt_yr_xcnt,
  		COUNT(prvyr_open_amt_day) prvyr_open_amt_day_xcnt,
  		COUNT(prvyr_open_amt_wk) prvyr_open_amt_wk_xcnt,
  		COUNT(prvyr_open_amt_prd) prvyr_open_amt_prd_xcnt,
  		COUNT(prvyr_open_amt_qtr) prvyr_open_amt_qtr_xcnt,
  		COUNT(prvyr_open_amt_yr) prvyr_open_amt_yr_xcnt,
  		COUNT(prvyr_pipe_amt_day_s) prvyr_pipe_amt_day_xcnt_s,
  		COUNT(prvyr_pipe_amt_wk_s) prvyr_pipe_amt_wk_xcnt_s,
  		COUNT(prvyr_pipe_amt_prd_s) prvyr_pipe_amt_prd_xcnt_s,
  		COUNT(prvyr_pipe_amt_qtr_s) prvyr_pipe_amt_qtr_xcnt_s,
  		COUNT(prvyr_pipe_amt_yr_s) prvyr_pipe_amt_yr_xcnt_s,
        COUNT(prvyr_wtd_pipe_amt_day_s) prvyr_wtd_pipe_amt_day_xcnt_s,
  		COUNT(prvyr_wtd_pipe_amt_wk_s) prvyr_wtd_pipe_amt_wk_xcnt_s,
  		COUNT(prvyr_wtd_pipe_amt_prd_s) prvyr_wtd_pipe_amt_prd_xcnt_s,
  		COUNT(prvyr_wtd_pipe_amt_qtr_s) prvyr_wtd_pipe_amt_qtr_xcnt_s,
  		COUNT(prvyr_wtd_pipe_amt_yr_s) prvyr_wtd_pipe_amt_yr_xcnt_s,
  		COUNT(prvyr_open_amt_day_s) prvyr_open_amt_day_xcnt_s,
  		COUNT(prvyr_open_amt_wk_s) prvyr_open_amt_wk_xcnt_s,
  		COUNT(prvyr_open_amt_prd_s) prvyr_open_amt_prd_xcnt_s,
  		COUNT(prvyr_open_amt_qtr_s) prvyr_open_amt_qtr_xcnt_s,
  		COUNT(prvyr_open_amt_yr_s) prvyr_open_amt_yr_xcnt_s,

    		grouping_id( fact.sales_group_id, fact.parent_sales_group_id, fact.salesrep_id, 
  	     	 SNAP_DATE, product_category_id,item_id) groupid,
  		COUNT(*)                        xcnt
  	FROM bil_bi_pipec_wg_mv fact
   	group by
             fact.sales_group_id,fact.salesrep_id, fact.parent_sales_group_id,
  	      	SNAP_DATE, product_category_id,item_id
          		, grp_total_flag

)