--------------------------------------------------------------------------
-- David Brown 27/9/02
-- Ver 1.1
-- david.brown@oracle.com
-- Report on workareas with the object versions they include
-- Note that a workarea can only have 1 version of an object, but a particular version of an object 
-- can be in more than 1 workarea
--
-- flavours of jr_name.get_label:- 
-- format is one of: 
--             'NAME' - returns only the names of object versions. For example: MYAPP/MY_FOLDER/DEPT. 
--             'BRANCH' - returns only the branch names on which the object versions are found. For example:
--             MYAPP{MAIN;3}/MY_FOLDER{MAIN;2}/DEPT{MAIN;10}. 
--             'VLABEL' - returns only the version labels of object versions. For example:
--             MYAPP{1.2}/MY_FOLDER{1.1}/DEPT{1.9}. 
--             'NAMETYPE' - returns the names and object types of object versions. For example:
--             MYAPP/MY_FOLDER/DEPT=Table. 
--             'BRANCHTYPE' - returns the names and branch types of object versions.
--             MYAPP{MAIN;3}/MY_FOLDER{MAIN;2}/DEPT{MAIN;10}=Table. 
--             'VLABELTYPE' - returns the names and version label types of object versions. For example:
--             MYAPP{1.2}/MY_FOLDER{1.1}/DEPT{1.9}=Table. 
--------------------------------------------------------------------------
set lines 240
set pages 80
set wrap off
set feedback off

ttitle left'Workarea Object Versions' skip 2



column Workarea format a30 heading Workarea


break on workarea

select 
w.name workarea
,jr_name.get_path(c.object_ivid,'VLABEL') Object
from 
i$sdd_wa_context c
,i$sdd_workareas w
where c.workarea_irid = w.irid
order by 1,2

spool wa_obj_ver.lis
/
spool off