Min Max Planning Report at Subinventory level


Min Max Planning Report at Subinventory level

Share this:

Price: $79.99

 

Product Description

This report is for min-max plan at the subinventory level. Oracle Inventory looks at inventory balances, purchase order and internal order supply, and optionally, 

sales order demand for a single subinventory only. In addition, rather than using item attribute planning modifiers, Oracle Inventory uses values and parameters set at the item/subinventory level

What happens now?

Once you've decided on the report or view you'd like to buy, simply add it to your basket and proceed through the checkout. You will visit 2checkout.com who are our payment processor, and on successful payment you will return to our site and the code will be unlocked for you to use. There will be a direct link in the order confirmation screen, or you can view the code at any time in the future through your Account screen.

What am I buying?

There are a total of 103 lines of code in this product. Here is an example:
35.    msi.segment1,
36.    (Select sum ( v1.ONHAND_QTY) from apps.inv_min_max_temp v1 where 1=1) v1_qty,
37.    (select sum(transaction_quantity) from mtl_onhand_quantities v2
38.    where mil.INVENTORY_LOCATION_ID=v2.locator_id
39.    and v2.subinventory_code=mil.subinventory_code) V2_Qty
40.    FROM apps.inv_min_max_temp v,

Report Fields

PO_HEADER_ID UNIT PRICE MFG_PART_NUM VENDOR_PRODUCT_NUM ITEM_SEGMENTS DESCRIPTION ORGANIZATION_ID ORG_NAME ERROR SORTEE SUBINVENTORY_CODE LOCATOR MIN_QTY MAX_QTY ONHAND_QTY SUPPLY_QTY DEMAND_QTY TOTAL_AVAILABLE_QTY MIN_ORD_QTY
MAX_ORD_QTY FIX_MULT REORD_QTY
PRIMARY_UOM_CODE BUYING_LEAD_TIME ITEM_COST
FULL_LEAD_TIME INV_ITEM_ID SEGMENT1
V1_QTY (SUM_ONHAND_QTY) V2_QTY (SUM_TRX_QTY)