VIEW: APPS.BIL_OBI_OPTY_PIPE_PG_V

Source

View Text - Preformatted

SELECT EFFECTIVE_TIME_ID, PARENT_SALES_GROUP_ID, SALES_GROUP_ID, SALESREP_ID, PRODUCT_CATEGORY_ID, ITEM_ID, ROLLUP_FLAG, PIPELINE_AMT, WTD_PIPELINE_AMT, OPEN_AMT, PERIOD_OPEN_AMT, PIPELINE_AMT_S, WTD_PIPELINE_AMT_S, OPEN_AMT_S, PERIOD_OPEN_AMT_S, NULL WON_OPTY_AMT, NULL LOST_OPTY_AMT, NULL NO_OPTY_AMT, NULL NEW_OPTY_AMT, NULL CNV_OPTY_AMT, NULL NFP_YR, NULL NFP_QTR, NULL NFP_PER, NULL WON_OPTY_AMT_S, NULL LOST_OPTY_AMT_S, NULL NO_OPTY_AMT_S, NULL NEW_OPTY_AMT_S, NULL CNV_OPTY_AMT_S, NULL NFP_YR_S, NULL NFP_QTR_S, NULL NFP_PER_S FROM BIL_OBI_PIPE_G_MV SUMRY UNION ALL SELECT EFFECTIVE_TIME_ID, PARENT_SALES_GROUP_ID, SALES_GROUP_ID, SALESREP_ID, PRODUCT_CATEGORY_ID, ITEM_ID, ROLLUP_FLAG, NULL PIPELINE_AMT, NULL WTD_PIPELINE_AMT, NULL OPEN_AMT, NULL PERIOD_OPEN_AMT, NULL PIPELINE_AMT_S, NULL WTD_PIPELINE_AMT_S, NULL OPEN_AMT_S, NULL PERIOD_OPEN_AMT_S, WON_OPTY_AMT, LOST_OPTY_AMT, NO_OPTY_AMT, NEW_OPTY_AMT, CNV_OPTY_AMT, NFP_YR, NFP_QTR, NFP_PER, WON_OPTY_AMT_S, LOST_OPTY_AMT_S, NO_OPTY_AMT_S, NEW_OPTY_AMT_S, CNV_OPTY_AMT_S, NFP_YR_S, NFP_QTR_S, NFP_PER_S FROM BIL_OBI_OPTY_PG_MV SUMRY WITH READ ONLY

View Text - HTML Formatted

SELECT EFFECTIVE_TIME_ID
, PARENT_SALES_GROUP_ID
, SALES_GROUP_ID
, SALESREP_ID
, PRODUCT_CATEGORY_ID
, ITEM_ID
, ROLLUP_FLAG
, PIPELINE_AMT
, WTD_PIPELINE_AMT
, OPEN_AMT
, PERIOD_OPEN_AMT
, PIPELINE_AMT_S
, WTD_PIPELINE_AMT_S
, OPEN_AMT_S
, PERIOD_OPEN_AMT_S
, NULL WON_OPTY_AMT
, NULL LOST_OPTY_AMT
, NULL NO_OPTY_AMT
, NULL NEW_OPTY_AMT
, NULL CNV_OPTY_AMT
, NULL NFP_YR
, NULL NFP_QTR
, NULL NFP_PER
, NULL WON_OPTY_AMT_S
, NULL LOST_OPTY_AMT_S
, NULL NO_OPTY_AMT_S
, NULL NEW_OPTY_AMT_S
, NULL CNV_OPTY_AMT_S
, NULL NFP_YR_S
, NULL NFP_QTR_S
, NULL NFP_PER_S
FROM BIL_OBI_PIPE_G_MV SUMRY UNION ALL SELECT EFFECTIVE_TIME_ID
, PARENT_SALES_GROUP_ID
, SALES_GROUP_ID
, SALESREP_ID
, PRODUCT_CATEGORY_ID
, ITEM_ID
, ROLLUP_FLAG
, NULL PIPELINE_AMT
, NULL WTD_PIPELINE_AMT
, NULL OPEN_AMT
, NULL PERIOD_OPEN_AMT
, NULL PIPELINE_AMT_S
, NULL WTD_PIPELINE_AMT_S
, NULL OPEN_AMT_S
, NULL PERIOD_OPEN_AMT_S
, WON_OPTY_AMT
, LOST_OPTY_AMT
, NO_OPTY_AMT
, NEW_OPTY_AMT
, CNV_OPTY_AMT
, NFP_YR
, NFP_QTR
, NFP_PER
, WON_OPTY_AMT_S
, LOST_OPTY_AMT_S
, NO_OPTY_AMT_S
, NEW_OPTY_AMT_S
, CNV_OPTY_AMT_S
, NFP_YR_S
, NFP_QTR_S
, NFP_PER_S
FROM BIL_OBI_OPTY_PG_MV SUMRY WITH READ ONLY