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: OSM.AS_LEADS_LOG

Object Details

Object Name:	AS_LEADS_LOG
Object Type:	TABLE
Owner:	OSM
FND Design Data:	AS.AS_LEADS_LOG
Subobject Name:
Status:	VALID

AS_LEAD_LOG stores opportunity change history

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AS_LEADS_LOG_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LOG_ID
AS_LEADS_LOG_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE LEAD_ID
AS_LEADS_LOG_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CURRENT_LOG
AS_LEADS_LOG_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEAD_ID CREATION_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
LOG_ID	NUMBER		Yes	Lead Log Identifier
LEAD_ID	NUMBER		Yes	Lead Identifier
CREATED_BY	NUMBER		Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column
STATUS_CODE	VARCHAR2	(30)		The status of the lead validated against as_statuses_vl
SALES_STAGE_ID	NUMBER			Sales stage identifier of the lead
WIN_PROBABILITY	NUMBER			Probability that this lead will be won. The higher the percentage the higher the chance of making the sale.
DECISION_DATE	DATE			The date that the purchase decision will be made by the prospect
SECURITY_GROUP_ID	NUMBER			Subscriber id, for CRM Online Services use
LOG_MODE	VARCHAR2	(1)		Log mode
CUSTOMER_ID	NUMBER			Customer identifier of the lead
ADDRESS_ID	NUMBER			Address identifier of the lead
CHANNEL_CODE	VARCHAR2	(240)		Sales channel for this lead, validated against 'LEAD_CHANNEL' from order capture
CURRENCY_CODE	VARCHAR2	(240)		The currency code used for this lead, validated against fnd_currencies_vl
TOTAL_AMOUNT	NUMBER			The likely amount of sale from this lead, summed from total amounts at the lead line level
DESCRIPTION	VARCHAR2	(240)		Opportunity description
SOURCE_PROMOTION_ID	NUMBER			Source code identifier
OFFER_ID	NUMBER			Promotion offer identifier from Marketing
CLOSE_COMPETITOR_ID	NUMBER			Customer identifier that is marked as a competitor
VEHICLE_RESPONSE_CODE	VARCHAR2	(30)		Indicates how the lead was created
SALES_METHODOLOGY_ID	NUMBER			Sales Methodology Identifier of this lead
OWNER_SALESFORCE_ID	NUMBER			Owner salesforce identifier
OWNER_SALES_GROUP_ID	NUMBER			Owner sales group identifier
ORG_ID	NUMBER			Operating unit which performed this transaction
LOG_START_DATE	DATE			The date that this log is created.
LOG_END_DATE	DATE			The date that this log end.
LOG_ACTIVE_DAYS	NUMBER			The number of days that this log stayed active.
ENDDAY_LOG_FLAG	VARCHAR2	(1)		If this log is the end day log.
CURRENT_LOG	NUMBER			Indicates if the log represent the current state of the opportunity.
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number

Query Text

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


SELECT LOG_ID
,      LEAD_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      STATUS_CODE
,      SALES_STAGE_ID
,      WIN_PROBABILITY
,      DECISION_DATE
,      SECURITY_GROUP_ID
,      LOG_MODE
,      CUSTOMER_ID
,      ADDRESS_ID
,      CHANNEL_CODE
,      CURRENCY_CODE
,      TOTAL_AMOUNT
,      DESCRIPTION
,      SOURCE_PROMOTION_ID
,      OFFER_ID
,      CLOSE_COMPETITOR_ID
,      VEHICLE_RESPONSE_CODE
,      SALES_METHODOLOGY_ID
,      OWNER_SALESFORCE_ID
,      OWNER_SALES_GROUP_ID
,      ORG_ID
,      LOG_START_DATE
,      LOG_END_DATE
,      LOG_ACTIVE_DAYS
,      ENDDAY_LOG_FLAG
,      CURRENT_LOG
,      OBJECT_VERSION_NUMBER
FROM OSM.AS_LEADS_LOG;

Dependencies

[top of page]

OSM.AS_LEADS_LOG does not reference any database object

OSM.AS_LEADS_LOG is referenced by following:

OSM: AS_LEADS_LOG#