View: QA_ERES_PC_RESULTS_REL_V

Product:	QA - Quality
Description:	parent child relationships for electronic records
Implementation/DBA Data:	APPS.QA_ERES_PC_RESULTS_REL_V

View Text

SELECT DISTINCT PC.PARENT_COLLECTION_ID
, PC.PARENT_OCCURRENCE
, PC.CHILD_PLAN_ID
, P1.NAME CHILD_PLAN_NAME
, REL.DATA_ENTRY_MODE
FROM QA_PC_RESULTS_RELATIONSHIP PC
, QA_PLANS P1
, QA_PC_PLAN_RELATIONSHIP REL
WHERE PC.ENABLED_FLAG=1
AND PC.CHILD_PLAN_ID=P1.PLAN_ID
AND PC.PARENT_PLAN_ID=REL.PARENT_PLAN_ID
AND PC.CHILD_PLAN_ID=REL.CHILD_PLAN_ID

Columns