寻找更好的方法来处理 SUM 和 groupby 子句

问：

我正在使用聚合函数 SUM（） 添加三 （3） 个新列（sum （on_hand）、sum（可分配）、sum（要填充的列），然后是 group by 子句，这种方法迫使我在 group by 子句中列出所有 43 列，任何更好的方法来缩短此查询或让我避免此路由，但结果相同，以 43 列 + 3 个新求和列结尾

SELECT
  SUM(ON_HAND_Qty) AS ON_HAND,
  SUM(WM_Allocated_QtY) AS Allocated_QTY,
  SUM(TO_BE_FILLED_QTY) AS To_fill_QTY 
FROM
  INVENTORY 
WHERE latest_flg * * 
GROUP BY * * location_ID,
  DC_NBR,
  Item_ID,
  TC_COMPANY_ID,
  TC_LPN_ID,
  DC_NBR,
  TC_COMPANY_ID,
  LOCATION_ID,
  TC_LPN_ID,
  TRANSITIONAL_INVENTORY_TYPE,
  INVENTORY_TYPE,
  PRODUCT_STATUS,
  CNTRY_OF_ORGN,
  ITEM_ATTR_1,
  ITEM_ATTR_2,
  ITEM_ATTR_3,
  ITEM_ATTR_4,
  ITEM_ATTR_5,
  LOCN_CLASS,
  ALLOCATABLE,
  CREATED_SOURCE,
  CREATED_DTTM,
  LAST_UPDATED_SOURCE_TYPE,
  LAST_UPDATED_SOURCE,
  LAST_UPDATED_DTTM,
  INBOUND_OUTBOUND_INDICATOR,
  LPN_DETAIL_ID,
  C_FACILITY_ID,
  BATCH_NBR,
  LPN_ID,
  WM_INVENTORY_ID,
  ON_HAND_QTY,
  WM_ALLOCATED_QTY,
  TO_BE_FILLED_QTY,
  WM_VERSION_ID,
  CREATED_SOURCE_TYPE,
  TO_BE_CONSOLIDATED_QTY,
  LOCATION_DTL_ID,
  PACK_QTY,
  SUB_PACK_QTY,
  ITEM_ID,
  MARKED_FOR_DELETE,
  RECALL_ID,
  CRNT_ROW_IND,
  BQ_EFF_BGN_DTTM,
  BQ_EFF_END_DTTM,
  BQ_CREATE_DTTM,
  LATEST_FLG