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