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