mrp_forecast_interface方便整批建立forecast料號
1. 新增forecast
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 後既執行排程匯入動作.
