INV Min-max planning
Description
- Categories
- BI Publisher
- Application
- Inventory
- Source
- Min-max planning report (XML)
- Short Name
- INVISMMX_XML
- DB package
- INV_INVISMMX_XMLP_PKG
Imported from BI Publisher
Min-max planning report
Min-max planning report
SQL 32 lines
SELECT DISTINCT IMMT.ITEM_SEGMENTS, IMMT.DESCRIPTION, IMMT.ERROR, IMMT.SORTEE, IMMT.SUBINVENTORY_CODE, IMMT.MIN_QTY, IMMT.MAX_QTY, IMMT.ONHAND_QTY, IMMT.SUPPLY_QTY, IMMT.DEMAND_QTY, IMMT.TOT_AVAIL_QTY, IMMT.MIN_ORD_QTY, IMMT.MAX_ORD_QTY, IMMT.FIX_MULT, IMMT.REORD_QTY FROM INV_MIN_MAX_TEMP IMMT, MTL_SYSTEM_ITEMS_B_KFV C, MTL_ITEM_CATEGORIES MIC, mtl_categories MC Where ITEM_SEGMENTS = C.CONCATENATED_SEGMENTS AND C.ORGANIZATION_ID = :P_ORG_ID AND MIC.ORGANIZATION_ID=C.ORGANIZATION_ID AND MIC.INVENTORY_ITEM_ID =C.INVENTORY_ITEM_ID AND MIC.CATEGORY_SET_ID =:P_CAT_SET_ID AND MIC.CATEGORY_ID = MC.CATEGORY_ID AND &P_CATG_WHERE1 AND &P_CATG_WHERE2 AND &P_RANGE_SQL --ORDER BY 1,SUBINVENTORY_CODE ORDER BY 5 ASC , 1 , SUBINVENTORY_CODE |
Parameters 34
| Parameter | Type | List of values SQL |
|---|---|---|
| Planning Level | LOV Oracle | |
| Subinventory | LOV Oracle | |
| Item Selection | LOV Oracle | |
| Category Set | LOV Oracle | |
| Categories From | Char | |
| To | Char | |
| Items From | Char | |
| To 2 | Char | |
| Planners From | LOV Oracle | |
| To 3 | LOV Oracle | |
| Buyers From | LOV Oracle | |
| To 4 | LOV Oracle | |
| Sort by | LOV Oracle | |
| Range | LOV Oracle | |
| From | Char | |
| To 5 | Char | |
| Demand Cutoff Date | Date | |
| Demand Cutoff Date Offset | Number | |
| Supply Cutoff Date | Date | |
| Supply Cutoff Date Offset | Number | |
| Restock | LOV Oracle | |
| For Repetitive Item | LOV Oracle | |
| Default Delivery To | LOV Oracle | |
| Net Unreserved Orders | LOV Oracle | |
| Net Reserved Orders | LOV Oracle | |
| Net WIP Demand | LOV Oracle | |
| Include PO Supply | LOV Oracle | |
| Include Move Order Supply | LOV Oracle | |
| Include WIP Supply | LOV Oracle | |
| Include Interface Supply | LOV Oracle | |
| Include Nonnettable | LOV Oracle | |
| Lot Control | LOV Oracle | |
| Display Format | LOV Oracle | |
| Display Item Description | LOV Oracle |