Here the Policy what I mean is: To deploy a software(MS Office, Adobe Acrobat, VLC etc) we will create a Managed Software Delivery Policy with the required settings.
And part the Managed Software Delivery we can add Pre-requisites if needed.
Please find the below screen shot for your reference.
Can we have any SQL query to get a report that What all Policies are using a perticual softwre as Pre-requsits.