Get Operating Unit & Legal Entity
Posted by
Jiltin 12 March, 2008 3,050 views
- Oracle Applications : Steps for Creating New Operating Unit in a multi org set up.
- Set an OPERATING UNIT
- How do you check the profile option values using sql – Oracle Applications?
- General Ledger in Release 12 – New/changed features
- How To Add Responsibility to USER using pl/sql? – Oracle Applications
Following script extracts the operating unit and legal entities from oracle applications
————————————————————————-
— Author : Jay
————————————————————————-
SELECT
hr.name operating_unit,
hr.organization_id org_id,
le.name legal_entity_name,
decode(ar.set_of_books_id,‘-1′,‘No’,NULL,‘No’,‘Yes’) system_option_defined
FROM
hr_operating_units hr,
hr_all_organization_units_tl le,
ar_system_parameters_all ar
WHERE le.organization_id = to_number(hr.legal_entity_id)
AND le.LANGUAGE = userenv(‘LANG’)
AND hr.organization_id = ar.org_id(+)
ORDER BY 2;
— Author : Jay
————————————————————————-
SELECT
hr.name operating_unit,
hr.organization_id org_id,
le.name legal_entity_name,
decode(ar.set_of_books_id,‘-1′,‘No’,NULL,‘No’,‘Yes’) system_option_defined
FROM
hr_operating_units hr,
hr_all_organization_units_tl le,
ar_system_parameters_all ar
WHERE le.organization_id = to_number(hr.legal_entity_id)
AND le.LANGUAGE = userenv(‘LANG’)
AND hr.organization_id = ar.org_id(+)
ORDER BY 2;
Categories :
11i Scripts
This script does not work.
LEGAL_ENTITY_ID does not exist in HR_OPERATING_UNITS
Thanks
Tim