QA Collection Element Action Rules

Description

Application: Quality
Source: Collection Element Action Rules Report (XML)
Short Name: QLTCHACR_XML
DB package: QA_QLTCHACR_XMLP_PKG

QA Collection Element Action Rules and other Oracle EBS reports with Blitz Report™ on our demo environment

Copy

select        qcatv.char_name "Characteristic",
	ml.meaning "Enabled",
	qcatv.TRIGGER_SEQUENCE "Sequence",
	qcatv.char_name Chard,
	qcatv.operator "Operator_Num",
	lower(qcatv.operator_meaning) "Operator",
        	NVL(qcatv.low_value_meaning, decode(qc.datatype,
	   2, to_char(qltdate.canon_to_number(qcatv.low_value_other)),
        	   3, qltdate.any_to_user(qcatv.low_value_other),
	   6, qltdate.canon_to_user(qcatv.low_value_other),
        	   qcatv.low_value_other)) "Trigger Value",
        	NVL(qcatv.high_value_meaning, decode(qc.datatype,
	   2, to_char(qltdate.canon_to_number(qcatv.high_value_other)),
        	   3, qltdate.any_to_user(qcatv.high_value_other),
	   6, qltdate.canon_to_user(qcatv.high_value_other),
         	   qcatv.high_value_other)) "High Trigger",
	qa.description "Desc"
from	qa_chars qc,
	qa_actions qa,
	mfg_lookups ml,
	qa_char_actions qca,
	qa_char_action_triggers_v qcatv
where	qcatv.CHAR_ACTION_TRIGGER_ID = qca.CHAR_ACTION_TRIGGER_ID
and 	qcatv.char_id = qc.char_id
and 	qca.action_id = qa.action_id
and 	ml.lookup_type  = 'SYS_YES_NO'
and 	qc.enabled_flag = ml.lookup_code
&P_char_limiter 
&P_Enabled_limiter
--order by qca.char_action_id, qcatv.TRIGGER_SEQUENCE
order by 1,2,3,4