Calculate Net Inventory (replroq.ksh)
|
Module Name |
replroq.ksh |
|
Description |
Calculate Net Inventory |
|
Functional Area |
Replenishment |
|
Module Type |
Business Processing |
|
Module Technology |
ksh |
|
Catalog ID |
RMS308 |
|
Wrapper Script |
rmswrap_shell.ksh |
Design Overview
This module performs the bulk of the logic to process and persist the replenishment data into replenishment net inventory temp table. (The information on this table is extracted by the reqext batch program.)
The wrapper script does the following things:
-
Insert records into the staging table and determines the thread id of each record.
-
Retrieves the max concurrent thread from to determine the maximum number of concurrent process the wrapper should run at a time.
-
Moves the records from a staging table to a temporary table and will calculate the net inventory position and determine the ROQ of items which are on replenishment.
The pre-processing function of this batch program in prepost truncates the records from the replenishment net inventory temp tables, and builds replenishment distribution temp and replenishment allocation in temp tables.