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
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 NameSQL textValidation
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 CST Subinventory Account Value - Multi-Org XXE4ARW Excel4apps Inventory Items (1) GW Items XXE4ARW Excel4apps Inventory Items (2) PO Approved Supplier List Upload RD INV Inventory Aging GL Account Analysis INV Inventory Aging
Blitz Report™