eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

MATERIALIZED VIEW: APPS.BIL_BI_OPDTL_MV

Object Details

Object Name:	BIL_BI_OPDTL_MV
Object Type:	MATERIALIZED VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

M-View Details

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

MV Log Dependencies:


BIL_BI_OPDTL_F
ENI_OLTP_ITEM_STAR
FII_TIME_DAY
JTF_RS_GROUP_USAGES

[View Source Query]

Columns

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.

Query Text

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;

Dependencies

[top of page]

APPS.BIL_BI_OPDTL_MV references the following:

APPS: BIL_BI_OPDTL_MV
BIL: BIL_BI_OPDTL_F
ENI: ENI_OLTP_ITEM_STAR
FII: FII_TIME_DAY
JTF: JTF_RS_GROUP_USAGES

APPS.BIL_BI_OPDTL_MV is referenced by following:

APPS: BIL_BI_OP11_PG_MV; BIL_BI_OP21_G_MV; BIL_BI_OPLDC_MV; BIL_BI_OPLPC_MV; BIL_BI_TOPOP_G_MV; BIM_I_EXT_COL_MV; BIM_SGMT_ACT_B_MV