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

NAME: Calculate Failure Rates
SHORT CODE: CSPPLFRT
MODULE: Oracle Spares Management

Description: Calculates Failure Rates
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_level_id : Planning Node Identifier
• p_api_version :

NAME: Create Excess/Defective Lists
SHORT CODE: CSPPLEXC1
MODULE: Oracle Spares Management

Description: Create Excess/Defective Lists
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