eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.AMS_MEDIA_CHANNELS_VL

Object Details

Object Name:	AMS_MEDIA_CHANNELS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_MEDIA_CHANNELS_VL
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

AMS_MEDIA_CHANNELS specifies all different media that can be used by an activity and the channels attached to them.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row id.
MEDIA_CHANNEL_ID	NUMBER		Yes	Unique Identifier.
LAST_UPDATE_DATE	DATE		Yes	Standard Who Columns.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Columns.
CREATION_DATE	DATE		Yes	Standard Who Columns.
CREATED_BY	NUMBER	(15)	Yes	Standard Who Columns.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Columns.
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 attached to the Media.
MEDIA_ACTIVE_FROM_DATE	DATE		Yes	Active from date for the Media.
MEDIA_ACTIVE_TO_DATE	DATE			Active to date for the Media.
CHANNEL_TYPE_CODE	VARCHAR2	(30)	Yes	Type of the Channel. Internal or External.
CHANNEL_TYPE	VARCHAR2	(80)	Yes	Indicates the meaning of the Channel type code.
ORDER_SEQUENCE	NUMBER	(15)		Order number of the Channels attached to the media.
MANAGED_BY_PERSON_ID	NUMBER	(15)		Indicates the person managing the Channel.
OUTBOUND_FLAG	VARCHAR2	(1)	Yes	Indicates whether the channel is inbound or outbound.
INBOUND_FLAG	VARCHAR2	(1)	Yes	Indicates whether the channel is inbound or outbound.
CHANNEL_ACTIVE_FROM_DATE	DATE			Active from date for the Channel.
CHANNEL_ACTIVE_TO_DATE	DATE			Active to date for the Channel.
RATING	VARCHAR2	(30)		Rating of the Channel. for Example Good,Bad.
PREFERRED_VENDOR_ID	NUMBER			Indicates the preffered vendor for the Channel.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Desciptive Flexfield structure defining column.
ATTRIBUTE1	VARCHAR2	(150)		Desciptive Flexfield structure.
ATTRIBUTE2	VARCHAR2	(150)		Desciptive Flexfield structure.
ATTRIBUTE3	VARCHAR2	(150)		Desciptive Flexfield structure.
ATTRIBUTE4	VARCHAR2	(150)		Desciptive Flexfield structure.
ATTRIBUTE5	VARCHAR2	(150)		Desciptive Flexfield structure.
ATTRIBUTE6	VARCHAR2	(150)		Desciptive Flexfield structure.
ATTRIBUTE7	VARCHAR2	(150)		Desciptive Flexfield structure.
ATTRIBUTE8	VARCHAR2	(150)		Desciptive Flexfield structure.
ATTRIBUTE9	VARCHAR2	(150)		Desciptive Flexfield structure.
ATTRIBUTE10	VARCHAR2	(150)		Desciptive Flexfield structure.
ATTRIBUTE11	VARCHAR2	(150)		Desciptive Flexfield structure.
ATTRIBUTE12	VARCHAR2	(150)		Desciptive Flexfield structure.
ATTRIBUTE13	VARCHAR2	(150)		Desciptive Flexfield structure.
ATTRIBUTE14	VARCHAR2	(150)		Desciptive Flexfield structure.
ATTRIBUTE15	VARCHAR2	(150)		Desciptive Flexfield structure.
CHANNEL_NAME	VARCHAR2	(120)	Yes	Name of the Channel.
DESCRIPTION	VARCHAR2	(4000)		Description.
COUNTRY_ID	NUMBER			Identifier for country of the Marketing Medium

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      MEDIA_CHANNEL_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      MEDIA_ID
,      CHANNEL_ID
,      MEDIA_ACTIVE_FROM_DATE
,      MEDIA_ACTIVE_TO_DATE
,      CHANNEL_TYPE_CODE
,      CHANNEL_TYPE
,      ORDER_SEQUENCE
,      MANAGED_BY_PERSON_ID
,      OUTBOUND_FLAG
,      INBOUND_FLAG
,      CHANNEL_ACTIVE_FROM_DATE
,      CHANNEL_ACTIVE_TO_DATE
,      RATING
,      PREFERRED_VENDOR_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CHANNEL_NAME
,      DESCRIPTION
,      COUNTRY_ID
FROM APPS.AMS_MEDIA_CHANNELS_VL;

Dependencies

[top of page]

APPS.AMS_MEDIA_CHANNELS_VL references the following:

APPS: AMS_CHANNELS_VL; AMS_MEDIA_CHANNELS

APPS.AMS_MEDIA_CHANNELS_VL is referenced by following:

APPS: OZF_AP_INTERFACE_PVT - show dependent code; OZF_AR_INTERFACE_PVT - show dependent code; OZF_CLAIM_PUB - show dependent code; OZF_FUND_UTILIZED_PUB - show dependent code