SELECT grp_total_flag,
parent_sales_group_id,
sales_group_id sales_group_id,
salesrep_id,
snap_date,
product_category_id,
item_id,
pipeline_amt_day,
pipeline_amt_week,
pipeline_amt_period,
pipeline_amt_quarter,
pipeline_amt_year,
wtd_pipeline_amt_day,
wtd_pipeline_amt_week,
wtd_pipeline_amt_period,
wtd_pipeline_amt_quarter,
wtd_pipeline_amt_year,
open_amt_day,
open_amt_week,
open_amt_period,
open_amt_quarter,
open_amt_year,
pipeline_amt_day_s,
pipeline_amt_week_s,
pipeline_amt_period_s,
pipeline_amt_quarter_s,
pipeline_amt_year_s,
wtd_pipeline_amt_day_s,
wtd_pipeline_amt_week_s,
wtd_pipeline_amt_period_s,
wtd_pipeline_amt_quarter_s,
wtd_pipeline_amt_year_s,
open_amt_day_s,
open_amt_week_s,
open_amt_period_s,
open_amt_quarter_s,
open_amt_year_s
FROM BIL_BI_PIPEC_G_MV
UNION ALL
SELECT grp_total_flag,
parent_sales_group_id,
sales_group_id sales_group_id,
salesrep_id,
snap_date,
product_category_id,
item_id,
pipeline_amt_day,
pipeline_amt_week,
pipeline_amt_period,
pipeline_amt_quarter,
pipeline_amt_year,
wtd_pipeline_amt_day,
wtd_pipeline_amt_week,
wtd_pipeline_amt_period,
wtd_pipeline_amt_quarter,
wtd_pipeline_amt_year,
open_amt_day,
open_amt_week,
open_amt_period,
open_amt_quarter,
open_amt_year,
pipeline_amt_day_s,
pipeline_amt_week_s,
pipeline_amt_period_s,
pipeline_amt_quarter_s,
pipeline_amt_year_s,
wtd_pipeline_amt_day_s,
wtd_pipeline_amt_week_s,
wtd_pipeline_amt_period_s,
wtd_pipeline_amt_quarter_s,
wtd_pipeline_amt_year_s,
open_amt_day_s,
open_amt_week_s,
open_amt_period_s,
open_amt_quarter_s,
open_amt_year_s
FROM BIL_BI_PIPE_G_MV
SELECT GRP_TOTAL_FLAG
,
PARENT_SALES_GROUP_ID
,
SALES_GROUP_ID SALES_GROUP_ID
,
SALESREP_ID
,
SNAP_DATE
,
PRODUCT_CATEGORY_ID
,
ITEM_ID
,
PIPELINE_AMT_DAY
,
PIPELINE_AMT_WEEK
,
PIPELINE_AMT_PERIOD
,
PIPELINE_AMT_QUARTER
,
PIPELINE_AMT_YEAR
,
WTD_PIPELINE_AMT_DAY
,
WTD_PIPELINE_AMT_WEEK
,
WTD_PIPELINE_AMT_PERIOD
,
WTD_PIPELINE_AMT_QUARTER
,
WTD_PIPELINE_AMT_YEAR
,
OPEN_AMT_DAY
,
OPEN_AMT_WEEK
,
OPEN_AMT_PERIOD
,
OPEN_AMT_QUARTER
,
OPEN_AMT_YEAR
,
PIPELINE_AMT_DAY_S
,
PIPELINE_AMT_WEEK_S
,
PIPELINE_AMT_PERIOD_S
,
PIPELINE_AMT_QUARTER_S
,
PIPELINE_AMT_YEAR_S
,
WTD_PIPELINE_AMT_DAY_S
,
WTD_PIPELINE_AMT_WEEK_S
,
WTD_PIPELINE_AMT_PERIOD_S
,
WTD_PIPELINE_AMT_QUARTER_S
,
WTD_PIPELINE_AMT_YEAR_S
,
OPEN_AMT_DAY_S
,
OPEN_AMT_WEEK_S
,
OPEN_AMT_PERIOD_S
,
OPEN_AMT_QUARTER_S
,
OPEN_AMT_YEAR_S
FROM BIL_BI_PIPEC_G_MV
UNION ALL
SELECT GRP_TOTAL_FLAG
,
PARENT_SALES_GROUP_ID
,
SALES_GROUP_ID SALES_GROUP_ID
,
SALESREP_ID
,
SNAP_DATE
,
PRODUCT_CATEGORY_ID
,
ITEM_ID
,
PIPELINE_AMT_DAY
,
PIPELINE_AMT_WEEK
,
PIPELINE_AMT_PERIOD
,
PIPELINE_AMT_QUARTER
,
PIPELINE_AMT_YEAR
,
WTD_PIPELINE_AMT_DAY
,
WTD_PIPELINE_AMT_WEEK
,
WTD_PIPELINE_AMT_PERIOD
,
WTD_PIPELINE_AMT_QUARTER
,
WTD_PIPELINE_AMT_YEAR
,
OPEN_AMT_DAY
,
OPEN_AMT_WEEK
,
OPEN_AMT_PERIOD
,
OPEN_AMT_QUARTER
,
OPEN_AMT_YEAR
,
PIPELINE_AMT_DAY_S
,
PIPELINE_AMT_WEEK_S
,
PIPELINE_AMT_PERIOD_S
,
PIPELINE_AMT_QUARTER_S
,
PIPELINE_AMT_YEAR_S
,
WTD_PIPELINE_AMT_DAY_S
,
WTD_PIPELINE_AMT_WEEK_S
,
WTD_PIPELINE_AMT_PERIOD_S
,
WTD_PIPELINE_AMT_QUARTER_S
,
WTD_PIPELINE_AMT_YEAR_S
,
OPEN_AMT_DAY_S
,
OPEN_AMT_WEEK_S
,
OPEN_AMT_PERIOD_S
,
OPEN_AMT_QUARTER_S
,
OPEN_AMT_YEAR_S
FROM BIL_BI_PIPE_G_MV
|
|
|