You are browsing the archive for Oracle Inventory.

by oracleguru

Min-max planning report

ORACLE APPS COMMUNITY > Tutorial > Logistics & Warehouse > Oracle Inventory

 

NAME: Min-max planning report
SHORT CODE: INVISMMX
MODULE: Oracle Inventory

Description: Min-max planning report
Navigation: Oracle Inventory 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 : 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 Unreserved Orders
  • P_NET_RSV : Net Rese

 

Tags: No Comments »

by oracleguru

Lot And Serial Date Notification

ORACLE APPS COMMUNITY > Tutorial > Logistics & Warehouse > Oracle Inventory

 

NAME: Lot And Serial Date Notification
SHORT CODE: INVLSDAT
MODULE: Oracle Inventory

Description: Lot And Serial Date Notification
Navigation: Oracle Inventory Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Organization : Organization
  • Structure_ID : Structure ID
  • Item_Category : Item Category
  • Item_Low : Item (From)
  • Item_High : Item (To)
  • Lot_Serial : Lot or Serial
  • Lot_Number_Low : Lot Number (From)
  • Lot_Number_High : Lot Number (To)
  • Serial_Number_Low : Serial Number (From)
  • Serial_Number_High : Serial Number (To)
  • Date_Context : Date Context
  • Date_Type : Date Type
  • Days_In_Future : Days In Future
  • Days_In_Past : Days In Past
  • Include_Zero_Balance : Include Zero Balances

 

Tags: No Comments »

by oracleguru

Material Status Where-Used Report

ORACLE APPS COMMUNITY > Tutorial > Logistics & Warehouse > Oracle Inventory

 

NAME: Material Status Where-Used Report
SHORT CODE: INVMSWHU
MODULE: Oracle Inventory

Description: Material Status Where-Used Report
Navigation: Oracle Inventory Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_ORG : Organization
  • P_ONH_STATUS_ENABLED_FLAG : Flag to enable/disable the onhand status flag
  • P_MS_LO : Material Status From
  • P_MS_HI : Material Status To
  • P_SEARCH_SUB : Search Subinventories
  • P_SEARCH_LOC : Search Locators
  • P_SEARCH_LOT : Search Lots
  • P_SEARCH_SER : Search Serials
  • P_SEARCH_ONH : Search Onhand

 

Tags: No Comments »