[Home] [Help] [Dependency Information]
Object Name: | BIL_BI_OPDTL_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | BIL_BI_OPDTL_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | GENERAL |
Refresh Mode: | DEMAND |
Refresh Method: | FAST |
Build Mode: | DEFERRED |
Fast Refreshable: | DIRLOAD_DML |
BIL_BI_OPDTL_F
ENI_OLTP_ITEM_STAR
FII_TIME_DAY
JTF_RS_GROUP_USAGES
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OPTY_CREATION_TIME_ID | NUMBER | The date the opportunity was created | ||
OPTY_CLOSE_TIME_ID | NUMBER | Yes | The forecast date for won opty and close date for other statuses set for this opportunity | |
OPTY_LD_CONVERSION_TIME_ID | NUMBER | The day this opportunity was converted from/linked to a lead | ||
SALES_GROUP_ID | NUMBER | Yes | Sales group identifier who gets the sales credits | |
SALESREP_ID | NUMBER | Yes | Salesperson or resource identifier who gets sales credits.Will never be 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 | ||
CAMPAIGN_OBJECT_ID | NUMBER | Campaign object id for the promotion source | ||
CAMPAIGN_OBJECT_TYPE | VARCHAR2 | (30) | Campaign object type for the promotion source | |
CHILD_CAMPAIGN_OBJECT_ID | NUMBER | Child campaign object id for the promotion source | ||
CHILD_CAMPAIGN_OBJECT_TYPE | VARCHAR2 | (30) | Child campaign object type for the promotion source | |
OPTY_ID | NUMBER | Yes | Opportunity identifier to obtain accurate counts | |
COMPETITOR_ID | NUMBER | The key competitor for this opportunity at header level | ||
HDR_SOURCE_PROMOTION_ID | NUMBER | Marketing header source promotion id for this opportunity | ||
OPEN_STATUS_FLAG | VARCHAR2 | (1) | Opportunity open status flag indicator (Y if Open) | |
WIN_LOSS_INDICATOR | VARCHAR2 | (1) | Opportunity status indicator (W for won, L for Lost, N for no opportunity and Null for others) | |
FORECAST_ROLLUP_FLAG | VARCHAR2 | (1) | Forecast rollup flag (Y if this opportunity is forecast-able) | |
SALES_CREDIT_AMT | NUMBER | Line level Sales Credit Amount in primary currency | ||
SALES_CREDIT_AMT_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
SALES_CREDIT_AMT_S | NUMBER | Line level Sales Credit Amount in secondary currency | ||
SALES_CREDIT_AMT_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
NEW_OPTY_AMT | NUMBER | Sales credit amount in primary currency | ||
NEW_OPTY_AMT_S | NUMBER | Sales credit amount in secondary currency | ||
LATEST_OPEN_OPTY_AMT | NUMBER | The sum of sales credit amount for opportunities with forecastable and open status flags as Y (used for the competitor report) in primary currency | ||
LATEST_OPEN_OPTY_AMT_S | NUMBER | The sum of sales credit amount for opportunities with forecastable and open status flags as Y (used for the competitor report) 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 is a NO OPPORTUNITY in primary currency | ||
NO_OPTY_AMT_S | NUMBER | Sales credit amount If the opportunity is a 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 | ||
NEW_OPTY_CNT | NUMBER | Count of New Opty = 1 | ||
LATEST_OPEN_OPTY_CNT | NUMBER | 1 if the forecastable and open status flags are Y (used for the competitor and opportunity overview report) | ||
WON_OPTY_CNT | NUMBER | 1 if the opportunity has been WON | ||
LOST_OPTY_CNT | NUMBER | 1 if the opportunity has been LOST | ||
NO_OPTY_CNT | NUMBER | 1 if the opportunity has been NO OPPORTUNITY | ||
CNV_OPTY_CNT | NUMBER | 1 If the opportunity has been Linked to / converted from a lead | ||
NEW_OPTY_AMT_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
NEW_OPTY_AMT_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
LATEST_OPEN_OPTY_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
LATEST_OPEN_OPTY_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
WON_OPTY_AMT_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
WON_OPTY_AMT_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
LOST_OPTY_AMT_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
LOST_OPTY_AMT_XCNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
NO_OPTY_AMT_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
NO_OPTY_AMT_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 | ||
NEW_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 | ||
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 | ||
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 period in primary currency | ||
NFP_PER_S | NUMBER | Sum of sales credit if the opty is created and closed in the period in secondary currency | ||
NFP_WK | NUMBER | Sum of sales credit if the opty is created and closed in the week in primary currency | ||
NFP_WK_S | NUMBER | Sum of sales credit if the opty is created and closed in the week in secondary currency | ||
NFP_YR_CNT | NUMBER | Dummy count column required to create fast refresh MV | ||
NFP_YR_CNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
NFP_QTR_CNT | NUMBER | Dummy count column required to create fast refresh MV | ||
NFP_QTR_CNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
NFP_PER_CNT | NUMBER | Dummy count column required to create fast refresh MV | ||
NFP_PER_CNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
NFP_WK_CNT | NUMBER | Dummy count column required to create fast refresh MV | ||
NFP_WK_CNT_S | NUMBER | Dummy count column required to create fast refresh MV | ||
XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
LEAD_NUMBER | VARCHAR2 | (30) | The lead number of the Opportunity. | |
WIN_PROBABILITY | NUMBER | The win probability of the Opportunity. | ||
SALES_STAGE_ID | NUMBER | The sales stage identifier of the Opportunity. | ||
CUSTOMER_ID | NUMBER | The customer id of the customer of the opportunity. | ||
STATUS | VARCHAR2 | (30) | The status code of the Opportunity. | |
OWNER_SALES_GROUP_ID | NUMBER | The Sales group of the owner of this opportunity. | ||
OWNER_SALESREP_ID | NUMBER | The sales representative who owns this opportunity. | ||
OPTY_AMT | NUMBER | The amount of the entire opportunity in the primary currency. | ||
OPTY_AMT_S | NUMBER | The amount of the entire opportunity in the secondary currency. | ||
OPTY_EFFECTIVE_TIME_ID | NUMBER | The close date set for this opportunity. |
Cut, paste (and edit) the following text to query this object:
SELECT OPTY_CREATION_TIME_ID
, OPTY_CLOSE_TIME_ID
, OPTY_LD_CONVERSION_TIME_ID
, SALES_GROUP_ID
, SALESREP_ID
, PRODUCT_CATEGORY_ID
, ITEM_ID
, CAMPAIGN_OBJECT_ID
, CAMPAIGN_OBJECT_TYPE
, CHILD_CAMPAIGN_OBJECT_ID
, CHILD_CAMPAIGN_OBJECT_TYPE
, OPTY_ID
, COMPETITOR_ID
, HDR_SOURCE_PROMOTION_ID
, OPEN_STATUS_FLAG
, WIN_LOSS_INDICATOR
, FORECAST_ROLLUP_FLAG
, SALES_CREDIT_AMT
, SALES_CREDIT_AMT_XCNT
, SALES_CREDIT_AMT_S
, SALES_CREDIT_AMT_XCNT_S
, NEW_OPTY_AMT
, NEW_OPTY_AMT_S
, LATEST_OPEN_OPTY_AMT
, LATEST_OPEN_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
, NEW_OPTY_CNT
, LATEST_OPEN_OPTY_CNT
, WON_OPTY_CNT
, LOST_OPTY_CNT
, NO_OPTY_CNT
, CNV_OPTY_CNT
, NEW_OPTY_AMT_XCNT
, NEW_OPTY_AMT_XCNT_S
, LATEST_OPEN_OPTY_XCNT
, LATEST_OPEN_OPTY_XCNT_S
, WON_OPTY_AMT_XCNT
, WON_OPTY_AMT_XCNT_S
, LOST_OPTY_AMT_XCNT
, LOST_OPTY_AMT_XCNT_S
, NO_OPTY_AMT_XCNT
, NO_OPTY_AMT_XCNT_S
, CNV_OPTY_AMT_XCNT
, CNV_OPTY_AMT_XCNT_S
, NEW_OPTY_CNT_XCNT
, LATEST_OPEN_OPTY_CNT_XCNT
, WON_OPTY_CNT_XCNT
, LOST_OPTY_CNT_XCNT
, NO_OPTY_CNT_XCNT
, CNV_OPTY_CNT_XCNT
, NFP_YR
, NFP_YR_S
, NFP_QTR
, NFP_QTR_S
, NFP_PER
, NFP_PER_S
, NFP_WK
, NFP_WK_S
, NFP_YR_CNT
, NFP_YR_CNT_S
, NFP_QTR_CNT
, NFP_QTR_CNT_S
, NFP_PER_CNT
, NFP_PER_CNT_S
, NFP_WK_CNT
, NFP_WK_CNT_S
, XCNT
, LEAD_NUMBER
, WIN_PROBABILITY
, SALES_STAGE_ID
, CUSTOMER_ID
, STATUS
, OWNER_SALES_GROUP_ID
, OWNER_SALESREP_ID
, OPTY_AMT
, OPTY_AMT_S
, OPTY_EFFECTIVE_TIME_ID
FROM APPS.BIL_BI_OPDTL_MV;
|
|
|