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.