Monday, January 11, 2016

Oracle Application r12: Query to fetch Legal entity for Operating Unit

In R12 use below query to fetch Legal entity details for Operating Unit
 
Select a.organization_id, 
          a.organization_code, 
          a.organization_name, 
          a.operating_unit, 
          b.name OU, 
          a.set_of_books_id,
          d.name LEDGER,
          a.legal_entity,
          c.name LE_NAME
From apps. ORG_ORGANIZATION_DEFINITIONS a,
         apps. HR_OPERATING_UNITS b,
         apps. xle_entity_profiles c,
         apps. gl_ledgers d
Where a.operating_unit=b.organization_id
and    C.LEGAL_ENTITY_ID=a.LEGAL_ENTITY
AND    d.ledger_id=a.set_of_books_id;