eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.ICX_CAT_CONTENT_ZONES_VL

Object Details

Object Name:	ICX_CAT_CONTENT_ZONES_VL
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

View to store translatable information for the content zones.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row ID
ZONE_ID	NUMBER		Yes	Content zone ID
TYPE	VARCHAR2	(20)		Content zone type
URL	VARCHAR2	(2000)		URL of the content zone
IMAGE	VARCHAR2	(2000)		Image of the content zone
SUPPLIER_ATTRIBUTE_ACTION_FLAG	VARCHAR2	(20)		flag to indicate whether to include all, include some, exclude all, or exclude some suppliers
CATEGORY_ATTRIBUTE_ACTION_FLAG	VARCHAR2	(20)		flag to indicate whether to include all, include some, exclude all, or exclude some categories
SQE_SEQUENCE	NUMBER			SQE sequence of the content zone
ITEMS_WITHOUT_SUPPLIER_FLAG	VARCHAR2	(1)		Flag to indicate whether inventory items and internal templates should be included in the content zone.
ITEMS_WITHOUT_SHOP_CATG_FLAG	VARCHAR2	(1)		Flag to indicate whether to include items without shopping categories in the content zone.
SECURITY_ASSIGNMENT_FLAG	VARCHAR2	(20)		indicates whether the content zone is secured by responsibilities, OUs or all users
NAME	VARCHAR2	(2000)		name of the content zone
DESCRIPTION	VARCHAR2	(2000)		description of the content zone
KEYWORDS	VARCHAR2	(4000)		used in search results to display the content zone if there is a keyword match
CREATED_BY	NUMBER		Yes	user created the content zone
CREATION_DATE	DATE		Yes	creation date
LAST_UPDATED_BY	NUMBER		Yes	user who last updated the content zone
LAST_UPDATE_DATE	DATE		Yes	last update date
LAST_UPDATE_LOGIN	NUMBER			last update login

Query Text

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


SELECT ROW_ID
,      ZONE_ID
,      TYPE
,      URL
,      IMAGE
,      SUPPLIER_ATTRIBUTE_ACTION_FLAG
,      CATEGORY_ATTRIBUTE_ACTION_FLAG
,      SQE_SEQUENCE
,      ITEMS_WITHOUT_SUPPLIER_FLAG
,      ITEMS_WITHOUT_SHOP_CATG_FLAG
,      SECURITY_ASSIGNMENT_FLAG
,      NAME
,      DESCRIPTION
,      KEYWORDS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.ICX_CAT_CONTENT_ZONES_VL;

Dependencies

[top of page]

APPS.ICX_CAT_CONTENT_ZONES_VL references the following:

APPS: ICX_CAT_CONTENT_ZONES_B; ICX_CAT_CONTENT_ZONES_TL

APPS.ICX_CAT_CONTENT_ZONES_VL is not referenced by any database object