ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EFEF3869E053B46B63588994Y SELECT A.LANGUAGE, A.LANG_DESC, A.PROPERTY_ID, B.PROPERTY_TYPE_INDICATOR TYPE, B.LENGTH, B.PRECISION, A.PROPERTY_DESC, B.RANGE_MIN, B.RANGE_MAX, DECODE(C.VALUE, NULL, 'N', 'Y') DISPLAY, C.DISPLAY_ORDER, C.VALUE, C.MEANING FROM GR_PROPERTIES_TL_V A, GR_PROPERTIES_B B, GR_PROPERTY_VALUES_TL C where A.PROPERTY_ID = B.PROPERTY_ID and A.PROPERTY_ID = C.PROPERTY_ID (+) and (:P_PROPERTY_ID1 IS NULL OR A.PROPERTY_ID >= :P_PROPERTY_ID1) and (:P_PROPERTY_ID2 IS NULL OR A.PROPERTY_ID <= :P_PROPERTY_ID2) and A.LANGUAGE = C.LANGUAGE (+) and (:P_LANGUAGE1 IS NULL OR A.LANGUAGE >= :P_LANGUAGE1) and (:P_LANGUAGE2 IS NULL OR A.LANGUAGE <= :P_LANGUAGE2) and (:P_PROP_TYPE IS NULL OR B.PROPERTY_TYPE_INDICATOR = :P_PROP_TYPE) order by A.LANGUAGE, A.PROPERTY_ID, C.DISPLAY_ORDER GR GRRPT050_XML AR GR تقرير الخصائص (تنسيق XML) Application: إدارة نظم التصنيع التشغيلي Source: تقرير الخصائص (تنسيق XML) Short Name: GRRPT050_XML DB package: GR_GRRPT050_XMLP_PKG D GR Eigenschaften Application: Process Manufacturing Gefahrgutverwaltung Source: Eigenschaften (XML) Short Name: GRRPT050_XML DB package: GR_GRRPT050_XMLP_PKG F GR Etat des propriétés Application: Process Manufacturing Regulatory Management Source: Etat des propriétés (XML) Short Name: GRRPT050_XML DB package: GR_GRRPT050_XMLP_PKG US GR Properties Application: Process Manufacturing Regulatory Management Source: Properties Report (XML) Short Name: GRRPT050_XML DB package: GR_GRRPT050_XMLP_PKG ZHS GR 属性报表 Application: OPM 项目管制系统 Source: 属性报表 (XML) Short Name: GRRPT050_XML DB package: GR_GRRPT050_XMLP_PKG BI Publisher :p_language1 :p_language2 :p_prop_type :p_property_id1 :p_property_id2 1 10 :p_property_id1 LOV Oracle GR_PROP_ID Y select property_id id, property_id value, description description from gr_properties_tl where language=userenv('LANG') order by 1 Y AR من معرف الملكية D Von Eigenschaftskennung F ID propriété - De US From Property ID ZHS 起始特性标识 2 20 :p_property_id2 LOV Oracle GR_PROP_ID Y select property_id id, property_id value, description description from gr_properties_tl where language=userenv('LANG') order by 1 Y AR إلى معرف الملكية D Bis Eigenschaftskennung F ID propriété - A US To Property ID ZHS 终止特性标识 3 30 :p_prop_type LOV Oracle GR_PROP_TYP Y select lookup_code id, meaning value, null description from fnd_lookup_values where lookup_type='GR_PROP_TYPE' and language=userenv('LANG') order by value,description AR نوع الخاصية D Eigenschaftsart F Type de propriété US Property Type ZHS 特性类型 4 40 :p_language1 LOV Oracle FND_LANGUAGES Y select language_code id, language_code value, description description from fnd_languages_vl order by language_code Y AR من اللغة D Von Sprache F Langue - De US From Langage ZHS 起始语言 5 50 :p_language2 LOV Oracle FND_LANGUAGES Y select language_code id, language_code value, description description from fnd_languages_vl order by language_code Y AR إلى اللغة D Bis Sprache F Langue - A US To Language ZHS 终止语言