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]

TABLE: BIM.EDW_BIM_OPPR_OPRNTIES_LTC

Object Details

Object Name:	EDW_BIM_OPPR_OPRNTIES_LTC
Object Type:	TABLE
Owner:	BIM
FND Design Data:	BIM.EDW_BIM_OPPR_OPRNTIES_LTC
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:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EDW_BIM_OPPR_OPRNTIES_LTC_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	OPPORTUNITY_PK_KEY
EDW_BIM_OPPR_OPRNTIES_LTC_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	ALL_FK_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
OPPORTUNITY_PK	VARCHAR2	(240)		Unique Identifier for Opportunity Header .
OPPORTUNITY_PK_KEY	NUMBER			System Generated Unique Identifier for Opportunity Header .
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 .
SECURITY_GROUP_ID	NUMBER			Standard Who Column .
LAST_UPDATE_DATE	DATE		Yes
CREATION_DATE	DATE		Yes
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
,      OPPORTUNITY_PK_KEY
,      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
,      SECURITY_GROUP_ID
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      ORIG_SYSTEM_REFERENCE
,      VEHICLE_RESPONSE_CODE
,      DECISION_TIMEFRAME_CODE
,      DELETED_FLAG
FROM BIM.EDW_BIM_OPPR_OPRNTIES_LTC;

Dependencies

[top of page]

BIM.EDW_BIM_OPPR_OPRNTIES_LTC does not reference any database object

BIM.EDW_BIM_OPPR_OPRNTIES_LTC is referenced by following:

BIM: EDW_BIM_OPPR_OPRNTIES_LTC#