Skip to Content
0
Jul 07, 2014 at 10:08 AM

BOM Components Forecast

18 Views

Hi all

Please help to rectify my Query for getting BOM Components based on MRP Forecast defined for BOM Parent Items

SELECT T1.[Father], T1.[ChildNum], T1.[Code], T1.[Quantity], T1.[Warehouse], T2.[ItemCode], T2.[Date], T2.[Quantity] FROM OITT T0 INNER JOIN ITT1 T1 ON T0.Code = T1.Father inner join FCT1 T2 on T0.Code=T2.ItemCode

Kedalene