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

VIEW: ICX.ICX_CAT_CATEGORIES_TL#

Object Details
Object Name: ICX_CAT_CATEGORIES_TL#
Object Type: VIEW
Owner: ICX
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
RT_CATEGORY_ID NUMBER
Yes
LANGUAGE VARCHAR2 (4) Yes
SOURCE_LANG VARCHAR2 (4) Yes
CATEGORY_NAME VARCHAR2 (250) Yes
DESCRIPTION VARCHAR2 (2000)
TYPE NUMBER
Yes
KEY VARCHAR2 (250) Yes
TITLE VARCHAR2 (500)
ITEM_COUNT NUMBER

CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

UPPER_CATEGORY_NAME VARCHAR2 (250) Yes
BATCH_JOB_NUM NUMBER

REBUILD_FLAG VARCHAR2 (1)
UPPER_KEY VARCHAR2 (250) Yes
SECTION_MAP VARCHAR2 (300)
PROGRAM_LOGIN_ID NUMBER

ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT RT_CATEGORY_ID
,      LANGUAGE
,      SOURCE_LANG
,      CATEGORY_NAME
,      DESCRIPTION
,      TYPE
,      KEY
,      TITLE
,      ITEM_COUNT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      UPPER_CATEGORY_NAME
,      BATCH_JOB_NUM
,      REBUILD_FLAG
,      UPPER_KEY
,      SECTION_MAP
,      PROGRAM_LOGIN_ID
,      ZD_EDITION_NAME
FROM ICX.ICX_CAT_CATEGORIES_TL#;

Dependencies

[top of page]

ICX.ICX_CAT_CATEGORIES_TL# references the following:

SchemaICX
TableICX_CAT_CATEGORIES_TL
ICX.ICX_CAT_CATEGORIES_TL# is referenced by following:

SchemaAPPS
SynonymICX_CAT_CATEGORIES_TL
TriggerICX_CAT_CATEGORIES_TL+