[MRP] MRP連結PO的SQL

SELECT PLL.*
FROM PO_LINE_LOCATIONS_ALL PLL ,
      MRP_RECOMMENDATIONS MR,
      MRP_ITEM_PURCHASE_ORDERS MIPO
WHERE PLL.PO_LINE_ID       = MIPO.LINE_ID
  AND MR.DISPOSITION_ID    = MIPO.TRANSACTION_ID
  AND MR.ORGANIZATION_ID   = PLL.ORG_ID
  AND MR.COMPILE_DESIGNATOR   = 'XXX-MRP'

MRP - mrp_forecast_interface

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 後既執行排程匯入動作.