Oracle Apps Fusion Blog(Forms, Reports, Oracle Application Technical, SQL, PL/SQL, OAF)
(Move to ...)
Home
▼
Sunday, July 3, 2022
Query to get Legal Entity Name in Oracle Apps
SELECT hou.name operating_unit_name
,xep.name legal_entity_name
FROM hr_operating_units hou
,xle_entity_profiles xep
WHERE hou.default_legal_context_id = xep.legal_entity_id
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment