Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Need help to build the sql logic — 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

Need help to build the sql logic

Accepted answer
edited Apr 20, 2022 9:13AM in Reporting and Analytics for HCM 3 comments


Hi Team,

I am working on a requirement for position incumbent. Here my code will get each positon with vacant positon details. And for each position one record I am getting. My requirement is, I want to print the each position multiple time as per the vacant positions avaiable.

Eg; Position ABC having 3 vacant position and the output coming in one line as per the existing code. I want to print the Position records 3 times instad of once based on the vacant position.

I have tried many ways but failing to build this logic.

Please review the attached sql and let me know the logic.

Howdy, Stranger!

Log In

To view full details, sign in.


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