Displaying Open Orders by Item (DOOI)
Purpose: Use this on-line inquiry to identify orders that contain a specific item and to evaluate item statistics such as quantities ordered and reserved for that item.
You can also use this option to advance to standard Order Inquiry for a specific order, or to find out about pending purchase orders for a backordered item.
Quotes: This menu option also allows you to review item statistics on quotes; see Entering Pre-Order Quotes.
In this topic:
- Open Orders by Item Screen (Selecting an Item for Review)
- Display Open Orders by Item Screen
- Display Open Purchase Orders Screen
Open Orders by Item Screen (Selecting an Item for Review)
Use this screen to select the item you would like to research for open orders or purchase order information.
How to display this screen: Enter DOOI in the Fast path field or select this option from a menu.
Note:
You must enter complete and accurate information in both the Item and the SKU fields if applicable.Field | Description |
---|---|
Item |
Represents a unit of inventory. Alphanumeric, 12 positions; required. |
SKU (Stock keeping unit; an unlabeled field to the right of the item number) |
The style of the item, such as its color and size. Alphanumeric, three 4-position fields; required for any item with a SKU. |
Display Open Orders by Item Screen
Use this screen to evaluate open orders for a specific item by quantity, age, and reason for backorder. You can also advance from this screen to standard Order Inquiry for a specific order or display open purchase orders for the item. How to display this screen: Enter a complete item code and SKU, if any, at the Display Open Orders by Item Screen.
Field | Description |
---|---|
Description (Unlabeled field to the right of the SKU field) |
Text that describes the item. Alphanumeric, 120 positions; display-only |
Order # |
A unique number that the system assigns each order. Numeric, 7 positions; display-only. |
St # (Ship To Number) |
The number of the shipping address for the order. The system assigns a ship to suffix for each shipping address on an order. Numeric, 3 positions; display-only. |
Ln # (Line number) |
The item's order detail line number. Numeric, 3 positions; display-only. |
Days old |
The age of the order in days. Numeric, 5 positions; display-only |
Quantity |
Three status fields for the order detail line. These fields are: OrderedThe quantity of the item on the order line. Numeric, 7 positions; display-only. ReservedThe total reserved quantity of the item on the order line. Numeric, 7 positions; display-only. ShippedThe total quantity of the item on the order line that has shipped to date. Numeric, 7 positions; display-only. |
Rsn cde (Reason code) |
Represents the reason the item is on backorder. Valid values are:
The system will not “tie-up” inventory that can be matched to current orders if the order will not ship for a period of time. The system uses the following calculation to identify future orders: Arrival date - Reservation lead days = Date The system will not reserve inventory if the system-calculated date is greater than today's date. Normally, the Evaluate Future Orders program runs each evening during a periodic process to evaluate each order detail line identified as a “future” order. The system reruns the arrival date calculation and reserves inventory if the system-calculated date is less than or equal to today's date.
|
For more information, see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1). Alphanumeric, 1 position; display-only. |
|
Description |
Text that explains the meaning of the backorder reason code. Alphanumeric, 25 positions; display-only |
Screen Option | Procedure |
---|---|
Display an order |
Select Display for an order to advance to Order Inquiry Header Screen or the Order Inquiry Detail Screen, depending on the setting of the Default Version for Order Inquiry (C34) system control value. |
Display open purchase orders for an item |
Select Display Open POs to advance to the Display Open Purchase Orders Screen. |
Display Open Purchase Orders Screen
Use this screen to obtain information about the unreceived or partially received purchase orders for an item. This screen includes the purchase order numbers, vendors, quantities and expected delivery dates for the item.
How to display this screen: Select Display Open POs at the Display Open Orders by Item Screen.
Field | Description |
---|---|
Whs (Warehouse) |
The warehouse to which the item will be delivered. Numeric, 3 positions; display-only. |
PO# |
The number of the purchase order on which the item was ordered from the vendor. Numeric, 7 positions; display-only |
Ln# (Line number) |
The line number of item on the purchase order. Numeric, 3 positions; display-only |
Vendor # |
A code to identify the supplier of the item. Vendor codes are defined in and validated against the Vendor table. See Working with Vendors (WVEN). Numeric, 7 positions; display-only. |
Name |
The name of the vendor associated with the vendor number. Alphanumeric, 30 positions; display-only. |
Qty due (Quantity due) |
The number of units of the item expected in the shipment. Numeric, 7 positions; display-only. |
Date |
The date when the shipment of the item is expected. Numeric, 6 positions (in user date format); display-only. |