| SOB & Operating Units [message #94989] |
Mon, 29 July 2002 18:06  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
