PL/SQL (MOSC)

MOSC Banner

Select Query for Assets that are not amortised

edited Aug 6, 2012 8:55PM in PL/SQL (MOSC) 2 commentsAnswered

Hi

Could anybody suggest a SQL select that would give me a list of which assets in a FA Book that has does NOT amortise it adjustments. I found it easy enough to do a query for assets that are marked to amortise, but now our user wants a list of assets where adjustments do not amortise, and I have found this not a straignt forward thing to provide.  

Thanks B

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