ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4533869E053B46B63588994Y 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 QA QLTCHACR_XML AR QA تقرير قواعد إجراء عنصر التجميع Application: الجودة Source: تقرير قواعد إجراء عنصر التجميع (XML) Short Name: QLTCHACR_XML DB package: QA_QLTCHACR_XMLP_PKG D QA Prüfelemente - Vorgangsregeln Application: Qualität Source: Prüfelemente - Vorgangsregeln (XML) Short Name: QLTCHACR_XML DB package: QA_QLTCHACR_XMLP_PKG F QA Etat Règles d'action par élément qualité Application: Quality Source: Etat Règles d'action par élément qualité (XML) Short Name: QLTCHACR_XML DB package: QA_QLTCHACR_XMLP_PKG US QA Collection Element Action Rules Application: Quality Source: Collection Element Action Rules Report (XML) Short Name: QLTCHACR_XML DB package: QA_QLTCHACR_XMLP_PKG ZHS QA 收集要素活动规则报表 Application: 质量管理系统 Source: 收集要素活动规则报表 (XML) Short Name: QLTCHACR_XML DB package: QA_QLTCHACR_XMLP_PKG BI Publisher &p_char_limiter &p_enabled_limiter :p_char_limiter :p_char_name :p_conc_request_id :p_enabled :p_enabled_limiter :p_enabled_meaning 1 10 :p_char_name LOV Oracle QA_SRS_ELEMENT_ID Y select char_id id, name value, null description from qa_chars order by name AR اسم عنصر التجميع D Prüfelement F Nom de l'élément qualité US Collection Element Name ZHS 收集要素名称 2 20 :p_enabled LOV Oracle QA_SRS_YES_NO_ID Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by meaning SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'SYS_YES_NO' AND LOOKUP_CODE=1 AR عنصر تجميع فعال D Nur aktivierte Prüfelemente F Elément qualité activé US Collection Element Enabled ZHS 已启用收集要素