DBA Data[Home] [Help]

VIEW: APPS.QA_ERES_PC_RESULTS_REL_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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