Skip to content

DBA Data[Home] [Help] [Dependency Information]

TABLE: APPS.BIL_BI_PIPEC_G_MV

Object Details
Object Name: BIL_BI_PIPEC_G_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_BIL_BI_PIPEC_G_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("SALES_GROUP_ID")
ColumnSYS_OP_MAP_NONNULL("SALESREP_ID")
ColumnSYS_OP_MAP_NONNULL("PARENT_SALES_GROUP_ID")
ColumnSYS_OP_MAP_NONNULL("SNAP_DATE")
ColumnSYS_OP_MAP_NONNULL("PRODUCT_CATEGORY_ID")
ColumnSYS_OP_MAP_NONNULL("ITEM_ID")
ColumnSYS_OP_MAP_NONNULL("GRP_TOTAL_FLAG")
BIL_BI_PIPEC_G_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnSNAP_DATE
ColumnGRP_TOTAL_FLAG
ColumnPARENT_SALES_GROUP_ID
ColumnSALES_GROUP_ID
ColumnSALESREP_ID
BIL_BI_PIPEC_G_MV_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnSNAP_DATE
ColumnGRP_TOTAL_FLAG
ColumnPARENT_SALES_GROUP_ID
ColumnPRODUCT_CATEGORY_ID
ColumnSALES_GROUP_ID
ColumnSALESREP_ID
ColumnITEM_ID
Columns
Name Datatype Length Mandatory Comments
GRP_TOTAL_FLAG NUMBER

Marker for granularity. 1 for group, 0 for group and product category
PARENT_SALES_GROUP_ID NUMBER

Parent group identifier for the sales group.
SALES_GROUP_ID NUMBER

Sales group identifier who gets the sales credits.
SALESREP_ID NUMBER

Salesperson or resource identifier who gets sales credits. Will never be null.
SNAP_DATE DATE

The date that snap shot is taken.
PRODUCT_CATEGORY_ID NUMBER

The product category to which the item in this sales credit line belongs to.
ITEM_ID NUMBER

The concatenated value of item and the master org id. If the opportunity line is assigned to category then -1.
PIPELINE_AMT_DAY NUMBER

Sum of pipeline amounts if the opty is closed in the same day in Primary currency.
PIPELINE_AMT_WEEK NUMBER

Sum of pipeline amounts if the opty is closed in the same week in Primary currency.
PIPELINE_AMT_PERIOD NUMBER

Sum of pipeline amounts if the opty is closed in the same period in Primary currency.
PIPELINE_AMT_QUARTER NUMBER

Sum of pipeline amounts if the opty is closed in the same quarter in Primary currency.
PIPELINE_AMT_YEAR NUMBER

Sum of pipeline amounts if the opty is closed in the same year in Primary currency.
WTD_PIPELINE_AMT_DAY NUMBER

Sum of total weighted pipeline amounts if the opty is closed in the same day in primary currency.
WTD_PIPELINE_AMT_WEEK NUMBER

Sum of total weighted pipeline amounts if the opty is closed in the same week in primary currency.
WTD_PIPELINE_AMT_PERIOD NUMBER

Sum of total weighted pipeline amounts if the opty is closed in the same period in primary currency.
WTD_PIPELINE_AMT_QUARTER NUMBER

Sum of total weighted pipeline amounts if the opty is closed in the same quarter in primary currency.
WTD_PIPELINE_AMT_YEAR NUMBER

Sum of total weighted pipeline amounts if the opty is closed in the same year in primary currency.
OPEN_AMT_DAY NUMBER

Sum of open amounts if the opty is closed in the same day in Primary currency.
OPEN_AMT_WEEK NUMBER

Sum of open amounts if the opty is closed in the same week in Primary currency.
OPEN_AMT_PERIOD NUMBER

Sum of open amounts if the opty is closed in the same period in Primary currency.
OPEN_AMT_QUARTER NUMBER

Sum of open amounts if the opty is closed in the same quarter in Primary currency.
OPEN_AMT_YEAR NUMBER

Sum of open amounts if the opty is closed in the same year in Primary currency.
PIPELINE_AMT_DAY_S NUMBER

Sum of pipeline amounts if the opty is closed in the same day in secondary currency.
PIPELINE_AMT_WEEK_S NUMBER

Sum of pipeline amounts if the opty is closed in the same week in secondary currency.
PIPELINE_AMT_PERIOD_S NUMBER

Sum of pipeline amounts if the opty is closed in the same period in secondary currency.
PIPELINE_AMT_QUARTER_S NUMBER

Sum of pipeline amounts if the opty is closed in the same quarter in secondary currency.
PIPELINE_AMT_YEAR_S NUMBER

Sum of pipeline amounts if the opty is closed in the same year in secondary currency.
WTD_PIPELINE_AMT_DAY_S NUMBER

Sum of total weighted pipeline amounts if the opty is closed in the same day in secondary currency.
WTD_PIPELINE_AMT_WEEK_S NUMBER

Sum of total weighted pipeline amounts if the opty is closed in the same week in secondary currency.
WTD_PIPELINE_AMT_PERIOD_S NUMBER

Sum of total weighted pipeline amounts if the opty is closed in the same period in secondary currency.
WTD_PIPELINE_AMT_QUARTER_S NUMBER

Sum of total weighted pipeline amounts if the opty is closed in the same quarter in secondary currency.
WTD_PIPELINE_AMT_YEAR_S NUMBER

Sum of total weighted pipeline amounts if the opty is closed in the same year in secondary currency.
OPEN_AMT_DAY_S NUMBER

Sum of open amounts if the opty is closed in the same day in secondary currency.
OPEN_AMT_WEEK_S NUMBER

Sum of open amounts if the opty is closed in the same week in secondary currency.
OPEN_AMT_PERIOD_S NUMBER

Sum of open amounts if the opty is closed in the same period in secondary currency.
OPEN_AMT_QUARTER_S NUMBER

Sum of open amounts if the opty is closed in the same quarter in secondary currency.
OPEN_AMT_YEAR_S NUMBER

