Berkas tidak ada di InboxBerkas

Buat Pak Sami Boy di Bogor
Untuk kasus berkas yang tidak ada di inboxberkas harus dijalankan pake SQL


insert into inboxberkas

SELECT DISTINCT A.*,g.WFMPROFILE,e.subyekid,c.duedate_ ,w.useridto

FROM

BERKAS A, JBPM_TOKEN B, JBPM_TASKINSTANCE C, SUBYEKBERKAS D,

PERORANGAN E, SUBYEK F, PROFILE G,

(SELECT

berkasflow.berkasid, berkasflow.useridto, profile.keterangan EMPLOYEENAME

FROM berkasflow, profile

WHERE

berkasflow.berkasflowterakhir = '1'

AND profile.profileid = berkasflow.useridto) W

WHERE

A.BERKASWFM = B.PROCESSINSTANCE_ AND

B.ID_ = C.TOKEN_ AND

G.WFMPROFILE(+) = C.ACTORID_ AND G.FLAGSPOPP = 'Y' AND

D.BERKASID(+) = A.BERKASID AND

D.SUBYEKID = E.SUBYEKID(+) AND

D.SUBYEKID = F.SUBYEKID(+) AND

W.BERKASID(+) = A.BERKASID AND

D.SUBYEKTIPE(+) = 'P' AND

a.berkasyear =2008 and a.berkasnomor=2900 and

(A.BERKASSTATUS = '1' or A.BERKASSTATUS = '2') AND

C.END_ IS NULL AND

A.KODESPOPP <> 'SPOPP-1.01.1' AND

A.KODESPOPP <> 'SPOPP-1.01.2' AND

C.ISCANCELLED_ = 0;

Baca Selengkapnya..