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

TABLE: ICX.ICX_POR_EXT_QUERY_TL

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


Stores named extended queries or a URL for an item. For example, you can create a query for Related Items. When this feature is enabled, an icon appears in the search results row for the item. Clicking on the icon executes the extended query.
Currently not implemented in Self-Service Purchasing 4.0
When implemented, either a label or a picture or both are required.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
RT_ITEM_ID NUMBER
Yes Item unique identifier
LANGUAGE VARCHAR2 (4)
Language
SOURCE_LANG VARCHAR2 (4)
Source language
QUERY VARCHAR2 (2000)
BugsEye query or URL
TYPE VARCHAR2 (2000)
QUERY or URL
LABEL VARCHAR2 (2000)
Text displayed next to icon in results
PICTURE VARCHAR2 (2000)
Icon to use
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

Request ID
PROGRAM_APPLICATION_ID NUMBER

Program application ID
PROGRAM_ID NUMBER

Program ID
PROGRAM_UPDATE_DATE DATE

Program update date
Query Text

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


SELECT RT_ITEM_ID
,      LANGUAGE
,      SOURCE_LANG
,      QUERY
,      TYPE
,      LABEL
,      PICTURE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM ICX.ICX_POR_EXT_QUERY_TL;

Dependencies

[top of page]

ICX.ICX_POR_EXT_QUERY_TL does not reference any database object

ICX.ICX_POR_EXT_QUERY_TL is referenced by following:

SchemaAPPS
SynonymICX_POR_EXT_QUERY_TL