INV Min-max planning

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Min-max planning report
Application: Inventory
Source: Min-max planning report (XML)
Short Name: INVISMMX_XML
DB package: INV_INVISMMX_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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