SELECT hou.name operating_unit_name,
hou.organization_id operating_unit_id,
hou.set_of_books_id sob_id,
gsob.name sob_name,
ood.organization_name inv_org_name,
ood.organization_code inv_org_code,
ood.organization_id inv_org_id,
ood.chart_of_accounts_id
FROM hr_operating_units hou,
apps.org_organization_definitions ood,
apps.gl_sets_of_books gsob
WHERE 1 = 1
AND hou.organization_id = ood.operating_unit
AND hou.set_of_books_id = gsob.set_of_books_id
ORDER BY hou.organization_id ASC
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.