--===========================================================================
-- Copywright 2002, Matthew Oldham  (m_olldham@yahoo.com)
--=============================================================================
-- DESCRIPTION: Shows Table Usages by Disscoverer Business Area
--
--=============================================================================
-- MODIFICATION HISTORY
-- Person      Date       Comments
-- ---------   ---------- --------------------------------------------
-- Matthew     07/17/2002 Initial Creatioon; 
--=============================================================================
column ba_name heading 'Business Area' format a40
column sobj_ext_table heading 'Table' format a30
column obj_ext_owner heading 'Table Owner' format a12

break on ba_name skip 1
ttitle 'Table Usages by Discoverer Business Area'

  select eul4_bas.ba_name, -- business area
         eul4_objs.sobj_ext_table, -- table name
         eul4_objs.obj_ext_owner -- object owner
    from eul4_bas, eul4_ba_obj_links, eul4_objs
   where eul4_bas.ba_id = eul4_ba_obj_links.bol_ba_id
     and eul4_objs.obj_id = eul4_ba_obj_links.bol_obj_id
     and eul4_objs.obj_ext_owner like upper('&owner')
order by 1,2
/