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:

Goal

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?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.