DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AS_LEADS

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

SchemaAPPS
SynonymAS_LEADS_ALL
APPS.AS_LEADS is referenced by following:

SchemaAPPS
Package BodyAS_ACCESS_PVT - show dependent code
Package BodyAS_COMPETITOR_PROD_PVT - show dependent code
Package BodyAS_OPP_CONTACT_PVT - show dependent code
Package BodyAS_OPP_HEADER_PVT - show dependent code
Package BodyAS_OPP_LINE_PVT - show dependent code
Package BodyAS_OPP_SALES_CREDIT_PVT - show dependent code
ViewAS_TERRITORY_ACCESSES_V
Package BodyPA_PROJECT_REQUEST_PVT - show dependent code