set termout on
set echo on
-- This Script (richeck.sql) Checks Referential Integrity for the STORET v1.x Database
-- SQL Plus Environment Variables
set echo off
set verify on
set feedback on
set termout on
set time off
set timing off
set heading off
set linesize 300
set pagesize 0

show user

accept schema_user prompt 'Enter database username : '
accept connectstring prompt 'Enter database connect string :'
prompt 'Enter password for &schema_user@&connectstring:'
connect &schema_user@&connectstring

PROMPT Your SQL*Plus Session is currently connected to Database as USER/SCHEMA... 
show user
PROMPT Script Log File: C:\RICHECK.LOG 
PROMPT This Script (row_viol.sql) Checks Referential Integrity for the STORET v1.x Database 
PROMPT Displays Relationship(s) Violated with all rows subject to violation(s).
PROMPT Select rows violating from Primary Table within the relationship check.
PROMPT RICHECK relationship:
PROMPT PRIMARY TABLE              "relationship"             SECONDARY TABLE
ACCEPT CONTINUE CHAR FORMAT A1 PROMPT 'Press <ENTER> To Continue an EXECUTE this script (CTRL-C to abort): '

SPOOL c:\richeck.log  

COLUMN USER FORMAT A50 HEADING "SCHEMA BEING CHECKED FOR REFERENTIAL INTEGRITY"         

show user

COLUMN USER CLEAR     
COLUMN RELATIONSHIP FORMAT A70            
COLUMN "RI PROBLEMS" FORMAT B999,999,999        

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMADDR    SOMETIMES IS_ASSIGNED_TO                  TSMSTATN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMADDR   TSMADDR  
WHERE                 
      TSMADDR.TSMSTATN_IS_NUMBER   IS NOT NULL  
      AND TSMADDR.TSMSTATN_ORG_ID      IS NOT NULL                  
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMSTATN   TSMSTATN          
      WHERE TSMADDR.TSMSTATN_IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER       
      AND TSMADDR.TSMSTATN_ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID            
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMADDR    SOMETIMES IS_ASSIGNED_TO                  TSMCPORG' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMADDR   TSMADDR  
WHERE                 
      TSMADDR.TSMCPORG_IS_NUMBER   IS NOT NULL  
      AND TSMADDR.TSMCPORG_ORG_ID      IS NOT NULL                  
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMCPORG   TSMCPORG          
      WHERE TSMADDR.TSMCPORG_IS_NUMBER              = TSMCPORG.TSMCPORG_IS_NUMBER       
      AND TSMADDR.TSMCPORG_ORG_ID                 = TSMCPORG.TSMCPORG_ORG_ID            
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMADDR    SOMETIMES IS_ASSIGNED_TO                  TSRLAB' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSMADDR   TSMADDR  
WHERE                 
      TSMADDR.TSRLAB_IS_NUMBER     IS NOT NULL  
      AND TSMADDR.TSRLAB_ORG_ID        IS NOT NULL                  
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRLAB   TSRLAB              
      WHERE TSMADDR.TSRLAB_IS_NUMBER                = TSRLAB.TSRLAB_IS_NUMBER           
      AND TSMADDR.TSRLAB_ORG_ID                   = TSRLAB.TSRLAB_ORG_ID                
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMADDR    SOMETIMES IS_ASSIGNED_TO                  TSMORGAN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMADDR   TSMADDR  
WHERE                 
      TSMADDR.TSMORGAN_IS_NUMBER   IS NOT NULL  
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMORGAN   TSMORGAN          
      WHERE TSMADDR.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER       
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMADDR    SOMETIMES IS_FOR      TSMWLE' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSMADDR   TSMADDR  
WHERE                 
      TSMADDR.TSMWELL_ORG_ID       IS NOT NULL  
      AND TSMADDR.TSMWELL_IS_NUMBER    IS NOT NULL                  
      AND TSMADDR.TSMWLE_TYPE_NAME     IS NOT NULL                  
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMWLE   TSMWLE              
      WHERE TSMADDR.TSMWELL_ORG_ID                  = TSMWLE.TSMWELL_ORG_ID             
      AND TSMADDR.TSMWELL_IS_NUMBER               = TSMWLE.TSMWELL_IS_NUMBER            
      AND TSMADDR.TSMWLE_TYPE_NAME                = TSMWLE.TSMWLE_TYPE_NAME             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMALP     SOMETIMES IS_ASSOCIATED_WITH              TSMRRR' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSMALP   TSMALP    
WHERE                 
      TSMALP.TSMRRR_IS_NUMBER     IS NOT NULL   
      AND TSMALP.TSMRRR_ORG_ID        IS NOT NULL                   
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMRRR   TSMRRR              
      WHERE TSMALP.TSMRRR_IS_NUMBER                = TSMRRR.TSMRRR_IS_NUMBER            
      AND TSMALP.TSMRRR_ORG_ID                   = TSMRRR.TSMRRR_ORG_ID                 
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMALP     SOMETIMES IS_ASSOCIATED_WITH              TSMFHU' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSMALP   TSMALP    
WHERE                 
      TSMALP.TSMFHU_IS_NUMBER     IS NOT NULL   
      AND TSMALP.TSMFHU_ORG_ID        IS NOT NULL                   
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMFHU   TSMFHU              
      WHERE TSMALP.TSMFHU_IS_NUMBER                = TSMFHU.TSMFHU_IS_NUMBER            
      AND TSMALP.TSMFHU_ORG_ID                   = TSMFHU.TSMFHU_ORG_ID                 
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMALP     SOMETIMES IS_ASSOCIATED_WITH              TSMNAL' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSMALP   TSMALP    
WHERE                 
      TSMALP.TSMNAL_CD            IS NOT NULL   
      AND TSMALP.TSMNAL_STATE         IS NOT NULL                   
      AND TSMALP.TSMNAL_ORG_ID        IS NOT NULL                   
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMNAL   TSMNAL              
      WHERE TSMALP.TSMNAL_CD   = TSMNAL.TSMNAL_CD                   
      AND TSMALP.TSMNAL_STATE= TSMNAL.TSMNAL_STATE                  
      AND TSMALP.TSMNAL_ORG_ID                   = TSMNAL.TSMNAL_ORG_ID                 
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMALP     SOMETIMES IS_LOCATION_OF                  TSMSTATN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMALP   TSMALP    
WHERE                 
      TSMALP.TSMSTATN0IS_NUMBER   IS NOT NULL   
      AND TSMALP.TSMSTATN0ORG_ID      IS NOT NULL                   
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMSTATN   TSMSTATN             
      WHERE TSMALP.TSMSTATN0IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER        
      AND TSMALP.TSMSTATN0ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID             
      )             
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMALP     SOMETIMES IS_PRIMARILY_LOCATED_BY         TSMGEOPA' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMALP   TSMALP    
WHERE                 
      TSMALP.TSMGEOPA_IS_NUMBER   IS NOT NULL   
      AND TSMALP.TSMGEOPA_ORG_ID      IS NOT NULL                   
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMGEOPA   TSMGEOPA          
      WHERE TSMALP.TSMGEOPA_IS_NUMBER              = TSMGEOPA.TSMGEOPA_IS_NUMBER        
      AND TSMALP.TSMGEOPA_ORG_ID                 = TSMGEOPA.TSMGEOPA_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMALP     SOMETIMES IS_SECONDARILY_LOCATED_BY       TSMGEOPA' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMALP   TSMALP    
WHERE                 
      TSMALP.TSMGEOPA0IS_NUMBER   IS NOT NULL   
      AND TSMALP.TSMGEOPA0ORG_ID      IS NOT NULL                   
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMGEOPA   TSMGEOPA          
      WHERE TSMALP.TSMGEOPA0IS_NUMBER              = TSMGEOPA.TSMGEOPA_IS_NUMBER        
      AND TSMALP.TSMGEOPA0ORG_ID                 = TSMGEOPA.TSMGEOPA_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMALP     SOMETIMES LOCATES     TSMPMGRD' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMALP   TSMALP    
WHERE                 
      TSMALP.TSMSTATN_ORG_ID      IS NOT NULL   
      AND TSMALP.TSMSTATN_IS_NUMBER   IS NOT NULL                   
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMPMGRD   TSMPMGRD          
      WHERE TSMALP.TSMSTATN_ORG_ID                 = TSMPMGRD.TSMSTATN_ORG_ID           
      AND TSMALP.TSMSTATN_IS_NUMBER              = TSMPMGRD.TSMSTATN_IS_NUMBER          
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMALP     SOMETIMES LOCATES     TSMPMTCT' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMALP   TSMALP    
WHERE                 
      TSMALP.TSMSTATN1ORG_ID      IS NOT NULL   
      AND TSMALP.TSMSTATN1IS_NUMBER   IS NOT NULL                   
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMPMTCT   TSMPMTCT          
      WHERE TSMALP.TSMSTATN1ORG_ID                 = TSMPMTCT.TSMSTATN_ORG_ID           
      AND TSMALP.TSMSTATN1IS_NUMBER              = TSMPMTCT.TSMSTATN_IS_NUMBER          
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMALP     SOMETIMES LOCATES     TSMPIPE' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSMALP   TSMALP    
WHERE                 
      TSMALP.TSMPIPE_IS_NUMBER    IS NOT NULL   
      AND TSMALP.TSMPIPE_ORG_ID       IS NOT NULL                   
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMPIPE   TSMPIPE            
      WHERE TSMALP.TSMPIPE_IS_NUMBER               = TSMPIPE.TSMPIPE_IS_NUMBER          
      AND TSMALP.TSMPIPE_ORG_ID                  = TSMPIPE.TSMPIPE_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMALP     SOMETIMES LOCATES     TSMWELL' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSMALP   TSMALP    
WHERE                 
      TSMALP.TSMWELL_IS_NUMBER    IS NOT NULL   
      AND TSMALP.TSMWELL_ORG_ID       IS NOT NULL                   
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMWELL   TSMWELL            
      WHERE TSMALP.TSMWELL_IS_NUMBER               = TSMWELL.TSMWELL_IS_NUMBER          
      AND TSMALP.TSMWELL_ORG_ID                  = TSMWELL.TSMWELL_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMAMDA    ALWAYS    IS_DESCRIBED_BY                 TSMMAD' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSMAMDA   TSMAMDA  
WHERE                 
      TSMAMDA.TSMMAD_IS_NUMBER     IS NULL      
      OR TSMAMDA.TSMMAD_ORG_ID        IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMMAD   TSMMAD              
      WHERE TSMAMDA.TSMMAD_IS_NUMBER                = TSMMAD.TSMMAD_IS_NUMBER           
      AND TSMAMDA.TSMMAD_ORG_ID                   = TSMMAD.TSMMAD_ORG_ID                
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMAMDA    ALWAYS    MEASURES    TSMALP' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSMAMDA   TSMAMDA  
WHERE                 
      TSMAMDA.TSMALP_IS_NUMBER     IS NULL      
      OR TSMAMDA.TSMALP_ORG_ID        IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMALP   TSMALP              
      WHERE TSMAMDA.TSMALP_IS_NUMBER                = TSMALP.TSMALP_IS_NUMBER           
      AND TSMAMDA.TSMALP_ORG_ID                   = TSMALP.TSMALP_ORG_ID                
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMCPORG   ALWAYS    ASSISTS     TSMORGAN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMCPORG   TSMCPORG
WHERE                 
      TSMCPORG.TSMORGAN_IS_NUMBER   IS NULL     
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMORGAN   TSMORGAN          
      WHERE TSMCPORG.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER      
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMCSNG    ALWAYS    IS_USED_IN  TSMINTVL' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMCSNG   TSMCSNG  
WHERE                 
      TSMCSNG.TSMINTVL_IS_NUMBER   IS NULL      
      OR TSMCSNG.TSMINTVL_ORG_ID      IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMINTVL   TSMINTVL          
      WHERE TSMCSNG.TSMINTVL_IS_NUMBER              = TSMINTVL.TSMINTVL_IS_NUMBER       
      AND TSMCSNG.TSMINTVL_ORG_ID                 = TSMINTVL.TSMINTVL_ORG_ID            
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMEADDR   SOMETIMES IS_ASSIGNED_TO                  TSMCPORG' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMEADDR   TSMEADDR
WHERE                 
      TSMEADDR.TSMCPORG_IS_NUMBER   IS NOT NULL 
      AND TSMEADDR.TSMCPORG_ORG_ID      IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMCPORG   TSMCPORG          
      WHERE TSMEADDR.TSMCPORG_IS_NUMBER              = TSMCPORG.TSMCPORG_IS_NUMBER      
      AND TSMEADDR.TSMCPORG_ORG_ID                 = TSMCPORG.TSMCPORG_ORG_ID           
      )    
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMEADDR   SOMETIMES IS_FOR      TSMSTATN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMEADDR   TSMEADDR
WHERE                 
      TSMEADDR.TSMSTATN_IS_NUMBER   IS NOT NULL 
      AND TSMEADDR.TSMSTATN_ORG_ID      IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMSTATN   TSMSTATN          
      WHERE TSMEADDR.TSMSTATN_IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER      
      AND TSMEADDR.TSMSTATN_ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMEADDR   SOMETIMES IS_FOR      TSRLAB' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSMEADDR   TSMEADDR
