Help With Custom SQL For Parts, Onhand, Cost/Value Where Item Not Used/Moved Since 2014: "Non Moving Items"
Last updated on JANUARY 18, 2018
Applies to:Oracle Inventory Management - Version 12.1.2 and later
Information in this document applies to any platform.
How to query items that are not moved for a long time (for example, since 31-DEC-2014) and still have balance?
Users have onhand and value reports but they do not meet their needs.
Users want a custom query to look for items still onhand for a long period of time, like 2014.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms