QA收集计划

SELECT qpv.plan_id,
       qpv.NAME,
       qpc.char_name,
       qpc.prompt_sequence,
       qpc.char_type_meaning,
       qpc.prompt,
       qpc.mandatory_flag,
       qpCA.ACTION_DESCRIPTION,
       QPCA.MESSAGE
  FROM qa_plans_v      qpv,
       qa_plan_chars_v qpc,
       QA_PLAN_CHAR_ACTION_TRIGGERS_V qpct,
       QA_PLAN_CHAR_ACTIONS_V QPCA
 WHERE qpv.plan_id = qpc.plan_id
   and qpc.PLAN_ID = qpct.PLAN_ID(+)
   and qpc.char_id = qpct.CHAR_ID(+)
   and qpct.PLAN_CHAR_ACTION_TRIGGER_ID = qpca.PLAN_CHAR_ACTION_TRIGGER_ID(+)
   AND qpv.NAME = 'SA_IQC_LINE1_1'--计划名称
ORDER BY QPC.prompt_sequence