WHERE                 
      TSMEADDR.TSRLAB_IS_NUMBER     IS NOT NULL 
      AND TSMEADDR.TSRLAB_ORG_ID        IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRLAB   TSRLAB              
      WHERE TSMEADDR.TSRLAB_IS_NUMBER                = TSRLAB.TSRLAB_IS_NUMBER          
      AND TSMEADDR.TSRLAB_ORG_ID                   = TSRLAB.TSRLAB_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMEADDR   SOMETIMES IS_FOR      TSMPERSN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMEADDR   TSMEADDR
WHERE                 
      TSMEADDR.TSMPERSN_IS_NUMBER   IS NOT NULL 
      AND TSMEADDR.TSMPERSN_ORG_ID      IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMPERSN   TSMPERSN          
      WHERE TSMEADDR.TSMPERSN_IS_NUMBER              = TSMPERSN.TSMPERSN_IS_NUMBER      
      AND TSMEADDR.TSMPERSN_ORG_ID                 = TSMPERSN.TSMPERSN_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMEADDR   SOMETIMES IS_FOR      TSMORGAN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMEADDR   TSMEADDR
WHERE                 
      TSMEADDR.TSMORGAN_IS_NUMBER   IS NOT NULL 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMORGAN   TSMORGAN          
      WHERE TSMEADDR.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER      
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMERS     ALWAYS    IS_DEFINED_BY                   TSMORGAN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMERS   TSMERS    
WHERE                 
      TSMERS.TSMORGAN_IS_NUMBER   IS NULL       
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMORGAN   TSMORGAN          
      WHERE TSMERS.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER        
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMESTLC   ALWAYS    CHARACTERIZES                   TSMALP' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSMESTLC   TSMESTLC
WHERE     
      TSMESTLC.TSMALP_ORG_ID <> 'DEMOTEST' AND            
      (TSMESTLC.TSMALP_IS_NUMBER     IS NULL     
      OR TSMESTLC.TSMALP_ORG_ID        IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMALP   TSMALP              
      WHERE TSMESTLC.TSMALP_IS_NUMBER                = TSMALP.TSMALP_IS_NUMBER          
      AND TSMESTLC.TSMALP_ORG_ID                   = TSMALP.TSMALP_ORG_ID               
      ))               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMESTLC   SOMETIMES IS_CHARACTERIZED_BY             TSMESTRY' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMESTLC   TSMESTLC
WHERE                 
      TSMESTLC.TSMESTRY_ORG_ID      IS NOT NULL 
      AND TSMESTLC.TSMESTRY_IS_NUMBER   IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMESTRY   TSMESTRY          
      WHERE TSMESTLC.TSMESTRY_ORG_ID                 = TSMESTRY.TSMESTRY_ORG_ID         
      AND TSMESTLC.TSMESTRY_IS_NUMBER              = TSMESTRY.TSMESTRY_IS_NUMBER        
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMESTRY   SOMETIMES IS_LOCATED_IN                   TSMESTRY' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMESTRY   TSMESTRY
WHERE                 
      TSMESTRY.TSMESTRY0ORG_ID      IS NOT NULL 
      AND TSMESTRY.TSMESTRY0IS_NUMBER   IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMESTRY   IN_TSMESTRY             
      WHERE TSMESTRY.TSMESTRY0ORG_ID                 = IN_TSMESTRY.TSMESTRY_ORG_ID      
      AND TSMESTRY.TSMESTRY0IS_NUMBER              = IN_TSMESTRY.TSMESTRY_IS_NUMBER     
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMFCLTY   ALWAYS    IS          TSMSTATN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMFCLTY   TSMFCLTY
WHERE                 
      TSMFCLTY.TSMSTATN_IS_NUMBER   IS NULL     
      OR TSMFCLTY.TSMSTATN_ORG_ID      IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMSTATN   TSMSTATN          
      WHERE TSMFCLTY.TSMSTATN_IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER      
      AND TSMFCLTY.TSMSTATN_ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMFILL    ALWAYS    IS_USED_IN  TSMINTVL' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMFILL   TSMFILL  
WHERE                 
      TSMFILL.TSMINTVL_IS_NUMBER   IS NULL      
      OR TSMFILL.TSMINTVL_ORG_ID      IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMINTVL   TSMINTVL          
      WHERE TSMFILL.TSMINTVL_IS_NUMBER              = TSMINTVL.TSMINTVL_IS_NUMBER       
      AND TSMFILL.TSMINTVL_ORG_ID                 = TSMINTVL.TSMINTVL_ORG_ID            
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMFSA     ALWAYS    DESCRIBES   TSMFCLTY' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMFSA   TSMFSA    
WHERE                 
      TSMFSA.TSMSTATN_ORG_ID      IS NULL       
      OR TSMFSA.TSMSTATN_IS_NUMBER   IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMFCLTY   TSMFCLTY          
      WHERE TSMFSA.TSMSTATN_ORG_ID                 = TSMFCLTY.TSMSTATN_ORG_ID              
      AND TSMFSA.TSMSTATN_IS_NUMBER              = TSMFCLTY.TSMSTATN_IS_NUMBER          
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMFSA     ALWAYS    IS_DESCRIBED_BY                 TSMSIC' AS "RELATIONSHIP"  from dual ;              
SELECT         
* 
FROM                  
   TSMFSA   TSMFSA    
WHERE                 
      TSMFSA.TSMSIC_CODE          IS NULL       
      OR TSMFSA.TSMSIC_ORG_ID        IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMSIC   TSMSIC              
      WHERE TSMFSA.TSMSIC_CODE = TSMSIC.TSMSIC_CODE                 
      AND TSMFSA.TSMSIC_ORG_ID                   = TSMSIC.TSMSIC_ORG_ID                 
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMGLL     ALWAYS    CHARACTERIZES                   TSMALP' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSMGLL   TSMGLL    
WHERE                 
      TSMGLL.TSMALP_IS_NUMBER     IS NULL       
      OR TSMGLL.TSMALP_ORG_ID        IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMALP   TSMALP              
      WHERE TSMGLL.TSMALP_IS_NUMBER                = TSMALP.TSMALP_IS_NUMBER            
      AND TSMGLL.TSMALP_ORG_ID                   = TSMALP.TSMALP_ORG_ID                 
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMGNTXT   SOMETIMES DEFINES     TSRRSULT' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMGNTXT   TSMGNTXT
WHERE                 
      TSMGNTXT.TSRRSULT_IS_NUMBER   IS NOT NULL 
      AND TSMGNTXT.TSRRSULT_ORG_ID      IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRRSULT   TSRRSULT          
      WHERE TSMGNTXT.TSRRSULT_IS_NUMBER              = TSRRSULT.TSRRSULT_IS_NUMBER      
      AND TSMGNTXT.TSRRSULT_ORG_ID                 = TSRRSULT.TSRRSULT_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMGNTXT   SOMETIMES DESCRIBES   TSMPROJ' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSMGNTXT   TSMGNTXT
WHERE                 
      TSMGNTXT.TSMPROJ_IS_NUMBER    IS NOT NULL 
      AND TSMGNTXT.TSMPROJ_ORG_ID       IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMPROJ   TSMPROJ            
      WHERE TSMGNTXT.TSMPROJ_IS_NUMBER               = TSMPROJ.TSMPROJ_IS_NUMBER        
      AND TSMGNTXT.TSMPROJ_ORG_ID                  = TSMPROJ.TSMPROJ_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMGNTXT   SOMETIMES DESCRIBES   TSMPROGM' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMGNTXT   TSMGNTXT
WHERE                 
      TSMGNTXT.TSMPROGM_IS_NUMBER   IS NOT NULL 
      AND TSMGNTXT.TSMPROGM_ORG_ID      IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMPROGM   TSMPROGM          
      WHERE TSMGNTXT.TSMPROGM_IS_NUMBER              = TSMPROGM.TSMPROGM_IS_NUMBER      
      AND TSMGNTXT.TSMPROGM_ORG_ID                 = TSMPROGM.TSMPROGM_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMGNTXT   SOMETIMES DESCRIBES   TSRGRCFG' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMGNTXT   TSMGNTXT
WHERE                 
      TSMGNTXT.TSRGRCFG_IS_NUMBER   IS NOT NULL 
      AND TSMGNTXT.TSRGRCFG_ORG_ID      IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRGRCFG   TSRGRCFG          
      WHERE TSMGNTXT.TSRGRCFG_IS_NUMBER              = TSRGRCFG.TSRGRCFG_IS_NUMBER      
      AND TSMGNTXT.TSRGRCFG_ORG_ID                 = TSRGRCFG.TSRGRCFG_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMHOLE    ALWAYS    IS          TSMINTVL' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMHOLE   TSMHOLE  
WHERE                 
      TSMHOLE.TSMINTVL_IS_NUMBER   IS NULL      
      OR TSMHOLE.TSMINTVL_ORG_ID      IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMINTVL   TSMINTVL          
      WHERE TSMHOLE.TSMINTVL_IS_NUMBER              = TSMINTVL.TSMINTVL_IS_NUMBER       
      AND TSMHOLE.TSMINTVL_ORG_ID                 = TSMINTVL.TSMINTVL_ORG_ID            
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMIGUA    ALWAYS    FURTHER_DEFINES                 TSMINTVL' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMIGUA   TSMIGUA  
WHERE                 
      TSMIGUA.TSMINTVL_IS_NUMBER   IS NULL      
      OR TSMIGUA.TSMINTVL_ORG_ID      IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMINTVL   TSMINTVL          
      WHERE TSMIGUA.TSMINTVL_IS_NUMBER              = TSMINTVL.TSMINTVL_IS_NUMBER       
      AND TSMIGUA.TSMINTVL_ORG_ID                 = TSMINTVL.TSMINTVL_ORG_ID            
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMIGUA    ALWAYS    IS_DESCRIBED_BY                 TSMGEOUN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMIGUA   TSMIGUA  
WHERE                 
      TSMIGUA.TSMGEOUN_CD          IS NULL      
      OR TSMIGUA.TSMGEOUN_ORG_ID      IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMGEOUN   TSMGEOUN          
      WHERE TSMIGUA.TSMGEOUN_CD = TSMGEOUN.TSMGEOUN_CD              
      AND TSMIGUA.TSMGEOUN_ORG_ID                 = TSMGEOUN.TSMGEOUN_ORG_ID            
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMINTVL   SOMETIMES CONSISTS_OF TSMLTHUN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMINTVL   TSMINTVL
WHERE                 
      TSMINTVL.TSMLTHUN_CD          IS NOT NULL 
      AND TSMINTVL.TSMLTHUN_ORG_ID      IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMLTHUN   TSMLTHUN          
      WHERE TSMINTVL.TSMLTHUN_CD = TSMLTHUN.TSMLTHUN_CD             
      AND TSMINTVL.TSMLTHUN_ORG_ID                 = TSMLTHUN.TSMLTHUN_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMINTVL   SOMETIMES CONSISTS_OF TSMGEOUN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMINTVL   TSMINTVL
