select msi.secondary_inventory_name,msi.description,
ood.ORGANIZATION_ID,ood.ORGANIZATION_NAME,ood.OPERATING_UNIT, hou.name ouname ,ood.SET_OF_BOOKS_ID,sob.name sobname
from apps.mtl_secondary_inventories msi,
org_organization_definitions ood,
hr_operating_units hou,gl_sets_of_books sob
where msi.organization_id=ood.ORGANIZATION_ID and
ood.OPERATING_UNIT=hou.organization_id and
ood.SET_OF_BOOKS_ID=sob.set_of_books_id[@more@]