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

TABLE: ICX.POR_NONCAT_TEMPLATES_ALL_TL

Object Details
Object Name: POR_NONCAT_TEMPLATES_ALL_TL
Object Type: TABLE
Owner: ICX
Subobject Name:
Status: VALID


This table stores all the translatable attribute values for a non-catalog request template.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
POR_NONCAT_TEMPLATES_ALL_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTEMPLATE_ID
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
TEMPLATE_ID NUMBER
Yes Internally generated identifier for non-catalog request template
SOURCE_LANG VARCHAR2 (4) Yes Source language in which template was created
LANGUAGE VARCHAR2 (4) Yes Language
TEMPLATE_NAME VARCHAR2 (240)
Non-Catalog Request Template Name
ITEM_DESCRIPTION VARCHAR2 (240)
Description for non-catalog request
CREATED_BY NUMBER
Yes Internal identifier of user who created the row
CREATION_DATE DATE
Yes Date on which row was created
LAST_UPDATED_BY NUMBER
Yes Internal identifier of user who last updated the row
LAST_UPDATE_DATE DATE
Yes Date on which row was last updated
LAST_UPDATE_LOGIN NUMBER

Operating system login of user who last updated the row
IMAGE VARCHAR2 (2000)
Image of the non-catalog template
KEYWORDS VARCHAR2 (4000)
Used in search results to display the smart form if there is a keyword match
Query Text

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


SELECT TEMPLATE_ID
,      SOURCE_LANG
,      LANGUAGE
,      TEMPLATE_NAME
,      ITEM_DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      IMAGE
,      KEYWORDS
FROM ICX.POR_NONCAT_TEMPLATES_ALL_TL;

Dependencies

[top of page]

ICX.POR_NONCAT_TEMPLATES_ALL_TL does not reference any database object

ICX.POR_NONCAT_TEMPLATES_ALL_TL is referenced by following:

SchemaAPPS
SynonymPOR_NONCAT_TEMPLATES_ALL_TL