WHERE                 
      TSMINTVL.TSMGEOUN_CD          IS NOT NULL 
      AND TSMINTVL.TSMGEOUN_ORG_ID      IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1  
      FROM   TSMGEOUN   TSMGEOUN          
      WHERE TSMINTVL.TSMGEOUN_CD = TSMGEOUN.TSMGEOUN_CD             
      AND TSMINTVL.TSMGEOUN_ORG_ID                 = TSMGEOUN.TSMGEOUN_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMINTVL   ALWAYS    PARTITIONS  TSMWELL' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSMINTVL   TSMINTVL
WHERE                 
      TSMINTVL.TSMWELL_IS_NUMBER    IS NULL     
      OR TSMINTVL.TSMWELL_ORG_ID       IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMWELL   TSMWELL            
      WHERE TSMINTVL.TSMWELL_IS_NUMBER               = TSMWELL.TSMWELL_IS_NUMBER        
      AND TSMINTVL.TSMWELL_ORG_ID                  = TSMWELL.TSMWELL_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMLOG     ALWAYS    DESCRIBES_CONSTRUCTION_OF       TSMWELL' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSMLOG   TSMLOG    
WHERE                 
      TSMLOG.TSMWELL_IS_NUMBER    IS NULL       
      OR TSMLOG.TSMWELL_ORG_ID       IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMWELL   TSMWELL            
      WHERE TSMLOG.TSMWELL_IS_NUMBER               = TSMWELL.TSMWELL_IS_NUMBER          
      AND TSMLOG.TSMWELL_ORG_ID                  = TSMWELL.TSMWELL_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMOCNLC   ALWAYS    CHARACTERIZES                   TSMALP' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSMOCNLC   TSMOCNLC
WHERE                 
      TSMOCNLC.TSMALP_IS_NUMBER     IS NULL     
      OR TSMOCNLC.TSMALP_ORG_ID        IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMALP   TSMALP              
      WHERE TSMOCNLC.TSMALP_IS_NUMBER                = TSMALP.TSMALP_IS_NUMBER          
      AND TSMOCNLC.TSMALP_ORG_ID                   = TSMALP.TSMALP_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMOPNG    ALWAYS    IS          TSMINTVL' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMOPNG   TSMOPNG  
WHERE                 
      TSMOPNG.TSMINTVL_IS_NUMBER   IS NULL      
      OR TSMOPNG.TSMINTVL_ORG_ID      IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMINTVL   TSMINTVL          
      WHERE TSMOPNG.TSMINTVL_IS_NUMBER              = TSMINTVL.TSMINTVL_IS_NUMBER       
      AND TSMOPNG.TSMINTVL_ORG_ID                 = TSMINTVL.TSMINTVL_ORG_ID            
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMPCOA    ALWAYS    INVOLVES    TSMCPORG' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMPCOA   TSMPCOA  
WHERE                 
      TSMPCOA.TSMCPORG_IS_NUMBER   IS NULL      
      OR TSMPCOA.TSMCPORG_ORG_ID      IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMCPORG   TSMCPORG          
      WHERE TSMPCOA.TSMCPORG_IS_NUMBER              = TSMCPORG.TSMCPORG_IS_NUMBER       
      AND TSMPCOA.TSMCPORG_ORG_ID                 = TSMCPORG.TSMCPORG_ORG_ID            
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMPCOA    ALWAYS    IS_INVOLVED_IN                  TSMPROJ' AS "RELATIONSHIP"  from dual ;             
SELECT                
* 
FROM                  
   TSMPCOA   TSMPCOA  
WHERE                 
      TSMPCOA.TSMPROJ_IS_NUMBER    IS NULL      
      OR TSMPCOA.TSMPROJ_ORG_ID       IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMPROJ   TSMPROJ            
      WHERE TSMPCOA.TSMPROJ_IS_NUMBER               = TSMPROJ.TSMPROJ_IS_NUMBER         
      AND TSMPCOA.TSMPROJ_ORG_ID                  = TSMPROJ.TSMPROJ_ORG_ID              
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMPERSN   ALWAYS    IS_PART_OF  TSMORGAN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMPERSN   TSMPERSN
WHERE                 
      TSMPERSN.TSMORGAN_IS_NUMBER   IS NULL     
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMORGAN   TSMORGAN          
      WHERE TSMPERSN.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER      
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMPIPE    ALWAYS    IS_PART_OF  TSMFCLTY' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMPIPE   TSMPIPE  
WHERE                 
      TSMPIPE.TSMSTATN_ORG_ID      IS NULL      
      OR TSMPIPE.TSMSTATN_IS_NUMBER   IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMFCLTY   TSMFCLTY          
      WHERE TSMPIPE.TSMSTATN_ORG_ID                 = TSMFCLTY.TSMSTATN_ORG_ID          
      AND TSMPIPE.TSMSTATN_IS_NUMBER              = TSMFCLTY.TSMSTATN_IS_NUMBER         
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMPMGRD   ALWAYS    BELONGS_TO  TSMSTATN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMPMGRD   TSMPMGRD
WHERE                 
      TSMPMGRD.TSMSTATN_IS_NUMBER   IS NULL     
      OR TSMPMGRD.TSMSTATN_ORG_ID      IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMSTATN   TSMSTATN          
      WHERE TSMPMGRD.TSMSTATN_IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER      
      AND TSMPMGRD.TSMSTATN_ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMPMTCT   ALWAYS    BELONGS_TO  TSMSTATN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMPMTCT   TSMPMTCT
WHERE                 
      TSMPMTCT.TSMSTATN_IS_NUMBER   IS NULL     
      OR TSMPMTCT.TSMSTATN_ORG_ID      IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMSTATN   TSMSTATN          
      WHERE TSMPMTCT.TSMSTATN_IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER      
      AND TSMPMTCT.TSMSTATN_ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMPPA     ALWAYS    HAS         TSMPROJ' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSMPPA   TSMPPA    
WHERE                 
      TSMPPA.TSMPROJ_IS_NUMBER    IS NULL       
      OR TSMPPA.TSMPROJ_ORG_ID       IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1       
      FROM   TSMPROJ   TSMPROJ            
      WHERE TSMPPA.TSMPROJ_IS_NUMBER               = TSMPROJ.TSMPROJ_IS_NUMBER          
      AND TSMPPA.TSMPROJ_ORG_ID                  = TSMPROJ.TSMPROJ_ORG_ID          
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMPPA     ALWAYS    HAS         TSMPERSN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMPPA   TSMPPA    
WHERE                 
      TSMPPA.TSMPERSN_IS_NUMBER   IS NULL       
      OR TSMPPA.TSMPERSN_ORG_ID      IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMPERSN   TSMPERSN          
      WHERE TSMPPA.TSMPERSN_IS_NUMBER              = TSMPERSN.TSMPERSN_IS_NUMBER        
      AND TSMPPA.TSMPERSN_ORG_ID                 = TSMPERSN.TSMPERSN_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMPPRA    ALWAYS    HAS         TSMPPA' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSMPPRA   TSMPPRA  
WHERE                 
      TSMPPRA.TSMPERSN_ORG_ID      IS NULL      
      OR TSMPPRA.TSMPERSN_IS_NUMBER   IS NULL   
      OR TSMPPRA.TSMPROJ_ORG_ID       IS NULL   
      OR TSMPPRA.TSMPROJ_IS_NUMBER    IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMPPA   TSMPPA              
      WHERE TSMPPRA.TSMPERSN_ORG_ID                 = TSMPPA.TSMPERSN_ORG_ID            
      AND TSMPPRA.TSMPERSN_IS_NUMBER              = TSMPPA.TSMPERSN_IS_NUMBER           
      AND TSMPPRA.TSMPROJ_ORG_ID                  = TSMPPA.TSMPROJ_ORG_ID               
      AND TSMPPRA.TSMPROJ_IS_NUMBER               = TSMPPA.TSMPROJ_IS_NUMBER            
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMPPRA    ALWAYS    IS_FOR      TSMPROLE' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMPPRA   TSMPPRA  
WHERE                 
      TSMPPRA.TSMPROLE_IS_NUMBER   IS NULL      
      OR TSMPPRA.TSMPROLE_ORG_ID      IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMPROLE   TSMPROLE          
      WHERE TSMPPRA.TSMPROLE_IS_NUMBER              = TSMPROLE.TSMPROLE_IS_NUMBER       
      AND TSMPPRA.TSMPROLE_ORG_ID                 = TSMPROLE.TSMPROLE_ORG_ID            
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMPRA     ALWAYS    IS_FOR      TSMPERSN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMPRA   TSMPRA    
WHERE                 
      TSMPRA.TSMPERSN_IS_NUMBER   IS NULL       
      OR TSMPRA.TSMPERSN_ORG_ID      IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMPERSN   TSMPERSN          
      WHERE TSMPRA.TSMPERSN_IS_NUMBER              = TSMPERSN.TSMPERSN_IS_NUMBER        
      AND TSMPRA.TSMPERSN_ORG_ID                 = TSMPERSN.TSMPERSN_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMPRA     ALWAYS    IS_FOR      TSMPROLE' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMPRA   TSMPRA    
WHERE                 
      TSMPRA.TSMPROLE_IS_NUMBER   IS NULL       
      OR TSMPRA.TSMPROLE_ORG_ID      IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMPROLE   TSMPROLE          
      WHERE TSMPRA.TSMPROLE_IS_NUMBER              = TSMPROLE.TSMPROLE_IS_NUMBER        
      AND TSMPRA.TSMPROLE_ORG_ID                 = TSMPROLE.TSMPROLE_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMPROGM   ALWAYS    SPONSORED_BYTSMORGAN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMPROGM   TSMPROGM
WHERE                 
      TSMPROGM.TSMORGAN_IS_NUMBER   IS NULL     
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMORGAN   TSMORGAN          
      WHERE TSMPROGM.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER      
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMPROJ    ALWAYS    IS_THE_RESPONSIBILITY_OF        TSMORGAN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMPROJ   TSMPROJ  
WHERE                 
      TSMPROJ.TSMORGAN_IS_NUMBER   IS NULL      
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMORGAN   TSMORGAN          
      WHERE TSMPROJ.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER       
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMPRPRA   ALWAYS    IS_FOR      TSMPROJ' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSMPRPRA   TSMPRPRA
WHERE                 
      TSMPRPRA.TSMPROJ_IS_NUMBER    IS NULL     
      OR TSMPRPRA.TSMPROJ_ORG_ID       IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMPROJ   TSMPROJ            
      WHERE TSMPRPRA.TSMPROJ_IS_NUMBER               = TSMPROJ.TSMPROJ_IS_NUMBER        
      AND TSMPRPRA.TSMPROJ_ORG_ID                  = TSMPROJ.TSMPROJ_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMPRPRA   ALWAYS    PARTICIPATED_IN_BY              TSMPROGM' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMPRPRA   TSMPRPRA
WHERE                 
      TSMPRPRA.TSMPROGM_IS_NUMBER   IS NULL     
      OR TSMPRPRA.TSMPROGM_ORG_ID      IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMPROGM   TSMPROGM          
      WHERE TSMPRPRA.TSMPROGM_IS_NUMBER              = TSMPROGM.TSMPROGM_IS_NUMBER      
      AND TSMPRPRA.TSMPROGM_ORG_ID                 = TSMPROGM.TSMPROGM_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMPSA     ALWAYS    IS_USED_BY  TSMPROJ' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSMPSA   TSMPSA    
WHERE                 
      TSMPSA.TSMPROJ_IS_NUMBER    IS NULL       
      OR TSMPSA.TSMPROJ_ORG_ID       IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMPROJ   TSMPROJ            
      WHERE TSMPSA.TSMPROJ_IS_NUMBER               = TSMPROJ.TSMPROJ_IS_NUMBER          
      AND TSMPSA.TSMPROJ_ORG_ID                  = TSMPROJ.TSMPROJ_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMPSA     ALWAYS    USES        TSMSTATN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMPSA   TSMPSA    
WHERE                 
      TSMPSA.TSMSTATN_IS_NUMBER   IS NULL       
      OR TSMPSA.TSMSTATN_ORG_ID      IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMSTATN   TSMSTATN                  
      WHERE TSMPSA.TSMSTATN_IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER        
      AND TSMPSA.TSMSTATN_ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMPSRA    ALWAYS    IS_FOR      TSMPSA' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSMPSRA   TSMPSRA  
