[Home] [Help] [Dependency Information]
Object Name: | ICX_POR_DESCRIPTORS_CACHE |
---|---|
Object Type: | TABLE |
Owner: | ICX |
FND Design Data: | ICX.ICX_POR_DESCRIPTORS_CACHE |
Subobject Name: | |
Status: | VALID |
Table to implement Caching in the Base Attributes creation and management. This table has been designed to give the operator a facility to do Review and Submit for all the changes done.
During editing/creation of attributes online, all edits/creations/deletes are stored in this table which is a copy of the ICX_POR_DESCRIPTORS_TL table. The user then has the opportunity to review the changes prior to submission.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ICX_POR_DESCRIPTORS_CACHE_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
SESSION_KEY
RT_DESCRIPTOR_ID RT_CATEGORY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION_KEY | VARCHAR2 | (250) | Yes | Unique Identifier for the user session |
DB_ACTION | VARCHAR2 | (10) | Yes | Database Action - ADD/EDIT/DELETE |
RT_DESCRIPTOR_ID | NUMBER | Yes | Unique Identifier for attribute/descriptor | |
RT_CATEGORY_ID | NUMBER | Yes | Unique Identifier for Category | |
LANGUAGE | VARCHAR2 | (4) | Yes | Language |
KEY | VARCHAR2 | (250) | Yes | Attribute/Descriptor Key |
CLASS | VARCHAR2 | (30) | Yes | Descriptor Class - POM_BASE_ATTR / IPD_BASE_ATTR / POM_CAT_ATTR |
TYPE | VARCHAR2 | (30) | Yes | Descriptor/Attribute Type |
SEQUENCE | VARCHAR2 | (30) | Sequence | |
DESCRIPTOR_NAME | VARCHAR2 | (250) | Yes | Descriptor Name |
DESCRIPTION | VARCHAR2 | (2000) | Description | |
ITEM_DETAIL_VISIBLE | VARCHAR2 | (1) | Yes | Indicates whether this Descriptor will be visible when Item Details are displayed. |
SEARCH_RESULTS_VISIBLE | VARCHAR2 | (1) | Yes | Indicates whether this Descriptor will be visible when Search Results are displayed. |
SEARCHABLE | VARCHAR2 | (1) | Yes | Indicates whether items are searchable based on this Descriptor's value. |
REQUIRED | VARCHAR2 | (1) | Yes | Indicates whether the attribute/descriptor is required. |
MULTIVALUE | VARCHAR2 | (1) | Reserved for future use. | |
CUSTOMIZATION_LEVEL | VARCHAR2 | (30) | Yes | Customization Level (All the attributes of this attribute are implemented in a bitmap 0 - No1 - Yes) |
SECTION_TAG | NUMBER | Section Tag used for the descriptor in the Section based searching | ||
CREATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION_KEY
, DB_ACTION
, RT_DESCRIPTOR_ID
, RT_CATEGORY_ID
, LANGUAGE
, KEY
, CLASS
, TYPE
, SEQUENCE
, DESCRIPTOR_NAME
, DESCRIPTION
, ITEM_DETAIL_VISIBLE
, SEARCH_RESULTS_VISIBLE
, SEARCHABLE
, REQUIRED
, MULTIVALUE
, CUSTOMIZATION_LEVEL
, SECTION_TAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM ICX.ICX_POR_DESCRIPTORS_CACHE;
ICX.ICX_POR_DESCRIPTORS_CACHE does not reference any database object
ICX.ICX_POR_DESCRIPTORS_CACHE is referenced by following:
|
|
|