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

TABLE: BIM.EDW_BIM_OPPR_OPRNTIES_LSTG

Object Details
Object Name: EDW_BIM_OPPR_OPRNTIES_LSTG
Object Type: TABLE
Owner: BIM
FND Design Data: TableBIM.EDW_BIM_OPPR_OPRNTIES_LSTG
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_OPPR_OPRNTIES_LSTG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnOPPORTUNITY_PK
EDW_BIM_OPPR_OPRNTIES_LSTG_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCOLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
OPPORTUNITY_PK VARCHAR2 (240)
Unique Identifier for Opportunity Header .
ROW_ID ROWID (10)
Row Identifier .
ALL_FK VARCHAR2 (40)
Foreign Key to All Level of the Opportunity Dimension .
ALL_FK_KEY NUMBER

System Generated Foreign Key to All Level of the Opportunity Dimension .
OPPORTUNITY_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely .
NAME VARCHAR2 (240)
Reserved for future use in Express .
OPPORTUNITY_LEAD_ID NUMBER

Oltp unique identifier for opportunity header .
OPP_LEAD_NUMBER VARCHAR2 (240)
Unique Number assigned to opportunity header .
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.
SALES_STAGE_ID NUMBER

Not used .
PRICE_LIST_ID NUMBER

Not used .
INITIATING_CONTACT_ID NUMBER

Not used .
CLOSE_COMPETITOR_ID NUMBER

Not used .
SOURCE_PROMOTION_ID NUMBER

Not used .
ADDRESS_ID NUMBER

Not used .
CUSTOMER_ID NUMBER

Not used .
RANK VARCHAR2 (240)
Not used .
PARENT_PROJECT VARCHAR2 (240)
Project to which this opportunity belongs
NO_OPP_ALLOWED_FLAG VARCHAR2 (40)
Not used .
LEAD_SOURCE_CODE VARCHAR2 (240)
Originating source code of opportunity .
END_USER_CUSTOMER_NAME VARCHAR2 (240)
Not used .
DELETE_ALLOWED_FLAG VARCHAR2 (40)
Not Used .
DECISION_DATE_FLAG VARCHAR2 (40)
Not used .
CURRENCY_CODE VARCHAR2 (240)
The currency code used for this opportunity .
TOTAL_AMOUNT NUMBER

The likely amount of sale from this opportunity .
CLOSE_REASON VARCHAR2 (240)
A reason for closing a opportunity .
CLOSE_COMPETITOR_CODE VARCHAR2 (240)
Not used .
CLOSE_COMPETITOR VARCHAR2 (240)
Not used .
CLOSE_COMMENT VARCHAR2 (240)
Not used .
CHANNEL_CODE VARCHAR2 (80)
Not used .
DECISION_DATE DATE

Not used .
OPP_DESCRIPTION VARCHAR2 (2000)
Opportunity name of the lead, usually the main interest for the lead .
INSTANCE VARCHAR2 (40)
Instance Identifier .
USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute .
USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute .
USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute .
USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute .
USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute .
REQUEST_ID NUMBER

Standard Who Column .
OPERATION_CODE VARCHAR2 (40)
Code used during warehouse collection .
ERROR_CODE VARCHAR2 (2000)
Code used to store error messages .
COLLECTION_STATUS VARCHAR2 (40)
Collection status code for the record .
SECURITY_GROUP_ID NUMBER

Standard Who Column .
ORIG_SYSTEM_REFERENCE VARCHAR2 (240)
Originating source of opportunity .
VEHICLE_RESPONSE_CODE VARCHAR2 (80)
Indicates how the lead was created .
DECISION_TIMEFRAME_CODE VARCHAR2 (80)
specify the time by when decision will be made .
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 OPPORTUNITY_PK
,      ROW_ID
,      ALL_FK
,      ALL_FK_KEY
,      OPPORTUNITY_DP
,      NAME
,      OPPORTUNITY_LEAD_ID
,      OPP_LEAD_NUMBER
,      WIN_PROBABILITY
,      SALES_STAGE_ID
,      PRICE_LIST_ID
,      INITIATING_CONTACT_ID
,      CLOSE_COMPETITOR_ID
,      SOURCE_PROMOTION_ID
,      ADDRESS_ID
,      CUSTOMER_ID
,      RANK
,      PARENT_PROJECT
,      NO_OPP_ALLOWED_FLAG
,      LEAD_SOURCE_CODE
,      END_USER_CUSTOMER_NAME
,      DELETE_ALLOWED_FLAG
,      DECISION_DATE_FLAG
,      CURRENCY_CODE
,      TOTAL_AMOUNT
,      CLOSE_REASON
,      CLOSE_COMPETITOR_CODE
,      CLOSE_COMPETITOR
,      CLOSE_COMMENT
,      CHANNEL_CODE
,      DECISION_DATE
,      OPP_DESCRIPTION
,      INSTANCE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      REQUEST_ID
,      OPERATION_CODE
,      ERROR_CODE
,      COLLECTION_STATUS
,      SECURITY_GROUP_ID
,      ORIG_SYSTEM_REFERENCE
,      VEHICLE_RESPONSE_CODE
,      DECISION_TIMEFRAME_CODE
,      DELETED_FLAG
FROM BIM.EDW_BIM_OPPR_OPRNTIES_LSTG;

Dependencies

[top of page]

BIM.EDW_BIM_OPPR_OPRNTIES_LSTG does not reference any database object

BIM.EDW_BIM_OPPR_OPRNTIES_LSTG is referenced by following:

SchemaAPPS
SynonymEDW_BIM_OPPR_OPRNTIES_LSTG