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

TABLE: ICX.ICX_POR_CTX_TL

Object Details
Object Name: ICX_POR_CTX_TL
Object Type: TABLE
Owner: ICX
FND Design Data: TableICX.ICX_POR_CTX_TL
Subobject Name:
Status: VALID


ICX_POR_CTX_TL is created for Advanced Search capabilities. The table implements the 'detail-datastore' for intermedia index. This table stores the CTX_ string (with section tags) and has ICX_POR_ITEMS_TL as its Master (rt_item_id is the joining key). Each record in this table populates only 1 of the CTX_ columns since it corresponds to a particular language.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000149130C00001$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00002$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00003$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00004$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00005$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00006$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00007$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00008$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00009$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00010$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00011$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00012$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00013$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00014$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00015$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00016$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00017$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00018$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00019$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00020$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00021$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00022$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00023$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00024$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00025$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00026$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00027$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00028$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00029$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00030$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00031$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00032$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00033$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00034$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00035$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00036$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
SYS_IL0000149130C00039$$ LOB UNIQUE TablespaceAPPS_TS_ARCHIVE
Columns
Name Datatype Length Mandatory Comments
CTX_AR CLOB (4000)
Arabic
CTX_BG CLOB (4000)
Bulgarian
CTX_CA CLOB (4000)
Catalan
CTX_CS CLOB (4000)
Czech
CTX_D CLOB (4000)
German
CTX_DK CLOB (4000)
Danish
CTX_E CLOB (4000)
Spanish
CTX_EG CLOB (4000)
Egyptian
CTX_EL CLOB (4000)
Greek
CTX_ESA CLOB (4000)
Latin American Spanish
CTX_F CLOB (4000)
French
CTX_FRC CLOB (4000)
Canadian French
CTX_GB CLOB (4000)
English
CTX_HR CLOB (4000)
Croatian
CTX_HU CLOB (4000)
Hungarian
CTX_I CLOB (4000)
Italian
CTX_IS CLOB (4000)
Icelandic
CTX_IW CLOB (4000)
Hebrew
CTX_JA CLOB (4000)
Japanese
CTX_KO CLOB (4000)
Korean
CTX_LT CLOB (4000)
Lithuanian
CTX_N CLOB (4000)
Norwegian
CTX_NL CLOB (4000)
Dutch
CTX_PL CLOB (4000)
Polish
CTX_PT CLOB (4000)
Portugese
CTX_PTB CLOB (4000)
Brazilian Portugese
CTX_RO CLOB (4000)
Romamian
CTX_RU CLOB (4000)
Russian
CTX_S CLOB (4000)
Swedish
CTX_SF CLOB (4000)
Finnish
CTX_SK CLOB (4000)
Slovek
CTX_SL CLOB (4000)
Slovenian
CTX_TH CLOB (4000)
Thai
CTX_TR CLOB (4000)
Turkish
CTX_ZHT CLOB (4000)
Traditional Chinese
CTX_ZHS CLOB (4000)
Simplified Chinese
RT_ITEM_ID NUMBER
Yes Item ID
LANGUAGE VARCHAR2 (4) Yes Defined language for the row
CTX_US CLOB (4000)
American English
SEQUENCE NUMBER
Yes Sequence
Query Text

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


SELECT CTX_AR
,      CTX_BG
,      CTX_CA
,      CTX_CS
,      CTX_D
,      CTX_DK
,      CTX_E
,      CTX_EG
,      CTX_EL
,      CTX_ESA
,      CTX_F
,      CTX_FRC
,      CTX_GB
,      CTX_HR
,      CTX_HU
,      CTX_I
,      CTX_IS
,      CTX_IW
,      CTX_JA
,      CTX_KO
,      CTX_LT
,      CTX_N
,      CTX_NL
,      CTX_PL
,      CTX_PT
,      CTX_PTB
,      CTX_RO
,      CTX_RU
,      CTX_S
,      CTX_SF
,      CTX_SK
,      CTX_SL
,      CTX_TH
,      CTX_TR
,      CTX_ZHT
,      CTX_ZHS
,      RT_ITEM_ID
,      LANGUAGE
,      CTX_US
,      SEQUENCE
FROM ICX.ICX_POR_CTX_TL;

Dependencies

[top of page]

ICX.ICX_POR_CTX_TL does not reference any database object

ICX.ICX_POR_CTX_TL is referenced by following:

SchemaAPPS
SynonymICX_POR_CTX_TL