How to update life in months on R11.5.10
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