QA Collection Plan Action Rules Copy link

select        qp1.NAME "Plan Name",
	qp1.DESCRIPTION "Plan Description",
	qp1.EFFECTIVE_FROM "Effective From",
	qp1.EFFECTIVE_TO "Effective To",
	qc.name "Characteristic",
	ml2.MEANING "Enabled",
	qpcatv.TRIGGER_SEQUENCE "Sequence",
	qpcatv.char_name Chard,
	qpcatv.operator "Operator_Num",
	lower(qpcatv.operator_meaning) "Operator",
        	NVL(qpcatv.low_value_meaning, decode(qpcatv.datatype,
	   2, to_char(qltdate.canon_to_number(qpcatv.low_value_other)),
        	   3, qltdate.any_to_user(qpcatv.low_value_other),
	   6, qltdate.canon_to_user(qpcatv.low_value_other),
        	   qpcatv.low_value_other)) "Trigger Value",
        	NVL(qpcatv.high_value_meaning,decode(qpcatv.datatype,
	   2, to_char(qltdate.canon_to_number(qpcatv.high_value_other)),
        	   3, qltdate.any_to_user(qpcatv.high_value_other),
	   6, qltdate.canon_to_user(qpcatv.high_value_other),
         	   qpcatv.high_value_other)) "High Trigger",
	qa.description "Desc"
from	mfg_lookups ml2,
	qa_actions qa,
	qa_chars qc,
	qa_plan_chars qpc,
	&P_table qp1,
	qa_plan_char_actions qpca,
	qa_plan_char_action_triggers_v qpcatv
where	qpcatv.PLAN_CHAR_ACTION_TRIGGER_ID = qpca.PLAN_CHAR_ACTION_TRIGGER_ID
and 	qpcatv.plan_id = qp1.plan_id
and 	qpcatv.plan_id = qpc.plan_id
and 	qpcatv.char_id = qpc.char_id
and 	qpcatv.char_id = qc.char_id
and 	qpca.action_id = qa.action_id
and   	qpc.enabled_flag = ml2.lookup_code
and      	ml2.lookup_type  = 'SYS_YES_NO'
&P_plan_limiter
&P_Element_Limiter
&P_Element_Enabled_Limiter
&P_org_limiter
ORDER BY 1 ASC,2 ASC,3 ASC,4 ASC,5 ASC,6 ASC,7
  ASC,9 ASC,8 ASC,10 ASC,11 ASC,12 ASC , qpca.action_id ,
  qpcatv.TRIGGER_SEQUENCE