Anonymous

CREATE OR REPLACE FORCE VIEW TRD_FOE_ADMINIS.TRD_FOE_VWORKFLOW(   IDAPLICACION,   ID,   ACTIVITYNAME,   TYPE,   FINI,   FFIN,   EXECUTION,   PROCID,   STATE,   TRANSITION,   ASSIGNEE,   PROCESS_ID,   PROCESS_NAME,   CREATION_DATE,   MODIFICATION_DATE,   CODE_USER,   DATE_MOD,   DATE_INSERT,   PROCESS,   AT_TIME,   ALARM)AS     SELECT   DISTINCT              D.NAME AS IDAPLICACION,              A.DBID_ AS ID,              A.activity_name_ AS ActivityName,              A.type_ AS TYPE,              A.start_ AS Fini,              A.end_ AS FFin,              A.execution_ AS Execution,              B.procdefid_ AS ProcId,              B.state_ AS State,              G.NEXTDECISION AS Transition,              G.USER_CODE AS Assignee,              CAST (E.ID AS varchar2 (30)) AS PROCESS_ID,              E.NAME AS PROCESS_NAME,              SYSDATE AS CREATION_DATE,              SYSDATE AS MODIFICATION_DATE,              CAST ('WF' AS varchar2 (6)) AS CODE_USER,              SYSDATE AS DATE_MOD,              SYSDATE AS DATE_INSERT,              CAST ('WF' AS varchar2 (6)) AS PROCESS,              DECODE (                 G.duration,                 0,                 'at_time',                 DECODE (                    GREATEST (A.start_ + G.duration, NVL (A.end_, SYSDATE)),                    NVL (A.end_, SYSDATE) + 0,                    'backward',                    'at_time'                 )              )                 AS AT_TIME,              DECODE (                 G.duration,                 0,                 'no_alarm',                 DECODE (                    A.end_,                    NULL,                    DECODE (                       GREATEST (G.alarm, ( (A.start_ + G.duration) - SYSDATE)),                       G.alarm,                       'alarm',                       'no_alarm'                    ),                    'no_alarm'                 )              )                 AS ALARM       FROM   JBPM4_HIST_ACTINST A,              JBPM4_HIST_PROCINST B,              JBPM4_HIST_TASK C,              TRD_FOE_WF_APPLICATION D,              TRD_FOE_WF_PROCESS E,              TRD_FOE_CONTACTS F,              TRD_FOE_WF_NODE G      WHERE       B.ID_ = A.EXECUTION_              AND A.HTASK_ = C.DBID_              AND E.ID = D.ID_PROCESS              AND D.ID_ = B.ID_              AND B.PROCDEFID_ = E.KEY || '-' || E.VERSION              AND F.ID = 1              AND A.activity_name_ = G.NAME   ORDER BY   A.DBID_;