[Home] [Help] [Dependency Information]
Object Name: | BIL_OBI_OPTY_PG_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | FND.BIL_OBI_OPTY_PG_MV |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_SNAP$_BIL_OBI_OPTY_PG_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("PRODUCT_CATEGORY_ID") SYS_OP_MAP_NONNULL("ITEM_ID") SYS_OP_MAP_NONNULL("ENT_YEAR_ID") SYS_OP_MAP_NONNULL("ENT_QTR_ID") SYS_OP_MAP_NONNULL("ENT_PERIOD_ID") SYS_OP_MAP_NONNULL("XGRP") |
BIL_OBI_OPTY_PG_MV_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
EFFECTIVE_TIME_ID
SALES_GROUP_ID SALESREP_ID |
BIL_OBI_OPTY_PG_MV_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
EFFECTIVE_TIME_ID
SALES_GROUP_ID PRODUCT_CATEGORY_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, close date for rest of the measures. | ||
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 | ||
PRODUCT_CATEGORY_ID | NUMBER | The product category to which the item in this sales credit line belongs to | ||
ITEM_ID | NUMBER | NULL for valid items and -1 for rows in assigned to category union all | ||
ROLLUP_FLAG | VARCHAR2 | (1) | Flag to distinguish between rollup and non-rolled up amount | |
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 | Sales credit amount If the opportunity has been WON in primary currency. | ||
WON_OPTY_AMT_S | NUMBER | Sales credit amount If the opportunity has been WON in secondary currency . | ||
LOST_OPTY_AMT | NUMBER | Sales credit amount If the opportunity has been LOST in primary currency. | ||
LOST_OPTY_AMT_S | NUMBER | Sales credit amount If the opportunity has been LOST in secondary currency. | ||
NO_OPTY_AMT | NUMBER | Sales credit amount If the opportunity has been NO OPPORTUNITY in primary currency. | ||
NO_OPTY_AMT_S | NUMBER | Sales credit amount If the opportunity has been NO OPPORTUNITY in secondary currency. | ||
CNV_OPTY_AMT | NUMBER | Sales credit amount If the opportunity has been Linked to / converted from a lead in primary currency | ||
CNV_OPTY_AMT_S | NUMBER | Sales credit amount If the opportunity has 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_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 | ||
ALL_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
ENT_YEAR_ID | NUMBER | Columns like ent_yr_id,grouping_id( | ||
ENT_QTR_ID | NUMBER | Columns like ent_yr_id,grouping_id( | ||
ENT_PERIOD_ID | NUMBER | Columns like ent_yr_id,grouping_id( | ||
XGRP | NUMBER | Columns like ent_yr_id,grouping_id( |
Cut, paste (and edit) the following text to query this object:
SELECT EFFECTIVE_TIME_ID
, PARENT_SALES_GROUP_ID
, SALES_GROUP_ID
, SALESREP_ID
, PRODUCT_CATEGORY_ID
, ITEM_ID
, ROLLUP_FLAG
, 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_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
, ALL_XCNT
, ENT_YEAR_ID
, ENT_QTR_ID
, ENT_PERIOD_ID
, XGRP
FROM APPS.BIL_OBI_OPTY_PG_MV;
APPS.BIL_OBI_OPTY_PG_MV does not reference any database object
APPS.BIL_OBI_OPTY_PG_MV is referenced by following:
|
|
|