Weekly Stock on Hand and Retail Value Update for Item/Location (hstwkupd)
|
Module Name |
hstwkupd.pc |
|
Description |
Weekly Stock on Hand and Retail Value Update for Item/Location |
|
Functional Area |
Sales History |
|
Module Type |
Business Processing |
|
Module Technology |
ProC |
|
Catalog ID |
RMS159 |
|
Wrapper Script |
rmswrap_multi.ksh |
Design Overview
This program runs weekly to update the current stock on hand, retail values and average cost for each item/location on ITEM_LOC_HIST is using SQL*Loader (hstwkupd.ctl). The program must be run on the last day of the week as scheduled.
Restart/Recovery
The logical unit of work for HSTWKUPD is item/location. The program is threaded by location using the v_restart_store_wh view.