AnsweredAssumed Answered

Locks at database level [URGENT]

Question asked by mcanovas on Feb 1, 2013
Latest reply on Feb 4, 2013 by another_martink
Dear friends,

Our DBA are reporting that there are some locking sessions, when this happens the we have problems with clarity performance.

we have Clarity 13.0.1.0101 05 (V13 SP5).
Anyone can help us to determine why locks occur?.


We have some queries to get some information about those locked sessions:
SQL> SELECT *
  2  FROM   (SELECT DISTINCT s1.inst_id,
  3                          s1.sid
  4          FROM   gv$lock l1,
  5                 gv$session s1,
  6                 gv$lock l2,
  7                 gv$session s2
8          WHERE  s1.sid = l1.sid
  9                 AND s2.sid = l2.sid
10                 AND l1.BLOCK = 1
11                 AND l2.request > 0
12                 AND l1.id1 = l2.id1
13                 AND l2.id2 = l2.id2
14                 AND l1.inst_id = s1.inst_id
15                 AND l2.inst_id = s2.inst_id
16          UNION
17          SELECT DISTINCT s2.inst_id,
18                          s2.sid
19          FROM   gv$lock l1,
20                 gv$session s1,
21                 gv$lock l2,
22                 gv$session s2
23          WHERE  s1.sid = l1.sid
24                 AND s2.sid = l2.sid
25                 AND l1.BLOCK = 1
26                 AND l2.request > 0
27                 AND l1.id1 = l2.id1
28                 AND l2.id2 = l2.id2
29                 AND l1.inst_id = s1.inst_id
30                 AND l2.inst_id = s2.inst_id) q
31  ORDER  BY q.inst_id,
32            q.sid;
 
   INST_ID        SID
---------- ----------
         1        183
        1        201
         1        272
         1        464
         1        711
         1        726
         1        811
         1       1060
SQL> --2) Blocking sessions and blocked statements:
SQL> SELECT ' '                                        "BLOCKED",
  2         gv$session.inst_id                         "INST_ID",
  3         gv$session.sid                             "SID",
  4         gv$lock.TYPE                               lock_type,
  5         gv$lock.id1                                lock_id1,
  6         gv$lock.id2                                lock_id2,
  7         gv$lock.lmode                              lock_lmode,
  8         gv$lock.request                            lock_request,
  9         gv$sql.sql_id                              "Statement ID",
10         Replace(gv$sql.sql_fulltext, Chr(10), ' ') "Statement text",
11         gv$sql.last_load_time                      "Last Load Time",
12         ' '                                        "BLOCKING",
13         dba_objects.object_name                    "Object",
14         dba_objects.owner                          "Owner",
15         CASE
16           WHEN row_wait_obj# < 0 THEN NULL
17           ELSE dbms_rowid.Rowid_create (1, gv$session.row_wait_obj#, gv$session.row_wait_file#, gv$session.row_wait_block#, gv$session.row_wait_row#)
18         END                                        "ROWID"
19  FROM   gv$session
20         left outer join gv$sql
21                      ON ( gv$session.sql_id = gv$sql.sql_id )
22         left outer join dba_objects
23                      ON ( dba_objects.object_id = gv$session.row_wait_obj# )
24         left outer join gv$lock
25                      ON ( gv$lock.sid = gv$session.sid
26                           AND gv$lock.inst_id = gv$session.inst_id )
27  WHERE  gv$session.sid IN (SELECT s2.sid
28                            FROM   gv$lock l1,
29                                   gv$session s1,
30                                   gv$lock l2,
31                                   gv$session s2
32                            WHERE  s1.sid = l1.sid
33                                   AND s2.sid = l2.sid
34                                   AND l1.BLOCK = 1
35                                   AND l2.request > 0
36                                   AND l1.id1 = l2.id1
37                                   AND l2.id2 = l2.id2
38                                   AND l1.inst_id = s1.inst_id
39                                   AND l2.inst_id = s2.inst_id)
40  ORDER  BY gv$session.inst_id,
41            gv$session.sid;
 
BLOCKED                             INST_ID        SID LOCK_TYPE   LOCK_ID1   LOCK_ID2 LOCK_LMODE LOCK_REQUEST Statement ID  Statement text                                                                   Last Load Time                                                               BLOCKING                         Object                                                                           Owner                          ROWID
-------------------------------- ---------- ---------- --------- ---------- ---------- ---------- ------------ ------------- -------------------------------------------------------------------------------- ---------------------------------------------------------------------------- -------------------------------- -------------------------------------------------------------------------------- ------------------------------ ------------------
                                          1        183 TX            983040      38753          0            6                                                                                                                                                                                                              TEMP_WBS                                                                         CLARITY_USER                   AAAVN2AAHAAAsM+AAG
                                          1        183 TM             86902          0          3            0                                                                                                                                                                                                              TEMP_WBS                                                                         CLARITY_USER                   AAAVN2AAHAAAsM+AAG
                                          1        183 TX           2949133       1294          6            0                                                                                                                                                                                                              TEMP_WBS                                                                         CLARITY_USER                   AAAVN2AAHAAAsM+AAG
                                          1        183 AE               100          0          4            0                                                                                                                                                                                                              TEMP_WBS                                                                         CLARITY_USER                   AAAVN2AAHAAAsM+AAG
                                          1        201 AE               100          0          4            0                                                                                                                                                                                                                                                                                                                              
                                          1        201 TX            917509      37588          0            4                                                                                                                                                                                                                                                                                                                              
                                          1        201 TX            720910      40348          6            0                                                                                                                                                                                                                                                                                                                              
                                          1        201 TM             58655          0          3            0                                                                                                                                                                                                                                                                                                                              
                                          1        272 TX            131091      70960          6            0                                                                                                                                                                                                                                                                                                                              
                                          1        272 TX            983040      38753          0            4                                                                                                                                                                                                                                                                                                                              
                                          1        272 AE               100          0          4            0                                                                                                                                                                                                                                                                                                                              
                                          1        272 TM             58655          0          3            0                                                                                                                                                                                                                                                                                                                              
                                          1        464 AE               100          0          4            0 7fpvx6apk3q2g delete from temp_wbs          where cacheid             in (select cacheid       2013-01-31/22:03:58                                                                                           TEMP_WBS                                                                         CLARITY_USER                   AAAVN2AAHAABRwxAA4
                                          1        464 TX            393229      73377          6            0 7fpvx6apk3q2g delete from temp_wbs          where cacheid             in (select cacheid       2013-01-31/22:03:58                                                                                           TEMP_WBS                                                                         CLARITY_USER                   AAAVN2AAHAABRwxAA4
                                          1        464 TM             86902          0          3            0 7fpvx6apk3q2g delete from temp_wbs          where cacheid             in (select cacheid       2013-01-31/22:03:58                                                                                           TEMP_WBS                                                                         CLARITY_USER                   AAAVN2AAHAABRwxAA4
                                          1        464 TX            917509      37588          0            6 7fpvx6apk3q2g delete from temp_wbs          where cacheid             in (select cacheid       2013-01-31/22:03:58                                                                                           TEMP_WBS                                                                         CLARITY_USER                   AAAVN2AAHAABRwxAA4
                                          1        711 TX           2031634      13572          0            4                                                                                                                                                                                                                                                                                                                              
                                          1        711 TX           2162694      11804          6            0                                                                                                                                                                                                                                                                                                                              
                                          1        711 TM             58655          0          3            0                                                                                                                                                                                                                                                                                                                              
                                          1        711 AE               100          0          4            0                                                                                                                                                                                                                                                                                                                              
SELECT ss.inst_id,
  2         ss.sid,
  3         ss.username,
  4         ss.status,
  5         ss.machine,
  6         To_char(SYSDATE - ( ss.last_call_et / 86400 ), 'dd-mon-yyyy HH24:MI:SS') since,
  7         ss.last_call_et,
  8         To_char(ss.logon_time, 'dd-mon-yyyy HH24:MI:SS')                         logon_time,
  9         ss.current_queue_duration
10  FROM   gv$session ss
11         inner join (SELECT DISTINCT s1.inst_id,
12                                     s1.sid
13                     FROM   gv$lock l1,
14                            gv$session s1,
15                            gv$lock l2,
16                            gv$session s2
17                     WHERE  s1.sid = l1.sid
18                            AND s2.sid = l2.sid
19                            AND l1.BLOCK = 1
20                            AND l2.request > 0
21                            AND l1.id1 = l2.id1
22                            AND l2.id2 = l2.id2
23                            AND l1.inst_id = s1.inst_id
24                            AND l2.inst_id = s2.inst_id
25                     UNION
26                     SELECT DISTINCT s2.inst_id,
27                                     s2.sid
28                     FROM   gv$lock l1,
29                            gv$session s1,
30                            gv$lock l2,
31                            gv$session s2
32                     WHERE  s1.sid = l1.sid
33                            AND s2.sid = l2.sid
34                            AND l1.BLOCK = 1
35                            AND l2.request > 0
36                            AND l1.id1 = l2.id1
37                            AND l2.id2 = l2.id2
38                            AND l1.inst_id = s1.inst_id
39                            AND l2.inst_id = s2.inst_id) bb
40                 ON ( ss.inst_id = bb.inst_id
41                      AND ss.sid = bb.sid )
42  ORDER  BY ss.inst_id,
43            ss.sid;
 
   INST_ID        SID USERNAME                       STATUS   MACHINE                                                          SINCE                                                                       LAST_CALL_ET LOGON_TIME                                                                  CURRENT_QUEUE_DURATION
---------- ---------- ------------------------------ -------- ---------------------------------------------------------------- --------------------------------------------------------------------------- ------------ --------------------------------------------------------------------------- ----------------------
         1        183 CLARITY_USER                   ACTIVE   LES0009001823.es.mapfre.net/10.252.185.58                        01-feb-2013 11:51:06                                                                 951 01-feb-2013 10:13:46                                                                             0
         1        201 CLARITY_USER                   ACTIVE   LES0009001824.es.mapfre.net/10.252.185.57                        01-feb-2013 11:49:11                                                                1066 01-feb-2013 09:30:43                                                                             0
         1        272 CLARITY_USER                   ACTIVE   LES0009001823.es.mapfre.net/10.252.185.58                        01-feb-2013 11:45:13                                                                1304 01-feb-2013 10:13:47                                                                             0
         1        464 CLARITY_USER                   ACTIVE   LES0009001824.es.mapfre.net/10.252.185.57                        01-feb-2013 11:50:51                                                                 966 01-feb-2013 08:12:42                                                                             0
         1        711 CLARITY_USER                   ACTIVE   LES0009001823.es.mapfre.net/10.252.185.58                        01-feb-2013 11:19:44                                                                2833 01-feb-2013 09:13:38                                                                             0
         1        726 CLARITY_USER                   INACTIVE LES0009001824.es.mapfre.net/10.252.185.57                        01-feb-2013 11:49:24                                                                1053 01-feb-2013 08:42:46                                                                             0
         1        811 CLARITY_USER                   INACTIVE LES0009001823.es.mapfre.net/10.252.185.58                        01-feb-2013 11:45:21                                                                1296 01-feb-2013 09:43:49                                                                             0
         1       1060 CLARITY_USER                   INACTIVE LES0009001823.es.mapfre.net/10.252.185.58                        01-feb-2013 11:20:14                                                                2803 01-feb-2013 08:21:49                                                                             0
         1       1152 CLARITY_USER                   ACTIVE   LES0009001823.es.mapfre.net/10.252.185.58                        01-feb-2013 12:06:57                                                                   0 01-feb-2013 09:43:51                                                                             
SQL>  select l1.sid, ' IS BLOCKING ', l2.sid
  2      from v$lock l1, v$lock l2
  3      where l1.block =1 and l2.request > 0
  4      and l1.id1=l2.id1
  5      and l1.id2=l2.id2
  6  ;
 
       SID 'ISBLOCKING'                            SID
---------- -------------------------------- ----------
      1060  IS BLOCKING                            711
       811  IS BLOCKING                            183
       811  IS BLOCKING                            272
       726  IS BLOCKING                            464
       726  IS BLOCKING                            201
select s1.username || '@' || s1.machine
  2      || ' ( SID=' || s1.sid || ' )  is blocking '
  3      || s2.username || '@' || s2.machine || ' ( SID=' || s2.sid || ' ) ' AS blocking_status
  4      from v$lock l1, v$session s1, v$lock l2, v$session s2
  5      where s1.sid=l1.sid and s2.sid=l2.sid
  6      and l1.BLOCK=1 and l2.request > 0
  7      and l1.id1 = l2.id1
  8      and l2.id2 = l2.id2 ;
 
BLOCKING_STATUS
--------------------------------------------------------------------------------
CLARITY_USER@LES0009001823.es.mapfre.net/10.252.185.58 ( SID=1163 )  is blocking
CLARITY_USER@LES0009001824.es.mapfre.net/10.252.185.57 ( SID=726 )  is blocking
CLARITY_USER@LES0009001823.es.mapfre.net/10.252.185.58 ( SID=811 )  is blocking
CLARITY_USER@LES0009001823.es.mapfre.net/10.252.185.58 ( SID=1060 )  is blocking
CLARITY_USER@LES0009001824.es.mapfre.net/10.252.185.57 ( SID=726 )  is blocking
CLARITY_USER@LES0009001823.es.mapfre.net/10.252.185.58 ( SID=811 )  is blocking
SQL> --4.- Open cursors:
SQL>  select sql_id, sql_fulltext
  2  from v$sqlarea
  3  where sql_id in
  4  (select sql_id from v$open_cursor where sid in( 1060,811,726));
 
SQL_ID        SQL_FULLTEXT
------------- --------------------------------------------------------------------------------
01x8ys1xws11z select count(*) locks from prlock where prname= :v0  and prtablename= :v1  and p
0364j59shhd07 SELECT  TS.*
                        FROM    PRJ_TENTATIVE_SCHEDULES TS
                        WHERE   TS.PROJECT_ID =  :v0
                        AND     TS.CREATED_BY =  :v1
 
0jcnr9hrw6qfn SELECT *
                       FROM   PRTIMEENTRY
                       WHERE  PRTIMESHEETID =  :v0
 
0n6g13y9dhb2v SELECT  C.PRID AS CALID, R.PRID AS RESID, C.PRNAME, C.PRVALUE, SR.RESOURCE_TYPE
                      FROM    PRJ_RESOURCES R, SRM_RESOURCES SR, PRCALENDAR C
                      WHERE   R.PRCALENDARID = C.PRID
                      AND     R.PRID =  :v0
                      AND     R.PRID = SR.ID
 
0tf4t6dt197hm select odf_q.*  , (select b.name from cmn_partitions a,cmn_captions_nls b  where
                                      SRM_RESOURCES.LAST_NAME LAST_NAME,
                                      SRM_RESOURCES.FIRST_NAME FIRST_NAME,
                                      SRM_RESOURCES.FULL_NAME FULL_NAME,
                                      SRM_RESOURCES.UNIQUE_NAME UNIQUE_NAME,
                                      SRM_RESOURCES.UNIQUE_NAME UNIQUE_CODE
                                      FROM SRM_RESOURCES, PRJ_RESOURCES WHERE
                                      :"SYS_B_04"=:"SYS_B_05"  AND
                                      :"SYS_B_06"= :v2  and :"SYS_B_07"=:"SYS_B_08" AND SRM_RESOU
                      FROM    PRJ_RESOURCES PRJ_RES
                            , SRM_RESOURCES SRM_RES
                      WHERE PRJ_RES.PRISROLE != :"SYS_B_10"
                      AND PRJ_RES.PRID = SRM_RES.ID
                      AND :"SYS_B_11"=:"SYS_B_12"
                      AND :"SYS_B_13"= :v3  and :"SYS_B_14"=:"SYS_B_15") q_role_id where rownu
                              INV.CODE CODE,
                              INV.CODE UNIQUE_CODE,
                              INV.NAME NAME
                              FROM
                              INV_INVESTMENTS INV, INV_PROJECTS PRJ
                              WHERE
                             :"SYS_B_18"=:"SYS_B_19"
                                 AND INV.ID=PRJ.PRID
                                 AND PRJ.IS_TEMPLATE=:"SYS_B_20"
                                 AND (INV.PURGE_FLAG=:"SYS_B_21" OR INV.PURGE_FLAG IS NULL)
                                 AND
                              :"SYS_B_22"= :v6  and :"SYS_B_23"=:"SYS_B_24") q_v_project_id wh
                      ELSE PRASSIGNMENT.PRACTSUM END por_practsum  , prassignment.prTaskID prt
                      PRJ_HPD_FACTOR_FCT() ELSE PRASSIGNMENT.PRACTSUM+PRASSIGNMENT.PRESTSUM +
                      WHEN PRTASK.PRSTART < PRASSIGNMENT.PRACTTHRU THEN PRASSIGNMENT.PRACTTHRU
                      ELSE PRASSIGNMENT.PRESTSUM END prestsum  , prassignment.prEstPattern pre
                      ELSE PRASSIGNMENT.PRESTSUM END por_prestsum  , CASE WHEN SRM_RESOURCES.R
                      ELSE PRASSIGNMENT.PRACTSUM END practsum  , NVL(PRTEAM.REQUIREMENT_NAME,
               and prassignment.created_by = CREATED.user_id and prassignment.last_updated_by
 
1kms5ytfqn57r select cacheid
                          from temp_wbs_keys
                         where :"SYS_B_0"=:"SYS_B_1"
                           and sessionid =  :v0
                           and projectid =  :v1
                            and ( created_date + :"SYS_B_2"/:"SYS_B_3" ) > sysdate
 
1sb1d52jysydc SELECT   PRTIMESHEET.PRSTATUS, PRTIMEPERIOD.PRSTART, PRTIMEPERIOD.PRFINISH
                      FROM     PRTIMEPERIOD, PRTIMESHEET
                      WHERE    PRTIMESHEET.PRID= :v0
                      AND      PRTIMESHEET.PRTIMEPERIODID = PRTIMEPERIOD.PRID
 
1tnun46vx6am4 select CMN_LOCKED_BY_FCT( :v0 , :v1 , :v2 ) AS lockedBy FROM DUAL
1wzc4kbd3705u update TEMP_WBS
                           set client_selected = :"SYS_B_0", visible = :"SYS_B_1"
                         where taskid =  :v0
                           and cacheid =  :v1
 
2cmda9jkxajnn select wbssequence, wbslevel, nnb_seq
                          from TEMP_WBS
                         where taskid =  :v0
                           and cacheid =  :v1
 
2qhn22m4s2gxz select count(*) value from odf_objects o where o.code =  :v0  and (is_audit_inse
2qx4y08n4j7a1 update TEMP_WBS
                           set visible = :"SYS_B_0"
                         where exists( select temp.wbssequence
                                         from TEMP_WBS temp
                                        where temp.wbslevel < TEMP_WBS.wbslevel
                                          and temp.wbssequence < TEMP_WBS.wbssequence
                                          and temp.nnb_seq > TEMP_WBS.wbssequence
                                          and temp.client_selected = :"SYS_B_1"
                                          and temp.cacheid = TEMP_WBS.cacheid)
                           and wbslevel > :"SYS_B_2"
                           and cacheid =  :v0
                           and wbssequence >  :v1
                           and wbssequence <  :v2
                           and wbslevel >  :v3
 
315bp8r2afggs SELECT  :v0  odf_pk,  :v1  attribute , q.prid value, q.name lookupValue  from (
               FROM PRTEAM team, SRM_RESOURCES res, PRASSIGNMENT assign
              WHERE :"SYS_B_1"=:"SYS_B_2"
                AND :"SYS_B_3"= :v2  and :"SYS_B_4"=:"SYS_B_5" AND res.id = team.prresourceid
                AND team.prid = assign.team_id
                AND assign.prtaskid =  :v3 ) q  ORDER BY lookupValue
 
31v0h7vghbggd update TEMP_WBS_KEYS
                           set created_date = SYSDATE
                         where cacheid =  :v0
 
33d5uy16n0k25 select  object_id, permission_code, class_code
                      from    cmn_sec_chk_user_glb_r_v0 a
                      where   user_id =  :v0
 
3hut2c1syj9bd insert into prlock (prname, prtablename, prrecordid, prlockedsince, pruserid)
                        values ( :v0 , :v1 , :v2 , :v3 , :v4 )
 
3jcfkk0bcthj5 select partition_code
                        from odf_ca_project
                        where id =  :v0
 
3nwrb59x3xnz2 select * from (select row_number() over ( order by id) row_num, count(*) over ()
                              USERS.user_name UNIQUE_CODE,
                              RESOURCES.LAST_NAME LAST_NAME,
                              RESOURCES.FULL_NAME FULL_NAME,
                              RESOURCES.FIRST_NAME FIRST_NAME,
                              RESOURCES.UNIQUE_NAME UNIQUE_NAME
                              FROM SRM_RESOURCES RESOURCES, CMN_SEC_USERS USERS WHERE USERS.ID
                              :"SYS_B_0" = :"SYS_B_1"               AND
                              :"SYS_B_2"= :v0  and :"SYS_B_3"=:"SYS_B_4"  AND USERS.ID =  :v1
 
3v0cjgtrn9jrm select edits from prj_gantt_edits where project_id= :v0  and user_id= :v1  and t
499z4wzpd9vkw SELECT  U.USER_NAME, U.LAST_NAME, U.FIRST_NAME, U.EMAIL_ADDRESS, P.CODE, L.*
                        FROM    PRLOCK L, CMN_SEC_USERS U, INV_INVESTMENTS P
                        WHERE   PRNAME=:"SYS_B_0"
                        AND     PRTABLENAME=:"SYS_B_1"
                        AND     PRUSERID=U.ID
                        AND     PRRECORDID=P.ID
                        AND     P.ID =  :v0
 
SQL_ID        SQL_FULLTEXT
------------- --------------------------------------------------------------------------------
4ckskmtpgwd82 SELECT  *
                      FROM    PRTIMESHEET
                      WHERE   PRID= :v0
 
4v1s627nzttzn select f.id as formula_id
                             , f.task_id as task_id
                             , f.is_default as is_default
                             , f.formula as formula
                             , f.sequence as sequence
                             , e.id as condition_id
                             , e.expression condition
                      from prj_task_formulas f
                      , odf_filter_expressions e
                      where f.task_id= :v0
                      and f.id=e.object_instance_id(+)
                      and e.object_code(+)= :v1
                      order by f.sequence, f.id
 
4vmznh780ty5r select (select count(*) from TEMP_WBS_EXT where cacheid =  :v0  ) cache_count,
                          (
                            select count(*)
                              from (
                                select q.CACHEID, q.WBSSEQUENCE, q.DEPTASKID, q.SORTSEQUENCE
                                      , row_number() over (partition by q.DEPTASKID order by q
                                 from (
                                    select FILTER.CACHEID, FILTER.WBSSEQUENCE, DEP.PRPREDTASKI
                                          , (FILTER.WBSSEQUENCE - :"SYS_B_0") SORTSEQUENCE
                                      from TEMP_WBS FILTER, PRDEPENDENCY DEP
                                     WHERE FILTER.TASKID = DEP.PRSUCCTASKID
                                       AND FILTER.CACHEID =  :v1
                                       AND DEP.PRPREDTASKID NOT IN ( SELECT TASKID FROM TEMP_W
                                    union
                                    SELECT FILTER.CACHEID, FILTER.WBSSEQUENCE, DEP.PRSUCCTASKI
                                          , (FILTER.WBSSEQUENCE + :"SYS_B_1") SORTSEQUENCE
                                      FROM TEMP_WBS FILTER, PRDEPENDENCY DEP
                                     WHERE FILTER.TASKID = DEP.PRPREDTASKID
                                       AND FILTER.CACHEID =  :v3
                                       AND DEP.PRSUCCTASKID NOT IN ( SELECT TASKID FROM TEMP_W
                                    ) q
                            ) z where z.rownbr = :"SYS_B_2"
                          ) project_count from dual
 
4vs91dcv7u1p6 insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t
52kbxn6ntr9xc SELECT  P.ID, P.NAME, P.SCHEDULE_START, P.SCHEDULE_FINISH, MIN(SP.PRISREADONLY)
                        FROM    PRSUBPROJECT SP, PRTASK T, INV_INVESTMENTS P
                        WHERE   SP.PRTASKID = T.PRID
                        AND     SP.PRREFTASKID IS NULL
                        AND     T.PRPROJECTID=:"SYS_B_0"
                        AND     P.ID = SP.PRREFPROJECTID
                        AND     P.IS_ACTIVE = :"SYS_B_1"
                        GROUP BY P.ID, P.NAME, P.SCHEDULE_START, P.SCHEDULE_FINISH
 
58wytbj2juyqv select  CMN_SEC_CHK_CLS_INST_RIGHT_FCT( :v0 , :v1 , :v2 , :v3 , :v4 , :v5 , :v6
                      from    dual
 
59bpazvxbxzdb SELECT  I.ID
                              , I.NAME
                              , I.CODE
                              , I.IS_ACTIVE
                              , P.IS_PROGRAM
                              , P.IS_TEMPLATE
                              , CA.ODF_OBJECT_CODE
                      FROM    INV_INVESTMENTS I
                              , INV_PROJECTS P
                              , ODF_CA_INV CA
                      WHERE   I.ID =  :v0
                      AND     P.PRID(+) = I.ID
                      AND     CA.ID = I.ID
 
59t498dxmshnj select count(*) cache_count from TEMP_WBS_V where cacheid =  :v0
5jgfy25gpdjc2 SELECT action.id action_id, action_code action, parameter_code parameter, parame
                      FROM   cmn_portlets portlet, cmn_actions action, cmn_action_params param
                       WHERE  portlet.portlet_type_code =  :v0
                         AND portlet.portlet_view_type_code =  :v1
                         AND mi.container_id = portlet.id
                         AND mi.action_id = action.id
                        AND param.action_id = action.id
 
5rvjc179anv1q select * from (select row_number() over ( order by description  asc) row_num, co
                             description description
                      FROM ppa_matrix
                      WHERE :"SYS_B_0"= :v0  and :"SYS_B_1"=:"SYS_B_2"  AND matrixtype IN (:"S
                             AND NOT EXISTS (
                               SELECT :"SYS_B_5"
                               FROM ppa_locmatrixassignments a, pac_mnt_resources r
                               WHERE a.matrixkey = ppa_matrix.matrixkey
                               AND a.locationid IS NOT NULL
                               AND a.locationid !=r.LOCATIONID
                                    AND pac_fos_is_valid_location_fct ((select unique_name from SRM_RESOURCES w
 
5tutrpn2p2fgv select count(*) changes
                          from TEMP_WBS wbs, prtask task
                         where wbs.cacheid =  :v0
                           and wbs.taskid = task.prid
                           and (wbs.origwbssequence != task.prwbssequence or wbs.origwbslevel
 
65hz1644mx9jn SELECT TASKID
                           FROM TEMP_WBS
                          WHERE CACHEID =  :v0
                            AND WBSSEQUENCE IN
                                (SELECT DISTINCT PAR_SEQ FROM TEMP_WBS WHERE CACHEID =  :v1 )
 
6gt9xp0yn6uv6 SELECT  t.prid
                                , t.prprojectid
                                , inv.NAME PROJECT_NAME
                                , t.prresourceid
                                , rs.FIRST_NAME
                                , rs.LAST_NAME
                                , rp.prisrole
                                , ca.odf_object_code
                        FROM    PRTeam t
                                , SRM_RESOURCES rs
                                , PRJ_RESOURCES rp
                                , INV_INVESTMENTS inv
                                , ODF_CA_INV ca
                        WHERE   rs.id = rp.prid
                        and     rs.id = t.prresourceid
                        and     inv.id = t.prprojectid
                        and     inv.id = ca.id
                        AND     t.prid = :v0
 
7bk2bvua5vhm2 SELECT PRID, PRSTATUS
                       FROM   PRTIMESHEET
                       WHERE  PRTIMEPERIODID =  :v0
                       AND    PRRESOURCEID =  :v1
                       AND    PRSTATUS < :"SYS_B_0"
 
7kzhccr1wfd8b select count(*) cnt from prj_gantt_edits where project_id= :v0  and user_id= :v1
7pvdjvvj6za95 select g.ID, g.CODE, g.PRINCIPAL_TYPE, g.DAL_PARTITION_CODE, g.PORTLET_ID
                        from CMN_GRIDS g
                        where g.PORTLET_INSTANCE_ID =  :v0
                        and g.PRINCIPAL_TYPE = :"SYS_B_00"
                        and g.PRINCIPAL_ID =  :v1
                        union
                        select g.ID, g.CODE, g.PRINCIPAL_TYPE, g.DAL_PARTITION_CODE, g.PORTLET
                        from CMN_GRIDS g
                        where g.PRINCIPAL_TYPE = :"SYS_B_01"
                        and   g.PRINCIPAL_ID =  :v2  and g.DAL_PARTITION_CODE =  :v3
                        and   g.CODE =  :v4
                        and ((g.dal_type=:"SYS_B_02" and g.class_code is null)  )  union
                        select ID, CODE, PRINCIPAL_TYPE, DAL_PARTITION_CODE, PORTLET_ID
                        from
                        (
                          select g.ID ID, g.CODE CODE, g.DAL_PARTITION_CODE DAL_PARTITION_CODE
                          from CMN_PARTITIONS_FLAT f, CMN_PARTITIONS p, CMN_GRIDS g
                          where f.CHILD_PARTITION_CODE =  :v5
                          and f.PARTITION_CODE = p.CODE
                          and g.DAL_PARTITION_CODE = f.PARTITION_CODE
                          and g.CODE =  :v6
                          and g.PRINCIPAL_TYPE = :"SYS_B_03"
                          and ((g.dal_type=:"SYS_B_04" and g.class_code is null)  )  union
                          select  g.ID ID, g.CODE CODE, g.DAL_PARTITION_CODE DAL_PARTITION_COD
                                  g.PORTLET_ID PORTLET_ID
                          from    CMN_GRIDS g
                          where   g.DAL_PARTITION_CODE = :"SYS_B_06"
                          and     g.CODE =  :v7
                          and     (g.CLASS_CODE =  :v8  or (g.dal_type =:"SYS_B_07" and g.clas
                          and     g.PRINCIPAL_TYPE = :"SYS_B_08"
                        ) all_parent_lists
                        where DEPTH = ( select max(DEPTH) from
                          (
                            select  p.DEPTH DEPTH
                            from    CMN_PARTITIONS_FLAT f, CMN_PARTITIONS p, CMN_GRIDS g
                            where   f.CHILD_PARTITION_CODE =  :v9
                            and     f.PARTITION_CODE = p.CODE
                            and     g.DAL_PARTITION_CODE = p.CODE
                            and     p.IS_ACTIVE = :"SYS_B_09"
                            and     g.CODE =  :v10
                            and     (g.CLASS_CODE =  :v11  or (g.dal_type =:"SYS_B_10" and g.c
                            and     g.PRINCIPAL_TYPE = :"SYS_B_11"
                            union
                            select -:"SYS_B_12" DEPTH
                            from DUAL
                          ) closest_parent_depth
                        )
              
                        union
              
                        select g.ID, g.CODE, g.PRINCIPAL_TYPE, g.DAL_PARTITION_CODE, g.PORTLET
                        from CMN_GRIDS g
                        where g.PORTLET_ID =  :v12
                        and g.PRINCIPAL_TYPE = :"SYS_B_13"
 
7t60pux2vnkcs INSERT INTO NMS_MESSAGES (
                           ID, TOPIC, MESSAGE_CODE, OBJECT_ID, OBJECT_CODE, USER_ID,
                           MESSAGE_TYPE_CODE, MESSAGE, SEND_DATE, EXPIRATION_DATE,
                           CREATED_DATE, CREATED_BY, LAST_UPDATED_DATE, LAST_UPDATED_BY)
                        VALUES (  :v0 ,  :v1 ,  :v2 ,  :v3 ,  :v4 ,  :v5 ,  :v6 ,  :v7 ,  :v8
 
81garfb589678 SELECT DISTINCT
                        PRDEPENDENCY.PRID
                        ,PRDEPENDENCY.PRPREDTASKID
                        ,PRDEPENDENCY.PRSUCCTASKID
                        ,PRDEPENDENCY.PRTYPE
                        ,PRED.PRNAME PRPREDTASKNAME
                        ,SUCC.PRNAME PRSUCCTASKNAME
                        FROM PRDEPENDENCY,PRTASK PRED,PRTASK SUCC
                        WHERE (PRED.PRPROJECTID in (select child_id from inv_flat_hierarchies
                          OR SUCC.PRPROJECTID in (select child_id from inv_flat_hierarchies wh
                        AND PRED.PRID = PRDEPENDENCY.PRPREDTASKID
                        AND SUCC.PRID = PRDEPENDENCY.PRSUCCTASKID
 
89wbzpqk9jzyx select  us.id,
                              us.token,
                              us.user_name,
                              us.pwd,
                              us.force_pwd_change,
                              us.first_name,
                              us.last_name,
                              us.email_address, us.locale,
                              us.timezone,
                              us.last_pwd_change,
                              us.bad_login_count,
                              us.is_ldap,
                              l.language_code,
                              lu.lookup_code user_status,
                              r.id resource_id,
                              r.unique_name,
                              us.home_url,
                              us.nav_state,
                              fm.id favorites_menu_id,
                              us.screen_reader_opt,
                              us.high_contrast_ui
                      from    cmn_user_session_v us left outer join
                                  cmn_menu_items fm on  fm.principal_id = us.id
                                                    and fm.principal_type =  :v0
                                                    and fm.container_type_code =  :v1
                                                    and fm.parent_menu_id is null,
                              cmn_languages l,
                              cmn_lookups lu,
                              srm_resources r
                      where   us.language_id = l.id
                      and     us.user_status_id = lu.id
                      and     r.user_id = us.id
                      and     us.token= :v2
 
8mdwdcfka2615 SELECT  a.*
                        FROM     cmn_attribute_value_sets a
                        WHERE    a.view_code =  :v0
                        AND      a.user_id =  :v1   AND a.class_code =  :v2  order by a.name
 
8n3k000mfk2x5 INSERT INTO TEMP_WBS_SLICE( TASKID, PROJECTID, WBSSEQUENCE, WBSLEVEL, NNB_SEQ, I
                        (SELECT Q.TASKID, Q.PROJECTID, Q.WBSSEQUENCE, Q.WBSLEVEL, Q.NNB_SEQ, Q
                           FROM
                               (SELECT TASKID, PROJECTID, WBSSEQUENCE, WBSLEVEL, NNB_SEQ, IS_E
                                  FROM TEMP_WBS_V
                                 WHERE CACHEID =  :v0
                                  AND VISIBLE = :"SYS_B_0"  ) Q
                          WHERE Q.ODF_ROW_NUM BETWEEN  :v1  AND  :v2  )
 
SQL_ID        SQL_FULLTEXT
------------- --------------------------------------------------------------------------------
8ra7zbuyfbpbp select NVL( max( taskid ), -:"SYS_B_0" ) maxtaskid, count(*) taskcount from TEMP
8xy3xh6khnmfu select * from CMN_SESSION_PROPERTIES  where :"SYS_B_0"=:"SYS_B_1"
8z4164qpxb38k select NVL( max( prid ), -:"SYS_B_0" ) maxtaskid, count(*) taskcount
                          from prtask
                         where prprojectid in ( select  :v0  from dual union select distinct p
 
8zy7mgynk4ndh update TEMP_WBS_GLOBAL
                           set prrefprojectid = null, refprocessed = null
                         where prrefprojectid is not null or refprocessed is not null
 
96g93hntrzjtr select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_
9kjhrspjk99mx SELECT UNIQUE POSITION, ARGUMENT_NAME, decode(DATA_TYPE, :"SYS_B_0", TYPE_NAME,
9u98z4a93rmf7 select * from (
              
                      SELECT  mi.id id, action.id action, action.action_code code, action.targ
                              action.policy_id, action.is_system, ac.name,
                              :"SYS_B_00" page_id, :"SYS_B_01" page_name,
                              mi.parent_menu_id parent, mi.menu_item_level level_index,
                              mi.position position, :"SYS_B_02" space_code, portlet.portlet_co
                              :"SYS_B_04" url, -:"SYS_B_05" job_definition_id, :"SYS_B_06" obj
                      FROM    cmn_portlets portlet, cmn_menu_items mi, cmn_captions_nls ac, cm
                      WHERE   portlet.portlet_type_code =  :v0
                      AND     portlet.portlet_view_type_code =  :v1
                      AND     mi.container_id = portlet.id
                      AND     mi.action_id = action.id
                      AND     mi.item_type_code = :"SYS_B_08"
                      AND     mi.is_hidden = :"SYS_B_09"
                      AND     action.page_id =  :v2
                      AND     action.object_action_id =  :v3
                      AND     action.principal_type =  :v4
                      AND     action.principal_id =  :v5
                      AND     ac.pk_id = action.id
                      AND     ac.table_name =  :v6
                      AND     ac.language_code =  :v7
                      UNION
              
                      SELECT  mi.id id, action.id action, action.action_code code, action.targ
                              action.policy_id, action.is_system, ac.name,
                              page.id page_id, pc.name page_name,
                              mi.parent_menu_id parent, mi.menu_item_level level_index,
                              mi.position position, page.space_code, portlet.portlet_code, :"S
                              :"SYS_B_11" url, -:"SYS_B_12" job_definition_id, :"SYS_B_13" obj
                      FROM    cmn_pages page, cmn_captions_nls pc, cmn_menu_items mi,
                              cmn_portlets portlet, cmn_captions_nls ac, cmn_actions action
                      WHERE   portlet.portlet_type_code =  :v8
                      AND     portlet.portlet_view_type_code =  :v9
                      AND     mi.container_id = portlet.id
                      AND     mi.action_id = action.id
                      AND     mi.item_type_code = :"SYS_B_15"
                      AND     mi.is_hidden = :"SYS_B_16"
                      AND     action.page_id = page.id
                      AND     ac.pk_id = action.id
                      AND     ac.table_name =  :v10
                      AND     ac.language_code =  :v11
                      AND     pc.pk_id = action.page_id
                      AND     pc.table_name =  :v12
                      AND     pc.language_code =  :v13
                      UNION
              
                      SELECT  mi.id id, action.id action, oa.action code, oa.navigate_to targe
                              action.policy_id, action.is_system, ac.name,
                              oa.id page_id, pc.name page_name,
                              mi.parent_menu_id parent, mi.menu_item_level level_index,
                              mi.position position, :"SYS_B_17" space_code, portlet.portlet_co
                              oa.external_link_url url, oa.job_definition_id job_definition_id
                      FROM    odf_actions oa, cmn_captions_nls pc, cmn_menu_items mi,
                              cmn_portlets portlet, cmn_captions_nls ac, cmn_actions action
                      WHERE   portlet.portlet_type_code =  :v14
                      AND     portlet.portlet_view_type_code =  :v15
                      AND     mi.container_id = portlet.id
                      AND     mi.action_id = action.id
                      AND     mi.item_type_code = :"SYS_B_19"
                      AND     mi.is_hidden = :"SYS_B_20"
                      AND     action.object_action_id = oa.id
                      AND     ac.pk_id = action.id
                      AND     ac.table_name =  :v16
                      AND     ac.language_code =  :v17
                      AND     pc.pk_id = action.object_action_id
                      AND     pc.table_name =  :v18
                      AND     pc.language_code =  :v19
                      ) menus   WHERE portlet_code =  :v20   ORDER BY portlet_code desc, level
 
a7u9aq6uchxs9 update TEMP_WBS_GLOBAL
                           set refprocessed = :"SYS_B_0" where refprocessed = :"SYS_B_1"
 
aqga0cv814vm5 SELECT  A.*
                      FROM    PRASSIGNMENT A, PRTIMEENTRY TE
                      WHERE   TE.PRTIMESHEETID =  :v0
                      AND     A.PRID = TE.PRASSIGNMENTID
 
asyuz82fsvarp SELECT  TS.ID, P.NAME, P.ID AS PROJECT_ID, TS.CREATED_BY, TP.IS_PUBLISHABLE
                        FROM    PRJ_TENTATIVE_PROJECTS TP, PRJ_TENTATIVE_SCHEDULES TS, INV_INV
                        WHERE   TP.PROJECT_ID =  :v0
                        AND     TS.ID = TP.TENTATIVE_SCHEDULE_ID
                        AND     P.ID = TS.PROJECT_ID
                        AND     TS.CREATED_BY =  :v1
                        ORDER BY P.NAME
 
bb1g6a5vs81yj update PRTIMEENTRY set practsum= :v0 , prmodtime= :v1 , practcurve= :v2  where p
bjn3mpg3szb5x INSERT INTO TEMP_WBS_SLICE ( TASKID, PROJECTID, WBSSEQUENCE, WBSLEVEL, NNB_SEQ,
                         (SELECT TASKID, PROJECTID, WBSSEQUENCE, WBSLEVEL, NNB_SEQ, IS_EXT_DEP
                          FROM TEMP_WBS_V
                           WHERE CACHEID =  :v0
                             AND WBSSEQUENCE >  :v1
                             AND WBSSEQUENCE <  :v2
                             AND WBSLEVEL >  :v3
                             AND VISIBLE = :"SYS_B_0"  )
 
bmdjxu1k32910 SELECT NVL (MAX (PRUSERID), -9) FROM PRLOCK WHERE PRTABLENAME = :B3 AND PRNAME =
bsvpy04y7wf7a select temp.taskid, sub.prrefprojectid
                          from prsubproject sub, TEMP_WBS_GLOBAL temp
                         where sub.prtaskid = temp.taskid
                           and sub.prisipd = :"SYS_B_0"
                           and sub.prreftaskid is null
                           and temp.refprocessed is null
                           and sub.prrefprojectid not in ( select prrefprojectid from TEMP_WBS
 
bttt25pjfdsn8 update TEMP_WBS
                           set client_selected = :"SYS_B_0", visible = :"SYS_B_1"
                         where :"SYS_B_2"=:"SYS_B_3"
                           and cacheid =  :v0
                           and (client_selected = :"SYS_B_4" or visible = :"SYS_B_5")
 
bwxx9xjtrbfay SELECT  P.ID, P.NAME, P.SCHEDULE_START, P.SCHEDULE_FINISH, MIN(SP.PRISREADONLY)
                        FROM    PRSUBPROJECT SP, PRTASK T, INV_INVESTMENTS P
                        WHERE   SP.PRTASKID = T.PRID
                        AND     SP.PRREFTASKID IS NULL
                        AND     (T.PRPROJECTID IN(:"SYS_B_00",:"SYS_B_01",:"SYS_B_02",:"SYS_B_
                        AND     P.ID = SP.PRREFPROJECTID
                        AND     P.IS_ACTIVE = :"SYS_B_19"
                        GROUP BY P.ID, P.NAME, P.SCHEDULE_START, P.SCHEDULE_FINISH
 
by1m2yytaqjka select * from (select row_number() over ( order by rate_type  asc) row_num, coun
                             NAME NAME
                        FROM    cmn_lookups_v
                        WHERE   :"SYS_B_0"= :v0  and :"SYS_B_1"=:"SYS_B_2"  AND    LOOKUP_TYPE = :"SYS_B_
                        AND   IS_ACTIVE = :"SYS_B_4"
                        AND   language_code =  :v1  ) q) q order by q.row_num
 
c0kp4fm9kprnh SELECT /*+ first_rows */ COUNT (1) FROM CMN_SEC_CHK_USER_V0 WHERE USER_ID = :B3
c59gg35c4ys7z SELECT  SP.PRREFPROJECTID AS ID, T.PRPROJECTID AS PARENT_ID, SP.PRREFPROJECTID a
                      FROM    PRTASK T, PRSUBPROJECT SP
                      WHERE   T.PRID = SP.PRTASKID
                      AND     SP.PRISIPD = :"SYS_B_0"
 
ccyx6y7xjw8uu select count(*) cache_count
                         from TEMP_WBS_V
                        where cacheid =  :v0
                          and visible = :"SYS_B_0"
 
cg327aq5g7hb5 SELECT USER_ID FROM CMN_SESSIONS
                       WHERE TOKEN =  :v0
 
SQL_ID        SQL_FULLTEXT
------------- --------------------------------------------------------------------------------
d5tqvajzpucxc select odf_q.*  , (select name from ( SELECT INV.ID ID,
                              INV.CODE CODE,
                              INV.CODE UNIQUE_CODE,
                              INV.NAME NAME
                              FROM
                              INV_INVESTMENTS INV, INV_PROJECTS PRJ
                              WHERE
                              :"SYS_B_00"=:"SYS_B_01"
                                 AND INV.ID=PRJ.PRID
                                 AND PRJ.IS_TEMPLATE=:"SYS_B_02"
                                 AND (INV.PURGE_FLAG=:"SYS_B_03" OR INV.PURGE_FLAG IS NULL)
                                 AND
                              :"SYS_B_04"= :v0  and :"SYS_B_05"=:"SYS_B_06") q_prprojectid whe
                            ELSE NVL((SELECT :"SYS_B_18" FROM DUAL WHERE EXISTS (SELECT :"SYS_
                       END) has_subtasks  , prtask.prName  prname  , CASE WHEN BASEREC.FINISH_
                            ELSE NVL((SELECT :"SYS_B_29" FROM DUAL WHERE EXISTS (SELECT :"SYS_
                       END) is_proxy  , prtask.prIsTask pristask   ,(CASE WHEN PRTASK.PRISTASK
 
dc58tv6xz3q89 SELECT SUB.PRREFPROJECTID
                        FROM PRSUBPROJECT SUB, PRTASK T
                        WHERE T.PRID = SUB.PRTASKID
                        AND (T.PRPROJECTID IN(:"SYS_B_0"))
 
dct6u23c7ygf2 SELECT  INV.ID, INV.NAME, INV.CODE, INV.IS_ACTIVE, INV.ASSGN_POOL, INV.SCHEDULE_
                        FROM    INV_INVESTMENTS INV, INV_PROJECTS PRJ
                        WHERE   INV.ID =  :v0
                                AND INV.ID = PRJ.PRID
 
dvsqdbq6wngkc SELECT COUNT (1) FROM CMN_SEC_CHK_USER_INST_V0 WHERE USER_ID = :B5 AND OBJECT_ID
dxmzpq85scut7 update TEMP_WBS
                           set visible = :"SYS_B_0"
                         where :"SYS_B_1"=:"SYS_B_2"
                           and wbssequence >  :v0
                           and wbssequence <  :v1
                           and wbslevel >  :v2
                           and cacheid =  :v3
 
f5t5qdr52hbhn select attribute_code from odf_locked_attributes where object_code =  :v0  and o
famqtyk1jt3uu insert into TEMP_WBS_EXT (cacheid, wbssequence, sortsequence, exttaskid, extproj
                        (
                        select CACHEID, WBSSEQUENCE, SORTSEQUENCE, DEPTASKID, DEPPROJECTID
                          from (
                            select q.CACHEID, q.WBSSEQUENCE, q.DEPTASKID, q.SORTSEQUENCE, q.DE
                                  , row_number() over (partition by q.DEPTASKID order by q.SOR
                             from (
                                select FILTER.CACHEID, FILTER.WBSSEQUENCE, DEP.PRPREDTASKID DE
                                      , (FILTER.WBSSEQUENCE - :"SYS_B_0") SORTSEQUENCE
                                  from TEMP_WBS FILTER, PRDEPENDENCY DEP, PRTASK
                                 WHERE FILTER.TASKID = DEP.PRSUCCTASKID
                                   AND FILTER.CACHEID =  :v0
                                   AND PRTASK.PRID = DEP.PRPREDTASKID
                                   AND DEP.PRPREDTASKID NOT IN ( SELECT TASKID FROM TEMP_WBS W
                                union
                                SELECT FILTER.CACHEID, FILTER.WBSSEQUENCE, DEP.PRSUCCTASKID DE
                                      , (FILTER.WBSSEQUENCE + :"SYS_B_1") SORTSEQUENCE
                                  FROM TEMP_WBS FILTER, PRDEPENDENCY DEP, PRTASK
                                 WHERE FILTER.TASKID = DEP.PRPREDTASKID
                                   AND FILTER.CACHEID =  :v2
                                   AND PRTASK.PRID = DEP.PRSUCCTASKID
                                   AND DEP.PRSUCCTASKID NOT IN ( SELECT TASKID FROM TEMP_WBS W
                                ) q
                        ) z where z.rownbr = :"SYS_B_2" )
 
fd80qgs2d2hvv select count(*) changes
                          from TEMP_WBS wbs, prtask task
                         where wbs.cacheid =  :v0
                           and wbs.taskid = task.prid
                           and task.last_updated_date > ( select created_date from temp_wbs_ke
 
fjac9atbz6k9z SELECT CMN_SESSION_PROPERTIES.ID, CMN_SESSION_PROPERTIES.SESSION_ID, CMN_SESSION
                        FROM CMN_SESSION_PROPERTIES, CMN_SESSIONS
                        WHERE CMN_SESSION_PROPERTIES.SESSION_ID=CMN_SESSIONS.ID
                        AND CMN_SESSIONS.TOKEN= :v0
                        AND CMN_SESSION_PROPERTIES.NAME= :v1
 
g3176qdxahvv9 select :"SYS_B_0" from dual
g4qxcmbxv2k4a select   :"SYS_B_0" pmd_analytical_partition_by, inv_investments.id odf_pk, odf_
                        NVL( CMN_PAGES.ORIGINATING_PAGE_ID, CMN_PAGES.ID ) )
                        FROM CMN_INSTANCE_PAGES, CMN_PAGES, ODF_CA_PROJECT
                        WHERE CMN_INSTANCE_PAGES.PAGE_FRAME_ID = CMN_PAGES.ID
                        AND CMN_INSTANCE_PAGES.OBJECT_INSTANCE_ID = INV_INVESTMENTS.ID
                        AND (CMN_INSTANCE_PAGES.OBJECT_TYPE = :"SYS_B_2"  OR CMN_INSTANCE_PAGE
                        AND CMN_INSTANCE_PAGES.OBJECT_INSTANCE_ID = ODF_CA_PROJECT.ID) odf_pag
 
g8q1jsf1jzkaw SELECT COUNT(*) BASELINE_COUNT
                          FROM PRJ_BASELINES
                         WHERE PRJ_BASELINES.PROJECT_ID =  :v0
 
gd1ng353x11cv UPDATE PRASSIGNMENT
                      SET    PRPENDACTSUM =
                              (SELECT NVL(SUM(PRTIMEENTRY.PRACTSUM), :"SYS_B_0")
                               FROM   PRTIMEENTRY , PRTIMESHEET
                               WHERE  PRTIMEENTRY.PRASSIGNMENTID =  :v0
                               AND    PRTIMEENTRY.PRTIMESHEETID = PRTIMESHEET.PRID
                               AND    PRTIMESHEET.PRSTATUS < :"SYS_B_1")
                      WHERE PRID =  :v1
 
ggad02ybwcj1d update PRTIMESHEET set prversion= :v0 , prmodtime= :v1  where prid= :v2
ggkd4xrct6vtk select count(*) locks from prlock where prname= :v0  and prtablename= :v1  and p
ghgvj04fwacxb select   :"SYS_B_0" pmd_analytical_partition_by, inv_investments.id odf_pk, inv_
gp1yvuxyq32dp delete
                          from TEMP_WBS_EXT
                         where cacheid =  :v0
 
gxzy470b6cvyk SELECT  I.NAME, I.ID, I.SCHEDULE_START START_DATE, I.SCHEDULE_FINISH FINISH_DATE
                        FROM    INV_INVESTMENTS I, INV_PROJECTS P
                        WHERE   I.ID =  :v0
                        AND     P.PRID = I.ID
Thank you very much!

Outcomes