JOIN between PER_ALL_PEOPLE_F and HR_ALL_ORGANIZATION_UNITS

in Oracle E-Business Suite & Oracle Fusion Applications; My goal is to find the organization of each employee, does anybody know how to join PER_ALL_PEOPLE_F and HR_ALL_ORGANIZATION_UNITS for ...
+ Post Reply + Post New Topic
Results 1 to 7 of 7
  1. #1
    nestor is offline Junior Member
    Points: 620, Level: 12
    Join Date
    16 Sep 2010
    Posts
    28
    Points
    620

    JOIN between PER_ALL_PEOPLE_F and HR_ALL_ORGANIZATION_UNITS

    My goal is to find the organization of each employee, does anybody know how to join PER_ALL_PEOPLE_F and HR_ALL_ORGANIZATION_UNITS for me to be able to get the organization_id and organization name of each person. Please help


  2. #2
    srinivas_apps is offline Junior Member
    Points: 80, Level: 1
    Join Date
    14 Feb 2009
    Posts
    4
    Points
    80

    Re: JOIN between PER_ALL_PEOPLE_F and HR_ALL_ORGANIZATION_UNITS

    per_all_people_f - person_id
    per_all_assignments_f - person_id,organization_id
    hr_all_organization_units - organization_id

    assignments table is where you get the org id and join it with organization units. hope it helps.
    nestor says Thanks.

  3. #3
    nestor is offline Junior Member
    Points: 620, Level: 12
    Join Date
    16 Sep 2010
    Posts
    28
    Points
    620

    Re: JOIN between PER_ALL_PEOPLE_F and HR_ALL_ORGANIZATION_UNITS

    Thank you for a helping hand even if i am not an indian. More power to you sir. I will be posting another question and i hope you'll still offer the same help

  4. #4
    Sadik's Avatar
    Sadik is offline Administrator
    Points: 35,670, Level: 100
    Join Date
    03 Aug 2008
    Location
    Kolkata, India
    Posts
    1,863
    Points
    35,670

    Re: JOIN between PER_ALL_PEOPLE_F and HR_ALL_ORGANIZATION_UNITS

    Quote Originally Posted by nestor View Post
    Thank you for a helping hand even if i am not an indian.
    Nester, this forum is not only for Indians, more than half members are not indians, I don't know where you got that from?
    Learn Oracle with Oracle forum. Check out General Discussion Forums

  5. #5
    nestor is offline Junior Member
    Points: 620, Level: 12
    Join Date
    16 Sep 2010
    Posts
    28
    Points
    620

    Re: JOIN between PER_ALL_PEOPLE_F and HR_ALL_ORGANIZATION_UNITS

    Sorry for that statement sir. I just thought that most of the members are indian. I hope you guys don't get offended by that statement.

  6. #6
    Sadik's Avatar
    Sadik is offline Administrator
    Points: 35,670, Level: 100
    Join Date
    03 Aug 2008
    Location
    Kolkata, India
    Posts
    1,863
    Points
    35,670

    Re: JOIN between PER_ALL_PEOPLE_F and HR_ALL_ORGANIZATION_UNITS

    Quote Originally Posted by nestor View Post
    Sorry for that statement sir. I just thought that most of the members are indian. I hope you guys don't get offended by that statement.
    Oh no need for apology... My apologies if my comment was harsh!
    Learn Oracle with Oracle forum. Check out General Discussion Forums

  7. #7
    srinivas_apps is offline Junior Member
    Points: 80, Level: 1
    Join Date
    14 Feb 2009
    Posts
    4
    Points
    80

    Re: JOIN between PER_ALL_PEOPLE_F and HR_ALL_ORGANIZATION_UNITS

    any time Nestor!!

Other Solutions
  1. Dependent package list of per_all_people_f table
    By katripon in forum Oracle HRMS & Payroll
    Replies: 3
    Last Post: 12-17-2013, 10:08 AM
  2. SQL Join two tables
    By virusx1984 in forum Oracle Database
    Replies: 7
    Last Post: 03-02-2011, 02:17 PM
  3. Dis-JOIN-ted..
    By reylliam in forum SQL PL/SQL
    Replies: 7
    Last Post: 02-26-2011, 03:33 AM
  4. Replies: 10
    Last Post: 09-23-2010, 08:30 AM
  5. Join in TopLink
    By callme_harry in forum Oracle Forms and Reports
    Replies: 4
    Last Post: 11-14-2008, 04:39 AM