FA: SCM: OM SQL Query: To Obtain a List of Open Orders - Includes Inventory Item Attributes to Limit Results - Kit item, Item Number, etc.
(Doc ID 2678799.1)
Last updated on MAY 06, 2022
Applies to:Oracle Fusion Order Management Cloud Service - Version 11.13.20.01.0 and later
Information in this document applies to any platform.
This note describes SQL that can be used to identify open Sales Orders. The select criteria can be modified to limit results base on specific inventory item attributes, including:
1.Is the item a Kit item?
2. Is the item Stockable?
3. Is the item Returnable?
4. Does the Item Number include specific text?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document