Create Min-Max Report

 

NAME: Create Min-Max Report
SHORT CODE: CSPPLMMX
MODULE: Oracle Spares Management

Description: Min-max planning report
Navigation: Oracle Spares Management Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_ORG_ID : Organization
  • P_LEVEL_ID : Planning node identifier
  • P_LEVEL : Planning Level
  • P_SUBINV_ENABLE_FLAG : Flag to enable/disable the subinventory parameter
  • P_SUBINV : Subinventory
  • P_SELECTION : Selection
  • P_CAT_SET_ID : Category Set
  • P_CATG_STRUCT_ID : Category Structure
  • P_CATG_LO : Category Low
  • P_CATG_HI : Category High
  • P_ITEM_LO : Item Low
  • P_ITEM_HI : Item High
  • P_PLANNER_LO : Planner Low
  • P_PLANNER_HI : Planner High
  • P_BUYER_LO : Buyer Low
  • P_BUYER_HI : Buyer High
  • P_SORT : Sort by
  • P_D_CUTOFF : Demand Cutoff Date
  • P_D_CUTOFF_REL : Demand Cutoff Date Offset
  • P_S_CUTOFF : Supply Cutoff Date
  • P_S_CUTOFF_REL : Supply Cutoff Date Offset
  • P_USER_ID : User ID
  • P_RESTOCK : Restock
  • P_HANDLE_REP_ITEM : For Repetitive Item
  • P_DD_LOC_ID : Default Delivery To
  • P_NET_UNRSV : Net

 

Leave a reply

Your email address will not be published. Required fields are marked *