work order cost value and compare quantity with standard quantity(manufacturing)

Summary:

i need a query statement to get work order cost value and compare quantity with standard quantity.

i tried to get standard quantity but u can't find a table contain this value .

if i get from work definition user can change quantity after work order complete

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):