ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4700E51A9E05362FB09050512Y SELECT &P_ITEM_FLEXDATA item_flexdat, msi.inventory_item_id item_id, msi.primary_uom_code uom_code, msi.description item_description, round(nvl(moqd.primary_transaction_quantity,0),:P_QTY_PRECISION) item_qty, -- 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 nvl(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'),&P_ITEM_FLEXDATA) C_item_value FROM MTL_SYSTEM_ITEMS_VL msi, MTL_ONHAND_QUANTITIES_DETAIL moqd WHERE &P_ITEM_WHERE and msi.inventory_item_id = moqd.inventory_item_id (+) and msi.organization_id = moqd.organization_id (+) and msi.organization_id = :P_ORGANIZATION_ID and msi.stock_enabled_flag = 'Y' ORDER BY &P_ITEM_ORDER_BY INV INVIRISQ_XML AR INV إجمالي كميات الأصناف (بتنسيق XML) Imported from BI Publisher Description: إجمالي كميات الأصناف Application: المخازن Source: إجمالي كميات الأصناف (بتنسيق XML) Short Name: INVIRISQ_XML DB package: INV_INVIRISQ_XMLP_PKG D INV Artikelbestände - Übersicht Imported from BI Publisher Description: Artikelbestände - Übersicht Application: Lager Source: Artikelbestände - Übersicht (XML) Short Name: INVIRISQ_XML DB package: INV_INVIRISQ_XMLP_PKG E INV Resumen de Cantidades de Artículos Imported from BI Publisher Description: Resumen de Cantidades de Artículos Application: Inventory Source: Resumen de Cantidades de Artículos (XML) Short Name: INVIRISQ_XML DB package: INV_INVIRISQ_XMLP_PKG F INV Synthèse des quantités Imported from BI Publisher Description: Synthèse des quantités Application: Inventory Source: Synthèse des quantités (XML) Short Name: INVIRISQ_XML DB package: INV_INVIRISQ_XMLP_PKG I INV Sintetico quantità articoli Imported from BI Publisher Description: Sintetico quantità articoli Application: Inventory Source: Sintetico quantità articoli (XML) Short Name: INVIRISQ_XML DB package: INV_INVIRISQ_XMLP_PKG JA INV 品目数量要約 Imported from BI Publisher Description: 品目数量要約 Application: Inventory Source: 品目数量要約(XML) Short Name: INVIRISQ_XML DB package: INV_INVIRISQ_XMLP_PKG KO INV 품목 수량 요약 Imported from BI Publisher Description: 품목 수량 요약 Application: Inventory Source: 품목 수량 요약(XML) Short Name: INVIRISQ_XML DB package: INV_INVIRISQ_XMLP_PKG PTB INV Resumo de quantidades do item Imported from BI Publisher Description: Sumário de quantidades do item Application: Inventário Source: Resumo de quantidades do item (XML) Short Name: INVIRISQ_XML DB package: INV_INVIRISQ_XMLP_PKG RU INV Сводка количеств для позиций Imported from BI Publisher Description: Сводка количеств для позиций Application: Запасы Source: Сводка количеств для позиций (XML) Short Name: INVIRISQ_XML DB package: INV_INVIRISQ_XMLP_PKG S INV Artikelkvantiteter totalt Imported from BI Publisher Description: Artikelkvantiteter totalt Application: Inventory Source: Artikelkvantiteter totalt (XML) Short Name: INVIRISQ_XML DB package: INV_INVIRISQ_XMLP_PKG TR INV Kalem miktarları özeti Imported from BI Publisher Description: Kalem miktarları özeti Application: Stok Yönetimi Source: Kalem miktarları özeti (XML) Short Name: INVIRISQ_XML DB package: INV_INVIRISQ_XMLP_PKG US INV Item quantities summary Imported from BI Publisher Description: Item quantities summary Application: Inventory Source: Item quantities summary (XML) Short Name: INVIRISQ_XML DB package: INV_INVIRISQ_XMLP_PKG ZHS INV 物料数量汇总 Imported from BI Publisher Description: 物料数量汇总 Application: 库存管理系统 Source: 物料数量汇总 (XML) Short Name: INVIRISQ_XML DB package: INV_INVIRISQ_XMLP_PKG BI Publisher &p_item_flexdata &p_item_order_by &p_item_where :p_conc_request_id :p_item_flexdata :p_item_hi :p_item_lo :p_item_order_by :p_item_where :p_negative_only :p_optimizer_code :p_organization_id :p_qty_precision :p_struct_num :p_trace_flag 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_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 - Minimo JA 品目:自 品目:下位 KO 품목: 부터 품목 하한 PTB Itens - De Item - inferior RU Позиции с Позиция с S Från artiklar Från artikel TR Kalemler - İlk Kalem alt değeri US Items From Item low ZHS 物料自 物料下限 4 20 :p_item_hi Char AR إلى صنف إلى D Bis Bis Artikel E A A Artículo F A Article - A I A Articolo - Massimo JA 至 品目:上位 KO 까지 품목 상한 PTB Até Item - superior RU По Позиция по S Till Till artikel TR Son Kalem üst değeri US To Item high ZHS 至 物料上限 5 30 :p_negative_only LOV Oracle INV_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by lookup_code select meaning from mfg_lookups where lookup_type='SYS_YES_NO' and lookup_code=2 AR الكميات السالبة فقط الكميات السالبة فقط D Nur negative Mengen Nur negative Mengen E Sólo Cantidades Negativas Sólo Cantidades Negativas F Quantités négatives seult Quantités négatives seult I Solo quantità negative Solo quantità negative JA マイナスの数量のみ マイナスの数量のみ KO 음수 수량만 음수 수량만 PTB Quantidades negativas somente Quantidades negativas somente RU Только отрицательные количества Только отрицательные количества S Endast negativa kvantiteter Endast negativa kvantiteter TR Yalnızca negatif miktarlar Yalnızca negatif miktarlar US Negative quantities only Negative quantities only ZHS 仅限于负数量 仅限于负数量