cost organization- inventory

Summary:

we are trying to build BIP inventory report, we need to add “Cost Organization”? is there any way ?

For example in the case of PTO “Valuation Unit” the “Cost Organization” is CO-US-100

For JPO “Valuation Unit” the “Cost Organization” is CO-JP-600

For TJP “Valuation Unit” the “Cost Organization” is CO-US-102

Let me know if you have any sql for this ?

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):