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
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
|
|
|