DBA Data[Home] [Help] [Dependency Information]

TABLE: IBE.IBE_CT_IMEDIA_SEARCH

Object Details
Object Name: IBE_CT_IMEDIA_SEARCH
Object Type: TABLE
Owner: IBE
FND Design Data: TableIBE.IBE_CT_IMEDIA_SEARCH
Subobject Name:
Status: VALID


IBE_CT_IMEDIA_SEARCH is used by iStore to search for product items. This table is denormalized, and it combines data from MTL_SYSTEM_ITEMS_TL table and MTL_ITEM_CATEGORIES table . An intermedia index on the INDEXED_SEARCH column is primarily used in the search.
INDEXED_SEARCH Column can be customized depending on what data merchant wants to enable searching on . Currently it contains Item name (description from mtl_system_items_tl) and Item description (long description from mtl_system_items_tl) as an out of box implementation.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: IBE_CT_IMEDIA_SEARCH_PK
  1. ColumnIBE_CT_IMEDIA_SEARCH_ID
Indexes
Index Type Uniqueness Tablespace Column
IBE_CT_IMEDIA_SEARCH_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnIBE_CT_IMEDIA_SEARCH_ID
IBE_CT_IMEDIA_SEARCH_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_ID
ColumnORGANIZATION_ID
ColumnLANGUAGE
ColumnCATEGORY_ID
ColumnCATEGORY_SET_ID
SYS_IL0000083623C00015$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
IBE_CT_IMEDIA_SEARCH_ID NUMBER (15) Yes InterMedia Search Identifier.
OBJECT_VERSION_NUMBER NUMBER (9)
Object version number for locking
CREATED_BY NUMBER

Standard Who Column
CREATION_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER

Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
CATEGORY_ID NUMBER (15) Yes Category Identifier.
ORGANIZATION_ID NUMBER (15) Yes Organization Identifier.
CATEGORY_SET_ID NUMBER
Yes Category set identifier.
INVENTORY_ITEM_ID NUMBER (15) Yes Inventory Item Identifier.
LANGUAGE VARCHAR2 (4)
Language
DESCRIPTION VARCHAR2 (240)
Description of Inventory Item.
LONG_DESCRIPTION VARCHAR2 (4000)
Long Description of Inventory Item.
INDEXED_SEARCH CLOB (4000)
InterMedia Enabled Search Column.
WEB_STATUS VARCHAR2 (30)
**** Not Currently Used.
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT IBE_CT_IMEDIA_SEARCH_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CATEGORY_ID
,      ORGANIZATION_ID
,      CATEGORY_SET_ID
,      INVENTORY_ITEM_ID
,      LANGUAGE
,      DESCRIPTION
,      LONG_DESCRIPTION
,      INDEXED_SEARCH
,      WEB_STATUS
,      SECURITY_GROUP_ID
FROM IBE.IBE_CT_IMEDIA_SEARCH;

Dependencies

[top of page]

IBE.IBE_CT_IMEDIA_SEARCH does not reference any database object

IBE.IBE_CT_IMEDIA_SEARCH is referenced by following:

SchemaIBE
ViewIBE_CT_IMEDIA_SEARCH#