[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:
|
|
|