Clarity

 View Only
  • 1.  Task dependencies

    Posted Aug 11, 2009 10:07 AM
    Hi:       In OWB there is a view called "Dependence definition" that shows the task and task dependencies.  Do you know some NSQL that returns some data like it ?  Thanks  Fernando


  • 2.  Re: Task dependencies

    Posted Aug 11, 2009 01:43 PM
    Try querying PRDEPENDENCY and Tech Ref for its field definitions  Martti K. Message Edited by another_martink on 08-11-2009 05:42 PM [left]


  • 3.  Re: Task dependencies

    Posted Aug 12, 2009 10:18 AM
    Hi,  Set sql trace for an user and then  access owb via clarity project and check the dependency view.you will get all the sql you want.Modify according to your need and use in the nsql.    regards,sundar


  • 4.  Re: Task dependencies

    Posted Aug 13, 2009 02:59 PM
    try this as a start  select
      pred.prexternalid
    , pred.prname
    , dtype.name
    , succ.prexternalid
    , succ.prname
    , dep.*
    from prdependency dep
    join prtask pred on pred.prid = dep.prpredtaskid
    join prtask succ on succ.prid = dep.prsucctaskid
    -- check data type of dtype.lookup_code = dep.prtype
    join cmn_lookups_v dtype on (dtype.lookup_code = dep.prtype and lookup_type = 'prDependencyType' and language_code = 'en')