You are browsing the archive for Oracle Warehouse Management.

Scheduled Shipment Report

 

NAME: Scheduled Shipment Report
SHORT CODE: WMSSCHS
MODULE: Oracle Warehouse Management

Description: Scheduled Shipment Report for Direct Shipping
Navigation: Oracle Warehouse Management Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_ORG_CODE : Organization Code
  • P_CUSTOMER_NAME : Customer Name
  • P_SCHEDULE_SHIPMENT_FROM_DATE : Schedule Shipment Date From
  • P_SCHEDULE_SHIPMENT_TO_DATE : Schedule Shipment Date To
  • P_REQUEST_DATE_FROM : Requested Date From
  • P_REQUEST_DATE_TO : Requested Date To
  • P_DELIVERY_ID : Delivery Number
  • P_TRIP_ID : Trip Number
  • P_PROJECT : Project Number
  • P_TASK : Task Number
  • P_PRIOR_RES_FLAG : Print Prior Reservations Only
  • P_PRINT_CUS_PROD_DET : Print Customer Production Details

 

Register Custom API’s

 

NAME: Register Custom API’s
SHORT CODE: WMSRCAPI
MODULE: Oracle Warehouse Management

Description: Register Custom API’s
Navigation: Oracle Warehouse Management Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_hook_short_name_id : Short Name
  • p_call_package : Called Package
  • p_call_procedure : Called Procedure
  • p_call_description : Call Description
  • p_effective_to_date : Effective To Date
  • p_mode : Mode

 

Push Replenishment

 

NAME: Push Replenishment
SHORT CODE: WMSPUREPL
MODULE: Oracle Warehouse Management

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

Report Parameters:

  • p_organization_id :
  • p_item_id :
  • p_ABC_assignment_group_id :
  • p_abc_class_id :
  • p_Order_Type_id :
  • p_Customer_class :
  • p_customer :
  • p_Carrier_id :
  • p_Ship_Method_code :
  • p_Scheduled_Ship_Date_To :
  • p_Scheduled_Ship_Date_From :
  • p_Forward_Pick_Sub :
  • p_repl_UOM :
  • p_Repl_Lot_Size :
  • p_Min_Order_lines_threshold :
  • p_Min_repl_qty_threshold :
  • p_max_NUM_items_for_repl :
  • p_Sort_Criteria :
  • p_Release_Sequence_Rule_Id :
  • p_create_reservation :
  • p_Auto_allocate :
  • p_plan_tasks :