Skip to Content
avatar image
Former Member

Where Used query including Resources

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers