/* Formatted on 10/3/2016 8:38:19 PM (QP5 v5.114.809.3010) */
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
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
No comments:
Post a Comment