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.AMV_C_CHANNELS_VL

Object Details

Object Name:	AMV_C_CHANNELS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMV.AMV_C_CHANNELS_VL
Subobject Name:
Status:	VALID

View Type

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

AMV_C_CHANNELS_VL is a view on the base and translation tables that contains the translated label based on the current language.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Unique identifier generated by the database
CHANNEL_CATEGORY_ID	NUMBER		Yes	Unique Identifier.
CHANNEL_TYPE	VARCHAR2	(30)	Yes	Channel Type
STATUS	VARCHAR2	(30)	Yes	Channel Status
OWNER_USER_ID	NUMBER		Yes	Channel Owner Resource Identifier
DEFAULT_APPROVER_USER_ID	NUMBER		Yes	Default Approver Resource Identifier
EFFECTIVE_START_DATE	DATE		Yes	Effective start date for channel
EXPIRATION_DATE	DATE			Expiration date for channel
ACCESS_LEVEL_TYPE	VARCHAR2	(30)	Yes	Channel Access Level
PUB_NEED_APPROVAL_FLAG	VARCHAR2	(1)	Yes	Indicates whether publishing needs approval
SUB_NEED_APPROVAL_FLAG	VARCHAR2	(1)	Yes	Need Approval Flag
MATCH_ON_ALL_CRITERIA_FLAG	VARCHAR2	(1)	Yes	Indicated whether all the the channel criterias are entered
MATCH_ON_KEYWORD_FLAG	VARCHAR2	(1)	Yes	Indicates whether channel keywords are entered
MATCH_ON_AUTHOR_FLAG	VARCHAR2	(1)	Yes	Indicates whether chanel authors are entered
MATCH_ON_PERSPECTIVE_FLAG	VARCHAR2	(1)	Yes	Indicates whether channel perspectives are entered
MATCH_ON_ITEM_TYPE_FLAG	VARCHAR2	(1)	Yes	Indicates whether channel item types are entered
MATCH_ON_CONTENT_TYPE_FLAG	VARCHAR2	(1)	Yes	Indicates whether channel content types are entered
MATCH_ON_TIME_FLAG	VARCHAR2	(1)	Yes	no longer used
APPLICATION_ID	NUMBER			Application Identifier
EXTERNAL_ACCESS_FLAG	VARCHAR2	(1)		Indicates whether channel can be accessed external to the application owning the channel
ITEM_MATCH_COUNT	NUMBER			Number of items matched with the channel
LAST_MATCH_TIME	DATE			Date item was last matched with the channel
NOTIFICATION_INTERVAL_TYPE	VARCHAR2	(30)		Interval for sending out notifications
LAST_NOTIFICATION_TIME	DATE			Date notification was last sent
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfiled structure defining column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment.
CHANNEL_ID	NUMBER		Yes	Channel Identifier
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	This column is used for locking purposes.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column.
CREATION_DATE	DATE		Yes	Standard WHO column.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column.
CHANNEL_NAME	VARCHAR2	(80)	Yes	Channel Name
DESCRIPTION	VARCHAR2	(2000)		Description

Query Text

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


SELECT ROW_ID
,      CHANNEL_CATEGORY_ID
,      CHANNEL_TYPE
,      STATUS
,      OWNER_USER_ID
,      DEFAULT_APPROVER_USER_ID
,      EFFECTIVE_START_DATE
,      EXPIRATION_DATE
,      ACCESS_LEVEL_TYPE
,      PUB_NEED_APPROVAL_FLAG
,      SUB_NEED_APPROVAL_FLAG
,      MATCH_ON_ALL_CRITERIA_FLAG
,      MATCH_ON_KEYWORD_FLAG
,      MATCH_ON_AUTHOR_FLAG
,      MATCH_ON_PERSPECTIVE_FLAG
,      MATCH_ON_ITEM_TYPE_FLAG
,      MATCH_ON_CONTENT_TYPE_FLAG
,      MATCH_ON_TIME_FLAG
,      APPLICATION_ID
,      EXTERNAL_ACCESS_FLAG
,      ITEM_MATCH_COUNT
,      LAST_MATCH_TIME
,      NOTIFICATION_INTERVAL_TYPE
,      LAST_NOTIFICATION_TIME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CHANNEL_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CHANNEL_NAME
,      DESCRIPTION
FROM APPS.AMV_C_CHANNELS_VL;

Dependencies

[top of page]

APPS.AMV_C_CHANNELS_VL references the following:

APPS: AMV_C_CHANNELS_B; AMV_C_CHANNELS_TL

APPS.AMV_C_CHANNELS_VL is referenced by following:

APPS: AMV_CATEGORY_PVT - show dependent code; AMV_ITEM_PUB - show dependent code; AMV_MYCHANNEL_PVT - show dependent code; AMV_SEARCH_PVT - show dependent code; AMV_USER_PVT - show dependent code; AMV_WFAPPROVAL_PVT - show dependent code; IBU_DYN_USER_GROUPS_PKG - show dependent code