QA Collection Element Action Rules
Description
Categories: BI Publisher
Application: Quality
Source: Collection Element Action Rules Report (XML)
Short Name: QLTCHACR_XML
DB package: QA_QLTCHACR_XMLP_PKG
Source: Collection Element Action Rules Report (XML)
Short Name: QLTCHACR_XML
DB package: QA_QLTCHACR_XMLP_PKG
Run
QA Collection Element Action Rules and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Collection Element Name |
|
LOV Oracle | |
Collection Element Enabled |
|
LOV Oracle |