SELECT B.ROWID ROW_ID , B.CAMPAIGN_ID , T.CAMPAIGN_NAME , B.SOURCE_CODE , B.INBOUND_EMAIL_ID , DLA.USING_OBJECT_ID CMP_DELIVERABLE_ID FROM AMS_CAMPAIGNS_ALL_TL T , AMS_CAMPAIGNS_ALL_B B , AMS_OBJECT_ASSOCIATIONS DLA WHERE B.CAMPAIGN_ID = T.CAMPAIGN_ID AND DLA.MASTER_OBJECT_TYPE = 'CAMP' AND DLA.USING_OBJECT_TYPE = 'DELV' AND DLA.MASTER_OBJECT_ID = B.CAMPAIGN_ID AND T.LANGUAGE = USERENV('LANG')