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

PRC: SQL to get the Cost Center Owner approver's email address on Requisitions



We are currently investigating the process of being able to extract the Cost Center Approver email address. The cost center owner approval is setup in the second stage of requisition approvals, however, we are not able to get the correct information to display. Please see the code below.

Content (required):

SQL was refined, and when searching for a specific requisition number, it only shows three records for all searches and requisitions (and there are more than that, that approved requisitions) - it also does not align with what is displayed on the front-end to the end-user. Please can someone assist in 'correcting' the SQL, or correcting the tables/fields used.

Howdy, Stranger!

Log In

To view full details, sign in.


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