on 07-07-2014 11:08 AM
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
Hi,
Try this query:
SELECT T0.[Code], T1.[ItemCode], T3.[Code],T3.[ChildNum], T3.[Quantity], T3.[Warehouse], T1.[Date], T1.[Quantity] FROM OFCT T0 left join FCT1 T1 on t0.absid = t1.absid left join OITT T2 on T2.[Code] = t1.itemcode INNER JOIN ITT1 T3 ON T2.Code = T3.Father
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
I add a new inner join:
inner join OFCT T3 on T2.absid = T3.absid
And a "where" condition to select the forecast:
where T3.name = [%0]
Your query shows all items in all forecast.
Kind regards
Agustín Marcos Cividanes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.