[Home] [Help] [Dependency Information]
Object Name: | BIL_BI_OP21_G_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UMARKER | CHAR | (6) | Needed for FAST refresh of MV | |
OPTY_CREATION_TIME_ID | NUMBER | The date the opportunity was created | ||
OPTY_CLOSE_TIME_ID | NUMBER | The close date set for this opportunity and forecast date for won opty amt | ||
OPTY_LD_CONVERSION_TIME_ID | NUMBER | The day this opportunity was converted from/linked to a lead | ||
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 gets the sales credits | ||
SALESREP_ID | NUMBER | Salesperson or resource identifier who gets sales credits. Will never be null | ||
OPTY_ID | NUMBER | Opportunity identifier to obtain accurate counts | ||
NEW_OPTY_AMT | NUMBER | Sales credit amount in primary currency | ||
NEW_OPTY_AMT_S | NUMBER | Sales credit amount 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_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_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_XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
CNV_OPTY_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 | ||
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 | ||
XCNT | NUMBER | Dummy count column required to create fast refresh MV | ||
OPTY_EFFECTIVE_TIME_ID | NUMBER | The close date set for this opportunity. |
Cut, paste (and edit) the following text to query this object:
SELECT UMARKER
, OPTY_CREATION_TIME_ID
, OPTY_CLOSE_TIME_ID
, OPTY_LD_CONVERSION_TIME_ID
, PARENT_SALES_GROUP_ID
, SALES_GROUP_ID
, SALESREP_ID
, OPTY_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
, LATEST_OPEN_OPTY_CNT
, WON_OPTY_CNT
, LOST_OPTY_CNT
, NO_OPTY_CNT
, CNV_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_XCNT
, CNV_OPTY_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
, LATEST_OPEN_OPTY_CNT_XCNT
, WON_OPTY_CNT_XCNT
, LOST_OPTY_CNT_XCNT
, NO_OPTY_CNT_XCNT
, CNV_OPTY_CNT_XCNT
, XCNT
, OPTY_EFFECTIVE_TIME_ID
FROM APPS.BIL_BI_OP21_G_MV;
APPS.BIL_BI_OP21_G_MV does not reference any database object
APPS.BIL_BI_OP21_G_MV is referenced by following:
|
|
|