WHERE                 
      TSMPSRA.TSMSTATN_ORG_ID      IS NULL      
      OR TSMPSRA.TSMSTATN_IS_NUMBER   IS NULL   
      OR TSMPSRA.TSMPROJ_ORG_ID       IS NULL   
      OR TSMPSRA.TSMPROJ_IS_NUMBER    IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMPSA   TSMPSA              
      WHERE TSMPSRA.TSMSTATN_ORG_ID                 = TSMPSA.TSMSTATN_ORG_ID            
      AND TSMPSRA.TSMSTATN_IS_NUMBER              = TSMPSA.TSMSTATN_IS_NUMBER           
      AND TSMPSRA.TSMPROJ_ORG_ID                  = TSMPSA.TSMPROJ_ORG_ID               
      AND TSMPSRA.TSMPROJ_IS_NUMBER               = TSMPSA.TSMPROJ_IS_NUMBER            
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMPSRA    ALWAYS    IS_FOR      TSMPSR' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSMPSRA   TSMPSRA  
WHERE                 
      TSMPSRA.TSMPSR_IS_NUMBER     IS NULL      
      OR TSMPSRA.TSMPSR_ORG_ID        IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMPSR   TSMPSR              
      WHERE TSMPSRA.TSMPSR_IS_NUMBER                = TSMPSR.TSMPSR_IS_NUMBER           
      AND TSMPSRA.TSMPSR_ORG_ID                   = TSMPSR.TSMPSR_ORG_ID                
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMPUMP    ALWAYS    DRAWS_WATER_FROM                TSMWELL' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSMPUMP   TSMPUMP  
WHERE                 
      TSMPUMP.TSMWELL_IS_NUMBER    IS NULL      
      OR TSMPUMP.TSMWELL_ORG_ID       IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMWELL   TSMWELL            
      WHERE TSMPUMP.TSMWELL_IS_NUMBER               = TSMWELL.TSMWELL_IS_NUMBER         
      AND TSMPUMP.TSMWELL_ORG_ID                  = TSMWELL.TSMWELL_ORG_ID              
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMRFLBL   ALWAYS    REFERENCES  TSMERS' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSMRFLBL   TSMRFLBL
WHERE                 
      TSMRFLBL.TSMERS_IS_NUMBER     IS NULL     
      OR TSMRFLBL.TSMERS_ORG_ID        IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMERS   TSMERS              
      WHERE TSMRFLBL.TSMERS_IS_NUMBER                = TSMERS.TSMERS_IS_NUMBER          
      AND TSMRFLBL.TSMERS_ORG_ID                   = TSMERS.TSMERS_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMRFLBL   ALWAYS    REFERENCES  TSMSTATN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMRFLBL   TSMRFLBL
WHERE                 
      TSMRFLBL.TSMSTATN_IS_NUMBER   IS NULL     
      OR TSMRFLBL.TSMSTATN_ORG_ID      IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMSTATN   TSMSTATN          
      WHERE TSMRFLBL.TSMSTATN_IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER      
      AND TSMRFLBL.TSMSTATN_ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMSPRNG   ALWAYS    IS          TSMSTATN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMSPRNG   TSMSPRNG
WHERE                 
      TSMSPRNG.TSMSTATN_IS_NUMBER   IS NULL     
      OR TSMSPRNG.TSMSTATN_ORG_ID      IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMSTATN   TSMSTATN          
      WHERE TSMSPRNG.TSMSTATN_IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER      
      AND TSMSPRNG.TSMSTATN_ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMSPRNG   SOMETIMES IS_DESCRIBED_BY                 TSMGEOUN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMSPRNG   TSMSPRNG
WHERE                 
      TSMSPRNG.TSMGEOUN_CD          IS NOT NULL 
      AND TSMSPRNG.TSMGEOUN_ORG_ID      IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMGEOUN   TSMGEOUN          
      WHERE TSMSPRNG.TSMGEOUN_CD = TSMGEOUN.TSMGEOUN_CD             
      AND TSMSPRNG.TSMGEOUN_ORG_ID                 = TSMGEOUN.TSMGEOUN_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMSPRNG   SOMETIMES IS_DESCRIBED_BY                 TSMLTHUN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMSPRNG   TSMSPRNG
WHERE                 
      TSMSPRNG.TSMLTHUN_CD          IS NOT NULL 
      AND TSMSPRNG.TSMLTHUN_ORG_ID      IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSMLTHUN   TSMLTHUN          
      WHERE TSMSPRNG.TSMLTHUN_CD = TSMLTHUN.TSMLTHUN_CD             
      AND TSMSPRNG.TSMLTHUN_ORG_ID                 = TSMLTHUN.TSMLTHUN_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMSTATN   ALWAYS    IS_CLASSIFIED_BY                TSMVSTC' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSMSTATN   TSMSTATN
WHERE                 
      TSMSTATN.TSMVSTC_IS_NUMBER    IS NULL     
      OR TSMSTATN.TSMVSTC_ORG_ID       IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMVSTC   TSMVSTC            
      WHERE TSMSTATN.TSMVSTC_IS_NUMBER               = TSMVSTC.TSMVSTC_IS_NUMBER        
      AND TSMSTATN.TSMVSTC_ORG_ID                  = TSMVSTC.TSMVSTC_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMSTATN   ALWAYS    IS_ESTABLISHED_BY               TSMORGAN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMSTATN   TSMSTATN
WHERE                 
      TSMSTATN.TSMORGAN_IS_NUMBER   IS NULL     
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMORGAN   TSMORGAN          
      WHERE TSMSTATN.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER      
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMUOA     ALWAYS    ESTABLISHES_ACCESS_TO           TSMORGAN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM           
   TSMUOA   TSMUOA    
WHERE                 
      TSMUOA.TSMORGAN_IS_NUMBER   IS NULL       
      OR    NOT EXISTS   
      (               
      SELECT 1        
      FROM   TSMORGAN   TSMORGAN          
      WHERE TSMUOA.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER        
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMUOA     ALWAYS    PROVIDES_ACCESS_FOR             TSMUSER' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSMUOA   TSMUOA    
WHERE                 
      TSMUOA.TSMUSER_USERID       IS NULL       
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMUSER   TSMUSER            
      WHERE TSMUOA.TSMUSER_USERID                  = TSMUSER.TSMUSER_USERID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMVSC     ALWAYS    IS_DESIGNATED_BY                TSMPROJ' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSMVSC   TSMVSC    
WHERE                 
      TSMVSC.TSMPROJ_IS_NUMBER    IS NULL       
      OR TSMVSC.TSMPROJ_ORG_ID       IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMPROJ   TSMPROJ            
      WHERE TSMVSC.TSMPROJ_IS_NUMBER               = TSMPROJ.TSMPROJ_IS_NUMBER          
      AND TSMVSC.TSMPROJ_ORG_ID                  = TSMPROJ.TSMPROJ_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMWELL    ALWAYS    IS          TSMSTATN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSMWELL   TSMWELL  
WHERE                 
      TSMWELL.TSMSTATN_IS_NUMBER   IS NULL      
      OR TSMWELL.TSMSTATN_ORG_ID      IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMSTATN   TSMSTATN          
      WHERE TSMWELL.TSMSTATN_IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER       
      AND TSMWELL.TSMSTATN_ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID            
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSMWLE     ALWAYS    IS_FOR      TSMWELL' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSMWLE   TSMWLE    
WHERE                 
      TSMWLE.TSMWELL_IS_NUMBER    IS NULL       
      OR TSMWLE.TSMWELL_ORG_ID       IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMWELL   TSMWELL            
      WHERE TSMWLE.TSMWELL_IS_NUMBER               = TSMWELL.TSMWELL_IS_NUMBER          
      AND TSMWLE.TSMWELL_ORG_ID                  = TSMWELL.TSMWELL_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRAAL     ALWAYS    IS_CONDUCTED_AT                 TSMALP' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSRAAL   TSRAAL    
WHERE       
	TSRAAL.TSMALP_ORG_ID <>'DEMOTEST' AND          
      (TSRAAL.TSMALP_IS_NUMBER     IS NULL       
      OR TSRAAL.TSMALP_ORG_ID        IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMALP   TSMALP              
      WHERE TSRAAL.TSMALP_IS_NUMBER                = TSMALP.TSMALP_IS_NUMBER            
      AND TSRAAL.TSMALP_ORG_ID                   = TSMALP.TSMALP_ORG_ID                 
      ))               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRAAL     ALWAYS    PLACES      TSRFDACT' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRAAL   TSRAAL    
WHERE                 
      TSRAAL.TSRFDACT_IS_NUMBER   IS NULL       
      OR TSRAAL.TSRFDACT_ORG_ID      IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRFDACT   TSRFDACT          
      WHERE TSRAAL.TSRFDACT_IS_NUMBER              = TSRFDACT.TSRFDACT_IS_NUMBER        
      AND TSRAAL.TSRFDACT_ORG_ID                 = TSRFDACT.TSRFDACT_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRADL     ALWAYS    COLLECTS_DATA_AT                TSMSTATN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRADL   TSRADL    
WHERE                 
      TSRADL.TSMSTATN_IS_NUMBER   IS NULL       
      OR TSRADL.TSMSTATN_ORG_ID      IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMSTATN   TSMSTATN          
      WHERE TSRADL.TSMSTATN_IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER        
      AND TSRADL.TSMSTATN_ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRANLPR   SOMETIMES HAS_AS_ITS_NATIONAL_MODEL       TSRANLPR' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRANLPR   TSRANLPR
WHERE                 
      TSRANLPR.TSRANLPR0IS_NUMBER   IS NOT NULL 
      AND TSRANLPR.TSRANLPR0ORG_ID      IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRANLPR   IN_TSRANLPR             
      WHERE TSRANLPR.TSRANLPR0IS_NUMBER              = IN_TSRANLPR.TSRANLPR_IS_NUMBER   
      AND TSRANLPR.TSRANLPR0ORG_ID                 = IN_TSRANLPR.TSRANLPR_ORG_ID        
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRANLPR   SOMETIMES IS_DESCRIBED_IN                 TSRCITN' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRANLPR   TSRANLPR
WHERE                 
      TSRANLPR.TSRCITN_IS_NUMBER    IS NOT NULL 
      AND TSRANLPR.TSRCITN_ORG_ID       IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRCITN   TSRCITN            
      WHERE TSRANLPR.TSRCITN_IS_NUMBER               = TSRCITN.TSRCITN_IS_NUMBER        
      AND TSRANLPR.TSRCITN_ORG_ID                  = TSRCITN.TSRCITN_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRANLPR   SOMETIMES USES        TSRANLEQ' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRANLPR   TSRANLPR
WHERE                 
      TSRANLPR.TSRANLEQ_IS_NUMBER   IS NOT NULL 
      AND TSRANLPR.TSRANLEQ_ORG_ID      IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRANLEQ   TSRANLEQ          
      WHERE TSRANLPR.TSRANLEQ_IS_NUMBER              = TSRANLEQ.TSRANLEQ_IS_NUMBER      
      AND TSRANLPR.TSRANLEQ_ORG_ID                 = TSRANLEQ.TSRANLEQ_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRBRG     SOMETIMES HAS_RESULT_TAXON_OF             TSRCHAR' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRBRG   TSRBRG    
WHERE                
      TSRBRG.TSRCHAR_IS_NUMBER    IS NOT NULL   
      AND TSRBRG.TSRCHAR_ORG_ID       IS NOT NULL                   
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRCHAR   TSRCHAR            
      WHERE TSRBRG.TSRCHAR_IS_NUMBER               = TSRCHAR.TSRCHAR_IS_NUMBER          
      AND TSRBRG.TSRCHAR_ORG_ID                  = TSRCHAR.TSRCHAR_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRBRG     ALWAYS    IS_FOR      TSRFDACT' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRBRG   TSRBRG    
