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: TableAS.AS_LEADS_LOG
Subobject Name:
Status: VALID


AS_LEAD_LOG stores opportunity change history


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AS_LEADS_LOG_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOG_ID
AS_LEADS_LOG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLAST_UPDATE_DATE
ColumnLEAD_ID
AS_LEADS_LOG_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEAD_ID
ColumnCREATION_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:

SchemaAPPS
SynonymAS_LEADS_LOG