You are browsing the archive for Oracle Warehouse Management.

Calculate Averages of Actual Times

 

NAME: Calculate Averages of Actual Times
SHORT CODE: WMS_LMS_CALC_ACTUALS
MODULE: Oracle Warehouse Management

Description: Concurrent Program to calculate Actual Timings
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_id : Organization id

 

Launch Task Release

 

NAME: Launch Task Release
SHORT CODE: WMS_LAUNCH_TASK_RELEASE
MODULE: Oracle Warehouse Management

Description:
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 : Organization id
  • p_query_name : Control Board Saved Query
  • p_task_release_id : Task Release Criteria ID

 

Generate LPN

 

NAME: Generate LPN
SHORT CODE: WMS_GENERATE_LPN
MODULE: Oracle Warehouse Management

Description: Generate LPN
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_api_version : API Version
  • p_organization_id : Organization
  • p_container_item_id : Container Item
  • p_revision : Revision
  • p_lot_number : Lot Number
  • p_from_serial_number : Serial From
  • p_to_serial_number : Serial To
  • p_subinventory : Subinventory
  • p_locator_id : Locator ID
  • p_org_parms : Organization Parameters
  • p_org_dummy : Org Dummy
  • p_total_length : Total Length
  • p_lpn_prefix : LPN Prefix
  • p_starting_num : Starting Number
  • p_ucc_128_suffix : UCC 128 Suffix Flag
  • p_fld_dummy : Fld Dummy
  • p_lpn_suffix : LPN Suffix
  • p_quantity : Quantity
  • p_source : Source
  • p_cost_group_id : Cost Group ID
  • p_client_code : Client Code