INV Min-max planning

Description
Categories: BI Publisher, Logistics
Application: Inventory
Source: Min-max planning report (XML)
Short Name: INVISMMX_XML
DB package: INV_INVISMMX_XMLP_PKG
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
Parameter Name SQL text Validation
Purchasing By Revision
 
LOV Oracle
User ID
 
Number
Category Structure
 
Number
INV_SRS_MMX_SUBINV_ENABLE_FLAG
 
Number
Organization
 
Number
Display Item Description
 
LOV Oracle
Display Format
 
LOV Oracle
Lot Control
 
LOV Oracle
Include Nonnettable
 
LOV Oracle
Include Interface Supply
 
LOV Oracle
Include WIP Supply
 
LOV Oracle
Include Move Order Supply
 
LOV Oracle
Include PO Supply
 
LOV Oracle
Net WIP Demand
 
LOV Oracle
Net Reserved Orders
 
LOV Oracle
Net Unreserved Orders
 
LOV Oracle
Default Delivery To
 
LOV Oracle
For Repetitive Item
 
LOV Oracle
Restock
 
LOV Oracle
Supply Cutoff Date Offset
 
Number
Supply Cutoff Date
 
Date
Demand Cutoff Date Offset
 
Number
Demand Cutoff Date
 
Date
To
 
From
 
Range
 
LOV Oracle
Sort by
 
LOV Oracle
To
 
LOV Oracle
Buyers From
 
LOV Oracle
To
 
LOV Oracle
Planners From
 
LOV Oracle
To
 
Items From
 
To
 
Categories From
 
Category Set
 
LOV Oracle
Item Selection
 
LOV Oracle
Subinventory
 
LOV Oracle
Planning Level
 
LOV Oracle
Ask a question