54 lines
993 B
Plaintext
54 lines
993 B
Plaintext
àÍÒ¢éÍÁÙÅä»äÇé·Õè table : endr_tmp_data_print
|
|
|
|
¢éÍÁÙÅ·ÕèµéͧãÊè
|
|
PROCESS_ID ==> gen µèͤÃÑ駷ÕèÊÑ觾ÔÁ¾ì
|
|
TASK_ID ==> §Ò¹·ÕèàÅ×Í¡
|
|
USER_ID ==> user ·ÕèÊÑ觾ÔÁ¾ì
|
|
SERVER_ID ==> server printer ·ÕèÊÑ觾ÔÁ¾ì
|
|
|
|
CREATE_BY
|
|
CREATE_DATE
|
|
UPDATE_BY
|
|
UPDATE_DATE
|
|
|
|
|
|
|
|
|
|
áÊ´§ printer server
|
|
|
|
procedure sp_sch_printer(
|
|
cRecordset out sys_refcursor,
|
|
sUser_id in varchar2
|
|
)
|
|
|
|
|
|
|
|
|
|
procedure sp_sch_team(
|
|
cRecordset out sys_refcursor,
|
|
sUser_id in varchar2
|
|
);
|
|
|
|
|
|
|
|
pkg_ws_login.sp_sch_data_print(crecordset => :crecordset,
|
|
steam => :steam,
|
|
spolicy => :spolicy,
|
|
sclient => :sclient,
|
|
stype => :stype);
|
|
|
|
|
|
|
|
|
|
|
|
|
|
///////////////// search
|
|
|
|
|
|
select t.processid ,t.enddate ,t.outcome ,t.approvers
|
|
,t.textattribute1 ,t.textattribute2 ,t.textattribute3 ,t.numberattribute1
|
|
from wftask t where t.taskid='62f54360-0065-45a8-8440-88888ed9c54d'
|
|
|
|
|
|
|