DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.BIM_DIMV_CHANNELS

Object Details
Object Name: BIM_DIMV_CHANNELS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBIM.BIM_DIMV_CHANNELS
Subobject Name:
Status: VALID

View Type

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.
.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.BIM_DIMV_CHANNELS references the following:

SchemaAPPS
ViewAMS_CHANNELS_VL
ViewAMS_EVENT_HEADERS_VL
ViewAMS_EVENT_OFFERS_VL
ViewAMS_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS

APPS.BIM_DIMV_CHANNELS is not referenced by any database object