[Home] [Help] [Dependency Information]
Object Name: | AMS_CHANNELS_B |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_CHANNELS_B |
Subobject Name: | |
Status: | VALID |
AMS_CHANNELS_B stores information about what Media Channels are available to be used in Oracle Marketing. Some examples: 'Newspaper X', 'TV Channel Y', 'Radio Station Z', 'Call Center W'. For every Channels set up there will be flags to specify if the Channel can be used for inbound and/or outbound communication with the Customer.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_CHANNELS_B_U1 | NORMAL | UNIQUE | APPS_TS_SEED | CHANNEL_ID |
AMS_CHANNELS_B_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | PREFERRED_VENDOR_ID |
AMS_CHANNELS_B_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED | PARTY_ID |
AMS_CHANNELS_B_N3 | NORMAL | NONUNIQUE | APPS_TS_SEED | LAST_UPDATE_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 . | |
CHANNEL_TYPE_CODE | VARCHAR2 | (30) | Yes | Channel type like internal or external. |
ORDER_SEQUENCE | NUMBER | (15) | This column is used for upgrade purposes only. | |
MANAGED_BY_PERSON_ID | NUMBER | (15) | Reference to the person who manages the channel. | |
OUTBOUND_FLAG | VARCHAR2 | (1) | Yes | Flag indicates whether the channel is an outbound channel. |
INBOUND_FLAG | VARCHAR2 | (1) | Yes | Flag indicates whether the channel is an inbound channel. |
ACTIVE_FROM_DATE | DATE | OM Upgrade purposes only. | ||
ACTIVE_TO_DATE | DATE | OM Upgrade purposes only. | ||
RATING | VARCHAR2 | (30) | Rating of the channel. | |
PREFERRED_VENDOR_ID | NUMBER | Reference to the preferred vendor. | ||
PARTY_ID | NUMBER | (15) | Identifier of the Party associated with the channel ,coming from hz_parties. | |
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 | ||
COUNTRY_ID | NUMBER | Denotes the country in which the channel is created | ||
INTERNAL_RESOURCE | VARCHAR2 | (30) | Internal resource used. eg. mail server 01 | |
PROGRAM_APPLICATION_ID | NUMBER | Identifier for the application of the concurrent Program. | ||
PROGRAM_ID | NUMBER | Concurrent Proram Identifier | ||
PROGRAM_UPDATE_DATE | DATE | Date the program last updated. |
Cut, paste (and edit) the following text to query this object:
SELECT CHANNEL_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, CHANNEL_TYPE_CODE
, ORDER_SEQUENCE
, MANAGED_BY_PERSON_ID
, OUTBOUND_FLAG
, INBOUND_FLAG
, ACTIVE_FROM_DATE
, ACTIVE_TO_DATE
, RATING
, PREFERRED_VENDOR_ID
, PARTY_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, COUNTRY_ID
, INTERNAL_RESOURCE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM AMS.AMS_CHANNELS_B;
AMS.AMS_CHANNELS_B does not reference any database object
AMS.AMS_CHANNELS_B is referenced by following:
|
|
|