Skip to Content

Where Used query including Resources

Jan 13, 2017 at 12:40 PM


avatar image
Former Member

I have a where used query that works really well if needed to locate any given itemcode within a BoM, however, most of my BoM's include resources and I now need to include Resource. Can anyone help update the query below to include the ORSC table? (if this is the correct table)

SELECT T0.Code AS 'BOM Component', T2.ItemName AS 'BOM Comp Description', T0.Father AS 'BOM Product Num', T0.Quantity AS 'Comp Qty', T0.Price AS 'Comp Cost', T0.PriceList AS 'Comp Price List', T1.ListName AS 'Price List Name' FROM ITT1 T0 LEFT OUTER JOIN OPLN T1 ON T0.PriceList = T1.ListNum LEFT OUTER JOIN OITM T2 ON T0.Code = T2.ItemCode WHERE (T0.Code LIKE '%%[%1]%%' OR '[%1]' = ' ') ORDER BY T0.Code, T0.Father FOR BROWSE

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers