ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F8051A9E05362FB09050512Y select null item_data, null cat_data, mc.description cat_desc, msi.description item_desc, msi.primary_uom_code, round(cic.material_cost * :P_EXCHANGE_RATE , :ext_precision_saved) material_cost, round(cic.material_overhead_cost * :P_EXCHANGE_RATE, :ext_precision_saved) mat_ovhd, round(cic.resource_cost * :P_EXCHANGE_RATE, :ext_precision_saved) resrc_cost, round(cic.outside_processing_cost * :P_EXCHANGE_RATE, :ext_precision_saved) out_proc, round(cic.overhead_cost * :P_EXCHANGE_RATE, :ext_precision_saved) ovhd_cost, round(cic.item_cost* :P_EXCHANGE_RATE , :ext_precision_saved) unit_cost, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexpad_item', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') C_FLEXPAD_ITEM, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexpad_cat', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'PADDED_VALUE') C_FLEXPAD_CAT, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield_cat', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD_CAT, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield_item', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD_ITEM, --BOM_CSTRELCR_XMLP_PKG.order_func(:C_FLEXPAD_ITEM, :C_FLEXPAD_CAT) C_ORDER, BOM_CSTRELCR_XMLP_PKG.order_func(fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexpad_item', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexpad_cat', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'PADDED_VALUE')) C_ORDER from mtl_system_items_vl msi, mtl_parameters mp, mtl_item_categories mic, mtl_categories mc, cst_item_costs cic where msi.organization_id = :org_id and mp.organization_id = :org_id and cic.cost_type_id = :cost_type_id and cic.inventory_item_id = msi.inventory_item_id and cic.organization_id = mp.cost_organization_id and mic.inventory_item_id = cic.inventory_item_id and mic.organization_id = :org_id and mic.category_id = mc.category_id and mic.category_set_id = :P_CATEGORY_SET and &P_WHERE_ITEM and &P_WHERE_CAT and &WHERE_ZERO group by &P_FLEXDATA_ITEM, &P_FLEXDATA_CAT, mic.category_id, msi.description, msi.primary_uom_code, cic.material_cost, cic.material_overhead_cost, cic.resource_cost, cic.outside_processing_cost, cic.overhead_cost, cic.item_cost, mc.description, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexpad_item', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexpad_cat', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'PADDED_VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield_cat', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield_item', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') order by C_ORDER, cat_desc, C_FLEXPAD_ITEM BOM CSTRELCRG_XML AR CST تقرير تكلفة العناصر (تنسيق XML) Imported from BI Publisher Description: تقرير تكلفة العناصر Application: شجرة المنتجات Source: تقرير تكلفة العناصر (تنسيق XML) Short Name: CSTRELCRG_XML DB package: BOM_CSTRELCR_XMLP_PKG D CST Kostenelemente - Artikel Imported from BI Publisher Description: Artikel - Kostenelemente Application: Produktionsdaten Source: Kostenelemente - Artikel (XML) Short Name: CSTRELCRG_XML DB package: BOM_CSTRELCR_XMLP_PKG E CST Costes por Elemento Imported from BI Publisher Description: Informe de costes por elemento Application: Bills of Material Source: Costes por Elemento (XML) Short Name: CSTRELCRG_XML DB package: BOM_CSTRELCR_XMLP_PKG F CST Etat des coûts élémentaires Imported from BI Publisher Description: Etat des coûts élémentaires Application: Bills of Material Source: Etat des coûts élémentaires (XML) Short Name: CSTRELCRG_XML DB package: BOM_CSTRELCR_XMLP_PKG I CST Rapporto Costi di base Imported from BI Publisher Description: Rapporto Costi di base Application: Bills of Material Source: Rapporto Costi di base (XML) Short Name: CSTRELCRG_XML DB package: BOM_CSTRELCR_XMLP_PKG JA CST 要素原価レポート Imported from BI Publisher Description: 要素原価レポート Application: Bills of Material Source: 要素原価レポート(XML) Short Name: CSTRELCRG_XML DB package: BOM_CSTRELCR_XMLP_PKG KO CST 요소별 원가 보고서 Imported from BI Publisher Description: 요소별 원가 보고서 Application: Bills of Material Source: 요소별 원가 보고서(XML) Short Name: CSTRELCRG_XML DB package: BOM_CSTRELCR_XMLP_PKG PTB CST Relatório de Custo Elementar Imported from BI Publisher Description: Relatório de Custo Elementar Application: Bills of Material Source: Relatório de Custo Elementar (XML) Short Name: CSTRELCRG_XML DB package: BOM_CSTRELCR_XMLP_PKG RU CST Отчет об элементах затрат Imported from BI Publisher Description: Отчет об элементах затрат Application: Спецификации Source: Отчет об элементах затрат (XML) Short Name: CSTRELCRG_XML DB package: BOM_CSTRELCR_XMLP_PKG S CST Elementkostnad - rapport Imported from BI Publisher Description: Elementkostnad - rapport Application: Bills of Material Source: Elementkostnad - rapport (XML) Short Name: CSTRELCRG_XML DB package: BOM_CSTRELCR_XMLP_PKG TR CST Unsur Bazında Maliyet Raporu Imported from BI Publisher Description: Unsur Bazında Maliyet Raporu Application: Ürün Ağacı Source: Unsur Bazında Maliyet Raporu (XML) Short Name: CSTRELCRG_XML DB package: BOM_CSTRELCR_XMLP_PKG US CST Elemental Cost Imported from BI Publisher Description: Elemental Cost Report Application: Bills of Material Source: Elemental Cost Report (XML) Short Name: CSTRELCRG_XML DB package: BOM_CSTRELCR_XMLP_PKG ZHS CST 基本成本报表 Imported from BI Publisher Description: 基本成本报表 Application: 物料清单管理系统 Source: 基本成本报表 (XML) Short Name: CSTRELCRG_XML DB package: BOM_CSTRELCR_XMLP_PKG BI Publisher &p_flexdata_cat &p_flexdata_item &p_where_cat &p_where_item &where_zero :cost_type_id :ext_precision_saved :org_id :p_category_set :p_conc_request_id :p_currency_code :p_exchange_rate :p_exchange_rate_char :p_flexdata_cat :p_flexdata_item :p_from_cat :p_from_item :p_struct_num :p_to_cat :p_to_item :p_trace_flag :p_view_cost :p_where_cat :p_where_item :pid_flex_num :report_sort_opt :where_zero :zero_cost_only 1 -80 :org_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 dell'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 组织标识 组织标识 2 -70 :p_qty_precision Number fnd_profile.value('REPORT_QUANTITY_PRECISION') AR دقة الكمية دقة الكمية D Nachkommastellen Nachkommastellen E Precisión de Cantidad Precisión de Cantidad F Précision des quantités Précision des quantités I Precisione quantità Precisione quantità JA 数量精度 数量精度 KO 수량 소수점 이하 자리수 수량 소수점 이하 자리수 PTB Precisão da Quantidade Precisão da Quantidade RU Точность количества Точность количества S Kvantitetsprecision Kvantitetsprecision TR Miktar Duyarlılığı Miktar Duyarlılığı US Quantity Precision Quantity Precision ZHS 数量精确度 数量精确度 3 -60 :p_bom_or_eng Char SELECT :PARAMETER.PROGRAM_APPL_SHORT_NAME FROM DUAL Y AR CST_SRS_BOM_OR_ENG BOM أو هندسي D CST_SRS_BOM_OR_ENG PD oder KON E CST_SRS_BOM_OR_ENG BOM o ENG F CST_SRS_BOM_OR_ENG BOM ou ENG I CST_SRS_BOM_OR_ENG BOM o ENG JA CST_SRS_BOM_OR_ENG BOMまたはENG KO CST_SRS_BOM_OR_ENG BOM 혹은 ENG PTB CST_SRS_BOM_OR_ENG BOM ou ENG RU CST_SRS_BOM_OR_ENG СП или ТПП S CST_SRS_BOM_OR_ENG BOM eller ENG TR CST_SRS_BOM_OR_ENG Ürün Ağacı veya Mühendislik US CST_SRS_BOM_OR_ENG BOM or ENG ZHS CST_SRS_BOM_OR_ENG BOM 或 ENG 4 -50 :p_struct_num Number select structure_id from mtl_category_sets where category_set_id = :$flex$.category_set 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 类别结构 类别结构 5 -40 :p_view_cost Number fnd_profile.value('CST_VIEW_COSTS') AR امتياز عرض التكاليف امتياز عرض التكاليف D Berechtigung für Kosten anzeigen Berechtigung für Kosten anzeigen E Privilegio de Consultar Costes Privilegio de Consultar Costes F Voir privilège coût Voir privilège coût I Visualizza privilegio costi Visualizza privilegio costi JA 原価権限の表示 原価権限の表示 KO 원가 특권 조회 원가 특권 조회 PTB Verificar Privilégio de Custo Verificar Privilégio de Custo RU Привилегия просмотра затрат Привилегия просмотра затрат S Behörighet att granska kostnader Behörighet att granska kostnader TR Maliyet Ayrıcalığını Görüntüle Maliyet Ayrıcalığını Görüntüle US View Cost Privilege View Cost Privilege ZHS 查看成本权限 查看成本权限 6 -30 :p_inverse_rate Char fnd_profile.value('DISPLAY_INVERSE_RATE') Y AR CST_SRS_INVERSE_RATE عرض السعر العكسي D CST_SRS_INVERSE_RATE Gegenkurs anzeigen E CST_SRS_INVERSE_RATE Visualizar Tipo de Cambio Inverso F CST_SRS_INVERSE_RATE Afficher taux inverse I CST_SRS_INVERSE_RATE Visualizza tasso inverso JA CST_SRS_INVERSE_RATE 逆数レートの表示 KO CST_SRS_INVERSE_RATE 역산율 표시 PTB CST_SRS_INVERSE_RATE Exibir Taxa de Inversão RU CST_SRS_INVERSE_RATE Вывод обратного курса S CST_SRS_INVERSE_RATE Visa inverterad kurs TR CST_SRS_INVERSE_RATE Ters Kuru Görüntüle US CST_SRS_INVERSE_RATE Display Inverse Rate ZHS CST_SRS_INVERSE_RATE 显示逆汇率 7 -20 :p_rate_type Number 2 Y AR CST_SRS_RATE_TYPE نوع سعر الصرف D CST_SRS_RATE_TYPE Wechselkursart E CST_SRS_RATE_TYPE Clase de Tipo de Cambio F CST_SRS_RATE_TYPE Type de taux de change I CST_SRS_RATE_TYPE Tipo di tasso di cambio JA CST_SRS_RATE_TYPE 換算レート・タイプ KO CST_SRS_RATE_TYPE 환율 유형 PTB CST_SRS_RATE_TYPE Tipo de Taxa de Câmbio RU CST_SRS_RATE_TYPE Тип обменного курса S CST_SRS_RATE_TYPE Växelkurstyp TR CST_SRS_RATE_TYPE Döviz Kuru Tipi US CST_SRS_RATE_TYPE Exchange Rate Type ZHS CST_SRS_RATE_TYPE 汇率类型 8 10 :report_sort_opt LOV Oracle CST_SRS_ITEMCAT_SORT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_ITEM_REPORT_SORT' and lookup_code in (1,2) order by value,description SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'CST_ITEM_REPORT_SORT' AND LOOKUP_CODE = 1 Y AR خيار فرز التقرير خيار فرز التقرير D Sortieren nach Sortieren nach E Opción de Clasificación del Informe Opción de Clasificación del Informe F Option tri état Option tri état I Opzione di ordinamento rapporto Opzione di ordinamento rapporto JA レポート・ソート・オプション レポート・ソート・オプション KO 보고서 정렬 옵션 보고서 정렬 옵션 PTB Opção de Classificação do Relatório Opção de Classificação do Relatório RU Параметр сортировки отчета Параметр сортировки отчета S Sorteringsalternativ för rapport Sorteringsalternativ för rapport TR Rapor Sıralama Seçeneği Rapor Sıralama Seçeneği US Report Sort Option Report Sort Option ZHS 报表排序选项 报表排序选项 9 20 :zero_cost_only LOV Oracle CST_SRS_LU_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description select meaning from MFG_LOOKUPS where lookup_type = 'SYS_YES_NO' and lookup_code = 2 Y AR تكلفة صفرية فقط تكلفة صفرية فقط D Nur Nullkosten Nur Nullkosten E Sólo Coste Cero Sólo Coste Cero F Coût zéro seulement Coût zéro seulement I Solo costi zero Solo costi zero JA ゼロ原価のみ ゼロ原価のみ KO 영(0) 원가만 영(0) 원가만 PTB Apenas Custo Zero Apenas Custo Zero RU Только бесплатные Только бесплатные S Endast nollkostnad Endast nollkostnad TR Salt Sıfır Maliyetli Salt Sıfır Maliyetli US Zero Cost Only Zero Cost Only ZHS 仅限于零成本 仅限于零成本 10 30 :cost_type_id LOV Oracle CST_SRS_COST_TYPE Y select cct.cost_type_id id, cct.cost_type value, cct.description description from cst_cost_types cct,mtl_parameters mp where nvl(cct.organization_id,fnd_profile.value('MFG_ORGANIZATION_ID'))= fnd_profile.value('MFG_ORGANIZATION_ID') and nvl(cct.disable_date,sysdate+1)>sysdate and ((:$flex$.cst_srs_bom_or_eng='BOM') or (:$flex$.cst_srs_bom_or_eng='ENG' and cct.available_to_eng_flag=1)) and mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and ((cct.cost_type_id=mp.primary_cost_method) or (cct.cost_type_id not in (1,2,5,6))) order by cost_type Y AR نوع التكلفة نوع التكلفة D Kostentyp Kostentyp E Tipo de Coste Tipo de Coste F Type de coût Type de coût I Tipo di costo Tipo di costo JA 原価タイプ 原価タイプ KO 원가 유형 원가 유형 PTB Tipo de Custo Tipo de custo RU Тип затрат Тип затрат S Kostnadstyp Kostnadstyp TR Maliyet Tipi Maliyet tipi US Cost Type Cost type ZHS 成本类型 成本类型 11 40 :p_from_item Char AR الصنف من الصنف من D Von Artikel Von Artikel E De Artículo De Artículo F Article - De Article - De I Articolo - Da Articolo - Da JA 品目:自 品目:自 KO 품목: 부터 품목: 부터 PTB Item - De Item - De RU Позиция с Позиция с S Från artikel Från artikel TR Kalem, İlk Kalem, İlk US Item From Item From ZHS 物料自 物料自 12 50 :p_to_item Char AR إلى الصنف إلى D Bis Bis Artikel E A A Artículo F A Article - A I A Articolo - A JA 至 品目:至 KO 까지 품목: 까지 PTB Até Item - Até RU По Позиция по S Till Till artikel TR Son Kalem, Son US To Item To ZHS 至 物料至 13 60 :p_category_set LOV Oracle CST_SRS_CATEGORY_SET Y select category_set_id id, category_set_name value, description description from mtl_category_sets where mult_item_cat_assign_flag='N' order by value,description select CATEGORY_SET_NAME from MTL_DEFAULT_CATEGORY_SETS D, MTL_CATEGORY_SETS S where D.FUNCTIONAL_AREA_ID=5 AND S.CATEGORY_SET_ID = D.CATEGORY_SET_ID Y AR مجموعة الفئات مجموعة الفئات D KategorieSet KategorieSet E Juego de Categorías Juego de Categorías F Jeu de catégories Jeu de catégories I Serie 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 类别集 类别集 14 70 :p_from_cat Char AR الفئة من الفئة من D Von Kategorie Von Kategorie E De Categoría De Categoría F Catégorie - De Catégorie - De I Categoria - Da Categoria - Da JA カテゴリ:自 カテゴリ:自 KO 범주 From 범주 From PTB Categoria - De Categoria - De RU Категория с Категория с S Från kategori Från kategori TR Kategori, İlk Kategori, İlk US Category From Category From ZHS 类别自 类别自 15 80 :p_to_cat Char AR إلى 2 الفئة إلى D Bis 2 Bis Kategorie E A 2 A Categoría F A 2 Catégorie - A I A 2 Categoria - A JA 至 2 カテゴリ:至 KO 까지 2 범주 To PTB Até 2 Categoria - Até RU По 2 Категория по S Till 2 Till kategori TR Son 2 Kategori, Son US To 2 Category To ZHS 至 2 类别至 16 90 :p_currency_code LOV Oracle CST_SRS_CURRENCY_CODE Y select currency_code id, currency_code value, description description from fnd_currencies_vl where trunc(nvl(start_date_active,sysdate-1))<sysdate and trunc(nvl(end_date_active,sysdate+1))>sysdate order by value,description SELECT CURRENCY_CODE FROM GL_SETS_OF_BOOKS SOB, ORG_ORGANIZATION_DEFINITIONS OOD WHERE OOD.ORGANIZATION_ID = fnd_profile.value('MFG_ORGANIZATION_ID') AND SOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID Y AR العملة العملة D Währung Währung E Divisa Divisa F Devise Devise I Divisa Divisa JA 通貨 通貨 KO 통화 통화 PTB Moeda Moeda RU Валюта Валюта S Valuta Valuta TR Para Birimi Para Birimi US Currency Currency ZHS 币种 币种 17 100 :p_exchange_rate_char LOV Oracle CST_SRS_EXCHANGE_RATE_C Y select actual_rate id, display_rate value, period description from cst_gl_translation_view where org_id=fnd_profile.value('MFG_ORGANIZATION_ID') and code=:$flex$.cst_srs_currency_code and inverse=:$flex$.cst_srs_inverse_rate and rate_type=:$flex$.cst_srs_rate_type order by period_year desc,period_num desc Y AR سعر الصرف سعر الصرف D Wechselkurs Wechselkurs E Tipo de Cambio Tipo de Cambio F Taux de change Taux de change I Tasso di cambio Tasso di cambio JA 換算レート 換算レート KO 환율 환율 PTB Taxa de Câmbio Taxa de Câmbio RU Обменный курс Обменный курс S Växelkurs Växelkurs TR Döviz Kuru Döviz Kuru US Exchange Rate Exchange Rate ZHS 汇率 汇率