Hi All, I am building a report in Fixed Assets in Oracle Apps R12. Since couple of days I am fighting with Units Query. I am not able to get correct units for the period. One asset may have multiple scenarios like Partial Retirements, Full transfer , partial transfer, Unit adjustments, full retirements, reinstatement ...etc. So any body have an Idea about this? Any one kindly do the needful.