Sum of open amounts if the opty is closed in the same year in secondary currency.
PRVWK_PIPE_AMT_DAY NUMBER

Sum of previous week pipeline amounts if the opty is closed in the same day in Primary currency.
PRVWK_PIPE_AMT_WK NUMBER

Sum of previous week pipeline amounts if the opty is closed in the same week in Primary currency.
PRVWK_PIPE_AMT_PRD NUMBER

Sum of previous week pipeline amounts if the opty is closed in the same period in Primary currency.
PRVWK_PIPE_AMT_QTR NUMBER

Sum of previous week pipeline amounts if the opty is closed in the same quarter in Primary currency.
PRVWK_PIPE_AMT_YR NUMBER

Sum of previous week pipeline amounts if the opty is closed in the same year in Primary currency.
PRVWK_WTD_PIPE_AMT_DAY NUMBER

Sum of previous week weighted pipeline amounts if the opty is closed in the same day in Primary currency.
PRVWK_WTD_PIPE_AMT_WK NUMBER

Sum of previous week weighted pipeline amounts if the opty is closed in the same week in Primary currency.
PRVWK_WTD_PIPE_AMT_PRD NUMBER

Sum of previous week weighted pipeline amounts if the opty is closed in the same period in Primary currency.
PRVWK_WTD_PIPE_AMT_QTR NUMBER

Sum of previous week weighted pipeline amounts if the opty is closed in the same quarter in Primary currency.
PRVWK_WTD_PIPE_AMT_YR NUMBER

Sum of previous week weighted pipeline amounts if the opty is closed in the same year in Primary currency.
PRVWK_OPEN_AMT_DAY NUMBER

Sum of previous week open amounts if the opty is closed in the same day in Primary currency.
PRVWK_OPEN_AMT_WK NUMBER

Sum of previous week open amounts if the opty is closed in the same week in Primary currency.
PRVWK_OPEN_AMT_PRD NUMBER

Sum of previous week open amounts if the opty is closed in the same period in Primary currency.
PRVWK_OPEN_AMT_QTR NUMBER

Sum of previous week open amounts if the opty is closed in the same quarter in Primary currency.
PRVWK_OPEN_AMT_YR NUMBER

Sum of previous week open amounts if the opty is closed in the same year in Primary currency.
PRVWK_PIPE_AMT_DAY_S NUMBER

Sum of previous week pipeline amounts if the opty is closed in the same day in Secondary currency.
PRVWK_PIPE_AMT_WK_S NUMBER

Sum of previous week pipeline amounts if the opty is closed in the same week in Secondary currency.
PRVWK_PIPE_AMT_PRD_S NUMBER

Sum of previous week pipeline amounts if the opty is closed in the same period in Secondary currency.
PRVWK_PIPE_AMT_QTR_S NUMBER

Sum of previous week pipeline amounts if the opty is closed in the same quarter in Secondary currency.
PRVWK_PIPE_AMT_YR_S NUMBER

Sum of previous week pipeline amounts if the opty is closed in the same year in Secondary currency.
PRVWK_WTD_PIPE_AMT_DAY_S NUMBER

Sum of previous week weighted pipeline amounts if the opty is closed in the same day in Secondary currency.
PRVWK_WTD_PIPE_AMT_WK_S NUMBER

Sum of previous week weighted pipeline amounts if the opty is closed in the same week in Secondary currency.
PRVWK_WTD_PIPE_AMT_PRD_S NUMBER

Sum of previous week weighted pipeline amounts if the opty is closed in the same period in Secondary currency.
PRVWK_WTD_PIPE_AMT_QTR_S NUMBER

Sum of previous week weighted pipeline amounts if the opty is closed in the same quarter in Secondary currency.
PRVWK_WTD_PIPE_AMT_YR_S NUMBER

Sum of previous week weighted pipeline amounts if the opty is closed in the same year in Secondary currency.
PRVWK_OPEN_AMT_DAY_S NUMBER

Sum of previous week open amounts if the opty is closed in the same day in Secondary currency.
PRVWK_OPEN_AMT_WK_S NUMBER

Sum of previous week open amounts if the opty is closed in the same week in Secondary currency.
PRVWK_OPEN_AMT_PRD_S NUMBER

Sum of previous week open amounts if the opty is closed in the same period in Secondary currency.
PRVWK_OPEN_AMT_QTR_S NUMBER

Sum of previous week open amounts if the opty is closed in the same quarter in Secondary currency.
PRVWK_OPEN_AMT_YR_S NUMBER

Sum of previous week open amounts if the opty is closed in the same year in Secondary currency.
PRVPRD_PIPE_AMT_DAY NUMBER

Sum of previous period pipeline amounts if the opty is closed in the same day in Primary currency.
PRVPRD_PIPE_AMT_WK NUMBER

Sum of previous period pipeline amounts if the opty is closed in the same week in Primary currency.
PRVPRD_PIPE_AMT_PRD NUMBER

Sum of previous period pipeline amounts if the opty is closed in the same period in Primary currency.
PRVPRD_PIPE_AMT_QTR NUMBER

Sum of previous period pipeline amounts if the opty is closed in the same quarter in Primary currency.
PRVPRD_PIPE_AMT_YR NUMBER

Sum of previous period pipeline amounts if the opty is closed in the same year in Primary currency.
PRVPRD_WTD_PIPE_AMT_DAY NUMBER

Sum of previous period weighted pipeline amounts if the opty is closed in the same day in Primary currency.
PRVPRD_WTD_PIPE_AMT_WK NUMBER

Sum of previous period weighted pipeline amounts if the opty is closed in the same week in Primary currency.
PRVPRD_WTD_PIPE_AMT_PRD NUMBER

Sum of previous period weighted pipeline amounts if the opty is closed in the same period in Primary currency.
PRVPRD_WTD_PIPE_AMT_QTR NUMBER

Sum of previous period weighted pipeline amounts if the opty is closed in the same quarter in Primary currency.
PRVPRD_WTD_PIPE_AMT_YR NUMBER

Sum of previous period weighted pipeline amounts if the opty is closed in the same year in Primary currency.
PRVPRD_OPEN_AMT_DAY NUMBER

