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

TABLE: BIM.EDW_BIM_OPPORTUNITIES_M

Object Details
Object Name: EDW_BIM_OPPORTUNITIES_M
Object Type: TABLE
Owner: BIM
FND Design Data: TableBIM.EDW_BIM_OPPORTUNITIES_M
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDW_BIM_OPPORTUNITIES_M_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnL2_OPPLINE_PK
ColumnL2_OPPLINE_PK_KEY
EDW_BIM_OPPORTUNITIES_M_U2 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnL2_OPPLINE_PK_KEY
Columns
Name Datatype Length Mandatory Comments
L2_OPPLINE_PK_KEY NUMBER
Yes System generated unique identifier for opportunity line .
L1_OPPORTUNITY_PK_KEY NUMBER

System generated unique identifier for opportunity .
L0_ALL_PK_KEY NUMBER

System generated unique identifier for all level .
L0_ALL_PK VARCHAR2 (40)
Unique identifier for all level .
L0_NAME VARCHAR2 (80)
Reserved for future use in Express .
L1_OPPORTUNITY_PK VARCHAR2 (240)
Unique Identifier for opportunity .
L1_OPPORTUNITY_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely .
L1_NAME VARCHAR2 (240)
Reserved for future use in Express .
L1_OPPORTUNITY_LEAD_ID NUMBER

Oltp unique identifier for opportunity header .
L1_OPP_LEAD_NUMBER VARCHAR2 (240)
Unique Number assigned to opportunity header .
L1_WIN_PROBABILITY NUMBER

The percentage or probability that this lead will result in a sale. The higher the percentage the higher the chance of making a sale.
L1_SALES_STAGE_ID NUMBER

Not Used .
L1_PRICE_LIST_ID NUMBER

Not Used .
L1_INITIATING_CONTACT_ID NUMBER

Not Used .
L1_CLOSE_COMPETITOR_ID NUMBER

Not Used .
L1_SOURCE_PROMOTION_ID NUMBER

Not Used .
L1_ADDRESS_ID NUMBER

Not Used .
L1_CUSTOMER_ID NUMBER

Not Used .
L1_RANK VARCHAR2 (240)
Not Used .
L1_PARENT_PROJECT VARCHAR2 (240)
Project to which this opportunity belongs .
L1_NO_OPP_ALLOWED_FLAG VARCHAR2 (40)
Not Used .
L1_LEAD_SOURCE_CODE VARCHAR2 (240)
Originating source code of opportunity .
L1_END_USER_CUSTOMER_NAME VARCHAR2 (240)
Not Used .
L1_DELETE_ALLOWED_FLAG VARCHAR2 (40)
Not Used .
L1_DECISION_DATE_FLAG VARCHAR2 (40)
Not Used .
L1_CURRENCY_CODE VARCHAR2 (240)
The currency code used for this opportunity .
L1_TOTAL_AMOUNT NUMBER

The likely amount of sale from this opportunity .
L1_CLOSE_REASON VARCHAR2 (240)
A reason for closing a opportunity .
L1_CLOSE_COMPETITOR_CODE VARCHAR2 (240)
Not Used .
L1_CLOSE_COMPETITOR VARCHAR2 (240)
Not Used .
L1_CLOSE_COMMENT VARCHAR2 (240)
Not Used .
L1_CHANNEL_CODE VARCHAR2 (80)
Not Used .
L1_DECISION_DATE DATE

Not Used .
L1_OPP_DESCRIPTION VARCHAR2 (2000)
Opportunity name of the lead, usually the main interest for the lead .
L1_INSTANCE VARCHAR2 (240)
Instance Identifier .
L1_USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute .
L1_USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute .
L1_USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute .
L1_USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute .
L1_USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute .
L2_OPPLINE_PK VARCHAR2 (240)
Unique Identifier for Opportunity Line .
L2_OPPLINE_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely .
L2_NAME VARCHAR2 (240)
Rserved for future use in Express .
L2_OPP_LEAD_LINE_ID NUMBER

OLTP unique identifier for opportunity line .
L2_LEAD_ID NUMBER

Unique identifier for Opportunity .
L2_WIN_PROBABILITY NUMBER

Not Used .
L2_SALES_STAGE_ID NUMBER

Not Used .
L2_PRICE_VOLUME_MARGIN NUMBER

Not Used .
L2_PRICE NUMBER

Not Used .
L2_ORIG_OPPORTUNITY_LINE_ID NUMBER

Not Used .
L2_ORIGINAL_LEAD_LINE_ID NUMBER

