ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4543869E053B46B63588994 select qcv.CHAR_TYPE_MEANING "Element Type", qcv.CHAR_TYPE_DESCRIPTION "Element Type Desc", qcv.NAME "Element Name", qcv.DATATYPE "Datatype Num", qcv.DATATYPE_MEANING "Datatype", qcv.DISPLAY_LENGTH "Reporting Length", qcv.DECIMAL_PRECISION "Decimal Precision", qcv.UOM_CODE "UOM", decode(qcv.datatype, 3, qltdate.any_to_user(qcv.default_value), 6, qltdate.canon_to_user (qcv.default_value), qcv.DEFAULT_VALUE) "Default Value", ml2.meaning "Enabled", ml.meaning "Pre-Defined", ml3.meaning "Mandatory", QA_QLTCHARR_XMLP_PKG.c_default_value_numformula(qcv.DATATYPE, decode ( qcv.datatype , 3 , qltdate.any_to_user ( qcv.default_value ) , 6 , qltdate.canon_to_user ( qcv.default_value ) , qcv.DEFAULT_VALUE )) C_Default_Value_Num from qa_chars_v qcv, mfg_lookups ml, mfg_lookups ml2, mfg_lookups ml3 where qcv.CHAR_CONTEXT_CHECKBOX = ml.LOOKUP_CODE and ml.LOOKUP_TYPE = 'SYS_YES_NO' and qcv.ENABLED_FLAG = ml2.LOOKUP_CODE and ml2.LOOKUP_TYPE = 'SYS_YES_NO' and qcv.MANDATORY_FLAG = ml3.LOOKUP_CODE and ml3.LOOKUP_TYPE = 'SYS_YES_NO' &P_Element_Type_Limiter &P_Element_Limiter &P_Enabled_Limiter Order By qcv.CHAR_TYPE_MEANING, qcv.NAME Y QA QLTCHARR_XML AR QA تقرير عناصر التجميع Application: الجودة Source: تقرير عناصر التجميع (XML) Short Name: QLTCHARR_XML DB package: QA_QLTCHARR_XMLP_PKG D QA Prüfelemente Application: Qualität Source: Prüfelemente (XML) Short Name: QLTCHARR_XML DB package: QA_QLTCHARR_XMLP_PKG F QA Etat Eléments qualité Application: Quality Source: Etat Eléments qualité (XML) Short Name: QLTCHARR_XML DB package: QA_QLTCHARR_XMLP_PKG US QA Collection Elements Application: Quality Source: Collection Elements Report (XML) Short Name: QLTCHARR_XML DB package: QA_QLTCHARR_XMLP_PKG ZHS QA 收集要素报表 Application: 质量管理系统 Source: 收集要素报表 (XML) Short Name: QLTCHARR_XML DB package: QA_QLTCHARR_XMLP_PKG BI Publisher &p_element_limiter &p_element_type_limiter &p_enabled_limiter :p_conc_request_id :p_element :p_element_limiter :p_element_type :p_element_type_limiter :p_element_type_meaning :p_enabled :p_enabled_limiter :p_enabled_meaning 1 10 :p_element_type LOV Oracle QA_SRS_ELEMENT_TYPE_CODE Y select lookup_code id, meaning value, null description from fnd_common_lookups where lookup_type='ELEMENT_TYPE' order by meaning AR نوع عنصر التجميع D Prüfelementart F Type d'élément qualité US Collection Element Type ZHS 收集要素类型 2 20 :p_element 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 Elément qualité US Collection Element ZHS 收集要素 3 30 :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éments qualité activés seulement US Enabled Collection Elements Only ZHS 仅限于已启用收集要素