SQL Queries - CAST Knowledge Base - Queries on artifacts - How to get the list of objects based on module name

SELECT ps.module_name, 
       ps.module_id, 
       pso.object_id 
FROM   <your_local>.pmc_subset_objects pso 
       JOIN (SELECT ps.subset_id   AS MODULE_ID, 
                    pm.object_name AS MODULE_NAME 
             FROM   (SELECT pm.object_id, 
                            pm.object_name 
                     FROM   <your_mngt>cms_portf_module pm 
                     WHERE  1 = 1 
                     and pm.Object_Name in ([list of module names]) -- comment out to scan all defined modules 
                    ) pm 
                    JOIN <your_local>.pmc_subsets ps 
                      ON ps.subset_name LIKE 'CMS_MOD__' 
                                             || pm.object_id 
                                             || '_Preparation2') ps 
         ON pso.subset_id = ps.module_id