[Home] [Help] [Dependency Information]
Object Name: | BIM_DIMV_CHANNELS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BIM.BIM_DIMV_CHANNELS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
BIM_DIMV_CHANNELS is a view showing all marketing channels which includes media channels, events and event offerings.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | VARCHAR2 | (44) | id | |
VALUE | VARCHAR2 | (80) | value | |
CHANNEL_ID | VARCHAR2 | (44) | For media channels, value is ' CHLS' || AMS_CHANNELS_VL.CHANNEL_ID. For event headers, value is 'EVEH' || AMS_EVENT_HEADERS_VL.EVENT_HEADER_ID. For event offerings, value is 'EVEO' || AMS_EVENT_OFFERS_VL.EVENT_OFFER_ID. | |
CHANNEL_TYPE_CODE | VARCHAR2 | (30) | For media channels, value is AMS_CHANNELS_VL.CHANNEL_TYPE_CODE. For event headers, value is AMS_EVENT_HEADERS_VL.EVENT_TYPE_CODE. For event offers, value is AMS_EVENT_OFFERS_VL.EVENT_TYPE_CODE. | |
CHANNEL_TYPE | VARCHAR2 | (80) | event channel type | |
INBOUND_FLAG | VARCHAR2 | (1) | NULL for events and event offers. | |
OUTBOUND_FLAG | VARCHAR2 | (1) | NULL for events and event offers. | |
ACTIVE_FROM_DATE | DATE | channel active from date | ||
ACTIVE_TO_DATE | DATE | active to date | ||
CHANNEL_NAME | VARCHAR2 | (240) | For media channels, value is AMS_CHANNELS_VL.CHANNEL_NAME. For events, value is AMS_EVENT_HEADERS_VL.EVENT_HEADER_NAME. For event offers, value is AMS_EVENT_OFFERS_VL.EVENT_OFFER_NAME. | |
DESCRIPTION | VARCHAR2 | (4000) | description |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, VALUE
, CHANNEL_ID
, CHANNEL_TYPE_CODE
, CHANNEL_TYPE
, INBOUND_FLAG
, OUTBOUND_FLAG
, ACTIVE_FROM_DATE
, ACTIVE_TO_DATE
, CHANNEL_NAME
, DESCRIPTION
FROM APPS.BIM_DIMV_CHANNELS;
APPS.BIM_DIMV_CHANNELS is not referenced by any database object
|
|
|