Purpose of Query
This query helps us to get the names of the modules the object belongs to.
Applicable CAST Version
Release | Yes/No |
---|---|
8.2.x | |
8.1.x | |
8.0.x | |
7.3.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
Query for CSS
SELECT sq.module_name FROM <local_base>.cdt_objects cobj JOIN ( SELECT pso.object_id AS object_id , ps.module_name AS module_name FROM <local_base>.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 <mngt_base>.cms_portf_module pm ) pm JOIN <local_base>.pmc_subsets ps ON ps.subset_name LIKE 'CMS_MOD__' || pm.object_id || '_Preparation2' ) ps ON pso.subset_id = ps.module_id ) sq ON sq.object_id = cobj.object_id WHERE cobj.object_id IN ( -- This is the list of Ghost objects SELECT k.idkey FROM <local_base>.keys k JOIN <local_base>.typ t ON t.idtyp = k.objtyp JOIN <local_base>.typcat tc ON tc.idtyp = t.idtyp AND tc.idcatparent = 2500 WHERE k.objtyp NOT IN (237, 355) AND NOT EXISTS ( SELECT 1 FROM <local_base>.objpro op WHERE op.idobj = k.idkey) ORDER BY k.idkey)
For CAIP versions >= 8.2.3
Notes/comments
Related Pages