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

TABLE: AMV.AMV_C_CHANNELS_B

Object Details
Object Name: AMV_C_CHANNELS_B
Object Type: TABLE
Owner: AMV
FND Design Data: TableAMV.AMV_C_CHANNELS_B
Subobject Name:
Status: VALID


AMV_C_CHANNELS_B stores all Channels that exist in the system. A Channel is place to which information (e.g. items/urls/files/messages) can be published. A channel can be of two types, 'content' or 'group'. A content channel is a channel the end user can subscribe to. A group channel is a one-to-one relationship with a user group and is used to push information to a certain user group.
Channels are a means to classify items and ultimately deliver information. Channels are categorized and defined by attributes. The outcome is channel properties, which determine what content items may exist in a given channel.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMV_C_CHANNELS_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHANNEL_ID
ColumnZD_EDITION_NAME
AMV_C_CHANNELS_B_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHANNEL_CATEGORY_ID
AMV_C_CHANNELS_B_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOWNER_USER_ID
AMV_C_CHANNELS_B_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDEFAULT_APPROVER_USER_ID
AMV_C_CHANNELS_B_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHANNEL_TYPE
AMV_C_CHANNELS_B_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACCESS_LEVEL_TYPE
AMV_C_CHANNELS_B_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLICATION_ID
Columns
Name Datatype Length Mandatory Comments
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_TYPE VARCHAR2 (30) Yes Channel Type
CHANNEL_CATEGORY_ID NUMBER
Yes Category Identifier
STATUS VARCHAR2 (30) Yes Channel Status
OWNER_USER_ID NUMBER
Yes Channel Owner Resource Identifier
DEFAULT_APPROVER_USER_ID NUMBER
Yes Channel 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 type
PUB_NEED_APPROVAL_FLAG VARCHAR2 (1) Yes Indicates whether publishing needs approval
SUB_NEED_APPROVAL_FLAG VARCHAR2 (1) Yes Indicates whether subscription needs approval
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.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT CHANNEL_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CHANNEL_TYPE
,      CHANNEL_CATEGORY_ID
,      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
,      SECURITY_GROUP_ID
,      ZD_EDITION_NAME
FROM AMV.AMV_C_CHANNELS_B;

Dependencies

[top of page]

AMV.AMV_C_CHANNELS_B does not reference any database object

AMV.AMV_C_CHANNELS_B is referenced by following:

SchemaAMV
ViewAMV_C_CHANNELS_B#