[Home] [Help] [Dependency Information]
Object Name: | BIL_BI_OPTY_PG_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | BIL_BI_OPTY_PG_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | GENERAL |
Refresh Mode: | DEMAND |
Refresh Method: | FAST |
Build Mode: | DEFERRED |
Fast Refreshable: | DIRLOAD_DML |
BIL_BI_OP12_PG_MV
BIL_BI_OP11_PG_MV
BIL_BI_OPDTL_MV
BIL_BI_OPDTL_F
ENI_OLTP_ITEM_STAR
FII_TIME_DAY
JTF_RS_GROUP_USAGES
BIL_BI_RS_GRP_MV
BIL_BI_GRP_CNT_MV
JTF_RS_GROUPS_DENORM
JTF_RS_GROUP_USAGES
JTF_RS_GROUPS_DENORM
JTF_RS_GROUP_USAGES
FII_TIME_DAY
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. 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 | ||
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 | ||
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( | ||
REPORT_DATE_JULIAN | NUMBER | Columns like ent_yr_id,grouping_id( | ||
WEEK_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
, EFFECTIVE_PERIOD_TYPE_ID
, PARENT_SALES_GROUP_ID
, SALES_GROUP_ID
, SALESREP_ID
, PRODUCT_CATEGORY_ID
, ITEM_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_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
, REPORT_DATE_JULIAN
, WEEK_ID
, XGRP
FROM APPS.BIL_BI_OPTY_PG_MV;
APPS.BIL_BI_OPTY_PG_MV is not referenced by any database object
|
|
|