ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4720D51A9E05362FB09050512Y select qsv.spec_name "Characteristic Group", qsv.EFFECTIVE_FROM "Effective From", qsv.EFFECTIVE_TO "Effective To", qsv.ASSIGNMENT_TYPE "Assignment Type", qsv.ASSIGNMENT_TYPE_MEANING "Spec Type", null c_flexdata, qsv.ITEM_REVISION "Item Revision", qsv.ITEM_DESCRIPTION "Item Description", qsv.VENDOR_NUMBER "Supplier Number", qsv.VENDOR_NAME "Supplier Name", qsv.CUSTOMER_NUMBER "Customer Number", qsv.CUSTOMER_NAME "Customer Name", null c_category_flexdata, mc.DESCRIPTION "Category Description", qsv.category_set_name "Category Set", qsv.COMMON_SPEC_NAME "Common Spec Name", qscv.CHAR_NAME "Char Name", qscv.Datatype "DATATYPE", qscv.uom_code "UOM", decode(qscv.datatype, 3, qltdate.any_to_user(qscv.target_value), qscv.target_value) "Target Value", decode(qscv.datatype, 3, qltdate.any_to_user(qscv.upper_spec_limit), qscv.upper_spec_limit) "Upper Spec Limit" , decode(qscv.datatype, 3, qltdate.any_to_user(qscv.lower_spec_limit), qscv.lower_spec_limit) "Lower Spec Limit", decode(qscv.datatype, 3, qltdate.any_to_user(qscv.upper_reasonable_limit), qscv.upper_reasonable_limit) "Upper Reasonable Limit", decode(qscv.datatype, 3, qltdate.any_to_user(qscv.lower_reasonable_limit), qscv.lower_reasonable_limit) "Lower Reasonable Limit", decode(qscv.datatype, 3, qltdate.any_to_user(qscv.upper_user_defined_limit), qscv.upper_user_defined_limit) "Upper User Defined Limit", decode(qscv.datatype, 3, qltdate.any_to_user(qscv.lower_user_defined_limit), qscv.lower_user_defined_limit) "Lower User Defined Limit", qscv.DECIMAL_PRECISION, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_desc', 'INV', 'MSTK', 101, MSI2.ORGANIZATION_ID, MSI2.INVENTORY_ITEM_ID, 'ALL', 'Y', 'DESCRIPTION') C_Item_Desc, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_flex', 'INV', 'MSTK', 101, MSI2.ORGANIZATION_ID, MSI2.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_ITEM_FLEX, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_category_desc', 'INV', 'MSTK', 101, MSI2.ORGANIZATION_ID, MSI2.INVENTORY_ITEM_ID, 'ALL', 'Y', 'DESCRIPTION') C_CATEGORY_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_category_flex', 'INV', 'MSTK', 101, MSI2.ORGANIZATION_ID, MSI2.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_CATEGORY_FLEX, QA_QLTSPECR_XMLP_PKG.c_target_valueformula(qscv.Datatype, decode ( qscv.datatype , 3 , qltdate.any_to_user ( qscv.target_value ) , qscv.target_value )) C_target_value, QA_QLTSPECR_XMLP_PKG.c_upper_spec_numberformula(qscv.Datatype, decode ( qscv.datatype , 3 , qltdate.any_to_user ( qscv.upper_spec_limit ) , qscv.upper_spec_limit )) C_upper_spec_Number, QA_QLTSPECR_XMLP_PKG.c_lower_spec_numberformula(qscv.Datatype, decode ( qscv.datatype , 3 , qltdate.any_to_user ( qscv.lower_spec_limit ) , qscv.lower_spec_limit )) C_lower_spec_Number, QA_QLTSPECR_XMLP_PKG.c_upper_user_numberformula(qscv.Datatype, decode ( qscv.datatype , 3 , qltdate.any_to_user ( qscv.upper_user_defined_limit ) , qscv.upper_user_defined_limit )) C_Upper_User_Number, QA_QLTSPECR_XMLP_PKG.c_lower_user_numberformula(qscv.Datatype, decode ( qscv.datatype , 3 , qltdate.any_to_user ( qscv.lower_user_defined_limit ) , qscv.lower_user_defined_limit )) C_Lower_User_Number, QA_QLTSPECR_XMLP_PKG.c_upper_reason_numberformula(qscv.Datatype, decode ( qscv.datatype , 3 , qltdate.any_to_user ( qscv.upper_reasonable_limit ) , qscv.upper_reasonable_limit )) C_Upper_Reason_Number, QA_QLTSPECR_XMLP_PKG.c_lower_reason_numberformula(qscv.Datatype, decode ( qscv.datatype , 3 , qltdate.any_to_user ( qscv.lower_reasonable_limit ) , qscv.lower_reasonable_limit )) C_Lower_Reason_Number, qa_common_xmlp_pkg.get_precision(qscv.DECIMAL_PRECISION) qty_precision from mtl_categories mc, mtl_system_items msi2, qa_spec_chars_v qscv, qa_specs_v qsv where qscv.spec_id = qsv.common_spec_id and mc.category_id (+) = qsv.category_id and msi2.Inventory_Item_id (+) = qsv.item_id and msi2.Organization_id (+) = qsv.organization_id &P_Category_Set_limiter &P_Spec_Name_limiter and &P_Item_limiter &P_Spec_Type_limiter &P_Vendor_Number_limiter &P_Customer_Number_limiter &P_org_limiter and &P_Category_limiter ORDER BY 5 ASC,15 ASC,7 ASC,11 ASC,13 ASC,1 ASC,8 ASC,9 ASC,10 ASC,12 ASC,14 ASC,4 ASC,16 ASC,2 ASC, 3 ASC QA QLTSPECR_XML AR QA تقرير مواصفات الجودة Imported from BI Publisher Description: تقرير مواصفات الجودة Application: الجودة Source: تقرير مواصفات الجودة (XML) Short Name: QLTSPECR_XML DB package: QA_QLTSPECR_XMLP_PKG D QA Spezifikationen Imported from BI Publisher Description: Spezifikationen Application: Qualität Source: Spezifikationen (XML) Short Name: QLTSPECR_XML DB package: QA_QLTSPECR_XMLP_PKG E QA Especificaciones de Calidad Imported from BI Publisher Description: Informe de especificaciones de calidad Application: Quality Source: Especificaciones de Calidad (XML) Short Name: QLTSPECR_XML DB package: QA_QLTSPECR_XMLP_PKG F QA Etat Spécifications qualité Imported from BI Publisher Description: Etat Spécifications qualité Application: Quality Source: Etat Spécifications qualité (XML) Short Name: QLTSPECR_XML DB package: QA_QLTSPECR_XMLP_PKG I QA Rapporto Specifiche qualità Imported from BI Publisher Description: Rapporto Specifiche qualità Application: Quality Source: Rapporto Specifiche qualità (XML) Short Name: QLTSPECR_XML DB package: QA_QLTSPECR_XMLP_PKG JA QA 品質仕様レポート Imported from BI Publisher Description: 品質仕様レポート Application: Quality Source: 品質仕様レポート(XML) Short Name: QLTSPECR_XML DB package: QA_QLTSPECR_XMLP_PKG KO QA 품질 검사규격 보고서 Imported from BI Publisher Description: 품질 검사규격 보고서 Application: Quality Source: 품질 검사규격 보고서(XML) Short Name: QLTSPECR_XML DB package: QA_QLTSPECR_XMLP_PKG PTB QA Relatório de Especificações de Qualidade Imported from BI Publisher Description: Relatório Especificações de Qualidade Application: Qualidade Source: Relatório de Especificações de Qualidade (XML) Short Name: QLTSPECR_XML DB package: QA_QLTSPECR_XMLP_PKG RU QA Отчет о спецификациях качества Imported from BI Publisher Description: Отчет о спецификациях качества Application: Контроль качества Source: Отчет о спецификациях качества (XML) Short Name: QLTSPECR_XML DB package: QA_QLTSPECR_XMLP_PKG S QA Kvalitetsspecifikationer - rapport Imported from BI Publisher Description: Kvalitetsspecifikationer - rapport Application: Quality Source: Kvalitetsspecifikationer - rapport (XML) Short Name: QLTSPECR_XML DB package: QA_QLTSPECR_XMLP_PKG TR QA Kalite Spesifikasyonları Raporu Imported from BI Publisher Description: Kalite Spesifikasyonları Raporu Application: Kalite Yönetimi Source: Kalite Spesifikasyonları Raporu (XML) Short Name: QLTSPECR_XML DB package: QA_QLTSPECR_XMLP_PKG US QA Quality Specifications Imported from BI Publisher Description: Quality Specifications Report Application: Quality Source: Quality Specifications Report (XML) Short Name: QLTSPECR_XML DB package: QA_QLTSPECR_XMLP_PKG ZHS QA 质量规格报表 Imported from BI Publisher Description: 质量规格报表 Application: 质量管理系统 Source: 质量规格报表 (XML) Short Name: QLTSPECR_XML DB package: QA_QLTSPECR_XMLP_PKG BI Publisher &p_category_limiter &p_category_set_limiter &p_customer_number_limiter &p_item_limiter &p_org_limiter &p_spec_name_limiter &p_spec_type_limiter &p_vendor_number_limiter :p_category :p_category_flexdata :p_category_limiter :p_category_set :p_category_set_limiter :p_conc_request_id :p_customer_number :p_customer_number_limiter :p_flexdata :p_item :p_item_limiter :p_org_limiter :p_organization_id :p_qty_precision :p_spec_name :p_spec_name_limiter :p_spec_type :p_spec_type_limiter :p_spec_type_meaning :p_struct_num :p_vendor_number :p_vendor_number_limiter 1 -30 :p_junk LOV Oracle QA_SRS_CATEGORY_STRUCTURE Y select structure_id id, structure_id value, null description from mtl_category_sets where :$flex$.qa_srs_category_set=category_set_id order by value,description select min(structure_id) from mtl_category_sets where category_set_id = nvl(:$flex$.category_set,category_set_id) AR هيكل الفئة هيكل الفئة D Kategoriestruktur Kategoriestruktur E Estructura de Categoría Estructura de Categoría F Structure de catégorie Structure de catégorie I Struttura categoria Struttura categoria JA カテゴリ体系 カテゴリ体系 KO 범주 구조 범주 구조 PTB Estrutura da Categoria Estrutura da Categoria RU Структура категорий Структура категорий S Kategoristruktur Kategoristruktur TR Kategori Yapısı Kategori Yapısı US Category Structure Category Structure ZHS 类别结构 类别结构 2 -20 :p_organization_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR معرف التنظيم معرف التنظيم D Organisationskennung Organisationskennung E Id Organización Id Organización F ID organisation ID organisation I ID organizzazione ID organizzazione JA 組織ID 組織ID KO 조직 ID 조직 ID PTB Id da Organização Id da Organização RU Идент. организ. Идент. организ. S Organisations-id Organisations-id TR Organizasyon No Organizasyon No US Organization Id Organization Id ZHS 组织标识 组织标识 3 10 :p_spec_type LOV Oracle QA_SRS_SPEC_TYPE_CODE Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='QA_SPEC_TYPE' order by meaning AR نوع المواصفات نوع المواصفات D Spezifikationsart Spezifikationsart E Tipo de Especificación Tipo de Especificación F Type de spécification Type de spécification I Tipo di specifica Tipo di specifica JA 仕様タイプ 仕様タイプ KO 검사 규격 유형 검사 규격 유형 PTB Tipo de Especificação Tipo de Especificação RU Тип спецификации Тип спецификации S Specifikationstyp Specifikationstyp TR Spesifikasyon Tipi Spesifikasyon Tipi US Specification Type Specification Type ZHS 规格类型 规格类型 4 20 :p_spec_name LOV Oracle QA_SRS_SPECIFICATION_ID Y select spec_id id, spec_name value, null description from qa_specs order by spec_name AR اسم المواصفات اسم المواصفات D Spezifikation Spezifikation E Nombre de Especificación Nombre de Especificación F Nom spécification Nom spécification I Nome specifica Nome specifica JA 仕様名 仕様名 KO 검사 규격명 검사 규격명 PTB Nome da Especificação Nome da Especificação RU Имя спецификации Имя спецификации S Specifikationsnamn Specifikationsnamn TR Spesifikasyon Adı Spesifikasyon Adı US Specification Name Specification Name ZHS 规格名称 规格名称 5 30 :p_category_set LOV Oracle QA_SRS_CATEGORY_SET Y select category_set_id id, category_set_name value, description description from mtl_category_sets order by category_set_name AR مجموعة الفئات مجموعة الفئات D KategorieSet KategorieSet E Juego de Categorías Juego de Categorías F Jeu de catégories Jeu de catégories I Serie di categorie Serie di categorie JA カテゴリ・セット カテゴリ・セット KO 범주 세트 범주 세트 PTB Conj. Categorias Conj. Categorias RU Набор катег. Набор катег. S Kategoriuppsättning Kategoriuppsättning TR Kategori Kümesi Kategori Kümesi US Category Set Category Set ZHS 类别集 类别集 6 40 :p_category Char AR الفئة الفئة D Kategorie Kategorie E Categoría Categoría F Catégorie Catégorie I Categoria Categoria JA カテゴリ カテゴリ KO 범주 범주 PTB Categoria Categoria RU Категория Категория S Kategori Kategori TR Kategori Kategori US Category Category ZHS 类别 类别 7 50 :p_item Char AR الصنف الصنف D Artikel Artikel E Artículo Artículo F Article Article I Articolo Articolo JA 品目 品目 KO 품목 품목 RU Позиция Позиция S Artikel Artikel TR Kalem Kalem US Item Item ZHS 物料 物料 8 60 :p_customer_number LOV Oracle QA_SRS_CUSTOMER Y select customer_number id, customer_number value, customer_name description from qa_customers_lov_v order by customer_name AR العميل العميل D Kunde Kunde E Cliente Cliente F Client Client I Cliente Cliente JA 顧客 顧客 KO 고객 고객 PTB Cliente Cliente RU Заказчик Заказчик S Kund Kund TR Müşteri Müşteri US Customer Customer ZHS 客户 客户 9 70 :p_vendor_number LOV Oracle QA_SRS_SUPPLIER Y select segment1 id, segment1 value, vendor_name description from po_vendors order by segment1 AR المُورَّد المُورَّد D Lieferant Lieferant E Proveedor Proveedor F Fournisseur Fournisseur I Fornitore Fornitore JA 仕入先 仕入先 KO 공급자 공급자 PTB Fornecedor Fornecedor RU Поставщик Поставщик S Leverantör Leverantör TR Tedarikçi Tedarikçi US Supplier Supplier ZHS 供应商 供应商