WHERE                 
      TSRBRG.TSRFDACT_IS_NUMBER   IS NULL       
      OR TSRBRG.TSRFDACT_ORG_ID      IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRFDACT   TSRFDACT          
      WHERE TSRBRG.TSRFDACT_IS_NUMBER              = TSRFDACT.TSRFDACT_IS_NUMBER        
      AND TSRBRG.TSRFDACT_ORG_ID                 = TSRFDACT.TSRFDACT_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRBRGI    ALWAYS    IS_PART_OF  TSRBRG' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSRBRGI   TSRBRGI  
WHERE                 
      TSRBRGI.TSRBRG_IS_NUMBER     IS NULL      
      OR TSRBRGI.TSRBRG_ORG_ID        IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRBRG   TSRBRG              
      WHERE TSRBRGI.TSRBRG_IS_NUMBER                = TSRBRG.TSRBRG_IS_NUMBER           
      AND TSRBRGI.TSRBRG_ORG_ID                   = TSRBRG.TSRBRG_ORG_ID                
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRCCGA    ALWAYS    INCORPORATES_A_CHARACTERISTIC_TOTSRCHGRP' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRCCGA   TSRCCGA  
WHERE                 
      TSRCCGA.TSRCHGRP_IS_NUMBER   IS NULL      
      OR TSRCCGA.TSRCHGRP_ORG_ID      IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRCHGRP   TSRCHGRP          
      WHERE TSRCCGA.TSRCHGRP_IS_NUMBER              = TSRCHGRP.TSRCHGRP_IS_NUMBER       
      AND TSRCCGA.TSRCHGRP_ORG_ID                 = TSRCHGRP.TSRCHGRP_ORG_ID            
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRCCGA    ALWAYS    PLACES_IN_A_GROUP               TSRCHAR' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRCCGA   TSRCCGA  
WHERE                 
      TSRCCGA.TSRCHAR_IS_NUMBER    IS NULL      
      OR TSRCCGA.TSRCHAR_ORG_ID       IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRCHAR   TSRCHAR            
      WHERE TSRCCGA.TSRCHAR_IS_NUMBER               = TSRCHAR.TSRCHAR_IS_NUMBER         
      AND TSRCCGA.TSRCHAR_ORG_ID                  = TSRCHAR.TSRCHAR_ORG_ID              
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRCHALS   ALWAYS    ALTERNATIVELY_NAMES             TSRCHAR' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRCHALS   TSRCHALS
WHERE                 
      TSRCHALS.TSRCHAR_IS_NUMBER    IS NULL     
      OR TSRCHALS.TSRCHAR_ORG_ID       IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRCHAR   TSRCHAR            
      WHERE TSRCHALS.TSRCHAR_IS_NUMBER               = TSRCHAR.TSRCHAR_IS_NUMBER        
      AND TSRCHALS.TSRCHAR_ORG_ID                  = TSRCHAR.TSRCHAR_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRCHDEF   ALWAYS    DESCRIBES   TSRCCGA' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRCHDEF   TSRCHDEF
WHERE                 
      TSRCHDEF.TSRCCGA_ORG_ID       IS NULL     
      OR TSRCHDEF.TSRCCGA_IS_NUMBER    IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRCCGA   TSRCCGA            
      WHERE TSRCHDEF.TSRCCGA_ORG_ID                  = TSRCCGA.TSRCCGA_ORG_ID           
      AND TSRCHDEF.TSRCCGA_IS_NUMBER               = TSRCCGA.TSRCCGA_IS_NUMBER          
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRCHDEF   SOMETIMES IS_DESCRIBED_BY                 TSRANLPR' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRCHDEF   TSRCHDEF
WHERE                 
      TSRCHDEF.TSRANLPR_IS_NUMBER   IS NOT NULL 
      AND TSRCHDEF.TSRANLPR_ORG_ID      IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRANLPR   TSRANLPR          
      WHERE TSRCHDEF.TSRANLPR_IS_NUMBER              = TSRANLPR.TSRANLPR_IS_NUMBER      
      AND TSRCHDEF.TSRANLPR_ORG_ID                 = TSRANLPR.TSRANLPR_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRCHDEF   SOMETIMES IS_DESCRIBED_BY                 TSRLSPP' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRCHDEF   TSRCHDEF
WHERE                 
      TSRCHDEF.TSRLSPP_IS_NUMBER    IS NOT NULL 
      AND TSRCHDEF.TSRLSPP_ORG_ID       IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRLSPP   TSRLSPP            
      WHERE TSRCHDEF.TSRLSPP_IS_NUMBER               = TSRLSPP.TSRLSPP_IS_NUMBER        
      AND TSRCHDEF.TSRLSPP_ORG_ID                  = TSRLSPP.TSRLSPP_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRCHGRP   SOMETIMES IS_DEFINED_IN                   TSRCITN' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRCHGRP   TSRCHGRP
WHERE                 
      TSRCHGRP.TSRCITN_IS_NUMBER    IS NOT NULL 
      AND TSRCHGRP.TSRCITN_ORG_ID       IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRCITN   TSRCITN            
      WHERE TSRCHGRP.TSRCITN_IS_NUMBER               = TSRCITN.TSRCITN_IS_NUMBER        
      AND TSRCHGRP.TSRCITN_ORG_ID                  = TSRCITN.TSRCITN_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRCHGRP   ALWAYS    IS_ESTABLISHED_AND_CONTROLLED_BYTSMORGAN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRCHGRP   TSRCHGRP
WHERE                 
      TSRCHGRP.TSMORGAN_IS_NUMBER   IS NULL     
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMORGAN   TSMORGAN          
      WHERE TSRCHGRP.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER      
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRCITN    ALWAYS    IS_REFERENCED_BY                TSMORGAN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRCITN   TSRCITN  
WHERE 
      TSRCITN.TSMORGAN_IS_NUMBER   IS NULL      
      OR    NOT EXISTS
      (       
      SELECT 1        
      FROM   TSMORGAN   TSMORGAN          
      WHERE TSRCITN.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER       
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRCLDES   ALWAYS    DESCRIBES_CELL_FORMS_FOR        TSRRSULT' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRCLDES   TSRCLDES
WHERE                 
      TSRCLDES.TSRRSULT_IS_NUMBER   IS NULL     
      OR TSRCLDES.TSRRSULT_ORG_ID      IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRRSULT   TSRRSULT          
      WHERE TSRCLDES.TSRRSULT_IS_NUMBER              = TSRRSULT.TSRRSULT_IS_NUMBER      
      AND TSRCLDES.TSRRSULT_ORG_ID                 = TSRRSULT.TSRRSULT_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRCPA     ALWAYS    ASSIGNS     TSRCITN' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRCPA   TSRCPA    
WHERE                 
      TSRCPA.TSRCITN_IS_NUMBER    IS NULL       
      OR TSRCPA.TSRCITN_ORG_ID       IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRCITN   TSRCITN            
      WHERE TSRCPA.TSRCITN_IS_NUMBER               = TSRCITN.TSRCITN_IS_NUMBER          
      AND TSRCPA.TSRCITN_ORG_ID                  = TSRCITN.TSRCITN_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRCPA     ALWAYS    CORRESPONDS_TO                  TSMPROJ' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRCPA   TSRCPA    
WHERE                 
      TSRCPA.TSMPROJ_IS_NUMBER    IS NULL       
      OR TSRCPA.TSMPROJ_ORG_ID       IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMPROJ   TSMPROJ            
      WHERE TSRCPA.TSMPROJ_IS_NUMBER               = TSMPROJ.TSMPROJ_IS_NUMBER          
      AND TSRCPA.TSMPROJ_ORG_ID                  = TSMPROJ.TSMPROJ_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRCPV     ALWAYS    SERVES_AS_THE_RESULT_FOR        TSRCHAR' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRCPV   TSRCPV    
WHERE                 
      TSRCPV.TSRCHAR_IS_NUMBER    IS NULL       
      OR TSRCPV.TSRCHAR_ORG_ID       IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRCHAR   TSRCHAR            
      WHERE TSRCPV.TSRCHAR_IS_NUMBER               = TSRCHAR.TSRCHAR_IS_NUMBER          
      AND TSRCPV.TSRCHAR_ORG_ID                  = TSRCHAR.TSRCHAR_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRCTCA    ALWAYS    ASSIGNS     TSRCHTYP' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRCTCA   TSRCTCA  
WHERE                 
      TSRCTCA.TSRCHTYP_CATEGORY    IS NULL      
      OR TSRCTCA.TSRCHTYP_SUBCATGRY   IS NULL   
      OR TSRCTCA.TSRCHTYP_ORG_ID      IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRCHTYP   TSRCHTYP          
      WHERE TSRCTCA.TSRCHTYP_CATEGORY               = TSRCHTYP.TSRCHTYP_CATEGORY        
      AND TSRCTCA.TSRCHTYP_SUBCATGRY              = TSRCHTYP.TSRCHTYP_SUBCATGRY         
      AND TSRCTCA.TSRCHTYP_ORG_ID                 = TSRCHTYP.TSRCHTYP_ORG_ID            
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRCTCA    ALWAYS    IS_ASSIGNED_TO                  TSRCHAR' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRCTCA   TSRCTCA  
WHERE                 
      TSRCTCA.TSRCHAR_IS_NUMBER    IS NULL      
      OR TSRCTCA.TSRCHAR_ORG_ID       IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRCHAR   TSRCHAR            
      WHERE TSRCTCA.TSRCHAR_IS_NUMBER               = TSRCHAR.TSRCHAR_IS_NUMBER         
      AND TSRCTCA.TSRCHAR_ORG_ID                  = TSRCHAR.TSRCHAR_ORG_ID              
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRDQL     ALWAYS    HAS         TSRUOM' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSRDQL   TSRDQL    
WHERE                 
      TSRDQL.TSRUOM_IS_NUMBER     IS NULL       
      OR TSRDQL.TSRUOM_ORG_ID        IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRUOM   TSRUOM              
      WHERE TSRDQL.TSRUOM_IS_NUMBER                = TSRUOM.TSRUOM_IS_NUMBER            
      AND TSRDQL.TSRUOM_ORG_ID                   = TSRUOM.TSRUOM_ORG_ID                 
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRDQL     ALWAYS    QUALIFIES   TSRRSULT' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRDQL   TSRDQL    
WHERE                 
      TSRDQL.TSRRSULT_IS_NUMBER   IS NULL       
      OR TSRDQL.TSRRSULT_ORG_ID      IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRRSULT   TSRRSULT          
      WHERE TSRDQL.TSRRSULT_IS_NUMBER              = TSRRSULT.TSRRSULT_IS_NUMBER        
      AND TSRDQL.TSRRSULT_ORG_ID                 = TSRRSULT.TSRRSULT_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSREOD     ALWAYS    PROVIDES_DETAIL_ABOUT           TSRSMPLE' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSREOD   TSREOD    
WHERE                 
      TSREOD.TSRFDACT_ORG_ID      IS NULL       
      OR TSREOD.TSRFDACT_IS_NUMBER   IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRSMPLE   TSRSMPLE          
      WHERE TSREOD.TSRFDACT_ORG_ID                 = TSRSMPLE.TSRFDACT_ORG_ID           
      AND TSREOD.TSRFDACT_IS_NUMBER              = TSRSMPLE.TSRFDACT_IS_NUMBER          
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFAFSA   ALWAYS    BELONGS_TO  TSRFDSET' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRFAFSA   TSRFAFSA
WHERE                 
      TSRFAFSA.TSRFDSET_IS_NUMBER   IS NULL     
      OR TSRFAFSA.TSRFDSET_ORG_ID      IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRFDSET   TSRFDSET          
      WHERE TSRFAFSA.TSRFDSET_IS_NUMBER              = TSRFDSET.TSRFDSET_IS_NUMBER      
      AND TSRFAFSA.TSRFDSET_ORG_ID                 = TSRFDSET.TSRFDSET_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFAFSA   ALWAYS    HAS         TSRFDACT' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRFAFSA   TSRFAFSA
WHERE                 
      TSRFAFSA.TSRFDACT_IS_NUMBER   IS NULL         
      OR TSRFAFSA.TSRFDACT_ORG_ID      IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRFDACT   TSRFDACT          
      WHERE TSRFAFSA.TSRFDACT_IS_NUMBER              = TSRFDACT.TSRFDACT_IS_NUMBER      
      AND TSRFAFSA.TSRFDACT_ORG_ID                 = TSRFDACT.TSRFDACT_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFAPEA   ALWAYS    COLLECTS    TSRFDACT' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRFAPEA   TSRFAPEA
WHERE                 
      TSRFAPEA.TSRFDACT_IS_NUMBER   IS NULL     
      OR TSRFAPEA.TSRFDACT_ORG_ID      IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRFDACT   TSRFDACT          
      WHERE TSRFAPEA.TSRFDACT_IS_NUMBER              = TSRFDACT.TSRFDACT_IS_NUMBER      
      AND TSRFAPEA.TSRFDACT_ORG_ID                 = TSRFDACT.TSRFDACT_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFAPEA   ALWAYS    IS_COLLECTED_BY                 TSMPERSN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRFAPEA   TSRFAPEA
WHERE                 
      TSRFAPEA.TSMPERSN_IS_NUMBER   IS NULL     
      OR TSRFAPEA.TSMPERSN_ORG_ID      IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMPERSN   TSMPERSN          
      WHERE TSRFAPEA.TSMPERSN_IS_NUMBER              = TSMPERSN.TSMPERSN_IS_NUMBER      
      AND TSRFAPEA.TSMPERSN_ORG_ID                 = TSMPERSN.TSMPERSN_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFAPRA   ALWAYS    IS_FOR      TSMPROJ' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRFAPRA   TSRFAPRA
WHERE                 
      TSRFAPRA.TSMPROJ_IS_NUMBER    IS NULL     
      OR TSRFAPRA.TSMPROJ_ORG_ID       IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMPROJ   TSMPROJ            
      WHERE TSRFAPRA.TSMPROJ_IS_NUMBER               = TSMPROJ.TSMPROJ_IS_NUMBER        
      AND TSRFAPRA.TSMPROJ_ORG_ID                  = TSMPROJ.TSMPROJ_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFAPRA   ALWAYS    IS_FOR      TSRFDACT' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRFAPRA   TSRFAPRA
WHERE                 
      TSRFAPRA.TSRFDACT_IS_NUMBER   IS NULL     
      OR TSRFAPRA.TSRFDACT_ORG_ID      IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRFDACT   TSRFDACT          
      WHERE TSRFAPRA.TSRFDACT_IS_NUMBER              = TSRFDACT.TSRFDACT_IS_NUMBER      
      AND TSRFAPRA.TSRFDACT_ORG_ID                 = TSRFDACT.TSRFDACT_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFAQSA   ALWAYS    HAS_CHECK_PROVIDED_BY           TSRFQS' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSRFAQSA   TSRFAQSA
WHERE                 
      TSRFAQSA.TSRFQS_IS_NUMBER     IS NULL     
      OR TSRFAQSA.TSRFQS_ORG_ID        IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRFQS   TSRFQS              
      WHERE TSRFAQSA.TSRFQS_IS_NUMBER                = TSRFQS.TSRFQS_IS_NUMBER          
      AND TSRFAQSA.TSRFQS_ORG_ID                   = TSRFQS.TSRFQS_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFAQSA   ALWAYS    VALIDATES   TSRFDACT' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRFAQSA   TSRFAQSA
WHERE                 
      TSRFAQSA.TSRFDACT_IS_NUMBER   IS NULL     
      OR TSRFAQSA.TSRFDACT_ORG_ID      IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRFDACT   TSRFDACT          
      WHERE TSRFAQSA.TSRFDACT_IS_NUMBER              = TSRFDACT.TSRFDACT_IS_NUMBER      
      AND TSRFAQSA.TSRFDACT_ORG_ID                 = TSRFDACT.TSRFDACT_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFDACT   SOMETIMES COMPOSITES_INTO                 TSRFDACT' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRFDACT   TSRFDACT
WHERE                 
      TSRFDACT.TSRFDACT0IS_NUMBER   IS NOT NULL 
      AND TSRFDACT.TSRFDACT0ORG_ID      IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRFDACT   IN_TSRFDACT             
      WHERE TSRFDACT.TSRFDACT0IS_NUMBER              = IN_TSRFDACT.TSRFDACT_IS_NUMBER   
      AND TSRFDACT.TSRFDACT0ORG_ID                 = IN_TSRFDACT.TSRFDACT_ORG_ID        
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFDACT   SOMETIMES HAS_AS_ITS_SUBJECT              TSRBIOPT' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRFDACT   TSRFDACT
WHERE                 
      TSRFDACT.TSRBIOPT_IS_NUMBER   IS NOT NULL 
      AND TSRFDACT.TSRBIOPT_ORG_ID      IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRBIOPT   TSRBIOPT          
      WHERE TSRFDACT.TSRBIOPT_IS_NUMBER              = TSRBIOPT.TSRBIOPT_IS_NUMBER      
      AND TSRFDACT.TSRBIOPT_ORG_ID                 = TSRBIOPT.TSRBIOPT_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFDACT   SOMETIMES HAS_A_SUBJECT_TAXON_OF          TSRCHAR' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRFDACT   TSRFDACT
WHERE                 
      TSRFDACT.TSRCHAR_IS_NUMBER    IS NOT NULL 
      AND TSRFDACT.TSRCHAR_ORG_ID       IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRCHAR   TSRCHAR            
      WHERE TSRFDACT.TSRCHAR_IS_NUMBER               = TSRCHAR.TSRCHAR_IS_NUMBER        
      AND TSRFDACT.TSRCHAR_ORG_ID                  = TSRCHAR.TSRCHAR_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFDACT   SOMETIMES IS_FURNISHED_BY                 TSRGRCFG' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRFDACT   TSRFDACT
WHERE                 
      TSRFDACT.TSRGRCFG_IS_NUMBER   IS NOT NULL 
      AND TSRFDACT.TSRGRCFG_ORG_ID      IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRGRCFG   TSRGRCFG          
      WHERE TSRFDACT.TSRGRCFG_IS_NUMBER              = TSRGRCFG.TSRGRCFG_IS_NUMBER      
      AND TSRFDACT.TSRGRCFG_ORG_ID                 = TSRGRCFG.TSRGRCFG_ORG_ID           
      )               
