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]

TABLE: AMV.AMV_C_CHL_ITEM_MATCH

Object Details

Object Name:	AMV_C_CHL_ITEM_MATCH
Object Type:	TABLE
Owner:	AMV
FND Design Data:	AMV.AMV_C_CHL_ITEM_MATCH
Subobject Name:
Status:	VALID

AMV_C_CHL_ITEMS_MATCH stores channels that an item is published to. The column published_due_to_type specifies if the item was pushed or pulled (matched).
Pushed means that the person creating the item really want to make sure the channel (and people subscribing to it) will get the item.
Pulled/Matched mean that the matching engine, using matching criteria, decided that the item should be published to the channel.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMV_C_CHL_ITEM_MATCH_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHANNEL_ITEM_ID
AMV_C_CHL_ITEM_MATCH_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHANNEL_CATEGORY_ID
AMV_C_CHL_ITEM_MATCH_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ITEM_ID
AMV_C_CHL_ITEM_MATCH_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHANNEL_ID ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CHANNEL_ITEM_ID	NUMBER		Yes	Channel Item 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_ID	NUMBER			Channel Identifier
ITEM_ID	NUMBER		Yes	Item Identifier
TABLE_NAME_CODE	VARCHAR2	(30)	Yes	Indicates the table from where item is linked
CHANNEL_CATEGORY_ID	NUMBER			Category Identifier
APPLICATION_ID	NUMBER			Application Identifier
APPROVAL_STATUS_TYPE	VARCHAR2	(30)	Yes	Approval status of item associated to channel/category
APPROVAL_DATE	DATE			Date approval was made
AVAILABLE_DUE_TO_TYPE	VARCHAR2	(30)	Yes	Mechanism used to associate item with channel/category
AVAILABLE_FOR_CHANNEL_DATE	DATE		Yes	Date item will be available for channel/category
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
TERRITORY_ID	NUMBER			Territory to which the Item is published.

Query Text

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


SELECT CHANNEL_ITEM_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CHANNEL_ID
,      ITEM_ID
,      TABLE_NAME_CODE
,      CHANNEL_CATEGORY_ID
,      APPLICATION_ID
,      APPROVAL_STATUS_TYPE
,      APPROVAL_DATE
,      AVAILABLE_DUE_TO_TYPE
,      AVAILABLE_FOR_CHANNEL_DATE
,      SECURITY_GROUP_ID
,      TERRITORY_ID
FROM AMV.AMV_C_CHL_ITEM_MATCH;

Dependencies

[top of page]

AMV.AMV_C_CHL_ITEM_MATCH does not reference any database object

AMV.AMV_C_CHL_ITEM_MATCH is referenced by following:

APPS: AMV_C_CHL_ITEM_MATCH