QA: Senfor Intl - Quality Parent Child Relationships Extract

➜ Back to Library
Description
This report extracts Quality Collection Plan parent Child Relationships.

Parameters:
===========
Org: Select the specific inventory organization(s) to be extracted (optional).
Plan: Select the specific plan(s) required (optional).

/* +======================================================================================+
-- | Copyright 2025 Senfor International Yönet ...  This report extracts Quality Collection Plan parent Child Relationships.

Parameters:
===========
Org: Select the specific inventory organization(s) to be extracted (optional).
Plan: Select the specific plan(s) required (optional).

/* +======================================================================================+
-- | Copyright 2025 Senfor International Yönetim Danışmanlık Hizmetleri Ltd. Şti. |
-- | All rights reserved. |
-- | Original Author: Ion Yılmaz ([email protected]) |
-- +======================================================================================+
-- | This code is made available on an "As-Is" basis and may require modification |
-- | depending upon the configuration of the system it is being used on. |
-- | Permission to use this code is granted provided the original author is acknowledged.|
-- | No warranties, express or otherwise are included in this permission. |
-- +======================================================================================+
-- | Version Modified on Modified by Description |
-- | ======= =========== ============== =================================================|
-- | 1.0 04 Feb 2025 Ion Yılmaz Initial Release |
-- +======================================================================================+*/   more 
select 
(select qpcv2.plan_name from qa_plan_chars_v qpcv2 where qpcv2.plan_id=qppr.parent_plan_id and qper.parent_char_id=qpcv2.char_id and qpcv2.plan_name like '%' )
 Parent_Plan, 
(select qpcv3.plan_name from qa_plan_chars_v qpcv3 where qpcv3.plan_id=qppr.child_plan_id and qper.child_char_id=qpcv3.char_id)Child_Plan,
qppr.plan_relationship_id "Relation ID",
(select qpcv.char_name from qa_plan_chars_v qpcv where qpcv.plan_id=qppr.parent_plan_id and qper.parent_char_id=qpcv.char_id) Parent, 
(select qpcv1.char_name from qa_plan_chars_v qpcv1 where qpcv1.plan_id=qppr.child_plan_id and qper.child_char_id=qpcv1.char_id)Child
from 
QA_PC_PLAN_RELATIONSHIP qppr,
QA_PC_ELEMENT_RELATIONSHIP qper
where 
qppr.plan_relationship_id=qper.plan_relationship_id 
and qppr.plan_relationship_id > 99
order by 1,2,3
Download
Related Blitz Reports
QA Collection Plan Relationships QA Collection Plans QA Plan Relationship Upload QA Collection Plan Upload QA Sequence Element Audit QA Collection Plan Details QA Collection Plan Action Rules QA Collection Element Usages QA Collection Plan Actions
Blitz Report™