;     

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFDACT   SOMETIMES IS_FURNISHED_BY                 TSRFLDGR' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRFDACT   TSRFDACT                 
WHERE                 
      TSRFDACT.TSRFLDGR_IS_NUMBER   IS NOT NULL 
      AND TSRFDACT.TSRFLDGR_ORG_ID      IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRFLDGR   TSRFLDGR          
      WHERE TSRFDACT.TSRFLDGR_IS_NUMBER              = TSRFLDGR.TSRFLDGR_IS_NUMBER      
      AND TSRFDACT.TSRFLDGR_ORG_ID                 = TSRFLDGR.TSRFLDGR_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFDACT   SOMETIMES IS_GATHERED_BY                  TSRFLDPR' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRFDACT   TSRFDACT
WHERE                 
      TSRFDACT.TSRFLDPR_IS_NUMBER   IS NOT NULL 
      AND TSRFDACT.TSRFLDPR_ORG_ID      IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRFLDPR   TSRFLDPR          
      WHERE TSRFDACT.TSRFLDPR_IS_NUMBER              = TSRFLDPR.TSRFLDPR_IS_NUMBER      
      AND TSRFDACT.TSRFLDPR_ORG_ID                 = TSRFLDPR.TSRFLDPR_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFDACT   SOMETIMES IS_SPLIT_FROM                   TSRFDACT' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRFDACT   TSRFDACT
WHERE                 
      TSRFDACT.TSRFDACT1IS_NUMBER   IS NOT NULL 
      AND TSRFDACT.TSRFDACT1ORG_ID      IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRFDACT   IN_TSRFDACT             
      WHERE TSRFDACT.TSRFDACT1IS_NUMBER              = IN_TSRFDACT.TSRFDACT_IS_NUMBER   
      AND TSRFDACT.TSRFDACT1ORG_ID                 = IN_TSRFDACT.TSRFDACT_ORG_ID        
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFDACT   SOMETIMES OCCURS_DURING                   TSRSTVST' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRFDACT   TSRFDACT
WHERE                 
      TSRFDACT.TSRSTVST_IS_NUMBER   IS NOT NULL 
      AND TSRFDACT.TSRSTVST_ORG_ID      IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRSTVST   TSRSTVST          
      WHERE TSRFDACT.TSRSTVST_IS_NUMBER              = TSRSTVST.TSRSTVST_IS_NUMBER      
      AND TSRFDACT.TSRSTVST_ORG_ID                 = TSRSTVST.TSRSTVST_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFDACT   SOMETIMES OCCURS_WITHIN                   TSROPPRD' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRFDACT   TSRFDACT
WHERE                 
      TSRFDACT.TSROPPRD_ORG_ID      IS NOT NULL 
      AND TSRFDACT.TSROPPRD_IS_NUMBER   IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSROPPRD   TSROPPRD          
      WHERE TSRFDACT.TSROPPRD_ORG_ID                 = TSROPPRD.TSROPPRD_ORG_ID         
      AND TSRFDACT.TSROPPRD_IS_NUMBER              = TSROPPRD.TSROPPRD_IS_NUMBER        
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFDSET   ALWAYS    IS_DEFINED_BY                   TSRSTVST' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRFDSET   TSRFDSET
WHERE                 
      TSRFDSET.TSRSTVST_IS_NUMBER   IS NULL     
      OR TSRFDSET.TSRSTVST_ORG_ID      IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRSTVST   TSRSTVST          
      WHERE TSRFDSET.TSRSTVST_IS_NUMBER              = TSRSTVST.TSRSTVST_IS_NUMBER      
      AND TSRFDSET.TSRSTVST_ORG_ID                 = TSRSTVST.TSRSTVST_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFLDPR   ALWAYS    IS_DEFINED_BY                   TSMORGAN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRFLDPR   TSRFLDPR
WHERE                 
      TSRFLDPR.TSMORGAN_IS_NUMBER   IS NULL     
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMORGAN   TSMORGAN          
      WHERE TSRFLDPR.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER      
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFLDPR   SOMETIMES IS_DEFINED_IN                   TSRCITN' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRFLDPR   TSRFLDPR
WHERE                 
      TSRFLDPR.TSRCITN_IS_NUMBER    IS NOT NULL 
      AND TSRFLDPR.TSRCITN_ORG_ID       IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRCITN   TSRCITN            
      WHERE TSRFLDPR.TSRCITN_IS_NUMBER               = TSRCITN.TSRCITN_IS_NUMBER        
      AND TSRFLDPR.TSRCITN_ORG_ID                  = TSRCITN.TSRCITN_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFQS     ALWAYS    IS_CREATED_FOR                  TSRTRIP' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRFQS   TSRFQS    
WHERE                 
      TSRFQS.TSRTRIP_IS_NUMBER    IS NULL       
      OR TSRFQS.TSRTRIP_ORG_ID       IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRTRIP   TSRTRIP            
      WHERE TSRFQS.TSRTRIP_IS_NUMBER               = TSRTRIP.TSRTRIP_IS_NUMBER          
      AND TSRFQS.TSRTRIP_ORG_ID                  = TSRTRIP.TSRTRIP_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFQSDP   ALWAYS    IS_OWNED_BY TSMORGAN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRFQSDP   TSRFQSDP
WHERE                 
      TSRFQSDP.TSMORGAN_IS_NUMBER   IS NULL     
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMORGAN   TSMORGAN          
      WHERE TSRFQSDP.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER      
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFQSPA   ALWAYS    IS_FOR      TSMPERSN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRFQSPA   TSRFQSPA
WHERE                 
      TSRFQSPA.TSMPERSN_IS_NUMBER   IS NULL     
      OR TSRFQSPA.TSMPERSN_ORG_ID      IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMPERSN   TSMPERSN          
      WHERE TSRFQSPA.TSMPERSN_IS_NUMBER              = TSMPERSN.TSMPERSN_IS_NUMBER      
      AND TSRFQSPA.TSMPERSN_ORG_ID                 = TSMPERSN.TSMPERSN_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRFQSPA   ALWAYS    IS_FOR      TSRFQS' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
