INV Min-max planning

➜ Back to Library
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
Run INV Min-max planning and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
 
Related Blitz Reports
BOM Bill of Material Structure GL Account Analysis (Distributions) RD INV Inventory Aging XXE4ARW Excel4apps Inventory Items GW Items INV Inventory Items CST Uninvoiced Receipts CST Inventory Value Report - by Subinventory (Item Cost) CST Inventory Value - Multi-Organization (Item Costs)
Blitz Report™

Blitz Report™ provides multiple benefits: