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


TABLE: ICX.ICX_CATG_DETLS_INFO_TL

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

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ICX_CATG_DETLS_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCATEGORY_ID
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
CREATED_BY NUMBER
Yes
CREATED_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

CATEGORY_ID NUMBER
Yes
MARKETING_TEXT VARCHAR2 (2000)
SOURCE_LANG VARCHAR2 (4) Yes
LANGUAGE VARCHAR2 (4) Yes
Query Text

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


SELECT CREATED_BY
,      CREATED_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CATEGORY_ID
,      MARKETING_TEXT
,      SOURCE_LANG
,      LANGUAGE
FROM ICX.ICX_CATG_DETLS_INFO_TL;

Dependencies

[top of page]

ICX.ICX_CATG_DETLS_INFO_TL does not reference any database object

ICX.ICX_CATG_DETLS_INFO_TL is referenced by following:

SchemaAPPS
SynonymICX_CATG_DETLS_INFO_TL