Tuesday, 4 October 2016

Query to get Set of Books, Operating Unit, Organization data

/* 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

No comments:

Post a Comment