Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
PRC: SQL to get the Cost Center Owner approver's email address on Requisitions — Cloud Customer Connect
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

Question
1
Views
0
Comments

Summary:

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.

Register

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