Home » Applications » Oracle Fusion Apps & E-Business Suite » SOB & Operating Units
SOB & Operating Units [message #94989] Mon, 29 July 2002 18:06 Go to next message
ram
Messages: 95
Registered: November 2000
Member
How do I find the link between SOB and Operating units? Is there any table that gives this info? I want to display all the OUs that belong to one SOB.
Re: SOB & Operating Units [message #94990 is a reply to message #94989] Mon, 29 July 2002 23:40 Go to previous message
Daniel Somogyi
Messages: 13
Registered: July 2002
Junior Member
Hi,

try this SElECT, it should give you what you need :)

Dany

SELECT HR_OPERATING_UNITS.NAME ORG_NAME,
HR_OPERATING_UNITS.ORGANIZATION_ID ORG_ID,
HR_OPERATING_UNITS.SET_OF_BOOKS_ID SET_OF_BOOKS,
GL.GL_SETS_OF_BOOKS.NAME,
GL.GL_SETS_OF_BOOKS.DESCRIPTION,
GL.GL_SETS_OF_BOOKS.CURRENCY_CODE
FROM
APPS.HR_OPERATING_UNITS
HR_OPERATING_UNITS,
HR.HR_ORGANIZATION_INFORMATION
HR_ORGANIZATION_INFORMATION,
GL.GL_SETS_OF_BOOKS
WHERE
HR_OPERATING_UNITS.ORGANIZATION_ID = HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID
AND ((HR_ORGANIZATION_INFORMATION.ORG_INFORMATION_CONTEXT='Operating Unit Information'))
AND GL.GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID = HR_OPERATING_UNITS.SET_OF_BOOKS_ID
ORDER BY HR_OPERATING_UNITS.SET_OF_BOOKS_ID
Previous Topic: General Ledger Interface (gl_interface) program
Next Topic: copying database
Goto Forum:
  


Current Time: Thu Mar 28 17:27:20 CDT 2024