[Home] [Help] [Dependency Information]
Object Name: | AMV_U_MY_CHANNELS |
---|---|
Object Type: | TABLE |
Owner: | AMV |
FND Design Data: | AMV.AMV_U_MY_CHANNELS |
Subobject Name: | |
Status: | VALID |
AMV_U_MY_CHANNELS stores all channels a user is subscribing to. My channel consist of:
- Subscribed Channels (can be a group or content channel or a channel category)
- Private Channels (created by the user)
- Group Channels (if it has been set as required)
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMV_U_MY_CHANNELS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | MY_CHANNEL_ID |
AMV_U_MY_CHANNELS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
USER_OR_GROUP_ID
USER_OR_GROUP_TYPE SUBSCRIBING_TO_ID SUBSCRIBING_TO_TYPE |
AMV_U_MY_CHANNELS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SUBSCRIBING_TO_ID
SUBSCRIBING_TO_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MY_CHANNEL_ID | NUMBER | Yes | My 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 | |
USER_OR_GROUP_ID | NUMBER | Yes | User or Group Identifier to which this channel/category is associated | |
USER_OR_GROUP_TYPE | VARCHAR2 | (30) | Yes | Indicates whether its a User or Group |
SUBSCRIBING_TO_ID | NUMBER | Yes | Channel or Category Identifier to which subscription is made | |
SUBSCRIBING_TO_TYPE | VARCHAR2 | (30) | Yes | Indicates whether subscription is made to channel/category |
SUBSCRIPTION_REASON_TYPE | VARCHAR2 | (30) | Yes | Reason for subscription |
ORDER_NUMBER | NUMBER | Yes | Order in which subscriptions are stored | |
STATUS | VARCHAR2 | (30) | Yes | Status of the subscription |
NOTIFY_FLAG | VARCHAR2 | (1) | Yes | Indicates whether notifications are to be received or not |
NOTIFICATION_INTERVAL_TYPE | VARCHAR2 | (30) | Interval for getting notifications | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT MY_CHANNEL_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, USER_OR_GROUP_ID
, USER_OR_GROUP_TYPE
, SUBSCRIBING_TO_ID
, SUBSCRIBING_TO_TYPE
, SUBSCRIPTION_REASON_TYPE
, ORDER_NUMBER
, STATUS
, NOTIFY_FLAG
, NOTIFICATION_INTERVAL_TYPE
, SECURITY_GROUP_ID
FROM AMV.AMV_U_MY_CHANNELS;
AMV.AMV_U_MY_CHANNELS does not reference any database object
AMV.AMV_U_MY_CHANNELS is referenced by following:
|
|
|