Sum of previous period open amounts if the opty is closed in the same day in Primary currency.
PRVPRD_OPEN_AMT_WK NUMBER

Sum of previous period open amounts if the opty is closed in the same week in Primary currency.
PRVPRD_OPEN_AMT_PRD NUMBER

Sum of previous period open amounts if the opty is closed in the same period in Primary currency.
PRVPRD_OPEN_AMT_QTR NUMBER

Sum of previous period open amounts if the opty is closed in the same quarter in Primary currency.
PRVPRD_OPEN_AMT_YR NUMBER

Sum of previous period open amounts if the opty is closed in the same year in Primary currency.
PRVPRD_PIPE_AMT_DAY_S NUMBER

Sum of previous period pipeline amounts if the opty is closed in the same day in Secondary currency.
PRVPRD_PIPE_AMT_WK_S NUMBER

Sum of previous period pipeline amounts if the opty is closed in the same week in Secondary currency.
PRVPRD_PIPE_AMT_PRD_S NUMBER

Sum of previous period pipeline amounts if the opty is closed in the same period in Secondary currency.
PRVPRD_PIPE_AMT_QTR_S NUMBER

Sum of previous period pipeline amounts if the opty is closed in the same quarter in Secondary currency.
PRVPRD_PIPE_AMT_YR_S NUMBER

Sum of previous period pipeline amounts if the opty is closed in the same year in Secondary currency.
PRVPRD_WTD_PIPE_AMT_DAY_S NUMBER

Sum of previous period weighted pipeline amounts if the opty is closed in the same day in Secondary currency.
PRVPRD_WTD_PIPE_AMT_WK_S NUMBER

Sum of previous period weighted pipeline amounts if the opty is closed in the same week in Secondary currency.
PRVPRD_WTD_PIPE_AMT_PRD_S NUMBER

Sum of previous period weighted pipeline amounts if the opty is closed in the same period in Secondary currency.
PRVPRD_WTD_PIPE_AMT_QTR_S NUMBER

Sum of previous period weighted pipeline amounts if the opty is closed in the same quarter in Secondary currency.
PRVPRD_WTD_PIPE_AMT_YR_S NUMBER

Sum of previous period weighted pipeline amounts if the opty is closed in the same year in Secondary currency.
PRVPRD_OPEN_AMT_DAY_S NUMBER

Sum of previous period open amounts if the opty is closed in the same day in Secondary currency.
PRVPRD_OPEN_AMT_WK_S NUMBER

Sum of previous period open amounts if the opty is closed in the same week in Secondary currency.
PRVPRD_OPEN_AMT_PRD_S NUMBER

Sum of previous period open amounts if the opty is closed in the same period in Secondary currency.
PRVPRD_OPEN_AMT_QTR_S NUMBER

Sum of previous period open amounts if the opty is closed in the same quarter in Secondary currency.
PRVPRD_OPEN_AMT_YR_S NUMBER

Sum of previous period open amounts if the opty is closed in the same year in Secondary currency.
PRVQTR_PIPE_AMT_DAY NUMBER

Sum of previous quarter pipeline amounts if the opty is closed in the same day in Primary currency.
PRVQTR_PIPE_AMT_WK NUMBER

Sum of previous quarter pipeline amounts if the opty is closed in the same week in Primary currency.
PRVQTR_PIPE_AMT_PRD NUMBER

Sum of previous quarter pipeline amounts if the opty is closed in the same period in Primary currency.
PRVQTR_PIPE_AMT_QTR NUMBER

Sum of previous quarter pipeline amounts if the opty is closed in the same quarter in Primary currency.
PRVQTR_PIPE_AMT_YR NUMBER

Sum of previous quarter pipeline amounts if the opty is closed in the same year in Primary currency.
PRVQTR_WTD_PIPE_AMT_DAY NUMBER

Sum of previous quarter weighted pipeline amounts if the opty is closed in the same day in Primary currency.
PRVQTR_WTD_PIPE_AMT_WK NUMBER

Sum of previous quarter weighted pipeline amounts if the opty is closed in the same week in Primary currency.
PRVQTR_WTD_PIPE_AMT_PRD NUMBER

Sum of previous quarter weighted pipeline amounts if the opty is closed in the same period in Primary currency.
PRVQTR_WTD_PIPE_AMT_QTR NUMBER

Sum of previous quarter weighted pipeline amounts if the opty is closed in the same quarter in Primary currency.
PRVQTR_WTD_PIPE_AMT_YR NUMBER

Sum of previous quarter weighted pipeline amounts if the opty is closed in the same year in Primary currency.
PRVQTR_OPEN_AMT_DAY NUMBER

Sum of previous quarter open amounts if the opty is closed in the same day in Primary currency.
PRVQTR_OPEN_AMT_WK NUMBER

Sum of previous quarter open amounts if the opty is closed in the same week in Primary currency.
PRVQTR_OPEN_AMT_PRD NUMBER

Sum of previous quarter open amounts if the opty is closed in the same period in Primary currency.
PRVQTR_OPEN_AMT_QTR NUMBER

Sum of previous quarter open amounts if the opty is closed in the same quarter in Primary currency.
PRVQTR_OPEN_AMT_YR NUMBER

Sum of previous quarter open amounts if the opty is closed in the same year in Primary currency.
PRVQTR_PIPE_AMT_DAY_S NUMBER

Sum of previous quarter pipeline amounts if the opty is closed in the same day in Secondary currency.
PRVQTR_PIPE_AMT_WK_S NUMBER

Sum of previous quarter pipeline amounts if the opty is closed in the same week in Secondary currency.
PRVQTR_PIPE_AMT_PRD_S NUMBER

Sum of previous quarter pipeline amounts if the opty is closed in the same period in Secondary currency.
PRVQTR_PIPE_AMT_QTR_S NUMBER

Sum of previous quarter pipeline amounts if the opty is closed in the same quarter in Secondary currency.
PRVQTR_PIPE_AMT_YR_S NUMBER

Sum of previous quarter pipeline amounts if the opty is closed in the same year in Secondary currency.
PRVQTR_WTD_PIPE_AMT_DAY_S NUMBER

