[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ICX_POR_ITEMS_TL |
|---|---|
| Object Type: | TABLE |
| Owner: | ICX |
| FND Design Data: |  ICX.ICX_POR_ITEMS_TL
|
| Subobject Name: | |
| Status: | VALID |
Stores information and root descriptors for translatable data for each item in the catalog. Root descriptor columns are in the format Axxxx where xxxx is an integer. Some of the root descriptors are seeded by Oracle while others may be generated through the use of the application.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
RT_ITEM_IDLANGUAGE| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| ICX_POR_ITEMS_TL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
RT_ITEM_ID
LANGUAGE
|
| ICX_POR_ITEMS_TL_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REBUILD_CTX_JOBNO
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RT_ITEM_ID | NUMBER | Yes | Internally generated Item identifier | |
| LANGUAGE | VARCHAR2 | (4) | Yes | Defined language for the row |
| SOURCE_LANG | VARCHAR2 | (4) | Yes | Actual language for the row |
| CTX_DESC | VARCHAR2 | (4000) | Text column used as the basis for the ConText query (IP Only) | |
| A6 | VARCHAR2 | (700) | Reserved for pricing attributes. | |
| A7 | VARCHAR2 | (2000) | Reserved for short Item Description (DESCRIPTION) | |
| A8 | VARCHAR2 | (700) | Reserved for comments (COMMENTS) (IP Only) | |
| A9 | VARCHAR2 | (700) | Reserved for alias (ALIAS) | |
| CTX_AR | VARCHAR2 | (4000) | Context related column for Arabic | |
| CTX_CS | VARCHAR2 | (4000) | Context related column for Czech | |
| CTX_D | VARCHAR2 | (4000) | Context related column for German | |
| CTX_DK | VARCHAR2 | (4000) | Context related column for Danish | |
| CTX_E | VARCHAR2 | (4000) | Context related column for Spanish | |
| CTX_EL | VARCHAR2 | (4000) | Context related column for Greek | |
| CTX_ESA | VARCHAR2 | (4000) | Context related column for Latin American Spanish | |
| CTX_F | VARCHAR2 | (4000) | Context related column for French | |
| CTX_FRC | VARCHAR2 | (4000) | Context related column for Canadian French | |
| CTX_GB | VARCHAR2 | (4000) | Context related column for English | |
| CTX_HU | VARCHAR2 | (4000) | Context related column for Hungarian | |
| CTX_IW | VARCHAR2 | (4000) | Context related column for Hebrew | |
| CTX_JA | VARCHAR2 | (4000) | Context related column for Japanese | |
| CTX_KO | VARCHAR2 | (4000) | Context related column for Korean | |
| CTX_N | VARCHAR2 | (4000) | Context related column for Norwegian | |
| CTX_NL | VARCHAR2 | (4000) | Context related column for Dutch | |
| CTX_PL | VARCHAR2 | (4000) | Context related column for Polish | |
| CTX_PT | VARCHAR2 | (4000) | Context related column for Portuguese | |
| CTX_PTB | VARCHAR2 | (4000) | Context related column for Brazilian Portuguese | |
| CTX_RO | VARCHAR2 | (4000) | Context related column for Romamian | |
| CTX_RU | VARCHAR2 | (4000) | Context related column for Russian | |
| CTX_S | VARCHAR2 | (4000) | Context related column for Swedish | |
| CTX_SF | VARCHAR2 | (4000) | Context related column for Finnish | |
| CTX_SK | VARCHAR2 | (4000) | Context related column for Slovak | |
| CTX_TH | VARCHAR2 | (4000) | Context related column for Thai | |
| CTX_TR | VARCHAR2 | (4000) | Context related column for Turkish | |
| CTX_US | VARCHAR2 | (4000) | Context related column for American English | |
| CTX_ZHT | VARCHAR2 | (4000) | Context related column for Traditional Chinese | |
| CTX_ZHS | VARCHAR2 | (4000) | Context related column for Simplified Chinese | |
| 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 | ||
| REQUEST_ID | NUMBER | Extended Who Column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Extended Who Column | ||
| PROGRAM_ID | NUMBER | Extended Who Column | ||
| PROGRAM_UPDATE_DATE | DATE | Extended Who Column | ||
| A23 | VARCHAR2 | (2000) | Reserved for extended item description (LONG_DESCRIPTION) | |
| A30 | VARCHAR2 | (240) | ||
| CTX_BG | VARCHAR2 | (4000) | Context related column for Bulgarian | |
| CTX_CA | VARCHAR2 | (4000) | Context related column for Catalan | |
| CTX_EG | VARCHAR2 | (4000) | Context related column for Egyptian | |
| CTX_HR | VARCHAR2 | (4000) | Context related column for Croatian | |
| CTX_I | VARCHAR2 | (4000) | Context related column for Italian | |
| CTX_IS | VARCHAR2 | (4000) | Context related column for Icelandic | |
| CTX_LT | VARCHAR2 | (4000) | Context related column for Lithuanian | |
| CTX_SL | VARCHAR2 | (4000) | Context related column for Slovenian | |
| REBUILD_CTX_JOBNO | NUMBER | Rebuild Context Job Number |
Cut, paste (and edit) the following text to query this object:
SELECT RT_ITEM_ID
, LANGUAGE
, SOURCE_LANG
, CTX_DESC
, A6
, A7
, A8
, A9
, CTX_AR
, CTX_CS
, CTX_D
, CTX_DK
, CTX_E
, CTX_EL
, CTX_ESA
, CTX_F
, CTX_FRC
, CTX_GB
, CTX_HU
, CTX_IW
, CTX_JA
, CTX_KO
, CTX_N
, CTX_NL
, CTX_PL
, CTX_PT
, CTX_PTB
, CTX_RO
, CTX_RU
, CTX_S
, CTX_SF
, CTX_SK
, CTX_TH
, CTX_TR
, CTX_US
, CTX_ZHT
, CTX_ZHS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, A23
, A30
, CTX_BG
, CTX_CA
, CTX_EG
, CTX_HR
, CTX_I
, CTX_IS
, CTX_LT
, CTX_SL
, REBUILD_CTX_JOBNO
FROM ICX.ICX_POR_ITEMS_TL;
ICX.ICX_POR_ITEMS_TL does not reference any database object
ICX.ICX_POR_ITEMS_TL is referenced by following:
ICX
ICX_POR_ITEMS_TL#
|
|
|
|