text: 
  /******************************************************************************** 
  	component-centric-snapshot-inferred-inactive-concepts
  	
  	Assertion:	
  	All inferred relationships in which the concept associated is inactive, are inactive relationships.
  
  ********************************************************************************/
  	
  	/* Inactive Source Id */
  	insert into qa_result (runid, assertionuuid, concept_id, details)
  	select 
  		<RUNID>,
  		'<ASSERTIONUUID>',
  		b.id,
  		concat('RELATIONSHIP: id=',a.id, ': Active inferred relationship is associated with an inactive sourceid concept.') 	
  	from curr_relationship_s a
  	inner join curr_concept_s b on a.sourceid = b.id
  	where a.active = '1'
  	and b.active = '0';
  
  
  	
  	/* Inactive Destination Id */
  	insert into qa_result (runid, assertionuuid, concept_id, details)
  	select 
  		<RUNID>,
  		'<ASSERTIONUUID>',
  		b.id,
  		concat('RELATIONSHIP: id=',a.id, ': Active inferred relationship is associated with an inactive destinationid concept.') 	
  	
  	from curr_relationship_s a
  	inner join curr_concept_s b on a.destinationid = b.id
  	where a.active = '1'
  	and b.active = '0';
  		
  	
  	
  	/* Inactive Destination Id */
  	insert into qa_result (runid, assertionuuid, concept_id, details)
  	select 
  		<RUNID>,
  		'<ASSERTIONUUID>',
  		b.id,
  		concat('RELATIONSHIP: id=',a.id, ': Active inferred relationship is associated with an inactive typeid concept.') 	
  	
  	from curr_relationship_s a
  	inner join curr_concept_s b on a.typeid = b.id
  	where a.active = '1'
  	and b.active = '0';
  
  	