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_CHANNELS_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CHANNEL_NAME	VARCHAR2	(120)	Yes	Name of the channel.
CHANNEL_ID	NUMBER		Yes	Unique identifier of channel.
MANAGED_BY_PERSON_ID	NUMBER	(15)		Channel manager identifier.
CHANNEL_TYPE_CODE	VARCHAR2	(30)	Yes	Channel type code.
OBJECT_VERSION_NUMBER	NUMBER	(9)		This column is used for locking purpose.
OUTBOUND_FLAG	VARCHAR2	(1)	Yes	Outbound flag.
INBOUND_FLAG	VARCHAR2	(1)	Yes	Inbound flag.
ACTIVE_FROM_DATE	DATE			Date from which channel is active.
ACTIVE_TO_DATE	DATE			Date to which channel is active.
DESCRIPTION	VARCHAR2	(4000)		Description of the channel.
PREFERRED_VENDOR_ID	NUMBER			Unique identifier of vendor.
RATING	VARCHAR2	(30)		Rating of channel.
PARTY_ID	NUMBER	(15)		Unique Identifier of party.
VENDOR_NAME	VARCHAR2	(240)		Name of the vendor.
CREATION_DATE	DATE		Yes	Channel created on date.
COUNTRY_ID	NUMBER			Denotes the country in which the channel is created
INTERNAL_RESOURCE	VARCHAR2	(30)		Internal resource used. eg. mail server 01

Query Text

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


SELECT CHANNEL_NAME
,      CHANNEL_ID
,      MANAGED_BY_PERSON_ID
,      CHANNEL_TYPE_CODE
,      OBJECT_VERSION_NUMBER
,      OUTBOUND_FLAG
,      INBOUND_FLAG
,      ACTIVE_FROM_DATE
,      ACTIVE_TO_DATE
,      DESCRIPTION
,      PREFERRED_VENDOR_ID
,      RATING
,      PARTY_ID
,      VENDOR_NAME
,      CREATION_DATE
,      COUNTRY_ID
,      INTERNAL_RESOURCE
FROM APPS.AMS_CHANNELS_V;

Dependencies

[top of page]

APPS.AMS_CHANNELS_V references the following:

APPS: AMS_CHANNELS_VL; PO_VENDORS

APPS.AMS_CHANNELS_V is not referenced by any database object