Not Used .
L2_QUOTED_LINE_FLAG VARCHAR2 (240)
Not Used .
L2_CHANNEL_CODE VARCHAR2 (80)
Not Used .
L2_SHIP_DATE DATE

Not Used .
L2_DECISION_DATE DATE

Not Used .
L2_INSTANCE VARCHAR2 (240)
Instance Identifier .
L2_USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute .
L2_USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute .
L2_USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute .
L2_USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute .
L2_USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute .
L2_LAST_UPDATE_DATE DATE

Standard Who Column .
L2_CREATION_DATE DATE

Standard Who Column .
SECURITY_GROUP_ID NUMBER

Standard Who Column .
LAST_UPDATE_DATE DATE
Yes
CREATION_DATE DATE
Yes
L1_ORIG_SYSTEM_REFERENCE VARCHAR2 (240)
Opportunity name of the lead, usually the main interest for the lead .
L1_VEHICLE_RESPONSE_CODE VARCHAR2 (80)
Indicates how the lead was created .
L1_DECISION_TIMEFRAME_CODE VARCHAR2 (80)
specify the time by when decision will be made .
L1_DELETED_FLAG VARCHAR2 (20)
Flag to indicate if this lead is soft deleted .
Query Text

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


SELECT L2_OPPLINE_PK_KEY
,      L1_OPPORTUNITY_PK_KEY
,      L0_ALL_PK_KEY
,      L0_ALL_PK
,      L0_NAME
,      L1_OPPORTUNITY_PK
,      L1_OPPORTUNITY_DP
,      L1_NAME
,      L1_OPPORTUNITY_LEAD_ID
,      L1_OPP_LEAD_NUMBER
,      L1_WIN_PROBABILITY
,      L1_SALES_STAGE_ID
,      L1_PRICE_LIST_ID
,      L1_INITIATING_CONTACT_ID
,      L1_CLOSE_COMPETITOR_ID
,      L1_SOURCE_PROMOTION_ID
,      L1_ADDRESS_ID
,      L1_CUSTOMER_ID
,      L1_RANK
,      L1_PARENT_PROJECT
,      L1_NO_OPP_ALLOWED_FLAG
,      L1_LEAD_SOURCE_CODE
,      L1_END_USER_CUSTOMER_NAME
,      L1_DELETE_ALLOWED_FLAG
,      L1_DECISION_DATE_FLAG
,      L1_CURRENCY_CODE
,      L1_TOTAL_AMOUNT
,      L1_CLOSE_REASON
,      L1_CLOSE_COMPETITOR_CODE
,      L1_CLOSE_COMPETITOR
,      L1_CLOSE_COMMENT
,      L1_CHANNEL_CODE
,      L1_DECISION_DATE
,      L1_OPP_DESCRIPTION
,      L1_INSTANCE
,      L1_USER_ATTRIBUTE1
,      L1_USER_ATTRIBUTE2
,      L1_USER_ATTRIBUTE3
,      L1_USER_ATTRIBUTE4
,      L1_USER_ATTRIBUTE5
,      L2_OPPLINE_PK
,      L2_OPPLINE_DP
,      L2_NAME
,      L2_OPP_LEAD_LINE_ID
,      L2_LEAD_ID
,      L2_WIN_PROBABILITY
,      L2_SALES_STAGE_ID
,      L2_PRICE_VOLUME_MARGIN
,      L2_PRICE
,      L2_ORIG_OPPORTUNITY_LINE_ID
,      L2_ORIGINAL_LEAD_LINE_ID
,      L2_QUOTED_LINE_FLAG
,      L2_CHANNEL_CODE
,      L2_SHIP_DATE
,      L2_DECISION_DATE
,      L2_INSTANCE
,      L2_USER_ATTRIBUTE1
,      L2_USER_ATTRIBUTE2
,      L2_USER_ATTRIBUTE3
,      L2_USER_ATTRIBUTE4
,      L2_USER_ATTRIBUTE5
,      L2_LAST_UPDATE_DATE
,      L2_CREATION_DATE
,      SECURITY_GROUP_ID
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      L1_ORIG_SYSTEM_REFERENCE
,      L1_VEHICLE_RESPONSE_CODE
,      L1_DECISION_TIMEFRAME_CODE
,      L1_DELETED_FLAG
FROM BIM.EDW_BIM_OPPORTUNITIES_M;

Dependencies

[top of page]

BIM.EDW_BIM_OPPORTUNITIES_M does not reference any database object

BIM.EDW_BIM_OPPORTUNITIES_M is referenced by following:

SchemaAPPS
SynonymEDW_BIM_OPPORTUNITIES_M