Sum of previous quarter weighted pipeline amounts if the opty is closed in the same day in Secondary currency.
PRVQTR_WTD_PIPE_AMT_WK_S NUMBER

Sum of previous quarter weighted pipeline amounts if the opty is closed in the same week in Secondary currency.
PRVQTR_WTD_PIPE_AMT_PRD_S NUMBER

Sum of previous quarter weighted pipeline amounts if the opty is closed in the same period in Secondary currency.
PRVQTR_WTD_PIPE_AMT_QTR_S NUMBER

Sum of previous quarter weighted pipeline amounts if the opty is closed in the same quarter in Secondary currency.
PRVQTR_WTD_PIPE_AMT_YR_S NUMBER

Sum of previous quarter weighted pipeline amounts if the opty is closed in the same year in Secondary currency.
PRVQTR_OPEN_AMT_DAY_S NUMBER

Sum of previous quarter open amounts if the opty is closed in the same day in Secondary currency.
PRVQTR_OPEN_AMT_WK_S NUMBER

Sum of previous quarter open amounts if the opty is closed in the same week in Secondary currency.
PRVQTR_OPEN_AMT_PRD_S NUMBER

Sum of previous quarter open amounts if the opty is closed in the same period in Secondary currency.
PRVQTR_OPEN_AMT_QTR_S NUMBER

Sum of previous quarter open amounts if the opty is closed in the same quarter in Secondary currency.
PRVQTR_OPEN_AMT_YR_S NUMBER

Sum of previous quarter open amounts if the opty is closed in the same year in Secondary currency.
PRVYR_PIPE_AMT_DAY NUMBER

Sum of previous year pipeline amounts if the opty is closed in the same day in Primary currency.
PRVYR_PIPE_AMT_WK NUMBER

Sum of previous year pipeline amounts if the opty is closed in the same week in Primary currency.
PRVYR_PIPE_AMT_PRD NUMBER

Sum of previous year pipeline amounts if the opty is closed in the same period in Primary currency.
PRVYR_PIPE_AMT_QTR NUMBER

Sum of previous year pipeline amounts if the opty is closed in the same quarter in Primary currency.
PRVYR_PIPE_AMT_YR NUMBER

Sum of previous year pipeline amounts if the opty is closed in the same year in Primary currency.
PRVYR_WTD_PIPE_AMT_DAY NUMBER

Sum of previous year weighted pipeline amounts if the opty is closed in the same day in Primary currency.
PRVYR_WTD_PIPE_AMT_WK NUMBER

Sum of previous year weighted pipeline amounts if the opty is closed in the same week in Primary currency.
PRVYR_WTD_PIPE_AMT_PRD NUMBER

Sum of previous year weighted pipeline amounts if the opty is closed in the same period in Primary currency.
PRVYR_WTD_PIPE_AMT_QTR NUMBER

Sum of previous year weighted pipeline amounts if the opty is closed in the same quarter in Primary currency.
PRVYR_WTD_PIPE_AMT_YR NUMBER

Sum of previous year weighted pipeline amounts if the opty is closed in the same year in Primary currency.
PRVYR_OPEN_AMT_DAY NUMBER

Sum of previous year open amounts if the opty is closed in the same day in Primary currency.
PRVYR_OPEN_AMT_WK NUMBER

Sum of previous year open amounts if the opty is closed in the same week in Primary currency.
PRVYR_OPEN_AMT_PRD NUMBER

Sum of previous year open amounts if the opty is closed in the same period in Primary currency.
PRVYR_OPEN_AMT_QTR NUMBER

Sum of previous year open amounts if the opty is closed in the same quarter in Primary currency.
PRVYR_OPEN_AMT_YR NUMBER

Sum of previous year open amounts if the opty is closed in the same year in Primary currency.
PRVYR_PIPE_AMT_DAY_S NUMBER

Sum of previous year pipeline amounts if the opty is closed in the same day in Secondary currency.
PRVYR_PIPE_AMT_WK_S NUMBER

Sum of previous year pipeline amounts if the opty is closed in the same week in Secondary currency.
PRVYR_PIPE_AMT_PRD_S NUMBER

Sum of previous year pipeline amounts if the opty is closed in the same period in Secondary currency.
PRVYR_PIPE_AMT_QTR_S NUMBER

Sum of previous year pipeline amounts if the opty is closed in the same quarter in Secondary currency.
PRVYR_PIPE_AMT_YR_S NUMBER

Sum of previous year pipeline amounts if the opty is closed in the same year in Secondary currency.
PRVYR_WTD_PIPE_AMT_DAY_S NUMBER

Sum of previous year weighted pipeline amounts if the opty is closed in the same day in Secondary currency.
PRVYR_WTD_PIPE_AMT_WK_S NUMBER

Sum of previous year weighted pipeline amounts if the opty is closed in the same week in Secondary currency.
PRVYR_WTD_PIPE_AMT_PRD_S NUMBER

Sum of previous year weighted pipeline amounts if the opty is closed in the same period in Secondary currency.
PRVYR_WTD_PIPE_AMT_QTR_S NUMBER

Sum of previous year weighted pipeline amounts if the opty is closed in the same quarter in Secondary currency.
PRVYR_WTD_PIPE_AMT_YR_S NUMBER

Sum of previous year weighted pipeline amounts if the opty is closed in the same year in Secondary currency.
PRVYR_OPEN_AMT_DAY_S NUMBER

Sum of previous year open amounts if the opty is closed in the same day in Secondary currency.
PRVYR_OPEN_AMT_WK_S NUMBER

Sum of previous year open amounts if the opty is closed in the same week in Secondary currency.
PRVYR_OPEN_AMT_PRD_S NUMBER

Sum of previous year open amounts if the opty is closed in the same period in Secondary currency.
PRVYR_OPEN_AMT_QTR_S NUMBER

Sum of previous year open amounts if the opty is closed in the same quarter in Secondary currency.
PRVYR_OPEN_AMT_YR_S NUMBER

