Saturday, 5 March 2022

query to get legal entity and business Unit name

SELECT

hou.name BU_NAME,

hou.SHORT_CODE ,

le.NAME Legal_ENtity,

led.NAME Ledger_Name

FROM

hr_operating_units hou,

xla_gl_ledgers led,

Xle_entity_profiles le

WHERE

hou.default_legal_context_id = le.legal_entity_id

AND led.ledger_id = hou.set_of_books_id

No comments:

Post a Comment