[Home] [Help]
View: BIL_BI_PIPE_G_V
| Product: | FND - Application Object Library |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
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