[Home] [Help] [Dependency Information]
Object Name: | BIL_BI_OPTY_G_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_SNAP$_BIL_BI_OPTY_G_MV | FUNCTION-BASED NORMAL | UNIQUE | APPS_TS_SUMMARY |
SYS_OP_MAP_NONNULL("PARENT_SALES_GROUP_ID")
SYS_OP_MAP_NONNULL("SALES_GROUP_ID") SYS_OP_MAP_NONNULL("SALESREP_ID") SYS_OP_MAP_NONNULL("TXN_YR_ID") SYS_OP_MAP_NONNULL("TXN_QTR_ID") SYS_OP_MAP_NONNULL("TXN_PER_ID") SYS_OP_MAP_NONNULL("TXN_WK_ID") SYS_OP_MAP_NONNULL("TXN_DAY_ID") SYS_OP_MAP_NONNULL("XGRP") |
BIL_BI_OPTY_G_MV_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
EFFECTIVE_TIME_ID
EFFECTIVE_PERIOD_TYPE_ID PARENT_SALES_GROUP_ID SALES_GROUP_ID SALESREP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EFFECTIVE_TIME_ID | NUMBER | Effective date rolled up over day, week, period, quarter, year. Effective date is opportunity creation date for new opportunity, conversion date for converted from leads facts, close date for rest of the measures. Day level rows will be present in the MV to facilitate reporting till the as of date | ||
EFFECTIVE_PERIOD_TYPE_ID | NUMBER | Period type of effective_time_id. Valid period type in BIS Enterprise calendar | ||
PARENT_SALES_GROUP_ID | NUMBER | The parent of the sales group appearing in the sales_group_id column | ||
SALES_GROUP_ID | NUMBER | Sales group identifier who get the sales credits | ||
SALESREP_ID | NUMBER | Salesperson or resource identifier who gets sales credits. For sales group rollup, this column has a value of NULL | ||
NEW_OPTY_AMT | NUMBER | Amount of any created opportunity in primary currency | ||
NEW_OPTY_AMT_S | NUMBER | Amount of any created opportunity in secondary currency | ||
WON_OPTY_AMT | NUMBER | Amount of opportunities that have been WON in primary currency | ||
WON_OPTY_AMT_S | NUMBER | Amount of opportunities that have been WON in secondary currency | ||
LOST_OPTY_AMT | NUMBER | Amount of opportunities that have been LOST in primary currency | ||
LOST_OPTY_AMT_S | NUMBER | Amount of opportunities that have been LOST in secondary currency | ||
NO_OPTY_AMT | NUMBER | Amount of opportunities that have been NO OPPORTUNITY in primary currency | ||
NO_OPTY_AMT_S | NUMBER | Amount of opportunities that have been NO OPPORTUNITY in secondary currency | ||
CNV_OPTY_AMT | NUMBER | Amount of opportunities that have been Linked to / converted from a lead in primary currency | ||
CNV_OPTY_AMT_S | NUMBER | Amount of opportunities that have been Linked to / converted from a lead in secondary currency | ||
NFP_YR | NUMBER | Sum of sales credit if the opty is created and closed in the same year in primary currency | ||
NFP_YR_S | NUMBER | Sum of sales credit if the opty is created and closed in the same year in secondary currency | ||
NFP_QTR | NUMBER | Sum of sales credit if the opty is created and closed in the same quarter in primary currency | ||
NFP_QTR_S | NUMBER | Sum of sales credit if the opty is created and closed in the same quarter in secondary currency | ||
NFP_PER | NUMBER | Sum of sales credit if the opty is created and closed in the same period in primary currency | ||
NFP_PER_S | NUMBER | Sum of sales credit if the opty is created and closed in the same period in secondary currency | ||
NFP_WK | NUMBER | Sum of sales credit if the opty is created and closed in the same week in primary currency | ||
NFP_WK_S | NUMBER | Sum of sales credit if the opty is created and closed in the same week in secondary currency | ||
NEW_OPTY_CNT | NUMBER | Count of opportunities that have been created | ||
WON_OPTY_CNT | NUMBER | Count of opportunities that have been WON | ||
LOST_OPTY_CNT | NUMBER | Count of opportunities that have been LOST | ||
NO_OPTY_CNT | NUMBER | Count of opportunities that are NO OPPORTUNITIES | ||
CNV_OPTY_CNT | NUMBER | Count of opportunities that have been Linked to / converted from a lead | ||
LATEST_OPEN_OPTY_CNT | NUMBER | Count of latest open opportunities (used for the competitor and opportunity overview report) | ||
NEW_OPTY_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
NEW_OPTY_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
WON_OPTY_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
WON_OPTY_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
LOST_OPTY_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
LOST_OPTY_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
NO_OPTY_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
NO_OPTY_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
CNV_OPTY_AMT_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
CNV_OPTY_AMT_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
NFP_YR_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
NFP_YR_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
NFP_QTR_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
NFP_QTR_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
NFP_PER_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
NFP_PER_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
NFP_WK_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
NFP_WK_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
NEW_OPTY_CNT_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
WON_OPTY_CNT_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
LOST_OPTY_CNT_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
NO_OPTY_CNT_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
CNV_OPTY_CNT_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
LATEST_OPEN_OPTY_CNT_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
ALL_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
TXN_YR_ID | NUMBER | Columns like ent_yr_id,grouping_id( | ||
TXN_QTR_ID | NUMBER | Columns like ent_yr_id,grouping_id( | ||
TXN_PER_ID | NUMBER | Columns like ent_yr_id,grouping_id( | ||
TXN_DAY_ID | NUMBER | Columns like ent_yr_id,grouping_id( | ||
TXN_WK_ID | NUMBER | Columns like ent_yr_id,grouping_id( | ||
XGRP | NUMBER | Dummy grouping columns required to aggregate data in MV |
Cut, paste (and edit) the following text to query this object:
SELECT EFFECTIVE_TIME_ID
, EFFECTIVE_PERIOD_TYPE_ID
, PARENT_SALES_GROUP_ID
, SALES_GROUP_ID
, SALESREP_ID
, NEW_OPTY_AMT
, NEW_OPTY_AMT_S
, WON_OPTY_AMT
, WON_OPTY_AMT_S
, LOST_OPTY_AMT
, LOST_OPTY_AMT_S
, NO_OPTY_AMT
, NO_OPTY_AMT_S
, CNV_OPTY_AMT
, CNV_OPTY_AMT_S
, NFP_YR
, NFP_YR_S
, NFP_QTR
, NFP_QTR_S
, NFP_PER
, NFP_PER_S
, NFP_WK
, NFP_WK_S
, NEW_OPTY_CNT
, WON_OPTY_CNT
, LOST_OPTY_CNT
, NO_OPTY_CNT
, CNV_OPTY_CNT
, LATEST_OPEN_OPTY_CNT
, NEW_OPTY_XCNT
, NEW_OPTY_XCNT_S
, WON_OPTY_XCNT
, WON_OPTY_XCNT_S
, LOST_OPTY_XCNT
, LOST_OPTY_XCNT_S
, NO_OPTY_XCNT
, NO_OPTY_XCNT_S
, CNV_OPTY_AMT_XCNT
, CNV_OPTY_AMT_XCNT_S
, NFP_YR_XCNT
, NFP_YR_XCNT_S
, NFP_QTR_XCNT
, NFP_QTR_XCNT_S
, NFP_PER_XCNT
, NFP_PER_XCNT_S
, NFP_WK_XCNT
, NFP_WK_XCNT_S
, NEW_OPTY_CNT_XCNT
, WON_OPTY_CNT_XCNT
, LOST_OPTY_CNT_XCNT
, NO_OPTY_CNT_XCNT
, CNV_OPTY_CNT_XCNT
, LATEST_OPEN_OPTY_CNT_XCNT
, ALL_XCNT
, TXN_YR_ID
, TXN_QTR_ID
, TXN_PER_ID
, TXN_DAY_ID
, TXN_WK_ID
, XGRP
FROM APPS.BIL_BI_OPTY_G_MV;
APPS.BIL_BI_OPTY_G_MV does not reference any database object
APPS.BIL_BI_OPTY_G_MV is referenced by following:
|
|
|