ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4700D51A9E05362FB09050512Y SELECT &P_LOC_FLEXDATA LOC_FLEXDATA, MIL.INVENTORY_LOCATION_ID MIL_LOC_ID, MIL.DESCRIPTION MIL_DESC, MIL.SUBINVENTORY_CODE MIL_SUBINV_CD, MIL.DISABLE_DATE MIL_DISABLE_DT, MIL.LOCATION_WEIGHT_UOM_CODE MIL_WEIGHT_UOM, UMT1.DESCRIPTION MIL_WT_UOM_DESC, MIL.VOLUME_UOM_CODE MIL_VOL_UOM, UMT2.DESCRIPTION MIL_VOL_UOM_DESC, ROUND(NVL(MIL.MAX_CUBIC_AREA ,0), :P_QTY_PRECISION) MIL_MAX_CUBIC_AREA, ROUND(NVL(MIL.MAX_WEIGHT,0), :P_QTY_PRECISION) MIL_MAX_WEIGHT, ROUND(NVL(MIL.LOCATION_MAXIMUM_UNITS,0), :P_QTY_PRECISION) MIL_MAX_UNITS, MOQD.INVENTORY_ITEM_ID MOH_ITEM_ID, MOQD.REVISION MOH_ITEM_REV, &P_ITEM_FLEXDATA ITEM_FLEXDATA, MSI.DESCRIPTION ITEM_DESC, MSI.PRIMARY_UOM_CODE MSI_UOM_CODE, ROUND(NVL(MOQD.PRIMARY_TRANSACTION_QUANTITY,0), :P_QTY_PRECISION) MOH_QTY, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_loc_value', 'INV', 'MTLL', 101, mil.ORGANIZATION_ID, mil.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') C_LOC_VALUE, INV_INVIRILC_XMLP_PKG.loc_pct_max_wt(ROUND ( NVL ( MIL.MAX_WEIGHT , 0 ) , :P_QTY_PRECISION ), :C_GROSS_WT) C_MAX_WT_PCT, INV_INVIRILC_XMLP_PKG.loc_pct_max_vol(ROUND ( NVL ( MIL.MAX_CUBIC_AREA , 0 ) , :P_QTY_PRECISION ), :C_GROSS_VOL) C_MAX_VOL_PCT, 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, INV_INVIRILC_XMLP_PKG.dsply_wt_cnv_rate(INV_INVIRILC_XMLP_PKG.weight_conv_rate(MOQD.INVENTORY_ITEM_ID, MSI.PRIMARY_UOM_CODE, MIL.LOCATION_WEIGHT_UOM_CODE)) C_WT_CNV_RT_DSPLY, INV_INVIRILC_XMLP_PKG.item_rev_wt_calc(:C_WEIGHT_CONV_RATE, :C_ITEM_REV_QTY) C_ITEM_REV_WEIGHT, INV_INVIRILC_XMLP_PKG.dsply_vol_cnv_rate(INV_INVIRILC_XMLP_PKG.vol_conv_rate(MOQD.INVENTORY_ITEM_ID, MSI.PRIMARY_UOM_CODE, MIL.VOLUME_UOM_CODE) ) C_VOL_CVN_RT_DSPLY, INV_INVIRILC_XMLP_PKG.item_rev_vol_calc(:C_VOL_CONV_RATE, :C_ITEM_REV_QTY) C_ITEM_REV_VOL, INV_INVIRILC_XMLP_PKG.vol_conv_rate(MOQD.INVENTORY_ITEM_ID, MSI.PRIMARY_UOM_CODE, MIL.VOLUME_UOM_CODE) C_VOL_CONV_RATE, INV_INVIRILC_XMLP_PKG.weight_conv_rate(MOQD.INVENTORY_ITEM_ID, MSI.PRIMARY_UOM_CODE, MIL.LOCATION_WEIGHT_UOM_CODE) C_WEIGHT_CONV_RATE FROM MTL_ITEM_LOCATIONS MIL, MTL_UNITS_OF_MEASURE UMT1, MTL_UNITS_OF_MEASURE UMT2, MTL_UNITS_OF_MEASURE UMF1, MTL_SYSTEM_ITEMS_VL MSI, MTL_ONHAND_QUANTITIES_DETAIL MOQD WHERE &P_LOC_WHERE AND MIL.LOCATION_WEIGHT_UOM_CODE = UMT1.UOM_CODE (+) AND MIL.VOLUME_UOM_CODE = UMT2.UOM_CODE (+) AND MSI.PRIMARY_UOM_CODE = UMF1.UOM_CODE (+) AND MOQD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MOQD.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MIL.INVENTORY_LOCATION_ID = MOQD.LOCATOR_ID(+) AND MIL.ORGANIZATION_ID = MOQD.ORGANIZATION_ID(+) AND MIL.SUBINVENTORY_CODE = MOQD.SUBINVENTORY_CODE(+) AND MIL.ORGANIZATION_ID = :P_ORG order by &P_LOC_ORDER_BY, MIL.SUBINVENTORY_CODE, &P_ITEM_ORDER_BY, MOQD.REVISION INV INVIRILC_XML AR INV تقرير كميات محدد المواقع (بتنسيق XML) Imported from BI Publisher Description: تقرير كميات محدد المواقع Application: المخازن Source: تقرير كميات محدد المواقع (بتنسيق XML) Short Name: INVIRILC_XML DB package: INV_INVIRILC_XMLP_PKG D INV Lagerplatz - Bestände Imported from BI Publisher Description: Lagerplatz - Bestände Application: Lager Source: Lagerplatz - Bestände (XML) Short Name: INVIRILC_XML DB package: INV_INVIRILC_XMLP_PKG E INV Cantidades de Ubicaciones de Stock Imported from BI Publisher Description: Cantidades de Ubicaciones Application: Inventory Source: Cantidades de Ubicaciones de Stock (XML) Short Name: INVIRILC_XML DB package: INV_INVIRILC_XMLP_PKG F INV Etat des quantités par emplacement Imported from BI Publisher Description: Etat des quantités par emplacement Application: Inventory Source: Etat des quantités par emplacement (XML) Short Name: INVIRILC_XML DB package: INV_INVIRILC_XMLP_PKG I INV Rapporto Quantità collocazione Imported from BI Publisher Description: Rapporto Quantità collocazione Application: Inventory Source: Rapporto Quantità collocazione (XML) Short Name: INVIRILC_XML DB package: INV_INVIRILC_XMLP_PKG JA INV 保管棚数量レポート Imported from BI Publisher Description: 保管棚数量レポート Application: Inventory Source: 保管棚数量レポート(XML) Short Name: INVIRILC_XML DB package: INV_INVIRILC_XMLP_PKG KO INV 보관처 수량 보고서 Imported from BI Publisher Description: 보관처 수량 보고서 Application: Inventory Source: 보관처 수량 보고서(XML) Short Name: INVIRILC_XML DB package: INV_INVIRILC_XMLP_PKG PTB INV Relatório de quantidades de endereço Imported from BI Publisher Description: Relatório de quantidades de endereço Application: Inventário Source: Relatório de quantidades de endereço (XML) Short Name: INVIRILC_XML DB package: INV_INVIRILC_XMLP_PKG RU INV Отчет о количествах на складских местах Imported from BI Publisher Description: Отчет о количествах на складских местах Application: Запасы Source: Отчет о количествах на складских местах (XML) Short Name: INVIRILC_XML DB package: INV_INVIRILC_XMLP_PKG S INV Lagerplatskvantiteter - rapport Imported from BI Publisher Description: Lagerplatskvantiteter - rapport Application: Inventory Source: Lagerplatskvantiteter - rapport (XML) Short Name: INVIRILC_XML DB package: INV_INVIRILC_XMLP_PKG TR INV Stok adresi miktarları raporu Imported from BI Publisher Description: Stok adresi miktarları raporu Application: Stok Yönetimi Source: Stok adresi miktarları raporu (XML) Short Name: INVIRILC_XML DB package: INV_INVIRILC_XMLP_PKG US INV Locator quantities Imported from BI Publisher Description: Locator quantities report Application: Inventory Source: Locator quantities report (XML) Short Name: INVIRILC_XML DB package: INV_INVIRILC_XMLP_PKG ZHS INV 货位数量报表 Imported from BI Publisher Description: 货位数量报表 Application: 库存管理系统 Source: 货位数量报表 (XML) Short Name: INVIRILC_XML DB package: INV_INVIRILC_XMLP_PKG BI Publisher &p_item_flexdata &p_item_order_by &p_loc_flexdata &p_loc_order_by &p_loc_where :c_gross_vol :c_gross_wt :c_item_rev_qty :c_vol_conv_rate :c_weight_conv_rate :p_conc_request_id :p_item_flexdata :p_item_num :p_item_order_by :p_loc_flexdata :p_loc_hi :p_loc_lo :p_loc_num :p_loc_order_by :p_loc_where :p_optimizer_code :p_org :p_qty_precision :p_trace_flag 1 -30 :p_org 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') AR خيار الدقة الديناميكية خيار الدقة الديناميكية D Option Nachkommastellen Option Nachkommastellen E Opción Precisión Dinámica Opción Precisión Dinámica F Option précision dynamique Option précision dynamique I Opzione precisione dinamica Opzione precisione dinamica JA 動的演算精度オプション 動的演算精度オプション KO 동적 소수점자리 옵션 동적 소수점자리 옵션 PTB Opção de Precisão Dinâmica Opção de Precisão Dinâmica RU Динамическая точность Динамическая точность S Alternativ för dynamisk precision Alternativ för dynamisk precision TR Dinamik Duyarlılık Seçeneği Dinamik Duyarlılık Seçeneği US Dynamic Precision Option Dynamic Precision Option ZHS 动态精确度选项 动态精确度选项 3 10 :p_loc_lo Char AR محددو المواقع من محدد موقع من D Von Lagerplatz Von Lagerplatz E De Ubicación De Ubicación F Emplacts - De Emplacement - De I Collocazioni - Da Collocazione - Da JA 保管棚:自 保管棚:下位 KO 보관처: 부터 보관처 하한 PTB Endereços - De Endereço - Inferior RU Складские места с Складское место с S Från lagerplats Lagerplatser från TR Stok Adresleri: İlk Stok Adresi İlk: US Locators From Locator Low ZHS 货位自 货位下限 4 20 :p_loc_hi Char AR إلى محدد موقع إلى D Bis Lagerplatz bis E A A Ubicación F A Emplacement - A I A Collocazione - A JA 至 保管棚:上位 KO 까지 보관처 상한 PTB Até Endereço - Superior RU По Складское место по S Till Lagerplatser till TR Son Stok Adresi Son: US To Locator High ZHS 至 货位上限