View: AMS_CHANNELS_V

Product:	AMS - Marketing
Description:	This view returns the channel details.
Implementation/DBA Data:	APPS.AMS_CHANNELS_V

View Text

SELECT A.CHANNEL_NAME
, A.CHANNEL_ID
, A.MANAGED_BY_PERSON_ID
, A.CHANNEL_TYPE_CODE
, A.OBJECT_VERSION_NUMBER
, A.OUTBOUND_FLAG
, A.INBOUND_FLAG
, A.ACTIVE_FROM_DATE
, A.ACTIVE_TO_DATE
, A.DESCRIPTION
, A.PREFERRED_VENDOR_ID
, A.RATING
, A.PARTY_ID
, B.VENDOR_NAME
, A.CREATION_DATE
, A.COUNTRY_ID
, A.INTERNAL_RESOURCE
FROM AMS_CHANNELS_VL A
, PO_VENDORS B
WHERE A.PREFERRED_VENDOR_ID = B.VENDOR_ID(+)

Columns