ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4701351A9E05362FB09050512Y SELECT si.secondary_inventory_name subinv, si.description subinv_desc, &P_ITEM_FLEXDATA item_flexdat, msi.description item_description, moqd.revision item_revision, moqd.locator_id locator_id, &P_LOC_FLEXDATA locator_flexdat, msi.inventory_item_id item_id, msi.primary_uom_code uom_code, nvl(moqd.primary_transaction_quantity,0) item_qty, decode(msi.inventory_item_id,null,null,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_value', 'INV', 'MSTK', 101, msi.ORGANIZATION_ID, msi.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE')) C_item_value, decode(mil.inventory_location_id,null,null,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_locator_value', 'INV', 'MTLL', 101, mil.ORGANIZATION_ID, mil.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE')) C_locator_value, INV_INVIRSIQ_XMLP_PKG.cf_roundedqtyformula(:C_sum_item_qty) CF_rounded_qty FROM MTL_SYSTEM_ITEMS_VL msi, MTL_ONHAND_QUANTITIES_detail moqd, MTL_SECONDARY_INVENTORIES si, MTL_ITEM_LOCATIONS mil WHERE &P_ITEM_WHERE and si.secondary_inventory_name = moqd.subinventory_code(+) and si.organization_id = moqd.organization_id (+) and moqd.organization_id = msi.organization_id(+) and moqd.inventory_item_id = msi.inventory_item_id (+) and moqd.locator_id = mil.inventory_location_id(+) and moqd.organization_id = mil.organization_id(+) &C_SUBINV_WHERE and si.quantity_tracked = 1 and si.organization_id = :P_ORGANIZATION_ID ORDER BY si.secondary_inventory_name, &P_ITEM_ORDER_BY INV INVIRSIQ_XML AR INV تقرير كميات المخزن (بتنسيق XML) Imported from BI Publisher Description: تقرير كميات المخزن Application: المخازن Source: تقرير كميات المخزن (بتنسيق XML) Short Name: INVIRSIQ_XML DB package: INV_INVIRSIQ_XMLP_PKG D INV Lagerbestände Imported from BI Publisher Description: Lagerbestände Application: Lager Source: Lagerbestände (XML) Short Name: INVIRSIQ_XML DB package: INV_INVIRSIQ_XMLP_PKG E INV Cantidades de Subalmacenes Imported from BI Publisher Description: Informe de cantidades de subalmacenes Application: Inventory Source: Cantidades de Subalmacenes (XML) Short Name: INVIRSIQ_XML DB package: INV_INVIRSIQ_XMLP_PKG F INV Etat des stocks par magasin Imported from BI Publisher Description: Etat des stocks par magasin Application: Inventory Source: Etat des stocks par magasin (XML) Short Name: INVIRSIQ_XML DB package: INV_INVIRSIQ_XMLP_PKG I INV Rapporto Quantità sottomagazzino Imported from BI Publisher Description: Rapporto Quantità sottomagazzino Application: Inventory Source: Rapporto Quantità sottomagazzino (XML) Short Name: INVIRSIQ_XML DB package: INV_INVIRSIQ_XMLP_PKG JA INV 保管場所数量レポート Imported from BI Publisher Description: 保管場所数量レポート Application: Inventory Source: 保管場所数量レポート(XML) Short Name: INVIRSIQ_XML DB package: INV_INVIRSIQ_XMLP_PKG KO INV 창고 수량 보고서 Imported from BI Publisher Description: 창고 수량 보고서 Application: Inventory Source: 창고 수량 보고서(XML) Short Name: INVIRSIQ_XML DB package: INV_INVIRSIQ_XMLP_PKG PTB INV Relatório de quantidades de subinventário Imported from BI Publisher Description: Relatório de quantidades de subinventário Application: Inventário Source: Relatório de quantidades de subinventário (XML) Short Name: INVIRSIQ_XML DB package: INV_INVIRSIQ_XMLP_PKG RU INV Отчет о количествах в складских подразделениях Imported from BI Publisher Description: Отчет о количествах в складских подразделениях Application: Запасы Source: Отчет о количествах в складских подразделениях (XML) Short Name: INVIRSIQ_XML DB package: INV_INVIRSIQ_XMLP_PKG S INV Lagerställekvantiteter - rapport Imported from BI Publisher Description: Lagerställekvantiteter - rapport Application: Inventory Source: Lagerställekvantiteter - rapport (XML) Short Name: INVIRSIQ_XML DB package: INV_INVIRSIQ_XMLP_PKG TR INV Stok yeri miktarları raporu Imported from BI Publisher Description: Stok yeri miktarları raporu Application: Stok Yönetimi Source: Stok yeri miktarları raporu (XML) Short Name: INVIRSIQ_XML DB package: INV_INVIRSIQ_XMLP_PKG US INV Subinventory quantities Imported from BI Publisher Description: Subinventory quantities report Application: Inventory Source: Subinventory quantities report (XML) Short Name: INVIRSIQ_XML DB package: INV_INVIRSIQ_XMLP_PKG ZHS INV 子库存数量报表 Imported from BI Publisher Description: 子库存数量报表 Application: 库存管理系统 Source: 子库存数量报表 (XML) Short Name: INVIRSIQ_XML DB package: INV_INVIRSIQ_XMLP_PKG BI Publisher &c_subinv_where &p_item_flexdata &p_item_order_by &p_item_where &p_loc_flexdata :c_sum_item_qty :p_conc_request_id :p_item_flexdata :p_item_hi :p_item_lo :p_item_order_by :p_item_where :p_loc_flexdata :p_optimizer_code :p_organization_id :p_qty_precision :p_struct_num :p_subinv_hi :p_subinv_lo :p_trace_flag :qty_precision 1 -30 :p_organization_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR التنظيم التنظيم D Organisation Organisation E Organización Organización F Organisation Organisation I Organizzazione Organizzazione JA 組織 組織 KO 조직 조직 PTB Organização Organização RU Организация Организация S Organisation Organisation TR Organizasyon Organizasyon US Organization Organization ZHS 组织 组织 2 -20 :p_qty_precision LOV Oracle INV_SRS_PRECISION Y select lookup_code id, lookup_code value, meaning description from mfg_lookups where lookup_type='INV_SRS_PRECISION' and enabled_flag='Y' order by lookup_code fnd_profile.value('REPORT_QUANTITY_PRECISION') Y AR الدقة الدقة D Nachkommastellen Nachkommastellen E Precisión Precisión F Précision Précision I Precisione Precisione JA 精度 精度 KO 소수점 이하 자리수 소수점 이하 자리수 PTB Precisão Precisão RU Точность Точность TR Duyarlılık Duyarlılık US Precision Precision ZHS 精确度 精确度 3 10 :p_subinv_lo LOV Oracle INV_SRS_SUBINV 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 Magasin - De Magasin - De I Sottomagazzino - Da Sottomagazzino - Da JA 保管場所:自 保管場所:自 KO 창고 From 창고 From PTB De Subinventário De Subinventário RU Складское подразделение с Складское подразделение с S Från lagerställe Från lagerställe TR Stok Yeri: İlk Stok Yeri: İlk US Subinventory From Subinventory From ZHS 子库存自 子库存自 4 20 :p_subinv_hi LOV Oracle INV_SRS_SUBINV 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 Bis Bis Lager E A A Subalmacén F A Magasin - A I A Sottomagazzino - A JA 至 保管場所:至 KO 까지 창고 To PTB Até Para Subinventário RU По Складское подразделение по S Till Till lagerställe TR Son Stok Yeri: Son US To Subinventory To ZHS 至 子库存至 5 30 :p_item_lo Char AR الأصناف من الصنف من D Von Artikel Von Artikel E De Artículo De Artículo F Articles - De Article - De I Articoli - Da Articolo - Da JA 品目:自 品目:自 KO 품목: 부터 품목: 부터 PTB Itens - De Item - De RU Позиции с Позиция с S Från artiklar Från artikel TR Kalemler - İlk Kalem: İlk US Items From Item From ZHS 物料自 物料自 6 40 :p_item_hi Char AR إلى 2 الصنف إلى D Bis 2 Bis Artikel E A 2 A Artículo F A 2 Article - A I A 2 Articolo - A JA 至 2 品目:至 KO 까지 2 품목: 까지 PTB Até 2 Item - Até RU По 2 Позиция по S Till 2 Till artikel TR Son 2 Kalem: Son US To 2 Item To ZHS 至 2 物料至