Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Determine the Requisitionning & procurement BU on a requisition

edited Sep 9, 2019 12:09AM in Self Service Procurement 2 comments

Summary

Determine the Requisitionning &procurement BU on a requisition

Content

Hello all,

I have 2 questions
1) I would like to run some statistics on what the procurement BU is on all our requisitions  by querying the requisition header table (in R12) however the Procurement BU ID seems to be empty in most cases. How can i find this data?

2) Which requisition table holds the requisitioning BU name? or is it only "fun_all_business_units_v" to find the name?

Thanks

 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!