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]

VIEW: APPS.AS_LEADS

Object Details

Object Name:	AS_LEADS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AS.AS_LEADS
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.

View Type

Internal

[View Source]

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			Request identifier of last concurrent program to update record
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 lead number
STATUS	VARCHAR2	(30)	Yes	Status of lead
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
INITIATING_CONTACT_ID	NUMBER			Obsolete
CHANNEL_CODE	VARCHAR2	(30)		Sales channel, validated against 'LEAD_CHANNEL' from Order Capture
TOTAL_AMOUNT	NUMBER			Total amount of lead (sales opportunity)
CURRENCY_CODE	VARCHAR2	(15)		Currency code from fnd_currencies_vl
DECISION_DATE	DATE			Date that prospect is expected to decide about sale
WIN_PROBABILITY	NUMBER			Percentage or probability that sale will be made
CLOSE_REASON	VARCHAR2	(30)		Reason for closing of opportunity, validated against 'CLOSE_REASON' from as_lookups
CLOSE_COMPETITOR	VARCHAR2	(255)		Competitor who won the deal, free format text
CLOSE_COMPETITOR_ID	NUMBER			Close competitor identifier, validated against ra_customers where competitor_flag = 'Y'
CLOSE_COMMENT	VARCHAR2	(240)		Additional comments on why the lead was closed
DESCRIPTION	VARCHAR2	(240)		Opportunity name (main interest) of lead
RANK	VARCHAR2	(30)		Rank of the lead - not currently used
END_USER_CUSTOMER_NAME	VARCHAR2	(255)		End user customer, free format text, when lead is worked through a VAR
SOURCE_PROMOTION_ID	NUMBER			Promotion identifier that initiated the creation of the lead
END_USER_CUSTOMER_ID	NUMBER			End user customer identifier when lead is worked through a VAR
END_USER_ADDRESS_ID	NUMBER			End user address identifier when lead is worked through a VAR
ORG_ID	NUMBER			Operating unit which performed this transaction
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
PARENT_PROJECT	VARCHAR2	(80)		Project to which this lead belongs
CLOSE_COMPETITOR_CODE	VARCHAR2	(30)		Close competitor, validated against 'COMPETITOR' from as_lookups
NO_OPP_ALLOWED_FLAG	VARCHAR2	(1)		Flag to determine whether or not lead can be set a status of NO OPPORUNITY
DELETE_ALLOWED_FLAG	VARCHAR2	(1)		Flag to determine if a lead can still be deleted
PRICE_LIST_ID	NUMBER			Price List identifier
AUTO_ASSIGNMENT_TYPE	VARCHAR2	(30)		Auto Assign Ment Type
PRM_ASSIGNMENT_TYPE	VARCHAR2	(30)		Prm Assignmant Type
CUSTOMER_BUDGET	NUMBER			Customer Budget
DELETED_FLAG	VARCHAR2	(1)		Deleted Flag
METHODOLOGY_CODE	VARCHAR2	(30)		Methodology Code
ORIGINAL_LEAD_ID	NUMBER			Unique identifier for Original Lead
DECISION_TIMEFRAME_CODE	VARCHAR2	(30)		Decision Timeframe Code
INCUMBENT_PARTNER_RESOURCE_ID	NUMBER			Unique identifier for Incumbent Partner Resource
INCUMBENT_PARTNER_PARTY_ID	NUMBER			Unique identifier for Incumbent Partner Party
OFFER_ID	NUMBER			Unique identifier for Offer
VEHICLE_RESPONSE_CODE	VARCHAR2	(30)		Vehicle Response Code
BUDGET_STATUS_CODE	VARCHAR2	(30)		Budget Status Code
FOLLOWUP_DATE	DATE			Followup Date
PRM_EXEC_SPONSOR_FLAG	VARCHAR2	(1)		Prm Exec Sponsor Flag
PRM_PRJ_LEAD_IN_PLACE_FLAG	VARCHAR2	(1)		Prm Prj Lead In Place Flag
PRM_IND_CLASSIFICATION_CODE	VARCHAR2	(30)		Prm Ind Classification Code
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

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
,      CLOSE_COMPETITOR_ID
,      CLOSE_COMMENT
,      DESCRIPTION
,      RANK
,      END_USER_CUSTOMER_NAME
,      SOURCE_PROMOTION_ID
,      END_USER_CUSTOMER_ID
,      END_USER_ADDRESS_ID
,      ORG_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PARENT_PROJECT
,      CLOSE_COMPETITOR_CODE
,      NO_OPP_ALLOWED_FLAG
,      DELETE_ALLOWED_FLAG
,      PRICE_LIST_ID
,      AUTO_ASSIGNMENT_TYPE
,      PRM_ASSIGNMENT_TYPE
,      CUSTOMER_BUDGET
,      DELETED_FLAG
,      METHODOLOGY_CODE
,      ORIGINAL_LEAD_ID
,      DECISION_TIMEFRAME_CODE
,      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
FROM APPS.AS_LEADS;

Dependencies

[top of page]

APPS.AS_LEADS references the following:

APPS: AS_LEADS_ALL

APPS.AS_LEADS is referenced by following:

APPS: AS_ACCESS_PVT - show dependent code; AS_COMPETITOR_PROD_PVT - show dependent code; AS_OPP_CONTACT_PVT - show dependent code; AS_OPP_HEADER_PVT - show dependent code; AS_OPP_LINE_PVT - show dependent code; AS_OPP_SALES_CREDIT_PVT - show dependent code; AS_TERRITORY_ACCESSES_V; PA_PROJECT_REQUEST_PVT - show dependent code