[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AS_INTEREST_CODES_B |
|---|---|
| Object Type: | TABLE |
| Owner: | OSM |
| FND Design Data: |  AS.AS_INTEREST_CODES_B
|
| Subobject Name: | |
| Status: | VALID |
This stores the code that are used for anything that
a customer or a contact may be interested in. This includes anything
from products to applications and even to competitors. It should not
be used for items that are tracked in Oracle Inventory. These items
have their own code, the Item Number, already defined in the Inventory
system.
| Tablespace: |  APPS_TS_SEED |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AS_INTEREST_CODES_B_U1 | NORMAL | UNIQUE |
APPS_TS_SEED
|
 INTEREST_CODE_ID
|
| AS_INTEREST_CODES_B_N1 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
PARENT_INTEREST_CODE_ID
|
| AS_INTEREST_CODES_B_N2 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
INTEREST_TYPE_ID
PARENT_INTEREST_CODE_ID
PRODUCT_CATEGORY_ID
PRODUCT_CAT_SET_ID
|
| AS_INTEREST_CODES_B_N3 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
ENABLED_FLAG
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INTEREST_CODE_ID | NUMBER | Yes | Interest code 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 | ||
| 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_TYPE_ID | NUMBER | Yes | Type of interest | |
| PARENT_INTEREST_CODE_ID | NUMBER | Parent interest code identifier | ||
| CATEGORY_ID | NUMBER | Category identifier | ||
| CATEGORY_SET_ID | NUMBER | Category set identifier | ||
| PF_ITEM_ID | NUMBER | Product Family item identifier | ||
| PF_ORGANIZATION_ID | NUMBER | Product Family item's organization identifier | ||
| CURRENCY_CODE | VARCHAR2 | (15) | Currency Code for the Product Family Price | |
| PRICE | NUMBER | Price in the currency. | ||
| SECURITY_GROUP_ID | NUMBER | Subscriber id, for CRM Online Services use | ||
| 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 | |
| INTERNAL_UPGRADE_CODE_ID | NUMBER | For internal use only. To keep the new interest code id upon data migration. | ||
| ENABLED_FLAG | VARCHAR2 | (1) | Master Enabled flag | |
| PRODUCT_CATEGORY_ID | NUMBER | Column to map the interest code to the new product catalog category | ||
| PRODUCT_CAT_SET_ID | NUMBER | Store 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_CODE_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_TYPE_ID
, PARENT_INTEREST_CODE_ID
, CATEGORY_ID
, CATEGORY_SET_ID
, PF_ITEM_ID
, PF_ORGANIZATION_ID
, CURRENCY_CODE
, PRICE
, SECURITY_GROUP_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, INTERNAL_UPGRADE_CODE_ID
, ENABLED_FLAG
, PRODUCT_CATEGORY_ID
, PRODUCT_CAT_SET_ID
, OBJECT_VERSION_NUMBER
FROM OSM.AS_INTEREST_CODES_B;
OSM.AS_INTEREST_CODES_B does not reference any database object
OSM.AS_INTEREST_CODES_B is referenced by following:
OSM
AS_INTEREST_CODES_B#
|
|
|
|