[Home] [Help] [Dependency Information]
Object Name: | AS_INTERESTS_ALL |
---|---|
Object Type: | TABLE |
Owner: | OSM |
FND Design Data: | AS.AS_INTERESTS_ALL |
Subobject Name: | |
Status: | VALID |
AS_INTERESTS_ALL stores information about a product that a customer,
contact, or opportunity has interested in.
.
Each row includes a value that identifies the customer, contact or
lead that the interest applies to. Each row can also include values
that identify the interaction that led to the interest, the item of
interest, a description of the nature of the interest, and the level
of interest.
.
You can create records in AS_SCRIPT_ANSWER_ACTIONS that will trigger
the creation of a row in AS_INTERESTS_ALL when a contact gives a
pre-defined answer to a script question.
.
.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AS_INTERESTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
INTEREST_ID
ORG_ID |
AS_INTERESTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CUSTOMER_ID
ADDRESS_ID |
AS_INTERESTS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CONTACT_ID |
AS_INTERESTS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LEAD_ID |
AS_INTERESTS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
INTEREST_TYPE_ID
INTEREST_USE_CODE |
AS_INTERESTS_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ADDRESS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTEREST_ID | NUMBER | Yes | Product interest 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 | ||
INTEREST_USE_CODE | VARCHAR2 | (30) | Yes | Type of interest/classification (LEAD, CONTACT, or COMPANY) |
INTEREST_TYPE_ID | NUMBER | Obsolete. Type of interest | ||
CUSTOMER_ID | NUMBER | Yes | Customer/prospect identifier | |
ADDRESS_ID | NUMBER | Account identifier | ||
LEAD_ID | NUMBER | Lead identifier | ||
CONTACT_ID | NUMBER | Contact identifier | ||
PRIMARY_INTEREST_CODE_ID | NUMBER | Obsolete. Primary interest code identifier | ||
SECONDARY_INTEREST_CODE_ID | NUMBER | Obsolete. Secondary interest code identifier | ||
STATUS_CODE | VARCHAR2 | (30) | Level of interest code | |
DESCRIPTION | VARCHAR2 | (240) | Description of the interest | |
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 | |
SECURITY_GROUP_ID | NUMBER | Subscriber id, for CRM Online Services use | ||
INTERNAL_UPGRADE_CUST_ID | NUMBER | Column used to store old customer id for interest_use_code = 'CONTACT_INTEREST' | ||
INTERNAL_UPGRADE_REL_ID | NUMBER | Column used to store old customer id (subject_id) for interest_use_code = 'CONTACT_INTEREST' | ||
PRODUCT_CATEGORY_ID | NUMBER | Maps to the new product category | ||
PRODUCT_CAT_SET_ID | NUMBER | Stores the category set id of the catalog | ||
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number |
Cut, paste (and edit) the following text to query this object:
SELECT INTEREST_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, INTEREST_USE_CODE
, INTEREST_TYPE_ID
, CUSTOMER_ID
, ADDRESS_ID
, LEAD_ID
, CONTACT_ID
, PRIMARY_INTEREST_CODE_ID
, SECONDARY_INTEREST_CODE_ID
, STATUS_CODE
, DESCRIPTION
, ORG_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, INTERNAL_UPGRADE_CUST_ID
, INTERNAL_UPGRADE_REL_ID
, PRODUCT_CATEGORY_ID
, PRODUCT_CAT_SET_ID
, OBJECT_VERSION_NUMBER
FROM OSM.AS_INTERESTS_ALL;
OSM.AS_INTERESTS_ALL does not reference any database object
OSM.AS_INTERESTS_ALL is referenced by following:
|
|
|