[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AS_SALES_LEADS |
|---|---|
| Object Type: | TABLE |
| Owner: | OSM |
| FND Design Data: |  AS.AS_SALES_LEADS
|
| Subobject Name: | |
| Status: | VALID |
AS_SALES_LEADS stores information about sales leads Each row can
include values that describe your budget_status, timeframe, contact etc.
These parameters are used to qualify it and route the sales lead to the
corresponding sales person.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AS_SALES_LEADS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 SALES_LEAD_ID
|
| AS_SALES_LEADS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ASSIGN_TO_PERSON_ID
|
| AS_SALES_LEADS_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LEAD_NUMBER
|
| AS_SALES_LEADS_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CREATION_DATE
|
| AS_SALES_LEADS_N12 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_TX_DATA
|
"LAST_UPDATE_DATE"
|
| AS_SALES_LEADS_N13 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARENT_PROJECT
|
| AS_SALES_LEADS_N14 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DESCRIPTION
|
| AS_SALES_LEADS_N16 | NORMAL | NONUNIQUE |
APPS_TS_TX_DATA
|
STATUS_CODE
LEAD_RANK_ID
|
| AS_SALES_LEADS_N17 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ASSIGN_DATE
|
| AS_SALES_LEADS_N18 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORIG_SYSTEM_REFERENCE
|
| AS_SALES_LEADS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CUSTOMER_ID
ADDRESS_ID
|
| AS_SALES_LEADS_N20 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PRIMARY_CONTACT_PARTY_ID
|
| AS_SALES_LEADS_N21 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PRIMARY_CNT_PERSON_PARTY_ID
|
| AS_SALES_LEADS_N23 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ADDRESS_ID
|
| AS_SALES_LEADS_N24 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PRIMARY_CONTACT_PHONE_ID
|
| AS_SALES_LEADS_N25 | NORMAL | NONUNIQUE |
APPS_TS_TX_DATA
|
ASSIGN_TO_SALESFORCE_ID
STATUS_CODE
|
| AS_SALES_LEADS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ASSIGN_SALES_GROUP_ID
|
| AS_SALES_LEADS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SOURCE_PROMOTION_ID
|
| AS_SALES_LEADS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CHANNEL_CODE
|
| AS_SALES_LEADS_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
OFFER_ID
|
| AS_SALES_LEADS_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LAST_UPDATE_DATE
|
| AS_SALES_LEADS_N8 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_TX_DATA
|
"LEAD_RANK_SCORE"
"CREATION_DATE"
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SALES_LEAD_ID | NUMBER | Yes | Sales 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 Sales Leads. |
| STATUS_CODE | VARCHAR2 | (30) | Yes | The status of this sales lead validated against as_statuses_b |
| CUSTOMER_ID | NUMBER | Yes | Customer identifier | |
| ADDRESS_ID | NUMBER | Address identifier | ||
| SOURCE_PROMOTION_ID | NUMBER | Promotion identfier that initiated the creation of this sales lead - ams_source_codes.source_code_id | ||
| INITIATING_CONTACT_ID | NUMBER | For future use, store primary contact id | ||
| ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) | Identifies the source of sales lead - MKT,ISTORE | |
| CONTACT_ROLE_CODE | VARCHAR2 | (30) | Obsolete in 11i | |
| CHANNEL_CODE | VARCHAR2 | (30) | Sales channel for this sales lead, validated against aso_i_sales_channels_v | |
| BUDGET_AMOUNT | NUMBER | Estimated budget amount | ||
| CURRENCY_CODE | VARCHAR2 | (15) | The currency code used for this sales lead, validated against fnd_currencies_vl | |
| DECISION_TIMEFRAME_CODE | VARCHAR2 | (30) | Specifies the time by when decision will be made | |
| CLOSE_REASON | VARCHAR2 | (30) | A reason for closing a sales lead, validated against 'CLOSE_REASON_TYPE' from as_lookups | |
| LEAD_RANK_CODE | VARCHAR2 | (30) | Obsolete in 11i -- use lead_rank_id instead | |
| PARENT_PROJECT | VARCHAR2 | (80) | Parent project of this sales lead | |
| DESCRIPTION | VARCHAR2 | (2000) | Description of sales lead | |
| 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 | |
| ASSIGN_TO_PERSON_ID | NUMBER | The EMPLOYEE_PERSON_ID of whom the sales lead is assigned to | ||
| ASSIGN_DATE | DATE | Assign Date | ||
| BUDGET_STATUS_CODE | VARCHAR2 | (30) | Budget status , validated values are APPROVED, NOT APPROVED and PENDING | |
| ACCEPT_FLAG | VARCHAR2 | (1) | Indicates the Lead is accepted | |
| VEHICLE_RESPONSE_CODE | VARCHAR2 | (30) | Indicates how the lead was created | |
| TOTAL_SCORE | NUMBER | Total score of this sales lead | ||
| SCORECARD_ID | NUMBER | Indicates which score card was used to rank the sales lead | ||
| KEEP_FLAG | VARCHAR2 | (1) | Obsolete : To indicate user would like to keep the sales lead | |
| URGENT_FLAG | VARCHAR2 | (1) | To signify this is an urgent sales lead | |
| IMPORT_FLAG | VARCHAR2 | (1) | Indicates the deal is imported | |
| REJECT_REASON_CODE | VARCHAR2 | (30) | The reason code for rejecting this sales lead | |
| LEAD_RANK_ID | NUMBER | FK to AS_SALES_LEAD_RANKS_B | ||
| ASSIGN_SALES_GROUP_ID | NUMBER | The sales group id for assign_to_salesforce_id | ||
| DELETED_FLAG | VARCHAR2 | (1) | To indicate this sales lead has been soft deleted. | |
| OFFER_ID | NUMBER | Promotions offer | ||
| SECURITY_GROUP_ID | NUMBER | Subscriber id, for CRM Online Services use | ||
| INCUMBENT_PARTNER_PARTY_ID | NUMBER | Incumbent partner identifier, used for PRM | ||
| INCUMBENT_PARTNER_RESOURCE_ID | NUMBER | Incumbent partner resource identifier, used for PRM | ||
| PRM_EXEC_SPONSOR_FLAG | VARCHAR2 | (1) | PRM use | |
| PRM_PRJ_LEAD_IN_PLACE_FLAG | VARCHAR2 | (1) | PRM use | |
| ASSIGN_TO_SALESFORCE_ID | NUMBER | The resource_id of whom is this sales lead assigned to | ||
| PRM_SALES_LEAD_TYPE | VARCHAR2 | (30) | For PRM use to identify the sales_lead_type. Valid values are DIRECT and INDIRECT based on lookup type PRM_LEAD_TYPE | |
| PRM_IND_CLASSIFICATION_CODE | VARCHAR2 | (30) | industry classification code for PRM. lookup_type - prm_industry_classification_type | |
| AUTO_ASSIGNMENT_TYPE | VARCHAR2 | (30) | Assignment type for TAP processing | |
| QUALIFIED_FLAG | VARCHAR2 | (1) | Indicates whether the lead is qualified or not. | |
| ORIG_SYSTEM_CODE | VARCHAR2 | (30) | lead source of a lead imported by Lead import program | |
| PRM_ASSIGNMENT_TYPE | VARCHAR2 | (30) | For PRM use | |
| PRIMARY_CONTACT_PARTY_ID | NUMBER | Relationship party id of the contact denormalised from AS_SALES_LEAD_CONTACTS.CONTACT_PARTY_ID | ||
| PRIMARY_CNT_PERSON_PARTY_ID | NUMBER | Party id of primary contact | ||
| PRIMARY_CONTACT_PHONE_ID | NUMBER | Phone id of primary contact | ||
| REFERRED_BY | NUMBER | Party name of the referring partner | ||
| REFERRAL_STATUS | VARCHAR2 | (30) | Referral status for tracking lead referral | |
| REF_ORDER_NUMBER | NUMBER | Referral order number | ||
| REF_ORDER_AMT | NUMBER | Referral order amount | ||
| REF_COMM_AMT | NUMBER | Referral commission amount | ||
| REF_DECLINE_REASON | VARCHAR2 | (30) | Referral decline reason | |
| REF_COMM_LTR_STATUS | VARCHAR2 | (30) | Referral commission letter status | |
| REFERRAL_TYPE | VARCHAR2 | (30) | Referral type | |
| TRUNC_CREATION_DATE | DATE | Trunc of creation date | ||
| LEAD_DATE | DATE | Stores the lead date | ||
| COUNTRY | VARCHAR2 | (60) | Country | |
| SOURCE_SYSTEM | VARCHAR2 | (30) | Source system of the sales lead | |
| TOTAL_AMOUNT | NUMBER | Total amount | ||
| EXPIRATION_DATE | DATE | Expiration date | ||
| LEAD_RANK_IND | VARCHAR2 | (1) | Lead rank indicator | |
| LEAD_ENGINE_RUN_DATE | DATE | Lead Engine Run Date | ||
| CURRENT_REROUTES | NUMBER | Current Reroutes | ||
| STATUS_OPEN_FLAG | VARCHAR2 | (1) | Flag indicating if lead status is open or closed | |
| LEAD_RANK_SCORE | NUMBER | Lead Rank Score | ||
| MARKETING_SCORE | NUMBER | Marketing score to raise the value of the lead | ||
| INTERACTION_SCORE | NUMBER | Score of the leads created from interaction mining | ||
| SOURCE_PRIMARY_REFERENCE | VARCHAR2 | (240) | Source system primary reference number for tracking originating source for lead | |
| SOURCE_SECONDARY_REFERENCE | VARCHAR2 | (240) | Source system secondary reference number for tracking originating source for lead | |
| SALES_METHODOLOGY_ID | NUMBER | SALES METHODOLOGY ID | ||
| SALES_STAGE_ID | NUMBER | Sales stage id for methodology | ||
| OBJECT_VERSION_NUMBER | NUMBER | Object Version Number |
Cut, paste (and edit) the following text to query this object:
SELECT SALES_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_CODE
, CUSTOMER_ID
, ADDRESS_ID
, SOURCE_PROMOTION_ID
, INITIATING_CONTACT_ID
, ORIG_SYSTEM_REFERENCE
, CONTACT_ROLE_CODE
, CHANNEL_CODE
, BUDGET_AMOUNT
, CURRENCY_CODE
, DECISION_TIMEFRAME_CODE
, CLOSE_REASON
, LEAD_RANK_CODE
, PARENT_PROJECT
, DESCRIPTION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ASSIGN_TO_PERSON_ID
, ASSIGN_DATE
, BUDGET_STATUS_CODE
, ACCEPT_FLAG
, VEHICLE_RESPONSE_CODE
, TOTAL_SCORE
, SCORECARD_ID
, KEEP_FLAG
, URGENT_FLAG
, IMPORT_FLAG
, REJECT_REASON_CODE
, LEAD_RANK_ID
, ASSIGN_SALES_GROUP_ID
, DELETED_FLAG
, OFFER_ID
, SECURITY_GROUP_ID
, INCUMBENT_PARTNER_PARTY_ID
, INCUMBENT_PARTNER_RESOURCE_ID
, PRM_EXEC_SPONSOR_FLAG
, PRM_PRJ_LEAD_IN_PLACE_FLAG
, ASSIGN_TO_SALESFORCE_ID
, PRM_SALES_LEAD_TYPE
, PRM_IND_CLASSIFICATION_CODE
, AUTO_ASSIGNMENT_TYPE
, QUALIFIED_FLAG
, ORIG_SYSTEM_CODE
, PRM_ASSIGNMENT_TYPE
, PRIMARY_CONTACT_PARTY_ID
, PRIMARY_CNT_PERSON_PARTY_ID
, PRIMARY_CONTACT_PHONE_ID
, REFERRED_BY
, REFERRAL_STATUS
, REF_ORDER_NUMBER
, REF_ORDER_AMT
, REF_COMM_AMT
, REF_DECLINE_REASON
, REF_COMM_LTR_STATUS
, REFERRAL_TYPE
, TRUNC_CREATION_DATE
, LEAD_DATE
, COUNTRY
, SOURCE_SYSTEM
, TOTAL_AMOUNT
, EXPIRATION_DATE
, LEAD_RANK_IND
, LEAD_ENGINE_RUN_DATE
, CURRENT_REROUTES
, STATUS_OPEN_FLAG
, LEAD_RANK_SCORE
, MARKETING_SCORE
, INTERACTION_SCORE
, SOURCE_PRIMARY_REFERENCE
, SOURCE_SECONDARY_REFERENCE
, SALES_METHODOLOGY_ID
, SALES_STAGE_ID
, OBJECT_VERSION_NUMBER
FROM OSM.AS_SALES_LEADS;
OSM.AS_SALES_LEADS does not reference any database object
OSM.AS_SALES_LEADS is referenced by following:
APPS
AS_SALES_LEADS
AS_SALES_LEADS_BIUD
|
|
|
|