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