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