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_ALL

Object Details

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

AS_LEADS_ALL stores information about sales opportunities.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AS_LEADS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LEAD_ID
AS_LEADS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID ADDRESS_ID
AS_LEADS_N10	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPPER("PARENT_PROJECT")
AS_LEADS_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEAD_NUMBER
AS_LEADS_N19	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS DECISION_DATE
AS_LEADS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SALES_STAGE_ID
AS_LEADS_N20	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DECISION_DATE WIN_PROBABILITY
AS_LEADS_N21	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADDRESS_ID
AS_LEADS_N22	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CLOSE_COMPETITOR_ID
AS_LEADS_N23	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INCUMBENT_PARTNER_PARTY_ID
AS_LEADS_N24	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SALES_METHODOLOGY_ID
AS_LEADS_N25	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OWNER_SALESFORCE_ID OWNER_SALES_GROUP_ID
AS_LEADS_N26	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATION_DATE
AS_LEADS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE
AS_LEADS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_PROMOTION_ID
AS_LEADS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS WIN_PROBABILITY
AS_LEADS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WIN_PROBABILITY
AS_LEADS_N9	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPPER("DESCRIPTION")

Columns

Name	Datatype	Length	Mandatory	Comments
LEAD_ID	NUMBER		Yes	Lead identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
REQUEST_ID	NUMBER			Standard who column
PROGRAM_APPLICATION_ID	NUMBER			Application identifier of last concurrent program to update record
PROGRAM_ID	NUMBER			Identifier of last concurrent program to update record
PROGRAM_UPDATE_DATE	DATE			Last date concurrent program updated record
LEAD_NUMBER	VARCHAR2	(30)	Yes	Unique number for lead, system generated by sequence as_lead_number_s
STATUS	VARCHAR2	(30)	Yes	The status of this opportunity validated against as_statuses_vl
CUSTOMER_ID	NUMBER		Yes	Customer identifier
ADDRESS_ID	NUMBER			Address identifier
LEAD_SOURCE_CODE	VARCHAR2	(30)		Originating source code of lead/opportunity
ORIG_SYSTEM_REFERENCE	VARCHAR2	(240)		Unique lead identifier from foreign system
SALES_STAGE_ID	NUMBER			Sales stage identifier of this lead
INITIATING_CONTACT_ID	NUMBER			for future use
CHANNEL_CODE	VARCHAR2	(30)		Sales channel for this lead, validated against 'LEAD_CHANNEL' from order capture
TOTAL_AMOUNT	NUMBER			The likely amount of sale from this lead, summed from total amounts at the lead line level
CURRENCY_CODE	VARCHAR2	(15)		The currency code used for this lead, validated against fnd_currencies_vl
DECISION_DATE	DATE			The date the purchase decision will be made by the prospect
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.
CLOSE_REASON	VARCHAR2	(30)		A reason for closing a lead, validated against 'CLOSE_REASON' from as_lookups
CLOSE_COMPETITOR_CODE	VARCHAR2	(30)		Obsolete
CLOSE_COMPETITOR_ID	NUMBER			Customer identifier that is marked as a competitor
CLOSE_COMPETITOR	VARCHAR2	(255)		obsolete
CLOSE_COMMENT	VARCHAR2	(240)		Additional comment about the closing of this lead
DESCRIPTION	VARCHAR2	(240)		Opportunity name of the lead, usually the main interest for the lead
RANK	VARCHAR2	(30)		The rank of the lead -for future use
END_USER_CUSTOMER_NAME	VARCHAR2	(255)		Name of the end user who purchase the product from this lead if the lead was worked through a VAR
SOURCE_PROMOTION_ID	NUMBER			Promotion identfier that initiated the creation of the lead
END_USER_CUSTOMER_ID	NUMBER			PARTY_ID of end user who purchase the product from this lead if the lead was worked through a VAR
END_USER_ADDRESS_ID	NUMBER			ADDRESS_ID of end user who purchase the product from this lead if the lead was worked through a VAR
ORG_ID	NUMBER			Operating unit which performed this transaction
NO_OPP_ALLOWED_FLAG	VARCHAR2	(1)		Flag to determine whether this lead can still be set to a status of NO OPPORTUNITY based on profile OSM: No Opportunity Ceiling
DELETE_ALLOWED_FLAG	VARCHAR2	(1)		Flag to determine if this lead can still be deleted based on profile OSM: Opportunity Delete Ceiling
PARENT_PROJECT	VARCHAR2	(80)		Project to which this lead belongs
PRICE_LIST_ID	NUMBER			Price list identifier
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
DELETED_FLAG	VARCHAR2	(1)		Flag to indicate if this lead is soft deleted
AUTO_ASSIGNMENT_TYPE	VARCHAR2	(30)		Automatical assignment type
PRM_ASSIGNMENT_TYPE	VARCHAR2	(30)		PRM assignment type
CUSTOMER_BUDGET	NUMBER			Customer budget for this lead
METHODOLOGY_CODE	VARCHAR2	(30)		Obsolete
ORIGINAL_LEAD_ID	NUMBER			Lead identifier which the currenct lead was copied from
DECISION_TIMEFRAME_CODE	VARCHAR2	(30)		specify the time by when decision will be made, lookup_type DECISION_TIMEFRAME
SECURITY_GROUP_ID	NUMBER			Subscriber id, for CRM Online Services use
INCUMBENT_PARTNER_RESOURCE_ID	NUMBER			Incumbent partner resource identifier, used for PRM
INCUMBENT_PARTNER_PARTY_ID	NUMBER			Incumbent partner identifier, used for PRM
OFFER_ID	NUMBER			Promotion offer identifier from Marketing
VEHICLE_RESPONSE_CODE	VARCHAR2	(30)		Indicates how the lead was created
BUDGET_STATUS_CODE	VARCHAR2	(30)		PRM use
FOLLOWUP_DATE	DATE			PRM use
PRM_EXEC_SPONSOR_FLAG	VARCHAR2	(1)		PRM use
PRM_PRJ_LEAD_IN_PLACE_FLAG	VARCHAR2	(1)		PRM use
PRM_IND_CLASSIFICATION_CODE	VARCHAR2	(30)		industry classification code for prm. lookup_type - prm_industry_classification_type
PRM_LEAD_TYPE	VARCHAR2	(30)		For prm use to identify the lead_type. Valid values are DIRECT and INDIRECT based on lookup type PRM_LEAD_TYPE
FREEZE_FLAG	VARCHAR2	(1)		For opportunity freeze/lockout feature
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
PRM_REFERRAL_CODE	VARCHAR2	(240)		Stores the referral code of the partner
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
TOTAL_REVENUE_OPP_FORECAST_AMT	NUMBER			Sum of Sales Credits Forecast Amounts

