ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 2D538F9BA4897C8EE06369FB0905E237 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 Y US QA: Senfor Intl - Quality Parent Child Relationships Extract 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 (iyilmaz@senfor-intl.com.tr) | -- +======================================================================================+ -- | 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 | -- +======================================================================================+*/