ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F5303869E053B46B63588994Y select mil.organization_id organization_id, mil.SUBINVENTORY_CODE , decode(mil.physical_location_id,null,mil.inventory_location_id,mil.physical_location_id) locator_id, nvl(sum(decode(nvl(moqd.CONTAINERIZED_FLAG,2),2 ,greatest(moqd.primary_transaction_quantity,0))),0) loose_qty, nvl(sum(decode(moqd.CONTAINERIZED_FLAG,1 ,greatest(moqd.primary_transaction_quantity,0))),0) packed_qty, nvl(sum(greatest(moqd.primary_transaction_quantity,0)),0) total_qty, /*WMS_WMSCPTYR_XMLP_PKG.cf_calc_countersformula(:CS_WEIGHT, :CS_VOLUME, :CS_UNITS, :CS_MAX_SUB_WT, :CS_SUB_WT_PER, :CS_MAX_SUB_VOL, :CS_SUB_VOL_PER, :CS_SUB_UNITS_PER, :CS_MAX_SUB_UNITS, :CS_LOOSE_QTY, :CS_PACKED_QTY, :CS_TOTAL_QTY, :CS_NUM_LOCS) CF_CALC_COUNTERS,*/ WMS_WMSCPTYR_XMLP_PKG.CP_UNITS_PER_p CP_UNITS_PER, WMS_WMSCPTYR_XMLP_PKG.CP_WEIGHT_PER_p CP_WEIGHT_PER, WMS_WMSCPTYR_XMLP_PKG.CP_VOLUME_PER_p CP_VOLUME_PER, WMS_WMSCPTYR_XMLP_PKG.CP_COUNT_p CP_COUNT, WMS_WMSCPTYR_XMLP_PKG.CP_DISPLAY_SUB_p CP_DISPLAY_SUB, WMS_WMSCPTYR_XMLP_PKG.CP_SUB_LOOSE_QTY_p CP_SUB_LOOSE_QTY, WMS_WMSCPTYR_XMLP_PKG.CP_SUB_PACKED_QTY_p CP_SUB_PACKED_QTY, WMS_WMSCPTYR_XMLP_PKG.CP_SUB_TOTAL_QTY_p CP_SUB_TOTAL_QTY, WMS_WMSCPTYR_XMLP_PKG.CP_SUB_WEIGHT_p CP_SUB_WEIGHT, WMS_WMSCPTYR_XMLP_PKG.CP_SUB_VOLUME_p CP_SUB_VOLUME, WMS_WMSCPTYR_XMLP_PKG.cf_loc_flex_fieldformula(decode ( mil.physical_location_id , null , mil.inventory_location_id , mil.physical_location_id ), mil.organization_id) CF_LOC_FLEX_FIELD, WMS_WMSCPTYR_XMLP_PKG.cf_loc_capacityformula(mil.organization_id, decode ( mil.physical_location_id , null , mil.inventory_location_id , mil.physical_location_id ), nvl ( sum ( decode ( nvl ( moqd.CONTAINERIZED_FLAG , 2 ) , 2 , greatest ( moqd.primary_transaction_quantity , 0 ) ) ) , 0 ), nvl ( sum ( decode ( moqd.CONTAINERIZED_FLAG , 1 , greatest ( moqd.primary_transaction_quantity , 0 ) ) ) , 0 ), nvl ( sum ( greatest ( moqd.primary_transaction_quantity , 0 ) ) , 0 ), mil.SUBINVENTORY_CODE) CF_LOC_CAPACITY, WMS_WMSCPTYR_XMLP_PKG.CP_SUB_WT_p CP_SUB_WT, WMS_WMSCPTYR_XMLP_PKG.CP_SUB_VOL_p CP_SUB_VOL, WMS_WMSCPTYR_XMLP_PKG.CP_MAX_SUB_WT_p CP_MAX_SUB_WT, WMS_WMSCPTYR_XMLP_PKG.CP_MAX_SUB_VOL_p CP_MAX_SUB_VOL, WMS_WMSCPTYR_XMLP_PKG.CP_WT_PER_p CP_WT_PER, WMS_WMSCPTYR_XMLP_PKG.CP_VOL_PER_p CP_VOL_PER, WMS_WMSCPTYR_XMLP_PKG.CP_DISPLAY_LOC_p CP_DISPLAY_LOC, WMS_WMSCPTYR_XMLP_PKG.CP_LOC_LOOSE_QTY_p CP_LOC_LOOSE_QTY, WMS_WMSCPTYR_XMLP_PKG.CP_LOC_PACKED_QTY_p CP_LOC_PACKED_QTY, WMS_WMSCPTYR_XMLP_PKG.CP_UNITS_p CP_UNITS, WMS_WMSCPTYR_XMLP_PKG.CP_MAX_SUB_UNITS_p CP_MAX_SUB_UNITS, WMS_WMSCPTYR_XMLP_PKG.CP_LOC_TOTAL_QTY_p CP_LOC_TOTAL_QTY, WMS_WMSCPTYR_XMLP_PKG.CP_LOC_WT_PER_p CP_LOC_WT_PER, WMS_WMSCPTYR_XMLP_PKG.CP_LOC_VOL_PER_p CP_LOC_VOL_PER, WMS_WMSCPTYR_XMLP_PKG.CP_LOC_UNITS_PER_p CP_LOC_UNITS_PER, 'X' dummy from mtl_onhand_quantities_detail moqd, mtl_item_locations mil, mtl_item_locations mill where moqd.locator_id(+) = mil.inventory_location_id and mill.inventory_location_id = decode(mil.physical_location_id,null,mil.inventory_location_id,mil.physical_location_id) and trunc(nvl(mil.disable_date,sysdate+1)) > trunc(sysdate ) and trunc(nvl(mil.start_date_active,sysdate)) < trunc(sysdate+1) and trunc(nvl(mil.end_date_active,sysdate )) > trunc(sysdate-1) and mil.enabled_flag = 'Y' &lp_where_clause group by mil.SUBINVENTORY_CODE, decode(mil.physical_location_id,null,mil.inventory_location_id,mil.physical_location_id), mil.organization_id, mill.picking_order &LP_ORDER_BY WMS WMSCPTYR_XML AR WMS تقرير استخدام مساحة المستودع (بتنسيق XML) Application: إدارة المستودعات Source: تقرير استخدام مساحة المستودع (بتنسيق XML) Short Name: WMSCPTYR_XML DB package: WMS_WMSCPTYR_XMLP_PKG D WMS Lager - Raumauslastung Application: Warehouse Management Source: Lager - Raumauslastung (XML) Short Name: WMSCPTYR_XML DB package: WMS_WMSCPTYR_XMLP_PKG F WMS Etat Utilisation de l'espace de l'entrepôt Application: Warehouse Management Source: Etat Utilisation de l'espace de l'entrepôt (XML) Short Name: WMSCPTYR_XML DB package: WMS_WMSCPTYR_XMLP_PKG US WMS Warehouse Space Utilization Application: Warehouse Management Source: Warehouse Space Utilization Report (XML) Short Name: WMSCPTYR_XML DB package: WMS_WMSCPTYR_XMLP_PKG ZHS WMS 仓库空间利用率报表 Application: 仓库管理系统 Source: 仓库空间利用率报表 (XML) Short Name: WMSCPTYR_XML DB package: WMS_WMSCPTYR_XMLP_PKG BI Publisher &lp_order_by &lp_where_clause :cp_avg_loose_qty :cp_avg_packed_qty :cp_avg_total_qty :cp_avg_volume :cp_avg_weight :cp_count :cp_display_loc :cp_display_sub :cp_loc_loose_qty :cp_loc_loose_qty_c :cp_loc_packed_qty :cp_loc_packed_qty_c :cp_loc_total_qty :cp_loc_total_qty_c :cp_loc_units_per :cp_loc_vol_per :cp_loc_volume_c :cp_loc_weight_c :cp_loc_wt_per :cp_loose_qty_c :cp_max_sub_units :cp_max_sub_vol :cp_max_sub_wt :cp_packed_qty_c :cp_sub_loose_qty :cp_sub_packed_qty :cp_sub_total_qty :cp_sub_vol :cp_sub_volume :cp_sub_weight :cp_sub_wt :cp_total_qty_c :cp_units :cp_units_per :cp_vol_per :cp_volume_c :cp_volume_per :cp_weight_c :cp_weight_per :cp_wt_per :lp_non_conv_stock :lp_order_by :lp_where_clause :p_actual_start_date :p_application :p_conc_request_id :p_detail_level :p_detail_meaning :p_locator_flex_all :p_locator_id :p_message :p_non_conv_stk :p_non_conv_stock :p_order_by :p_order_by_meaning :p_org_code :p_org_id :p_org_name :p_printer :p_report_name :p_request_date :p_responsibility :p_save_output_flag :p_sub_units_uom_code :p_sub_vol_uom_code :p_sub_wt_uom_code :p_subinventory :p_units_operator :p_util_by_unit :p_util_by_volume :p_util_by_weight :p_value_na :p_value_no :p_value_yes :p_vol_operator :p_wt_operator 1 10 :p_org_id LOV Oracle INV_SRS_ORG Y select to_char(organization_id) id, organization_code value, organization_name description from org_organization_definitions where nvl(disable_date,sysdate+1)>sysdate order by value,description select Organization_code from mtl_parameters where organization_id = FND_PROFILE.VALUE('MFG_ORGANIZATION_ID') Y AR التنظيم D Organisation F Organisation US Organization ZHS 组织 2 20 :p_detail_level LOV Oracle WMS_CPTY_DETL_LEVEL Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='WMS_CAPACITY_DETAIL' and lookup_code in (1,2) order by value,description Y AR مستوى التفاصيل D Detailebene F Niveau de détail US Detail level ZHS 详细资料层 3 30 :p_subinventory LOV Oracle WMS_SRS_SUBINVENTORY Y select secondary_inventory_name id, secondary_inventory_name value, description description from mtl_secondary_inventories where organization_id=:$flex$.inv_srs_org order by secondary_inventory_name AR المخزن D Lager F Magasin US Subinventory ZHS 子库存 4 40 :p_locator_id Char AR محدد المواقع D Lagerplatz F Emplacement US Locator ZHS 货位 5 50 :p_wt_operator LOV Oracle WMS_OPERAND_TYPE Y select meaning id, meaning value, null description from mfg_lookups where lookup_type='WMS_OPERATOR' and lookup_code in (1,2,3) order by value,description AR مشغل الوزن D Operator Gewicht F Opérateur de poids US Weight Operator ZHS 重量运算符 6 60 :p_util_by_weight Number AR نسبة ملء الوزن D Füllmenge Gewicht (%) F Pourcentage de remplissage en poids US Weight Fill % ZHS 重量装载 % 7 70 :p_sub_wt_uom_code LOV Oracle WMS_UOM_CODES Y select uom_code id, uom_code value, unit_of_measure description from mtl_units_of_measure_vl order by value,description Y AR وحدة قياس وزن المخرجات D ME Ausgabegewicht F UdM poids de sortie US Output Weight UOM ZHS 重量输出单位 8 80 :p_vol_operator LOV Oracle WMS_OPERAND_TYPE Y select meaning id, meaning value, null description from mfg_lookups where lookup_type='WMS_OPERATOR' and lookup_code in (1,2,3) order by value,description AR مشغل الحجم D Operator Volumen F Opérateur de volume US Volume Operator ZHS 体积运算符 9 90 :p_util_by_volume Number AR نسبة ملء الحجم D Füllmenge Volumen (%) F Pourcentage de remplissage en volume US Volume Fill % ZHS 体积装载 % 10 100 :p_sub_vol_uom_code LOV Oracle WMS_UOM_CODES Y select uom_code id, uom_code value, unit_of_measure description from mtl_units_of_measure_vl order by value,description Y AR وحدة قياس حجم المخرجات D ME Ausgabevolumen F UdM volume de sortie US Output Volume UOM ZHS 体积输出单位 11 110 :p_units_operator LOV Oracle WMS_OPERAND_TYPE Y select meaning id, meaning value, null description from mfg_lookups where lookup_type='WMS_OPERATOR' and lookup_code in (1,2,3) order by value,description AR مشغل الوحدات D Operator Einheiten F Opérateur d'unités US Units Operator ZHS 数量运算符 12 120 :p_util_by_unit Number AR نسبة الاستخدام حسب الوحدات D Auslastung nach Einheiten (%) F Pourcentage d'utilisation en unités US %Utilization By Units ZHS 按数量列出的利用率 % 13 130 :p_order_by LOV Oracle WMS_ORDER_BY Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='WMS_CAPACITY_DETAIL' and lookup_code in (1,2,3) order by value,description Y AR ترتيب حسب D Sortieren nach F Tri par US Order By ZHS 排序依据 14 140 :p_non_conv_stk 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_code=2 and lookup_type='SYS_YES_NO' AR يتضمن مخزون غير قابل للتحويل D Mit nicht-umwandelbarem Bestand F Inclure le stock non convertible US Include Non-Convertable Stock ZHS 包括不可转换库存