SELECT gl.set_of_books_id,
gl.name,
gl.short_name,
hou.name operatin_unit,
hou.organization_id operating_unit_id,
org.organization_name warehouse_name,
org.organization_id warehouse_id
FROM org_organization_definitions org,
hr_operating_units hou,
gl_sets_of_books gl
where org.operating_unit=hou.organization_id
and hou.set_of_books_id = gl.set_of_books_id
order by 1,3,6
gl.name,
gl.short_name,
hou.name operatin_unit,
hou.organization_id operating_unit_id,
org.organization_name warehouse_name,
org.organization_id warehouse_id
FROM org_organization_definitions org,
hr_operating_units hou,
gl_sets_of_books gl
where org.operating_unit=hou.organization_id
and hou.set_of_books_id = gl.set_of_books_id
order by 1,3,6
No comments:
Post a Comment