View: AMS_ACT_DELIVERY_METHODS_V

Product:	AMS - Marketing
Description:	This view returns marketing activity delivery methods.
Implementation/DBA Data:	APPS.AMS_ACT_DELIVERY_METHODS_V

View Text

SELECT ADM.ACTIVITY_DELIVERY_METHOD_ID
, ADM.ARC_ACT_DELIVERY_USED_BY
, ADM.ACT_DELIVERY_METHOD_USED_BY_ID
, ADM.DELIVERY_MEDIA_TYPE_CODE
, LKUP1.MEANING
FROM AMS_ACT_DELIVERY_METHODS ADM
, AMS_LOOKUPS LKUP1
WHERE LKUP1.LOOKUP_TYPE(+)='AMS_DELIVERY_MEDIA_TYPE'
AND LKUP1.LOOKUP_CODE(+)= ADM.DELIVERY_MEDIA_TYPE_CODE

Columns