Price list

select id, vlocity_cmt__PricingElementId__r.vlocity_cmt__PricingVariableId__r.vlocity_cmt__ChargeType__c, vlocity_cmt__PriceListId__r.NAME, MC_TF_PriceAmount__c, vlocity_cmt__ProductId__r.name, vlocity_cmt__OfferId__r.name, vlocity_cmt__IsBasePrice__c, vlocity_cmt__IsOverride__c, vlocity_cmt__IsActive__c from vlocity_cmt__PriceListEntry__c order by vlocity_cmt__ProductId__r.name