Query Fixed Asset is duplicte row

[sakchai54]

My query Fixed Asset is show some duplicate row. It difference Remain life fileld but Green mark is True update. Please you suggest it not show red mark in my query

My Query.. below

SELECT

T2."PeriodCat" as "Period",

T0."ItemCode" as "Asset Code",

T0."ItemName" as "Asset Name",

T0."U_FA_BRAND",

T0."U_FA_MODEL",

T0."U_FA_COLOR",

T2."Quantity" as "Qty",

T6."DprStart" as "DPR.Start",

T6."DprEnd" as "DPR.End",

T6."UsefulLife" as "Useful Life (M)",

T6."RemainLife" as "Remain Life (M)",

T2."APC",

T2."OrDpAcc1",

(T2."APC")-(T2."OrDpAcc1") as "Net Book Value",

T2."SalvageVal",

T0."U_EMP_FA",

T5."firstName" || ' ' || T5."lastName" as "Owner",

T7."Location" as "Locate",

T0."U_ITEM_OLD_CODE",

T0."AssetClass" as "Class",

T3."Name" as "Class Name",

T0."U_FA_IMAGE"

FROM OITM T0

INNER JOIN ITM6 T1 ON T0."ItemCode" = T1."ItemCode"

INNER JOIN ITM8 T2 ON T0."ItemCode" = T2."ItemCode"

INNER JOIN OACS T3 ON T0."AssetClass" = T3."Code"

INNER JOIN ITM7 T6 ON T0."ItemCode" = T6."ItemCode"

LEFT OUTER JOIN ACQ1 T4 ON T0."ItemCode" = T4."ItemCode"

LEFT OUTER JOIN OHEM T5 ON T0."Employee" = T5."empID"

LEFT OUTER JOIN OLCT T7 ON T0."Location" = T7."Code"

Where

T0."validFor" = 'Y' and

T2."APC" <> '0' and

T6."UsefulLife" <>T6."RemainLife" and

T2."PeriodCat"= [%0]

GROUP BY

T2."PeriodCat",

T0."ItemCode",

T0."ItemName",

T0."U_FA_BRAND",

T0."U_FA_MODEL",

T0."U_FA_COLOR",

T2."Quantity",

T6."DprStart",

T6."DprEnd",

T6."UsefulLife",

T6."RemainLife",

T2."APC",

T2."OrDpAcc1",

T2."SalvageVal",

T0."U_EMP_FA",

T5."firstName",T5."lastName",

T7."Location",

T0."U_ITEM_OLD_CODE",

T0."AssetClass",

T3."Name",

T0."U_FA_IMAGE"