SOQL to see picklist

picklist.soql

SELECT EntityParticle.DeveloperName, Label, Value, IsActive 
FROM    PicklistValueInfo 
WHERE   EntityParticle.EntityDefinition.QualifiedApiName = 'Opportunity' 
ORDER BY EntityParticleId, Label

 //If you need to see all picklist controlling fields ( dependencies ), check this SOQL out:

SELECT   EntityParticle.DeveloperName, Label, Value, IsActive, EntityParticle.IsDependentPicklist, EntityParticle.FieldDefinition.ControllingFieldDefinition.DeveloperName
FROM    PicklistValueInfo
WHERE   EntityParticle.EntityDefinition.QualifiedApiName = 'Account'
AND    EntityParticle.IsDependentPicklist = TRUE
ORDER BY EntityParticleId, Label