SQL Queries - CAST Knowledge Base - Queries on Module - How to check if ghost objects are part of any module

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(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick) 
Microsoft SQL Server(question)
CSS2(tick)
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