1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Query to fetch employee details

Discussion in 'Oracle Apps Technical' started by sushantsharma, May 4, 2015.

  1. sushantsharma

    sushantsharma Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    75
    Location:
    Delhi
    The following is a Query to fetch employee details in Oracle HRMS

    Code (SQL):
    SELECT   papf.person_id         person_no
            ,papf.employee_number   empno
            ,papf.full_name         emp_name
            ,papf.date_of_birth     dob
            ,pj.job_id          job_no
            ,pj.name            job_name
            ,pap.position_id        position_no
            ,pap.name           position_name
            ,pbg.business_group_id  bg_no
            ,pbg.name           bg_name
            ,ppt.user_person_type       person_type
    FROM         per_all_people_f       papf       
            ,per_all_assignments_f  paaf
            ,per_jobs           pj
            ,per_all_positions      pap
            ,per_business_groups        pgb
            .per_person_types       ppt
    WHERE       papf.person_id         =   paaf.person_id
    AND     pj.job_id(+)           =   paaf.job_id
    AND     pap.position_id(+)     =    paaf.position_id
    AND     pbg.business_group_id   =   papf.business_group_id
    AND     papf.person_type_id     =       ppt.person_type_id
    AND     pbg.business_group_id   = '7911'
    ORDER       BY papf.employee_number ;