Sum of previous year open amounts if the opty is closed in the same year in Secondary currency.
PIPELINE_AMT_DAY_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PIPELINE_AMT_WEEK_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PIPELINE_AMT_PERIOD_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PIPELINE_AMT_QUARTER_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PIPELINE_AMT_YEAR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
WTD_PIPELINE_AMT_DAY_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
WTD_PIPELINE_AMT_WEEK_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
WTD_PIPELINE_AMT_PERIOD_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
WTD_PIPELINE_AMT_QUARTER_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
WTD_PIPELINE_AMT_YEAR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
OPEN_AMT_DAY_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
OPEN_AMT_WEEK_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
OPEN_AMT_PERIOD_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
OPEN_AMT_QUARTER_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
OPEN_AMT_YEAR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PIPELINE_AMT_DAY_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PIPELINE_AMT_WEEK_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PIPELINE_AMT_PERIOD_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PIPELINE_AMT_QUARTER_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PIPELINE_AMT_YEAR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
WTD_PIPELINE_AMT_DAY_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
WTD_PIPELINE_AMT_WEEK_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
WTD_PIPELINE_AMT_PERIOD_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
WTD_PIPELINE_AMT_QTR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
WTD_PIPELINE_AMT_YEAR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
OPEN_AMT_DAY_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
OPEN_AMT_WEEK_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
OPEN_AMT_PERIOD_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
OPEN_AMT_QUARTER_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
OPEN_AMT_YEAR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_PIPE_AMT_DAY_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_PIPE_AMT_WK_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_PIPE_AMT_PRD_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_PIPE_AMT_QTR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_PIPE_AMT_YR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_WTD_PIPE_AMT_DAY_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_WTD_PIPE_AMT_WK_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_WTD_PIPE_AMT_PRD_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_WTD_PIPE_AMT_QTR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_WTD_PIPE_AMT_YR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_OPEN_AMT_DAY_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_OPEN_AMT_WK_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_OPEN_AMT_PRD_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_OPEN_AMT_QTR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_OPEN_AMT_YR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_PIPE_AMT_DAY_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_PIPE_AMT_WK_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_PIPE_AMT_PRD_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_PIPE_AMT_QTR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_PIPE_AMT_YR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_WTD_PIPE_AMT_DAY_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_WTD_PIPE_AMT_WK_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_WTD_PIPE_AMT_PRD_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_WTD_PIPE_AMT_QTR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_WTD_PIPE_AMT_YR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_OPEN_AMT_DAY_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_OPEN_AMT_WK_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_OPEN_AMT_PRD_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_OPEN_AMT_QTR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVWK_OPEN_AMT_YR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_PIPE_AMT_DAY_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_PIPE_AMT_WK_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_PIPE_AMT_PRD_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_PIPE_AMT_QTR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_PIPE_AMT_YR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_WTD_PIPE_AMT_DAY_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_WTD_PIPE_AMT_WK_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_WTD_PIPE_AMT_PRD_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_WTD_PIPE_AMT_QTR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_WTD_PIPE_AMT_YR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_OPEN_AMT_DAY_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_OPEN_AMT_WK_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_OPEN_AMT_PRD_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_OPEN_AMT_QTR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_OPEN_AMT_YR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_PIPE_AMT_DAY_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_PIPE_AMT_WK_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_PIPE_AMT_PRD_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_PIPE_AMT_QTR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_PIPE_AMT_YR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_WTD_PIPE_AMT_DAY_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_WTD_PIPE_AMT_WK_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_WTD_PIPE_AMT_PRD_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_WTD_PIPE_AMT_QTR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_WTD_PIPE_AMT_YR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_OPEN_AMT_DAY_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_OPEN_AMT_WK_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_OPEN_AMT_PRD_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_OPEN_AMT_QTR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVPRD_OPEN_AMT_YR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_PIPE_AMT_DAY_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_PIPE_AMT_WK_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_PIPE_AMT_PRD_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_PIPE_AMT_QTR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_PIPE_AMT_YR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_WTD_PIPE_AMT_DAY_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_WTD_PIPE_AMT_WK_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_WTD_PIPE_AMT_PRD_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_WTD_PIPE_AMT_QTR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_WTD_PIPE_AMT_YR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_OPEN_AMT_DAY_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_OPEN_AMT_WK_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_OPEN_AMT_PRD_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_OPEN_AMT_QTR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_OPEN_AMT_YR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_PIPE_AMT_DAY_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_PIPE_AMT_WK_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_PIPE_AMT_PRD_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_PIPE_AMT_QTR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_PIPE_AMT_YR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_WTD_PIPE_AMT_DAY_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_WTD_PIPE_AMT_WK_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_WTD_PIPE_AMT_PRD_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_WTD_PIPE_AMT_QTR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_WTD_PIPE_AMT_YR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_OPEN_AMT_DAY_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_OPEN_AMT_WK_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_OPEN_AMT_PRD_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_OPEN_AMT_QTR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVQTR_OPEN_AMT_YR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_PIPE_AMT_DAY_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_PIPE_AMT_WK_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_PIPE_AMT_PRD_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_PIPE_AMT_QTR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_PIPE_AMT_YR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_WTD_PIPE_AMT_DAY_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_WTD_PIPE_AMT_WK_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_WTD_PIPE_AMT_PRD_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_WTD_PIPE_AMT_QTR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_WTD_PIPE_AMT_YR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_OPEN_AMT_DAY_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_OPEN_AMT_WK_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_OPEN_AMT_PRD_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_OPEN_AMT_QTR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_OPEN_AMT_YR_XCNT NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_PIPE_AMT_DAY_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_PIPE_AMT_WK_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_PIPE_AMT_PRD_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_PIPE_AMT_QTR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_PIPE_AMT_YR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_WTD_PIPE_AMT_DAY_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_WTD_PIPE_AMT_WK_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_WTD_PIPE_AMT_PRD_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_WTD_PIPE_AMT_QTR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_WTD_PIPE_AMT_YR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_OPEN_AMT_DAY_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_OPEN_AMT_WK_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_OPEN_AMT_PRD_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_OPEN_AMT_QTR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
PRVYR_OPEN_AMT_YR_XCNT_S NUMBER