*          
FROM                  
   TSRFQSPA   TSRFQSPA
WHERE                 
      TSRFQSPA.TSRFQS_IS_NUMBER     IS NULL     
      OR TSRFQSPA.TSRFQS_ORG_ID        IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRFQS   TSRFQS              
      WHERE TSRFQSPA.TSRFQS_IS_NUMBER                = TSRFQS.TSRFQS_IS_NUMBER          
      AND TSRFQSPA.TSRFQS_ORG_ID                   = TSRFQS.TSRFQS_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRGRCFG   ALWAYS    DESCRIBES   TSRFLDGR' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRGRCFG   TSRGRCFG
WHERE                 
      TSRGRCFG.TSRFLDGR_IS_NUMBER   IS NULL     
      OR TSRGRCFG.TSRFLDGR_ORG_ID      IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRFLDGR   TSRFLDGR          
      WHERE TSRGRCFG.TSRFLDGR_IS_NUMBER              = TSRFLDGR.TSRFLDGR_IS_NUMBER      
      AND TSRGRCFG.TSRFLDGR_ORG_ID                 = TSRFLDGR.TSRFLDGR_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRGRCFG   ALWAYS    IS_DEFINED_BY                   TSMORGAN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRGRCFG   TSRGRCFG
WHERE                 
      TSRGRCFG.TSMORGAN_IS_NUMBER   IS NULL     
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMORGAN   TSMORGAN          
      WHERE TSRGRCFG.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER      
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRHCSC    ALWAYS    EVALUATES   TSRCHGRP' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRHCSC   TSRHCSC  
WHERE                 
      TSRHCSC.TSRCHGRP_IS_NUMBER   IS NULL      
      OR TSRHCSC.TSRCHGRP_ORG_ID      IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRCHGRP   TSRCHGRP          
      WHERE TSRHCSC.TSRCHGRP_IS_NUMBER              = TSRCHGRP.TSRCHGRP_IS_NUMBER       
      AND TSRHCSC.TSRCHGRP_ORG_ID                 = TSRCHGRP.TSRCHGRP_ORG_ID            
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRLAB     ALWAYS    IS_IDENTIFIED_BY                TSMORGAN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRLAB   TSRLAB    
WHERE                 
      TSRLAB.TSMORGAN_IS_NUMBER   IS NULL       
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMORGAN   TSMORGAN          
      WHERE TSRLAB.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER        
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRLSPP    SOMETIMES IS_DESCRIBED_BY                 TSRCITN' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRLSPP   TSRLSPP  
WHERE                 
      TSRLSPP.TSRCITN_IS_NUMBER    IS NOT NULL  
      AND TSRLSPP.TSRCITN_ORG_ID       IS NOT NULL                  
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRCITN   TSRCITN            
      WHERE TSRLSPP.TSRCITN_IS_NUMBER               = TSRCITN.TSRCITN_IS_NUMBER         
      AND TSRLSPP.TSRCITN_ORG_ID                  = TSRCITN.TSRCITN_ORG_ID              
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSROAPA    ALWAYS    ASSIGNS     TSRANLPR' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSROAPA   TSROAPA  
WHERE                 
      TSROAPA.TSRANLPR_IS_NUMBER   IS NULL      
      OR TSROAPA.TSRANLPR_ORG_ID      IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRANLPR   TSRANLPR          
      WHERE TSROAPA.TSRANLPR_IS_NUMBER              = TSRANLPR.TSRANLPR_IS_NUMBER       
      AND TSROAPA.TSRANLPR_ORG_ID                 = TSRANLPR.TSRANLPR_ORG_ID            
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSROAPA    ALWAYS    IS_ASSIGNED_TO                  TSMORGAN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSROAPA   TSROAPA  
WHERE                 
      TSROAPA.TSMORGAN_IS_NUMBER   IS NULL      
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMORGAN   TSMORGAN          
      WHERE TSROAPA.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER       
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSROAPCA   ALWAYS    ACCEPTS     TSRCHAR' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSROAPCA   TSROAPCA
WHERE                 
      TSROAPCA.TSRCHAR_IS_NUMBER    IS NULL     
      OR TSROAPCA.TSRCHAR_ORG_ID       IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRCHAR   TSRCHAR            
      WHERE TSROAPCA.TSRCHAR_IS_NUMBER               = TSRCHAR.TSRCHAR_IS_NUMBER        
      AND TSROAPCA.TSRCHAR_ORG_ID                  = TSRCHAR.TSRCHAR_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSROAPCA   ALWAYS    IS_ACCEPTED_FOR                 TSROAPA' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSROAPCA   TSROAPCA
WHERE                 
      TSROAPCA.TSRANLPR_ORG_ID      IS NULL     
      OR TSROAPCA.TSRANLPR_IS_NUMBER   IS NULL  
      OR TSROAPCA.TSMORGAN_IS_NUMBER   IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSROAPA   TSROAPA            
      WHERE TSROAPCA.TSRANLPR_ORG_ID                 = TSROAPA.TSRANLPR_ORG_ID          
      AND TSROAPCA.TSRANLPR_IS_NUMBER              = TSROAPA.TSRANLPR_IS_NUMBER         
      AND TSROAPCA.TSMORGAN_IS_NUMBER              = TSROAPA.TSMORGAN_IS_NUMBER         
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSROLSPA   ALWAYS    ASSIGNS     TSRLSPP' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSROLSPA   TSROLSPA
WHERE                 
      TSROLSPA.TSRLSPP_IS_NUMBER    IS NULL     
      OR TSROLSPA.TSRLSPP_ORG_ID       IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRLSPP   TSRLSPP            
      WHERE TSROLSPA.TSRLSPP_IS_NUMBER               = TSRLSPP.TSRLSPP_IS_NUMBER        
      AND TSROLSPA.TSRLSPP_ORG_ID                  = TSRLSPP.TSRLSPP_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSROLSPA   ALWAYS    IS_ASSIGNED_TO                  TSMORGAN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSROLSPA   TSROLSPA               
