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.ENI_DBI_TOO_MV

Object Details

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

M-View Details

Container:	ENI_DBI_TOO_MV
Updatable:	N
Rewrite Enabled:	N
Rewrite Capability:	GENERAL
Refresh Mode:	DEMAND
Refresh Method:	COMPLETE
Build Mode:	DEFERRED
Fast Refreshable:	NO

MV Log Dependencies:


ENI_OLTP_ITEM_STAR

[View Source Query]

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMER_ID	NUMBER			The Customer ID of Customer on whom this Opportunity is logged
OPTY_ID	NUMBER		Yes	The Opportunity ID
SALES_CREDIT_AMT	NUMBER			The Amount of the Current Sales Opportunity in the Primary Currency
SALES_CREDIT_AMT_S	NUMBER			The Amount of the Current Sales Opportunity in the Secondary Currency
WIN_PROBABILITY	NUMBER			The Probability in percent of winning this Sale Opportunity
CLOSE_DATE	DATE			The Date for the Sale Opportunity when it would get closed
PRODUCT_CATEGORY_ID	NUMBER			The ID of the Item Catalog Category to which the Item on which the Sale Opportunity is logged belongs to
ITEM_ID	VARCHAR2	(25)		The Id of the Item on which the Sale Opportunity is logged
SALESREP_ID	NUMBER			The ID of the Sales person
SALES_GROUP_ID	NUMBER			The Group ID of the Sales group to which the Sales Person belongs
RANK_PROD_ITEM	NUMBER			The Column used to rank the Sale Opportunity for every combination of Product Product Category
RANK_ALL	NUMBER			The Column used to rank the Sale Opportunity on Amount

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CUSTOMER_ID
,      OPTY_ID
,      SALES_CREDIT_AMT
,      SALES_CREDIT_AMT_S
,      WIN_PROBABILITY
,      CLOSE_DATE
,      PRODUCT_CATEGORY_ID
,      ITEM_ID
,      SALESREP_ID
,      SALES_GROUP_ID
,      RANK_PROD_ITEM
,      RANK_ALL
FROM APPS.ENI_DBI_TOO_MV;

Dependencies

[top of page]

APPS.ENI_DBI_TOO_MV references the following:

APPS: ENI_DBI_TOO_MV; ENI_OLTP_ITEM_STAR
BIL: BIL_BI_OPDTL_F
ENI: ENI_OLTP_ITEM_STAR

APPS.ENI_DBI_TOO_MV is not referenced by any database object