I am trying to create a SQL query that will give me work orders created for each of the PM activities of an asset.  Is there such a table that stores combination of workorders and asset activity.  I could not find any. 

Any urgent help is greatly appreciated as I am trying to create a Disco report.

Thanks,

Sunil