select c.Table_name,c.column_name
from SYS.ALL_TAB_COLUMNS C
where C.COLUMN_NAME like '%CATEGORY_CODE%' and c.Table_name like 'FND_%'
----²éÕÒORG-ID LOcation_ID
Select aa.name,aa.organization_id,aa.location_id,aa.location_code
,aa.address_line_1 From HR_ORGANIZATION_UNITS_V aa Where aa.date_to Is Null
--
Select * From apps.ORG_ORGANIZATION_DEFINITIONS a Where a.DISABLE_DATE Is Null