Wednesday, March 27, 2013

OU-SOB-INVORG Details



  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.