The following SQL will allow you to find the package or deployment name based on the Deployment ID/Offer ID.
SELECT CollectionID ,OfferID ,Description FROM DeploymentSummary WHERE OfferID = 'PKG00000'
Where PKG00000
is the ID of the deployment you’re trying to find.