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

TABLE: ICX.ICX_POR_TITLE_ADMIN

Object Details
Object Name: ICX_POR_TITLE_ADMIN
Object Type: TABLE
Owner: ICX
FND Design Data: TableICX.ICX_POR_TITLE_ADMIN
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 Populate from sequence
TITLE VARCHAR2 (2000)
Title name
SOURCE VARCHAR2 (2000)
Document author (it could be a tool or a user, for example)
CREATIONDATE DATE

Creation date
UPDATEDATE DATE

Update date
CONNECTSTRING VARCHAR2 (2000)
Connect string
DOMAIN VARCHAR2 (2000)
Represents the type of content in the catalog
DESCRIPTION VARCHAR2 (2000)
Title description
TYPE VARCHAR2 (2000)
Type
PICTURE VARCHAR2 (2000)
Logo associated with the title
PRELOAD NUMBER

Preload
Query Text

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


SELECT TITLE_ID
,      TITLE
,      SOURCE
,      CREATIONDATE
,      UPDATEDATE
,      CONNECTSTRING
,      DOMAIN
,      DESCRIPTION
,      TYPE
,      PICTURE
,      PRELOAD
FROM ICX.ICX_POR_TITLE_ADMIN;

Dependencies

[top of page]

ICX.ICX_POR_TITLE_ADMIN does not reference any database object

ICX.ICX_POR_TITLE_ADMIN is referenced by following:

SchemaAPPS
SynonymICX_POR_TITLE_ADMIN