Fixed Assets - EBS (MOSC)

MOSC Banner

How to update life in months on R11.5.10

edited May 4, 2012 11:09PM in Fixed Assets - EBS (MOSC) 2 commentsAnswered
Hello

I got the following SQL to update the reamining life in months, and I was wondering if there is any better way to do it.

Finally if you did through Oracle Web ADI.

Thanks

SELECT a.asset_number,
b.life_in_months LIFE_IN_BOOKS,
m.asset_number,
m.attribute1 LIFE_IN_MASS_ADD
FROM fa_additions a,
fa_books b,
fa_mass_additions m
WHERE a.asset_id = b.asset_id
AND a.asset_number = m.asset_number
AND b.book_type_code LIKE 'BOOK NAME' --- pass the book
AND m.attribute1 IS NOT NULL

Once you get , you need to take count

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center