Search Results qa_pc_plan_relationship




Overview
Explore in AI Chat

Overview

The QA_PC_PLAN_RELATIONSHIP table is a core data structure within the Oracle E-Business Suite (EBS) Quality module (QA). It functions as the central repository for defining hierarchical and logical relationships between quality collection plans. In Oracle EBS, a collection plan is a structured set of inspection elements and criteria used to gather and evaluate quality data. This table enables the construction of complex, multi-level inspection processes by linking a parent plan to one or more child plans, thereby supporting sophisticated quality workflows and mandatory inspection sequences in both versions 12.1.1 and 12.2.2.

Key Information Stored

The table's primary purpose is to store the linkage between plans, characterized by several key columns. The PARENT_PLAN_ID and CHILD_PLAN_ID are foreign keys referencing the QA_PLANS table, defining the two plans in the relationship. The RELATION_TYPE column specifies the nature of the association between the parent and child plan. A critical flag, indicated in the documentation, denotes whether the child plan is mandatory for the parent plan's execution. The table's primary key is PLAN_RELATIONSHIP_ID, a unique identifier for each relationship record.

Common Use Cases and Queries

A primary use case is tracing the hierarchy of inspection plans for auditing or process analysis. For instance, to find all mandatory child plans for a specific parent plan, a query would join QA_PC_PLAN_RELATIONSHIP to QA_PLANS twice—once for the parent details and once for the child details. This is essential for generating reports on inspection process flows. Another common scenario involves validating data integrity before executing a collection plan, ensuring all prerequisite mandatory child plans have been completed. Sample SQL often follows this pattern:

  • SELECT parent_plan.NAME AS parent_plan, child_plan.NAME AS child_plan, rel.relation_type FROM qa_pc_plan_relationship rel, qa_plans parent_plan, qa_plans child_plan WHERE rel.parent_plan_id = parent_plan.plan_id AND rel.child_plan_id = child_plan.plan_id AND parent_plan.plan_id = :p_plan_id;

Related Objects

As defined by its foreign key constraints, QA_PC_PLAN_RELATIONSHIP is integrally connected to several other Quality module tables. It directly references the QA_PLANS table twice for the parent and child plan identifiers. Furthermore, it is referenced as a parent table by QA_PC_CRITERIA and QA_PC_ELEMENT_RELATIONSHIP, indicating that specific inspection criteria and element-level relationships can be defined within the context of a broader plan-to-plan relationship. This structure allows quality rules and element dependencies to be scoped to particular hierarchical plan links.