Human Capital Management - EBS (MOSC)

MOSC Banner

Varing Hirarchical Query

edited Apr 6, 2016 2:56AM in Human Capital Management - EBS (MOSC) Question

Dear all,

I have the data say as follows

Dept     

College of Sciences                 

     Physics 

     Chemistry

     Maths

College of Extra Studies          (Chairman College of Extra Studies )

     Physical Studies

     Life Sciences

     English

          English 1

          English 2

     Spanish

          Spanish 1

     Arabic

I have a requirement that if a student is in Physics , Chemistry, Maths -> His Chairman/Manager is Chairman Physics, Chairman Chemistry, Chairman Maths and So on.

and if a student is in  English1, English2,, Spanish 1 etc  -> His chairman is  Chairman English, Chairman Spanish

the sub departments below a depatment is variable ; for eg: English has 2 sub departments and Spanish has 1 sub department

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