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!

Legal Entity of Person/Employee in R12

Discussion in 'Oracle Apps Technical' started by chester04, Mar 5, 2015.

  1. chester04

    chester04 Active Member

    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    100
    Hi All,

    I need help to create a query on how to get the legal entity of a person/employee.
    Or tables that link the legal entity to a person/employee in R12.

    Thank you in advance.

    BR,
    Chester
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi check SELECT * FROM xle_entity_profiles
     
    chester04 likes this.
  3. chester04

    chester04 Active Member

    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    100
    Thanks Jagadekara...
    But would you know how can I linked it to person/employee?
    Or any table in HR that has the details of legal entity?
     
  4. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    I am not sure, but hr_operating_units have default_legal_context_id, it may be the legal_entity_id.

    So you can get organization_id from this, then under that organization which are persons then those are under your legal entity.
     
  5. chester04

    chester04 Active Member

    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    100
    Thanks jagadekara...

    But I got different organization_id from the hr_operating_units and person (per_all_assgignments_f)
     
  6. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    hr_operating_units table have which organization id and per_all_assignments_f table have which organization id?