Legal entity and Ledger relationship table

Legal entity and Ledger relationship table

In this post , We will be discussing about legal entity and ledger relationship table. There is a direct link between the legal entity and ledger in the organization structure of oracle apps. Legal Entity comes second from top and ledger comes third from top. We do create the Ledgers under legal entity in oracle apps. Here below I will share the legal entity and ledger relationship table sql join in oracle apps. Please find below complete information about legal entity and ledger relationship table.

Important legal entity and ledger relationship table

1.XLE_ENTITY_PROFILES

2.XLE_REGISTRATIONS

3.HR_LOCATIONS_ALL

4.GL_LEDGERS

5.HR_OPERATING_UNITS

SQL Query using the legal entity and ledger relationship table

select

  LEP.LEGAL_ENTITY_ID,

  LEP.name LEGAL_ENTITY,

  gl.name ledger_name,

  HRO.name OU_NAME

from apps.XLE_ENTITY_PROFILES LEP,

  apps.XLE_REGISTRATIONS REG,

  apps.HR_LOCATIONS_ALL HRL,

  apps.gl_ledgers gl,

  apps.HR_OPERATING_UNITS HRO

where LEP.TRANSACTING_ENTITY_FLAG      = 'Y'

and LEP.LEGAL_ENTITY_ID                = REG.SOURCE_ID

and REG.SOURCE_TABLE                   = 'XLE_ENTITY_PROFILES'

and HRL.LOCATION_ID                    = REG.LOCATION_ID

and REG.IDENTIFYING_FLAG               = 'Y'

and HRO.SET_OF_BOOKS_ID=GL.LEDGER_ID

and LEP.LEGAL_ENTITY_ID                = HRO.DEFAULT_LEGAL_CONTEXT_ID