Dummy count columns required to create fast refresh MV.
GROUPID NUMBER

Dummy count columns required to create fast refresh MV.
XCNT NUMBER

Dummy count columns required to create fast refresh MV.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT GRP_TOTAL_FLAG
,      PARENT_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
,      PRVWK_PIPE_AMT_DAY
,      PRVWK_PIPE_AMT_WK
,      PRVWK_PIPE_AMT_PRD
,      PRVWK_PIPE_AMT_QTR
,      PRVWK_PIPE_AMT_YR
,      PRVWK_WTD_PIPE_AMT_DAY
,      PRVWK_WTD_PIPE_AMT_WK
,      PRVWK_WTD_PIPE_AMT_PRD
,      PRVWK_WTD_PIPE_AMT_QTR
,      PRVWK_WTD_PIPE_AMT_YR
,      PRVWK_OPEN_AMT_DAY
,      PRVWK_OPEN_AMT_WK
,      PRVWK_OPEN_AMT_PRD
,      PRVWK_OPEN_AMT_QTR
,      PRVWK_OPEN_AMT_YR
,      PRVWK_PIPE_AMT_DAY_S
,      PRVWK_PIPE_AMT_WK_S
,      PRVWK_PIPE_AMT_PRD_S
,      PRVWK_PIPE_AMT_QTR_S
,      PRVWK_PIPE_AMT_YR_S
,      PRVWK_WTD_PIPE_AMT_DAY_S
,      PRVWK_WTD_PIPE_AMT_WK_S
,      PRVWK_WTD_PIPE_AMT_PRD_S
,      PRVWK_WTD_PIPE_AMT_QTR_S
,      PRVWK_WTD_PIPE_AMT_YR_S
,      PRVWK_OPEN_AMT_DAY_S
,      PRVWK_OPEN_AMT_WK_S
,      PRVWK_OPEN_AMT_PRD_S
,      PRVWK_OPEN_AMT_QTR_S
,      PRVWK_OPEN_AMT_YR_S
,      PRVPRD_PIPE_AMT_DAY
,      PRVPRD_PIPE_AMT_WK
,      PRVPRD_PIPE_AMT_PRD
,      PRVPRD_PIPE_AMT_QTR
,      PRVPRD_PIPE_AMT_YR
,      PRVPRD_WTD_PIPE_AMT_DAY
,      PRVPRD_WTD_PIPE_AMT_WK
,      PRVPRD_WTD_PIPE_AMT_PRD
,      PRVPRD_WTD_PIPE_AMT_QTR
,      PRVPRD_WTD_PIPE_AMT_YR
,      PRVPRD_OPEN_AMT_DAY
,      PRVPRD_OPEN_AMT_WK
,      PRVPRD_OPEN_AMT_PRD
,      PRVPRD_OPEN_AMT_QTR
,      PRVPRD_OPEN_AMT_YR
,      PRVPRD_PIPE_AMT_DAY_S
,      PRVPRD_PIPE_AMT_WK_S
,      PRVPRD_PIPE_AMT_PRD_S
,      PRVPRD_PIPE_AMT_QTR_S
,      PRVPRD_PIPE_AMT_YR_S
,      PRVPRD_WTD_PIPE_AMT_DAY_S
,      PRVPRD_WTD_PIPE_AMT_WK_S
,      PRVPRD_WTD_PIPE_AMT_PRD_S
,      PRVPRD_WTD_PIPE_AMT_QTR_S
,      PRVPRD_WTD_PIPE_AMT_YR_S
,      PRVPRD_OPEN_AMT_DAY_S
,      PRVPRD_OPEN_AMT_WK_S
,      PRVPRD_OPEN_AMT_PRD_S
,      PRVPRD_OPEN_AMT_QTR_S
,      PRVPRD_OPEN_AMT_YR_S
,      PRVQTR_PIPE_AMT_DAY
,      PRVQTR_PIPE_AMT_WK
,      PRVQTR_PIPE_AMT_PRD
,      PRVQTR_PIPE_AMT_QTR
,      PRVQTR_PIPE_AMT_YR
,      PRVQTR_WTD_PIPE_AMT_DAY
,      PRVQTR_WTD_PIPE_AMT_WK
,      PRVQTR_WTD_PIPE_AMT_PRD
,      PRVQTR_WTD_PIPE_AMT_QTR
,      PRVQTR_WTD_PIPE_AMT_YR
,      PRVQTR_OPEN_AMT_DAY
,      PRVQTR_OPEN_AMT_WK
,      PRVQTR_OPEN_AMT_PRD
,      PRVQTR_OPEN_AMT_QTR
,      PRVQTR_OPEN_AMT_YR
,      PRVQTR_PIPE_AMT_DAY_S
,      PRVQTR_PIPE_AMT_WK_S
,      PRVQTR_PIPE_AMT_PRD_S
,      PRVQTR_PIPE_AMT_QTR_S
,      PRVQTR_PIPE_AMT_YR_S
,      PRVQTR_WTD_PIPE_AMT_DAY_S
,      PRVQTR_WTD_PIPE_AMT_WK_S
,      PRVQTR_WTD_PIPE_AMT_PRD_S
,      PRVQTR_WTD_PIPE_AMT_QTR_S
,      PRVQTR_WTD_PIPE_AMT_YR_S
,      PRVQTR_OPEN_AMT_DAY_S
,      PRVQTR_OPEN_AMT_WK_S
,      PRVQTR_OPEN_AMT_PRD_S
,      PRVQTR_OPEN_AMT_QTR_S
,      PRVQTR_OPEN_AMT_YR_S
,      PRVYR_PIPE_AMT_DAY
,      PRVYR_PIPE_AMT_WK
,      PRVYR_PIPE_AMT_PRD
,      PRVYR_PIPE_AMT_QTR
,      PRVYR_PIPE_AMT_YR
,      PRVYR_WTD_PIPE_AMT_DAY
,      PRVYR_WTD_PIPE_AMT_WK
,      PRVYR_WTD_PIPE_AMT_PRD
,      PRVYR_WTD_PIPE_AMT_QTR
,      PRVYR_WTD_PIPE_AMT_YR
,      PRVYR_OPEN_AMT_DAY
,      PRVYR_OPEN_AMT_WK
,      PRVYR_OPEN_AMT_PRD
,      PRVYR_OPEN_AMT_QTR
,      PRVYR_OPEN_AMT_YR
,      PRVYR_PIPE_AMT_DAY_S
,      PRVYR_PIPE_AMT_WK_S
,      PRVYR_PIPE_AMT_PRD_S
,      PRVYR_PIPE_AMT_QTR_S
,      PRVYR_PIPE_AMT_YR_S
,      PRVYR_WTD_PIPE_AMT_DAY_S
,      PRVYR_WTD_PIPE_AMT_WK_S
,      PRVYR_WTD_PIPE_AMT_PRD_S
,      PRVYR_WTD_PIPE_AMT_QTR_S
,      PRVYR_WTD_PIPE_AMT_YR_S
,      PRVYR_OPEN_AMT_DAY_S
,      PRVYR_OPEN_AMT_WK_S
,      PRVYR_OPEN_AMT_PRD_S
,      PRVYR_OPEN_AMT_QTR_S
,      PRVYR_OPEN_AMT_YR_S
,      PIPELINE_AMT_DAY_XCNT
,      PIPELINE_AMT_WEEK_XCNT
,      PIPELINE_AMT_PERIOD_XCNT
,      PIPELINE_AMT_QUARTER_XCNT
,      PIPELINE_AMT_YEAR_XCNT
,      WTD_PIPELINE_AMT_DAY_XCNT
,      WTD_PIPELINE_AMT_WEEK_XCNT
,      WTD_PIPELINE_AMT_PERIOD_XCNT
,      WTD_PIPELINE_AMT_QUARTER_XCNT
,      WTD_PIPELINE_AMT_YEAR_XCNT
,      OPEN_AMT_DAY_XCNT
,      OPEN_AMT_WEEK_XCNT
,      OPEN_AMT_PERIOD_XCNT
,      OPEN_AMT_QUARTER_XCNT
,      OPEN_AMT_YEAR_XCNT
,      PIPELINE_AMT_DAY_XCNT_S
,      PIPELINE_AMT_WEEK_XCNT_S
,      PIPELINE_AMT_PERIOD_XCNT_S
,      PIPELINE_AMT_QUARTER_XCNT_S
,      PIPELINE_AMT_YEAR_XCNT_S
,      WTD_PIPELINE_AMT_DAY_XCNT_S
,      WTD_PIPELINE_AMT_WEEK_XCNT_S
,      WTD_PIPELINE_AMT_PERIOD_XCNT_S
,      WTD_PIPELINE_AMT_QTR_XCNT_S
,      WTD_PIPELINE_AMT_YEAR_XCNT_S
,      OPEN_AMT_DAY_XCNT_S
,      OPEN_AMT_WEEK_XCNT_S
,      OPEN_AMT_PERIOD_XCNT_S
,      OPEN_AMT_QUARTER_XCNT_S
,      OPEN_AMT_YEAR_XCNT_S
,      PRVWK_PIPE_AMT_DAY_XCNT
,      PRVWK_PIPE_AMT_WK_XCNT
,      PRVWK_PIPE_AMT_PRD_XCNT
,      PRVWK_PIPE_AMT_QTR_XCNT
,      PRVWK_PIPE_AMT_YR_XCNT
,      PRVWK_WTD_PIPE_AMT_DAY_XCNT
,      PRVWK_WTD_PIPE_AMT_WK_XCNT
,      PRVWK_WTD_PIPE_AMT_PRD_XCNT
,      PRVWK_WTD_PIPE_AMT_QTR_XCNT
,      PRVWK_WTD_PIPE_AMT_YR_XCNT
,      PRVWK_OPEN_AMT_DAY_XCNT
,      PRVWK_OPEN_AMT_WK_XCNT
,      PRVWK_OPEN_AMT_PRD_XCNT
,      PRVWK_OPEN_AMT_QTR_XCNT
,      PRVWK_OPEN_AMT_YR_XCNT
,      PRVWK_PIPE_AMT_DAY_XCNT_S
,      PRVWK_PIPE_AMT_WK_XCNT_S
,      PRVWK_PIPE_AMT_PRD_XCNT_S
,      PRVWK_PIPE_AMT_QTR_XCNT_S
,      PRVWK_PIPE_AMT_YR_XCNT_S
,      PRVWK_WTD_PIPE_AMT_DAY_XCNT_S
,      PRVWK_WTD_PIPE_AMT_WK_XCNT_S
,      PRVWK_WTD_PIPE_AMT_PRD_XCNT_S
,      PRVWK_WTD_PIPE_AMT_QTR_XCNT_S
,      PRVWK_WTD_PIPE_AMT_YR_XCNT_S
,      PRVWK_OPEN_AMT_DAY_XCNT_S
,      PRVWK_OPEN_AMT_WK_XCNT_S
,      PRVWK_OPEN_AMT_PRD_XCNT_S
,      PRVWK_OPEN_AMT_QTR_XCNT_S
,      PRVWK_OPEN_AMT_YR_XCNT_S
,      PRVPRD_PIPE_AMT_DAY_XCNT
,      PRVPRD_PIPE_AMT_WK_XCNT
,      PRVPRD_PIPE_AMT_PRD_XCNT
,      PRVPRD_PIPE_AMT_QTR_XCNT
,      PRVPRD_PIPE_AMT_YR_XCNT
,      PRVPRD_WTD_PIPE_AMT_DAY_XCNT
,      PRVPRD_WTD_PIPE_AMT_WK_XCNT
,      PRVPRD_WTD_PIPE_AMT_PRD_XCNT
,      PRVPRD_WTD_PIPE_AMT_QTR_XCNT
,      PRVPRD_WTD_PIPE_AMT_YR_XCNT
,      PRVPRD_OPEN_AMT_DAY_XCNT
,      PRVPRD_OPEN_AMT_WK_XCNT
,      PRVPRD_OPEN_AMT_PRD_XCNT
,      PRVPRD_OPEN_AMT_QTR_XCNT
,      PRVPRD_OPEN_AMT_YR_XCNT
,      PRVPRD_PIPE_AMT_DAY_XCNT_S
,      PRVPRD_PIPE_AMT_WK_XCNT_S
,      PRVPRD_PIPE_AMT_PRD_XCNT_S
,      PRVPRD_PIPE_AMT_QTR_XCNT_S
,      PRVPRD_PIPE_AMT_YR_XCNT_S
,      PRVPRD_WTD_PIPE_AMT_DAY_XCNT_S
,      PRVPRD_WTD_PIPE_AMT_WK_XCNT_S
,      PRVPRD_WTD_PIPE_AMT_PRD_XCNT_S
,      PRVPRD_WTD_PIPE_AMT_QTR_XCNT_S
,      PRVPRD_WTD_PIPE_AMT_YR_XCNT_S
,      PRVPRD_OPEN_AMT_DAY_XCNT_S
,      PRVPRD_OPEN_AMT_WK_XCNT_S
,      PRVPRD_OPEN_AMT_PRD_XCNT_S
,      PRVPRD_OPEN_AMT_QTR_XCNT_S
,      PRVPRD_OPEN_AMT_YR_XCNT_S
,      PRVQTR_PIPE_AMT_DAY_XCNT
,      PRVQTR_PIPE_AMT_WK_XCNT
,      PRVQTR_PIPE_AMT_PRD_XCNT
,      PRVQTR_PIPE_AMT_QTR_XCNT
,      PRVQTR_PIPE_AMT_YR_XCNT
,      PRVQTR_WTD_PIPE_AMT_DAY_XCNT
,      PRVQTR_WTD_PIPE_AMT_WK_XCNT
,      PRVQTR_WTD_PIPE_AMT_PRD_XCNT
,      PRVQTR_WTD_PIPE_AMT_QTR_XCNT
,      PRVQTR_WTD_PIPE_AMT_YR_XCNT
,      PRVQTR_OPEN_AMT_DAY_XCNT
,      PRVQTR_OPEN_AMT_WK_XCNT
,      PRVQTR_OPEN_AMT_PRD_XCNT
,      PRVQTR_OPEN_AMT_QTR_XCNT
,      PRVQTR_OPEN_AMT_YR_XCNT
,      PRVQTR_PIPE_AMT_DAY_XCNT_S
,      PRVQTR_PIPE_AMT_WK_XCNT_S
,      PRVQTR_PIPE_AMT_PRD_XCNT_S
,      PRVQTR_PIPE_AMT_QTR_XCNT_S
,      PRVQTR_PIPE_AMT_YR_XCNT_S
,      PRVQTR_WTD_PIPE_AMT_DAY_XCNT_S
,      PRVQTR_WTD_PIPE_AMT_WK_XCNT_S
,      PRVQTR_WTD_PIPE_AMT_PRD_XCNT_S
,      PRVQTR_WTD_PIPE_AMT_QTR_XCNT_S
,      PRVQTR_WTD_PIPE_AMT_YR_XCNT_S
,      PRVQTR_OPEN_AMT_DAY_XCNT_S
,      PRVQTR_OPEN_AMT_WK_XCNT_S
,      PRVQTR_OPEN_AMT_PRD_XCNT_S
,      PRVQTR_OPEN_AMT_QTR_XCNT_S
,      PRVQTR_OPEN_AMT_YR_XCNT_S
,      PRVYR_PIPE_AMT_DAY_XCNT
,      PRVYR_PIPE_AMT_WK_XCNT
,      PRVYR_PIPE_AMT_PRD_XCNT
,      PRVYR_PIPE_AMT_QTR_XCNT
,      PRVYR_PIPE_AMT_YR_XCNT
,      PRVYR_WTD_PIPE_AMT_DAY_XCNT
,      PRVYR_WTD_PIPE_AMT_WK_XCNT
,      PRVYR_WTD_PIPE_AMT_PRD_XCNT
,      PRVYR_WTD_PIPE_AMT_QTR_XCNT
,      PRVYR_WTD_PIPE_AMT_YR_XCNT
,      PRVYR_OPEN_AMT_DAY_XCNT
,      PRVYR_OPEN_AMT_WK_XCNT
,      PRVYR_OPEN_AMT_PRD_XCNT
,      PRVYR_OPEN_AMT_QTR_XCNT
,      PRVYR_OPEN_AMT_YR_XCNT
,      PRVYR_PIPE_AMT_DAY_XCNT_S
,      PRVYR_PIPE_AMT_WK_XCNT_S
,      PRVYR_PIPE_AMT_PRD_XCNT_S
,      PRVYR_PIPE_AMT_QTR_XCNT_S
,      PRVYR_PIPE_AMT_YR_XCNT_S
,      PRVYR_WTD_PIPE_AMT_DAY_XCNT_S
,      PRVYR_WTD_PIPE_AMT_WK_XCNT_S
,      PRVYR_WTD_PIPE_AMT_PRD_XCNT_S
,      PRVYR_WTD_PIPE_AMT_QTR_XCNT_S
,      PRVYR_WTD_PIPE_AMT_YR_XCNT_S
,      PRVYR_OPEN_AMT_DAY_XCNT_S
,      PRVYR_OPEN_AMT_WK_XCNT_S
,      PRVYR_OPEN_AMT_PRD_XCNT_S
,      PRVYR_OPEN_AMT_QTR_XCNT_S
,      PRVYR_OPEN_AMT_YR_XCNT_S
,      GROUPID
,      XCNT
FROM APPS.BIL_BI_PIPEC_G_MV;

Dependencies

[top of page]

APPS.BIL_BI_PIPEC_G_MV does not reference any database object

APPS.BIL_BI_PIPEC_G_MV is referenced by following:

SchemaAPPS
Materialized ViewBIL_BI_PIPEC_G_MV
ViewBIL_BI_PIPE_G_V
Materialized ViewBIL_BI_SLS_PERF_MV