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

TABLE: APPS.ENI_DBI_TOO_MV

Object Details
Object Name: ENI_DBI_TOO_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableENI.ENI_DBI_TOO_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ENI_DBI_TOO_MV_N1 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnPRODUCT_CATEGORY_ID
ColumnITEM_ID
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 does not reference any database object

APPS.ENI_DBI_TOO_MV is referenced by following:

SchemaAPPS
Materialized ViewENI_DBI_TOO_MV