My Oracle Support Banner

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 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

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