CREATE TABLE CUX.XX_APSP0058(
INVENTORY_ITEM_ID NUMBER,
ORGANIZATION_ID NUMBER,
ORG VARCHAR2(10 BYTE),
INVENTORY_ITEM VARCHAR2(20 BYTE),
TYPE VARCHAR2(1 BYTE),
MRPFRIDAY DATE,
MRPWEEKS NUMBER,
CREATION_DATE DATE,
CREATED_BY NUMBER,
LAST_UPDATE_DATE DATE,
LAST_UPDATE_LOGIN NUMBER,
LAST_UPDATED_BY NUMBER
)
MRPFRIDAY
SELECT
(((TRUNC(TRUNC(SYSDATE,'MM')+1,'WW')+5) -
(TRUNC(TRUNC(SYSDATE,'YY')+1,'WW')+5))/7)
FROM DUAL;
W0 W1 W2 W3 W4 W5 W6 W7 W8 W9 W10 W11 W12 W13 W14 W15 W16 W17 W18 W19 W20 W21 W22 W23 W24 W25
Org ITEM_SEGMENTS Type ORDER_TYPE_TEXT 10/26 11/2 11/9 11/16 11/23 11/30 12/7 12/14 12/21 12/28 1/4 1/11 1/18 1/25 2/1 2/8 2/15 2/22 3/1 3/8 3/15 3/22 3/23 3/24 3/25 3/26
T21 90-C1CP2U-L0UANAYZ
(EBS)Supply Intransit shipment 0 8000 0 2000 2000
(EBS)Demand Manual Demand -7530 -1530 -6530 -1030 -3000 -2000
(EBS)Supply On Hand 2640
(EBS)Supply Purchase requisition 500
(EBS)Demand Sales Orders -4200
(EBS)Check Point Safety Stock -5490 -5160 -11000 -11380
(PAB+ Supply - Demand - Safety Stock <0 br="br" nbsp="nbsp" order="order" planned="planned">(TPM View) 1560 1060
(Supply - Demand + Planned Order) "Projected Available Balance
(PAB)" 0 470 0 0 970 0 0 5490 5160
Lead Time (W7) Hub Demand (SPM View) 15640 1000
如何區分 AIR/Sea? Ignore 1560 =1560+0
Air 9620 =1060+4530+0+2030+2000
Sea 6020 =6020
1 開 26 周
2 Demand 要以 負數 表示
3 Lead Time: 設定在 XX_APS_SS_WEEK, 不分 EMS, 但, 要考慮各 Product Line 的起始分量周別不同
4 Planned Order 算法, 以12/21 為例
前期期末 5490
Manual -1330 = 4160
因 4160 低於 當期 ss 的要求: 5160, 故產生 Planned Order 1000
5 Planned Order (TPM View) 要剔除 W0, W1
6 Air/ Sea 要如何區分? 以及如何呈現在 PM Allocation 的畫面? <== Irene 會與 RON 討論
7 原本不同語言別的替代出貨功能, 是否保留? <==暫不用
8 計算後, 資料要拋至 Demantra & PM Allocation & EMS Forecast 介面
INVENTORY_ITEM_ID NUMBER,
ORGANIZATION_ID NUMBER,
ORG VARCHAR2(10 BYTE),
INVENTORY_ITEM VARCHAR2(20 BYTE),
TYPE VARCHAR2(1 BYTE),
MRPFRIDAY DATE,
MRPWEEKS NUMBER,
CREATION_DATE DATE,
CREATED_BY NUMBER,
LAST_UPDATE_DATE DATE,
LAST_UPDATE_LOGIN NUMBER,
LAST_UPDATED_BY NUMBER
)
MRPFRIDAY
SELECT
(((TRUNC(TRUNC(SYSDATE,'MM')+1,'WW')+5) -
(TRUNC(TRUNC(SYSDATE,'YY')+1,'WW')+5))/7)
FROM DUAL;
W0 W1 W2 W3 W4 W5 W6 W7 W8 W9 W10 W11 W12 W13 W14 W15 W16 W17 W18 W19 W20 W21 W22 W23 W24 W25
Org ITEM_SEGMENTS Type ORDER_TYPE_TEXT 10/26 11/2 11/9 11/16 11/23 11/30 12/7 12/14 12/21 12/28 1/4 1/11 1/18 1/25 2/1 2/8 2/15 2/22 3/1 3/8 3/15 3/22 3/23 3/24 3/25 3/26
T21 90-C1CP2U-L0UANAYZ
(EBS)Supply Intransit shipment 0 8000 0 2000 2000
(EBS)Demand Manual Demand -7530 -1530 -6530 -1030 -3000 -2000
(EBS)Supply On Hand 2640
(EBS)Supply Purchase requisition 500
(EBS)Demand Sales Orders -4200
(EBS)Check Point Safety Stock -5490 -5160 -11000 -11380
(PAB+ Supply - Demand - Safety Stock <0 br="br" nbsp="nbsp" order="order" planned="planned">(TPM View) 1560 1060
(Supply - Demand + Planned Order) "Projected Available Balance
(PAB)" 0 470 0 0 970 0 0 5490 5160
Lead Time (W7) Hub Demand (SPM View) 15640 1000
如何區分 AIR/Sea? Ignore 1560 =1560+0
Air 9620 =1060+4530+0+2030+2000
Sea 6020 =6020
1 開 26 周
2 Demand 要以 負數 表示
3 Lead Time: 設定在 XX_APS_SS_WEEK, 不分 EMS, 但, 要考慮各 Product Line 的起始分量周別不同
4 Planned Order 算法, 以12/21 為例
前期期末 5490
Manual -1330 = 4160
因 4160 低於 當期 ss 的要求: 5160, 故產生 Planned Order 1000
5 Planned Order (TPM View) 要剔除 W0, W1
6 Air/ Sea 要如何區分? 以及如何呈現在 PM Allocation 的畫面? <== Irene 會與 RON 討論
7 原本不同語言別的替代出貨功能, 是否保留? <==暫不用
8 計算後, 資料要拋至 Demantra & PM Allocation & EMS Forecast 介面
沒有留言:
張貼留言