SQL Id | SQL Text |
04xtrk7uyhknh | select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null |
082643d8tz90x | UPDATE rt_actinst_data SET data=:1 WHERE instance_id=:2 AND name=:3 |
09uxzvh4hbn17 |
select
t.PROC_INSTANCE_ID,
t.ACTIVITY_INS_ID,
t.WORKITEM_INS_ID,
t.NAME,
t.CURRENT_STATE,
t.COMPLETE_TIME,
t.CREATE_TIME,
t.LIMIT_TIME,
t.APP_URL,
t.USER_NAME,
t.USER_ID,
t.USER_ENTITY_TYPE,
t.USER_ENTITY_NAME,
t.USER_ENTITY_ID,
t.PARTICIPANT_TYPE,
t.SEND_TYPE,
t.OVERDUED_NE,
t.EXT_PROP,
t.FLOW_DIRECTION,
t.BUSINESSKEY,
t.DEPART_ID,
t.WI_INSTANCE_ID,
t.WI_INSTANCE_NAME,
t.WI_WORKFORM_TYPE,
t.WI_BUILDER,
t.WI_CREATE_TIME,
t.WI_INSTANCE_STATUS,
t.WI_BUSINESS,
t.WI_KEYDATA_ID,
t.WI_IS_FLOW,
t.WI_ATTR1,
t.WI_DEPT_ID,
t.WT_DEPT_ID,
t.WT_WORKTASK_STATUS,
t.WT_TARGET_TIME,
t.WT_LINK_URL,
t.WT_LINK_PARAM,
t.WT_IS_BATCH,
t.WI_BUILDER_REALNAME,
t.HOWLONG_WILL_OVERDUE,
t.HOWLONG_OVERDUED,
t.ACTIVITY_TMP_ID,
t.TARGET_TIME_NE,
t.BE_APPROVAL_STATUS,
t.ORG_NO,
t.OR
G_NAME,
t.VIEW_FLAGS,
t.OVERDUED,
t.TARGET_TIME,
t.WORKFORM_TYPE_KIND ,
s_app.cons_no ,
s_app.CONS_NAME,
s_app.ELEC_ADDR,
s_app.APP_CONTRACT_CAP,
s_app.CONTRACT_CAP,
s_app.VOLT_CODE , sa_org.org_name as ORG_NAME_SR,
s_app.org_no as ORG_NO_SR,
s_app.HANDLE_TIME as HANDLE_TIME
FROM (SELECT LI.*,
CASE
WHEN LI.OVERDUED_NE = 1 OR LI.OVERDUED_NE = 3 THEN 1
WHEN LI.OVERDUED_NE = 0 OR LI.OVERDUED_NE = 2 THEN
CASE
WHEN E.SUSPEND_FLAG = 0 THEN
CASE
WHEN SYSTIMESTAMP >= E.TARGET_OVERDUE_MINTIME THEN 1
ELSE 0
END
WHEN E.SUSPEND_FLAG = 1 THEN
CASE
WHEN E.SUSPEND_TIME >= E.TARGET_OVERDUE_MINTIME THEN 1
ELSE 0
END
ELSE 0
END
ELSE 0
END OVERDUED,
CASE
WHEN E.TARGET_OVERDUE_MINTIME IS NULL THEN LI.TARGET_TIME_NE
WHEN E.TARGET_OVERDUE_MINTIME <= LI.TARGET_TIME_NE THEN E.TARGET_OVERDUE_MINTIME
ELSE LI.TARGET_TIME_NE
END TARGET_TIME,
FTM.WORKFORM_TYPE_KIND
FROM (SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/
WF.PROC_INSTANCE_ID,
WF.ACTIVITY_INS_ID,
WF.WORKITEM_INS_ID,
WF.NAME,
WF.CURRENT_STATE,
WF.COMPLETE_TIME,
WF.CREATE_TIME,
WF.LIMIT_TIME,
WF.APP_URL,
WF.USER_NAME,
WF.USER_ID,
WF.USER_ENTITY_TYPE,
WF.USER_ENTITY_NAME,
WF.USER_ENTITY_ID,
WF.PARTICIPANT_TYPE,
WF.SEND_TYPE,
WF.OVERDUED AS OVERDUED_NE,
WF.EXT_PROP,
WF.FLOW_DIRECTION,
WF.BUSINESSKEY,
WF.DEPART_ID,
F.INSTANCE_ID AS WI_INSTANCE_ID,
F.INSTANCE_NAME AS WI_INSTANCE_NAME,
F.WORKFORM_TYPE AS WI_WORKFORM_TYPE,
F.BUILDER AS WI_BUILDER,
F.START_TIME AS WI_CREATE_TIME,
F.INSTANCE_STATUS AS WI_INSTANCE_STATUS,
F.BUSINESS AS WI_BUSINESS,
F.KEYDATA_ID AS WI_KEYDATA_ID,
F.IS_FLOW AS WI_IS_FLOW,
F.ATTR1 AS WI_ATTR1,
F.DEPT_ID AS WI_DEPT_ID,
'' AS WT_DEPT_ID,
WF.CURRENT_STATE AS WT_WORKTASK_STATUS,
NULL AS WT_TARGET_TIME,
'' AS WT_LINK_URL,
'' AS WT_LINK_PARAM,
'' AS WT_IS_BATCH,
U.REAL_NAME AS WI_BUILDER_REALNAME,
NULL AS HOWLONG_WILL_OVERDUE,
NULL AS HOWLONG_OVERDUED,
'' AS ACTIVITY_TMP_ID,
O.TIME_OUT_TIME AS TARGET_TIME_NE,
B.APPROVAL_STATUS AS BE_APPROVAL_STATUS,
ORG.ORG_NO,
ORG.ORG_NAME,
'' AS VIEW_FLAGS
FROM SA_WORKFORM_INST F,
(SELECT W.*
FROM RT_WORKITEMINST W
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = :1
AND W.PARTICIPANT_TYPE = 0
UNION ALL
SELECT W.*
FROM RT_WORKITEMINST W, SA_BROLE_USER R
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = R.ROLE_ID
AND R.USER_ID = :2
AND W.PARTICIPANT_TYPE = 1) WF,
SA_USER U,
(SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O,
SA_WF_BUSINESS_EXT B,
SA_DEPT D,
SA_ORG ORG
WHERE F.PROCINST_ID = WF.PROC_INSTANCE_ID
AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+)
AND F.BUILDER = U.USER_ID(+)
AND U.DEPT_ID = D.DEPT_ID(+)
AND D.ORG_NO = ORG.ORG_NO(+)
AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+)
AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((WF.DEPART_ID LIKE :3) OR (:4 LIKE (WF.DEPART_ID || '%')) OR (:5 = WF.DEPART_ID))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((F.DEPT_ID LIKE :6) OR (:7 LIKE (F.DEPT_ID || '%')) OR (:8 = F.DEPT_ID))))))
UNION ALL
SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/
WF.PROC_INSTANCE_ID,
WF.ACTIVITY_INS_ID,
WF.WORKITEM_INS_ID,
WF.NAME,
WF.CURRENT_STATE,
WF.COMPLETE_TIME,
WF.CREATE_TIME,
WF.LIMIT_TIME,
WF.APP_URL,
WF.USER_NAME,
WF.USER_ID,
WF.USER_ENTITY_TYPE,
WF.USER_ENTITY_NAME,
WF.USER_ENTITY_ID,
WF.PARTICIPANT_TYPE,
WF.SEND_TYPE,
WF.OVERDUED AS OVERDUED_NE,
WF.EXT_PROP,
WF.FLOW_DIRECTION,
WF.BUSINESSKEY,
WF.DEPART_ID,
F.INSTANCE_ID AS WI_INSTANCE_ID,
F.INSTANCE_NAME AS WI_INSTANCE_NAME,
F.WORKFORM_TYPE AS WI_WORKFORM_TYPE,
F.BUILDER AS WI_BUILDER,
F.START_TIME AS WI_CREATE_TIME,
F.INSTANCE_STATUS AS WI_INSTANCE_STATUS,
F.BUSINESS AS WI_BUSINESS,
F.KEYDATA_ID AS WI_KEYDATA_ID,
F.IS_FLOW AS WI_IS_FLOW,
F.ATTR1 AS WI_ATTR1,
F.DEPT_ID AS WI_DEPT_ID,
'' AS WT_DEPT_ID,
WF.CURRENT_STATE AS WT_WORKTASK_STATUS,
NULL AS WT_TARGET_TIME,
'' AS WT_LINK_URL,
'' AS WT_LINK_PARAM,
'' AS WT_IS_BATCH,
U.REAL_NAME AS WI_BUILDER_REALNAME,
NULL AS HOWLONG_WILL_OVERDUE,
NULL AS HOWLONG_OVERDUED,
'' AS ACTIVITY_TMP_ID,
O.TIME_OUT_TIME AS TARGET_TIME_NE,
B.APPROVAL_STATUS AS BE_APPROVAL_STATUS,
ORG.ORG_NO,
ORG.ORG_NAME,
'' AS VIEW_FLAGS
FROM SA_WORKFORM_INST F,
(SELECT W.*
FROM RT_WORKITEMINST W
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER
_ID = :9
AND W.PARTICIPANT_TYPE = 0
UNION ALL
SELECT W.*
FROM RT_WORKITEMINST W, SA_BROLE_USER R
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = R.ROLE_ID
AND R.USER_ID = :10
AND W.PARTICIPANT_TYPE = 1) WF,
SA_USER U,
RT_PROCESSINSTANCE P,
(SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O,
SA_WF_BUSINESS_EXT B,
SA_DEPT D,
SA_ORG ORG
WHERE WF.PROC_INSTANCE_ID = P.PROC_INSTANCE_ID
AND P.PARENT_PROCINC_ID IS NOT NULL
AND F.PROCINST_ID = P.PARENT_PROCINC_ID
AND F.BUILDER = U.USER_ID(+)
AND U.DEPT_ID = D.DEPT_ID(+)
AND D.ORG_NO = ORG.ORG_NO(+)
AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+)
AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+)
AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((WF.DEPART_ID LIKE :11) OR (:12 LIKE (WF.DEPART_ID || '%')) OR (:13 = WF.DEPART_ID))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((F.DEPT_ID LIKE :14) OR (:15 LIKE (F.DEPT_ID || '%')) O
R (:16 = F.DEPT_ID))))))
AND NOT EXISTS
(SELECT 1
FROM SA_WORKFORM_INST RF
WHERE WF.PROC_INSTANCE_ID = RF.PROCINST_ID)) LI,
SA_WF_WORKFORM_TYPE_MAP FTM,
(SELECT ACT_INST_ID,
SUSPEND_FLAG,
MIN(TARGET_OVERDUE_MINTIME) AS TARGET_OVERDUE_MINTIME,
MIN(SUSPEND_TIME) AS SUSPEND_TIME
FROM (SELECT A.ACT_INST_ID, B.*
FROM SA_WF_EXAM_ACT_INST A, SA_WF_EXAM_INST B
WHERE A.SUBJECT_INST_ID = B.SUBJECT_INST_ID
AND A.PROC_INST_ID = B.PROC_INST_ID
AND B.COMPLETE_FLAG = 0)
GROUP BY ACT_INST_ID, SUSPEND_FLAG) E
WHERE LI.WI_WORKFORM_TYPE = FTM.WORKFORM_TYPE(+)
AND LI.ACTIVITY_INS_ID = E.ACT_INST_ID(+)) T, s_app , sa_org
WHERE NOT EXISTS (SELECT 1
FROM SA_WF_WORKITEM_EXCLUDED_USER US
WHERE T.WORKITEM_INS_ID = US.WORKITEM_ID
AND US.USER_ID = :17)
AND T.WORKFORM_TYPE_KIND = '001'
and s_app.org_no = sa_org.org_no(+)
and t.wi_keydata_id = s_app.app_no(+) |
0h6b2sajwb74n | select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
130rf596xjbkf | UPDATE C_CONS
SET CHARGE_NUM = NVL(CHARGE_NUM, 0) + 1
WHERE CONS_NO = :1
AND ORG_NO = :2 |
1a0wsq0y0px7f |
select
sw.reply_tel ,
org.org_name,
case when exists(select * from P_PROC_BACK ppb where ppb.app_no = sw.app_no and ppb.app_no2 =
(
select sx.busi_no from sa_busi_proc sx where sx.proc_id= (select max(proc_id) from sa_busi_proc s1 where s1.app_no=sw.app_no and sw.busi_type_code='001' and s1.busi_no is not null)
)
)
then '??'
else ''
end attr1,
(select value
from
(select a.value , a.app_no from s_wkst_ext_attr a where a.attr_info_id = 10207025 order by a.extend_attr_id desc)ga
where ga.app_no =sw.sg_app_no and rownum=1) remark,
s_srv_req.CONTACT_NAME ,
s_srv_req.ADDR,
s_srv_req.CUST_NAME,
s_srv_req.REQ_DATE,
sw.county_code,
(select DISTRICT_NAME from sa_c_district where DISTRICT_NO = sw.COUNTY_CODE)as county_name,
SW.ACCEPT_CONTENT,
SW.HANDLE_CONTENT,
t.name,
case when exists(select 1 from s_wkst_ext_attr satt where satt.app_no=sw.app_no and sw.org_no like'51401%' and satt.value='????' and satt.attr_info_id='30000000002600')
then t.wi_instance_name||'??????'
when not exists(select 1 from s_wkst_ext_attr satt where satt.app_no=sw.app_no and sw.org_no like'51401%' and satt.value='????' and satt.attr_info_id='30000000002600')
and exists(select 1 from s_wkst_ext_attr satt where satt.app_no=sw.app_no and sw.org_no like'51401%' and satt.value='????' and satt.attr_info_id='30000000002500')
then t.wi_instance_name||'??????'
else t.wi_instance_name
end wi_instance_name ,
t.proc_instance_id, t.act
ivity_ins_id, t.workitem_ins_id, t.current_state, t.complete_time, t.create_time, t.limit_time, t.app_url, t.user_name,
t.user_id, t.user_entity_type, t.user_entity_name, t.user_entity_id, t.participant_type, t.send_type, t.overdued_ne, t.ext_prop, t.flow_direction,
t.businesskey, t.depart_id, t.wi_instance_id, t.wi_workform_type, t.wi_builder, t.wi_create_time, t.wi_instance_status, t.wi_business,
t.wi_keydata_id, t.wi_is_flow, t.wi_attr1, t.wi_dept_id, t.wt_dept_id, t.wt_worktask_status, t.wt_target_time, t.wt_link_url, t.wt_link_param, t.wt_is_batch,
t.wi_builder_realname, t.howlong_will_overdue, t.howlong_overdued, t.activity_tmp_id, t.target_time_ne, t.be_approval_status, t.org_no,
t.view_flags, t.overdued, t.target_time, t.workform_type_kind
from
(
select li.*,
CASE
WHEN li.overdued_ne = 1 or li.overdued_ne = 3 THEN 1
WHEN li.overdued_ne = 0 or li.overdued_ne = 2 THEN
CASE
WHEN e.suspend_flag = 0 THEN
CASE
WHEN systimestamp >= e.target_overdue_mintime THEN 1
ELSE 0
END
WHEN e.suspend_flag = 1 THEN
CASE
WHEN e.suspend_time >= e.target_overdue_mintime THEN 1
ELSE 0
END
ELSE 0
END
ELSE 0
END overdued,
CASE
WHEN E.TARGET_OVERDUE_MINTIME IS NULL THEN LI.TARGET_TIME_NE
WHEN E.TARGET_OVERDUE_MINTIME <= LI.TARGET_TIME_NE THEN E.TARGET_OVERDUE_MINTIME
ELSE LI.TARGET_TIME_NE
END target_time,
ftm.workform_type_kind
from
(select /*+index(f IDX_WORKFORM_PROCINST_ID)*/
wf.proc_instance_id,
wf.activity_ins_id,
wf.workitem_ins_id,
wf.name,
wf.current_state,
wf.complete_time,
wf.create_time,
wf.limit_time,
wf.app_url,
wf.user_name,
wf.user_id,
wf.user_entity_type,
wf.user_entity_name,
wf.user_entity_id,
wf.participant_type,
wf.send_type,
wf.overdued as overdued_ne,
wf.ext_prop,
wf.flow_direction,
wf.businesskey,
wf.depart_id,
f.instance_id as wi_instance_id,
f.instance_name as wi_instance_name,
f.workform_type as wi_workform_type,
f.builder as wi_builder,
f.
start_time as wi_create_time,
f.instance_status as wi_instance_status,
f.business as wi_business,
f.keydata_id as wi_keydata_id,
f.is_flow as wi_is_flow,
f.attr1 as wi_attr1,
f.dept_id as wi_dept_id,
'' as wt_dept_id,
wf.current_state as wt_worktask_status,
null as wt_target_time,
'' as wt_link_url,
'' as wt_link_param,
'' as wt_is_batch,
u.real_name as wi_builder_realname,
null as howlong_will_overdue,
null as howlong_overdued,
'' as activity_tmp_id,
o.time_out_time as target_time_ne,
b.approval_status as be_approval_status,
org.org_no,
--org.org_name,
'' as view_flags
from sa_workform_inst f,
(select w.*
from rt_workiteminst w
where (w.current_state = 1 OR w.current_state = 2 OR
w.current_state = 3)
and w.user_id = :1
and w.participant_type = 0
union all
select w.*
from rt_workiteminst w, sa_brole_user r
where (w.current_state = 1 OR w.cur
rent_state = 2 OR
w.current_state = 3)
and w.user_id = r.role_id
and r.user_id = :2
and w.participant_type = 1) wf,
sa_user u,
(select * from rt_overtime_deal where timer_type = 1) o,
sa_wf_business_ext b,
sa_dept d,
sa_org org
where f.procinst_id = wf.proc_instance_id
and wf.workitem_ins_id = o.instance_id(+)
and f.builder = u.user_id(+)
and u.dept_id = d.dept_id(+)
and d.org_no = org.org_no(+)
and wf.workitem_ins_id = b.workitem_id(+)
union all
select /*+index(f IDX_WORKFORM_PROCINST_ID)*/
wf.proc_instance_id,
wf.activity_ins_id,
wf.workitem_ins_id,
wf.name,
wf.current_state,
wf.complete_time,
wf.create_time,
wf.limit_time,
wf.app_url,
wf.user_name,
wf.user_id,
wf.user_entity_type,
wf.user_entity_name,
wf.user_entity_id,
wf.participant_type,
wf.send_type,
wf.overdued as overdued_ne,
wf.ex
t_prop,
wf.flow_direction,
wf.businesskey,
wf.depart_id,
f.instance_id as wi_instance_id,
f.instance_name as wi_instance_name,
f.workform_type as wi_workform_type,
f.builder as wi_builder,
f.start_time as wi_create_time,
f.instance_status as wi_instance_status,
f.business as wi_business,
f.keydata_id as wi_keydata_id,
f.is_flow as wi_is_flow,
f.attr1 as wi_attr1,
f.dept_id as wi_dept_id,
'' as wt_dept_id,
wf.current_state as wt_worktask_status,
null as wt_target_time,
'' as wt_link_url,
'' as wt_link_param,
'' as wt_is_batch,
u.real_name as wi_builder_realname,
null as howlong_will_overdue,
null as howlong_overdued,
'' as activity_tmp_id,
o.time_out_time as target_time_ne,
b.approval_status as be_approval_status,
org.org_no,
-- org.org_name,
'' as view_flags
from sa_workform_inst f,
(select w.*
from rt_workiteminst w
where (w.current_state = 1 OR w.current_state = 2 OR
w.current_state = 3)
and w.user_id = :3
and w.participant_type = 0
union all
select w.*
from rt_workiteminst w, sa_brole_user r
where (w.current_state = 1 OR w.current_state = 2 OR
w.current_state = 3)
and w.user_id = r.role_id
and r.user_id = :4
and w.participant_type = 1) wf,
sa_user u,
rt_processinstance p,
(select * from rt_overtime_deal where timer_type = 1) o,
sa_wf_business_ext b,
sa_dept d,
sa_org org
where wf.proc_instance_id = p.proc_instance_id
and p.parent_procinc_id is not null
and f.procinst_id = p.parent_procinc_id
and f.builder = u.user_id(+)
and u.dept_id = d.dept_id(+)
and d.org_no = org.org_no(+)
and wf.workitem_ins_id = o.instance_id(+)
and wf.workitem_ins_id = b.workitem_id(+)
and not exists (select 1 from sa_workform_inst rf where wf.proc_instance_id = rf.procinst_id)
) li,
sa_wf_workform_type_map ftm,
(select act_inst_id,
suspend_flag,
min(target_overdue_mintime) as target_overdue_mintime,
min(suspend_time) as suspend_time
from (select a.act_inst_id, b.*
from sa_wf_exam_act_inst a, sa_wf_exam_inst b
where a.subject_inst_id = b.subject_inst_id
and a.proc_inst_id = b.proc_inst_id
and b.complete_flag = 0)
group by act_inst_id, suspend_flag
) e
where (li.participant_type = 0 or (li.participant_type = 1 and ((depart_id is not null and ((DEPART_ID like :5) or (:6 like (DEPART_ID || '%')) or (:7 = DEPART_ID) or (:8 = DEPART_ID))) or ((depart_id is null or depart_id = '') and ((WI_DEPT_ID like :9) or (:10 like (WI_DEPT_ID || '%')) or (:11 = WI_DEPT_ID) or (:12 = WI_DEPT_ID))))))
and li.wi_workform_type = ftm.workform_type(+)
and li.activity_ins_id = e.act_inst_id(+)
) t ,
s_srv_req ,
s_95598_wkst sw,
sa_org org
where not exists (select 1 from sa_wf_workitem_excluded_user us where t.workitem_ins_id = us.workitem_id and us.user_id = :13 )
and t.WI_WORKFORM_TYPE in
(
SELECT SA_PROP_LIST.PROP_LIST_ID FROM SA_PROP_LIST, SA_WF_WORKFORM_TYPE_MAP
WHERE SA_PROP_LIST.PROP_LIST_ID = SA_WF_WORKFORM_TYPE_MAP.WORKFORM_TYPE
AND SA_PROP_LIST.PROP_TYPE_ID = 'workform_type'
AND SA_PROP_LIST.IS_
DELETE !='1'
AND SA_WF_WORKFORM_TYPE_MAP.WORKFORM_TYPE_KIND = '006'
)
and t.wi_keydata_id =sw.app_no(+)
and org.org_no=sw.org_no
and t.wi_keydata_id = s_srv_req.order_id(+) |
1h3u0gzkc4qtf |
select /*+ FIRST_ROWS */ * from (select t.*, ROWNUM as RN2 from (select view_s_app_workform.WORKFORM_STATUS as "WORKFORM_STATUS", view_s_app_workform.APP_ID as "APP_ID", view_s_app_workform.APP_NO as "APP_NO", view_s_app_workform.APP_MODE as "APP_MODE", view_s_app_workform.HANDLE_DEPT_NO as "HANDLE_DEPT_NO", view_s_app_workform.HANDLE_TIME as "HANDLE_TIME", view_s_app_workform.CONS_NO as "CONS_NO", view_s_app_workform.CONS_NAME as "CONS_NAME", view_s_app_workform.CUST_QUERY_NO as "CUST_QUERY_NO", view_s_app_workform.TMP_PAY_RELA_NO as "TMP_PAY_RELA_NO", view_s_app_workform.ORGN_CONS_NO as "ORGN_CONS_NO", view_s_app_workform.CONS_SORT_CODE as "CONS_SORT_CODE", view_s_app_workform.ELEC_ADDR as "ELEC_ADDR", view_s_app_workform.TRADE_CODE as "TRADE_CODE", view_s_app_workform.ELEC_TYPE_CODE as "ELEC_TYPE_CODE", view_s_app_workform.SHIFT_NO as "SHIFT_NO", view_s_app_workform.LODE_ATTR_CODE as "LODE_ATTR_CODE", view_s_app_workform.VOLT_CODE as "VOLT_CODE", view_s_app_workform.HEC_INDUSTRY_CODE as "HEC_INDUSTRY_CODE", view_s_app_workform.HOLIDAY as "HOLIDAY", view_s_app_workform.NOTIFY_MODE as "NOTIFY_MODE", view_s_app_workform.SETTLE_MODE as "SETTLE_MODE", view_s_app_workform.ORG_NO as "ORG_NO", view_s_app_workform.TRANSFER_CODE as &
quot;TRANSFER_CODE", view_s_app_workform.MR_SECT_NO as "MR_SECT_NO", view_s_app_workform.NOTE_TYPE_CODE as "NOTE_TYPE_CODE", view_s_app_workform.TMP_FLAG as "TMP_FLAG", view_s_app_workform.TMP_DATE as "TMP_DATE", view_s_app_workform.APP_CONTRACT_CAP as "APP_CONTRACT_CAP", view_s_app_workform.ORGN_CONTRACT_CAP as "ORGN_CONTRACT_CAP", view_s_app_workform.CONTRACT_CAP as "CONTRACT_CAP", view_s_app_workform.APP_RUN_CAP as "APP_RUN_CAP", view_s_app_workform.ORGN_RUN_CAP as "ORGN_RUN_CAP", view_s_app_workform.RUN_CAP as "RUN_CAP", view_s_app_workform.BGN_DATE as "BGN_DATE", view_s_app_workform.END_DATE as "END_DATE", view_s_app_workform.REASON as "REASON", view_s_app_workform.SHIFT_IN_CAP as "SHIFT_IN_CAP", view_s_app_workform.SHIFT_OUT_CAP as "SHIFT_OUT_CAP", view_s_app_workform.PERMENANT_REDUCE_FLAG as "PERMENANT_REDUCE_FLAG", view_s_app_workform.CONTENT as "CONTENT", view_s_app_workform.ST_UPQ as "ST_UPQ", view_s_app_workform.LONGTERM_CAP as "LONGTERM_CAP", view_s_app_workform.POWER_USAGE as "POWER_USAGE", view_s_app_workform.DMD_DATE as "DMD_DATE", view_s_app_workform.APP_TYPE_CODE as "APP_TYPE_CODE", view_s_app_workform.HANDLE_FLAG as "HANDLE_FLAG", view_s_app_workform.REFUSE_REASON as "REFUSE_REASON", view_s_ap
p_workform.RELA_APP_CODE as "RELA_APP_CODE", view_s_app_workform.REMARK as "REMARK", view_s_app_workform.MEAS_MODE as "MEAS_MODE", view_s_app_workform.BUILD_DATE as "BUILD_DATE", view_s_app_workform.PS_DATE as "PS_DATE", view_s_app_workform.CANCEL_DATE as "CANCEL_DATE", view_s_app_workform.DUE_DATE as "DUE_DATE", view_s_app_workform.STATUS_CODE as "STATUS_CODE", view_s_app_workform.OPERATE_STATUS as "OPERATE_STATUS", view_s_app_workform.MRD_FACTOR_CODE as "MRD_FACTOR_CODE", view_s_app_workform.IS_FLOW as "IS_FLOW", view_s_app_workform.INSTANCE_STATUS as "INSTANCE_STATUS", view_s_app_workform.COMPLETE_TIME as "COMPLETE_TIME", sa_c_trade_type.TRADE as "TRADE", sa_org.ORG_NO as "ORG_NO1", sa_org.ORG_NAME as "ORG_NAME", view_s_app_workform.DEPT_ID as "DEPT_ID", view_s_app_workform.REAL_NAME as "REAL_NAME", view_s_app_workform.DEPT_NAME as "DEPT_NAME", sa_org.ORG_TREE as "ORG_TREE", '' as "WORKFLOW_NAME", '' as "HANDLE_DEPT_NAME" from view_s_app_workform, sa_c_trade_type, sa_org where ((((view_s_app_workform.TRADE_CODE = sa_c_trade_type.TRADE_CODE(+) and VIEW_S_APP_WORKFORM.org_no = sa_org.org_no(+)) and ((view_s_app_workform.APP_TYPE_CODE=:1 AND view_s_app_workform.INSTANCE_STATUS=:2 AND (view_s_app_workform.HANDLE_TIME>=:3 AND view_s_app
_workform.HANDLE_TIME<=:4)))) and (VIEW_S_APP_WORKFORM.APP_TYPE_CODE IN ('101', '102', '103', '104', '105', '106', '107', '108', '109', '110', '111', '112', '201', '202', '203', '204', '205', '206', '207', '208', '209', '210', '211', '212', '213', '214', '215', '216', '217', '218', '301', '302', '303', '304', '305', '306', '307', '311', '351', '357', '715', '716', '901', '902'))) and (SA_ORG.ORG_TREE LIKE :5)) and (VIEW_S_APP_WORKFORM.ORG_NO LIKE :6) order by VIEW_S_APP_WORKFORM.APP_NO DESC) t where ROWNUM <= :7) where RN2 > :8 |
1mjd9xp80vuqa | select node, owner, name from syn$ where obj#=:1 |
1n1stjjw32fyv |
MERGE INTO SA_RPT_BASE_EP_DLXSMX_CONFIRM S USING (SELECT A.PRC_CODE, NVL (COUNT (C.MP_ID), 0) CONS_COUNT FROM C_CONS_PRC A, (SELECT CONS_ID FROM C_CONS A, R_OPER_ACTIVITY B, SA_USER C, SA_DEPT D, R_SECT E WHERE TO_CHAR (BUILD_DATE, 'YYYYMM') <= :B2 AND STATUS_CODE <> '9' AND A.ORG_NO = :B1 AND A.MR_SECT_NO = B.MR_SECT_NO AND E.MR_SECT_NO = B.MR_SECT_NO AND E.ORG_NO = :B1 AND B.OPERATOR_NO = C.USER_ID AND C.DEPT_ID = D.DEPT_ID AND (D.ATTR2 IS NULL OR D.ATTR2 <> '1') AND B.ACT_CODE = '08' AND B.EFFECT_FLAG = '1' UNION ALL SELECT CONS_ID FROM C_CONS A, R_OPER_ACTIVITY B, SA_USER C, SA_DEPT D, R_SECT E WHERE TO_CHAR (CANCEL_DATE, 'YYYYMM') >= :B2 AND STATUS_CODE = '9' AND A.ORG_NO = :B1 AND A.MR_SECT_NO = B.MR_SECT_NO AND E.MR_SECT_NO = B.MR_SECT_NO AND E.ORG_NO = :B1 AND B.OPERATOR_NO = C.USER_ID AND C.DEPT_ID = D.DEPT_ID AND (D.ATTR2 IS NULL OR D.ATTR2 <> '1') AND B.ACT_CODE = '08' AND B.EFFECT_FLAG = '1') B, C_MP C, E_CAT_PRC E, C_SP D WHERE D.SP_ID = C.SP_ID AND D.CONS_ID = B.CONS_ID AND D.SP_ID = A.SP_ID AND A.TARIFF_ID = C.TARIFF_ID AND E.PRC_CODE = A.PRC_CODE AND C.ORG_NO = :B1 AND E.PARA_VN = GET_EFFECT_PARA_VN ('1') AND C.STATUS_CODE <> '04' AND C.USAGE_TYPE_CODE = '01' AND E.PRC_CODE NOT IN ('90402003', '90403003', '90402001', '90403001', '90403002') AND E.ELEC_TYPE_CODE <> :B3 GROUP BY A.PRC_CODE) E ON ( E.PRC_CODE = S.PRC_CODE AND S.ORG_NO = :B1 AND S.FEE_MONTH = :B2 AND S.RPT_NAME = 'RPT_BASE_EP_DLXSMX_CONFIRM') WHEN
MATCHED THEN UPDATE SET S.CONS_COUNT = E.CONS_COUNT WHEN NOT MATCHED THEN INSERT (RPT_ID, ORG_NO, FEE_MONTH, PRC_CODE, CONS_COUNT, RPT_NAME) VALUES (UG_PUB.UF_GET_NEXT_LONG_CODE ('SA_RPT_BASE_EP_DLXSMX_CONFIRM', 'RPT_ID'), :B1 , :B2 , E.PRC_CODE, E.CONS_COUNT, 'RPT_BASE_EP_DLXSMX_CONFIRM') |
1rv5d17ntkmfk |
select /*+ FIRST_ROWS */ * from (select t.*, ROWNUM as RN2 from (select c_cons.CONS_ID as "CONS_ID", c_cons.VAT_ID as "VAT_ID", c_vat.VAT_NAME as "VAT_NAME", c_cons.CUST_ID as "CUST_ID", c_cons.CONS_NO as "CONS_NO", c_cons.CONS_NAME as "CONS_NAME", c_cons.CUST_QUERY_NO as "CUST_QUERY_NO", c_cons.TMP_PAY_RELA_NO as "TMP_PAY_RELA_NO", c_cons.ORGN_CONS_NO as "ORGN_CONS_NO", c_cons.ELEC_ADDR as "ELEC_ADDR", c_cons.TRADE_CODE as "TRADE_CODE", (select TRADE from sa_c_trade_type where c_cons.TRADE_CODE = sa_c_trade_type.TRADE_CODE) as "TRADE", c_cons.ELEC_TYPE_CODE as "ELEC_TYPE_CODE", c_cons.CONTRACT_CAP as "CONTRACT_CAP", c_cons.RUN_CAP as "RUN_CAP", c_cons.SHIFT_NO as "SHIFT_NO", c_cons.LODE_ATTR_CODE as "LODE_ATTR_CODE", c_cons.HEC_INDUSTRY_CODE as "HEC_INDUSTRY_CODE", c_cons.HOLIDAY as "HOLIDAY", c_cons.BUILD_DATE as "BUILD_DATE", c_cons.PS_DATE as "PS_DATE", c_cons.CANCEL_DATE as "CANCEL_DATE", c_cons.DUE_DATE as "DUE_DATE", c_cons.NOTIFY_MODE as "NOTIFY_MODE", c_cons.SETTLE_MODE as "SETTLE_MODE", c_cons.STATUS_CODE as "STATUS_CODE", c_cons.ORG_NO as "ORG_NO", (select ORG_NAME from sa_org where c_cons.ORG_NO = sa_org.ORG_NO) as "ORG_NAME", c_cons.RRIO_CODE as "RRIO_COD
E", c_cons.CHK_CYCLE as "CHK_CYCLE", c_cons.LAST_CHK_DATE as "LAST_CHK_DATE", c_cons.CHECKER_NO as "CHECKER_NO", (select REAL_NAME from sa_user where c_cons.CHECKER_NO = sa_user.USER_ID) as "CHECKER_NAME", c_cons.POWEROFF_CODE as "POWEROFF_CODE", c_cons.TRANSFER_CODE as "TRANSFER_CODE", c_cons.MR_SECT_NO as "MR_SECT_NO", c_cons.NOTE_TYPE_CODE as "NOTE_TYPE_CODE", c_cons.TMP_FLAG as "TMP_FLAG", c_cons.TMP_DATE as "TMP_DATE", c_cons.MEAS_MODE as "MEAS_MODE", c_cons.DB_TIMESTAMP as "DB_TIMESTAMP", c_cons.VOLT_CODE as "VOLT_CODE", c_cons.CONS_SORT_CODE as "CONS_SORT_CODE", '' as "PAY_MODE", '' as "MADE_NO", '' as "BAR_CODE", '' as "ASSET_NO", '' as "MADE_NO1", '' as "BAR_CODE1", '' as "ASSET_NO1", '' as "TELE_NO", '' as "OPERATOR_NO", '' as "TG_ID", '' as "LINE_ID", '' as "MP_MEAS_MODE", '' as "METER_FLAG", c_cons.CARD_NO as "CARD_NO", (select c_acct.pay_no from c_acct, c_payment_rela where c_acct.acct_id = c_payment_rela.acct_id and c_payment_rela.cons_id = c_cons.cons_id and rownum = 1) as "PAY_NO", (select t.LINK_LIST_ID from sa_prop_list t where t.PROP_TYPE_ID = 'volt_code' and t.PROP_LIST_ID = c_cons.VOLT_CODE) as "PRC_VOLT_CODE", '' as "MR
_MODE_CODE", '' as "CUST_NO", '' as "TRAN_MADE_NO", '' as "SUBS_ID", '' as "EMP_NO", '' as "EMP_NAME", (select real_name from sa_user where user_id = (select r_oper_activity.operator_no from r_sect, r_oper_activity where r_sect.mr_sect_no = r_oper_activity.mr_sect_no and r_oper_activity.ACT_CODE = '03' and r_sect.mr_sect_no = c_cons.mr_sect_no)) as "OPERATOR_NAME", (select emp_no from o_staff where staff_no = c_cons.CHECKER_NO and rownum = 1) as "CHKER_EMP_NO", '' as "IF_SUBSCIBE", '' as "SUBSCRIBE_ITEM", '' as "MOBILE", (select ATTR1 from sa_org where c_cons.ORG_NO = sa_org.ORG_NO) as "ATTR1", (select t.VAL_STR from sa_c_ea_val t where t.ATTR_ID = '22' and t.ATTR_CODE = 'CHK_DEPT' and t.OBJ_CODE = 'C_CONS' and t.CONS_ID = C_CONS.CONS_ID) as "CK_DEPT", (select t.VAL_STR from sa_c_ea_val t where t.ATTR_CODE = 'CK_DEPT_DIALOG_LABEL' and t.OBJ_CODE = 'C_CONS' and t.CONS_ID = C_CONS.CONS_ID) as "CK_DEPT_DIALOG_LABEL", (select r_plan.mr_mode_code MR_MODE_CODE from r_plan where c_cons.mr_sect_no = r_plan.mr_sect_no(+) and rownum = '1') as "MR_MODE_CODE1", '' as "BANK_ACCT", '' as "CUST_ACCT_NAME", '' as "HAS_OLD_PLAN", c_cons.PRIO_CODE as "PRIO_CODE", '' as "PRC_CODE", (select c_cust.credit_level_code from c_cust where c_cust.cust_id = c_cons.cust_id) as "CREDIT_L
EVEL_CODE", (select c_cust.value_level_code from c_cust where c_cust.cust_id = c_cons.cust_id) as "VALUE_LEVEL_CODE", (select c_cust.RISK_LEVEL_CODE from c_cust where c_cust.cust_id = c_cons.cust_id) as "RISK_LEVEL_CODE", (select c_cust.VIP_LEVEL from c_cust where c_cust.cust_id = c_cons.cust_id) as "VIP_LEVEL", (select c_cust.VIP_FLAG from c_cust where c_cust.cust_id = c_cons.cust_id) as "VIP_FLAG", '' as "HAS_MP_STATUS", c_cons.URBAN_RURAL_FLAG as "URBAN_RURAL_FLAG" from c_cons, c_vat where (c_cons.VAT_ID = c_vat.VAT_ID(+)) and (c_cons.ORG_NO like :1 AND C_CONS.CONS_ID IN('705062345'))) t where ROWNUM <= :2) where RN2 > :3 |
1vwxgjybd2yzr | BEGIN UG_SRAP.UP_ARC(:1, :2); END; |
1yybxy27zzaxt |
select /*+ FIRST_ROWS */ * from (select t.*, ROWNUM as RN2 from (select c_cons.CONS_ID as "CONS_ID", c_cons.VAT_ID as "VAT_ID", c_vat.VAT_NAME as "VAT_NAME", c_cons.CUST_ID as "CUST_ID", c_cons.CONS_NO as "CONS_NO", c_cons.CONS_NAME as "CONS_NAME", c_cons.CUST_QUERY_NO as "CUST_QUERY_NO", c_cons.TMP_PAY_RELA_NO as "TMP_PAY_RELA_NO", c_cons.ORGN_CONS_NO as "ORGN_CONS_NO", c_cons.ELEC_ADDR as "ELEC_ADDR", c_cons.TRADE_CODE as "TRADE_CODE", sa_c_trade_type.TRADE as "TRADE", c_cons.ELEC_TYPE_CODE as "ELEC_TYPE_CODE", c_cons.CONTRACT_CAP as "CONTRACT_CAP", c_cons.RUN_CAP as "RUN_CAP", c_cons.SHIFT_NO as "SHIFT_NO", c_cons.LODE_ATTR_CODE as "LODE_ATTR_CODE", c_cons.HEC_INDUSTRY_CODE as "HEC_INDUSTRY_CODE", c_cons.HOLIDAY as "HOLIDAY", c_cons.BUILD_DATE as "BUILD_DATE", c_cons.PS_DATE as "PS_DATE", c_cons.CANCEL_DATE as "CANCEL_DATE", c_cons.DUE_DATE as "DUE_DATE", c_cons.NOTIFY_MODE as "NOTIFY_MODE", c_cons.SETTLE_MODE as "SETTLE_MODE", c_cons.STATUS_CODE as "STATUS_CODE", c_cons.ORG_NO as "ORG_NO", sa_org.ORG_NAME as "ORG_NAME", c_cons.RRIO_CODE as "RRIO_CODE", c_cons.CHK_CYCLE as "CHK_CYCLE", c_cons.LAST_CHK_DATE as "LAST_CHK_DATE", c_cons.CHEC
KER_NO as "CHECKER_NO", sa_user.REAL_NAME as "CHECKER_NAME", c_cons.POWEROFF_CODE as "POWEROFF_CODE", c_cons.TRANSFER_CODE as "TRANSFER_CODE", c_cons.MR_SECT_NO as "MR_SECT_NO", c_cons.NOTE_TYPE_CODE as "NOTE_TYPE_CODE", c_cons.TMP_FLAG as "TMP_FLAG", c_cons.TMP_DATE as "TMP_DATE", c_cons.MEAS_MODE as "MEAS_MODE", c_cons.DB_TIMESTAMP as "DB_TIMESTAMP", c_cons.VOLT_CODE as "VOLT_CODE", c_cons.CONS_SORT_CODE as "CONS_SORT_CODE", '' as "PAY_MODE", '' as "MADE_NO", '' as "BAR_CODE", '' as "TELE_NO", '' as "PAY_NO", '' as "BANK_ACCT", c_cons.CARD_NO as "CARD_NO" from c_cons, c_vat, sa_c_trade_type, sa_org, sa_user where ((c_cons.VAT_ID = c_vat.VAT_ID(+) and c_cons.TRADE_CODE = sa_c_trade_type.TRADE_CODE(+) and c_cons.ORG_NO = sa_org.ORG_NO(+) and c_cons.CHECKER_NO = sa_user.USER_ID(+)) and (C_CONS.ORG_NO LIKE '21402%')) and (exists (select 1 from c_contact, c_cons_contact_rela where c_cons_contact_rela.cons_id = c_cons.cons_id and c_cons_contact_rela.contact_id = c_contact.contact_id and (c_contact.office_tel = :1 or c_contact.homephone = :2 or c_contact.mobile=:3)))) t where ROWNUM <= :4) where RN2 > :5
|
2gu24h03h87x9 | SELECT workitem_ins_id, proc_instance_id, activity_ins_id, parent_workitem, name, current_state, complete_time, create_time, limit_time, app_name, app_type, app_url, category, send_type, user_name, user_id, type, if_create_workitem, user_entity_type, user_entity_name, user_entity_id, r_data_id, participant_type, overdued, ifhandling, priority, need_part_role, description, ext_prop, flow_direction, origin_id, origin_name, origin_type, is_substituted, actor_id, actor_name, actor_type, msg_app_type, businesskey, depart_id FROM rt_workiteminst WHERE workitem_ins_id=:1 |
2m8db5h8zy794 | select * from (select alia.*, rownum as rnum from (SELECT instance_id, state_change_time, prolong_time, overtime_count, when_overtime, current_state, objecttype, create_time, time_out_time, schedule_type, timer_type, warning_interval, group_id, version FROM rt_overtime_deal WHERE time_out_time IS NOT NULL AND time_out_time<=:1 AND current_state=1 AND (overtime_count<1 OR overtime_count is NULL) AND handlestate=0 AND version=0) alia where rownum <2) where rnum>=1 |
2q93zsrvbdw48 | select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee# |
2ub0q5affr8jf | SELECT * FROM SA_DEPT D WHERE D.PARENT_DEPT_ID = :1 AND D.IS_DIRECT = '1' |
2ym6hhaq30r73 | select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3 |
32bhha21dkv0v | select col#, intcol#, charsetid, charsetform from col$ where obj#=:1 order by intcol# asc |
36fgu5nxfq68k | --lab128
select object_id,
owner,
object_name||decode(subobject_name, null, null, ' ('||subobject_name||')') obj_name,
object_type
from all_objects where object_id in (:1, :2, :3, :4) |
39m4sx9k63ba2 | select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece# |
3g7sxtj9d6zd3 | select privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 and grantee#=:2 group by privilege#, nvl(col#, 0) |
446fwt9azudm8 | SELECT SIR.AIR_ID,
SIR.READ_TYPE_CODE,
SMS.MP_NO,
SMS.MP_NAME,
SSS.SP_NAME,
DECODE(SMS.CHG_DESC, '01', '??', '??') CHG_DESC,
(SELECT COUNT(1) FROM S_MP_METER_RELA_SCHM S
WHERE S.APP_ID = SIR.APP_ID
AND S.MP_SCHEME_ID = SMS.MP_SCHEME_ID
AND S.CHG_DESC = '01') CNT_NEW,
(SELECT COUNT(1) FROM S_MP_METER_RELA_SCHM S
WHERE S.APP_ID = SIR.APP_ID
AND S.MP_SCHEME_ID = SMS.MP_SCHEME_ID
AND S.CHG_DESC != '01') CNT_OLD
FROM S_IR_READ SIR,
S_MP_SCHEME SMS,
S_CONSPRC_SCHEME SCS,
S_SP_SCHEME SSS
WHERE SMS.MP_ID = SIR.MP_ID
AND SMS.APP_ID = SIR.APP_ID
AND SMS.TARIFF_ID = SCS.TARIFF_ID
AND SCS.APP_ID = SIR.APP_ID
AND SSS.SP_ID = SCS.SP_ID
AND SSS.APP_ID = SIR.APP_ID
AND SIR.CONS_ID = SSS.CONS_ID
AND SCS.TAR_SCHEME_ID = :1
AND SIR.APP_ID = :2
AND SMS.MP_ID = :3 |
4jc5ucwq7a0h2 | SELECT *
FROM (SELECT NV.*
FROM VIEW_WORKITEM_NFLOW NV
WHERE NV.USER_ENTITY_ID = :1
UNION ALL
SELECT NV.*
FROM VIEW_WORKITEM_NFLOW NV, SA_BROLE_USER BU
WHERE NV.USER_ENTITY_ID = BU.ROLE_ID
AND BU.USER_ID = :2) T
WHERE T.WT_WORKTASK_STATUS = '01'
AND (T.WT_DEPT_ID IS NULL OR T.WT_DEPT_ID = '' OR T.WT_DEPT_ID = :3)
|
4mdhzj69qgg43 | UPDATE sys_group_server SET lastupdate=:1 where id=:2 |
4nxpj1gp0qjc6 |
SELECT *
FROM (SELECT LI.*,
CASE
WHEN LI.OVERDUED_NE = 1 OR LI.OVERDUED_NE = 3 THEN 1
WHEN LI.OVERDUED_NE = 0 OR LI.OVERDUED_NE = 2 THEN
CASE
WHEN E.SUSPEND_FLAG = 0 THEN
CASE
WHEN SYSTIMESTAMP >= E.TARGET_OVERDUE_MINTIME THEN 1
ELSE 0
END
WHEN E.SUSPEND_FLAG = 1 THEN
CASE
WHEN E.SUSPEND_TIME >= E.TARGET_OVERDUE_MINTIME THEN 1
ELSE 0
END
ELSE 0
END
ELSE 0
END OVERDUED,
CASE
WHEN E.TARGET_OVERDUE_MINTIME IS NULL THEN LI.TARGET_TIME_NE
WHEN LI.TARGET_TIME_NE IS NULL THEN E.TARGET_OVERDUE_MINTIME
WHEN E.TARGET_OVERDUE_MINTIME <= LI.TARGET_TIME_NE THEN E.TARGET_OVERDUE_MINTIME
ELSE LI.TARGET_TIME_NE
END TARGET_TIME,
FTM.WORKFORM_TYPE_KIND
FROM (SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/
WF.PROC_INSTANCE_ID,
WF.ACTIVITY_INS_ID,
WF.WORKITEM_INS_ID,
WF.NAME,
WF.CURRENT_
STATE,
WF.COMPLETE_TIME,
WF.CREATE_TIME,
WF.LIMIT_TIME,
WF.APP_URL,
WF.USER_NAME,
WF.USER_ID,
WF.USER_ENTITY_TYPE,
WF.USER_ENTITY_NAME,
WF.USER_ENTITY_ID,
WF.PARTICIPANT_TYPE,
WF.SEND_TYPE,
WF.OVERDUED AS OVERDUED_NE,
WF.EXT_PROP,
WF.FLOW_DIRECTION,
WF.BUSINESSKEY,
WF.DEPART_ID,
F.INSTANCE_ID AS WI_INSTANCE_ID,
F.INSTANCE_NAME AS WI_INSTANCE_NAME,
F.WORKFORM_TYPE AS WI_WORKFORM_TYPE,
F.BUILDER AS WI_BUILDER,
F.START_TIME AS WI_CREATE_TIME,
F.INSTANCE_STATUS AS WI_INSTANCE_STATUS,
F.BUSINESS AS WI_BUSINESS,
F.KEYDATA_ID AS WI_KEYDATA_ID,
F.IS_FLOW AS WI_IS_FLOW,
F.ATTR1 AS WI_ATTR1,
F.DEPT_ID AS WI_DEPT_ID,
'' AS WT_DEPT_ID,
WF.CURRENT_STATE AS WT_WORKTASK_STATUS,
NULL AS WT_TARGET_TIME,
'' AS WT_LINK_URL,
'' AS WT_LINK_PARAM,
'' AS WT_IS_BATCH,
U.REAL_NAME AS WI_BUILDER_REALNAME,
NULL AS HOWLONG_WILL_OVERDUE,
NULL AS HOWLONG_OVERDUED,
'' AS ACTIVITY_TMP_ID,
O.TIME_OUT_TIME AS TARGET_TIME_NE,
B.APPROVAL_STATUS AS BE_APPROVAL_STATUS,
ORG.ORG_NO,
ORG.ORG_NAME,
'' AS VIEW_FLAGS
FROM SA_WORKFORM_INST F,
(SELECT W.*
FROM RT_WORKITEMINST W
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = :1
AND W.PARTICIPANT_TYPE = 0
UNION ALL
SELECT W.*
FROM RT_WORKITEMINST W, SA_BROLE_USER R
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = R.ROLE_ID
AND R.USER_ID = :2
AND W.PARTICIPANT_TYPE = 1) WF,
SA_USER U,
(SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O,
SA_WF_BUSINESS_EXT B,
SA_DEPT D,
SA_ORG ORG
WHERE F.PROCINST_ID = WF.PROC_INSTANCE_ID
AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+)
AND F.BUILDER = U.USER_ID(+)
AND U.DEPT_ID = D.DEPT_ID(+)
AND D.
ORG_NO = ORG.ORG_NO(+)
AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+)
AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:3 LIKE (WF.DEPART_ID || '%')) OR (:4 = WF.DEPART_ID) OR (:5 = WF.DEPART_ID) OR (:6 = WF.DEPART_ID) OR (:7 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :8))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:9 LIKE (F.DEPT_ID || '%')) OR (:10 = F.DEPT_ID) OR (:11 = F.DEPT_ID) OR (:12 = F.DEPT_ID) OR (:13 = F.DEPT_ID) OR (F.DEPT_ID LIKE :14))))))
UNION ALL
SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/
WF.PROC_INSTANCE_ID,
WF.ACTIVITY_INS_ID,
WF.WORKITEM_INS_ID,
WF.NAME,
WF.CURRENT_STATE,
WF.COMPLETE_TIME,
WF.CREATE_TIME,
WF.LIMIT_TIME,
WF.APP_URL,
WF.USER_NAME,
WF.USER_ID,
WF.USER_ENTITY_TYPE,
WF.USER_ENTITY_NAME,
WF.USER_ENTITY_ID,
WF.PARTICIPANT_TYPE,
WF.SEND_TYPE,
WF.OVERDUED AS OVERDUED_NE,
WF.EXT_PROP,
WF.FLOW_DIRECTION,
WF.BUSINESSKEY,
WF.DEPART_ID,
F.INSTANCE_ID AS WI_INSTANCE_ID,
F.INSTANCE_NAME AS WI_INSTANCE_NAME,
F.WOR
KFORM_TYPE AS WI_WORKFORM_TYPE,
F.BUILDER AS WI_BUILDER,
F.START_TIME AS WI_CREATE_TIME,
F.INSTANCE_STATUS AS WI_INSTANCE_STATUS,
F.BUSINESS AS WI_BUSINESS,
F.KEYDATA_ID AS WI_KEYDATA_ID,
F.IS_FLOW AS WI_IS_FLOW,
F.ATTR1 AS WI_ATTR1,
F.DEPT_ID AS WI_DEPT_ID,
'' AS WT_DEPT_ID,
WF.CURRENT_STATE AS WT_WORKTASK_STATUS,
NULL AS WT_TARGET_TIME,
'' AS WT_LINK_URL,
'' AS WT_LINK_PARAM,
'' AS WT_IS_BATCH,
U.REAL_NAME AS WI_BUILDER_REALNAME,
NULL AS HOWLONG_WILL_OVERDUE,
NULL AS HOWLONG_OVERDUED,
'' AS ACTIVITY_TMP_ID,
O.TIME_OUT_TIME AS TARGET_TIME_NE,
B.APPROVAL_STATUS AS BE_APPROVAL_STATUS,
ORG.ORG_NO,
ORG.ORG_NAME,
'' AS VIEW_FLAGS
FROM SA_WORKFORM_INST F,
(SELECT W.*
FROM RT_WORKITEMINST W
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = :15
AND W.PARTICIPANT_TYPE = 0
UNION ALL
SELECT W.*
FROM RT_WORKITEMINST W, SA_BROLE_USER R
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = R.ROLE_ID
AND R.USER_ID = :16
AND W.PARTICIPANT_TYPE = 1) WF,
SA_USER U,
RT_PROCESSINSTANCE P,
(SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O,
SA_WF_BUSINESS_EXT B,
SA_DEPT D,
SA_ORG ORG
WHERE WF.PROC_INSTANCE_ID = P.PROC_INSTANCE_ID
AND P.PARENT_PROCINC_ID IS NOT NULL
AND F.PROCINST_ID = P.PARENT_PROCINC_ID
AND F.BUILDER = U.USER_ID(+)
AND U.DEPT_ID = D.DEPT_ID(+)
AND D.ORG_NO = ORG.ORG_NO(+)
AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+)
AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+)
AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:17 LIKE (WF.DEPART_ID || '%')) OR (:18 = WF.DEPART_ID) OR (:19 = WF.DEPART_ID) OR (:20 = WF.DEPART_ID) OR (:21 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :22))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:23 LIKE (F.DEPT_ID || '%')) OR (:24 = F.DEPT_ID) OR (:25 = F.DEPT_ID) OR (:26 = F.DEPT_ID) OR (:27 = F.DEPT_ID) OR (F.D
EPT_ID LIKE :28))))))
AND NOT EXISTS
(SELECT 1
FROM SA_WORKFORM_INST RF
WHERE WF.PROC_INSTANCE_ID = RF.PROCINST_ID)) LI,
SA_WF_WORKFORM_TYPE_MAP FTM,
(SELECT ACT_INST_ID,
SUSPEND_FLAG,
MIN(TARGET_OVERDUE_MINTIME) AS TARGET_OVERDUE_MINTIME,
MIN(SUSPEND_TIME) AS SUSPEND_TIME
FROM (SELECT A.ACT_INST_ID, B.*
FROM SA_WF_EXAM_ACT_INST A, SA_WF_EXAM_INST B
WHERE A.SUBJECT_INST_ID = B.SUBJECT_INST_ID
AND A.PROC_INST_ID = B.PROC_INST_ID
AND B.COMPLETE_FLAG = 0)
GROUP BY ACT_INST_ID, SUSPEND_FLAG) E
WHERE LI.WI_WORKFORM_TYPE = FTM.WORKFORM_TYPE(+)
AND LI.ACTIVITY_INS_ID = E.ACT_INST_ID(+)) T
WHERE NOT EXISTS (SELECT 1
FROM SA_WF_WORKITEM_EXCLUDED_USER US
WHERE T.WORKITEM_INS_ID = US.WORKITEM_ID
AND US.USER_ID = :29) |
4rsf2ggsf1zsd | DELETE P_PROC_TL_EXAMINE WHERE RSLT_ID IN (SELECT RSLT_ID FROM ARC_P_PROC_TL_EXAMINE) |
4t06c5ws8y6fn |
SELECT A.NAMEDES AS "NAME_DES",
C_CONS.CONS_NO AS "CONS_NO",
C_CONS.CONS_NAME AS "CONS_NAME",
A.CHARGE_ID AS "CHARGE_ID",
A.CHARGE_DATE AS "CHARGE_DATE",
NVL(A.KOU, 0) AS "KOU",
NVL(A.AMT_PAY, 0) AS "AMT_PAY",
NVL(A.REMAIN, 0) AS "REMAIN",
A.ORDERBY AS "ORDERBY",
A.CARD_PRINTED AS "CARD_PRINTED",
(A.KOU + A.AMT_PAY) AS "SUMAMT",
'' AS "MUST_CARD_PRINTED",
A.USERNAME AS "PRINTUSER",
A.ORG_NAME AS "ORG_NAME",
A.REAL_METER_VALUE AS "REAL_METER_VALUE",
A.T_PQ AS "T_PQ",
'' AS "D"
FROM (
--???????????????
SELECT (A_RCVBL_FLOW.RCVBL_AMT * -1) AS "KOU",
0 AS "CHARGE_ID",
0 AS "AMT_PAY",
0 AS "REMAIN",
'' AS "CARD_PRINTED",
'???' AS "NAMEDES",
A_RCVBL_FLOW.RENDER_DATE AS "CHARGE_DATE",
1 AS "ORDERBY",
SA_USER.REAL_NAME AS "USERNAME",
SA_ORG.ORG_NAME AS "ORG_NAME",
0 AS "REAL_METER_VALUE",
A_RCVBL_FLOW.T_PQ AS "T_PQ"
FROM A_RCVBL_FLOW, SA_USER, SA_ORG
WHE
RE A_RCVBL_FLOW.CONS_NO = :1
AND A_RCVBL_FLOW.RENDER_DATE <= :2
AND A_RCVBL_FLOW.RENDER_MAN = SA_USER.USER_ID(+)
AND A_RCVBL_FLOW.ORG_NO = SA_ORG.ORG_NO
UNION
--?????????????????????
SELECT (CASE
WHEN A_PAY_FLOW.TYPE_CODE IN ('1101', '1102', '1103') THEN
0
WHEN A_PAY_FLOW.TYPE_CODE IN ('3005') THEN
0
WHEN A_PAY_FLOW.TYPE_CODE IN ('3006') THEN
(A_PAY_FLOW.RCV_AMT)
WHEN A_PAY_FLOW.TYPE_CODE IN ('3001', '3002') THEN
(A_PAY_FLOW.RCV_AMT * -1)
WHEN A_PAY_FLOW.TYPE_CODE IN ('1104', '21') THEN
0
END) AS "KOU",
A_PAY_FLOW.CHARGE_ID AS "CHARGE_ID",
(CASE
WHEN A_PAY_FLOW.TYPE_CODE IN ('1101', '1102', '1103') THEN
A_PAY_FLOW.RCV_AMT
WHEN A_PAY_FLOW.TYPE_CODE IN ('3005') THEN
A_PAY_FLOW.RCV_AMT
WHEN A_PAY_FLOW.TYPE_CODE IN ('3006') THEN
0
WHEN A_PAY_FLOW.TYPE_CODE IN ('3001', '3002') THEN
0
WHEN A_PAY_FLOW.TYPE_CODE IN ('1104', '21') THEN
(nvl(A_RCVED_FLOW.THIS_RCVED_AMT, 0) + nvl(A_PREPAY_FLOW.Prepay_Amt, 0))
END) AS "AMT_PAY",
(CASE
WHEN A_PAY_FLOW.TYPE_CODE IN ('1101', '1102', '1103', '21', '1104') THEN
A_PREPAY_FLOW.REMAIN
ELSE
0
END) AS "REMAIN",
'' AS "CARD_PRINTED",
(CASE
WHEN A_PAY_FLOW.TYPE_CODE IN ('1101', '1102', '1103') AND SUBSTR(A_PAY_FLOW.ORG_NO, 1, 5) = '21401' THEN
'??'
WHEN A_PAY_FLOW.TYPE_CODE IN ('1101', '1102', '1103') AND SUBSTR(A_PAY_FLOW.ORG_NO, 1, 5) <> '21401' THEN
'??'
WHEN A_PAY_FLOW.TYPE_CODE IN ('3005') AND SUBSTR(A_PAY_FLOW.ORG_NO, 1, 5) = '21401' THEN
'??'
WHEN A_PAY_FLOW.TYPE_CODE IN ('3005') AND SUBSTR(A_PAY_FLOW.ORG_NO, 1, 5) <> '21401' THEN
'??'
WHEN A_PAY_FLOW.TYPE_CODE IN ('3006') AND SUBSTR(A_PAY_FLOW.ORG_NO, 1, 5) = '21401' THEN
'???'
WHEN A_PAY_FLOW.TYPE_CODE IN ('3006') AND SUBSTR(A_PAY_FLOW.ORG_NO, 1, 5) <> '21401' THEN
'???'
WHEN A_PAY_FLOW.TYPE_CODE IN ('3001', '3002') AND SUBSTR(A_PAY_FLOW.ORG_NO, 1, 5) = '21401' THEN
'??'
WHEN A_PAY_FLOW.TYPE_CODE IN ('3001', '3002') AND SUBSTR(A_PAY_FLOW.ORG_NO, 1, 5) <> '21401' THEN
'???'
WHEN A_PAY_FLOW.TYPE_CODE IN ('1104', '21') THEN
'??'
END) AS "NAMEDES",
A_PAY_FLOW.CHARGE_DATE AS "C
HARGE_DATE",
(CASE
WHEN A_PAY_FLOW.TYPE_CODE IN ('1101', '1102', '1103') THEN
6
WHEN A_PAY_FLOW.TYPE_CODE IN ('3005') THEN
2
WHEN A_PAY_FLOW.TYPE_CODE IN ('3006') THEN
3
WHEN A_PAY_FLOW.TYPE_CODE IN ('3001', '3002') THEN
1
WHEN A_PAY_FLOW.TYPE_CODE IN ('1104', '21') THEN
4
END) AS "ORDERBY",
(CASE
WHEN A_PAY_FLOW.TYPE_CODE IN ('1101', '1102', '1103', '1104', '21', '3001', '3002') THEN
SA_USER.REAL_NAME
ELSE
''
END) AS "USERNAME",
SA_ORG.ORG_NAME AS "ORG_NAME",
0 AS "REAL_METER_VALUE",
0 AS "T_PQ"
FROM A_PAY_FLOW, A_RCVED_FLOW, A_PREPAY_FLOW, SA_USER, SA_ORG
WHERE A_PAY_FLOW.CHARGE_ID = A_RCVED_FLOW.CHARGE_ID(+)
AND A_PAY_FLOW.CHARGE_ID = A_PREPAY_FLOW.CHARGE_ID(+)
AND A_PAY_FLOW.CONS_NO = :3
AND A_PAY_FLOW.CHARGE_EMP_NO = SA_USER.USER_ID(+)
AND A_PAY_FLOW.CHARGE_DATE <= :4
AND A_PAY_FLOW.TYPE_CODE IN
('1101', '1102', '1103', '3001', '21', '3002', '3005', '3006', '1104')
AND A_PAY_FLOW.RCV_ORG_NO = SA_ORG.ORG_NO
UNION
--????????????
SELECT (SUM(A_RCVED_FLOW.THIS_PENALTY) * -1) AS "KOU",
0 AS "CHARGE_ID",
0 AS "AMT_PAY",
0 AS "REMAIN",
'' AS "CARD_PRINTED",
'????' AS "NAMEDES",
A_PAY_FLOW.CHARGE_DATE AS "CHARGE_DATE",
5 AS "ORDERBY",
'' AS "USERNAME",
SA_ORG.ORG_NAME AS "ORG_NAME",
0 AS "REAL_METER_VALUE",
0 AS "T_PQ"
FROM A_PAY_FLOW, A_RCVED_FLOW, SA_ORG
WHERE A_PAY_FLOW.CHARGE_ID = A_RCVED_FLOW.CHARGE_ID
AND A_PAY_FLOW.CONS_NO = :5
AND A_PAY_FLOW.TYPE_CODE IN('1101', '1102', '1103')
AND A_PAY_FLOW.CHARGE_DATE <= :6
AND A_PAY_FLOW.RCV_ORG_NO = SA_ORG.ORG_NO
GROUP BY A_PAY_FLOW.CHARGE_ID, A_PAY_FLOW.CHARGE_DATE, SA_ORG.ORG_NAME
) A, C_CONS
WHERE C_CONS.CONS_NO = :7
AND (A.AMT_PAY + A.KOU <> 0 OR (A.AMT_PAY + A.KOU = 0 AND A.NAMEDES IN('??', '??')))
ORDER BY CHARGE_DATE, ORDERBY |
4um7k1gy6pp9d |
select s_mp_scheme.MP_SCHEME_ID as "MP_SCHEME_ID", s_mp_scheme.MP_APP_ID as "MP_APP_ID", s_mp_scheme.MP_ID as "MP_ID", s_mp_scheme.MP_NO as "MP_NO", s_mp_scheme.MP_NAME as "MP_NAME", s_mp_scheme.CONS_NO as "CONS_NO", s_mp_scheme.APP_ID as "APP_ID", s_mp_scheme.APP_NO as "APP_NO", s_mp_scheme.MP_NAME as "MP_NAME1", s_mp_scheme.MP_ADDR as "MP_ADDR", s_mp_scheme.TYPE_CODE as "TYPE_CODE", s_mp_scheme.MD_TYPE_CODE as "MD_TYPE_CODE", s_mp_scheme.VOLT_CODE as "VOLT_CODE", s_mp_scheme.CONS_ID as "CONS_ID", s_mp_scheme.METER_FLAG as "METER_FLAG", s_mp_scheme.LINE_ID as "LINE_ID", s_mp_scheme.TG_ID as "TG_ID", g_line.LINE_ID as "LINE_ID1", g_line.LINE_NAME as "LINE_NAME", g_tg.TG_ID as "TG_ID1", g_tg.TG_NAME as "TG_NAME", s_app.CONS_NO as "CONS_NO1", s_app.CONS_NAME as "CONS_NAME", s_app.ELEC_ADDR as "ELEC_ADDR", s_app.APP_NO as "APP_NO1", s_mp_scheme.MEAS_MODE as "MEAS_MODE", s_mp_scheme.SWITCH_NO as "SWITCH_NO", s_mp_scheme.MP_CAP as "MP_CAP", s_mp_scheme.CHG_DESC as "CHG_DESC", '' as "CT", '' as "PT", '' as "BREAK_BAR_CODE", '' as "SWITCH_BAR_CODE" from s_mp_scheme, g_line, g_tg, s_app where s_mp_scheme.CONS_NO=s_app.CONS_NO
AND s_mp_scheme.APP_NO=s_app.APP_NO AND s_mp_scheme.LINE_ID=g_line.LINE_ID (+) AND s_mp_scheme.TG_ID=g_tg.TG_ID (+) AND s_mp_scheme.APP_NO = :1 order by S_MP_SCHEME.CONS_ID, S_MP_SCHEME.MR_SECT_NO, S_MP_SCHEME.MR_SN, S_MP_SCHEME.MP_SCHEME_ID , S_MP_SCHEME.MP_ID |
4xv5cghqm3u2k | select sa_org.ORG_NO as "ORG_NO", sa_org.ORG_NAME as "ORG_NAME", sa_org.P_ORG_NO as "P_ORG_NO", sa_org.ORG_TYPE as "ORG_TYPE", sa_org.ORG_TREE as "ORG_TREE", sa_org.SORT_NO as "SORT_NO", sa_org.IS_DELETE as "IS_DELETE", sa_org.TAX_ID as "TAX_ID", sa_org.ATTR1 as "ATTR1", sa_org.ATTR2 as "ATTR2", sa_org.ATTR3 as "ATTR3", sa_org.ATTR4 as "ATTR4", sa_org.PRESERVE1 as "PRESERVE1", sa_org.PRESERVE2 as "PRESERVE2", sa_org.PRESERVE3 as "PRESERVE3", sa_org.PRESERVE4 as "PRESERVE4", sa_org.PRESERVE5 as "PRESERVE5" from sa_org where sa_org.ORG_NO = :1 |
50sg88xnk9h9n | update a_lfee_calc
set calc_flag = '1'
where rcvbl_amt_id = :1
and calc_flag = '0' |
571gj40ztu75a |
select /*+ FIRST_ROWS */ * from (select t.*, ROWNUM as RN2 from (select c_cons.CONS_ID as "CONS_ID", c_cons.VAT_ID as "VAT_ID", c_vat.VAT_NAME as "VAT_NAME", c_cons.CUST_ID as "CUST_ID", c_cons.CONS_NO as "CONS_NO", c_cons.CONS_NAME as "CONS_NAME", c_cons.CUST_QUERY_NO as "CUST_QUERY_NO", c_cons.TMP_PAY_RELA_NO as "TMP_PAY_RELA_NO", c_cons.ORGN_CONS_NO as "ORGN_CONS_NO", c_cons.ELEC_ADDR as "ELEC_ADDR", c_cons.TRADE_CODE as "TRADE_CODE", sa_c_trade_type.TRADE as "TRADE", c_cons.ELEC_TYPE_CODE as "ELEC_TYPE_CODE", c_cons.CONTRACT_CAP as "CONTRACT_CAP", c_cons.RUN_CAP as "RUN_CAP", c_cons.SHIFT_NO as "SHIFT_NO", c_cons.LODE_ATTR_CODE as "LODE_ATTR_CODE", c_cons.HEC_INDUSTRY_CODE as "HEC_INDUSTRY_CODE", c_cons.HOLIDAY as "HOLIDAY", c_cons.BUILD_DATE as "BUILD_DATE", c_cons.PS_DATE as "PS_DATE", c_cons.CANCEL_DATE as "CANCEL_DATE", c_cons.DUE_DATE as "DUE_DATE", c_cons.NOTIFY_MODE as "NOTIFY_MODE", c_cons.SETTLE_MODE as "SETTLE_MODE", c_cons.STATUS_CODE as "STATUS_CODE", c_cons.ORG_NO as "ORG_NO", sa_org.ORG_NAME as "ORG_NAME", c_cons.RRIO_CODE as "RRIO_CODE", c_cons.CHK_CYCLE as "CHK_CYCLE", c_cons.LAST_CHK_DATE as "LAST_CHK_DATE", c_cons.CHEC
KER_NO as "CHECKER_NO", sa_user.REAL_NAME as "CHECKER_NAME", c_cons.POWEROFF_CODE as "POWEROFF_CODE", c_cons.TRANSFER_CODE as "TRANSFER_CODE", c_cons.MR_SECT_NO as "MR_SECT_NO", c_cons.NOTE_TYPE_CODE as "NOTE_TYPE_CODE", c_cons.TMP_FLAG as "TMP_FLAG", c_cons.TMP_DATE as "TMP_DATE", c_cons.MEAS_MODE as "MEAS_MODE", c_cons.DB_TIMESTAMP as "DB_TIMESTAMP", c_cons.VOLT_CODE as "VOLT_CODE", c_cons.CONS_SORT_CODE as "CONS_SORT_CODE", '' as "PAY_MODE", '' as "MADE_NO", '' as "BAR_CODE", '' as "TELE_NO", '' as "PAY_NO", '' as "BANK_ACCT", c_cons.CARD_NO as "CARD_NO" from c_cons, c_vat, sa_c_trade_type, sa_org, sa_user where ((c_cons.VAT_ID = c_vat.VAT_ID(+) and c_cons.TRADE_CODE = sa_c_trade_type.TRADE_CODE(+) and c_cons.ORG_NO = sa_org.ORG_NO(+) and c_cons.CHECKER_NO = sa_user.USER_ID(+)) and (C_CONS.ORG_NO LIKE '21409%')) and (exists (select 1 from c_contact, c_cons_contact_rela where c_cons_contact_rela.cons_id = c_cons.cons_id and c_cons_contact_rela.contact_id = c_contact.contact_id and (c_contact.office_tel = :1 or c_contact.homephone = :2 or c_contact.mobile=:3)))) t where ROWNUM <= :4) where RN2 > :5
|
58z1k4t9kkuyv |
SELECT DISTINCT t.* FROM sa_sys_menu t
START WITH exists (select 1 from
(select distinct t1.menu_id menu_id
from sa_sys_menu t1, sa_resource t2, sa_brole_permission t3, sa_brole_user t4,
sa_permission_resource_map t7
where t1.link_name = t2.res_id
and t2.res_id = t7.res_id
and t7.permission_id = t3.permission_id
and t7.perm_type_id = 'execute'
and (t3.role_id = t4.role_id and t4.user_id = :1)
and t1.sys_id = :2
union all
select t1.menu_id menu_id
from sa_sys_menu t1, sa_resource t2, sa_brole_permission t3,
sa_permission_resource_map t7
where t1.link_name = t2.res_id
and t2.res_id = t7.res_id
and t7.permission_id = t3.permission_id
and t7.perm_type_id = 'execute'
and (t3.role_id = 'everyone')
and t1.sys_id = :3) aa
where aa.menu_id = t.menu_id
) and t.disable = '0'
CONNECT BY PRIOR t.menu_parent_id = t.menu_id
ORDER BY t.order_id |
5j4c2v06qdhqq | select procedure#, ownerlength, classlength, methodlength, siglength, flagslength, cookiesize from procedurejava$ where obj#=:1 order by procedure# |
5tbw0ux7xt6gu | select app_no, emp_no, org_no, reply_interval, reply_time from (
select a.app_no, a.emp_no, a.org_no,
(select b.value from s_wkst_ext_attr b where b.app_no = a.app_no and b.ATTR_INFO_ID = 30000000001600) reply_interval,
(select b.value from s_wkst_ext_attr b where b.app_no = a.app_no and b.ATTR_INFO_ID = 30000000000800) reply_time,
(select b.value from s_wkst_ext_attr b where b.app_no = a.app_no and b.ATTR_INFO_ID = 30000000001200) continue_flag
from s_95598_wkst a
where a.busi_type_code = '003'
and a.handle_status_code = '05'
)where continue_flag = '1' |
5ubfvamp6szak |
select o_staff.EMP_NO as "EMP_NO", o_staff.DEPT_NO as "DEPT_NO", o_staff.STAFF_NO as "STAFF_NO", o_staff.NAME as "NAME", o_staff.GENDER as "GENDER", o_staff.PHOTO as "PHOTO", o_staff.POS_NAME as "POS_NAME", o_staff.POSITION as "POSITION", o_staff.WORK_TYPE_CODE as "WORK_TYPE_CODE", o_staff.TECH_LEVEL_CODE as "TECH_LEVEL_CODE", o_staff.YMD as "YMD", o_staff.DEGREE_CODE as "DEGREE_CODE", o_staff.MOBILE as "MOBILE", o_staff.OFFICE_TEL_NO as "OFFICE_TEL_NO", o_staff.SRV_LEVEL_CODE as "SRV_LEVEL_CODE", o_staff.CERT_FLAG as "CERT_FLAG", o_staff.FIXED_FLAG as "FIXED_FLAG", o_staff.ON_POS_FLAG as "ON_POS_FLAG", o_staff.PROFESSION_CODE as "PROFESSION_CODE", o_staff.PROFESSION_BGN_DATE as "PROFESSION_BGN_DATE", o_staff.JOIN_DATE as "JOIN_DATE", o_staff.TITEL as "TITEL", o_staff.POLITICAL_STATUS_CODE as "POLITICAL_STATUS_CODE", o_staff.TITLE_LEVEL_CODE as "TITLE_LEVEL_CODE", o_staff.STATUS_CODE as "STATUS_CODE", o_staff.REMARK as "REMARK", sa_user.USER_ID as "USER_ID", sa_user.DEPT_ID as "DEPT_ID", sa_user.USER_NAME as "USER_NAME", sa_user.PASSWORD as "PASSWORD", sa_user.REAL_NAME as "REAL_NAME", sa_user.IS_LOCK as "IS_LOCK", sa_user.IS_DELE
TE as "IS_DELETE", sa_user.ATTR1 as "ATTR1", sa_user.GENDER as "GENDER1", sa_user.USER_IP as "USER_IP", sa_user.IS_MANAGER as "IS_MANAGER", sa_user.USER_TYPE as "USER_TYPE" from o_staff, sa_user where (o_staff.EMP_NO = sa_user.ATTR1) and (o_staff.EMP_NO = :1) |
6rmfc2jyd2bpb |
select /*+ FIRST_ROWS */ * from (select t.*, ROWNUM as RN2 from (select view_s_app_workform.WORKFORM_STATUS as "WORKFORM_STATUS", view_s_app_workform.APP_ID as "APP_ID", view_s_app_workform.APP_NO as "APP_NO", view_s_app_workform.APP_MODE as "APP_MODE", view_s_app_workform.HANDLE_DEPT_NO as "HANDLE_DEPT_NO", view_s_app_workform.HANDLE_TIME as "HANDLE_TIME", view_s_app_workform.CONS_NO as "CONS_NO", view_s_app_workform.CONS_NAME as "CONS_NAME", view_s_app_workform.CUST_QUERY_NO as "CUST_QUERY_NO", view_s_app_workform.TMP_PAY_RELA_NO as "TMP_PAY_RELA_NO", view_s_app_workform.ORGN_CONS_NO as "ORGN_CONS_NO", view_s_app_workform.CONS_SORT_CODE as "CONS_SORT_CODE", view_s_app_workform.ELEC_ADDR as "ELEC_ADDR", view_s_app_workform.TRADE_CODE as "TRADE_CODE", view_s_app_workform.ELEC_TYPE_CODE as "ELEC_TYPE_CODE", view_s_app_workform.SHIFT_NO as "SHIFT_NO", view_s_app_workform.LODE_ATTR_CODE as "LODE_ATTR_CODE", view_s_app_workform.VOLT_CODE as "VOLT_CODE", view_s_app_workform.HEC_INDUSTRY_CODE as "HEC_INDUSTRY_CODE", view_s_app_workform.HOLIDAY as "HOLIDAY", view_s_app_workform.NOTIFY_MODE as "NOTIFY_MODE", view_s_app_workform.SETTLE_MODE as "SETTLE_MODE", view_s_app_workform.ORG_NO as "ORG_NO", view_s_app_workform.TRANSFER_CODE as &
quot;TRANSFER_CODE", view_s_app_workform.MR_SECT_NO as "MR_SECT_NO", view_s_app_workform.NOTE_TYPE_CODE as "NOTE_TYPE_CODE", view_s_app_workform.TMP_FLAG as "TMP_FLAG", view_s_app_workform.TMP_DATE as "TMP_DATE", view_s_app_workform.APP_CONTRACT_CAP as "APP_CONTRACT_CAP", view_s_app_workform.ORGN_CONTRACT_CAP as "ORGN_CONTRACT_CAP", view_s_app_workform.CONTRACT_CAP as "CONTRACT_CAP", view_s_app_workform.APP_RUN_CAP as "APP_RUN_CAP", view_s_app_workform.ORGN_RUN_CAP as "ORGN_RUN_CAP", view_s_app_workform.RUN_CAP as "RUN_CAP", view_s_app_workform.BGN_DATE as "BGN_DATE", view_s_app_workform.END_DATE as "END_DATE", view_s_app_workform.REASON as "REASON", view_s_app_workform.SHIFT_IN_CAP as "SHIFT_IN_CAP", view_s_app_workform.SHIFT_OUT_CAP as "SHIFT_OUT_CAP", view_s_app_workform.PERMENANT_REDUCE_FLAG as "PERMENANT_REDUCE_FLAG", view_s_app_workform.CONTENT as "CONTENT", view_s_app_workform.ST_UPQ as "ST_UPQ", view_s_app_workform.LONGTERM_CAP as "LONGTERM_CAP", view_s_app_workform.POWER_USAGE as "POWER_USAGE", view_s_app_workform.DMD_DATE as "DMD_DATE", view_s_app_workform.APP_TYPE_CODE as "APP_TYPE_CODE", view_s_app_workform.HANDLE_FLAG as "HANDLE_FLAG", view_s_app_workform.REFUSE_REASON as "REFUSE_REASON", view_s_ap
p_workform.RELA_APP_CODE as "RELA_APP_CODE", view_s_app_workform.REMARK as "REMARK", view_s_app_workform.MEAS_MODE as "MEAS_MODE", view_s_app_workform.BUILD_DATE as "BUILD_DATE", view_s_app_workform.PS_DATE as "PS_DATE", view_s_app_workform.CANCEL_DATE as "CANCEL_DATE", view_s_app_workform.DUE_DATE as "DUE_DATE", view_s_app_workform.STATUS_CODE as "STATUS_CODE", view_s_app_workform.OPERATE_STATUS as "OPERATE_STATUS", view_s_app_workform.MRD_FACTOR_CODE as "MRD_FACTOR_CODE", view_s_app_workform.IS_FLOW as "IS_FLOW", view_s_app_workform.INSTANCE_STATUS as "INSTANCE_STATUS", view_s_app_workform.COMPLETE_TIME as "COMPLETE_TIME", sa_c_trade_type.TRADE as "TRADE", sa_org.ORG_NO as "ORG_NO1", sa_org.ORG_NAME as "ORG_NAME", view_s_app_workform.DEPT_ID as "DEPT_ID", view_s_app_workform.REAL_NAME as "REAL_NAME", view_s_app_workform.DEPT_NAME as "DEPT_NAME", sa_org.ORG_TREE as "ORG_TREE", '' as "WORKFLOW_NAME", '' as "HANDLE_DEPT_NAME" from view_s_app_workform, sa_c_trade_type, sa_org where ((((view_s_app_workform.TRADE_CODE = sa_c_trade_type.TRADE_CODE(+) and VIEW_S_APP_WORKFORM.org_no = sa_org.org_no(+)) and (view_s_app_workform.CONS_NO=:1)) and (VIEW_S_APP_WORKFORM.APP_TYPE_CODE IN ('101', '102', '103', '104', '105', '106', '107', '108', '109',
'110', '111', '112', '201', '202', '203', '204', '205', '206', '207', '208', '209', '210', '211', '212', '213', '214', '215', '216', '217', '218', '301', '302', '303', '304', '305', '306', '307', '311', '351', '357', '715', '716', '901', '902'))) and (SA_ORG.ORG_TREE LIKE :2)) and (VIEW_S_APP_WORKFORM.ORG_NO LIKE :3) order by VIEW_S_APP_WORKFORM.APP_NO DESC) t where ROWNUM <= :4) where RN2 > :5 |
6v5p1gsjdcs6b | SELECT A.SG_NO, A.PRN_NO, A.ORG_FLAG, B.KPI_NAME, B.KPI_DATE
FROM OPM_ORG_RULE A, TMP_OPM_ORG_KPI B
WHERE A.SG_NO = B.SG_NO
AND B.KPI_NAME = :1
AND A.ORG_FLAG = :2
ORDER BY A.ORG_FLAG |
6vuqxkfc3k1rj |
SELECT w.proc_instance_id,
w.activity_ins_id,
w.workitem_ins_id,
w.parent_workitem,
w.NAME,
to_char(w.current_state) as current_state,
w.complete_time,
w.create_time,
w.limit_time,
w.app_name,
w.app_type,
w.app_url,
w.CATEGORY,
w.send_type,
w.user_name,
w.user_id,
w.TYPE,
w.if_create_workitem,
w.msg_app_type,
w.user_entity_type,
w.user_entity_name,
w.user_entity_id,
w.r_data_id,
w.participant_type,
w.overdued,
w.ifhandling,
w.priority,
w.need_part_role,
w.description,
w.ext_prop,
w.flow_direction,
w.origin_id,
w.origin_name,
w.origin_type,
w.is_substituted,
w.actor_id,
w.actor_name,
w.actor_type,
w.businesskey,
w.depart_id,
'' AS wt_area,
'' AS wt_dept_id,
to_char(w.current_state) AS wt_worktask_status,
NULL AS target_time,
'' AS wt_link_url,
'' AS wt_link_param,
'' AS wt_is_batch,
'' AS wt_attr1,
'' AS wt_attr2,
'' AS wt_attr3,
'' AS wt_attr4,
'' AS wt_attr5,
d.dept_name AS dept_name,
u.real_name as real_name,
w.workform_type as wi_workform_type,
w.instance_id as wi_instance_id,
w.keydata_id as wi_keydata_id
FROM (select rw.*, f.workform_type,
f.instance_id, f.keydata_id
from rt_workiteminst rw,
(select f.procinst_id, f.workform_type, f.instance_id, f.keydata_id
from sa_workform_inst f
where f.instance_id in (:1, :2, :3)
union all
select fh.procinst_id, fh.workform_type, fh.instance_id, fh.keydata_id
from sa_workform_inst_history fh
where fh.instance_id in (:4, :5, :6)) f
where rw.proc_instance_id = f.procinst_id
union all
select rwh.*, f.workform_type, f.instance_id, f.keydata_id
from log_workiteminst rwh,
(select f.procinst_id, f.workform_type, f.instance_id, f.keydata_id
from sa_workform_inst f
where f.instance_id in (:7, :8, :9)
union all
select fh.procinst_id, fh.workform_type, fh.instance_id, fh.keydata_id
from sa_workform_inst_history fh
where fh.instance_id in (:10, :11, :12)) f
where rwh.proc_instance_id = f.procinst_id) w,
sa_user u,
sa_dept d
WHERE w.user_id = u.user_id(+)
and u.dept_id = d.dept_id(+)
UNION ALL
SELECT w.proc_instance_id,
w.activity_ins_id,
w.workitem_ins_id,
w.parent_workitem,
w.NAME,
to_char(w.current_state) as current_state,
w.complete_time,
w.create_time,
w.limit_time,
w.app_name,
w.app_type,
w.app_url,
w.CATEGORY,
w.send_type,
w.user_name,
w.user_id,
w.TYPE,
w.if_create_workitem,
w.msg_app_type,
w.user_entity_type,
w.user_entity_name,
w.user_entity_id,
w.r_data_id,
w.participant_type,
w.overdued,
w.ifhandling,
w.priority,
w.need_part_role,
w.description,
w.ext_prop,
w.flow_direction,
w.origin_id,
w.origin_name,
w.origin_type,
w.is_substituted,
w.actor_id,
w.actor_name,
w.actor_type,
w.businesskey,
w.depart_id,
'' AS wt_area,
'' AS wt_dept_id,
to_char(w.current_state) AS wt_worktask_status,
NULL AS target_time,
'' AS wt_link_url,
'' AS wt_link_param,
'' AS wt_is_batch,
'' AS wt_attr1,
'' AS wt_attr2,
'' AS wt_attr3,
'' AS wt_attr4,
'' AS wt_attr5,
d.dept_name AS dept_name,
u.real_name as real_name,
w.workform_type as wi_workform_type,
w.instance_id as wi_instance_id,
w.keydata_id as wi_keydata_id
FROM (select rw2.*, f2.workform_type, f2.instance_id, f2.keydata_id
from rt_workiteminst rw2,
rt_processinstance p2,
(select f.procinst_id, f.workform_type, f.instance_id, f.keydata_id
from sa_workform_inst f
where f.instance_id in (:13, :14, :15)
union all
select fh.procinst_id, fh.workform_type, fh.instance_id, fh.keydata_id
from sa_workform_inst_history fh
where fh.instance_id in (:16, :17, :18)) f2
where rw2.proc_instance_id = p2.proc_instance_id
and p2.parent_procinc_id = f2.procinst_id
union all
select rwh2.*, f2.workform_type, f2.instance_id, f2.keydata_id
from log_workiteminst rwh2,
log_procinst ph2,
(select f.procinst_id, f.workform_type, f.instance_id, f.keydata_id
from sa_workform_inst f
where f.instance_id in (:19, :20, :21)
union all
select fh.procinst_id, fh.workform_type, fh.instance_id, fh.keydata_id
from sa_workform_inst_history fh
where fh.instance_id in (:22, :23, :24)) f2
where rwh2.proc_instance_id = ph2.proc_instance_id
and ph2.parent_procinc_id = f2.procinst_id) w,
sa_user u,
sa_dept d
WHERE w.user_id = u.user_id(+)
AND u.dept_id = d.dept_id(+)
UNION ALL
SELECT '' AS proc_instance_id,
'' AS activity_ins_id,
wt.worktask_id AS workitem_ins_id,
'' AS parent_workitem,
wt.worktask_name AS NAME,
wt.worktask_status AS current_state,
wt.complete_time,
wt.start_time AS create_time,
NULL AS limit_time,
'' AS app_name,
'' AS app_type,
wt.link
_url AS app_url,
'' AS CATEGORY,
NULL AS send_type,
'' AS user_name,
wt.actor_id AS user_id,
NULL AS TYPE,
NULL AS if_create_workitem,
'' AS msg_app_type,
to_number(wt.participant_type) AS user_entity_type,
'' AS user_entity_name,
wt.participant_id AS user_entity_id,
wt.keydata_id AS r_data_id,
NULL AS participant_type,
0 AS overdued,
NULL AS ifhandling,
NULL AS priority,
NULL AS need_part_role,
'' AS description,
wt.link_param AS ext_prop,
NULL AS flow_direction,
'' AS origin_id,
'' AS origin_name,
NULL AS origin_type,
NULL AS is_substituted,
'' AS actor_id,
'' AS actor_name,
NULL AS actor_type,
'' AS businesskey,
wt.dept AS depart_id,
wt.area AS wt_area,
wt.dept AS wt_dept_id,
wt.worktask_status AS wt_worktask_status,
wt.target_time AS target_time,
wt.link_url AS wt_link_url,
wt.link_param AS wt_link_param,
wt.is_batch AS wt_is_batch,
wt.attr1 AS wt_attr1,
wt.attr2 AS wt_attr2,
wt.attr3 AS wt_attr3,
wt.attr4 AS wt_attr4,
wt.attr5 AS wt_attr5,
sa_dept.dept_name as dept_name,
sa_user.real_name as real_name,
wt.workform_type as wi_workform_type,
wt.instance_id as wi_instance_id,
wt.wi_keydata_id as wi_keydata_id
FROM (select wt.*,
f.workform_type, f.keydata_id as wi_keydata_id
from sa_worktask wt, sa_workform_inst f
where wt.instance_id in (:25, :26, :27)
and wt.instance_id = f.instance_id
union
select wth.*, fh.workform_type, fh.keydata_id as wi_keydata_id
from sa_worktask_history wth, sa_workform_inst_history fh
where wth.instance_id in (:28, :29, :30)
and wth.instance_id = fh.instance_id
) wt,
sa_user,
sa_dept
WHERE wt.actor_id = sa_user.user_id(+)
and sa_user.dept_id = sa_dept.dept_id(+) |
77rr3r2dspx7a |
SELECT *
FROM (SELECT LI.*,
CASE
WHEN LI.OVERDUED_NE = 1 OR LI.OVERDUED_NE = 3 THEN 1
WHEN LI.OVERDUED_NE = 0 OR LI.OVERDUED_NE = 2 THEN
CASE
WHEN E.SUSPEND_FLAG = 0 THEN
CASE
WHEN SYSTIMESTAMP >= E.TARGET_OVERDUE_MINTIME THEN 1
ELSE 0
END
WHEN E.SUSPEND_FLAG = 1 THEN
CASE
WHEN E.SUSPEND_TIME >= E.TARGET_OVERDUE_MINTIME THEN 1
ELSE 0
END
ELSE 0
END
ELSE 0
END OVERDUED,
CASE
WHEN E.TARGET_OVERDUE_MINTIME IS NULL THEN LI.TARGET_TIME_NE
WHEN LI.TARGET_TIME_NE IS NULL THEN E.TARGET_OVERDUE_MINTIME
WHEN E.TARGET_OVERDUE_MINTIME <= LI.TARGET_TIME_NE THEN E.TARGET_OVERDUE_MINTIME
ELSE LI.TARGET_TIME_NE
END TARGET_TIME,
FTM.WORKFORM_TYPE_KIND
FROM (SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/
WF.PROC_INSTANCE_ID,
WF.ACTIVITY_INS_ID,
WF.WORKITEM_INS_ID,
WF.NAME,
WF.CURRENT_
STATE,
WF.COMPLETE_TIME,
WF.CREATE_TIME,
WF.LIMIT_TIME,
WF.APP_URL,
WF.USER_NAME,
WF.USER_ID,
WF.USER_ENTITY_TYPE,
WF.USER_ENTITY_NAME,
WF.USER_ENTITY_ID,
WF.PARTICIPANT_TYPE,
WF.SEND_TYPE,
WF.OVERDUED AS OVERDUED_NE,
WF.EXT_PROP,
WF.FLOW_DIRECTION,
WF.BUSINESSKEY,
WF.DEPART_ID,
F.INSTANCE_ID AS WI_INSTANCE_ID,
F.INSTANCE_NAME AS WI_INSTANCE_NAME,
F.WORKFORM_TYPE AS WI_WORKFORM_TYPE,
F.BUILDER AS WI_BUILDER,
F.START_TIME AS WI_CREATE_TIME,
F.INSTANCE_STATUS AS WI_INSTANCE_STATUS,
F.BUSINESS AS WI_BUSINESS,
F.KEYDATA_ID AS WI_KEYDATA_ID,
F.IS_FLOW AS WI_IS_FLOW,
F.ATTR1 AS WI_ATTR1,
F.DEPT_ID AS WI_DEPT_ID,
'' AS WT_DEPT_ID,
WF.CURRENT_STATE AS WT_WORKTASK_STATUS,
NULL AS WT_TARGET_TIME,
'' AS WT_LINK_URL,
'' AS WT_LINK_PARAM,
'' AS WT_IS_BATCH,
U.REAL_NAME AS WI_BUILDER_REALNAME,
NULL AS HOWLONG_WILL_OVERDUE,
NULL AS HOWLONG_OVERDUED,
'' AS ACTIVITY_TMP_ID,
O.TIME_OUT_TIME AS TARGET_TIME_NE,
B.APPROVAL_STATUS AS BE_APPROVAL_STATUS,
ORG.ORG_NO,
ORG.ORG_NAME,
'' AS VIEW_FLAGS
FROM SA_WORKFORM_INST F,
(SELECT W.*
FROM RT_WORKITEMINST W
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = :1
AND W.PARTICIPANT_TYPE = 0
UNION ALL
SELECT W.*
FROM RT_WORKITEMINST W, SA_BROLE_USER R
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = R.ROLE_ID
AND R.USER_ID = :2
AND W.PARTICIPANT_TYPE = 1) WF,
SA_USER U,
(SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O,
SA_WF_BUSINESS_EXT B,
SA_DEPT D,
SA_ORG ORG
WHERE F.PROCINST_ID = WF.PROC_INSTANCE_ID
AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+)
AND F.BUILDER = U.USER_ID(+)
AND U.DEPT_ID = D.DEPT_ID(+)
AND D.
ORG_NO = ORG.ORG_NO(+)
AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+)
AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((WF.DEPART_ID LIKE :3) OR (:4 LIKE (WF.DEPART_ID || '%')) OR (:5 = WF.DEPART_ID))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((F.DEPT_ID LIKE :6) OR (:7 LIKE (F.DEPT_ID || '%')) OR (:8 = F.DEPT_ID))))))
UNION ALL
SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/
WF.PROC_INSTANCE_ID,
WF.ACTIVITY_INS_ID,
WF.WORKITEM_INS_ID,
WF.NAME,
WF.CURRENT_STATE,
WF.COMPLETE_TIME,
WF.CREATE_TIME,
WF.LIMIT_TIME,
WF.APP_URL,
WF.USER_NAME,
WF.USER_ID,
WF.USER_ENTITY_TYPE,
WF.USER_ENTITY_NAME,
WF.USER_ENTITY_ID,
WF.PARTICIPANT_TYPE,
WF.SEND_TYPE,
WF.OVERDUED AS OVERDUED_NE,
WF.EXT_PROP,
WF.FLOW_DIRECTION,
WF.BUSINESSKEY,
WF.DEPART_ID,
F.INSTANCE_ID AS WI_INSTANCE_ID,
F.INSTANCE_NAME AS WI_INSTANCE_NAME,
F.WORKFORM_TYPE AS WI_WORKFORM_TYPE,
F.BUILDER AS WI_BUILDER,
F.START_TIME AS WI_CREATE_TIME,
F.INSTANCE_STATUS AS WI_INSTANCE_STATUS,
F.BUSINESS AS WI_BUSINESS,
F.KEYDATA_ID AS WI_KEYDATA_ID,
F.IS_FLOW AS WI_IS_FLOW,
F.ATTR1 AS WI_ATTR1,
F.DEPT_ID AS WI_DEPT_ID,
'' AS WT_DEPT_ID,
WF.CURRENT_STATE AS WT_WORKTASK_STATUS,
NULL AS WT_TARGET_TIME,
'' AS WT_LINK_URL,
'' AS WT_LINK_PARAM,
'' AS WT_IS_BATCH,
U.REAL_NAME AS WI_BUILDER_REALNAME,
NULL AS HOWLONG_WILL_OVERDUE,
NULL AS HOWLONG_OVERDUED,
'' AS ACTIVITY_TMP_ID,
O.TIME_OUT_TIME AS TARGET_TIME_NE,
B.APPROVAL_STATUS AS BE_APPROVAL_STATUS,
ORG.ORG_NO,
ORG.ORG_NAME,
'' AS VIEW_FLAGS
FROM SA_WORKFORM_INST F,
(SELECT W.*
FROM RT_WORKITEMINST W
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = :9
AND W.PARTICIPANT_TYPE = 0
UNION ALL
SELECT W.*
FROM RT_WORKITEMINST W, SA_BROLE_USER R
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = R.ROLE_ID
AND R.USER_ID = :10
AND W.PARTICIPANT_TYPE = 1) WF,
SA_USER U,
RT_PROCESSINSTANCE P,
(SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O,
SA_WF_BUSINESS_EXT B,
SA_DEPT D,
SA_ORG ORG
WHERE WF.PROC_INSTANCE_ID = P.PROC_INSTANCE_ID
AND P.PARENT_PROCINC_ID IS NOT NULL
AND F.PROCINST_ID = P.PARENT_PROCINC_ID
AND F.BUILDER = U.USER_ID(+)
AND U.DEPT_ID = D.DEPT_ID(+)
AND D.ORG_NO = ORG.ORG_NO(+)
AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+)
AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+)
AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((WF.DEPART_ID LIKE :11) OR (:12 LIKE (WF.DEPART_ID || '%')) OR (:13 = WF.DEPART_ID))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((F.DEPT_ID LIKE :14) OR (:15 LIKE (F.DEPT_ID || '%')) OR (:16 = F.DEPT_ID))))))
AND NOT EXISTS
(SELECT 1
FROM SA_WORKFORM_INST RF
WHERE WF.PROC_INSTANCE_ID = RF.PROCINST_ID)) LI,
SA_WF_WORKFORM_TYPE_MAP FTM,
(
SELECT ACT_INST_ID,
SUSPEND_FLAG,
MIN(TARGET_OVERDUE_MINTIME) AS TARGET_OVERDUE_MINTIME,
MIN(SUSPEND_TIME) AS SUSPEND_TIME
FROM (SELECT A.ACT_INST_ID, B.*
FROM SA_WF_EXAM_ACT_INST A, SA_WF_EXAM_INST B
WHERE A.SUBJECT_INST_ID = B.SUBJECT_INST_ID
AND A.PROC_INST_ID = B.PROC_INST_ID
AND B.COMPLETE_FLAG = 0)
GROUP BY ACT_INST_ID, SUSPEND_FLAG) E
WHERE LI.WI_WORKFORM_TYPE = FTM.WORKFORM_TYPE(+)
AND LI.ACTIVITY_INS_ID = E.ACT_INST_ID(+)) T
WHERE NOT EXISTS (SELECT 1
FROM SA_WF_WORKITEM_EXCLUDED_USER US
WHERE T.WORKITEM_INS_ID = US.WORKITEM_ID
AND US.USER_ID = :17) |
7hugj14vg23t3 |
select /*+ FIRST_ROWS */ * from (select t.*, ROWNUM as RN2 from (select c_cons.CONS_ID as "CONS_ID", c_cons.VAT_ID as "VAT_ID", c_vat.VAT_NAME as "VAT_NAME", c_cons.CUST_ID as "CUST_ID", c_cons.CONS_NO as "CONS_NO", c_cons.CONS_NAME as "CONS_NAME", c_cons.CUST_QUERY_NO as "CUST_QUERY_NO", c_cons.TMP_PAY_RELA_NO as "TMP_PAY_RELA_NO", c_cons.ORGN_CONS_NO as "ORGN_CONS_NO", c_cons.ELEC_ADDR as "ELEC_ADDR", c_cons.TRADE_CODE as "TRADE_CODE", (select TRADE from sa_c_trade_type where c_cons.TRADE_CODE = sa_c_trade_type.TRADE_CODE) as "TRADE", c_cons.ELEC_TYPE_CODE as "ELEC_TYPE_CODE", c_cons.CONTRACT_CAP as "CONTRACT_CAP", c_cons.RUN_CAP as "RUN_CAP", c_cons.SHIFT_NO as "SHIFT_NO", c_cons.LODE_ATTR_CODE as "LODE_ATTR_CODE", c_cons.HEC_INDUSTRY_CODE as "HEC_INDUSTRY_CODE", c_cons.HOLIDAY as "HOLIDAY", c_cons.BUILD_DATE as "BUILD_DATE", c_cons.PS_DATE as "PS_DATE", c_cons.CANCEL_DATE as "CANCEL_DATE", c_cons.DUE_DATE as "DUE_DATE", c_cons.NOTIFY_MODE as "NOTIFY_MODE", c_cons.SETTLE_MODE as "SETTLE_MODE", c_cons.STATUS_CODE as "STATUS_CODE", c_cons.ORG_NO as "ORG_NO", (select ORG_NAME from sa_org where c_cons.ORG_NO = sa_org.ORG_NO) as "ORG_NAME", c_cons.RRIO_CODE as "RRIO_COD
E", c_cons.CHK_CYCLE as "CHK_CYCLE", c_cons.LAST_CHK_DATE as "LAST_CHK_DATE", c_cons.CHECKER_NO as "CHECKER_NO", (select REAL_NAME from sa_user where c_cons.CHECKER_NO = sa_user.USER_ID) as "CHECKER_NAME", c_cons.POWEROFF_CODE as "POWEROFF_CODE", c_cons.TRANSFER_CODE as "TRANSFER_CODE", c_cons.MR_SECT_NO as "MR_SECT_NO", c_cons.NOTE_TYPE_CODE as "NOTE_TYPE_CODE", c_cons.TMP_FLAG as "TMP_FLAG", c_cons.TMP_DATE as "TMP_DATE", c_cons.MEAS_MODE as "MEAS_MODE", c_cons.DB_TIMESTAMP as "DB_TIMESTAMP", c_cons.VOLT_CODE as "VOLT_CODE", c_cons.CONS_SORT_CODE as "CONS_SORT_CODE", '' as "PAY_MODE", '' as "MADE_NO", '' as "BAR_CODE", '' as "ASSET_NO", '' as "MADE_NO1", '' as "BAR_CODE1", '' as "ASSET_NO1", '' as "TELE_NO", '' as "OPERATOR_NO", '' as "TG_ID", '' as "LINE_ID", '' as "MP_MEAS_MODE", '' as "METER_FLAG", c_cons.CARD_NO as "CARD_NO", (select c_acct.pay_no from c_acct, c_payment_rela where c_acct.acct_id = c_payment_rela.acct_id and c_payment_rela.cons_id = c_cons.cons_id and rownum = 1) as "PAY_NO", (select t.LINK_LIST_ID from sa_prop_list t where t.PROP_TYPE_ID = 'volt_code' and t.PROP_LIST_ID = c_cons.VOLT_CODE) as "PRC_VOLT_CODE", '' as "MR
_MODE_CODE", '' as "CUST_NO", '' as "TRAN_MADE_NO", '' as "SUBS_ID", '' as "EMP_NO", '' as "EMP_NAME", (select real_name from sa_user where user_id = (select r_oper_activity.operator_no from r_sect, r_oper_activity where r_sect.mr_sect_no = r_oper_activity.mr_sect_no and r_oper_activity.ACT_CODE = '03' and r_sect.mr_sect_no = c_cons.mr_sect_no)) as "OPERATOR_NAME", (select emp_no from o_staff where staff_no = c_cons.CHECKER_NO and rownum = 1) as "CHKER_EMP_NO", '' as "IF_SUBSCIBE", '' as "SUBSCRIBE_ITEM", '' as "MOBILE", (select ATTR1 from sa_org where c_cons.ORG_NO = sa_org.ORG_NO) as "ATTR1", (select t.VAL_STR from sa_c_ea_val t where t.ATTR_ID = '22' and t.ATTR_CODE = 'CHK_DEPT' and t.OBJ_CODE = 'C_CONS' and t.CONS_ID = C_CONS.CONS_ID) as "CK_DEPT", (select t.VAL_STR from sa_c_ea_val t where t.ATTR_CODE = 'CK_DEPT_DIALOG_LABEL' and t.OBJ_CODE = 'C_CONS' and t.CONS_ID = C_CONS.CONS_ID) as "CK_DEPT_DIALOG_LABEL", (select r_plan.mr_mode_code MR_MODE_CODE from r_plan where c_cons.mr_sect_no = r_plan.mr_sect_no(+) and rownum = '1') as "MR_MODE_CODE1", '' as "BANK_ACCT", '' as "CUST_ACCT_NAME", '' as "HAS_OLD_PLAN", c_cons.PRIO_CODE as "PRIO_CODE", '' as "PRC_CODE", (select c_cust.credit_level_code from c_cust where c_cust.cust_id = c_cons.cust_id) as "CREDIT_L
EVEL_CODE", (select c_cust.value_level_code from c_cust where c_cust.cust_id = c_cons.cust_id) as "VALUE_LEVEL_CODE", (select c_cust.RISK_LEVEL_CODE from c_cust where c_cust.cust_id = c_cons.cust_id) as "RISK_LEVEL_CODE", (select c_cust.VIP_LEVEL from c_cust where c_cust.cust_id = c_cons.cust_id) as "VIP_LEVEL", (select c_cust.VIP_FLAG from c_cust where c_cust.cust_id = c_cons.cust_id) as "VIP_FLAG", '' as "HAS_MP_STATUS", c_cons.URBAN_RURAL_FLAG as "URBAN_RURAL_FLAG" from c_cons, c_vat where ((c_cons.VAT_ID = c_vat.VAT_ID(+)) and (c_cons.CUST_QUERY_NO like :1 escape '/')) and (c_cons.ORG_NO like :2)) t where ROWNUM <= :3) where RN2 > :4 |
7ng34ruy5awxq | select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj# |
7pnsrkndbdkdv | BEGIN DELETE FROM TMP_E_CONS_PRC_AMT_ID; FOR I IN 1 .. :sys_need_serial_count LOOP INSERT INTO TMP_E_CONS_PRC_AMT_ID(PRC_AMT_ID)VALUES(SEQ_E_CONS_PRC_AMT.NEXTVAL); END LOOP; OPEN :RET_CUR FOR SELECT PRC_AMT_ID FROM TMP_E_CONS_PRC_AMT_ID; END; |
7tc5u8t3mmzgf | select cachedblk, cachehit, logicalread from tab_stats$ where obj#=:1 |
81aguag80jf5h | select SEQ_P_SMS_SEND_ID.NEXTVAL from dual |
83m5qm6bras0m |
SELECT *
FROM (SELECT LI.*,
CASE
WHEN LI.OVERDUED_NE = 1 OR LI.OVERDUED_NE = 3 THEN 1
WHEN LI.OVERDUED_NE = 0 OR LI.OVERDUED_NE = 2 THEN
CASE
WHEN E.SUSPEND_FLAG = 0 THEN
CASE
WHEN SYSTIMESTAMP >= E.TARGET_OVERDUE_MINTIME THEN 1
ELSE 0
END
WHEN E.SUSPEND_FLAG = 1 THEN
CASE
WHEN E.SUSPEND_TIME >= E.TARGET_OVERDUE_MINTIME THEN 1
ELSE 0
END
ELSE 0
END
ELSE 0
END OVERDUED,
CASE
WHEN E.TARGET_OVERDUE_MINTIME IS NULL THEN LI.TARGET_TIME_NE
WHEN LI.TARGET_TIME_NE IS NULL THEN E.TARGET_OVERDUE_MINTIME
WHEN E.TARGET_OVERDUE_MINTIME <= LI.TARGET_TIME_NE THEN E.TARGET_OVERDUE_MINTIME
ELSE LI.TARGET_TIME_NE
END TARGET_TIME,
FTM.WORKFORM_TYPE_KIND
FROM (SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/
WF.PROC_INSTANCE_ID,
WF.ACTIVITY_INS_ID,
WF.WORKITEM_INS_ID,
WF.NAME,
WF.CURRENT_
STATE,
WF.COMPLETE_TIME,
WF.CREATE_TIME,
WF.LIMIT_TIME,
WF.APP_URL,
WF.USER_NAME,
WF.USER_ID,
WF.USER_ENTITY_TYPE,
WF.USER_ENTITY_NAME,
WF.USER_ENTITY_ID,
WF.PARTICIPANT_TYPE,
WF.SEND_TYPE,
WF.OVERDUED AS OVERDUED_NE,
WF.EXT_PROP,
WF.FLOW_DIRECTION,
WF.BUSINESSKEY,
WF.DEPART_ID,
F.INSTANCE_ID AS WI_INSTANCE_ID,
F.INSTANCE_NAME AS WI_INSTANCE_NAME,
F.WORKFORM_TYPE AS WI_WORKFORM_TYPE,
F.BUILDER AS WI_BUILDER,
F.START_TIME AS WI_CREATE_TIME,
F.INSTANCE_STATUS AS WI_INSTANCE_STATUS,
F.BUSINESS AS WI_BUSINESS,
F.KEYDATA_ID AS WI_KEYDATA_ID,
F.IS_FLOW AS WI_IS_FLOW,
F.ATTR1 AS WI_ATTR1,
F.DEPT_ID AS WI_DEPT_ID,
'' AS WT_DEPT_ID,
WF.CURRENT_STATE AS WT_WORKTASK_STATUS,
NULL AS WT_TARGET_TIME,
'' AS WT_LINK_URL,
'' AS WT_LINK_PARAM,
'' AS WT_IS_BATCH,
U.REAL_NAME AS WI_BUILDER_REALNAME,
NULL AS HOWLONG_WILL_OVERDUE,
NULL AS HOWLONG_OVERDUED,
'' AS ACTIVITY_TMP_ID,
O.TIME_OUT_TIME AS TARGET_TIME_NE,
B.APPROVAL_STATUS AS BE_APPROVAL_STATUS,
ORG.ORG_NO,
ORG.ORG_NAME,
'' AS VIEW_FLAGS
FROM SA_WORKFORM_INST F,
(SELECT W.*
FROM RT_WORKITEMINST W
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = :1
AND W.PARTICIPANT_TYPE = 0
UNION ALL
SELECT W.*
FROM RT_WORKITEMINST W, SA_BROLE_USER R
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = R.ROLE_ID
AND R.USER_ID = :2
AND W.PARTICIPANT_TYPE = 1) WF,
SA_USER U,
(SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O,
SA_WF_BUSINESS_EXT B,
SA_DEPT D,
SA_ORG ORG
WHERE F.PROCINST_ID = WF.PROC_INSTANCE_ID
AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+)
AND F.BUILDER = U.USER_ID(+)
AND U.DEPT_ID = D.DEPT_ID(+)
AND D.
ORG_NO = ORG.ORG_NO(+)
AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+)
AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:3 LIKE (WF.DEPART_ID || '%')) OR (:4 = WF.DEPART_ID) OR (:5 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :6))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:7 LIKE (F.DEPT_ID || '%')) OR (:8 = F.DEPT_ID) OR (:9 = F.DEPT_ID) OR (F.DEPT_ID LIKE :10))))))
UNION ALL
SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/
WF.PROC_INSTANCE_ID,
WF.ACTIVITY_INS_ID,
WF.WORKITEM_INS_ID,
WF.NAME,
WF.CURRENT_STATE,
WF.COMPLETE_TIME,
WF.CREATE_TIME,
WF.LIMIT_TIME,
WF.APP_URL,
WF.USER_NAME,
WF.USER_ID,
WF.USER_ENTITY_TYPE,
WF.USER_ENTITY_NAME,
WF.USER_ENTITY_ID,
WF.PARTICIPANT_TYPE,
WF.SEND_TYPE,
WF.OVERDUED AS OVERDUED_NE,
WF.EXT_PROP,
WF.FLOW_DIRECTION,
WF.BUSINESSKEY,
WF.DEPART_ID,
F.INSTANCE_ID AS WI_INSTANCE_ID,
F.INSTANCE_NAME AS WI_INSTANCE_NAME,
F.WORKFORM_TYPE AS WI_WORKFORM_TYPE,
F.BUILDER AS WI_BUILDER,
F.START_TIME AS WI_CREATE_TIME,
F.INSTANCE_STATUS AS WI_INSTANCE_STATUS,
F.BUSINESS AS WI_BUSINESS,
F.KEYDATA_ID AS WI_KEYDATA_ID,
F.IS_FLOW AS WI_IS_FLOW,
F.ATTR1 AS WI_ATTR1,
F.DEPT_ID AS WI_DEPT_ID,
'' AS WT_DEPT_ID,
WF.CURRENT_STATE AS WT_WORKTASK_STATUS,
NULL AS WT_TARGET_TIME,
'' AS WT_LINK_URL,
'' AS WT_LINK_PARAM,
'' AS WT_IS_BATCH,
U.REAL_NAME AS WI_BUILDER_REALNAME,
NULL AS HOWLONG_WILL_OVERDUE,
NULL AS HOWLONG_OVERDUED,
'' AS ACTIVITY_TMP_ID,
O.TIME_OUT_TIME AS TARGET_TIME_NE,
B.APPROVAL_STATUS AS BE_APPROVAL_STATUS,
ORG.ORG_NO,
ORG.ORG_NAME,
'' AS VIEW_FLAGS
FROM SA_WORKFORM_INST F,
(SELECT W.*
FROM RT_WORKITEMINST W
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = :11
AND W.PARTICIPANT_TYPE = 0
UNION ALL
SELECT W.*
FROM RT_WORKITEMINST W, SA_BROLE_USER R
WHERE (W.CURRENT_STATE
= 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = R.ROLE_ID
AND R.USER_ID = :12
AND W.PARTICIPANT_TYPE = 1) WF,
SA_USER U,
RT_PROCESSINSTANCE P,
(SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O,
SA_WF_BUSINESS_EXT B,
SA_DEPT D,
SA_ORG ORG
WHERE WF.PROC_INSTANCE_ID = P.PROC_INSTANCE_ID
AND P.PARENT_PROCINC_ID IS NOT NULL
AND F.PROCINST_ID = P.PARENT_PROCINC_ID
AND F.BUILDER = U.USER_ID(+)
AND U.DEPT_ID = D.DEPT_ID(+)
AND D.ORG_NO = ORG.ORG_NO(+)
AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+)
AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+)
AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:13 LIKE (WF.DEPART_ID || '%')) OR (:14 = WF.DEPART_ID) OR (:15 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :16))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:17 LIKE (F.DEPT_ID || '%')) OR (:18 = F.DEPT_ID) OR (:19 = F.DEPT_ID) OR (F.DEPT_ID LIKE :20))))))
AND NOT EXISTS
(SELECT 1
FROM SA_WORKFORM_INST RF
WHERE WF.PROC_INSTANC
E_ID = RF.PROCINST_ID)) LI,
SA_WF_WORKFORM_TYPE_MAP FTM,
(SELECT ACT_INST_ID,
SUSPEND_FLAG,
MIN(TARGET_OVERDUE_MINTIME) AS TARGET_OVERDUE_MINTIME,
MIN(SUSPEND_TIME) AS SUSPEND_TIME
FROM (SELECT A.ACT_INST_ID, B.*
FROM SA_WF_EXAM_ACT_INST A, SA_WF_EXAM_INST B
WHERE A.SUBJECT_INST_ID = B.SUBJECT_INST_ID
AND A.PROC_INST_ID = B.PROC_INST_ID
AND B.COMPLETE_FLAG = 0)
GROUP BY ACT_INST_ID, SUSPEND_FLAG) E
WHERE LI.WI_WORKFORM_TYPE = FTM.WORKFORM_TYPE(+)
AND LI.ACTIVITY_INS_ID = E.ACT_INST_ID(+)) T
WHERE NOT EXISTS (SELECT 1
FROM SA_WF_WORKITEM_EXCLUDED_USER US
WHERE T.WORKITEM_INS_ID = US.WORKITEM_ID
AND US.USER_ID = :21) |
8bcwmr56r94vs | SELECT DISTINCT B.PARENT_DEPT_ID FROM SA_DEPT B CONNECT BY PRIOR B.PARENT_DEPT_ID = B.DEPT_ID START WITH EXISTS (SELECT * FROM SA_USER A WHERE A.DEPT_ID = B.DEPT_ID AND A.DEPT_ID = :B2 AND A.USER_ID = :B1 ) |
8d7wv2y3tv46n |
select /*+ FIRST_ROWS */ * from (select t.*, ROWNUM as RN2 from (select view_s_app_workform.WORKFORM_STATUS as "WORKFORM_STATUS", view_s_app_workform.APP_ID as "APP_ID", view_s_app_workform.APP_NO as "APP_NO", view_s_app_workform.APP_MODE as "APP_MODE", view_s_app_workform.HANDLE_DEPT_NO as "HANDLE_DEPT_NO", view_s_app_workform.HANDLE_TIME as "HANDLE_TIME", view_s_app_workform.CONS_NO as "CONS_NO", view_s_app_workform.CONS_NAME as "CONS_NAME", view_s_app_workform.CUST_QUERY_NO as "CUST_QUERY_NO", view_s_app_workform.TMP_PAY_RELA_NO as "TMP_PAY_RELA_NO", view_s_app_workform.ORGN_CONS_NO as "ORGN_CONS_NO", view_s_app_workform.CONS_SORT_CODE as "CONS_SORT_CODE", view_s_app_workform.ELEC_ADDR as "ELEC_ADDR", view_s_app_workform.TRADE_CODE as "TRADE_CODE", view_s_app_workform.ELEC_TYPE_CODE as "ELEC_TYPE_CODE", view_s_app_workform.SHIFT_NO as "SHIFT_NO", view_s_app_workform.LODE_ATTR_CODE as "LODE_ATTR_CODE", view_s_app_workform.VOLT_CODE as "VOLT_CODE", view_s_app_workform.HEC_INDUSTRY_CODE as "HEC_INDUSTRY_CODE", view_s_app_workform.HOLIDAY as "HOLIDAY", view_s_app_workform.NOTIFY_MODE as "NOTIFY_MODE", view_s_app_workform.SETTLE_MODE as "SETTLE_MODE", view_s_app_workform.ORG_NO as "ORG_NO", view_s_app_workform.TRANSFER_CODE as &
quot;TRANSFER_CODE", view_s_app_workform.MR_SECT_NO as "MR_SECT_NO", view_s_app_workform.NOTE_TYPE_CODE as "NOTE_TYPE_CODE", view_s_app_workform.TMP_FLAG as "TMP_FLAG", view_s_app_workform.TMP_DATE as "TMP_DATE", view_s_app_workform.APP_CONTRACT_CAP as "APP_CONTRACT_CAP", view_s_app_workform.ORGN_CONTRACT_CAP as "ORGN_CONTRACT_CAP", view_s_app_workform.CONTRACT_CAP as "CONTRACT_CAP", view_s_app_workform.APP_RUN_CAP as "APP_RUN_CAP", view_s_app_workform.ORGN_RUN_CAP as "ORGN_RUN_CAP", view_s_app_workform.RUN_CAP as "RUN_CAP", view_s_app_workform.BGN_DATE as "BGN_DATE", view_s_app_workform.END_DATE as "END_DATE", view_s_app_workform.REASON as "REASON", view_s_app_workform.SHIFT_IN_CAP as "SHIFT_IN_CAP", view_s_app_workform.SHIFT_OUT_CAP as "SHIFT_OUT_CAP", view_s_app_workform.PERMENANT_REDUCE_FLAG as "PERMENANT_REDUCE_FLAG", view_s_app_workform.CONTENT as "CONTENT", view_s_app_workform.ST_UPQ as "ST_UPQ", view_s_app_workform.LONGTERM_CAP as "LONGTERM_CAP", view_s_app_workform.POWER_USAGE as "POWER_USAGE", view_s_app_workform.DMD_DATE as "DMD_DATE", view_s_app_workform.APP_TYPE_CODE as "APP_TYPE_CODE", view_s_app_workform.HANDLE_FLAG as "HANDLE_FLAG", view_s_app_workform.REFUSE_REASON as "REFUSE_REASON", view_s_ap
p_workform.RELA_APP_CODE as "RELA_APP_CODE", view_s_app_workform.REMARK as "REMARK", view_s_app_workform.MEAS_MODE as "MEAS_MODE", view_s_app_workform.BUILD_DATE as "BUILD_DATE", view_s_app_workform.PS_DATE as "PS_DATE", view_s_app_workform.CANCEL_DATE as "CANCEL_DATE", view_s_app_workform.DUE_DATE as "DUE_DATE", view_s_app_workform.STATUS_CODE as "STATUS_CODE", view_s_app_workform.OPERATE_STATUS as "OPERATE_STATUS", view_s_app_workform.MRD_FACTOR_CODE as "MRD_FACTOR_CODE", view_s_app_workform.IS_FLOW as "IS_FLOW", view_s_app_workform.INSTANCE_STATUS as "INSTANCE_STATUS", view_s_app_workform.COMPLETE_TIME as "COMPLETE_TIME", sa_c_trade_type.TRADE as "TRADE", sa_org.ORG_NO as "ORG_NO1", sa_org.ORG_NAME as "ORG_NAME", view_s_app_workform.DEPT_ID as "DEPT_ID", view_s_app_workform.REAL_NAME as "REAL_NAME", view_s_app_workform.DEPT_NAME as "DEPT_NAME", sa_org.ORG_TREE as "ORG_TREE", '' as "WORKFLOW_NAME", '' as "HANDLE_DEPT_NAME" from view_s_app_workform, sa_c_trade_type, sa_org where ((((view_s_app_workform.TRADE_CODE = sa_c_trade_type.TRADE_CODE(+) and VIEW_S_APP_WORKFORM.org_no = sa_org.org_no(+)) and ((view_s_app_workform.APP_TYPE_CODE=:1 AND view_s_app_workform.INSTANCE_STATUS=:2 AND (view_s_app_workform.HANDLE_TIME>=:3 AND view_s_app
_workform.HANDLE_TIME<=:4) AND (view_s_app_workform.COMPLETE_TIME>=:5 AND view_s_app_workform.COMPLETE_TIME<=:6)))) and (VIEW_S_APP_WORKFORM.APP_TYPE_CODE IN ('101', '102', '103', '104', '105', '106', '107', '108', '109', '110', '111', '112', '201', '202', '203', '204', '205', '206', '207', '208', '209', '210', '211', '212', '213', '214', '215', '216', '217', '218', '301', '302', '303', '304', '305', '306', '307', '311', '351', '357', '715', '716', '901', '902'))) and (SA_ORG.ORG_TREE LIKE :7)) and (VIEW_S_APP_WORKFORM.ORG_NO LIKE :8) order by VIEW_S_APP_WORKFORM.APP_NO DESC) t where ROWNUM <= :9) where RN2 > :10 |
8f1sjvfxuup9w | select t.*, o.*, m.comments
from sys.all_tables t,
sys.all_tab_comments m,
sys.all_objects o
where t.owner = :object_owner
and t.table_name = :object_name
and m.owner (+) = :object_owner
and m.table_name (+) = :object_name
and o.owner (+) = :object_owner
and o.object_name (+) = :object_name
and :object_type is not null
and :sub_object is null
|
8kq6gmc6gaz6b | select sa_fr_status.WORKITEM_INS_ID as "insId", sa_fr_status.TASK_ID as "taskId", sa_fr_status.TASK_STATUS as "taskStatus", sa_fr_status.DEAL_DATE as "dealDate", sa_fr_status.WORKER as "worker", sa_fr_status.EXT_PAR as "extPar" from sa_fr_status where sa_fr_status.WORKITEM_INS_ID= :1 and sa_fr_status.TASK_ID = :2 |
8mrg623amm8rx |
select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c, v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL
LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d, v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
|
8pg54v2j5v6x0 | select SEQ_A_VOUCHER_ACCT_NO.NEXTVAL from dual |
8xfbm11gv2rv0 | select sa_dept.DEPT_ID as "DEPT_ID", sa_dept.DEPT_NAME as "DEPT_NAME", sa_dept.PARENT_DEPT_ID as "PARENT_DEPT_ID", sa_dept.IS_DELETE as "IS_DELETE", sa_dept.IS_DATA_DEPT as "IS_DATA_DEPT", sa_dept.DEPT_TREE as "DEPT_TREE", sa_dept.DEPT_TYPE as "DEPT_TYPE", sa_dept.DEPT_SHORTNAME as "DEPT_SHORTNAME", sa_dept.ORDER_ID as "ORDER_ID", sa_dept.ATTR1 as "ATTR1", sa_dept.ATTR2 as "ATTR2", sa_dept.ATTR3 as "ATTR3", sa_dept.ATTR4 as "ATTR4", sa_dept.IS_ORGNIZATION as "IS_ORGNIZATION", sa_dept.IS_BILL as "IS_BILL", sa_dept.IS_DIRECT as "IS_DIRECT", sa_dept.IS_ACCOUNT as "IS_ACCOUNT", sa_dept.DBPAR_NO as "DBPAR_NO", sa_dept.ORG_NO as "ORG_NO" from sa_dept where sa_dept.DEPT_ID=:1 |
92juu7dd8686r |
select /*+ FIRST_ROWS */ * from (select t.*, ROWNUM as RN2 from (select c_cons.CONS_ID as "CONS_ID", c_cons.VAT_ID as "VAT_ID", c_vat.VAT_NAME as "VAT_NAME", c_cons.CUST_ID as "CUST_ID", c_cons.CONS_NO as "CONS_NO", c_cons.CONS_NAME as "CONS_NAME", c_cons.CUST_QUERY_NO as "CUST_QUERY_NO", c_cons.TMP_PAY_RELA_NO as "TMP_PAY_RELA_NO", c_cons.ORGN_CONS_NO as "ORGN_CONS_NO", c_cons.ELEC_ADDR as "ELEC_ADDR", c_cons.TRADE_CODE as "TRADE_CODE", (select TRADE from sa_c_trade_type where c_cons.TRADE_CODE = sa_c_trade_type.TRADE_CODE) as "TRADE", c_cons.ELEC_TYPE_CODE as "ELEC_TYPE_CODE", c_cons.CONTRACT_CAP as "CONTRACT_CAP", c_cons.RUN_CAP as "RUN_CAP", c_cons.SHIFT_NO as "SHIFT_NO", c_cons.LODE_ATTR_CODE as "LODE_ATTR_CODE", c_cons.HEC_INDUSTRY_CODE as "HEC_INDUSTRY_CODE", c_cons.HOLIDAY as "HOLIDAY", c_cons.BUILD_DATE as "BUILD_DATE", c_cons.PS_DATE as "PS_DATE", c_cons.CANCEL_DATE as "CANCEL_DATE", c_cons.DUE_DATE as "DUE_DATE", c_cons.NOTIFY_MODE as "NOTIFY_MODE", c_cons.SETTLE_MODE as "SETTLE_MODE", c_cons.STATUS_CODE as "STATUS_CODE", c_cons.ORG_NO as "ORG_NO", (select ORG_NAME from sa_org where c_cons.ORG_NO = sa_org.ORG_NO) as "ORG_NAME", c_cons.RRIO_CODE as "RRIO_COD
E", c_cons.CHK_CYCLE as "CHK_CYCLE", c_cons.LAST_CHK_DATE as "LAST_CHK_DATE", c_cons.CHECKER_NO as "CHECKER_NO", (select REAL_NAME from sa_user where c_cons.CHECKER_NO = sa_user.USER_ID) as "CHECKER_NAME", c_cons.POWEROFF_CODE as "POWEROFF_CODE", c_cons.TRANSFER_CODE as "TRANSFER_CODE", c_cons.MR_SECT_NO as "MR_SECT_NO", c_cons.NOTE_TYPE_CODE as "NOTE_TYPE_CODE", c_cons.TMP_FLAG as "TMP_FLAG", c_cons.TMP_DATE as "TMP_DATE", c_cons.MEAS_MODE as "MEAS_MODE", c_cons.DB_TIMESTAMP as "DB_TIMESTAMP", c_cons.VOLT_CODE as "VOLT_CODE", c_cons.CONS_SORT_CODE as "CONS_SORT_CODE", '' as "PAY_MODE", '' as "MADE_NO", '' as "BAR_CODE", '' as "ASSET_NO", '' as "MADE_NO1", '' as "BAR_CODE1", '' as "ASSET_NO1", '' as "TELE_NO", '' as "OPERATOR_NO", '' as "TG_ID", '' as "LINE_ID", '' as "MP_MEAS_MODE", '' as "METER_FLAG", c_cons.CARD_NO as "CARD_NO", (select c_acct.pay_no from c_acct, c_payment_rela where c_acct.acct_id = c_payment_rela.acct_id and c_payment_rela.cons_id = c_cons.cons_id and rownum = 1) as "PAY_NO", (select t.LINK_LIST_ID from sa_prop_list t where t.PROP_TYPE_ID = 'volt_code' and t.PROP_LIST_ID = c_cons.VOLT_CODE) as "PRC_VOLT_CODE", '' as "MR
_MODE_CODE", '' as "CUST_NO", '' as "TRAN_MADE_NO", '' as "SUBS_ID", '' as "EMP_NO", '' as "EMP_NAME", (select real_name from sa_user where user_id = (select r_oper_activity.operator_no from r_sect, r_oper_activity where r_sect.mr_sect_no = r_oper_activity.mr_sect_no and r_oper_activity.ACT_CODE = '03' and r_sect.mr_sect_no = c_cons.mr_sect_no)) as "OPERATOR_NAME", (select emp_no from o_staff where staff_no = c_cons.CHECKER_NO and rownum = 1) as "CHKER_EMP_NO", '' as "IF_SUBSCIBE", '' as "SUBSCRIBE_ITEM", '' as "MOBILE", (select ATTR1 from sa_org where c_cons.ORG_NO = sa_org.ORG_NO) as "ATTR1", (select t.VAL_STR from sa_c_ea_val t where t.ATTR_ID = '22' and t.ATTR_CODE = 'CHK_DEPT' and t.OBJ_CODE = 'C_CONS' and t.CONS_ID = C_CONS.CONS_ID) as "CK_DEPT", (select t.VAL_STR from sa_c_ea_val t where t.ATTR_CODE = 'CK_DEPT_DIALOG_LABEL' and t.OBJ_CODE = 'C_CONS' and t.CONS_ID = C_CONS.CONS_ID) as "CK_DEPT_DIALOG_LABEL", (select r_plan.mr_mode_code MR_MODE_CODE from r_plan where c_cons.mr_sect_no = r_plan.mr_sect_no(+) and rownum = '1') as "MR_MODE_CODE1", '' as "BANK_ACCT", '' as "CUST_ACCT_NAME", '' as "HAS_OLD_PLAN", c_cons.PRIO_CODE as "PRIO_CODE", '' as "PRC_CODE", (select c_cust.credit_level_code from c_cust where c_cust.cust_id = c_cons.cust_id) as "CREDIT_L
EVEL_CODE", (select c_cust.value_level_code from c_cust where c_cust.cust_id = c_cons.cust_id) as "VALUE_LEVEL_CODE", (select c_cust.RISK_LEVEL_CODE from c_cust where c_cust.cust_id = c_cons.cust_id) as "RISK_LEVEL_CODE", (select c_cust.VIP_LEVEL from c_cust where c_cust.cust_id = c_cons.cust_id) as "VIP_LEVEL", (select c_cust.VIP_FLAG from c_cust where c_cust.cust_id = c_cons.cust_id) as "VIP_FLAG", '' as "HAS_MP_STATUS", c_cons.URBAN_RURAL_FLAG as "URBAN_RURAL_FLAG" from c_cons, c_vat where ((c_cons.VAT_ID = c_vat.VAT_ID(+)) and (exists (select 1 from c_meter, c_meter_mp_rela where c_meter.cons_mt_id = c_meter_mp_rela.cons_mt_id and c_meter_mp_rela.cons_id = c_cons.cons_id and c_cons.org_no = c_meter.org_no and c_meter.made_no like :1 escape '/'))) and (c_cons.ORG_NO like :2)) t where ROWNUM <= :3) where RN2 > :4 |
9ay9a4kkapzzr | select distinct 1 from
(select distinct 1 from sa_resource t1, sa_brole_permission t2, sa_brole_user t3, sa_permission_resource_map t4
where t1.res_id=:1
and ((t3.user_id = :2 and t2.role_id = t3.role_id))
and (t1.res_id=t4.res_id)
and t4.permission_id = t2.permission_id and t4.perm_type_id = :3
union all
select distinct 1 from sa_resource t1, sa_brole_permission t2, sa_permission_resource_map t4
where t1.res_id=:4
and (t2.role_id = 'everyone')
and (t1.res_id=t4.res_id)
and t4.permission_id = t2.permission_id and t4.perm_type_id = :5) A |
9xrckb0sbmrbg |
select /*+ FIRST_ROWS */ * from (select t.*, ROWNUM as RN2 from (select c_cons.CONS_ID as "CONS_ID", c_cons.VAT_ID as "VAT_ID", c_vat.VAT_NAME as "VAT_NAME", c_cons.CUST_ID as "CUST_ID", c_cons.CONS_NO as "CONS_NO", c_cons.CONS_NAME as "CONS_NAME", c_cons.CUST_QUERY_NO as "CUST_QUERY_NO", c_cons.TMP_PAY_RELA_NO as "TMP_PAY_RELA_NO", c_cons.ORGN_CONS_NO as "ORGN_CONS_NO", c_cons.ELEC_ADDR as "ELEC_ADDR", c_cons.TRADE_CODE as "TRADE_CODE", (select TRADE from sa_c_trade_type where c_cons.TRADE_CODE = sa_c_trade_type.TRADE_CODE) as "TRADE", c_cons.ELEC_TYPE_CODE as "ELEC_TYPE_CODE", c_cons.CONTRACT_CAP as "CONTRACT_CAP", c_cons.RUN_CAP as "RUN_CAP", c_cons.SHIFT_NO as "SHIFT_NO", c_cons.LODE_ATTR_CODE as "LODE_ATTR_CODE", c_cons.HEC_INDUSTRY_CODE as "HEC_INDUSTRY_CODE", c_cons.HOLIDAY as "HOLIDAY", c_cons.BUILD_DATE as "BUILD_DATE", c_cons.PS_DATE as "PS_DATE", c_cons.CANCEL_DATE as "CANCEL_DATE", c_cons.DUE_DATE as "DUE_DATE", c_cons.NOTIFY_MODE as "NOTIFY_MODE", c_cons.SETTLE_MODE as "SETTLE_MODE", c_cons.STATUS_CODE as "STATUS_CODE", c_cons.ORG_NO as "ORG_NO", (select ORG_NAME from sa_org where c_cons.ORG_NO = sa_org.ORG_NO) as "ORG_NAME", c_cons.RRIO_CODE as "RRIO_COD
E", c_cons.CHK_CYCLE as "CHK_CYCLE", c_cons.LAST_CHK_DATE as "LAST_CHK_DATE", c_cons.CHECKER_NO as "CHECKER_NO", (select REAL_NAME from sa_user where c_cons.CHECKER_NO = sa_user.USER_ID) as "CHECKER_NAME", c_cons.POWEROFF_CODE as "POWEROFF_CODE", c_cons.TRANSFER_CODE as "TRANSFER_CODE", c_cons.MR_SECT_NO as "MR_SECT_NO", c_cons.NOTE_TYPE_CODE as "NOTE_TYPE_CODE", c_cons.TMP_FLAG as "TMP_FLAG", c_cons.TMP_DATE as "TMP_DATE", c_cons.MEAS_MODE as "MEAS_MODE", c_cons.DB_TIMESTAMP as "DB_TIMESTAMP", c_cons.VOLT_CODE as "VOLT_CODE", c_cons.CONS_SORT_CODE as "CONS_SORT_CODE", '' as "PAY_MODE", '' as "MADE_NO", '' as "BAR_CODE", '' as "ASSET_NO", '' as "MADE_NO1", '' as "BAR_CODE1", '' as "ASSET_NO1", '' as "TELE_NO", '' as "OPERATOR_NO", '' as "TG_ID", '' as "LINE_ID", '' as "MP_MEAS_MODE", '' as "METER_FLAG", c_cons.CARD_NO as "CARD_NO", (select c_acct.pay_no from c_acct, c_payment_rela where c_acct.acct_id = c_payment_rela.acct_id and c_payment_rela.cons_id = c_cons.cons_id and rownum = 1) as "PAY_NO", (select t.LINK_LIST_ID from sa_prop_list t where t.PROP_TYPE_ID = 'volt_code' and t.PROP_LIST_ID = c_cons.VOLT_CODE) as "PRC_VOLT_CODE", '' as "MR
_MODE_CODE", '' as "CUST_NO", '' as "TRAN_MADE_NO", '' as "SUBS_ID", '' as "EMP_NO", '' as "EMP_NAME", (select real_name from sa_user where user_id = (select r_oper_activity.operator_no from r_sect, r_oper_activity where r_sect.mr_sect_no = r_oper_activity.mr_sect_no and r_oper_activity.ACT_CODE = '03' and r_sect.mr_sect_no = c_cons.mr_sect_no)) as "OPERATOR_NAME", (select emp_no from o_staff where staff_no = c_cons.CHECKER_NO and rownum = 1) as "CHKER_EMP_NO", '' as "IF_SUBSCIBE", '' as "SUBSCRIBE_ITEM", '' as "MOBILE", (select ATTR1 from sa_org where c_cons.ORG_NO = sa_org.ORG_NO) as "ATTR1", (select t.VAL_STR from sa_c_ea_val t where t.ATTR_ID = '22' and t.ATTR_CODE = 'CHK_DEPT' and t.OBJ_CODE = 'C_CONS' and t.CONS_ID = C_CONS.CONS_ID) as "CK_DEPT", (select t.VAL_STR from sa_c_ea_val t where t.ATTR_CODE = 'CK_DEPT_DIALOG_LABEL' and t.OBJ_CODE = 'C_CONS' and t.CONS_ID = C_CONS.CONS_ID) as "CK_DEPT_DIALOG_LABEL", (select r_plan.mr_mode_code MR_MODE_CODE from r_plan where c_cons.mr_sect_no = r_plan.mr_sect_no(+) and rownum = '1') as "MR_MODE_CODE1", '' as "BANK_ACCT", '' as "CUST_ACCT_NAME", '' as "HAS_OLD_PLAN", c_cons.PRIO_CODE as "PRIO_CODE", '' as "PRC_CODE", (select c_cust.credit_level_code from c_cust where c_cust.cust_id = c_cons.cust_id) as "CREDIT_L
EVEL_CODE", (select c_cust.value_level_code from c_cust where c_cust.cust_id = c_cons.cust_id) as "VALUE_LEVEL_CODE", (select c_cust.RISK_LEVEL_CODE from c_cust where c_cust.cust_id = c_cons.cust_id) as "RISK_LEVEL_CODE", (select c_cust.VIP_LEVEL from c_cust where c_cust.cust_id = c_cons.cust_id) as "VIP_LEVEL", (select c_cust.VIP_FLAG from c_cust where c_cust.cust_id = c_cons.cust_id) as "VIP_FLAG", '' as "HAS_MP_STATUS", c_cons.URBAN_RURAL_FLAG as "URBAN_RURAL_FLAG" from c_cons, c_vat where ((c_cons.VAT_ID = c_vat.VAT_ID(+)) and (exists (select 1 from c_meter, c_meter_mp_rela where c_meter.cons_mt_id = c_meter_mp_rela.cons_mt_id and c_meter_mp_rela.cons_id = c_cons.cons_id and c_cons.org_no = c_meter.org_no and c_meter.made_no=:1))) and (c_cons.ORG_NO like :2)) t where ROWNUM <= :3) where RN2 > :4 |
9zm2m4a85pqf4 |
select /*+ FIRST_ROWS */ * from (select t.*, ROWNUM as RN2 from (select c_cons.CONS_ID as "CONS_ID", c_cons.VAT_ID as "VAT_ID", c_vat.VAT_NAME as "VAT_NAME", c_cons.CUST_ID as "CUST_ID", c_cons.CONS_NO as "CONS_NO", c_cons.CONS_NAME as "CONS_NAME", c_cons.CUST_QUERY_NO as "CUST_QUERY_NO", c_cons.TMP_PAY_RELA_NO as "TMP_PAY_RELA_NO", c_cons.ORGN_CONS_NO as "ORGN_CONS_NO", c_cons.ELEC_ADDR as "ELEC_ADDR", c_cons.TRADE_CODE as "TRADE_CODE", sa_c_trade_type.TRADE as "TRADE", c_cons.ELEC_TYPE_CODE as "ELEC_TYPE_CODE", c_cons.CONTRACT_CAP as "CONTRACT_CAP", c_cons.RUN_CAP as "RUN_CAP", c_cons.SHIFT_NO as "SHIFT_NO", c_cons.LODE_ATTR_CODE as "LODE_ATTR_CODE", c_cons.HEC_INDUSTRY_CODE as "HEC_INDUSTRY_CODE", c_cons.HOLIDAY as "HOLIDAY", c_cons.BUILD_DATE as "BUILD_DATE", c_cons.PS_DATE as "PS_DATE", c_cons.CANCEL_DATE as "CANCEL_DATE", c_cons.DUE_DATE as "DUE_DATE", c_cons.NOTIFY_MODE as "NOTIFY_MODE", c_cons.SETTLE_MODE as "SETTLE_MODE", c_cons.STATUS_CODE as "STATUS_CODE", c_cons.ORG_NO as "ORG_NO", sa_org.ORG_NAME as "ORG_NAME", c_cons.RRIO_CODE as "RRIO_CODE", c_cons.CHK_CYCLE as "CHK_CYCLE", c_cons.LAST_CHK_DATE as "LAST_CHK_DATE", c_cons.CHEC
KER_NO as "CHECKER_NO", sa_user.REAL_NAME as "CHECKER_NAME", c_cons.POWEROFF_CODE as "POWEROFF_CODE", c_cons.TRANSFER_CODE as "TRANSFER_CODE", c_cons.MR_SECT_NO as "MR_SECT_NO", c_cons.NOTE_TYPE_CODE as "NOTE_TYPE_CODE", c_cons.TMP_FLAG as "TMP_FLAG", c_cons.TMP_DATE as "TMP_DATE", c_cons.MEAS_MODE as "MEAS_MODE", c_cons.DB_TIMESTAMP as "DB_TIMESTAMP", c_cons.VOLT_CODE as "VOLT_CODE", c_cons.CONS_SORT_CODE as "CONS_SORT_CODE", '' as "PAY_MODE", '' as "MADE_NO", '' as "BAR_CODE", '' as "TELE_NO", '' as "PAY_NO", '' as "BANK_ACCT", c_cons.CARD_NO as "CARD_NO" from c_cons, c_vat, sa_c_trade_type, sa_org, sa_user where ((c_cons.VAT_ID = c_vat.VAT_ID(+) and c_cons.TRADE_CODE = sa_c_trade_type.TRADE_CODE(+) and c_cons.ORG_NO = sa_org.ORG_NO(+) and c_cons.CHECKER_NO = sa_user.USER_ID(+)) and (c_cons.CUST_QUERY_NO=:1)) and (C_CONS.ORG_NO LIKE '21408%')) t where ROWNUM <= :2) where RN2 > :3 |
9zr4y5ar85c1h |
select /*+ FIRST_ROWS */ * from (select t.*, ROWNUM as RN2 from (select c_cons.CONS_ID as "CONS_ID", c_cons.VAT_ID as "VAT_ID", c_vat.VAT_NAME as "VAT_NAME", c_cons.CUST_ID as "CUST_ID", c_cons.CONS_NO as "CONS_NO", c_cons.CONS_NAME as "CONS_NAME", c_cons.CUST_QUERY_NO as "CUST_QUERY_NO", c_cons.TMP_PAY_RELA_NO as "TMP_PAY_RELA_NO", c_cons.ORGN_CONS_NO as "ORGN_CONS_NO", c_cons.ELEC_ADDR as "ELEC_ADDR", c_cons.TRADE_CODE as "TRADE_CODE", sa_c_trade_type.TRADE as "TRADE", c_cons.ELEC_TYPE_CODE as "ELEC_TYPE_CODE", c_cons.CONTRACT_CAP as "CONTRACT_CAP", c_cons.RUN_CAP as "RUN_CAP", c_cons.SHIFT_NO as "SHIFT_NO", c_cons.LODE_ATTR_CODE as "LODE_ATTR_CODE", c_cons.HEC_INDUSTRY_CODE as "HEC_INDUSTRY_CODE", c_cons.HOLIDAY as "HOLIDAY", c_cons.BUILD_DATE as "BUILD_DATE", c_cons.PS_DATE as "PS_DATE", c_cons.CANCEL_DATE as "CANCEL_DATE", c_cons.DUE_DATE as "DUE_DATE", c_cons.NOTIFY_MODE as "NOTIFY_MODE", c_cons.SETTLE_MODE as "SETTLE_MODE", c_cons.STATUS_CODE as "STATUS_CODE", c_cons.ORG_NO as "ORG_NO", sa_org.ORG_NAME as "ORG_NAME", c_cons.RRIO_CODE as "RRIO_CODE", c_cons.CHK_CYCLE as "CHK_CYCLE", c_cons.LAST_CHK_DATE as "LAST_CHK_DATE", c_cons.CHEC
KER_NO as "CHECKER_NO", sa_user.REAL_NAME as "CHECKER_NAME", c_cons.POWEROFF_CODE as "POWEROFF_CODE", c_cons.TRANSFER_CODE as "TRANSFER_CODE", c_cons.MR_SECT_NO as "MR_SECT_NO", c_cons.NOTE_TYPE_CODE as "NOTE_TYPE_CODE", c_cons.TMP_FLAG as "TMP_FLAG", c_cons.TMP_DATE as "TMP_DATE", c_cons.MEAS_MODE as "MEAS_MODE", c_cons.DB_TIMESTAMP as "DB_TIMESTAMP", c_cons.VOLT_CODE as "VOLT_CODE", c_cons.CONS_SORT_CODE as "CONS_SORT_CODE", '' as "PAY_MODE", '' as "MADE_NO", '' as "BAR_CODE", '' as "TELE_NO", '' as "PAY_NO", '' as "BANK_ACCT", c_cons.CARD_NO as "CARD_NO" from c_cons, c_vat, sa_c_trade_type, sa_org, sa_user where ((c_cons.VAT_ID = c_vat.VAT_ID(+) and c_cons.TRADE_CODE = sa_c_trade_type.TRADE_CODE(+) and c_cons.ORG_NO = sa_org.ORG_NO(+) and c_cons.CHECKER_NO = sa_user.USER_ID(+)) and (C_CONS.ORG_NO LIKE '21407%')) and (exists (select 1 from c_contact, c_cons_contact_rela where c_cons_contact_rela.cons_id = c_cons.cons_id and c_cons_contact_rela.contact_id = c_contact.contact_id and (c_contact.office_tel = :1 or c_contact.homephone = :2 or c_contact.mobile=:3)))) t where ROWNUM <= :4) where RN2 > :5
|
a5ndtux8xrfzc | update S_FAULT_HANDLE set RECEIVE_TIME = :1 where HANDLE_ID = :2 |
a6vvt01r5w66v | select systimestamp from dual |
amx6ngannq4wz |
select t3.DESIGN_SCHEME_ID, --?????cptmnl_design_scheme_list????????
t3.APP_NO,
t3.ASSET_ID,
t3.ASSET_TYPE_CODE,
t3.CHG_MODE,
t3.TERMINAL_TYPE_CODE,
t3.COLL_MODE,
t3.AID_NODE_CODE,
t3.QLF_FLAG,
t3.DISQLF_CONTENT,
t3.VERIFIER_NO,
t3.CHK_DATE,
t3.SCHEMA_SRC,
t2.CP_SCHEME_ID,
t2.NAME,
t2.CP_TYPE_CODE,
t2.STATUS_CODE,
t2.CP_ADDR,
t2.GPS_LONGITUDE,
t2.GPS_LATITUDE,
t2.APP_NO as "APP_NO1",
t2.CP_SCHEME_NO,
t2.ORG_NO,
t6.ORG_NAME,
(SELECT real_name FROM sa_user WHERE user_id = t2.user_no) REAL_NAME
from S_R_CP_SCHEME t2,
R_CP_DESIGN_SCHEME t3,
(select t1.cp_scheme_id, t1.app_no
from S_R_CP_MP_RELA_SCHEME t1
group by t1.cp_scheme_id, t1.app_no) t4, --?????????????????????????????
R_TMNL_INST_SCHEME t5,
SA_ORG t6
where t3.app_no = t2.app_no
and t2.app_no = t4.app_no
and t2.org_no = t3.org_no
and t2.org_no = t6.org_no
and t2.org_no like (:1 || '%')
and t2.cp_scheme_id = t4.cp_scheme_id
and t2.cp_scheme_id = t5.cp_scheme_id
and t3.design_scheme_id = t5.design_scheme_id
and t5.org_no like (:2 || '%')
and t2.status_code = '01' -- ????
and t2.chg_mode = '01' -- ??
and not exists (SELECT 1 FROM SA_WORKFORM F WHERE t2.APP_NO = F.KEYDATA_ID)
order by t2.org_no asc, t4.app_no desc
|
an4593dzvqr4v | select obj#, dataobj#, subpart#, hiboundlen, hiboundval, ts#, file#, block#, pctfree$, pctused$, initrans, maxtrans, flags, analyzetime, samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, length(bhiboundval), bhiboundval from tabsubpart$ where pobj# = :1 order by subpart# |
axajjyf55qb9p | SELECT id, ip, name, lastupdate FROM sys_group_server where name=:1 |
ayvx78m6p3fju |
SELECT *
FROM (SELECT LI.*,
CASE
WHEN LI.OVERDUED_NE = 1 OR LI.OVERDUED_NE = 3 THEN 1
WHEN LI.OVERDUED_NE = 0 OR LI.OVERDUED_NE = 2 THEN
CASE
WHEN E.SUSPEND_FLAG = 0 THEN
CASE
WHEN SYSTIMESTAMP >= E.TARGET_OVERDUE_MINTIME THEN 1
ELSE 0
END
WHEN E.SUSPEND_FLAG = 1 THEN
CASE
WHEN E.SUSPEND_TIME >= E.TARGET_OVERDUE_MINTIME THEN 1
ELSE 0
END
ELSE 0
END
ELSE 0
END OVERDUED,
CASE
WHEN E.TARGET_OVERDUE_MINTIME IS NULL THEN LI.TARGET_TIME_NE
WHEN LI.TARGET_TIME_NE IS NULL THEN E.TARGET_OVERDUE_MINTIME
WHEN E.TARGET_OVERDUE_MINTIME <= LI.TARGET_TIME_NE THEN E.TARGET_OVERDUE_MINTIME
ELSE LI.TARGET_TIME_NE
END TARGET_TIME,
FTM.WORKFORM_TYPE_KIND
FROM (SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/
WF.PROC_INSTANCE_ID,
WF.ACTIVITY_INS_ID,
WF.WORKITEM_INS_ID,
WF.NAME,
WF.CURRENT_
STATE,
WF.COMPLETE_TIME,
WF.CREATE_TIME,
WF.LIMIT_TIME,
WF.APP_URL,
WF.USER_NAME,
WF.USER_ID,
WF.USER_ENTITY_TYPE,
WF.USER_ENTITY_NAME,
WF.USER_ENTITY_ID,
WF.PARTICIPANT_TYPE,
WF.SEND_TYPE,
WF.OVERDUED AS OVERDUED_NE,
WF.EXT_PROP,
WF.FLOW_DIRECTION,
WF.BUSINESSKEY,
WF.DEPART_ID,
F.INSTANCE_ID AS WI_INSTANCE_ID,
F.INSTANCE_NAME AS WI_INSTANCE_NAME,
F.WORKFORM_TYPE AS WI_WORKFORM_TYPE,
F.BUILDER AS WI_BUILDER,
F.START_TIME AS WI_CREATE_TIME,
F.INSTANCE_STATUS AS WI_INSTANCE_STATUS,
F.BUSINESS AS WI_BUSINESS,
F.KEYDATA_ID AS WI_KEYDATA_ID,
F.IS_FLOW AS WI_IS_FLOW,
F.ATTR1 AS WI_ATTR1,
F.DEPT_ID AS WI_DEPT_ID,
'' AS WT_DEPT_ID,
WF.CURRENT_STATE AS WT_WORKTASK_STATUS,
NULL AS WT_TARGET_TIME,
'' AS WT_LINK_URL,
'' AS WT_LINK_PARAM,
'' AS WT_IS_BATCH,
U.REAL_NAME AS WI_BUILDER_REALNAME,
NULL AS HOWLONG_WILL_OVERDUE,
NULL AS HOWLONG_OVERDUED,
'' AS ACTIVITY_TMP_ID,
O.TIME_OUT_TIME AS TARGET_TIME_NE,
B.APPROVAL_STATUS AS BE_APPROVAL_STATUS,
ORG.ORG_NO,
ORG.ORG_NAME,
'' AS VIEW_FLAGS
FROM SA_WORKFORM_INST F,
(SELECT W.*
FROM RT_WORKITEMINST W
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = :1
AND W.PARTICIPANT_TYPE = 0
UNION ALL
SELECT W.*
FROM RT_WORKITEMINST W, SA_BROLE_USER R
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = R.ROLE_ID
AND R.USER_ID = :2
AND W.PARTICIPANT_TYPE = 1) WF,
SA_USER U,
(SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O,
SA_WF_BUSINESS_EXT B,
SA_DEPT D,
SA_ORG ORG
WHERE F.PROCINST_ID = WF.PROC_INSTANCE_ID
AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+)
AND F.BUILDER = U.USER_ID(+)
AND U.DEPT_ID = D.DEPT_ID(+)
AND D.
ORG_NO = ORG.ORG_NO(+)
AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+)
AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:3 LIKE (WF.DEPART_ID || '%')) OR (:4 = WF.DEPART_ID) OR (:5 = WF.DEPART_ID) OR (:6 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :7))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:8 LIKE (F.DEPT_ID || '%')) OR (:9 = F.DEPT_ID) OR (:10 = F.DEPT_ID) OR (:11 = F.DEPT_ID) OR (F.DEPT_ID LIKE :12))))))
UNION ALL
SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/
WF.PROC_INSTANCE_ID,
WF.ACTIVITY_INS_ID,
WF.WORKITEM_INS_ID,
WF.NAME,
WF.CURRENT_STATE,
WF.COMPLETE_TIME,
WF.CREATE_TIME,
WF.LIMIT_TIME,
WF.APP_URL,
WF.USER_NAME,
WF.USER_ID,
WF.USER_ENTITY_TYPE,
WF.USER_ENTITY_NAME,
WF.USER_ENTITY_ID,
WF.PARTICIPANT_TYPE,
WF.SEND_TYPE,
WF.OVERDUED AS OVERDUED_NE,
WF.EXT_PROP,
WF.FLOW_DIRECTION,
WF.BUSINESSKEY,
WF.DEPART_ID,
F.INSTANCE_ID AS WI_INSTANCE_ID,
F.INSTANCE_NAME AS WI_INSTANCE_NAME,
F.WORKFORM_TYPE AS WI_WORKFORM_TYPE,
F.BUILDER AS WI_BUILDER,
F.START_TIME AS WI_CREATE_TIME,
F.INSTANCE_STATUS AS WI_INSTANCE_STATUS,
F.BUSINESS AS WI_BUSINESS,
F.KEYDATA_ID AS WI_KEYDATA_ID,
F.IS_FLOW AS WI_IS_FLOW,
F.ATTR1 AS WI_ATTR1,
F.DEPT_ID AS WI_DEPT_ID,
'' AS WT_DEPT_ID,
WF.CURRENT_STATE AS WT_WORKTASK_STATUS,
NULL AS WT_TARGET_TIME,
'' AS WT_LINK_URL,
'' AS WT_LINK_PARAM,
'' AS WT_IS_BATCH,
U.REAL_NAME AS WI_BUILDER_REALNAME,
NULL AS HOWLONG_WILL_OVERDUE,
NULL AS HOWLONG_OVERDUED,
'' AS ACTIVITY_TMP_ID,
O.TIME_OUT_TIME AS TARGET_TIME_NE,
B.APPROVAL_STATUS AS BE_APPROVAL_STATUS,
ORG.ORG_NO,
ORG.ORG_NAME,
'' AS VIEW_FLAGS
FROM SA_WORKFORM_INST F,
(SELECT W.*
FROM RT_WORKITEMINST W
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = :13
AND W.PARTICIPANT_TYPE = 0
UNION ALL
SELECT W.*
FROM RT_WORKITEMINST W, SA_BROLE_USER R
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = R.ROLE_ID
AND R.USER_ID = :14
AND W.PARTICIPANT_TYPE = 1) WF,
SA_USER U,
RT_PROCESSINSTANCE P,
(SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O,
SA_WF_BUSINESS_EXT B,
SA_DEPT D,
SA_ORG ORG
WHERE WF.PROC_INSTANCE_ID = P.PROC_INSTANCE_ID
AND P.PARENT_PROCINC_ID IS NOT NULL
AND F.PROCINST_ID = P.PARENT_PROCINC_ID
AND F.BUILDER = U.USER_ID(+)
AND U.DEPT_ID = D.DEPT_ID(+)
AND D.ORG_NO = ORG.ORG_NO(+)
AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+)
AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+)
AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:15 LIKE (WF.DEPART_ID || '%')) OR (:16 = WF.DEPART_ID) OR (:17 = WF.DEPART_ID) OR (:18 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :19))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:20 LIKE (F.DEPT_ID || '%')) OR (:21 = F.DEPT_ID) OR (:22 = F.DEPT_ID) OR (:23 = F.DEPT_ID) OR (F.DEPT_ID LIKE :24))))))
AND NOT EXISTS
(SELECT 1
FROM SA_WORKFORM_INST RF
WHERE WF.PROC_INSTANCE_ID = RF.PROCINST_ID)) LI,
SA_WF_WORKFORM_TYPE_MAP FTM,
(SELECT ACT_INST_ID,
SUSPEND_FLAG,
MIN(TARGET_OVERDUE_MINTIME) AS TARGET_OVERDUE_MINTIME,
MIN(SUSPEND_TIME) AS SUSPEND_TIME
FROM (SELECT A.ACT_INST_ID, B.*
FROM SA_WF_EXAM_ACT_INST A, SA_WF_EXAM_INST B
WHERE A.SUBJECT_INST_ID = B.SUBJECT_INST_ID
AND A.PROC_INST_ID = B.PROC_INST_ID
AND B.COMPLETE_FLAG = 0)
GROUP BY ACT_INST_ID, SUSPEND_FLAG) E
WHERE LI.WI_WORKFORM_TYPE = FTM.WORKFORM_TYPE(+)
AND LI.ACTIVITY_INS_ID = E.ACT_INST_ID(+)) T
WHERE NOT EXISTS (SELECT 1
FROM SA_WF_WORKITEM_EXCLUDED_USER US
WHERE T.WORKITEM_INS_ID = US.WORKITEM_ID
AND US.USER_ID = :25) |
b365tkr3fcndn |
select /*+ FIRST_ROWS */ * from (select t.*, ROWNUM as RN2 from (select c_cons.CONS_ID as "CONS_ID", c_cons.VAT_ID as "VAT_ID", c_vat.VAT_NAME as "VAT_NAME", c_cons.CUST_ID as "CUST_ID", c_cons.CONS_NO as "CONS_NO", c_cons.CONS_NAME as "CONS_NAME", c_cons.CUST_QUERY_NO as "CUST_QUERY_NO", c_cons.TMP_PAY_RELA_NO as "TMP_PAY_RELA_NO", c_cons.ORGN_CONS_NO as "ORGN_CONS_NO", c_cons.ELEC_ADDR as "ELEC_ADDR", c_cons.TRADE_CODE as "TRADE_CODE", sa_c_trade_type.TRADE as "TRADE", c_cons.ELEC_TYPE_CODE as "ELEC_TYPE_CODE", c_cons.CONTRACT_CAP as "CONTRACT_CAP", c_cons.RUN_CAP as "RUN_CAP", c_cons.SHIFT_NO as "SHIFT_NO", c_cons.LODE_ATTR_CODE as "LODE_ATTR_CODE", c_cons.HEC_INDUSTRY_CODE as "HEC_INDUSTRY_CODE", c_cons.HOLIDAY as "HOLIDAY", c_cons.BUILD_DATE as "BUILD_DATE", c_cons.PS_DATE as "PS_DATE", c_cons.CANCEL_DATE as "CANCEL_DATE", c_cons.DUE_DATE as "DUE_DATE", c_cons.NOTIFY_MODE as "NOTIFY_MODE", c_cons.SETTLE_MODE as "SETTLE_MODE", c_cons.STATUS_CODE as "STATUS_CODE", c_cons.ORG_NO as "ORG_NO", sa_org.ORG_NAME as "ORG_NAME", c_cons.RRIO_CODE as "RRIO_CODE", c_cons.CHK_CYCLE as "CHK_CYCLE", c_cons.LAST_CHK_DATE as "LAST_CHK_DATE", c_cons.CHEC
KER_NO as "CHECKER_NO", sa_user.REAL_NAME as "CHECKER_NAME", c_cons.POWEROFF_CODE as "POWEROFF_CODE", c_cons.TRANSFER_CODE as "TRANSFER_CODE", c_cons.MR_SECT_NO as "MR_SECT_NO", c_cons.NOTE_TYPE_CODE as "NOTE_TYPE_CODE", c_cons.TMP_FLAG as "TMP_FLAG", c_cons.TMP_DATE as "TMP_DATE", c_cons.MEAS_MODE as "MEAS_MODE", c_cons.DB_TIMESTAMP as "DB_TIMESTAMP", c_cons.VOLT_CODE as "VOLT_CODE", c_cons.CONS_SORT_CODE as "CONS_SORT_CODE", '' as "PAY_MODE", '' as "MADE_NO", '' as "BAR_CODE", '' as "TELE_NO", '' as "PAY_NO", '' as "BANK_ACCT", c_cons.CARD_NO as "CARD_NO" from c_cons, c_vat, sa_c_trade_type, sa_org, sa_user where ((c_cons.VAT_ID = c_vat.VAT_ID(+) and c_cons.TRADE_CODE = sa_c_trade_type.TRADE_CODE(+) and c_cons.ORG_NO = sa_org.ORG_NO(+) and c_cons.CHECKER_NO = sa_user.USER_ID(+)) and (c_cons.CONS_NAME like :1 escape '/')) and (C_CONS.ORG_NO LIKE '21401%')) t where ROWNUM <= :2) where RN2 > :3 |
b3nramc90jfyj |
select (select org_name from sa_org where org_no = a.org_no) org_name,
a.ym,
a.cons_no,
a.cons_name,
a.mr_sect_no,
rs.name,
rp.mr_day,
(select real_name from sa_user where user_id = g.reader_no) real_name,
(select real_name from sa_user where user_id = ro.operator_no) hsy,
(select real_name from sa_user where user_id = t.emp_no) cfy,
(select dept_name from sa_dept where dept_id = d.dept_id) dept_name,
(select prop_list_name
from sa_prop_list
where prop_type_id = 'plan_status'
and prop_list_id = g.plan_status) prop_list_name,
ca.pay_no,
(select prop_list_name from sa_prop_list where prop_type_id = 'pay_mode' and prop_list_id = ca.pay_mode) pay_mode,
ca.main_cons_no,
e.prepay_bal,
sum(f.t_amt) amt,
sum(f.t_amt) -e.prepay_bal
from e_cons_snap a,
sa_user c,
sa_dept d,
a_acct_bal e,
e_cons_prc_amt f,
r_plan g,
c_acct ca,
c_payment_rela cp,
r_sect rs,
r_oper_activity ro,
r_plan_day rp,
(select a.cons_no, b.remind_sect_no, b.emp_no from a_cr_rela a, a_cr_sect b where a.remind_sect_no = b.remind_sect_no) t
where g.reader_no = c.user_id
and c.dept_id = d.dept_id
and a.volt_code not in ('AC02202', 'AC03802')
and a.cons_no = e.cons_no
and a.calc_id =
f.calc_id
and a.app_code = g.mr_plan_no
and f.elec_type_code <> '000'
and g.event_type = '001'
and g.plan_type_code in ('01', '03')
and g.plan_status in ('06', '07')
and a.cons_id = cp.cons_id
and cp.acct_id = ca.acct_id
and g.mr_sect_no = rs.mr_sect_no
and g.mr_sect_no = ro.mr_sect_no
and g.mr_sect_no = rp.mr_sect_no
and ro.act_code = '06'
and a.cons_no = t.cons_no(+)
and a.org_no like nvl(:1, '%') || '%'
and e.org_no like nvl(:2, '%') || '%'
and f.org_no like nvl(:3, '%') || '%'
and g.org_no like nvl(:4, '%') || '%'
and rs.org_no like nvl(:5, '%') || '%'
and a.ym = :6
and f.ym = :7
and g.amt_ym = :8
and a.mr_sect_no like nvl(null, '%')
and g.reader_no like nvl(:9, '%')
and d.dept_id like nvl(null, '%')
and a.cons_no like nvl(null, '%')
group by a.org_no,
a.ym,
a.cons_no,
a.cons_name,
a.mr_sect_no,
rs.name,
rp.mr_day,
g.reader_no,
ro.operator_no,
t.emp_no,
d.dept_id,
g.plan_status,
ca.pay_no,
ca.pay_mode,
ca.main_cons_no,
e.prepay_bal
union
select (select org_name from sa_org where org_no = a.org_no) org_name,
a.ym,
a.cons_no,
a.cons_name,
a.mr_sect_no,
rs.name,
rp.mr_day,
(select real_name from sa_user where user_id =
g.reader_no) real_name,
(select real_name from sa_user where user_id = ro.operator_no) hsy,
(select real_name from sa_user where user_id = t.emp_no) cfy,
(select dept_name from sa_dept where dept_id = d.dept_id) dept_name,
(select prop_list_name
from sa_prop_list
where prop_type_id = 'plan_status'
and prop_list_id = g.plan_status) prop_list_name,
ca.pay_no,
(select prop_list_name from sa_prop_list where prop_type_id = 'pay_mode' and prop_list_id = ca.pay_mode) pay_mode,
ca.main_cons_no,
e.prepay_bal,
sum(f.t_amt) amt,
sum(f.t_amt) -e.prepay_bal
from arc_e_cons_snap a,
sa_user c,
sa_dept d,
a_acct_bal e,
arc_e_cons_prc_amt f,
arc_r_plan g,
c_acct ca,
c_payment_rela cp,
r_sect rs,
r_oper_activity ro,
r_plan_day rp,
(select a.cons_no, b.remind_sect_no, b.emp_no from a_cr_rela a, a_cr_sect b where a.remind_sect_no = b.remind_sect_no) t
where g.reader_no = c.user_id
and c.dept_id = d.dept_id
and a.volt_code not in ('AC02202', 'AC03802')
and a.cons_no = e.cons_no
and a.calc_id = f.calc_id
and a.app_code = g.mr_plan_no
and f.elec_type_code <> '000'
and g.event_type = '001'
and g.plan_type_code in ('01', '03')
and g.plan_status in ('08')
and a.cons_id = cp.cons_id
and cp.acct
_id = ca.acct_id
and g.mr_sect_no = rs.mr_sect_no
and g.mr_sect_no = ro.mr_sect_no
and g.mr_sect_no = rp.mr_sect_no
and ro.act_code = '06'
and a.cons_no = t.cons_no(+)
and a.org_no like nvl(:10, '%') || '%'
and e.org_no like nvl(:11, '%') || '%'
and f.org_no like nvl(:12, '%') || '%'
and g.org_no like nvl(:13, '%') || '%'
and rs.org_no like nvl(:14, '%') || '%'
and a.ym = :15
and f.ym = :16
and g.amt_ym = :17
and a.mr_sect_no like nvl(null, '%')
and g.reader_no like nvl(:18, '%')
and d.dept_id like nvl(null, '%')
and a.cons_no like nvl(null, '%')
group by a.org_no,
a.ym,
a.cons_no,
a.cons_name,
a.mr_sect_no,
rs.name,
rp.mr_day,
g.reader_no,
ro.operator_no,
t.emp_no,
d.dept_id,
g.plan_status,
ca.pay_no,
ca.pay_mode,
ca.main_cons_no,
e.prepay_bal |
bd502nbh9abbs | select s.synonym_name object_name, o.object_type
from all_synonyms s,
sys.all_objects o
where s.owner in ('PUBLIC', :schema)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
|
bks1zny5ra55a |
SELECT *
FROM (SELECT LI.*,
CASE
WHEN LI.OVERDUED_NE = 1 OR LI.OVERDUED_NE = 3 THEN 1
WHEN LI.OVERDUED_NE = 0 OR LI.OVERDUED_NE = 2 THEN
CASE
WHEN E.SUSPEND_FLAG = 0 THEN
CASE
WHEN SYSTIMESTAMP >= E.TARGET_OVERDUE_MINTIME THEN 1
ELSE 0
END
WHEN E.SUSPEND_FLAG = 1 THEN
CASE
WHEN E.SUSPEND_TIME >= E.TARGET_OVERDUE_MINTIME THEN 1
ELSE 0
END
ELSE 0
END
ELSE 0
END OVERDUED,
CASE
WHEN E.TARGET_OVERDUE_MINTIME IS NULL THEN LI.TARGET_TIME_NE
WHEN LI.TARGET_TIME_NE IS NULL THEN E.TARGET_OVERDUE_MINTIME
WHEN E.TARGET_OVERDUE_MINTIME <= LI.TARGET_TIME_NE THEN E.TARGET_OVERDUE_MINTIME
ELSE LI.TARGET_TIME_NE
END TARGET_TIME,
FTM.WORKFORM_TYPE_KIND
FROM (SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/
WF.PROC_INSTANCE_ID,
WF.ACTIVITY_INS_ID,
WF.WORKITEM_INS_ID,
WF.NAME,
WF.CURRENT_
STATE,
WF.COMPLETE_TIME,
WF.CREATE_TIME,
WF.LIMIT_TIME,
WF.APP_URL,
WF.USER_NAME,
WF.USER_ID,
WF.USER_ENTITY_TYPE,
WF.USER_ENTITY_NAME,
WF.USER_ENTITY_ID,
WF.PARTICIPANT_TYPE,
WF.SEND_TYPE,
WF.OVERDUED AS OVERDUED_NE,
WF.EXT_PROP,
WF.FLOW_DIRECTION,
WF.BUSINESSKEY,
WF.DEPART_ID,
F.INSTANCE_ID AS WI_INSTANCE_ID,
F.INSTANCE_NAME AS WI_INSTANCE_NAME,
F.WORKFORM_TYPE AS WI_WORKFORM_TYPE,
F.BUILDER AS WI_BUILDER,
F.START_TIME AS WI_CREATE_TIME,
F.INSTANCE_STATUS AS WI_INSTANCE_STATUS,
F.BUSINESS AS WI_BUSINESS,
F.KEYDATA_ID AS WI_KEYDATA_ID,
F.IS_FLOW AS WI_IS_FLOW,
F.ATTR1 AS WI_ATTR1,
F.DEPT_ID AS WI_DEPT_ID,
'' AS WT_DEPT_ID,
WF.CURRENT_STATE AS WT_WORKTASK_STATUS,
NULL AS WT_TARGET_TIME,
'' AS WT_LINK_URL,
'' AS WT_LINK_PARAM,
'' AS WT_IS_BATCH,
U.REAL_NAME AS WI_BUILDER_REALNAME,
NULL AS HOWLONG_WILL_OVERDUE,
NULL AS HOWLONG_OVERDUED,
'' AS ACTIVITY_TMP_ID,
O.TIME_OUT_TIME AS TARGET_TIME_NE,
B.APPROVAL_STATUS AS BE_APPROVAL_STATUS,
ORG.ORG_NO,
ORG.ORG_NAME,
'' AS VIEW_FLAGS
FROM SA_WORKFORM_INST F,
(SELECT W.*
FROM RT_WORKITEMINST W
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = :1
AND W.PARTICIPANT_TYPE = 0
UNION ALL
SELECT W.*
FROM RT_WORKITEMINST W, SA_BROLE_USER R
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = R.ROLE_ID
AND R.USER_ID = :2
AND W.PARTICIPANT_TYPE = 1) WF,
SA_USER U,
(SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O,
SA_WF_BUSINESS_EXT B,
SA_DEPT D,
SA_ORG ORG
WHERE F.PROCINST_ID = WF.PROC_INSTANCE_ID
AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+)
AND F.BUILDER = U.USER_ID(+)
AND U.DEPT_ID = D.DEPT_ID(+)
AND D.
ORG_NO = ORG.ORG_NO(+)
AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+)
AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:3 LIKE (WF.DEPART_ID || '%')) OR (:4 = WF.DEPART_ID) OR (:5 = WF.DEPART_ID) OR (:6 = WF.DEPART_ID) OR (:7 = WF.DEPART_ID) OR (:8 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :9))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:10 LIKE (F.DEPT_ID || '%')) OR (:11 = F.DEPT_ID) OR (:12 = F.DEPT_ID) OR (:13 = F.DEPT_ID) OR (:14 = F.DEPT_ID) OR (:15 = F.DEPT_ID) OR (F.DEPT_ID LIKE :16))))))
UNION ALL
SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/
WF.PROC_INSTANCE_ID,
WF.ACTIVITY_INS_ID,
WF.WORKITEM_INS_ID,
WF.NAME,
WF.CURRENT_STATE,
WF.COMPLETE_TIME,
WF.CREATE_TIME,
WF.LIMIT_TIME,
WF.APP_URL,
WF.USER_NAME,
WF.USER_ID,
WF.USER_ENTITY_TYPE,
WF.USER_ENTITY_NAME,
WF.USER_ENTITY_ID,
WF.PARTICIPANT_TYPE,
WF.SEND_TYPE,
WF.OVERDUED AS OVERDUED_NE,
WF.EXT_PROP,
WF.FLOW_DIRECTION,
WF.BUSINESSKEY,
WF.DEPART_ID,
F.INSTANCE_ID AS WI_INSTANCE_ID,
F.INSTANCE_NAME
AS WI_INSTANCE_NAME,
F.WORKFORM_TYPE AS WI_WORKFORM_TYPE,
F.BUILDER AS WI_BUILDER,
F.START_TIME AS WI_CREATE_TIME,
F.INSTANCE_STATUS AS WI_INSTANCE_STATUS,
F.BUSINESS AS WI_BUSINESS,
F.KEYDATA_ID AS WI_KEYDATA_ID,
F.IS_FLOW AS WI_IS_FLOW,
F.ATTR1 AS WI_ATTR1,
F.DEPT_ID AS WI_DEPT_ID,
'' AS WT_DEPT_ID,
WF.CURRENT_STATE AS WT_WORKTASK_STATUS,
NULL AS WT_TARGET_TIME,
'' AS WT_LINK_URL,
'' AS WT_LINK_PARAM,
'' AS WT_IS_BATCH,
U.REAL_NAME AS WI_BUILDER_REALNAME,
NULL AS HOWLONG_WILL_OVERDUE,
NULL AS HOWLONG_OVERDUED,
'' AS ACTIVITY_TMP_ID,
O.TIME_OUT_TIME AS TARGET_TIME_NE,
B.APPROVAL_STATUS AS BE_APPROVAL_STATUS,
ORG.ORG_NO,
ORG.ORG_NAME,
'' AS VIEW_FLAGS
FROM SA_WORKFORM_INST F,
(SELECT W.*
FROM RT_WORKITEMINST W
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = :17
AND W.PARTICIPANT_TYPE = 0
UNION ALL
SELECT W.*
FROM RT_WORKITEMINST W, SA_BROLE_USER R
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = R.ROLE_ID
AND R.USER_ID = :18
AND W.PARTICIPANT_TYPE = 1) WF,
SA_USER U,
RT_PROCESSINSTANCE P,
(SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O,
SA_WF_BUSINESS_EXT B,
SA_DEPT D,
SA_ORG ORG
WHERE WF.PROC_INSTANCE_ID = P.PROC_INSTANCE_ID
AND P.PARENT_PROCINC_ID IS NOT NULL
AND F.PROCINST_ID = P.PARENT_PROCINC_ID
AND F.BUILDER = U.USER_ID(+)
AND U.DEPT_ID = D.DEPT_ID(+)
AND D.ORG_NO = ORG.ORG_NO(+)
AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+)
AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+)
AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:19 LIKE (WF.DEPART_ID || '%')) OR (:20 = WF.DEPART_ID) OR (:21 = WF.DEPART_ID) OR (:22 = WF.DEPART_ID) OR (:23 = WF.DEPART_ID) OR (:24 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :25))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:26 LIKE (F.DEPT_ID || '%')) OR (:27 = F.DEPT_ID) O
R (:28 = F.DEPT_ID) OR (:29 = F.DEPT_ID) OR (:30 = F.DEPT_ID) OR (:31 = F.DEPT_ID) OR (F.DEPT_ID LIKE :32))))))
AND NOT EXISTS
(SELECT 1
FROM SA_WORKFORM_INST RF
WHERE WF.PROC_INSTANCE_ID = RF.PROCINST_ID)) LI,
SA_WF_WORKFORM_TYPE_MAP FTM,
(SELECT ACT_INST_ID,
SUSPEND_FLAG,
MIN(TARGET_OVERDUE_MINTIME) AS TARGET_OVERDUE_MINTIME,
MIN(SUSPEND_TIME) AS SUSPEND_TIME
FROM (SELECT A.ACT_INST_ID, B.*
FROM SA_WF_EXAM_ACT_INST A, SA_WF_EXAM_INST B
WHERE A.SUBJECT_INST_ID = B.SUBJECT_INST_ID
AND A.PROC_INST_ID = B.PROC_INST_ID
AND B.COMPLETE_FLAG = 0)
GROUP BY ACT_INST_ID, SUSPEND_FLAG) E
WHERE LI.WI_WORKFORM_TYPE = FTM.WORKFORM_TYPE(+)
AND LI.ACTIVITY_INS_ID = E.ACT_INST_ID(+)) T
WHERE NOT EXISTS (SELECT 1
FROM SA_WF_WORKITEM_EXCLUDED_USER US
WHERE T.WORKITEM_INS_ID = US.WORKITEM_ID
AND US.USER_ID = :33) |
bn7dr3cnvpqgt | select count(1) from sa_msg_receive, sa_msg, sa_msg_handle where ((sa_msg.MSG_ID = sa_msg_receive.MSG_ID) and (sa_msg.MSG_TYPE = sa_msg_handle.TYPE_ID)) and (sa_msg_receive.RECEIVER_ID = :1 ) |
bqpnkpzk4bt2y |
declare
c integer := 0;
p1 varchar2(500);
p2 varchar2(500);
expr varchar2(500);
dblink varchar2(500);
part1_type integer;
object_number integer;
dp integer;
begin
:object_type := null;
:object_owner := null;
:object_name := null;
:sub_object := null;
expr := :part1;
if :part2 is not null then expr := expr || '.' || :part2; end if;
if :part3 is not null then expr := expr || '.' || :part3; end if;
loop
begin
sys.dbms_utility.name_resolve(name => expr,
context => c,
schema => :object_owner,
part1 => p1,
part2 => p2,
dblink => dblink,
part1_type => part1_type,
object_number => object_number);
if part1_type = 1 then :object_type := 'INDEX'; end if;
if part1_type = 2 then :object_type := 'TABLE'; end if;
if part1_type = 4 then :object_type := 'VIEW'; end if;
if part1_type = 5 then :object_type := 'SYNONYM'; end if;
if part1_type = 6 then :object_type := 'SEQUENCE'; end if;
if part1_type = 7 then :object_type := 'PROCEDURE'; end if;
if part1_type = 8 then :object_type := 'FUNCTION'; end if;
if part1_type = 9 then :object_type := 'PACKAGE'; end if;
if part1_type = 12 then :object_type := 'TRIGGER'; end if;
if part1_type = 13 then :object_type := 'TYPE'; end if;
if part1_type = 28 then :object_type := 'JAVA SOURCE'; end if;
if part1_type = 29 then :object_type := 'JAVA CLASS'; end if;
if :object_type is null then
select object_type into :object_type
from sys.all_objects
where object_id = object_number;
end if;
exception
when others then null;
end;
c := c + 1;
if c > 9 then
dp := instr(expr, '.', -1);
if dp > 0 then
if :sub_object is not null then
:sub_object := '.' || :sub_object;
end if;
:sub_object := upper(substr(expr, dp + 1)) || :sub_object;
expr := substr(expr, 1, dp - 1);
c := 0;
end if;
end if;
exit when (:object_type is not null) or (c > 9);
end loop;
if :object_type is not null then
if p1 is null then
:object_name := p2;
elsif p2 is null then
:object_name := p1;
if :object_name = :part1 and :part2 is not null then
:sub_object := :part2;
end if;
if :object_name = :part2 and :part3 is not null then
:sub_object := :part3;
end if;
else
:object_name := p1;
:sub_object := p2;
end if;
return;
end if;
begin
if :part2 is null and :part3 is null then
select 'USER', null, :part1
into :object_type, :object_owner, :object_name
from sys.all_users u
where u.username = :part1
and rown
um = 1;
return;
end if;
exception
when no_data_found then
null;
end;
begin
if :part2 is null and :part3 is null and :deep != 0 then
select 'ROLE', null, :part1
into :object_type, :object_owner, :object_name
from sys.session_roles r
where r.role = :part1
and rownum = 1;
return;
end if;
exception
when no_data_found then
null;
end;
if :deep != 0 then
begin
if :part2 is null then
select constraint_type, owner, constraint_name
into :object_type, :object_owner, :object_name
from sys.all_constraints c
where c.constraint_name = :part1
and c.owner = :cur_schema
and rownum = 1;
else
select constraint_type, owner, constraint_name, :part3
into :object_type, :object_owner, :object_name, :sub_object
from sys.all_constraints c
where c.constraint_name = :part2
and c.owner = :part1
and rownum = 1;
end if;
if :object_type = 'P' then
:object_type := 'PRIMARY KEY';
end if;
if :object_type = 'U' then
:object_type := 'UNIQUE KEY';
end if;
if :object_type = 'R' then
:object_type := 'FOREIGN KEY';
end if;
if :object_type = 'C' then
:object_type := 'CHECK CONSTRAINT';
end if;
return;
exception
when no_data_found then
null;
end;
end if;
end;
|
brbkc7dh24mxh |
SELECT (SELECT ORG_NAME FROM SA_ORG SO WHERE SO.ORG_NO = CC.ORG_NO) ????,
CC.CONS_NO ??,
CC.CONS_NAME ??,
CC.ELEC_ADDR ??,
CC.CONTRACT_CAP ??,
(SELECT PROP_LIST_NAME
FROM SA_PROP_LIST
WHERE PROP_LIST_ID = CC.VOLT_CODE
AND PROP_TYPE_ID = 'volt_code') ????,
(SELECT PROP_LIST_NAME
FROM SA_PROP_LIST
WHERE PROP_LIST_ID = CC.MEAS_MODE
AND PROP_TYPE_ID = 'meas_mode') ????,
BXX.BAR_CODE ??
FROM C_CONS CC,
C_PAYMENT_RELA CP,
C_ACCT CA,
C_MP CM,
(SELECT DISTINCT CM.CONS_ID, BAR_CODE
FROM C_MP CM, C_METER_MP_RELA CMM, C_METER CME
WHERE CM.MP_ID = CMM.MP_ID
AND CMM.CONS_MT_ID = CME.CONS_MT_ID
AND CM.ORG_NO LIKE :1|| '%') BXX
WHERE (LC_FLAG <> '1' AND CA.PAY_MODE <> '010102')
AND CC.CONS_ID = CP.CONS_ID
AND CP.ACCT_ID = CA.ACCT_ID
AND cc.contract_cap >= 100
AND CC.CONS_ID = CM.CONS_ID
AND cc.status_code <> '9'
AND CC.ELEC_TYPE_CODE <> '000'
AND CC.TMP_FLAG = '03'
AND CC.CONS_ID = BXX.CONS_ID(+)
AND CC.ORG_NO LIKE :2|| '%'
GROUP BY CC.ORG_NO, CC.CONS_NO ,
CC.CONS_NAME ,
CC.ELEC_ADDR ,
CC.CONTRACT_CAP ,
CC.VOLT_CODE,
CC.MEAS_MODE,
BXX.BAR_CODE
|
brwsw1y3vta04 | INSERT INTO "GGS" ."GGS_STICK" (PROPERTY, VALUE) VALUES ('lv_version', :B1 ) |
bydf32qgqdwdu | begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
|
c1599tjmzu1fc | /* OracleOEM */ BEGIN :message := dbms_server_alert.expand_message(:language, :message_id, :argument_1, :argument_2, :argument_3, :argument_4, :argument_5); END; |
c56sbwns406ym | select sa_query_template_sql.SQL_ID as "SQL_ID", sa_query_template_sql.TEMPLATE_ID as "TEMPLATE_ID", sa_query_source_sql.QUERY_ID as "QUERY_ID", sa_query_source_sql.SQL_NAME as "SQL_NAME", sa_query_source_sql.SQL_COMMAND as "SQL_COMMAND" from sa_query_template_sql, sa_query_source_sql where (sa_query_template_sql.SQL_ID=sa_query_source_sql.SQL_ID) and (sa_query_template_sql.TEMPLATE_ID=:1) |
cdqp8fjhzczy6 |
select /*+ FIRST_ROWS */ * from (select t.*, ROWNUM as RN2 from (select view_s_app_workform.WORKFORM_STATUS as "WORKFORM_STATUS", view_s_app_workform.APP_ID as "APP_ID", view_s_app_workform.APP_NO as "APP_NO", view_s_app_workform.APP_MODE as "APP_MODE", view_s_app_workform.HANDLE_DEPT_NO as "HANDLE_DEPT_NO", view_s_app_workform.HANDLE_TIME as "HANDLE_TIME", view_s_app_workform.CONS_NO as "CONS_NO", view_s_app_workform.CONS_NAME as "CONS_NAME", view_s_app_workform.CUST_QUERY_NO as "CUST_QUERY_NO", view_s_app_workform.TMP_PAY_RELA_NO as "TMP_PAY_RELA_NO", view_s_app_workform.ORGN_CONS_NO as "ORGN_CONS_NO", view_s_app_workform.CONS_SORT_CODE as "CONS_SORT_CODE", view_s_app_workform.ELEC_ADDR as "ELEC_ADDR", view_s_app_workform.TRADE_CODE as "TRADE_CODE", view_s_app_workform.ELEC_TYPE_CODE as "ELEC_TYPE_CODE", view_s_app_workform.SHIFT_NO as "SHIFT_NO", view_s_app_workform.LODE_ATTR_CODE as "LODE_ATTR_CODE", view_s_app_workform.VOLT_CODE as "VOLT_CODE", view_s_app_workform.HEC_INDUSTRY_CODE as "HEC_INDUSTRY_CODE", view_s_app_workform.HOLIDAY as "HOLIDAY", view_s_app_workform.NOTIFY_MODE as "NOTIFY_MODE", view_s_app_workform.SETTLE_MODE as "SETTLE_MODE", view_s_app_workform.ORG_NO as "ORG_NO", view_s_app_workform.TRANSFER_CODE as &
quot;TRANSFER_CODE", view_s_app_workform.MR_SECT_NO as "MR_SECT_NO", view_s_app_workform.NOTE_TYPE_CODE as "NOTE_TYPE_CODE", view_s_app_workform.TMP_FLAG as "TMP_FLAG", view_s_app_workform.TMP_DATE as "TMP_DATE", view_s_app_workform.APP_CONTRACT_CAP as "APP_CONTRACT_CAP", view_s_app_workform.ORGN_CONTRACT_CAP as "ORGN_CONTRACT_CAP", view_s_app_workform.CONTRACT_CAP as "CONTRACT_CAP", view_s_app_workform.APP_RUN_CAP as "APP_RUN_CAP", view_s_app_workform.ORGN_RUN_CAP as "ORGN_RUN_CAP", view_s_app_workform.RUN_CAP as "RUN_CAP", view_s_app_workform.BGN_DATE as "BGN_DATE", view_s_app_workform.END_DATE as "END_DATE", view_s_app_workform.REASON as "REASON", view_s_app_workform.SHIFT_IN_CAP as "SHIFT_IN_CAP", view_s_app_workform.SHIFT_OUT_CAP as "SHIFT_OUT_CAP", view_s_app_workform.PERMENANT_REDUCE_FLAG as "PERMENANT_REDUCE_FLAG", view_s_app_workform.CONTENT as "CONTENT", view_s_app_workform.ST_UPQ as "ST_UPQ", view_s_app_workform.LONGTERM_CAP as "LONGTERM_CAP", view_s_app_workform.POWER_USAGE as "POWER_USAGE", view_s_app_workform.DMD_DATE as "DMD_DATE", view_s_app_workform.APP_TYPE_CODE as "APP_TYPE_CODE", view_s_app_workform.HANDLE_FLAG as "HANDLE_FLAG", view_s_app_workform.REFUSE_REASON as "REFUSE_REASON", view_s_ap
p_workform.RELA_APP_CODE as "RELA_APP_CODE", view_s_app_workform.REMARK as "REMARK", view_s_app_workform.MEAS_MODE as "MEAS_MODE", view_s_app_workform.BUILD_DATE as "BUILD_DATE", view_s_app_workform.PS_DATE as "PS_DATE", view_s_app_workform.CANCEL_DATE as "CANCEL_DATE", view_s_app_workform.DUE_DATE as "DUE_DATE", view_s_app_workform.STATUS_CODE as "STATUS_CODE", view_s_app_workform.OPERATE_STATUS as "OPERATE_STATUS", view_s_app_workform.MRD_FACTOR_CODE as "MRD_FACTOR_CODE", view_s_app_workform.IS_FLOW as "IS_FLOW", view_s_app_workform.INSTANCE_STATUS as "INSTANCE_STATUS", view_s_app_workform.COMPLETE_TIME as "COMPLETE_TIME", sa_c_trade_type.TRADE as "TRADE", sa_org.ORG_NO as "ORG_NO1", sa_org.ORG_NAME as "ORG_NAME", view_s_app_workform.DEPT_ID as "DEPT_ID", view_s_app_workform.REAL_NAME as "REAL_NAME", view_s_app_workform.DEPT_NAME as "DEPT_NAME", sa_org.ORG_TREE as "ORG_TREE", '' as "WORKFLOW_NAME", '' as "HANDLE_DEPT_NAME" from view_s_app_workform, sa_c_trade_type, sa_org where ((((view_s_app_workform.TRADE_CODE = sa_c_trade_type.TRADE_CODE(+) and VIEW_S_APP_WORKFORM.org_no = sa_org.org_no(+)) and ((view_s_app_workform.APP_TYPE_CODE=:1 AND (view_s_app_workform.HANDLE_TIME>=:2 AND view_s_app_workform.HANDLE_TIME<=:3)))) and (VIEW_
S_APP_WORKFORM.APP_TYPE_CODE IN ('101', '102', '103', '104', '105', '106', '107', '108', '109', '110', '111', '112', '201', '202', '203', '204', '205', '206', '207', '208', '209', '210', '211', '212', '213', '214', '215', '216', '217', '218', '301', '302', '303', '304', '305', '306', '307', '311', '351', '357', '715', '716', '901', '902'))) and (SA_ORG.ORG_TREE LIKE :4)) and (VIEW_S_APP_WORKFORM.ORG_NO LIKE :5) order by VIEW_S_APP_WORKFORM.APP_NO DESC) t where ROWNUM <= :6) where RN2 > :7 |
cjk1ffy5kmm5s | select obj# from oid$ where user#=:1 and oid$=:2 |
cqv52axncuvzv | SELECT signature, nhash, sqlarea_hash, last_used, inuse_features, flags, modified, incarnation FROM sql$ WHERE signature = :1 |
d608ma7v76s0b |
select s_batch_cust_app.ID as "ID", s_batch_cust_app.APP_ID as "APP_ID", s_batch_cust_app.CONS_NO as "CONS_NO", s_batch_cust_app.CONS_NAME as "CONS_NAME", s_batch_cust_app.ELEC_ADDR as "ELEC_ADDR", s_batch_cust_app.ORG_NO as "ORG_NO", s_batch_cust_app.APP_NO as "APP_NO", s_batch_cust_app.CONS_ID as "CONS_ID", s_mp_scheme.MP_SCHEME_ID as "MP_SCHEME_ID", s_mp_scheme.MP_ID as "MP_ID", s_mp_scheme.MP_NO as "MP_NO", s_mp_scheme.MD_TYPE_CODE as "MD_TYPE_CODE", s_mp_scheme.ORG_NO as "ORG_NO1", s_mp_scheme.CONS_NO as "CONS_NO1", s_mp_scheme.APP_ID as "APP_ID1", s_mp_scheme.APP_NO as "APP_NO1", s_mp_meter_rela_schm.MMR_SCHEME_ID as "MMR_SCHEME_ID", s_mp_meter_rela_schm.MP_SCHEME_ID as "MP_SCHEME_ID1", s_mp_meter_rela_schm.METER_SCHEME_ID as "METER_SCHEME_ID", s_mp_meter_rela_schm.MP_ID as "MP_ID1", s_mp_meter_rela_schm.CONS_ID as "CONS_ID1", s_mp_meter_rela_schm.CONS_NO as "CONS_NO2", s_mp_meter_rela_schm.APP_ID as "APP_ID2", s_mp_meter_rela_schm.APP_NO as "APP_NO2", s_mp_meter_rela_schm.METER_ID as "METER_ID1", s_meter_scheme.METER_SCHEME_ID as "METER_SCHEME_ID1", s_meter_scheme.METER_ID as "METER_ID", s_meter_scheme.SORT_CODE as "SORT_CODE", s_meter_scheme.CHG_DESC as "CHG_DE
SC", s_meter_scheme.BAR_CODE as "BAR_CODE", s_meter_scheme.MADE_NO as "MADE_NO", s_meter_scheme.TYPE_CODE as "TYPE_CODE", s_meter_scheme.FAULT_TYPE_CODE as "FAULT_TYPE_CODE", s_meter_scheme.WIRING_MODE as "WIRING_MODE", s_meter_scheme.ACCURACY_CODE as "ACCURACY_CODE", s_meter_scheme.VOLT_CODE as "VOLT_CODE", s_meter_scheme.CURRENT_CODE as "CURRENT_CODE", s_meter_scheme.DEV_SORT_CODE as "DEV_SORT_CODE", s_meter_scheme.REF_METER_FLAG as "REF_METER_FLAG", s_meter_scheme.REF_METER_ID as "REF_METER_ID", s_meter_scheme.T_FACTOR as "T_FACTOR", s_meter_scheme.VALIDATE_CODE as "VALIDATE_CODE", s_meter_scheme.RESET_FLAG as "RESET_FLAG", s_meter_scheme.REMAIN_PQ as "REMAIN_PQ", s_meter_scheme.PRESET_PQ as "PRESET_PQ", s_meter_scheme.CONS_MT_ID as "CONS_MT_ID", s_meter_scheme.ASSET_NO as "ASSET_NO", s_meter_scheme.OPERATE_STATUS as "OPERATE_STATUS", s_meter_scheme.APP_ID as "APP_ID3", s_meter_scheme.APP_NO as "APP_NO3", s_meter_scheme.ORG_NO as "ORG_NO2", s_meter_scheme.COMM_NO as "COMM_NO", s_meter_scheme.COMM_MODE as "COMM_MODE", s_meter_scheme.DISP_MODE as "DISP_MODE", s_meter_scheme.METER_CLOSE_MODE as "METER_CLOSE_MODE", s_meter_scheme.RP_ACCURACY_CODE as "RP_ACCURACY_CODE", s_meter_sc
heme.ATTACHEQUIP_TYPE_CODE as "ATTACHEQUIP_TYPE_CODE", s_meter_scheme.PREPAY_FLAG as "PREPAY_FLAG", s_meter_scheme.HARMONIC_MEAS_FALG as "HARMONIC_MEAS_FALG", s_meter_scheme.CARRIER_WAVE as "CARRIER_WAVE", s_meter_scheme.CONGEAL_FLAG as "CONGEAL_FLAG", s_meter_scheme.METER_USAGE as "METER_USAGE", s_meter_scheme.CI as "CI", s_meter_scheme.VL_FLAG as "VL_FLAG", s_meter_scheme.CL_FLAG as "CL_FLAG", s_meter_scheme.ANTI_PHASE_FLAG as "ANTI_PHASE_FLAG", s_meter_scheme.SUPER_POWER_FLAG as "SUPER_POWER_FLAG", s_meter_scheme.LOAD_CURVE_FLAG as "LOAD_CURVE_FLAG", s_meter_scheme.INFRARED_FLAG as "INFRARED_FLAG", s_meter_scheme.COMM_PROT_CODE as "COMM_PROT_CODE", s_meter_scheme.INST_DATE as "INST_DATE", (select this_read from s_ir_read where read_type_code = '11' and meter_scheme_id(+) = s_meter_scheme.METER_SCHEME_ID) as "READ_ALL", (select this_read from s_ir_read where read_type_code = '12' and meter_scheme_id(+) = s_meter_scheme.METER_SCHEME_ID) as "READ_AIGUILLE", (select this_read from s_ir_read where read_type_code = '13' and meter_scheme_id(+) = s_meter_scheme.METER_SCHEME_ID) as "READ_APEX", (select this_read from s_ir_read where read_type_code = '14' and meter_scheme_id(+) = s_meter_scheme.METER_SCHEME_ID) as "READ_LOW", (select this_read from s_ir_read where read_type_cod
e = '15' and meter_scheme_id(+) = s_meter_scheme.METER_SCHEME_ID) as "READ_AVERAGE", (select mr_digit from s_ir_read where read_type_code = '11' and meter_scheme_id(+) = s_meter_scheme.METER_SCHEME_ID) as "MR_DIGIT", (select CONTAINER_ID from s_container_dev_scheme where CHG_DESC = '01' and MP_SCHEME_ID(+) = s_mp_scheme.MP_SCHEME_ID and EQUIP_ID(+) = s_meter_scheme.METER_ID) as "BOX_ID", (select ASSET_NO from s_container_dev_scheme where CHG_DESC = '01' and MP_SCHEME_ID(+) = s_mp_scheme.MP_SCHEME_ID and EQUIP_ID(+) = s_meter_scheme.METER_ID) as "BOX_NO", '' as "BREAK_BAR_CODE", '' as "BREAK_SWITH_ID", '' as "SWITCH_BAR_CODE", '' as "SWITCH_SWITH_ID", (SELECT SEAL_ID FROM D_SEAL_IR WHERE EQUIP_CATEG = '01' AND SEAL_LOC_FLAG = '06' AND EQUIP_ID = S_METER_SCHEME.METER_ID AND ROWNUM = 1) as "SEAL_ID1", (SELECT SEAL_ID FROM D_SEAL_IR WHERE EQUIP_CATEG = '01' AND SEAL_LOC_FLAG = '05' AND EQUIP_ID = S_METER_SCHEME.METER_ID AND ROWNUM = 1) as "SEAL_ID2", (SELECT SEAL_ID FROM D_SEAL_IR A, S_CONTAINER_DEV_SCHEME B WHERE A.EQUIP_CATEG = '05' AND A.SEAL_LOC_FLAG = '22' AND A.EQUIP_ID = B.CONTAINER_ID AND B.MP_SCHEME_ID = s_mp_scheme.MP_SCHEME_ID AND B.EQUIP_ID = S_METER_SCHEME.METER_ID AND ROWNUM = 1) as "SEAL_ID3", (SELECT BAR_CODE FROM D_SWITCH WHERE EQUIP_CATEG = '24' AND (STORE_LOC_ID IS NULL OR STORE_LOC_ID = '1') AND MP_NO = S_MP_SCHEME.MP_NO AND CONS
_ID = s_batch_cust_app.CONS_ID AND ROWNUM = 1) as "SWITCH_NO11", (SELECT BAR_CODE FROM D_SWITCH WHERE EQUIP_CATEG = '23' AND (STORE_LOC_ID IS NULL OR STORE_LOC_ID = '1') AND MP_NO = S_MP_SCHEME.MP_NO AND CONS_ID = s_batch_cust_app.CONS_ID AND ROWNUM = 1) as "SWITCH_NO21", (SELECT BAR_CODE FROM D_SWITCH WHERE EQUIP_CATEG = '23' AND STORE_LOC_ID = '2' AND MP_NO = S_MP_SCHEME.MP_NO AND CONS_ID = s_batch_cust_app.CONS_ID AND ROWNUM = 1) as "SWITCH_NO22" from s_batch_cust_app, s_mp_scheme, s_mp_meter_rela_schm, s_meter_scheme where (s_batch_cust_app.CONS_NO = s_mp_scheme.CONS_NO and s_batch_cust_app.CONS_ID = s_mp_scheme.CONS_ID and s_mp_scheme.MP_SCHEME_ID = s_mp_meter_rela_schm.MP_SCHEME_ID and s_mp_scheme.MP_ID = s_mp_meter_rela_schm.MP_ID and s_mp_meter_rela_schm.METER_SCHEME_ID = s_meter_scheme.METER_SCHEME_ID AND s_batch_cust_app.APP_NO = S_MP_SCHEME.APP_NO AND s_batch_cust_app.APP_NO = s_mp_meter_rela_schm.APP_NO) and (s_batch_cust_app.APP_NO = :1 AND s_meter_scheme.CHG_DESC = :2 ) |
d7g71sfvxmaq9 |
select
e_cons_prc_amt.PRC_AMT_ID as "PRC_AMT_ID",
e_cons_prc_amt.CALC_ID as "CALC_ID",
(SELECT CAT_PRC_ABBR FROM e_cat_prc WHERE PRC_CODE=e_cons_prc_amt.PRC_CODE AND PARA_VN=e_cons_prc_amt.PARA_VN AND ROWNUM=1) as "PRC_CODE_NAME", --????
e_cons_prc_amt.T_CAT_KWH_AMT as "T_CAT_KWH_AMT",
(SELECT BA_VALUE FROM arc_e_base_amt WHERE PRC_AMT_ID =e_cons_prc_amt.PRC_AMT_ID AND SORT_DET !='6' AND ROWNUM=1) as "BA_VALUE", --?????
(SELECT BASE_PRC FROM arc_e_base_amt WHERE PRC_AMT_ID =e_cons_prc_amt.PRC_AMT_ID AND SORT_DET !='6' AND ROWNUM=1) as "BASE_PRC",
e_cons_prc_amt.T_BAS_AMT as "T_BAS_AMT", --?????
e_cons_prc_amt.T_ADJ_AMT as "T_ADJ_AMT", --?????
e_cons_prc_amt.T_PL_AMT as "T_PL_AMT", --?????
e_cons_prc_amt.t_amt, --????
e_cons_prc_amt.T_SETTLE_PQ as "T_SETTLE_PQ", --????
((SELECT SUM(NVL(SETTLE_RPQ, 0)) FROM arc_e_mp_pq WHERE YM= e_cons_prc_amt.YM AND MP_ID=e_cons_prc_amt.MP_ID and org_no=e_cons_prc_amt.org_no)) as "ELEC_UNACTIVE", --????
e_cons_prc_amt.calc_type ,
e_cons_prc_amt.MP_NAME as "MP_NAME", --???
e_cons_prc_amt.Mp_Id as "MP_ID",
e_cons_prc_amt.YM as "YM",
e_cons_prc_amt.ORG_NO as "ORG_NO",
e_cons_prc_amt.ELEC_TYPE_CODE as "ELEC_TYPE_CODE",
e_cons_prc_amt.TRADE_TYPE_CODE as "TRADE_TYPE_CODE",
(select trade
from sa_c_trade_type where trade_code=e_cons_prc_amt.TRADE_TYPE_CODE and rownum=1) as "TRADE_NAME"
from arc_e_cons_prc_amt e_cons_prc_amt
where e_cons_prc_amt.YM=:1
and e_cons_prc_amt.CALC_ID IN (:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147, :148, :149, :150, :151)
and e_cons_prc_amt.ORG_NO like :152
order by e_cons_prc_amt.mp_id, e_cons_prc_amt.PRC_CODE |
d9dkp2jmgfvr3 | select sa_resource.RES_ID as "RES_ID", sa_resource.MODULE_NAME as "MODULE_NAME", sa_resource.RES_NAME as "RES_NAME", sa_resource.RES_TYPE as "RES_TYPE", sa_resource.PERMISSION_ID as "PERMISSION_ID", sa_resource.ATTR1 as "ATTR1", sa_resource.ATTR2 as "ATTR2", sa_resource.ATTR3 as "ATTR3", sa_resource.ATTR4 as "ATTR4", sa_resource.FOLDER_ID as "FOLDER_ID", sa_resource.HEIGHT as "HEIGHT", sa_resource.PANEL_TITLE as "PANEL_TITLE", sa_resource.B_PANEL as "B_PANEL", sa_resource.VALID_FLAG as "VALID_FLAG", sa_resource.START_TIME as "START_TIME", sa_resource.END_TIME as "END_TIME" from sa_resource where sa_resource.RES_TYPE = 'component' and sa_resource.ATTR1 = :1 and sa_resource.ATTR2 = :2 |
dmutsut44mc8s | select sa_dept.DEPT_ID as "DEPT_ID", sa_dept.DEPT_NAME as "DEPT_NAME", sa_dept.PARENT_DEPT_ID as "PARENT_DEPT_ID", sa_dept.IS_DELETE as "IS_DELETE", sa_dept.IS_DATA_DEPT as "IS_DATA_DEPT", sa_dept.DEPT_TREE as "DEPT_TREE", sa_dept.DEPT_TYPE as "DEPT_TYPE", sa_dept.DEPT_SHORTNAME as "DEPT_SHORTNAME", sa_dept.ORDER_ID as "ORDER_ID", sa_dept.ATTR1 as "ATTR1", sa_dept.ATTR2 as "ATTR2", sa_dept.ATTR3 as "ATTR3", sa_dept.ATTR4 as "ATTR4", sa_dept.IS_ORGNIZATION as "IS_ORGNIZATION", sa_dept.IS_BILL as "IS_BILL", sa_dept.IS_DIRECT as "IS_DIRECT", sa_dept.IS_ACCOUNT as "IS_ACCOUNT", sa_dept.DBPAR_NO as "DBPAR_NO", sa_dept.ORG_NO as "ORG_NO" from sa_dept where sa_dept.DEPT_ID = :1 |
dq1zmfvv6c944 | select sa_brole_user.ROLE_ID as "ROLE_ID", sa_brole_user.USER_ID as "USER_ID", sa_brole_user.START_DATE as "START_DATE", sa_brole_user.END_DATE as "END_DATE", sa_brole_user.VALID_FLAG as "VALID_FLAG", sa_brole_user.APPROVE_FLAG as "APPROVE_FLAG", sa_brole_user.APPROVE_RESULT as "APPROVE_RESULT", sa_brole_user.APPROVE_USER as "APPROVE_USER", sa_brole_user.APPROVE_TIME as "APPROVE_TIME" from sa_brole_user where sa_brole_user.USER_ID = :1 AND sa_brole_user.ROLE_ID in ('h0036', 'agentRole') |
dr1a2v7ua3c5f |
select c_cons.CONS_ID as "CONS_ID", c_cons.VAT_ID as "VAT_ID", c_cons.CUST_ID as "CUST_ID", c_cons.CONS_NO as "CONS_NO", c_cons.CONS_NAME as "CONS_NAME", c_cons.CUST_QUERY_NO as "CUST_QUERY_NO", c_cons.TMP_PAY_RELA_NO as "TMP_PAY_RELA_NO", c_cons.ORGN_CONS_NO as "ORGN_CONS_NO", c_cons.CONS_SORT_CODE as "CONS_SORT_CODE", c_cons.ELEC_ADDR as "ELEC_ADDR", c_cons.TRADE_CODE as "TRADE_CODE", c_cons.ELEC_TYPE_CODE as "ELEC_TYPE_CODE", c_cons.CONTRACT_CAP as "CONTRACT_CAP", c_cons.RUN_CAP as "RUN_CAP", c_cons.SHIFT_NO as "SHIFT_NO", c_cons.LODE_ATTR_CODE as "LODE_ATTR_CODE", c_cons.VOLT_CODE as "VOLT_CODE", c_cons.HEC_INDUSTRY_CODE as "HEC_INDUSTRY_CODE", c_cons.HOLIDAY as "HOLIDAY", c_cons.BUILD_DATE as "BUILD_DATE", c_cons.PS_DATE as "PS_DATE", c_cons.CANCEL_DATE as "CANCEL_DATE", c_cons.DUE_DATE as "DUE_DATE", c_cons.NOTIFY_MODE as "NOTIFY_MODE", c_cons.SETTLE_MODE as "SETTLE_MODE", c_cons.STATUS_CODE as "STATUS_CODE", c_cons.ORG_NO as "ORG_NO", c_cons.RRIO_CODE as "RRIO_CODE", c_cons.CHK_CYCLE as "CHK_CYCLE", c_cons.LAST_CHK_DATE as "LAST_CHK_DATE", c_cons.CHECKER_NO as "CHECKER_NO", c_cons.POWEROFF_CODE as "POWEROFF_CODE", c_cons.TR
ANSFER_CODE as "TRANSFER_CODE", c_cons.MR_SECT_NO as "MR_SECT_NO", c_cons.NOTE_TYPE_CODE as "NOTE_TYPE_CODE", c_cons.TMP_FLAG as "TMP_FLAG", c_cons.TMP_DATE as "TMP_DATE", c_cons.MEAS_MODE as "MEAS_MODE", c_cons.DB_TIMESTAMP as "DB_TIMESTAMP", sa_org.ORG_NAME as "ORG_NAME", '' as "EMP_NAME", '' as "READER_NAME", 0 as "PREPAY_BAL", 0 as "ZQF", 0 as "ZQWYJ", 0 as "ZQDF" from c_cons, sa_org where (c_cons.ORG_NO = sa_org.ORG_NO) and (c_cons.CONS_NO= :1) |
dthz002fr92hr | SELECT DISTINCT C_CONS.CONS_NO CONS_NO, C_CONS.CONS_NAME CONS_NAME
FROM C_CONS
WHERE C_CONS.ORG_NO LIKE :1
AND EXISTS (SELECT 1
FROM C_MP
WHERE C_CONS.CONS_ID = C_MP.CONS_ID
AND C_MP.TYPE_CODE = '02'
AND C_MP.ORG_NO LIKE :2) |
dvu6vsjgatms1 | SELECT COUNT(1) C
FROM C_MP T, C_CONS C
WHERE T.ORG_NO LIKE :1 AND C.ORG_NO LIKE :2 AND T.CONS_NO = C.CONS_NO AND C.STATUS_CODE <> '9' AND EXISTS (SELECT 1 FROM R_OPER_ACTIVITY WHERE R_OPER_ACTIVITY.MR_SECT_NO = T.MR_SECT_NO AND R_OPER_ACTIVITY.ACT_CODE = '03'AND R_OPER_ACTIVITY.OPERATOR_NO = :3) |
dvwwqxvp2vkus |
SELECT *
FROM (SELECT THIS_READ,
READ_TYPE_CODE,
AMT_YM,
T_FACTOR,
BAR_CODE,
CASE READ_TYPE_CODE
WHEN '11' THEN
'1'
WHEN '15' THEN
'2'
ELSE
'3'
END RD_ORDER,
THIS_YMD,
CALC_ID
FROM ARC_R_DATA
WHERE CONS_NO = :1
AND CALC_ID IN (:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147, :148, :149, :150, :151, :152, :153, :154, :155, :156, :157, :158, :159, :160, :161, :162, :163,
:164, :165, :166, :167, :168, :169, :170, :171, :172, :173, :174, :175, :176, :177, :178, :179, :180, :181, :182, :183, :184, :185, :186, :187, :188, :189, :190, :191, :192, :193, :194, :195, :196, :197, :198, :199, :200, :201, :202, :203, :204, :205, :206, :207, :208, :209, :210, :211, :212, :213, :214, :215, :216, :217, :218, :219, :220, :221, :222, :223, :224, :225, :226, :227, :228, :229, :230, :231, :232, :233, :234, :235, :236, :237, :238, :239, :240, :241, :242, :243, :244, :245, :246, :247, :248, :249, :250, :251, :252, :253, :254, :255, :256, :257, :258, :259, :260, :261, :262, :263, :264, :265, :266, :267, :268, :269, :270, :271, :272, :273, :274, :275, :276, :277, :278, :279, :280, :281, :282, :283, :284, :285, :286, :287, :288, :289, :290, :291, :292, :293, :294, :295, :296, :297, :298, :299, :300, :301, :302, :303, :304, :305, :306, :307, :308, :309, :310, :311, :312, :313, :314, :315, :316, :317, :318, :319, :320, :321, :322, :323, :324, :325, :326, :327, :328, :329, :330, :331, :332, :333, :334, :335, :336, :337, :338, :339, :340, :341, :342, :343, :344, :345, :346, :347, :348, :349, :350, :351, :352, :353, :354, :355, :356, :357, :358, :359, :360, :361, :362, :363, :364, :365, :366, :367, :368, :369, :370, :371, :372, :373, :374, :375, :376, :377, :378, :379, :380, :381, :382, :383, :384, :385, :386, :387, :388, :389, :390, :391, :392, :393, :394, :395, :396, :397, :398, :399, :400, :401, :402, :403, :404, :405, :406, :407, :408, :409, :410, :411, :412, :413,
:414, :415, :416, :417, :418, :419, :420, :421, :422, :423, :424, :425, :426, :427, :428, :429, :430, :431, :432, :433, :434, :435, :436, :437, :438, :439, :440, :441, :442, :443, :444, :445, :446, :447, :448, :449, :450, :451, :452, :453, :454, :455, :456, :457, :458, :459, :460, :461, :462, :463, :464, :465, :466, :467, :468, :469, :470, :471, :472, :473, :474, :475, :476, :477, :478, :479, :480, :481, :482, :483, :484, :485, :486, :487, :488, :489, :490, :491, :492, :493, :494, :495, :496, :497, :498, :499, :500, :501, :502, :503, :504, :505, :506, :507, :508, :509, :510, :511, :512, :513, :514, :515, :516, :517, :518, :519, :520, :521, :522, :523, :524, :525, :526, :527, :528, :529, :530, :531, :532, :533, :534, :535, :536, :537, :538, :539, :540, :541, :542, :543, :544, :545, :546, :547, :548, :549, :550, :551, :552, :553, :554, :555, :556, :557, :558, :559, :560, :561, :562, :563, :564, :565, :566, :567, :568, :569, :570, :571, :572, :573, :574, :575, :576, :577, :578, :579, :580, :581, :582, :583, :584, :585, :586, :587, :588, :589, :590, :591, :592, :593, :594, :595, :596, :597, :598, :599, :600, :601, :602, :603, :604, :605, :606, :607, :608, :609, :610, :611, :612, :613, :614, :615, :616, :617, :618, :619, :620, :621, :622, :623, :624, :625, :626, :627, :628, :629, :630, :631, :632, :633, :634, :635, :636, :637, :638, :639, :640, :641, :642, :643, :644, :645, :646, :647, :648, :649, :650, :651, :652, :653, :654, :655, :656, :657, :658, :659, :660, :661, :662, :663,
:664, :665, :666, :667, :668, :669, :670, :671, :672, :673, :674, :675, :676, :677, :678, :679, :680, :681, :682, :683, :684, :685, :686, :687, :688, :689, :690, :691, :692, :693, :694, :695, :696, :697, :698, :699, :700, :701, :702, :703, :704, :705, :706, :707, :708, :709, :710, :711, :712, :713, :714, :715, :716, :717, :718, :719, :720, :721, :722, :723, :724, :725, :726, :727, :728, :729, :730, :731, :732, :733, :734, :735, :736, :737, :738, :739, :740, :741, :742, :743, :744, :745, :746, :747, :748, :749, :750, :751, :752, :753, :754, :755, :756, :757, :758, :759, :760, :761, :762, :763, :764, :765, :766, :767, :768, :769, :770, :771, :772, :773, :774, :775, :776, :777, :778, :779, :780, :781, :782, :783, :784, :785, :786, :787, :788, :789, :790, :791, :792, :793, :794, :795, :796, :797, :798, :799, :800, :801, :802, :803, :804, :805, :806, :807, :808, :809, :810, :811, :812, :813, :814, :815, :816, :817, :818, :819, :820, :821, :822, :823, :824, :825, :826, :827, :828, :829, :830, :831, :832, :833, :834, :835, :836, :837, :838, :839, :840, :841, :842, :843, :844, :845, :846, :847, :848, :849, :850, :851, :852, :853, :854, :855, :856, :857, :858, :859, :860, :861, :862, :863, :864, :865, :866, :867, :868, :869, :870, :871, :872, :873, :874, :875, :876, :877, :878, :879, :880, :881, :882, :883, :884, :885, :886, :887, :888, :889, :890, :891, :892, :893, :894, :895, :896, :897, :898, :899, :900, :901, :902, :903, :904, :905, :906, :907, :908, :909, :910, :911, :912, :913,
:914, :915, :916, :917, :918, :919, :920, :921, :922, :923, :924, :925, :926, :927, :928, :929, :930, :931, :932, :933, :934, :935, :936, :937, :938, :939, :940, :941, :942, :943, :944, :945, :946, :947, :948, :949, :950, :951, :952, :953, :954, :955, :956, :957, :958, :959, :960, :961, :962, :963, :964, :965, :966, :967, :968, :969, :970, :971, :972, :973, :974, :975, :976, :977, :978, :979, :980, :981, :982, :983, :984, :985, :986, :987, :988, :989, :990, :991, :992, :993, :994, :995, :996, :997, :998, :999, :1000, :1001)
AND ORG_NO LIKE :1002
AND AMT_YM = :1003
AND THIS_READ <> 0
)
ORDER BY AMT_YM DESC, THIS_YMD DESC, CALC_ID DESC, RD_ORDER ASC |
f25r7hqghsjvd | SELECT agent_id, origin_user, agent_user, start_time, end_time, origin_type, origin_name, agent_type, agent_name, type, proc_tmp_id, proc_tmp_name, category_id, category_name, creater_id, creater_name FROM sys_agent WHERE origin_type=1 AND origin_user='JL_JLD_0113' AND (start_time<:1 AND end_time>:2) ORDER BY agent_type DESC |
fdzqjmpvd6hvy | SELECT O.DATAOBJ# FROM SYS.OBJ$ O WHERE O.OBJ# = :B1 |
ffzkazv9wqy5c |
select max(a.CONS_NO) CONS_NO, min(a.SETTLE_FLAG) SETTLE_FLAG, MAX(a.RCVBL_YM) RCVBL_YM, max(a.ORG_NO) ORG_NO, max(calc_id) CALC_ID, max(rcvbl_amt_id) RCVBL_AMT_ID from a_rcvbl_flow a where CALC_ID in( select c.CALC_ID FROM a_rcvbl_flow c, a_rcved_flow b where b.charge_id in(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147, :148, :149, :150, :151, :152, :153, :154, :155, :156, :157, :158, :159, :160, :161, :162, :163, :164, :165, :166, :167, :168, :169, :170, :171, :172, :173, :174, :175, :176, :177, :178, :179, :180, :181, :182, :183, :184, :185, :186, :187, :188, :189, :190, :191, :192, :193, :194, :195, :196, :197, :198, :199, :200, :201, :202, :203, :204, :205, :206, :207, :208, :209, :210, :211, :212, :213, :214, :215, :216, :217, :218, :219, :220, :221,
:222, :223, :224, :225, :226, :227, :228, :229, :230, :231, :232, :233, :234, :235, :236, :237, :238, :239, :240, :241, :242, :243, :244, :245, :246, :247, :248, :249, :250, :251, :252, :253, :254, :255, :256, :257, :258, :259, :260, :261, :262, :263, :264, :265, :266, :267, :268, :269, :270, :271, :272, :273, :274, :275, :276, :277, :278, :279, :280, :281, :282, :283, :284, :285, :286, :287, :288, :289, :290, :291, :292, :293, :294, :295, :296, :297, :298, :299, :300, :301, :302, :303, :304, :305, :306, :307, :308, :309, :310, :311, :312, :313, :314, :315, :316, :317, :318, :319, :320, :321, :322, :323, :324, :325, :326, :327, :328, :329, :330, :331, :332, :333, :334, :335, :336, :337, :338, :339, :340, :341, :342, :343, :344, :345, :346, :347, :348, :349, :350, :351, :352, :353, :354, :355, :356, :357, :358, :359, :360, :361, :362, :363, :364, :365, :366, :367, :368, :369, :370, :371, :372, :373, :374, :375, :376, :377, :378, :379, :380, :381, :382, :383, :384, :385, :386, :387, :388, :389, :390, :391, :392, :393, :394, :395, :396, :397, :398, :399, :400, :401, :402, :403, :404, :405, :406, :407, :408, :409, :410, :411, :412, :413, :414, :415, :416, :417, :418, :419, :420, :421, :422, :423, :424, :425, :426, :427, :428, :429, :430, :431, :432, :433, :434, :435, :436, :437, :438, :439, :440, :441, :442, :443, :444, :445, :446, :447, :448, :449, :450, :451, :452, :453, :454, :455, :456, :457, :458, :459, :460, :461, :462, :463, :464, :465, :466, :467, :468, :469, :470, :471,
:472, :473, :474, :475, :476, :477, :478, :479, :480, :481, :482, :483, :484, :485, :486, :487, :488, :489, :490, :491, :492, :493, :494, :495, :496, :497, :498, :499, :500, :501, :502, :503, :504, :505, :506, :507, :508, :509, :510, :511, :512, :513, :514, :515, :516, :517, :518, :519, :520, :521, :522, :523, :524, :525, :526, :527, :528, :529, :530, :531, :532, :533, :534, :535, :536, :537, :538, :539, :540, :541, :542, :543, :544, :545, :546, :547, :548, :549, :550, :551, :552, :553, :554, :555, :556, :557, :558, :559, :560, :561, :562, :563, :564, :565, :566, :567, :568, :569, :570, :571, :572, :573, :574, :575, :576, :577, :578, :579, :580, :581, :582, :583, :584, :585, :586, :587, :588, :589, :590, :591, :592, :593, :594, :595, :596, :597, :598, :599, :600, :601, :602, :603, :604, :605, :606, :607, :608, :609, :610, :611, :612, :613, :614, :615, :616, :617, :618, :619, :620, :621, :622, :623, :624, :625, :626, :627, :628, :629, :630, :631, :632, :633, :634, :635, :636, :637, :638, :639, :640, :641, :642, :643, :644, :645, :646, :647, :648, :649, :650, :651, :652, :653, :654, :655, :656, :657, :658, :659, :660, :661, :662, :663, :664, :665, :666, :667, :668, :669, :670, :671, :672, :673, :674, :675, :676, :677, :678, :679, :680, :681, :682, :683, :684, :685, :686, :687, :688, :689, :690, :691, :692, :693, :694, :695, :696, :697, :698, :699, :700, :701, :702, :703, :704, :705, :706, :707, :708, :709, :710, :711, :712, :713, :714, :715, :716, :717, :718, :719, :720, :721,
:722, :723, :724, :725, :726, :727, :728, :729, :730, :731, :732, :733, :734, :735, :736, :737, :738, :739, :740, :741, :742, :743, :744, :745, :746, :747, :748, :749, :750, :751, :752, :753, :754, :755, :756, :757, :758, :759, :760, :761, :762, :763, :764, :765, :766, :767, :768, :769, :770, :771, :772, :773, :774, :775, :776, :777, :778, :779, :780, :781, :782, :783, :784, :785, :786, :787, :788, :789, :790, :791, :792, :793, :794, :795, :796, :797, :798, :799, :800, :801, :802, :803, :804, :805, :806, :807, :808, :809, :810, :811, :812, :813, :814, :815, :816, :817, :818, :819, :820, :821, :822, :823, :824, :825, :826, :827, :828, :829, :830, :831, :832, :833, :834, :835, :836, :837, :838, :839, :840, :841, :842, :843, :844, :845, :846, :847, :848, :849, :850, :851, :852, :853, :854, :855, :856, :857, :858, :859, :860, :861, :862, :863, :864, :865, :866, :867, :868, :869, :870, :871, :872, :873, :874, :875, :876, :877, :878, :879, :880, :881, :882, :883, :884, :885, :886, :887, :888, :889, :890, :891, :892, :893, :894, :895, :896, :897, :898, :899, :900, :901, :902, :903, :904, :905, :906, :907, :908, :909, :910, :911, :912, :913, :914, :915, :916, :917, :918, :919, :920, :921, :922, :923, :924, :925, :926, :927, :928, :929, :930, :931, :932, :933, :934, :935, :936, :937, :938, :939, :940, :941, :942, :943, :944, :945, :946, :947, :948, :949, :950, :951, :952, :953, :954, :955, :956, :957, :958, :959, :960, :961, :962, :963, :964, :965, :966, :967, :968, :969, :970, :971,
:972, :973, :974, :975, :976, :977, :978, :979, :980, :981, :982, :983, :984, :985, :986, :987, :988, :989, :990, :991, :992, :993, :994, :995, :996, :997, :998, :999, :1000) and b.rcvbl_amt_id = c.rcvbl_amt_id and b.org_no like :1001 and C.org_no like :1002) AND A.ORG_NO LIKE :1003 group by a.calc_id |
fj6xq84pwdw2z |
SELECT w.proc_instance_id,
w.activity_ins_id,
w.workitem_ins_id,
w.parent_workitem,
w.NAME,
to_char(w.current_state) as current_state,
w.complete_time,
w.create_time,
w.limit_time,
w.app_name,
w.app_type,
w.app_url,
w.CATEGORY,
w.send_type,
w.user_name,
w.user_id,
w.TYPE,
w.if_create_workitem,
w.msg_app_type,
w.user_entity_type,
w.user_entity_name,
w.user_entity_id,
w.r_data_id,
w.participant_type,
w.overdued,
w.ifhandling,
w.priority,
w.need_part_role,
w.description,
w.ext_prop,
w.flow_direction,
w.origin_id,
w.origin_name,
w.origin_type,
w.is_substituted,
w.actor_id,
w.actor_name,
w.actor_type,
w.businesskey,
w.depart_id,
'' AS wt_area,
'' AS wt_dept_id,
to_char(w.current_state) AS wt_worktask_status,
NULL AS target_time,
'' AS wt_link_url,
'' AS wt_link_param,
'' AS wt_is_batch,
'' AS wt_attr1,
'' AS wt_attr2,
'' AS wt_attr3,
'' AS wt_attr4,
'' AS wt_attr5,
d.dept_name AS dept_name,
u.real_name as real_name,
w.workform_type as wi_workform_type,
w.instance_id as wi_instance_id,
w.keydata_id as wi_keydata_id
FROM (select rw.*, f.workform_type,
f.instance_id, f.keydata_id
from rt_workiteminst rw,
(select f.procinst_id, f.workform_type, f.instance_id, f.keydata_id
from sa_workform_inst f
where f.instance_id in (:1, :2)
union all
select fh.procinst_id, fh.workform_type, fh.instance_id, fh.keydata_id
from sa_workform_inst_history fh
where fh.instance_id in (:3, :4)) f
where rw.proc_instance_id = f.procinst_id
union all
select rwh.*, f.workform_type, f.instance_id, f.keydata_id
from log_workiteminst rwh,
(select f.procinst_id, f.workform_type, f.instance_id, f.keydata_id
from sa_workform_inst f
where f.instance_id in (:5, :6)
union all
select fh.procinst_id, fh.workform_type, fh.instance_id, fh.keydata_id
from sa_workform_inst_history fh
where fh.instance_id in (:7, :8)) f
where rwh.proc_instance_id = f.procinst_id) w,
sa_user u,
sa_dept d
WHERE w.user_id = u.user_id(+)
and u.dept_id = d.dept_id(+)
UNION ALL
SELECT w.proc_instance_id,
w.activity_ins_id,
w.workitem_ins_id,
w.parent_workitem,
w.NAME,
to_char(w.current_state) as current_state,
w.complete_time,
w.create_time,
w.limit_time,
w.app_name,
w.app_type,
w.app_url,
w.CATEGORY,
w.send_type,
w.user_name,
w.user_id,
w.TYPE,
w.if_create_workitem,
w.msg_app_type,
w.user_entity_type,
w.user_entity_name,
w.user_entity_id,
w.r_data_id,
w.participant_type,
w.overdued,
w.ifhandling,
w.priority,
w.need_part_role,
w.description,
w.ext_prop,
w.flow_direction,
w.origin_id,
w.origin_name,
w.origin_type,
w.is_substituted,
w.actor_id,
w.actor_name,
w.actor_type,
w.businesskey,
w.depart_id,
'' AS wt_area,
'' AS wt_dept_id,
to_char(w.current_state) AS wt_worktask_status,
NULL AS target_time,
'' AS wt_link_url,
'' AS wt_link_param,
'' AS wt_is_batch,
'' AS wt_attr1,
'' AS wt_attr2,
'' AS wt_attr3,
'' AS wt_attr4,
'' AS wt_attr5,
d.dept_name AS dept_name,
u.real_name as real_name,
w.workform_type as wi_workform_type,
w.instance_id as wi_instance_id,
w.keydata_id as wi_keydata_id
FROM (select rw2.*, f2.workform_type, f2.instance_id, f2.keydata_id
from rt_workiteminst rw2,
rt_processinstance p2,
(select f.procinst_id, f.workform_type, f.instance_id, f.keydata_id
from sa_workform_inst f
where f.instance_id in (:9, :10)
union all
select fh.procinst_id, fh.workform_type, fh.instance_id, fh.keydata_id
from sa_workform_inst_history fh
where fh.instance_id in (:11, :12)) f2
where rw2.proc_instance_id = p2.proc_instance_id
and p2.parent_procinc_id = f2.procinst_id
union all
select rwh2.*, f2.workform_type, f2.instance_id, f2.keydata_id
from log_workiteminst rwh2,
log_procinst ph2,
(select f.procinst_id, f.workform_type, f.instance_id, f.keydata_id
from sa_workform_inst f
where f.instance_id in (:13, :14)
union all
select fh.procinst_id, fh.workform_type, fh.instance_id, fh.keydata_id
from sa_workform_inst_history fh
where fh.instance_id in (:15, :16)) f2
where rwh2.proc_instance_id = ph2.proc_instance_id
and ph2.parent_procinc_id = f2.procinst_id) w,
sa_user u,
sa_dept d
WHERE w.user_id = u.user_id(+)
AND u.dept_id = d.dept_id(+)
UNION ALL
SELECT '' AS proc_instance_id,
'' AS activity_ins_id,
wt.worktask_id AS workitem_ins_id,
'' AS parent_workitem,
wt.worktask_name AS NAME,
wt.worktask_status AS current_state,
wt.complete_time,
wt.start_time AS create_time,
NULL AS limit_time,
'' AS app_name,
'' AS app_type,
wt.link_url AS app_url,
'' AS CATEGORY,
NULL AS send_type,
'' AS user_name,
wt.actor_id AS user_id,
NULL AS TYPE,
NULL AS if_create_workitem,
'' AS msg_app_type,
to_number(wt.participant_type) AS user_entity_type,
'' AS user_entity_name,
wt.participant_id AS user_entity_id,
wt.keydata_id AS r_data_id,
NULL AS participant_type,
0 AS overdued,
NULL AS ifhandling,
NULL AS priority,
NULL AS need_part_role,
'' AS description,
wt.link_param AS ext_prop,
NULL AS flow_direction,
'' AS origin_id,
'' AS origin_name,
NULL AS origin_type,
NULL AS is_substituted,
'' AS actor_id,
'' AS actor_name,
NULL AS actor_type,
'' AS businesskey,
wt.dept AS depart_id,
wt.area AS wt_area,
wt.dept AS wt_dept_id,
wt.worktask_status AS wt_worktask_status,
wt.target_time AS target_time,
wt.link_url AS wt_link_url,
wt.link_param AS wt_link_param,
wt.is_batch AS wt_is_batch,
wt.attr1 AS wt_attr1,
wt.attr2 AS wt_attr2,
wt.attr3 AS wt_attr3,
wt.attr4 AS wt_attr4,
wt.attr5 AS wt_attr5,
sa_dept.dept_name as dept_name,
sa_user.real_name as real_name,
wt.workform_type as wi_workform_type,
wt.instance_id as wi_instance_id,
wt.wi_keydata_id as wi_keydata_id
FROM (select wt.*, f.workform_type, f.keydata_id as wi_keyd
ata_id
from sa_worktask wt, sa_workform_inst f
where wt.instance_id in (:17, :18)
and wt.instance_id = f.instance_id
union
select wth.*, fh.workform_type, fh.keydata_id as wi_keydata_id
from sa_worktask_history wth, sa_workform_inst_history fh
where wth.instance_id in (:19, :20)
and wth.instance_id = fh.instance_id
) wt,
sa_user,
sa_dept
WHERE wt.actor_id = sa_user.user_id(+)
and sa_user.dept_id = sa_dept.dept_id(+) |
fjurzns1pb47q | INSERT INTO "GGS" ."GGS_STICK" (PROPERTY, VALUE) VALUES ('lv_compat', :B1 ) |
fnj6cnubp1sau | begin
if :enable = 0 then
sys.dbms_output.disable;
else
sys.dbms_output.enable(:size);
end if;
end;
|
fvkwk0sc4hyvk | select 1 from s_wkst_rela a where a.rela_wkst_no=:1 and (rela_type like'01%' or rela_type like'02%') |
g3wrkmxkxzhf2 | select cols, audit$, textlength, intcols, property, flags, rowid from view$ where obj#=:1 |
g8k48mbcnrt9b | select * from (select alia.*, rownum as rnum from (SELECT DISTINCT group_id FROM rt_overtime_deal WHERE current_state=:1 AND (create_time is not null) AND (time_out_time is NULL) AND handlestate=0 AND version=0) alia where rownum <2) where rnum>=1 |
gbu2ydkdztspv | BEGIN delete p_proc_tl_examine
where rslt_id in (select rslt_id from arc_p_proc_tl_examine); END; |
gf0stawtdxnf6 |
select c_cons.CONS_ID as "consId", c_cons.VAT_ID as "vatId", c_cons.CUST_ID as "custId", c_cons.CONS_NO as "consNo", c_cons.CONS_NAME as "consName", c_cons.CUST_QUERY_NO as "custQueryNo", c_cons.TMP_PAY_RELA_NO as "tmpPayRelaNo", c_cons.ORGN_CONS_NO as "orgnConsNo", c_cons.CONS_SORT_CODE as "consSortCode", c_cons.ELEC_ADDR as "elecAddr", c_cons.TRADE_CODE as "tradeCode", c_cons.ELEC_TYPE_CODE as "elecTypeCode", c_cons.CONTRACT_CAP as "contractCap", c_cons.RUN_CAP as "runCap", c_cons.SHIFT_NO as "shiftNo", c_cons.LODE_ATTR_CODE as "lodeAttrCode", c_cons.VOLT_CODE as "voltCode", c_cons.HEC_INDUSTRY_CODE as "hecIndustryCode", c_cons.HOLIDAY as "holiday", c_cons.BUILD_DATE as "buildDate", c_cons.PS_DATE as "psDate", c_cons.CANCEL_DATE as "cancelDate", c_cons.DUE_DATE as "dueDate", c_cons.NOTIFY_MODE as "notifyMode", c_cons.SETTLE_MODE as "settleMode", c_cons.STATUS_CODE as "statusCode", c_cons.ORG_NO as "orgNo", c_cons.RRIO_CODE as "rrioCode", c_cons.CHK_CYCLE as "chkCycle", c_cons.LAST_CHK_DATE as "lastChkDate", c_cons.CHECKER_NO as "checkerNo", c_cons.POWEROFF_CODE as "poweroffCode", c_cons.TRANSFER_CODE as "transferCode",
c_cons.MR_SECT_NO as "mrSectNo", c_cons.NOTE_TYPE_CODE as "noteTypeCode", c_cons.TMP_FLAG as "tmpFlag", c_cons.TMP_DATE as "tmpDate", c_cons.MEAS_MODE as "measMode", c_cons.DB_TIMESTAMP as "dbTimestamp" from c_cons where CONS_ID = :1 |
gjkzdx6fxjc7w |
select /*+ FIRST_ROWS */ * from (select t.*, ROWNUM as RN2 from (select c_cons.CONS_ID as "CONS_ID", c_cons.VAT_ID as "VAT_ID", c_vat.VAT_NAME as "VAT_NAME", c_cons.CUST_ID as "CUST_ID", c_cons.CONS_NO as "CONS_NO", c_cons.CONS_NAME as "CONS_NAME", c_cons.CUST_QUERY_NO as "CUST_QUERY_NO", c_cons.TMP_PAY_RELA_NO as "TMP_PAY_RELA_NO", c_cons.ORGN_CONS_NO as "ORGN_CONS_NO", c_cons.ELEC_ADDR as "ELEC_ADDR", c_cons.TRADE_CODE as "TRADE_CODE", sa_c_trade_type.TRADE as "TRADE", c_cons.ELEC_TYPE_CODE as "ELEC_TYPE_CODE", c_cons.CONTRACT_CAP as "CONTRACT_CAP", c_cons.RUN_CAP as "RUN_CAP", c_cons.SHIFT_NO as "SHIFT_NO", c_cons.LODE_ATTR_CODE as "LODE_ATTR_CODE", c_cons.HEC_INDUSTRY_CODE as "HEC_INDUSTRY_CODE", c_cons.HOLIDAY as "HOLIDAY", c_cons.BUILD_DATE as "BUILD_DATE", c_cons.PS_DATE as "PS_DATE", c_cons.CANCEL_DATE as "CANCEL_DATE", c_cons.DUE_DATE as "DUE_DATE", c_cons.NOTIFY_MODE as "NOTIFY_MODE", c_cons.SETTLE_MODE as "SETTLE_MODE", c_cons.STATUS_CODE as "STATUS_CODE", c_cons.ORG_NO as "ORG_NO", sa_org.ORG_NAME as "ORG_NAME", c_cons.RRIO_CODE as "RRIO_CODE", c_cons.CHK_CYCLE as "CHK_CYCLE", c_cons.LAST_CHK_DATE as "LAST_CHK_DATE", c_cons.CHEC
KER_NO as "CHECKER_NO", sa_user.REAL_NAME as "CHECKER_NAME", c_cons.POWEROFF_CODE as "POWEROFF_CODE", c_cons.TRANSFER_CODE as "TRANSFER_CODE", c_cons.MR_SECT_NO as "MR_SECT_NO", c_cons.NOTE_TYPE_CODE as "NOTE_TYPE_CODE", c_cons.TMP_FLAG as "TMP_FLAG", c_cons.TMP_DATE as "TMP_DATE", c_cons.MEAS_MODE as "MEAS_MODE", c_cons.DB_TIMESTAMP as "DB_TIMESTAMP", c_cons.VOLT_CODE as "VOLT_CODE", c_cons.CONS_SORT_CODE as "CONS_SORT_CODE", '' as "PAY_MODE", '' as "MADE_NO", '' as "BAR_CODE", '' as "TELE_NO", '' as "PAY_NO", '' as "BANK_ACCT", c_cons.CARD_NO as "CARD_NO" from c_cons, c_vat, sa_c_trade_type, sa_org, sa_user where ((c_cons.VAT_ID = c_vat.VAT_ID(+) and c_cons.TRADE_CODE = sa_c_trade_type.TRADE_CODE(+) and c_cons.ORG_NO = sa_org.ORG_NO(+) and c_cons.CHECKER_NO = sa_user.USER_ID(+)) and ((c_cons.CONS_NAME like :1 escape '/' AND c_cons.ELEC_ADDR like :2 escape '/'))) and (C_CONS.ORG_NO LIKE '21401%')) t where ROWNUM <= :3) where RN2 > :4 |
gjttfx5kj8snu |
select view_workitem_flow_original.PROC_INSTANCE_ID as "PROC_INSTANCE_ID", view_workitem_flow_original.ACTIVITY_INS_ID as "ACTIVITY_INS_ID", view_workitem_flow_original.WORKITEM_INS_ID as "WORKITEM_INS_ID", view_workitem_flow_original.PARENT_WORKITEM as "PARENT_WORKITEM", view_workitem_flow_original.NAME as "NAME", view_workitem_flow_original.CURRENT_STATE as "CURRENT_STATE", view_workitem_flow_original.COMPLETE_TIME as "COMPLETE_TIME", view_workitem_flow_original.CREATE_TIME as "CREATE_TIME", view_workitem_flow_original.LIMIT_TIME as "LIMIT_TIME", view_workitem_flow_original.APP_NAME as "APP_NAME", view_workitem_flow_original.APP_TYPE as "APP_TYPE", view_workitem_flow_original.APP_URL as "APP_URL", view_workitem_flow_original.CATEGORY as "CATEGORY", view_workitem_flow_original.SEND_TYPE as "SEND_TYPE", view_workitem_flow_original.USER_NAME as "USER_NAME", view_workitem_flow_original.USER_ID as "USER_ID", view_workitem_flow_original.TYPE as "TYPE", view_workitem_flow_original.IF_CREATE_WORKITEM as "IF_CREATE_WORKITEM", view_workitem_flow_original.MSG_APP_TYPE as "MSG_APP_TYPE", view_workitem_flow_original.USER_ENTITY_TYPE as "USER_ENTITY_TYPE", view_workitem_flow_original.USER_ENTITY_NAME as "USER_ENTITY_NAME", view_workitem_flow_original.USER_ENTIT
Y_ID as "USER_ENTITY_ID", view_workitem_flow_original.R_DATA_ID as "R_DATA_ID", view_workitem_flow_original.PARTICIPANT_TYPE as "PARTICIPANT_TYPE", view_workitem_flow_original.OVERDUED as "OVERDUED", view_workitem_flow_original.IFHANDLING as "IFHANDLING", view_workitem_flow_original.PRIORITY as "PRIORITY", view_workitem_flow_original.NEED_PART_ROLE as "NEED_PART_ROLE", view_workitem_flow_original.DESCRIPTION as "DESCRIPTION", view_workitem_flow_original.EXT_PROP as "EXT_PROP", view_workitem_flow_original.FLOW_DIRECTION as "FLOW_DIRECTION", view_workitem_flow_original.ORIGIN_ID as "ORIGIN_ID", view_workitem_flow_original.ORIGIN_NAME as "ORIGIN_NAME", view_workitem_flow_original.ORIGIN_TYPE as "ORIGIN_TYPE", view_workitem_flow_original.IS_SUBSTITUTED as "IS_SUBSTITUTED", view_workitem_flow_original.ACTOR_ID as "ACTOR_ID", view_workitem_flow_original.ACTOR_NAME as "ACTOR_NAME", view_workitem_flow_original.ACTOR_TYPE as "ACTOR_TYPE", view_workitem_flow_original.BUSINESSKEY as "BUSINESSKEY", view_workitem_flow_original.DEPART_ID as "DEPART_ID", view_workitem_flow_original.PROC_INSTANCE_NAME as "PROC_INSTANCE_NAME", view_workitem_flow_original.PROC_TEMPLET_NAME as "PROC_TEMPLET_NAME", view_workitem_flow_original.ACTIVITY_TMP_ID as "ACTIVITY_TMP_ID&qu
ot;, view_workitem_flow_original.WT_AREA as "WT_AREA", view_workitem_flow_original.WT_DEPT_ID as "WT_DEPT_ID", view_workitem_flow_original.WT_WORKTASK_STATUS as "WT_WORKTASK_STATUS", view_workitem_flow_original.WT_TARGET_TIME as "WT_TARGET_TIME", view_workitem_flow_original.WT_LINK_URL as "WT_LINK_URL", view_workitem_flow_original.WT_LINK_PARAM as "WT_LINK_PARAM", view_workitem_flow_original.WT_IS_BATCH as "WT_IS_BATCH", view_workitem_flow_original.WT_ATTR1 as "WT_ATTR1", view_workitem_flow_original.WT_ATTR2 as "WT_ATTR2", view_workitem_flow_original.WT_ATTR3 as "WT_ATTR3", view_workitem_flow_original.WT_ATTR4 as "WT_ATTR4", view_workitem_flow_original.WT_ATTR5 as "WT_ATTR5", view_workitem_flow_original.WI_INSTANCE_ID as "WI_INSTANCE_ID", view_workitem_flow_original.WI_INSTANCE_NAME as "WI_INSTANCE_NAME", view_workitem_flow_original.WI_WORKFORM_TYPE as "WI_WORKFORM_TYPE", view_workitem_flow_original.WI_BUILDER as "WI_BUILDER", view_workitem_flow_original.WI_TARGET_TIME as "WI_TARGET_TIME", view_workitem_flow_original.WI_LIMIT_TIME as "WI_LIMIT_TIME", view_workitem_flow_original.WI_INSTANCE_STATUS as "WI_INSTANCE_STATUS", view_workitem_flow_original.WI_BUSINESS as "WI_BUSINESS", view_workitem_flow_original.WI_KEYDATA_ID as "WI_KEYDATA_ID", view_work
item_flow_original.WI_IS_FLOW as "WI_IS_FLOW", view_workitem_flow_original.WI_ATTR1 as "WI_ATTR1", view_workitem_flow_original.WI_ATTR2 as "WI_ATTR2", view_workitem_flow_original.WI_ATTR3 as "WI_ATTR3", view_workitem_flow_original.WI_ATTR4 as "WI_ATTR4", view_workitem_flow_original.WI_ATTR5 as "WI_ATTR5", view_workitem_flow_original.WI_DEPT_ID as "WI_DEPT_ID", view_workitem_flow_original.TARGET_TIME as "TARGET_TIME", view_workitem_flow_original.HOWLONG_WILL_OVERDUE as "HOWLONG_WILL_OVERDUE", view_workitem_flow_original.HOWLONG_OVERDUED as "HOWLONG_OVERDUED", view_workitem_flow_original.WI_BUILDER_REALNAME as "WI_BUILDER_REALNAME", view_workitem_flow_original.BE_APPROVAL_STATUS as "BE_APPROVAL_STATUS" from view_workitem_flow_original where view_workitem_flow_original.WI_KEYDATA_ID = :1 and view_workitem_flow_original.NAME = :2 and view_workitem_flow_original.COMPLETE_TIME is null order by view_workitem_flow_original.CREATE_TIME desc |