Re: Shared Entities in Des2000-Repository

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Thu, 22 Apr 1999 09:51:22 +0200
Message-ID: <371ED4FA.B2A41004_at_vnl.nl>

Peter,

this is a generic script:
select

  o.el_name||' ('|| o.el_version||')' "From"
, s.el_name||' ('|| s.el_version||')' "Shared into"
, e.el_name Name
, e.el_type_of Type
from SDD_ELEMENTS E
   , SDD_ELEMENTS O

   , SDD_ELEMENTS S
   , SDD_STRUCTURE_ELEMENTS
where str_use_of = e.el_id
and E.EL_ELEM_OWNED_BY = to_number('&&Application_Id') and STR_PART_OF <> to_number('&&Application_Id') and SUBSTR(STR_TYPE_OF,0,3) = 'APP'
and S.EL_ID = STR_PART_OF
and O.EL_ID = E.EL_ELEM_OWNED_BY
order by 2, 3, 4
/

Application_Id is the id of the applicatio/version you want from ci_application_systems
(Yes, you could rewrite that...)

Peter Buzanits wrote:

> I am looking for a view in the Des2000-repository, which displays the
> shared entities in an application system. I only find the regular
> entities in ci_entities which can be joined to the application system
> with the "application_system_owned_by"-reference.
>
> So I can query all regular enities of an AppSys. But how to query the
> entities shared into an AppSys? I looked into the diagrams shipped with
> Des2000 but didn't find anything...
>
> Thanks a lot for any help,
> Peter Buzanits
> ETM AG Austria
> http://www.etm.at
> --
> ---------------------------------------------------
> DI Peter Buzanits
> mailto:peter_at_icb.co.at http://peter.icb.co.at
> AOL-IM: Buzanits Keys available on PGP-Servers
> ---------------------------------------------------

--
Met vriendelijke groet,
kind regards,

Frank van Bortel
Technical consultant Oracle
V&L Informatica BV
-----------------------------------------------
Work                           Home
Postbus 545                    Hunzestraat 4
7500 AM Enschede               7555 WB Hengelo
(31)53.434.1500                (31)74.242.5046

Received on Thu Apr 22 1999 - 09:51:22 CEST