Shipping Purge

 

NAME: Shipping Purge
SHORT CODE: WSHPURGE
MODULE: Oracle Shipping

Description: Program to purge shipping entities
Navigation: Oracle Shipping Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_execution_mode : Execution Mode
  • p_source_system : Source System
  • p_ship_from_org : Ship From Org
  • p_order_number_from : Order Number From
  • p_source_system_dummy : To get source system of Order Number From
  • p_order_number_to : Order Number To
  • p_dummy_order : Dummy to make Order Number To mandatory
  • p_order_type : Order Type
  • p_ship_date_from : Ship Date From
  • p_ship_date_to : Ship Date To
  • p_dummy_ship_date : Dummy Ship Date
  • p_delete_beyond_x_ship_days : Delete beyond X ship days
  • p_dummy_x_ship_days : dummy to make x ship days mandatory
  • p_purge_intransit_trips : Purge In Transit Trips
  • p_delete_empty_records : Delete Empty Records
  • p_create_date_from : Create Date From
  • p_create_date_to : Create Date To
  • p_dummy_create_date : Dummy Create Date
  • p_del_beyond_creation_days : Delete Beyond X creation days
  • p_dummy_x_create_days : dum

 

Leave a reply

Your email address will not be published. Required fields are marked *