2008年10月1日 星期三

MRP - mrp_forecast_interface

mrp_forecast_interface方便整批建立forecast料號
1. 新增forecast

image

2. Insert mrp_forecast_interface

insert into mrp_forecast_interface
(ORGANIZATION_ID, -- INV ORG.
INVENTORY_ITEM_ID, -- ITEM ID
FORECAST_DESIGNATOR, -- forecast name ex. test1
FORECAST_DATE,
QUANTITY,
PROCESS_STATUS, -- 2
CONFIDENCE_PERCENTAGE, -- 100
LAST_UPDATE_DATE, -- sysdate
LAST_UPDATED_BY, -- user id
CREATION_DATE, -- sysdate
CREATED_BY) -- user id

3. commit 後既執行排程匯入動作.