[Home] [Help]
View: 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
Name |
ACTIVITY_DELIVERY_METHOD_ID |
ACT_DELIVERY_USED_BY |
DELIVERY_METHOD_USED_BY_ID |
DELIVERY_MEDIA_TYPE_CODE |
DELIVERY_MEDIA_NAME |