Group items tagged

SELECT ev1.INVENTORY_ITEM_ID,   ev1.ITEM_CODE ITEM,   XXRG_HR_PKG.get_org_name(:ORG_ID) ORGANIZATION,   ev1.DESCRIPTION,   SUM(Buk11) buk11,   SUM(Buk21) buk21 ,   SUM(Buk31) buk31 ,   SUM(Buk41) buk41,   SUM(Buk51) buk51  FROM   (SELECT ev1.INVENTORY_ITEM_ID,     ITEM_CODE,     DESCRIPTION,     (     CASE       WHEN age BETWEEN :BUK1_DAYS_FROM AND :BUK1_DAYS_TO       THEN SUM(aqty)       ELSE NULL     END) Buk11,     (     CASE       WHEN age BETWEEN :BUK2_DAYS_FROM AND :BUK2_DAYS_TO       THEN SUM(aqty)       ELSE NULL     END) Buk21,     (     CASE       WHEN age BETWEEN :BUK3_DAYS_FROM AND :BUK3_DAYS_TO       THEN SUM(aqty)       ELSE NULL     END) Buk31,     (     CASE       WHEN age BETWEEN :BUK4_DAYS_FROM AND :BUK4_DAYS_TO       THEN SUM(aqty)       ELSE NULL     END) Buk41,     (     CASE       WHEN age >= :BUK5_DAYS_FROM       THEN SUM(aqty)       ELSE NULL     END) Buk51   FROM     (SELECT        ITEM_CODE,       DESCRIPTION,       TRANSACTION_DATE,       TRANSACTION_QUANTITY,       SUM(TRANSACTION_QUANTITY) OVER(PARTITION BY INVENTORY_ITEM_ID ORDER BY TRANSACTION_ID,TRANSACTION_DATE)+ NVL(NQTY,0) BFF ,       (       CASE         WHEN TRANSACTION_QUANTITY > SUM(TRANSACTION_QUANTITY) OVER(PARTITION BY INVENTORY_ITEM_ID ORDER BY TRANSACTION_ID,TRANSACTION_DATE)+ NVL(NQTY,0)         THEN SUM(TRANSACTION_QUANTITY) OVER(PARTITION BY INVENTORY_ITEM_ID ORDER BY TRANSACTION_ID,TRANSACTION_DATE)                       +NVL(NQTY,0)         ELSE TRANSACTION_QUANTITY       END) AQTY       --,TCOST       ,       NVL(fnd_conc_date.string_to_date(:TILL_DATE),SYSDATE)-fnd_conc_date.string_to_date(TRANSACTION_DATE) AGE,       inventory_item_id     FROM       (SELECT V1.TRANSACTION_ID,         V1.ITEM_CODE,         V1.DESCRIPTION,         TRUNC(         CASE           WHEN V1.TRANSACTION_TYPE_ID = 4