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

TABLE: ICX.ICX_POR_TITLE_ADMIN_TL

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


Stores information about the titles (supplier catalogs) that have been loaded in the internal catalog. This table maps to the ADMIN section of the XML file. This table is used more extensively in v2.5 and beyond.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
TITLE_ID NUMBER
Yes Title identifier
LANGUAGE VARCHAR2 (4) Yes Defined language for the row
SOURCE_LANG VARCHAR2 (4) Yes Actual language for the row
TITLE VARCHAR2 (2000)
Title name
SOURCE VARCHAR2 (2000)
Document author (it could be a tool or a user, for example)
CREATIONDATE DATE

UPDATEDATE DATE

DOMAIN VARCHAR2 (2000)
Represents the type of content in the catalog
DESCRIPTION VARCHAR2 (2000)
Title description
TYPE VARCHAR2 (2000)
Type
PICTURE VARCHAR2 (2000)
IMAGE VARCHAR2 (2000)
Image
CREATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
Query Text

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


SELECT TITLE_ID
,      LANGUAGE
,      SOURCE_LANG
,      TITLE
,      SOURCE
,      CREATIONDATE
,      UPDATEDATE
,      DOMAIN
,      DESCRIPTION
,      TYPE
,      PICTURE
,      IMAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM ICX.ICX_POR_TITLE_ADMIN_TL;

Dependencies

[top of page]

ICX.ICX_POR_TITLE_ADMIN_TL does not reference any database object

ICX.ICX_POR_TITLE_ADMIN_TL is referenced by following:

SchemaAPPS
SynonymICX_POR_TITLE_ADMIN_TL