1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

UOP Asset Capacity

Discussion in 'Oracle Financials' started by Grant69, Jan 6, 2012.

  1. Grant69

    Grant69 Active Member

    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    Perth WA
    Hi

    I'm looking for report that will give me the current capacity of UOP Assets. I found the Adjusted Capacity & Production Capacity in the FA Books Summary Table. The Production Capacity gives the original Capacity & the Adjusted Capacity gives the reduced capacity. We change the capacity of our UOP assets on a yearly basis. For example we add a new asset with a capacity of 10 tonnes, 12 months later the capacity is changed to 15 tonnes, 12 months later the capacity is changed to 20 tonnes. So I want to be able to run a report or sql query that will show the capacity as 20 tonnes

    Appreciate any help

    Thanks
    Grant