R12 Sub Inventories

/* Formatted on 13-08-2011 23:54:52 (QP5 v5.115.810.9015) */
select a.name,a.organization_id opearting_unit from hr_operating_units a

SELECT   B.NAME OPERATING_UNIT,
         C.ORGANIZATION_CODE ORD_CODE,
         C.ORGANIZATION_NAME ORGANIZATION_NAME,
         SECONDARY_INVENTORY_NAME,
         DESCRIPTION
  FROM   mtl_secondary_inventories a,
         hr_operating_units B,
         ORG_ORGANIZATION_DEFINITIONS C
 WHERE       a.ORGANIZATION_ID = C.ORGANIZATION_ID
         AND B.ORGANIZATION_ID = C.OPERATING_UNIT
         AND C.ORGANIZATION_ID IN (103, 107, 111, 120, 125, 133, 138)
        
Select * from org_organization_definitions where organization_code like '%C%'