Query Text

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


SELECT LEAD_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LEAD_NUMBER
,      STATUS
,      CUSTOMER_ID
,      ADDRESS_ID
,      LEAD_SOURCE_CODE
,      ORIG_SYSTEM_REFERENCE
,      SALES_STAGE_ID
,      INITIATING_CONTACT_ID
,      CHANNEL_CODE
,      TOTAL_AMOUNT
,      CURRENCY_CODE
,      DECISION_DATE
,      WIN_PROBABILITY
,      CLOSE_REASON
,      CLOSE_COMPETITOR_CODE
,      CLOSE_COMPETITOR_ID
,      CLOSE_COMPETITOR
,      CLOSE_COMMENT
,      DESCRIPTION
,      RANK
,      END_USER_CUSTOMER_NAME
,      SOURCE_PROMOTION_ID
,      END_USER_CUSTOMER_ID
,      END_USER_ADDRESS_ID
,      ORG_ID
,      NO_OPP_ALLOWED_FLAG
,      DELETE_ALLOWED_FLAG
,      PARENT_PROJECT
,      PRICE_LIST_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DELETED_FLAG
,      AUTO_ASSIGNMENT_TYPE
,      PRM_ASSIGNMENT_TYPE
,      CUSTOMER_BUDGET
,      METHODOLOGY_CODE
,      ORIGINAL_LEAD_ID
,      DECISION_TIMEFRAME_CODE
,      SECURITY_GROUP_ID
,      INCUMBENT_PARTNER_RESOURCE_ID
,      INCUMBENT_PARTNER_PARTY_ID
,      OFFER_ID
,      VEHICLE_RESPONSE_CODE
,      BUDGET_STATUS_CODE
,      FOLLOWUP_DATE
,      PRM_EXEC_SPONSOR_FLAG
,      PRM_PRJ_LEAD_IN_PLACE_FLAG
,      PRM_IND_CLASSIFICATION_CODE
,      PRM_LEAD_TYPE
,      FREEZE_FLAG
,      SALES_METHODOLOGY_ID
,      OWNER_SALESFORCE_ID
,      OWNER_SALES_GROUP_ID
,      PRM_REFERRAL_CODE
,      OBJECT_VERSION_NUMBER
,      TOTAL_REVENUE_OPP_FORECAST_AMT
FROM OSM.AS_LEADS_ALL;

Dependencies

[top of page]

OSM.AS_LEADS_ALL does not reference any database object

OSM.AS_LEADS_ALL is referenced by following:

OSM: AS_LEADS_ALL#