WHERE                 
      TSROLSPA.TSMORGAN_IS_NUMBER   IS NULL     
      OR    NOT EXISTS 
      (               
      SELECT 1        
      FROM   TSMORGAN   TSMORGAN          
      WHERE TSROLSPA.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER      
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSROPPRD   ALWAYS    IS_MONITORED_BY                 TSRADL' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSROPPRD   TSROPPRD
WHERE                 
      TSROPPRD.TSRADL_IS_NUMBER     IS NULL     
      OR TSROPPRD.TSRADL_ORG_ID        IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRADL   TSRADL              
      WHERE TSROPPRD.TSRADL_IS_NUMBER                = TSRADL.TSRADL_IS_NUMBER          
      AND TSROPPRD.TSRADL_ORG_ID                   = TSRADL.TSRADL_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRPOPA    ALWAYS    LINKS_AN_OPERATING_PERIOD_TO    TSMPROJ' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRPOPA   TSRPOPA  
WHERE                 
      TSRPOPA.TSMPROJ_IS_NUMBER    IS NULL      
      OR TSRPOPA.TSMPROJ_ORG_ID       IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMPROJ   TSMPROJ            
      WHERE TSRPOPA.TSMPROJ_IS_NUMBER               = TSMPROJ.TSMPROJ_IS_NUMBER         
      AND TSRPOPA.TSMPROJ_ORG_ID                  = TSMPROJ.TSMPROJ_ORG_ID              
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRPOPA    ALWAYS    LINKS_A_PROJECT_TO              TSROPPRD' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRPOPA   TSRPOPA  
WHERE                 
      TSRPOPA.TSROPPRD_ORG_ID      IS NULL      
      OR TSRPOPA.TSROPPRD_IS_NUMBER   IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSROPPRD   TSROPPRD          
      WHERE TSRPOPA.TSROPPRD_ORG_ID                 = TSROPPRD.TSROPPRD_ORG_ID          
      AND TSRPOPA.TSROPPRD_IS_NUMBER              = TSROPPRD.TSROPPRD_IS_NUMBER         
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRRCI     ALWAYS    INCLUDES    TSRRSULT' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRRCI   TSRRCI    
WHERE                 
      TSRRCI.TSRRSULT_IS_NUMBER   IS NULL       
      OR TSRRCI.TSRRSULT_ORG_ID      IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRRSULT   TSRRSULT          
      WHERE TSRRCI.TSRRSULT_IS_NUMBER              = TSRRSULT.TSRRSULT_IS_NUMBER        
      AND TSRRCI.TSRRSULT_ORG_ID                 = TSRRSULT.TSRRSULT_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRRCI     ALWAYS    IS_MEASURED_BY                  TSRUOM' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSRRCI   TSRRCI    
WHERE                 
      TSRRCI.TSRUOM_IS_NUMBER     IS NULL       
      OR TSRRCI.TSRUOM_ORG_ID        IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRUOM   TSRUOM              
      WHERE TSRRCI.TSRUOM_IS_NUMBER                = TSRUOM.TSRUOM_IS_NUMBER            
      AND TSRRCI.TSRUOM_ORG_ID                   = TSRUOM.TSRUOM_ORG_ID                 
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRRLRA    ALWAYS    QUALIFIES   TSRRSULT' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRRLRA   TSRRLRA  
WHERE                 
      TSRRLRA.TSRRSULT_IS_NUMBER   IS NULL      
      OR TSRRLRA.TSRRSULT_ORG_ID      IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRRSULT   TSRRSULT          
      WHERE TSRRLRA.TSRRSULT_IS_NUMBER              = TSRRSULT.TSRRSULT_IS_NUMBER       
      AND TSRRLRA.TSRRSULT_ORG_ID                 = TSRRSULT.TSRRSULT_ORG_ID            
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRRLRA    ALWAYS    QUALIFIES_A_RESULT_WITH         TSRLBRMK' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRRLRA   TSRRLRA  
WHERE                 
      TSRRLRA.TSRLBRMK_IS_NUMBER   IS NULL      
      OR TSRRLRA.TSRLBRMK_ORG_ID      IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRLBRMK   TSRLBRMK          
      WHERE TSRRLRA.TSRLBRMK_IS_NUMBER              = TSRLBRMK.TSRLBRMK_IS_NUMBER       
      AND TSRRLRA.TSRLBRMK_ORG_ID                 = TSRLBRMK.TSRLBRMK_ORG_ID            
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRRQCAF   SOMETIMES IS_QUALIFIED_BY                 TSRUOM' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSRRQCAF   TSRRQCAF
WHERE                 
      TSRRQCAF.TSRUOM_IS_NUMBER     IS NOT NULL 
      AND TSRRQCAF.TSRUOM_ORG_ID        IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRUOM   TSRUOM              
      WHERE TSRRQCAF.TSRUOM_IS_NUMBER                = TSRUOM.TSRUOM_IS_NUMBER          
      AND TSRRQCAF.TSRUOM_ORG_ID                   = TSRUOM.TSRUOM_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRRQCAF   ALWAYS    QUALIFIES   TSRRSULT' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRRQCAF   TSRRQCAF
WHERE                 
      TSRRQCAF.TSRRSULT_IS_NUMBER   IS NULL     
      OR TSRRQCAF.TSRRSULT_ORG_ID      IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRRSULT   TSRRSULT          
      WHERE TSRRQCAF.TSRRSULT_IS_NUMBER              = TSRRSULT.TSRRSULT_IS_NUMBER      
      AND TSRRQCAF.TSRRSULT_ORG_ID                 = TSRRSULT.TSRRSULT_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRRSULT   SOMETIMES DESCRIBES   TSRBRGI' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRRSULT   TSRRSULT
WHERE                 
      TSRRSULT.TSRBRGI_IS_NUMBER    IS NOT NULL 
      AND TSRRSULT.TSRBRGI_ORG_ID       IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRBRGI   TSRBRGI            
      WHERE TSRRSULT.TSRBRGI_IS_NUMBER               = TSRBRGI.TSRBRGI_IS_NUMBER        
      AND TSRRSULT.TSRBRGI_ORG_ID                  = TSRBRGI.TSRBRGI_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRRSULT   SOMETIMES IS_CONTAINED_IN                 TSRBRG' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSRRSULT   TSRRSULT
WHERE                 
      TSRRSULT.TSRBRG_IS_NUMBER     IS NOT NULL 
      AND TSRRSULT.TSRBRG_ORG_ID        IS NOT NULL   
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRBRG   TSRBRG              
      WHERE TSRRSULT.TSRBRG_IS_NUMBER                = TSRBRG.TSRBRG_IS_NUMBER          
      AND TSRRSULT.TSRBRG_ORG_ID                   = TSRBRG.TSRBRG_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRRSULT   SOMETIMES IS_CREATED_BY                   TSRANLPR' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRRSULT   TSRRSULT
WHERE                 
      TSRRSULT.TSRANLPR_IS_NUMBER   IS NOT NULL 
      AND TSRRSULT.TSRANLPR_ORG_ID      IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRANLPR   TSRANLPR          
      WHERE TSRRSULT.TSRANLPR_IS_NUMBER              = TSRANLPR.TSRANLPR_IS_NUMBER      
      AND TSRRSULT.TSRANLPR_ORG_ID                 = TSRANLPR.TSRANLPR_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRRSULT   SOMETIMES IS_DESCRIBED_BY                 TSRUOM' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSRRSULT   TSRRSULT
WHERE                 
      TSRRSULT.TSRUOM_IS_NUMBER     IS NOT NULL 
      AND TSRRSULT.TSRUOM_ORG_ID        IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRUOM   TSRUOM              
      WHERE TSRRSULT.TSRUOM_IS_NUMBER                = TSRUOM.TSRUOM_IS_NUMBER          
      AND TSRRSULT.TSRUOM_ORG_ID                   = TSRUOM.TSRUOM_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRRSULT   SOMETIMES IS_FOR      TSRFQS' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSRRSULT   TSRRSULT
WHERE                 
      TSRRSULT.TSRFQS_IS_NUMBER     IS NOT NULL 
      AND TSRRSULT.TSRFQS_ORG_ID        IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRFQS   TSRFQS              
      WHERE TSRRSULT.TSRFQS_IS_NUMBER                = TSRFQS.TSRFQS_IS_NUMBER          
      AND TSRRSULT.TSRFQS_ORG_ID                   = TSRFQS.TSRFQS_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRRSULT   SOMETIMES IS_FOR      TSRHCSC' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRRSULT   TSRRSULT
WHERE                 
      TSRRSULT.TSRHCSC_IS_NUMBER    IS NOT NULL 
      AND TSRRSULT.TSRHCSC_ORG_ID       IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRHCSC   TSRHCSC            
      WHERE TSRRSULT.TSRHCSC_IS_NUMBER               = TSRHCSC.TSRHCSC_IS_NUMBER        
      AND TSRRSULT.TSRHCSC_ORG_ID                  = TSRHCSC.TSRHCSC_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRRSULT   SOMETIMES IS_MADE_BY  TSRLSPP' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRRSULT   TSRRSULT
WHERE                 
      TSRRSULT.TSRLSPP_IS_NUMBER    IS NOT NULL 
      AND TSRRSULT.TSRLSPP_ORG_ID       IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRLSPP   TSRLSPP            
      WHERE TSRRSULT.TSRLSPP_IS_NUMBER               = TSRLSPP.TSRLSPP_IS_NUMBER        
      AND TSRRSULT.TSRLSPP_ORG_ID                  = TSRLSPP.TSRLSPP_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRRSULT   SOMETIMES IS_PRODUCED_IN                  TSRLAB' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSRRSULT   TSRRSULT
WHERE                 
      TSRRSULT.TSRLAB_IS_NUMBER     IS NOT NULL 
      AND TSRRSULT.TSRLAB_ORG_ID        IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRLAB   TSRLAB              
      WHERE TSRRSULT.TSRLAB_IS_NUMBER                = TSRLAB.TSRLAB_IS_NUMBER          
      AND TSRRSULT.TSRLAB_ORG_ID                   = TSRLAB.TSRLAB_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRRSULT   SOMETIMES IS_QUALIFIED_BY                 TSRCHAR' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRRSULT   TSRRSULT
WHERE                 
      TSRRSULT.TSRCHAR_IS_NUMBER    IS NOT NULL 
      AND TSRRSULT.TSRCHAR_ORG_ID       IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRCHAR   TSRCHAR            
      WHERE TSRRSULT.TSRCHAR_IS_NUMBER               = TSRCHAR.TSRCHAR_IS_NUMBER        
      AND TSRRSULT.TSRCHAR_ORG_ID                  = TSRCHAR.TSRCHAR_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRRSULT   SOMETIMES IS_SECONDARILY_QUALIFIED_BY     TSRCHAR' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRRSULT   TSRRSULT
WHERE                 
      TSRRSULT.TSRCHAR0IS_NUMBER    IS NOT NULL 
      AND TSRRSULT.TSRCHAR0ORG_ID       IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRCHAR   TSRCHAR            
      WHERE TSRRSULT.TSRCHAR0IS_NUMBER               = TSRCHAR.TSRCHAR_IS_NUMBER        
      AND TSRRSULT.TSRCHAR0ORG_ID                  = TSRCHAR.TSRCHAR_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRRSULT   SOMETIMES IS_YIELDED_FROM                 TSRFDACT' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRRSULT   TSRRSULT
WHERE                 
      TSRRSULT.TSRFDACT_IS_NUMBER   IS NOT NULL 
      AND TSRRSULT.TSRFDACT_ORG_ID      IS NOT NULL                 
      AND    NOT EXISTS                   
      (               
      SELECT 1        
      FROM   TSRFDACT   TSRFDACT          
      WHERE TSRRSULT.TSRFDACT_IS_NUMBER              = TSRFDACT.TSRFDACT_IS_NUMBER      
      AND TSRRSULT.TSRFDACT_ORG_ID                 = TSRFDACT.TSRFDACT_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRSDP     ALWAYS    IS_OWNED_BY TSMORGAN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRSDP   TSRSDP    
WHERE                 
      TSRSDP.TSMORGAN_IS_NUMBER   IS NULL       
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMORGAN   TSMORGAN          
      WHERE TSRSDP.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER        
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRSMPLE   ALWAYS    IS_PART_OF  TSRFDACT' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                   
   TSRSMPLE   TSRSMPLE
WHERE                 
      TSRSMPLE.TSRFDACT_IS_NUMBER   IS NULL     
      OR TSRSMPLE.TSRFDACT_ORG_ID      IS NULL           
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRFDACT   TSRFDACT          
      WHERE TSRSMPLE.TSRFDACT_IS_NUMBER              = TSRFDACT.TSRFDACT_IS_NUMBER      
      AND TSRSMPLE.TSRFDACT_ORG_ID                 = TSRFDACT.TSRFDACT_ORG_ID           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRSTVST   ALWAYS    IS_FOR      TSRTSA' AS "RELATIONSHIP"  from dual ;              
set feedback on
SELECT                
* 
FROM                  
   TSRSTVST   TSRSTVST
WHERE                 
      TSRSTVST.TSMSTATN_ORG_ID      IS NULL     
      OR TSRSTVST.TSMSTATN_IS_NUMBER   IS NULL  
      OR TSRSTVST.TSRTRIP_ORG_ID       IS NULL  
      OR TSRSTVST.TSRTRIP_IS_NUMBER    IS NULL  
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRTSA   TSRTSA              
      WHERE TSRSTVST.TSMSTATN_ORG_ID                 = TSRTSA.TSMSTATN_ORG_ID           
      AND TSRSTVST.TSMSTATN_IS_NUMBER              = TSRTSA.TSMSTATN_IS_NUMBER          
      AND TSRSTVST.TSRTRIP_ORG_ID                  = TSRTSA.TSRTRIP_ORG_ID              
      AND TSRSTVST.TSRTRIP_IS_NUMBER               = TSRTSA.TSRTRIP_IS_NUMBER           
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRTNOD    ALWAYS    PROVIDES_DETAIL_ABOUT           TSRSMPLE' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRTNOD   TSRTNOD  
WHERE                 
      TSRTNOD.TSRFDACT_ORG_ID      IS NULL      
      OR TSRTNOD.TSRFDACT_IS_NUMBER   IS NULL   
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRSMPLE   TSRSMPLE          
      WHERE TSRTNOD.TSRFDACT_ORG_ID                 = TSRSMPLE.TSRFDACT_ORG_ID          
      AND TSRTNOD.TSRFDACT_IS_NUMBER              = TSRSMPLE.TSRFDACT_IS_NUMBER         
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRTOD     ALWAYS    PROVIDES_DETAIL_ABOUT           TSRSMPLE' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRTOD   TSRTOD    
WHERE                 
      TSRTOD.TSRFDACT_ORG_ID      IS NULL       
      OR TSRTOD.TSRFDACT_IS_NUMBER   IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRSMPLE   TSRSMPLE          
      WHERE TSRTOD.TSRFDACT_ORG_ID                 = TSRSMPLE.TSRFDACT_ORG_ID           
      AND TSRTOD.TSRFDACT_IS_NUMBER              = TSRSMPLE.TSRFDACT_IS_NUMBER          
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRTPA     ALWAYS    IS_FOR      TSMPROJ' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRTPA   TSRTPA    
WHERE                 
      TSRTPA.TSMPROJ_IS_NUMBER    IS NULL       
      OR TSRTPA.TSMPROJ_ORG_ID       IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMPROJ   TSMPROJ            
      WHERE TSRTPA.TSMPROJ_IS_NUMBER               = TSMPROJ.TSMPROJ_IS_NUMBER          
      AND TSRTPA.TSMPROJ_ORG_ID                  = TSMPROJ.TSMPROJ_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRTPA     ALWAYS    IS_FOR      TSRTRIP' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRTPA   TSRTPA    
WHERE                 
      TSRTPA.TSRTRIP_IS_NUMBER    IS NULL       
      OR TSRTPA.TSRTRIP_ORG_ID       IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRTRIP   TSRTRIP            
      WHERE TSRTPA.TSRTRIP_IS_NUMBER               = TSRTRIP.TSRTRIP_IS_NUMBER          
      AND TSRTPA.TSRTRIP_ORG_ID                  = TSRTRIP.TSRTRIP_ORG_ID               
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRTRIP    ALWAYS    SPONSORED_BYTSMORGAN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRTRIP   TSRTRIP  
WHERE                 
      TSRTRIP.TSMORGAN_IS_NUMBER   IS NULL      
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMORGAN   TSMORGAN          
      WHERE TSRTRIP.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER       
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRTSA     ALWAYS    IS_FOR      TSMSTATN' AS "RELATIONSHIP"  from dual ;            
set feedback on
SELECT                
* 
FROM                  
   TSRTSA   TSRTSA    
WHERE                 
      TSRTSA.TSMSTATN_IS_NUMBER   IS NULL       
      OR TSRTSA.TSMSTATN_ORG_ID      IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSMSTATN   TSMSTATN          
      WHERE TSRTSA.TSMSTATN_IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER        
      AND TSRTSA.TSMSTATN_ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID             
      )               
;                 

set feedback off
select 'RICHECK relationship:'||chr(10)|| 'TSRTSA     ALWAYS    IS_FOR      TSRTRIP' AS "RELATIONSHIP"  from dual ;             
set feedback on
SELECT                
* 
FROM                  
   TSRTSA   TSRTSA    
WHERE                 
      TSRTSA.TSRTRIP_IS_NUMBER    IS NULL       
      OR TSRTSA.TSRTRIP_ORG_ID       IS NULL    
      OR    NOT EXISTS
      (               
      SELECT 1        
      FROM   TSRTRIP   TSRTRIP            
      WHERE TSRTSA.TSRTRIP_IS_NUMBER               = TSRTRIP.TSRTRIP_IS_NUMBER          
      AND TSRTSA.TSRTRIP_ORG_ID                  = TSRTRIP.TSRTRIP_ORG_ID               
      )               
; 
  
SPOOL OFF  
-- SQL Plus Environment Variables
set echo off
set verify on
set feedback on
set termout on
set time off
set timing off
set heading on
set linesize 100
set pagesize 24
set serveroutput off
set echo on
-- File: RICHECK.SQL
-- @C:\richeck.sql  -- RE-RUN Script (if applicable)
   
