ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN AFA586A8A2BC5472E0530100007FF737 select msi.concatenated_segments item, msi.description item_description, mc.concatenated_segments category, xxen_util.meaning(msi.item_type,'ITEM_TYPE',3) user_item_type, msi.primary_uom_code uom, msi.inventory_item_status_code item_status, xxen_util.meaning(cict.inventory_asset_flag,'SYS_YES_NO',700) inventory_asset, xxen_util.meaning(msi.planning_make_buy_code,'MTL_PLANNING_MAKE_BUY',700) make_buy, decode(msi.inventory_planning_code,6, xxen_util.meaning(nvl(msi.mrp_planning_code,6),'MRP_PLANNING_CODE',700), xxen_util.meaning(nvl(msi.inventory_planning_code,6),'MTL_MATERIAL_PLANNING',700)) planning_method, decode(:p_item_revision, 1, ciqt.revision, null) revision, ciqt.subinventory_code subinventory, sec.description subinventory_desc, xxen_util.meaning(sec.asset_inventory,'SYS_YES_NO',700) asset_subinventory, decode(ciqt.subinventory_code,null,'Intransit','On-hand') type, ccg.cost_group, :p_as_of_date as_of_date, round(sum(nvl(ciqt.rollback_qty,0)),:p_qty_precision) qty, -- round( sum(nvl(ciqt.rollback_qty,0) * decode(nvl(sec.asset_inventory,1),1,nvl(cict.item_cost,0),0) * :p_exchange_rate) / xxen_util.zero_to_null(round(sum(nvl(ciqt.rollback_qty,0)),:p_qty_precision)) , :p_ext_precision) item_unit_cost, -- sum(ciqt.rollback_qty * nvl(cict.item_cost,0) * decode(sec.asset_inventory,2,0,1) * :p_exchange_rate) total_cost, sum(ciqt.rollback_qty * nvl(cict.material_cost,0) * decode(sec.asset_inventory,2,0,1) * :p_exchange_rate) material_cost, sum(ciqt.rollback_qty * nvl(cict.material_overhead_cost,0) * decode(sec.asset_inventory,2,0,1) * :p_exchange_rate) material_overhead_cost, sum(ciqt.rollback_qty * nvl(cict.resource_cost,0) * decode(sec.asset_inventory,2,0,1) * :p_exchange_rate) resource_cost, sum(ciqt.rollback_qty * nvl(cict.outside_processing_cost,0) * decode(sec.asset_inventory,2,0,1) * :p_exchange_rate) outside_processing_cost, sum(ciqt.rollback_qty * nvl(cict.overhead_cost,0) * decode(sec.asset_inventory,2,0,1) * :p_exchange_rate) overhead_cost, -- msi.concatenated_segments || ' - ' || msi.description item_label, ciqt.subinventory_code || ' - ' || sec.description subinventory_label, sysdate report_run_date from mtl_categories_b_kfv mc, mtl_system_items_vl msi, mtl_secondary_inventories sec, cst_inv_qty_temp ciqt, cst_inv_cost_temp cict, mtl_parameters mp, cst_item_costs cic, cst_cost_groups ccg where 1=1 and msi.organization_id = ciqt.organization_id and msi.inventory_item_id = ciqt.inventory_item_id and mp.organization_id = ciqt.organization_id and cict.organization_id = ciqt.organization_id and cict.inventory_item_id = ciqt.inventory_item_id and (cict.cost_group_id = ciqt.cost_group_id or mp.primary_cost_method = 1) and sec.organization_id(+) = ciqt.organization_id and sec.secondary_inventory_name(+) = ciqt.subinventory_code and mc.category_id = ciqt.category_id and cic.organization_id = ciqt.organization_id and cic.inventory_item_id = ciqt.inventory_item_id and cic.cost_type_id = cict.cost_type_id and ccg.cost_group_id (+) = nvl(ciqt.cost_group_id,cict.cost_group_id) group by xxen_util.meaning(msi.item_type,'ITEM_TYPE',3), msi.concatenated_segments, msi.description, mc.concatenated_segments, msi.primary_uom_code, msi.inventory_item_status_code, cict.inventory_asset_flag, msi.planning_make_buy_code, decode(msi.inventory_planning_code,6, xxen_util.meaning(nvl(msi.mrp_planning_code,6),'MRP_PLANNING_CODE',700), xxen_util.meaning(nvl(msi.inventory_planning_code,6),'MTL_MATERIAL_PLANNING',700)), decode(:p_item_revision, 1, ciqt.revision, null), ciqt.subinventory_code, decode(ciqt.subinventory_code,null,'Intransit','On-hand'), sec.description, sec.asset_inventory, ccg.cost_group, round(nvl(cict.item_cost,0) * :p_exchange_rate, :p_ext_precision), sysdate having 2=2 and decode(:p_neg_qty,1,1,2) = decode(:p_neg_qty,1,decode(sign(sum(ciqt.rollback_qty)),'-1',1,2),2) and decode(:p_zero_qty,2,round(sum(nvl(ciqt.rollback_qty,0)),:p_qty_precision),1) <> 0 order by ciqt.subinventory_code, msi.concatenated_segments, revision Y BOM CSTRINVR_XML AR CST Inventory Value Report - by Subinventory (Item Cost) Application: شجرة المنتجات Source: تقرير قيمة المخزون - حسب المخازن (تنسيق XML) Short Name: CSTRINVR_XML DB package: BOM_CSTRINVR_XMLP_PKG D CST Inventory Value Report - by Subinventory (Item Cost) Application: Produktionsdaten Source: Lagerbestandswert - nach Lager (XML) Short Name: CSTRINVR_XML DB package: BOM_CSTRINVR_XMLP_PKG E CST Inventory Value Report - by Subinventory (Item Cost) Application: Bills of Material Source: Valor de Inventario - por Subalmacén (XML) Short Name: CSTRINVR_XML DB package: BOM_CSTRINVR_XMLP_PKG F CST Inventory Value Report - by Subinventory (Item Cost) Application: Bills of Material Source: Etat des valeurs de stock - par magasin (XML) Short Name: CSTRINVR_XML DB package: BOM_CSTRINVR_XMLP_PKG I CST Inventory Value Report - by Subinventory (Item Cost) Application: Bills of Material Source: Rapporto Valore scorte - per sottomagazzino (XML) Short Name: CSTRINVR_XML DB package: BOM_CSTRINVR_XMLP_PKG JA CST Inventory Value Report - by Subinventory (Item Cost) Application: Bills of Material Source: 在庫価額レポート - 保管場所別(XML) Short Name: CSTRINVR_XML DB package: BOM_CSTRINVR_XMLP_PKG KO CST Inventory Value Report - by Subinventory (Item Cost) Application: Bills of Material Source: 재고 금액 보고서 - 창고별(XML) Short Name: CSTRINVR_XML DB package: BOM_CSTRINVR_XMLP_PKG PTB CST Inventory Value Report - by Subinventory (Item Cost) Application: Bills of Material Source: Relatório de Valor do Inventário - por Subinventário (XML) Short Name: CSTRINVR_XML DB package: BOM_CSTRINVR_XMLP_PKG RU CST Inventory Value Report - by Subinventory (Item Cost) Application: Спецификации Source: Отчет о стоимости запасов - по складскому подразделению (XML) Short Name: CSTRINVR_XML DB package: BOM_CSTRINVR_XMLP_PKG S CST Inventory Value Report - by Subinventory (Item Cost) Application: Bills of Material Source: Rapport över lagervärde - per lagerställe (XML) Short Name: CSTRINVR_XML DB package: BOM_CSTRINVR_XMLP_PKG TR CST Inventory Value Report - by Subinventory (Item Cost) Application: Ürün Ağacı Source: Envanter Değeri Raporu - Stok Yerine Göre (XML) Short Name: CSTRINVR_XML DB package: BOM_CSTRINVR_XMLP_PKG US CST Inventory Value Report - by Subinventory (Item Cost) Imported Oracle standard inventory value subinventory report by item cost Source: Inventory Value Report - by Subinventory (XML) Short Name: CSTRINVR_XML DB package: BOM_CSTRINVR_XMLP_PKG ZHS CST Inventory Value Report - by Subinventory (Item Cost) Application: 物料清单管理系统 Source: 库存值报表 - 按子库存列出 (XML) Short Name: CSTRINVR_XML DB package: BOM_CSTRINVR_XMLP_PKG Enginatics R12 only 1=1 2=2 :ext_precision :p_as_of_date :p_as_of_date1 :p_cat_from :p_cat_num :p_cat_seg :p_cat_set_name :p_cat_to :p_cat_where :p_category_set :p_conc_request_id :p_cost_org_id :p_cost_type :p_cost_type_id :p_currency_code :p_currency_dsp :p_def_cost_type :p_detail_level :p_exchange_rate :p_exchange_rate_char :p_exp_item :p_exp_sub :p_ext_prec :p_ext_precision :p_gl_num :p_item_from :p_item_revision :p_item_seg :p_item_to :p_item_where :p_neg_qty :p_org_id :p_organization :p_precision :p_qty_precision :p_qty_where :p_report_name :p_rpt_option :p_sessionid :p_sort_by :p_sort_option :p_sub_inv_mmt :p_sub_inv_moh :p_sub_inv_sec :p_subinv_from :p_subinv_to :p_subinv_where :p_title :p_trace :p_uncosted_txn :p_view_cost :p_zero_cost :p_zero_qty :qty_precision :round_unit 1 -100 :p_rpt_option LOV Oracle CST_SRS_RPT_DETAIL_OPTION Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_RPT_DETAIL_OPTION' order by meaning 1 Y AR خيار التقرير خيار التقرير D Auswertungsoption Auswertungsoption E Opción de Informe Opción de Informe F Option de rapport Option d'édition I Opzione rapporto Opzione rapporto JA レポート・オプション レポート・オプション KO 보고서 옵션 보고서 옵션 PTB Opção de Relatório Opção de Relatório RU Параметр отчета Параметр отчета S Rapportalternativ Rapportalternativ TR Rapor Seçeneği Rapor Seçeneği US Report Option Report Option ZHS 报表选项 报表选项 2 -90 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') AR معرف التنظيم معرف التنظيم D Organisationskennung Organisationskennung E Id Organización Id Organización F Identité de l'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 ZHS 组织标识 组织标识 3 -80 :p_gl_num Number fnd_profile.value('MFG_CHART_OF_ACCOUNTS_ID') AR معرف جدول تصنيف الحسابات معرف جدول تصنيف الحسابات D Kontenplankennung Kontenplankennung E Id Plan de Cuentas Id Plan de Cuentas F Plan comptable Id ID plan de comptes I Id piano dei conti Id del piano dei conti JA 勘定体系ID 勘定体系ID KO 계정 코드집 ID 계정 코드집 ID PTB Id do Plano de Contas Id do Plano de Contas RU Идентификатор плана счетов Идентификатор плана счетов S Kontoplans-id Kontoplans-id TR Hesap Planı No Hesap Planı No US Chart of Accounts Id ZHS 科目表标识 科目表标识 4 -70 :p_cat_num Number select mcs.structure_id from mtl_category_sets mcs where mcs.category_set_id=:$flex$.category_set AR هيكل الفئة هيكل الفئة D Kategoriestruktur Kategoriestruktur E Estructura de Categoría Estructura de Categoría F Structure de la 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 ZHS 类别结构 类别结构 5 -60 :p_inverse_rate Char fnd_profile.value('DISPLAY_INVERSE_RATE') US CST_SRS_INVERSE_RATE 6 -50 :p_rate_type Number 2 US CST_SRS_RATE_TYPE 7 -40 :p_qty_precision Number fnd_profile.value('REPORT_QUANTITY_PRECISION') AR دقة الكمية دقة الكمية D Nachkommastellen Nachkommastellen E Precisión de Cantidad Precisión de Cantidad F Quantité Précision 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 ZHS 数量精确度 数量精确度 8 -30 :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 le privilège des coûts 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 ZHS 查看成本权限 查看成本权限 9 20 :p_cost_type_id LOV Oracle CST_SRS_INV_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 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 select mp.primary_cost_method from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and mp.primary_cost_method not in (2,5,6) 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 成本类型 成本类型 10 50 :p_as_of_date DateTime sysdate Y AR اعتبارًا من تاريخ اعتبارًا من تاريخ D Vom Vom E A Fecha A fecha F En date du En date du I In data In data JA 現在日 現在日 KO 기준 일자 기준 일자 PTB Data de Referência Data de Referência RU На дату На дату S Per datum Per datum TR Başlangıç Tarihi Başlangıç Tarihi US As of Date As of Date ZHS 截止日期 截止日期 11 60 :p_item_from 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 70 :p_item_to Char :$flex$.item_from AR الصنف إلى الصنف إلى D Bis Artikel Bis Artikel E A Artículo A Artículo F Objet à Article - A I Articolo - A Articolo - A JA 品目:至 品目:至 KO 품목: 까지 품목: 까지 PTB Item - Até Item - até RU Позиция по Позиция по S Till artikel Till artikel TR Kalem, Son Kalem: Son US Item To Item to ZHS 物料至 物料至 13 80 :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 mdcs.category_set_id from mtl_default_category_sets mdcs where mdcs.functional_area_id=5 Y AR مجموعة الفئات مجموعة الفئات D KategorieSet KategorieSet E Juego de Categorías Juego de categorías F Ensemble de la catégorie Jeu de catégories I Serie categorie Serie di categorie JA カテゴリ・セット カテゴリ・セット KO 범주 세트 범주 세트 PTB Conj. Categorias Conjunto de categorias RU Набор категорий Набор категорий S Kategoriuppsättning Kategoriserie TR Kategori Kümesi Kategori kümesi US Category Set Category set ZHS 类别集 类别集 14 90 :p_cat_from 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 100 :p_cat_to Char :$flex$.category_from AR الفئة إلى الفئة إلى D Bis Kategorie Bis Kategorie E A Categoría A Categoría F Catégorie à Catégorie - A I Categoria - A Categoria - A JA カテゴリ:至 カテゴリ:至 KO 범주 To 범주 To PTB Categoria - Até Categoria - Até RU Категория по Категория по S Till kategori Till kategori TR Kategori, Son Kategori, Son US Category To Category To ZHS 类别至 类别至 16 110 :p_subinv_from LOV Oracle CST_SRS_SUBINVENTORY Y select secondary_inventory_name id, secondary_inventory_name value, description description from mtl_secondary_inventories where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by secondary_inventory_name AR مخزن من مخزن من D Von Lager Von Lager E De Subalmacén De Subalmacén F Sous-inventaire De Magasin - De I Sottomagazzino - Da Sottomagazzino - Da JA 保管場所:自 保管場所:自 KO 창고: 부터 창고: 부터 PTB Subinventário - De Subinventário - De RU Складское подразделение с Складское подразделение с S Från lagerställe Från lagerställe TR Stok Yeri: İlk Stok Yeri: İlk US Subinventory From Subinventory From ZHS 子库存自 子库存自 17 120 :p_subinv_to LOV Oracle CST_SRS_SUBINVENTORY Y select secondary_inventory_name id, secondary_inventory_name value, description description from mtl_secondary_inventories where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by secondary_inventory_name :$flex$.subinventory_from AR مخزن إلى مخزن إلى D Bis Lager Bis Lager E A Subalmacén A Subalmacén F Magasin - A Magasin - A I Sottomagazzino - A Sottomagazzino - A JA 保管場所:至 保管場所:至 KO 창고: 까지 창고: 까지 PTB Subinventário - Até Subinventário - Até RU Складское подразделение по Складское подразделение по S Till lagerställe Till lagerställe TR Stok Yeri: Son Stok Yeri: Son US Subinventory To Subinventory To ZHS 子库存至 子库存至 18 130 :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 Monnaie Devise I Divisa Divisa JA 通貨 通貨 KO 통화 통화 PTB Moeda Moeda RU Валюта Валюта S Valuta Valuta TR Para Birimi Para Birimi US Currency Currency ZHS 币种 币种 19 140 :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 汇率 汇率 20 150 :p_item_revision LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description 2 Y AR الكميات بواسطة المراجعة الكميات بواسطة المراجعة D Mengen nach Version Mengen nach Version E Cantidades por Revisión Cantidades por Revisión F Quantités par révision Quantités par version I Quantità per revisione Quantità per revisione JA 改訂別数量 改訂別数量 KO 개정별 수량 개정별 수량 PTB Quantidades por Revisão Quantidades por Revisão RU Количества по версиям Количества по версиям S Kvantiteter per revision Kvantiteter per revision TR Revizyon Bazında Miktarlar Revizyon Bazında Miktarlar US Quantities By Revision Quantities by Revision ZHS 按版本显示数量 按版本列出的数量 21 160 :p_neg_qty LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description 2 Y AR الكميات السالبة فقط الكميات السالبة فقط D Nur negative Mengen Nur negative Mengen E Sólo Cantidades Negativas Sólo Cantidades Negativas F Quantités négatives uniquement Quantités négatives seulement I Solo quantità negative Solo quantità negative JA マイナスの数量のみ マイナスの数量のみ KO 음의 수량만 음의 수량만 PTB Apenas Quantidades Negativas Apenas Quantidades Negativas RU Только отрицательные количества Только отрицательные количества S Endast negativa kvantiteter Endast negativa kvantiteter TR Sadece Negatif Miktarlar Sadece Negatif Miktarlar US Negative Quantities only Negative Quantities Only ZHS 仅限于负数量 仅限于负数量 22 170 :p_zero_cost LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description 2 Y AR عرض التكاليف الصفرية فقط عرض التكلفة الصفرية فقط D Nur Nullkosten anzeigen Nur Nullkosten anzeigen E Mostrar Sólo Costes Cero Mostrar Sólo Costes Cero F Afficher uniquement les coûts zéro Afficher coût zéro seulement I Visualizza solo costi zero Visualizza solo costi zero JA ゼロ原価のみ表示 ゼロ原価のみ表示 KO 0 원가만 표시 0 원가만 표시 PTB Exibir Apenas Custos Zero Exibir apenas custo zero RU Вывод только бесплатных позиций Вывод только бесплатных позиций S Visa endast nollkostnader Visa endast nollkostnad TR Sadece Sıfır Maliyetleri Görüntüle Sadece sıfır maliyeti görüntüler US Display Zero Costs only Display zero cost only ZHS 仅显示零成本 仅显示零成本 23 180 :p_exp_item LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description 2 Y AR تضمين بنود المصروفات تضمين بنود المصروفات D Mit Aufwandsartikeln Mit Aufwandsartikeln E Incluir Conceptos de Gasto Incluir Artículos de Gasto F Inclure les postes de dépenses Inclure les articles passés en charges I Includi articoli di spesa Includi articoli di spesa JA 費用品目を含む 費用品目を含む KO 비용 품목 포함 비용 품목 포함 PTB Incluir Itens de Despesa Incluir itens de despesas RU Включить статьи расхода Включить статьи расхода S Inkludera utgiftsposter Inkludera utgiftsposter TR Gider Kalemlerini Dahil Et Gider kalemlerini dahil eder US Include Expense Items Include expense items ZHS 包括低值易耗品 包括低值易耗品 24 190 :p_exp_sub LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description 2 Y AR تضمين مصروفات المخازن تضمين مصروفات المخازن D Mit Aufwandslägern Mit Aufwandslägern E Incluir Subalmacenes de Gasto Incluir Subalmacenes Gasto F Inclure les dépenses des sous-inventaires Inclure les magasins passés en charge I Includi sottomagazzini di spesa Include i sottomagazzini di spesa JA 費用保管場所を含む 費用保管場所を含む KO 비용 창고 포함 비용 창고를 포함합니다. PTB Incluir Subinventários de Despesas Incluir subinventários de despesa RU Включить складские подразделения расхода Включение складских подразделений расхода S Inkludera kostnadsförda lagerställen Inkludera kostnadsförda lagerställen TR Gider Stok Yerlerini Dahil Et Gider stok yerlerini dahil eder US Include Expense Subinventories Include expense subinventories ZHS 包括费用子库存 包括费用子库存 25 200 :p_zero_qty LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description 2 Y AR تضمين الكميات الصفرية عرض الكميات الصفرية D Mit Nullmengen Mit Nullmengen E Incluir Cantidades Cero Mostrar Cantidades Cero F Inclure les quantités nulles Afficher les quantités zéro I Includi quantità zero Visualizza quantità zero JA ゼロ数量を含む ゼロ数量のみ表示 KO 영(0) 수량 포함 0 수량 표시 PTB Incluir Quantidades Zero Exibir Quantidades Zero RU Включить нулевые количества Вывод нулевых количеств S Inkludera nollkvantiteter Visa nollkvantiteter TR Sıfır Miktarları Dahil Et Sıfır miktarları görüntüler US Include Zero Quantities Display zero quantities ZHS 包括零数量 显示零数量 26 210 :p_uncosted_txn LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description 2 Y AR تضمين حركات بدون قيم تضمين حركات بدون قيم D Mit nicht bewerteten Transaktionen Mit nicht bewerteten Transaktionen E Incluir Transacciones No Valoradas Incluir Transacciones No Valoradas F Inclure les transactions non évaluées Inclure mouvements non valorisés I Includi transazioni non valorizzate Include le transazioni non valorizzate JA 未評価取引を含む 未評価取引を含む KO 미평가 트랜잭션 포함 미평가 트랜잭션 포함 PTB Incluir Transações Sem Valor Incluir Transações Sem Valor RU Включить неоцененные транзакции Включить неоцененные транзакции S Inkludera icke-värderade transaktioner Inkludera icke-värderade transaktioner TR Değer İçermeyen İşlemleri Dahil Et Değer İçermeyen İşlemleri Dahil Et US Include Unvalued Transactions Include Unvalued Transactions ZHS 包括未估计值的事务处理 包括未估计值的事务处理 :$flex$.category_from Category From Category To :$flex$.category_set Category Set Category Structure :$flex$.cst_srs_currency_code Currency Exchange Rate :$flex$.cst_srs_inverse_rate CST_SRS_INVERSE_RATE Exchange Rate :$flex$.cst_srs_rate_type CST_SRS_RATE_TYPE Exchange Rate :$flex$.item_from Item From Item To :$flex$.subinventory_from Subinventory From Subinventory To B72663A47A015D789D05A0D6005F31BF Pivot - Category, Item, Subinventory SYSADMIN 13 ASSET_SUBINVENTORY 15 AS_OF_DATE 3 CATEGORY 1 7 INVENTORY_ASSET 1 ITEM 2 2 ITEM_DESCRIPTION 24 ITEM_LABEL 6 ITEM_STATUS 17 ITEM_UNIT_COST 8 MAKE_BUY 19 MATERIAL_COST 20 MATERIAL_OVERHEAD_COST 22 OUTSIDE_PROCESSING_COST 23 OVERHEAD_COST 9 PLANNING_METHOD 16 QTY 26 REPORT_RUN_DATE 21 RESOURCE_COST 10 REVISION 11 SUBINVENTORY 3 12 SUBINVENTORY_DESC 25 SUBINVENTORY_LABEL 18 TOTAL_COST 14 TYPE 5 UOM 4 USER_ITEM_TYPE ASSET_SUBINVENTORY FILTER 1 AS_OF_DATE ROW 1 CATEGORY ROW 2 INVENTORY_ASSET FILTER 4 ITEM_LABEL ROW 4 ITEM_STATUS FILTER 6 ITEM_UNIT_COST VALUE 2 AVG MAKE_BUY FILTER 2 MATERIAL_COST VALUE 4 SUM MATERIAL_OVERHEAD_COST VALUE 5 SUM OUTSIDE_PROCESSING_COST VALUE 7 SUM OVERHEAD_COST VALUE 8 SUM PLANNING_METHOD FILTER 3 QTY VALUE 1 SUM RESOURCE_COST VALUE 6 SUM SUBINVENTORY_LABEL ROW 3 TOTAL_COST VALUE 3 SUM USER_ITEM_TYPE FILTER 5 S Site 317971645884C9FB71DFFE66C3C2C2CF Pivot - Item, Subinventory SYSADMIN 13 ASSET_SUBINVENTORY 15 AS_OF_DATE 3 CATEGORY 7 INVENTORY_ASSET 1 ITEM 1 2 ITEM_DESCRIPTION 24 ITEM_LABEL 6 ITEM_STATUS 17 ITEM_UNIT_COST 8 MAKE_BUY 19 MATERIAL_COST 20 MATERIAL_OVERHEAD_COST 22 OUTSIDE_PROCESSING_COST 23 OVERHEAD_COST 9 PLANNING_METHOD 16 QTY 26 REPORT_RUN_DATE 21 RESOURCE_COST 10 REVISION 11 SUBINVENTORY 2 12 SUBINVENTORY_DESC 25 SUBINVENTORY_LABEL 18 TOTAL_COST 14 TYPE 5 UOM 4 USER_ITEM_TYPE ASSET_SUBINVENTORY FILTER 1 AS_OF_DATE ROW 1 CATEGORY FILTER 7 INVENTORY_ASSET FILTER 4 ITEM_LABEL ROW 2 ITEM_STATUS FILTER 6 ITEM_UNIT_COST VALUE 2 AVG MAKE_BUY FILTER 2 MATERIAL_COST VALUE 4 SUM MATERIAL_OVERHEAD_COST VALUE 5 SUM OUTSIDE_PROCESSING_COST VALUE 7 SUM OVERHEAD_COST VALUE 8 SUM PLANNING_METHOD FILTER 3 QTY VALUE 1 SUM RESOURCE_COST VALUE 6 SUM SUBINVENTORY_LABEL ROW 3 TOTAL_COST VALUE 3 SUM USER_ITEM_TYPE FILTER 5 S Site CEDDCA4491D6F4006D7D013D11A31B17 Pivot - Subinventory, Item SYSADMIN 13 ASSET_SUBINVENTORY 16 AS_OF_DATE 3 CATEGORY 15 COST_GROUP 7 INVENTORY_ASSET 1 ITEM 2 2 ITEM_DESCRIPTION 25 ITEM_LABEL 6 ITEM_STATUS 18 ITEM_UNIT_COST 8 MAKE_BUY 20 MATERIAL_COST 21 MATERIAL_OVERHEAD_COST 23 OUTSIDE_PROCESSING_COST 24 OVERHEAD_COST 9 PLANNING_METHOD 17 QTY 27 REPORT_RUN_DATE 22 RESOURCE_COST 10 REVISION 11 SUBINVENTORY 1 12 SUBINVENTORY_DESC 26 SUBINVENTORY_LABEL 19 TOTAL_COST 14 TYPE 5 UOM 4 USER_ITEM_TYPE ASSET_SUBINVENTORY FILTER 1 AS_OF_DATE ROW 1 CATEGORY FILTER 7 INVENTORY_ASSET FILTER 4 ITEM_LABEL ROW 3 ITEM_STATUS FILTER 6 ITEM_UNIT_COST VALUE 2 AVG MAKE_BUY FILTER 2 MATERIAL_COST VALUE 4 SUM MATERIAL_OVERHEAD_COST VALUE 5 SUM OUTSIDE_PROCESSING_COST VALUE 7 SUM OVERHEAD_COST VALUE 8 SUM PLANNING_METHOD FILTER 3 QTY VALUE 1 SUM RESOURCE_COST VALUE 6 SUM SUBINVENTORY_LABEL ROW 2 TOTAL_COST VALUE 3 SUM USER_ITEM_TYPE FILTER 5 S Site 56E91C01C279DF934CF3E174BCAF03A5 Pivot - Summary by Cost Group SYSADMIN 13 ASSET_SUBINVENTORY 16 AS_OF_DATE 3 CATEGORY 15 COST_GROUP 7 INVENTORY_ASSET 1 ITEM 2 2 ITEM_DESCRIPTION 25 ITEM_LABEL 6 ITEM_STATUS 18 ITEM_UNIT_COST 8 MAKE_BUY 20 MATERIAL_COST 21 MATERIAL_OVERHEAD_COST 23 OUTSIDE_PROCESSING_COST 24 OVERHEAD_COST 9 PLANNING_METHOD 17 QTY 27 REPORT_RUN_DATE 22 RESOURCE_COST 10 REVISION 11 SUBINVENTORY 1 12 SUBINVENTORY_DESC 26 SUBINVENTORY_LABEL 19 TOTAL_COST 14 TYPE 5 UOM 4 USER_ITEM_TYPE ASSET_SUBINVENTORY FILTER 1 AS_OF_DATE ROW 1 CATEGORY FILTER 7 COST_GROUP ROW 2 INVENTORY_ASSET FILTER 4 ITEM_STATUS FILTER 6 ITEM_UNIT_COST VALUE 2 AVG MAKE_BUY FILTER 2 MATERIAL_COST VALUE 4 SUM MATERIAL_OVERHEAD_COST VALUE 5 SUM OUTSIDE_PROCESSING_COST VALUE 7 SUM OVERHEAD_COST VALUE 8 SUM PLANNING_METHOD FILTER 3 QTY VALUE 1 SUM RESOURCE_COST VALUE 6 SUM SUBINVENTORY_LABEL ROW 3 TOTAL_COST VALUE 3 SUM USER_ITEM_TYPE FILTER 5 S Site SYSADMIN B72663A47A015D789D05A0D6005F31BF ERIC.CLEGG B72663A47A015D789D05A0D6005F31BF CEDDCA4491D6F4006D7D013D11A31B17