PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

PS Query - Use a subquery as a Select field in PS/Query

Hello,

We are on PS 8.58 Tools and PS 9.2. Need help on PS Query requirement. Can anyone tell me how to make subquery a select field in PS/Query? expression in PS Query has restrictions while adding from clause


Example

Select emplid,action ,(select Last_date_worked from ps_job k where k.emplid=j.emplid and k.last_date_worked=sysdate)

from ps_job J where J.EFFDT=(Select max(j1.effdt) from ps_job j1 where j1.emplid=j.emplid and j1.empl_rcd=j.empl_rcd and j1.effdt<=sysdate) followed with effseq logic etc.


Thank you,

Sudha

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center