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