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

VIEW: APPS.ICX_POR_ITEM_SOURCES_VL

Object Details
Object Name: ICX_POR_ITEM_SOURCES_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.ICX_POR_ITEM_SOURCES_VL
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ITEM_SOURCE_ID NUMBER
Yes
ITEM_SOURCE_NAME VARCHAR2 (2000)
DESCRIPTION VARCHAR2 (2000)
TYPE VARCHAR2 (8)
URL VARCHAR2 (2000)
IMAGE_URL VARCHAR2 (2000)
CTX_KEYWORDS VARCHAR2 (4000)
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

PROTOCOL_SUPPORTED VARCHAR2 (20)
IS_HUB VARCHAR2 (1)
OPERATOR_ID NUMBER

LOCK_ITEM_FLAG VARCHAR2 (1)
USER_DATA_FLAG VARCHAR2 (1)
DISPLAY_ALWAYS VARCHAR2 (1)
USER_NAME VARCHAR2 (100)
PASSWORD VARCHAR2 (100)
SEQUENCE_NUMBER NUMBER

ICX_SESSION_SERVLET_FLAG VARCHAR2 (1)
Query Text

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


SELECT ROW_ID
,      ITEM_SOURCE_ID
,      ITEM_SOURCE_NAME
,      DESCRIPTION
,      TYPE
,      URL
,      IMAGE_URL
,      CTX_KEYWORDS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROTOCOL_SUPPORTED
,      IS_HUB
,      OPERATOR_ID
,      LOCK_ITEM_FLAG
,      USER_DATA_FLAG
,      DISPLAY_ALWAYS
,      USER_NAME
,      PASSWORD
,      SEQUENCE_NUMBER
,      ICX_SESSION_SERVLET_FLAG
FROM APPS.ICX_POR_ITEM_SOURCES_VL;

Dependencies

[top of page]

APPS.ICX_POR_ITEM_SOURCES_VL references the following:

SchemaAPPS
SynonymICX_POR_ITEM_SOURCES
SynonymICX_POR_ITEM_SOURCES_TL

APPS.ICX_POR_ITEM_SOURCES_VL is not referenced by any database object