[Home] [Help] [Dependency Information]
Object Name: | AMS_MEDIA_CHANNELS |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_MEDIA_CHANNELS |
Subobject Name: | |
Status: | VALID |
AMS_MEDIA_CHANNELS stores what channel can handle what kind of media.
A specific vendor that will execute on part of a media. For example, for a media 'Business Magazine', possible channels could be Business Week, Forbes and Fortune.
In the case of response media, the channels are to be used by field customer responses. This is reference data used to control list of response venues which can be used in activities lika a Promotion.
Examples could be: Tele Center X can handle outbound 'Call Center' Media as well as inbound.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_MEDIA_CHANNELS_U1 | NORMAL | UNIQUE | APPS_TS_SEED | MEDIA_CHANNEL_ID |
AMS_MEDIA_CHANNELS_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
MEDIA_ID
CHANNEL_ID |
AMS_MEDIA_CHANNELS_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | CHANNEL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MEDIA_CHANNEL_ID | NUMBER | Yes | Unique Identifier. | |
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 | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | This column is used for locking purposes. | |
MEDIA_ID | NUMBER | Yes | Indicates the Media. | |
CHANNEL_ID | NUMBER | Yes | Indicates the channels used by media. | |
ACTIVE_FROM_DATE | DATE | Yes | Active from date for the Media. | |
ACTIVE_TO_DATE | DATE | Active to date for the Media. | ||
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT MEDIA_CHANNEL_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, MEDIA_ID
, CHANNEL_ID
, ACTIVE_FROM_DATE
, ACTIVE_TO_DATE
, SECURITY_GROUP_ID
FROM AMS.AMS_MEDIA_CHANNELS;
AMS.AMS_MEDIA_CHANNELS does not reference any database object
AMS.AMS_MEDIA_CHANNELS is referenced by following:
|
|
|