PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

PS/Query

edited Dec 9, 2013 11:35PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered
Hi All:

Is it possible to create a PS/Query using the following SQL:

select a.name as EmployeeName, a.supervisor_name as SupervisorName, b.name as NoteAddedBy,

    n.HR_NP_CREATE_DTTM as DateCreated, n.HR_NP_NOTE_ID as NoteId,

    n.HR_NP_SUBJECT as Subject, n.HR_NP_NOTE_TEXT as Text

    from ps_hr_np_note n

    , (select * from ps_employees x start with x.SUPERVISOR_ID = '648791' CONNECT BY prior x.EMPLID = x.SUPERVISOR_ID AND x.EMPLID <> X.SUPERVISOR_ID) a,

    ps_employees b  

where a.emplid = n.hr_np_note_key2

    and

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