SQL Id | SQL Text |
02djppxs4a73n | update ol$_locks t set t.obj = null |
05fs85a4b0dy2 | select t.plan_item_id, t.plan_year, t.PLAN_CD,
t.month_plan_cd, t.plan_type,
t.voltage_class_cd, t.voltage_class, t.work_site_id, t.work_site,
t.stop_asset_id, t.stop_asset, t.item_State_Cd,
t.stop_power_switch_id, t.stop_power_switch,
t.org_no, t.org_name, t.dept_no, t.dept_name, t.item_state,
to_char(t.stop_begin_date, 'yyyy-mm-dd hh24:mi:ss') strStopBeginDate, to_char(t.stop_end_date, 'yyyy-mm-dd hh24:mi:ss') strStopEndDate
from t_plan_week_plan_items t
where 1=1 and t.item_state in ('ÒÑ·¢²¼', 'ÒÑÍê³É') and t.org_no like GETORGNO(:1) and t.plan_type_cd =:2 and t.plan_year = :3 and t.plan_cd in (select a.week_plan_id from V_TICKET_QUERY a, V_POWERCUT_QUERY b where a.week_plan_id=b.WEEK_PLAN_CD ) |
0b243yjuy3dvq | select x.attr_uri, x.attr_name, x.attr_disp_name, x.attr_data_type, x.attr_index, x.attr_pos, x.attr_doc, x.cls_uri, x.cls_derive, y.cat_id, y.cat_disp_name, z.con_id, z.can_be_null, z.min_str_len, z.max_str_len, z.min_num_val, z.max_num_val, z.num_precision, z.min_date_val, z.max_date_val, z.attr_cls, e.edt_package, e.edt_class, e.edt_data from ol$_attr_defs x left join ol$_attr_categories y on x.cat_id = y.cat_id left join ol$_attr_constraints z on ol$_core.GETATTRDERIVE(x.attr_uri) = z.attr_uri left join ol$_attr_editors e on ol$_core.getattrprime(x.attr_uri) = e.attr_uri where x.cls_uri = :1 order by x.attr_index |
0dwr2vd6vbqzs |
SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff,
nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number
= :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
|
0k5gsd7bnr1wr | select b.workingBeginDateMin, b.workingEndDateMax , a.delay_begin_date, a.delay_end_date from v_powercut_apply_query a, ( select min(t.WORKING_BEGIN_DATE) workingBeginDateMin, max(t.WORKING_END_DATE ) workingEndDateMax from v_powercut_apply_query t where t.actionname in('EXECUTE', 'OVER') and t.ORG_NO= :1 and t.week_plan_cd= :2 ) b where a.WORKING_END_DATE=b.workingEndDateMax |
15p742qrkv57u | SELECT * FROM sgpm.o_org WHERE org_no=''
|
1f5c885f3vvfx | select /*+ index(v$_ST_Asset IDX_OL$_OBJECTS_CLS_PATHNAME) */ v$_ST_Asset.* from v$_ST_Asset where orgId = :1 and ( (ASSETSSTATUS = :2 OR ASSETSSTATUS = :3) and pathName like :4 ) order by pathName |
1h1sr3yhptj6t | SELECT DISTINCT a.sys_user_name, a.user_name, a.org_no, a.dept_no, (SELECT NAME FROM o_dept WHERE dept_no = a.dept_no) dept_name, (SELECT org_name FROM o_org WHERE org_no = a.org_no) org_name FROM v_sp_user a, v_sp_user_operpriv b WHERE a.sys_user_name = b.sys_user_name AND a.cur_status_code = '01' AND a.org_no = b.org_no AND a.org_no = :1 AND a.dept_no = :2 AND b.auth_id = :3 ORDER BY nlssort(a.user_name, 'NLS_SORT=SCHINESE_PINYIN_M') |
1r7mjtz9kp72t |
select * from (select /*+rule*/ p.OBJ_ID as id, p.NAME as psrName, OL$_OBJECT_UTIL.GETPARENTID(P.PATHNAME) as parentID,
p.cls_uri as psrGroupID, '' as attemperNumber, p.VOLTAGELEVEL AS VOLTAGELEVEL, c.cls_disp_name AS psrGroupName, 0 as lpsequence from olive.v$_st_powersystemresource p, olive.ol$_classes c where p.PATHNAME like (select pathname from olive.v$_lowarea l where l.ORGID = :1 and l.OBJ_ID =:2) || '%' and orgid = :3 and p.CLS_URI <>'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentContainer/ST_Station/DYCableBox' and p.CLS_URI <>'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentContainer/DYPolePosition' AND p.RESOURCESTATUS <> 'I' and p.CLS_URI = c.cls_uri union all select /*+rule*/ dp.OBJ_ID as id, dp.NAME as psrName, OL$_OBJECT_UTIL.GETPARENTID(dP.PATHNAME) as parentID, dp.cls_uri as psrGroupID, '' as attemperNumber, dp.VOLTAGELEVEL AS VOLTAGELEVEL, c.cls_disp_name AS psrGroupName, dp.LPSEQUENCE from olive.v$_dypoleposition dp, olive.ol$_classes c where dp.PATHNAME like (select pathname from olive.v$_lowarea l where l.ORGID = :4 and l.OBJ_ID = :5) || '%' and orgid = :6 AND dp.RESOURCESTATUS <> 'I' and dp.CLS_URI = c.cls_uri union all select /*+rule*/ mb.OBJ_ID as id, mb.NAME as psrName, OL$_OBJECT_UTIL.GETPARENTID(mb.PATHNAME) as parentID, mb.cls_uri as psrGroupID, '' as attemperNumber, mb.VOLTAGELEVEL AS VOLTAGELEVEL, c.cls_disp_name AS psrGroupName, mb.LPSEQUENCE from olive.v$_dycab
lebox mb, olive.ol$_classes c where mb.PATHNAME like (select pathname from olive.v$_lowarea l where l.ORGID = :7 and l.OBJ_ID = :8) || '%' and orgid = :9 AND mb.RESOURCESTATUS <> 'I' and mb.CLS_URI = c.cls_uri) order by lpsequence |
1zqktnh3k2w9h |
SELECT * FROM ( select name "Éú²ú±äѹÆ÷Ãû³Æ",
(select org_name
from sgpm.o_org
where org_no = orgid
And Rownum = 1) "¹©µçµ¥Î»",
(select (select (select name
from olive.v$_st_feeder
where obj_id = substr(o.s_04, 197, 64)
And Rownum = 1)
from olive.ol$_objects o
where obj_id = x.a
And Rownum = 1)
from olive.ol$_associations x
where b = substr(pathname, 2, 64)
And Rownum = 1) "ËùÊôÖ÷Ïß",
(select (select olive.getpathnamebypathid(o.s_04)
from olive.ol$_objects o
where obj_id = x.a
And Rownum = 1)
from olive.ol$_associations x
where b = substr(pathname, 2, 64)
And Rownum = 1) "Éú²ú±äѹÆ÷λÖÃ",
(select (select o.INSERVICEDATE
from olive.v$_st_powersystemresource o
where obj_id = x.a
And Rownum = 1)
from olive.ol$_associations x
where b = substr(pathname, 2, 64)
And Rownum = 1) "ͶÔËÈÕÆÚ",
(select (select (select (select org_name from sgpm.o_org where org_no=p_dept_no) from sgpm.o_dept where dept_no=o.o_15)
from olive.ol$_objects o
where obj_id = x.a
And Rownum = 1)
from olive.ol$_associations x
where b = substr(pathname, 2, 64)
And Rownum = 1) "ά»¤°à×é",
'10kV' "µçѹµÈ¼¶",
ratedCapacity "¶î¶¨ÈÝÁ¿(kVA)",
obj_id "Éú²úID",
(select name
from sgpm.p_code
where value = AssetsStatus
and code_type = 'AssetsState'
And Rownum = 1) "״̬",
CCBH "³ö³§±àºÅ",
(select name
from sgpm.p_code
where value = SBXH
and code_type = 'DisTransAssetXH'
And Rownum = 1) "É豸ÐͺÅ",
(Select Name
From Sgpm.p_Code p
Where Value = (Select Usetype
From Olive.V$_St_Distransformer
Where Obj_Id = (Select a
From Olive.Ol$_Associations
Where b = t.Obj_Id
and rownum = 1))
And p.Code_Type = 'UseType'
and rownum = 1) "ËùÓÃÐÔÖÊ",
(select name
from sgpm.p_code
where code_type = 'BDSB_ZCSSDW'
and value = t.ASSETNATURE) "×ʲúÐÔÖÊ",
decode((select (select ( (select 'Ïä±ä' from v$_ST_BoxStation where obj_id=substr(o.s_04, -129, 64))
)
from olive.ol$_objects o
where obj_id = x.a
A
nd Rownum = 1)
from olive.ol$_associations x
where b = substr(pathname, 2, 64)
And Rownum = 1), 'Ïä±ä', 'ÊÇ', '·ñ') "ÊÇ·ñÏä±ä",
(select name
from sgpm.p_code
where code_type = 'TransforNature'
and value = t.TRANSFORNATURE) "×ʲúËùÓÃÐÔÖÊ"
from olive.v$_ST_DisTransAsset t
where orgid = :1
and assetsstatus = decode(:2, null, 'S', :3, :4)
and length( :5)=7
) WHERE rownum <= :6 |
244v8yhfs7urr | SELECT C.CLS_ID, C.CLS_URI,
C.PKG_URI, C.CLS_NAME,
C.CLS_DISP_NAME, C.CLS_INDEX,
C.CLS_LEVEL, C.CLS_LOGGABLE,
C.CLS_ABSTRACT, C.CLS_DOC,
C.CLS_SORT
FROM OL$_CLASSES C, OL$_ASSOCIATION_CONSTRAINTS AC
WHERE C.CLS_URI = AC.SIDE_B
AND C.CLS_SORT = 'T'
AND AC.SIDE_A = :1 |
2bnuvr2y93awr | SELECT T.CLS_URI, T.ATTR_NAME, T.ATTR_URI, T.ATTR_DISP_NAME, T.ATTR_DATA_TYPE, T.ATTR_POS FROM OL$_ATTR_DEFS T WHERE T.CLS_URI = :B2 AND T.ATTR_NAME = :B1 |
2w5dgfjvasy4j | SELECT stat.sid, sess.status, sess.machine, sess.username, (SYSDATE-sess.logon_time)*86400 elapsed_time, stat.cpu, stat.memsorts, stat.tablescans, stat.phyreads, stat.logreads, stat.disksorts, stat.blks_changed, stat.chained_rows, stat.commits, stat.cursors, round((1-(stat.phyreads/DECODE(stat.logreads, 0, NULL, stat.logreads)))*100) buffer_cache_hitrate from (SELECT st.sid, SUM(DECODE(name, 'CPU used by this session', value, 0)) cpu, SUM(DECODE(name, 'sorts (disk)', value, 0)) disksorts, SUM(DECODE(name, 'sorts (memory)', value, 0)) memsorts, SUM(DECODE(SUBSTR(name, 0, 11), 'table scans', value, 0)) tablescans, SUM(DECODE(name, 'physical reads', value, 0)) phyreads, SUM(DECODE(name, 'session logical reads', value, 0)) logreads, SUM(DECODE(name, 'db block changes', value, 0)) blks_changed, SUM(DECODE(name, 'table fetch continued row', value, 0)) chained_rows, SUM(DECODE(name, 'user commits', value, 0)) commits, SUM(DECODE(name, 'opened cursors current', value, 0)) cursors FROM V$SESSTAT st, V$STATNAME sn WHERE st.statistic# = sn.statistic# GROUP BY st.sid) stat, v$session sess where stat.sid = sess.sid |
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 |
35x85qdq8manh | SELECT DISTINCT a.sys_user_name, a.user_name, a.org_no, a.dept_no, (SELECT NAME FROM o_dept WHERE dept_no = a.dept_no) dept_name, (SELECT org_name FROM o_org WHERE org_no = a.org_no) org_name FROM v_sp_user a, v_sp_user_operpriv b WHERE a.sys_user_name = b.sys_user_name AND a.org_no = b.org_no AND a.cur_status_code = '01' AND a.org_no = :1 AND b.auth_id = :2 ORDER BY a.dept_no, nlssort(a.user_name, 'NLS_SORT=SCHINESE_PINYIN_M') |
39896zjqcvbms |
SELECT * FROM ( select s.equip_id ÓªÏú±äѹÆ÷ID,
s.tran_name ÓªÏú±äѹÆ÷Ãû³Æ,
s.distran_object_name Éú²ú±äѹÆ÷Ãû³Æ,
(select org_name
from sgpm.o_org
where org_no = orgid
And Rownum = 1) ¹©µçµ¥Î»,
(select (select (select name
from olive.v$_st_feeder
where obj_id = substr(o.s_04, 197, 64)
And Rownum = 1)
from olive.ol$_objects o
where obj_id = x.a
And Rownum = 1)
from olive.ol$_associations x
where b = substr(pathname, 2, 64)
And Rownum = 1) ËùÊôÖ÷Ïß,
(select (select olive.getpathnamebypathid(o.s_04)
from olive.ol$_objects o
where obj_id = x.a
And Rownum = 1)
from olive.ol$_associations x
where b = substr(pathname, 2, 64)
And Rownum = 1) Éú²ú±äѹÆ÷λÖÃ,
'10kV' µçѹµÈ¼¶,
ratedCapacity "¶î¶¨ÈÝÁ¿(kVA)",
obj_id Éú²úID,
(select name
from sgpm.p_code
where value = AssetsStatus
and code_type = 'AssetsState'
And Rownum = 1) ״̬,
CCBH ³ö³§±àºÅ,
(select name
from sgpm.p_code
where value = SBXH
and code_type = 'DisTransAssetXH'
And Rownum = 1) É豸ÐͺÅ
from olive.v$_ST_DisTransAsset t, mis_pms_tran_map@ypjc s
where t.obj_id = s.DISTRAN_OBJECT_ID
and t.assetsstatus = :1
and s.org_no like :2 || '%'
and orgid = :3 ) WHERE rownum <= :4 |
3c1kubcdjnppq | update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln |
449xyhjkn7apn | select * from v$_ST_EquipmentCategory where ( orgId = :1 ) and OBJ_ID in (select /*+ INDEX ( ol$_associations NK_OL$_REFS_URI_A ) */ ol$_associations.b obj_id from ol$_associations where ol$_associations.ast_uri = :2 and ol$_associations.a = :3 ) |
450w20twk6ku5 | BEGIN
OL$_RULE_CORE.CHECKNAMEMAIN(:1, :2, :3, :4, :5, :6, :7);
END; |
4860dcbah84h4 | update t_yxdz_czpxx t set t.zlrdm=:1, t.zlr=:2, t.zldd=:3, t.zldddm=:4, t.zlsj=to_date( :5, 'yyyy - mm - dd hh24 : mi'), t.zljsr=:6, t.zljhr=:7, t.sfzx=:8, t.zxrdm=:9, t.zxr=:10, t.zxkssj=to_date( :11, 'yyyy - mm - dd hh24 : mi'), t.zxjssj=to_date( :12, 'yyyy - mm - dd hh24 : mi'), t.jhr=:13, t.jhrdm=:14, t.zbfzr=:15, t.zbfzrdm=:16, shdd=:17, shdddm=:18, shddy=:19, shddydm=:20, shddsj=to_date( :21, 'yyyy-mm-dd hh24:mi'), shyy=:22, disabledFlag=:23, hbdd=:24, hbdddm=:25, czph=:26, hbddy=:27, hbddydm=:28, czbzs=:29, xzshr=:30, xzshrdm=:31, sfzzzx=:32, zxbz=:33, czpbh=:34, zljsrdm=:35, dlh=:36, t.flsj=to_date( :37, 'yyyy - mm - dd hh24 : mi'), flr=:38, flrdm=:39, ylr=:40, ylrdm=:41 where t.processid=:42 |
4bzh761vk20q0 | update ol$_objects set D_07 = :D_07, S_34 = :S_34, S_35 = :S_35, S_05 = :S_05, N_15 = :N_15, D_01 = :D_01, N_42 = :N_42, O_09 = :O_09, O_21 = :O_21, S_09 = :S_09, S_36 = :S_36, O_17 = :O_17, S_63 = :S_63, O_01 = :O_01, S_31 = :S_31, S_32 = :S_32, D_04 = :D_04, S_01 = :S_01, O_05 = :O_05, S_28 = :S_28, S_27 = :S_27, O_15 = :O_15, S_02 = :S_02, O_02 = :O_02, O_16 = :O_16, O_20 = :O_20, D_05 = :D_05, S_03 = :S_03, D_06 = :D_06, S_04 = :S_04, D_03 = :D_03 where obj_id = :objId |
4hn182nyc6xd5 | INSERT INTO T_YPJC_DISTLINESEGMENT
(id,
loss_id,
from_dist_pole_position_id,
to_dist_pole_position_id,
dist_line_segment_id,
distlinesegmentname,
linename,
location,
wirelength,
wire_type_code,
wire_type_name,
unitresistance,
unitreactance)
VALUES
(sys_guid(), :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12) |
4ydgzsjh9kb57 |
SELECT a.obj_id objid,
a.cls_uri,
a.orgid,
getorgnamebyorgno(orgid) org_name,
a.NAME linename,
b.id,
b.objname,
to_char(b.count_date, 'yyyy-mm') count_date,
b.active_power,
b.reactive_power,
b.actual_line_lose,
b.actual_line_lose_rate,
b.academic_line_lose,
b.academic_line_lose_rate,
b.algorithm,
b.count_date,
b.compute_date
FROM olive.v$_lowarea a
LEFT JOIN (SELECT id,
low_area_original_id,
org_no,
org_name,
objid,
objname,
deptid,
userid,
active_power,
reactive_power,
actual_line_lose,
actual_line_lose_rate,
academic_line_lose,
academic_line_lose_rate,
calcalgo,
compute_date,
calcresult,
count_date,
algorithm,
row_number() over(PARTITION BY low_area_original_id ORDER BY count_date DESC) count_date_ord
FROM t_ypjc_dy_linelose l
WHERE NOT EXISTS (SELECT 1
FROM t_ypjc_low_plan_loss_relation r
WHERE r.loss_id = l.id)
) b ON a.obj_id = b.low_area_original_id
AND b.count_date_ord = 1
WHERE a.resourcestatus = :1
AND a.orgid = :2
ORDER BY compute_date |
525r285cr9aa7 |
select T128047.KGLX as c4,
T121580.BDSMC as c5,
T114421.KGMC as c6,
T133554.DD as c7,
T128047.MIN_VALUE as c9,
T128047.AVG_VALUE as c10,
T128047.MAX_VALUE as c11,
T121580.XJDM as c12,
T121580.DSJDM as c13
from
D_RQ_BY T133554,
D_SCADA_SWITCH T114421,
D_SB_DW$BDZ$ZB T121580,
F_SCADA_BDZ_VALUE T128047
where ( T114421.KGDM = T128047.KGDM and T121580.BDSDM = T128047.BDZDM and T128047.DATAID = T133554.HID and T121580.DSJMC = 'ºªµ¦¹©µç¹«Ë¾' and T121580.XJMC = '·ÊÏçÏØ¹©µç¹«Ë¾' and T128047.KGLX = 'Ïß·¿ª¹Ø' and (T121580.DSJDM in ('1340220') or T121580.XJDM in (substr('1340220' , 1 , 7), '1340220')) and T128047.DWDM in ('1340220') ) |
572fbaj0fdw2b | select output from table(dbms_workload_repository.awr_report_html( :dbid,
:inst_num,
:bid, :eid,
:rpt_options )) |
57dshrk20f9nk | select t.plan_item_id, t.plan_year, t.PLAN_CD,
t.month_plan_cd, t.plan_type,
t.voltage_class_cd, t.voltage_class, t.work_site_id, t.work_site,
t.stop_asset_id, t.stop_asset, t.item_State_Cd,
t.stop_power_switch_id, t.stop_power_switch,
t.org_no, t.org_name, t.dept_no, t.dept_name, t.item_state,
to_char(t.stop_begin_date, 'yyyy-mm-dd hh24:mi:ss') strStopBeginDate, to_char(t.stop_end_date, 'yyyy-mm-dd hh24:mi:ss') strStopEndDate
from t_plan_week_plan_items t
where 1=1 and t.item_state in ('ÒÑ·¢²¼', 'ÒÑÍê³É') and t.org_no like GETORGNO(:1) and t.plan_year = :2 and t.plan_cd in (select a.week_plan_id from V_TICKET_QUERY a, V_POWERCUT_QUERY b where a.week_plan_id=b.WEEK_PLAN_CD ) |
598k07tzg7tud | Select
Ass.Obj_Id,
ass.CLS_URI,
Ass.Name,
Ass.Ratedcapacity,
(Select Name
From Sgpm.p_Code
Where Code_Type = 'DisTransAssetXH'
And Value = Ass.Sbxh) Sbxh,
pc.Pathname Pathid,
Olive.Getpathnamebypathid(pc.Pathname) Pathname,
Ass.Assetsstatus,
Ass.Orgid,
Ass.CODE
From olive.v$_st_powersystemresource pp,
Olive.V$_St_Distransformer Pc,
Olive.V$_St_Distransasset Ass,
Olive.Ol$_Associations a
Where Pc.Pathname Like pp.PATHNAME||'%'
And pp.OBJ_ID = :1
And Ass.Pathname Like '\' || a.b || '%'
And Pc.Obj_Id = a.a
And Ass.Assetsstatus In (:2, :3)
And Ass.Orgid = Pc.Orgid
And Pc.Orgid = :4 and pc.RESOURCESTATUS = 'E' |
5b547zkdp3mq6 | begin
ol$_core_expand.MADEEQUIMODIFYDETAIL(:1, :2, :3);
end; |
5bhhxz06fvgnk |
SELECT OBJ_ID,
NAME,
A.CLS_URI,
A.PATHNAME,
C.CLS_DISP_NAME,
(CASE
WHEN A.CLS_URI LIKE
'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/%' THEN
(SELECT GETPATHNAMEBYPATHID(P1.PATHNAME || A.PATHNAME)
FROM OL$_ASSOCIATIONS ASS,
V$_ST_POWERSYSTEMRESOURCE P1,
V$_ST_POWERSYSTEMRESOURCE P2
WHERE ASS.AST_URI =
'OLASSOCIATIONTYPE://ST_PowerSystemResource_ST_Asset?A="OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource"&B="OLCLASS://Entity/ST_IdentifiedObject/ST_Asset"'
AND ASS.B = SUBSTR(A.PATHNAME, 2, 64)
AND ASS.A = P1.OBJ_ID
AND P1.PATHNAME LIKE P2.PATHNAME || '%'
AND ROWNUM = 1 AND P2.OBJ_ID IN (:1))
ELSE
GETPATHNAMEBYPATHID(PATHNAME)
END) PATHNAMEVALUE
FROM V$_ST_IDENTIFIEDOBJECT A, OLIVE.OL$_CLASSES C
WHERE C.CLS_URI = A.CLS_URI
AND OBJ_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)
ORDER BY A.CLS_URI , A.PATHNAME |
5qr55krh9dkx5 |
select APPLY_ID, APPLY_CD, APPLY_DATE, APPLICANT_CD, APPLICANT, APPLY_UNIT_CD, APPLY_UNIT, REPAIR_UNIT_CD, REPAIR_UNIT, PLAN_TO_CUT, WEEK_PLAN_CD, WORK_LEADER_CD, WORK_LEADER, APPLY_STOP_BEGIN_DATE, APPLY_STOP_END_DATE, STOP_TARGET_ID, STOP_TARGET, STOP_ASSETS_ID, STOP_ASSETS, STOP_SCOPE, WORK_CONTENT, WIRING_CHART, CHANGED_WIRING_CHART, HANDLER_CD, HANDLER, AUDITOR_CD, AUDITOR, APPROVAL_STOP_BEGIN_DATE, APPROVAL_STOP_END_DATE, DISTRICT_DISP_FASHION, DISTRICT_DISP_GUARD, DISTRICT_DISP_APPROVE, FASHION, FASHION_AUDITOR_CD, FASHION_AUDITOR, GUARD, GUARD_AUDITOR_CD, GUARD_AUDITOR, APPROVAL, APPROVER_CD, APPROVER, RECEIVER_CD, RECEIVER, WORKING_BEGIN_DATE, DELEGATE_CD, DELEGATE, BEGIN_DISPATCHER_CD, BEGIN_DISPATCHER, WORKING_END_DATE, REPORTER_CD, REPORTER, END_DISPATCHER_CD, END_DISPATCHER, REAUDITOR_CD, REAUDITOR, DELAY_APPLY_BEGIN_DATE, DELAY_APPLY_END_DATE, DELAY_BEGIN_DATE, DELAY_END_DATE, APPROVAL_BEGIN_DATE, APPROVAL_END_DATE, REPAIR_BEGIN_DATE, REPAIR_END_DATE, DELAY_APPLICANT_CD, DELAY_APPLICANT, DELAY_APPROVER_CD, DELAY_APPROVER, DELAY_REASON, MEMO, LAST_UPDATE_DATE, LAST_UPDATER_CD, LAST_UPDATER, CREATE_DATE, CREATER_CD, CREATER, ORG_NO, ORG_NAME, DEL_FLG , action_url, actionname, activity_name, HANDLE_AUDIT_DATE, FASHION_AUDIT_DATE, FASHION_APPROVAL_BEGIN_DATE, FASHION_APPROVAL_END_DATE, GUARD_AUDIT_DATE, APPROVE_AUDIT_DATE from V_POWERCUT_APPLY_QUERY a where 1=1 and a.WEEK_PLAN_CD =:1
|
5wfhpq886xacr | SELECT /*+index(t, NK_OL$_REFS_URI_A)*/ A, B OBJ_ID, (SELECT S_01 FROM OL$_OBJECTS WHERE OBJ_ID = B) NAME FROM OL$_ASSOCIATIONS T WHERE AST_URI = :B2 AND A = :B1 AND SUBSTR(B, 1, 32) IN (SELECT (SELECT CLS_ID FROM OL$_CLASSES WHERE CLS_URI = C.CLS_URI) CLS_ID FROM OL$_CLSNAME_DEFS C WHERE EXISTS (SELECT 1 FROM OL$_CLSRULE_DEFS D WHERE D.MAIN_ID = C.MAIN_ID AND EXISTS (SELECT 1 FROM OL$_RULE_DEFS WHERE UPPER(UP_COL) = 'NAME' AND RULE_TYPE = 'C2' AND RULE_ID = D.RULE_ID)) AND EQUIPMENT_SORT = OL$_RULE_CORE.GETEQUSORT(:B1 )) |
5yp7648cjj2s1 | SELECT t.sys_user_name, t.user_name, t.org_no, t.dept_no, (SELECT name FROM o_dept WHERE dept_no=t.dept_no) dept_name, (SELECT org_name FROM o_org WHERE org_no=t.org_no) org_name FROM v_sp_user t WHERE t.sys_user_name = UPPER(:1) |
646v5z184310m | select t.s_01 from olive.ol$_objects t where t.obj_id= :1 |
6fn21cpfwmbmw | INSERT INTO T_EQUIMODIFY_DETAIL WITH TEMP_ASSET_S AS (SELECT AA.OBJ_ID FROM OLIVE.V$_ST_ASSET AA WHERE AA.ORGID = :B1 AND AA.OBJ_ID IN (SELECT T.B FROM OLIVE.V$_ST_POWERSYSTEMRESOURCE P, OLIVE.OL$_OBJECTS_TEMP_TAB P1, OLIVE.OL$_ASSOCIATIONS T WHERE T.A = P.OBJ_ID AND P.PATHNAME LIKE P1.S_04 || '%' AND P.ORGID = :B1 )), TEMP_ASSET_R AS (SELECT AA.OBJ_ID FROM OLIVE.V$_ST_ASSET AA WHERE AA.ORGID = :B1 AND AA.OBJ_ID IN (SELECT T.B FROM OLIVE.V$_ST_POWERSYSTEMRESOURCE P, OLIVE.OL$_OBJECTS_TEMP_TAB P1, OLIVE.OL$_ASSOCIATIONS_RETIRE T WHERE T.A = P.OBJ_ID AND P.PATHNAME LIKE P1.S_04 || '%' AND P.ORGID = :B1 )), TEMP_ASSET_FIRSTALL AS (SELECT OBJ_ID FROM TEMP_ASSET_S UNION ALL SELECT OBJ_ID FROM TEMP_ASSET_R) SELECT :B3 , X.OBJ_ID, X.CLS_URI, X.NAME, X.VOLTAGELEVEL, X.INSERVICEDATE, X.CREATORID, X.CREATEDATE, X.LASTUPDATEID, X.LASTUPDATEDATE, X.ASSETSSTATUS, '', X.ORGID, DECODE(X.LASTUPDATEDATE, X.CREATEDATE, 'A', DECODE(X.ASSETSSTATUS, 'R', 'D', 'U')) OPERATOR_TYPE FROM OLIVE.V$_ST_ASSET X WHERE X.OBJ_ID IN (SELECT OBJ_ID FROM TEMP_ASSET_FIRSTALL) AND TO_CHAR(X.LASTUPDATEDATE, 'YYYY-MM-DD') = TO_CHAR(SYSDATE, 'YYYY-MM-DD') AND X.LASTUPDATEID = :B2 AND X.ORGID = :B1 |
6pcrpqf5dkunf | select /*+ index(o PK_OL$_OBJECTS) */ * from v$_DYPolePosition o where obj_id=:1 |
6t8pyz0wcrk16 | update ol$_objects set D_03 = :D_03, S_04 = :S_04, O_16 = :O_16, N_42 = :N_42, S_03 = :S_03, O_05 = :O_05, D_01 = :D_01, S_28 = :S_28, O_17 = :O_17, S_36 = :S_36, S_31 = :S_31, O_01 = :O_01, D_04 = :D_04, S_01 = :S_01, S_34 = :S_34, N_15 = :N_15, O_15 = :O_15, O_20 = :O_20, O_21 = :O_21, S_63 = :S_63, S_35 = :S_35, S_09 = :S_09, S_02 = :S_02, S_05 = :S_05, D_07 = :D_07, D_06 = :D_06, S_27 = :S_27, O_09 = :O_09, S_32 = :S_32, D_05 = :D_05 where obj_id = :objId |
7kg4x6mdk9rf0 | BEGIN :1 :=OWF_MGR.PKG_INDY_ORWF_API.SENDFLOW(:2, :3);END; |
7rph7uc1mq73k |
INSERT INTO T_EQUIMODIFY_DETAIL WITH TEMP_ASSET_S AS (SELECT AA.OBJ_ID FROM OLIVE.V$_ST_ASSET AA WHERE AA.ORGID = :B1 AND AA.OBJ_ID IN (SELECT T.B FROM OLIVE.V$_ST_POWERSYSTEMRESOURCE P, OLIVE.OL$_OBJECTS_TEMP_TAB P1, OLIVE.OL$_ASSOCIATIONS T WHERE T.A = P.OBJ_ID AND P.PATHNAME LIKE P1.S_04 || '%' AND P.ORGID = :B1 )), TEMP_ASSET_R AS (SELECT AA.OBJ_ID FROM OLIVE.V$_ST_ASSET AA WHERE AA.ORGID = :B1 AND AA.OBJ_ID IN (SELECT T.B FROM OLIVE.V$_ST_POWERSYSTEMRESOURCE P, OLIVE.OL$_OBJECTS_TEMP_TAB P1, OLIVE.OL$_ASSOCIATIONS_RETIRE T WHERE T.A = P.OBJ_ID AND P.PATHNAME LIKE P1.S_04 || '%' AND P.ORGID = :B1 )), TEMP_ASSET_FIRSTALL AS (SELECT OBJ_ID FROM TEMP_ASSET_S UNION ALL SELECT OBJ_ID FROM TEMP_ASSET_R), TEMP_ASSET_SUB_R AS (SELECT A.B OBJ_ID FROM OL$_ASSOCIATIONS_RETIRE A, TEMP_ASSET_FIRSTALL F WHERE A.A = F.OBJ_ID), TEMP_ASSET_SUB_S AS (SELECT A.B OBJ_ID FROM OL$_ASSOCIATIONS A, TEMP_ASSET_S S WHERE A.A = S.OBJ_ID) SELECT :B3 , AAA.OBJ_ID, AAA.CLS_URI, AAA.NAME, AAA.VOLTAGELEVEL, AAA.INSERVICEDATE, AAA.CREATORID, AAA.CREATEDATE, AAA.LASTUPDATEID, AAA.LASTUPDATEDATE, AAA.ASSETSSTATUS, '', AAA.ORGID, 'D' FROM OLIVE.V$_ST_ASSET AAA WHERE AAA.OBJ_ID IN (SELECT OBJ_ID FROM TEMP_ASSET_SUB_R UNION ALL SELECT OBJ_ID FROM TEMP_ASSET_SUB_S) AND AAA.ASSETSSTATUS = 'R' AND AAA.LASTUPDATEID = :B2 AND TO_CHAR(AAA.LASTUPDATEDATE, 'YYYY-MM-DD') = TO_CHAR(SYSDATE, 'YYYY-MM-DD')
|
7xgzx0zrnt0fc | select /*+ index(o PK_OL$_OBJECTS) */ * from v$_ST_DYLine o where obj_id=:1 |
7xn6xppmpg9u7 | SELECT *
FROM (SELECT D.OBJ_ID,
D.CLS_URI,
D.NAME,
GETNAMEPATHBYIDPATH(D.PATHNAME) PATHNAME,
C.CLS_DISP_NAME DISNAME
FROM (SELECT ASS.B
FROM OLIVE.OL$_ASSOCIATIONS ASS
START WITH ASS.A = :1 ---- ¶¥²ãÉ豸ÈÝÆ÷id
CONNECT BY PRIOR ASS.B = A) E,
OLIVE.V$_ST_POWERSYSTEMRESOURCE D,
OLIVE.OL$_CLASSES C
WHERE D.OBJ_ID = E.B
AND D.CLS_URI IN(:2)
AND C.CLS_URI = D.CLS_URI
AND D.RESOURCESTATUS = 'E'
AND D.ORGID =:3 ) E
ORDER BY E.PATHNAME |
8b9zc43w360qt | SELECT O_28 partitionField FROM ol$_objects t WHERE t.obj_id=:1 |
8d150bzkm38pm | SELECT 1 FROM indy_user_action t WHERE t.user_name = :1 AND t.user_bureau_name = :2 AND t.action_name = :3 |
8d3y3sqaj9f3s |
SELECT * FROM (SELECT row_.*, ROWNUM rownum_ FROM ( SELECT a.process_type, a.process_no, a.process_title, a.app_no, a.taskid, a.act_name, a.rcv_time, a.finish_time, a.alarm_date, a.due_time,
a.cur_state status_code, a.lock_emp_no, a.lock_time, a.org_no, a.overreason, a.worklist_type, a.alarm_time_limit, a.time_limit, a.task_color, a.back_reason, handle_rslt, a.busi_type_code, a.srv_mode
, CASE WHEN a.due_time < SYSDATE THEN 'Y' ELSE 'N' END isovertimer, CASE WHEN a.alarm_date < SYSDATE THEN 'Y' ELSE 'N' END isalarmtimer, a.cons_no, a.cons_name, a.elec_addr, a.sect_no, a.sect_name, a.sect_remark, a.chk_subject_no, a.chk_type, a.chk_name, a.chk_prio
, a.exam_chk_type, a.equip_categ, a.equip_model, a.assign_date, a.qty, a.subs_no, a.subs_name, a.subs_addr
, a.cust_no, a.cust_name, a.cust_use_addr, a.link_addr, a.link_name, a.link_tel, a.srv_channel, a.call_no, a.call_content, a.selbuy_equip, a.crm_cust_no, a.crm_cust_name, a.crm_resume, a.exam_remark, a.busi_data, a.start_user, a.distribute_dept, a.dm_task_type, a.app_contract_cap, a.t_contract_cap, a.volt_code, a.process_color, a.resume_time, a.user_org_no, a.terminal_addr, a.fault_addr, a.fault_property , a.scip_register_no, a.scip_cons_no, a.scip_busi_type, a.scip_srv_content, a.scip_req_time FROM wf_amber.v_indysp_worklist_cur a, wf_amber.indysp_task_user_cur b
WHERE a.taskid = b.taskid AND a.app_no = b.app_no
AND a.org_no = b.process_org_no
AND b.user_no = :1 AND b.user_
dept_no = :2
AND b.user_org_no = :3 AND a.cur_state NOT IN( 'WAIT', 'BACKWAIT') AND ( a.lock_emp_no = :4 OR a.lock_emp_no IS NULL ) ORDER BY a.rcv_time DESC ) row_ WHERE ROWNUM <:5) WHERE rownum_ >=:6 |
93dtuy0vt2k7q | SELECT task_id FROM p_task WHERE set_emp_no = :1 AND content LIKE '%methodName=notifyDeskMessage%' |
964zgsudcdac7 | SELECT D.ATTR_URI FROM OL$_ATTR_DEFS D WHERE D.CLS_URI = :B2 AND D.ATTR_NAME = :B1 |
9g4jrwq86jnb7 | BEGIN
OL$_RULE_CORE.CHECKANDUPDATELOWERNAME(:1);
END; |
9yh5wgu938tja | BEGIN
OL$_CORE_EXPAND.Batchinserviceasset(:1);
END; |
9yyb7wvndk114 | select * from v$_ST_DYLine where ( orgId = :1 and ResourceStatus = :2 ) and OBJ_ID in (select /*+ INDEX ( ol$_associations NK_OL$_REFS_URI_A ) */ ol$_associations.b obj_id from ol$_associations where ol$_associations.ast_uri = :3 and ol$_associations.a = :4 ) order by cls_uri |
a41yvpfth003x | select * from v$_ST_Equipment where ( orgId = :1 and RESOURCESTATUS=:2) and OBJ_ID in (select /*+ INDEX ( ol$_associations NK_OL$_REFS_URI_A ) */ ol$_associations.b obj_id from ol$_associations where ol$_associations.ast_uri = :3 and ol$_associations.a = :4 ) |
ab0n17bxfj28d | SELECT *
FROM (SELECT D.OBJ_ID,
D.CLS_URI,
D.NAME,
GETNAMEPATHBYIDPATH(D.PATHNAME) PATHNAME,
C.CLS_DISP_NAME DISNAME
FROM (SELECT ASS.B
FROM OLIVE.OL$_ASSOCIATIONS ASS
START WITH ASS.A = :1 ---- ¶¥²ãÉ豸ÈÝÆ÷id
CONNECT BY PRIOR ASS.B = A) E,
OLIVE.V$_ST_POWERSYSTEMRESOURCE D,
OLIVE.OL$_CLASSES C
WHERE D.OBJ_ID = E.B
AND D.CLS_URI IN(:2)
AND D.NAME LIKE :3
AND C.CLS_URI = D.CLS_URI
AND D.RESOURCESTATUS = 'E'
AND D.ORGID =:4 ) E
ORDER BY E.PATHNAME |
ac4pb7ypdb95a | select count(l.log_machine_ip) from indy_online_user l, indy_user u where l.log_link_id !=:1 and l.log_web_path=:2 and l.log_user_id = u.user_id and u.user_name = :3 |
aw6gj3r2syaxs | select interdata.area_code, interdata.area_name, interdata.sub_area_code, interdata.sub_area_name, to_char(Min(interdata.import_time), 'yyyy-mm-dd hh24:mi:ss') as fartime, to_char(Max(interdata.import_time), 'yyyy-mm-dd hh24:mi:ss') as neartime, sum(1) As sczcs, sum(Case When interdata.handle_flag = '2' Then 1 When (interdata.handle_flag = '3' or interdata.handle_flag = '4') Then 0 End) as sccgcs, sum(Case When (interdata.handle_flag = '0' or interdata.handle_flag = '1') Then 1 When (interdata.handle_flag = '2' or interdata.handle_flag = '3' or interdata.handle_flag = '4') Then 0 End) as clzzcs, sum(Case When interdata.handle_flag = '2' Then 0 When (interdata.handle_flag = '3' or interdata.handle_flag = '4') Then 1 End) as yccs from scada.scada_interface_data_bd interData where 1=1 and interData.area_code = 'dqid' Group By interdata.area_code, interdata.area_name, interdata.sub_area_code, interdata.sub_area_name order by interdata.area_code, interdata.sub_area_code |
awvtdy3vc6fum | SELECT codeId, codeSortId, parentCodeId, codeType, orgNo, value, name, dispSn, content1, content2, content3, content4, content5 FROM (SELECT '' codeId, '' codeSortId, p_code parentCodeId, code_type codeType, org_no orgNo, value, name, disp_sn dispSn, content1, content2, content3, content4, content5 FROM v_sp_cache_code) WHERE codeType=:1 |
b0mb9f2wdgnrk | select /*+ index(o PK_OL$_OBJECTS) */ * from v$_LowArea o where obj_id=:1 |
bm62pp5bq23r5 | SELECT a.app_no, a.taskid, b.locker, b.cur_state
FROM wf_amber.indysp_task_user_cur a, wf_amber.indywf_worklist_cur b
WHERE a.app_no = b.item_key
AND a.taskid = b.taskid
AND a.process_org_no = b.dept_name
AND a.app_no = :1
AND a.taskid = :2
AND a.user_no = :3
AND a.user_dept_no = :4
AND a.user_org_no = :5 |
btd9xht9j1ah9 | insert into PMS.t_plan_workflow( ITEM_KEY , AUDITOR_ID , AUDITOR , AUDIT_DATE , ACTION_NAME , ACTION_TITLE , NEXT_ACTION_NAME , NEXT_ACTION_TITLE , TASK_ID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9) |
bvuadm73ru53a | INSERT INTO T_YPJC_LINELOSE
(id,
org_no,
org_name,
line_id,
line_name,
voltage_level_code,
voltage_level_name,
count_date,
active_power,
reactive_power,
active_load,
reactive_load,
actual_line_lose,
actual_line_lose_rate,
academic_line_lose,
academic_line_lose_rate,
line_active_load,
line_reactive_load,
line_active_power,
line_reactive_power,
algorithm,
calcalgo,
calcresult)
VALUES
(:1,
:2,
:3,
:4,
:5,
:6,
:7,
to_date(:8, 'yyyy-mm'),
:9,
:10,
:11,
:12,
:13,
:14,
:15,
:16,
:17,
:18,
:19,
:20,
:21,
:22,
:23) |
byuacw6h7dqkn | INSERT INTO T_YPJC_DISTTRANSFORMER
(id,
loss_id,
dist_trans_id,
dist_trans_res_id,
disttransformername,
location,
measuremode,
pub_priv_flag,
ratedcapacity,
noloadcurrent,
impedancevoltage,
ratedshortcircuitloss,
noloadloss,
suppactivequantity,
suppactivequantityafter,
suppreactivequantity,
suppreactivequantityafter)
VALUES
(sys_guid(), :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16) |
c5tmjxj6rtck4 | SELECT mis_t.tg_id id,
(SELECT mis_area.tg_cap
FROM v_mis_tg@ypjc mis_area
WHERE mis_area.tg_id = mis_t.tg_id) capacity,
(SELECT mis_area.tg_name
FROM v_mis_tg@ypjc mis_area
WHERE mis_area.tg_id = mis_t.tg_id) name, (SELECT mis_area.org_no
FROM v_mis_tg@ypjc mis_area
WHERE mis_area.tg_id = mis_t.tg_id) org_no
FROM mis_pms_tran_map@ypjc m, v_mis_g_tran@ypjc mis_t
WHERE m.equip_id = mis_t.equip_id
AND m.org_no LIKE :1
AND mis_t.org_no LIKE :2
AND m.distran_object_id IN (
:3) |
c7udywnqw95vh | select value, name from sgpm.p_code t where t.code_type = :1 |
cfrwbnuu2xtam | select side_b from ol$_association_constraints where association_type = :1 and side_a = :2 |
cq9hj0h4ju789 | select b.name deptName, a.USER_TITLE userName, t_yxdz_czpxx_count(user_name, '', 'czrws', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') czrws, t_yxdz_czpxx_count(user_name, '', 'czps', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') czps, t_yxdz_czpxx_count(user_name, '', 'czbzs', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') czbzs, t_yxdz_czpxx_count(user_name, '', 'kprws', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') kprws, t_yxdz_czpxx_count(user_name, '', 'kps', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') kps, t_yxdz_czpxx_count(user_name, '', 'kpbzs', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') kpbzs, t_yxdz_czpxx_count(user_name, '', 'shrws', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') shrws, t_yxdz_czpxx_count(user_name, '', 'shps', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') shps, t_yxdz_czpxx_count(user_name, '', 'shbzs', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') shbzs, t_yxdz_czpxx_count(user_name, '', 'jhrws', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') jhrws, t_yxdz_czpxx_count(user_name, '', 'jhps', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') jhps, t_yxdz_czpxx_count(user_name, '', 'jhbzs', '201303', '±äµçµ¹Õ¢²Ù×÷Ʊ') jhbzs from amber.indy_user a, sgpm.o_dept b where b.dept_no = '0000081025' and a.USER_DEPARTMENT_NAME=b.DEPT_NO order by a.user_title desc |
cs4fxq1s9xvyc | UPDATE OLIVE.V$_ST_ASSET X SET X.ASSETSSTATUS = 'S' WHERE X.OBJ_ID IN (SELECT AA.OBJ_ID FROM OLIVE.V$_ST_ASSET A, OLIVE.V$_ST_ASSET AA WHERE AA.ORGID = A.ORGID AND A.ORGID = :B1 AND AA.ASSETSSTATUS = 'W' AND AA.PATHNAME LIKE A.PATHNAME || '%' AND A.OBJ_ID IN (SELECT /*+index(p, IDX_OL$_OBJECTS_CLS_PATHNAME)*/ T.B FROM OLIVE.V$_ST_POWERSYSTEMRESOURCE P, OLIVE.OL$_ASSOCIATIONS T WHERE T.A = P.OBJ_ID AND P.PATHNAME LIKE :B2 || '%' AND P.ORGID = :B1 )) |
czxzy970jq50g | update ol$_objects set S_27 = :S_27, D_08 = :D_08, S_40 = :S_40, D_10 = :D_10, O_07 = :O_07, S_36 = :S_36, D_04 = :D_04, D_01 = :D_01, S_32 = :S_32, O_03 = :O_03, D_06 = :D_06, O_29 = :O_29, S_35 = :S_35, S_75 = :S_75, S_15 = :S_15, S_68 = :S_68, N_07 = :N_07, N_01 = :N_01, O_04 = :O_04, S_63 = :S_63, S_02 = :S_02, S_76 = :S_76, D_03 = :D_03, O_27 = :O_27, S_03 = :S_03, S_21 = :S_21, O_01 = :O_01, N_10 = :N_10, N_52 = :N_52, N_42 = :N_42, O_25 = :O_25, D_05 = :D_05, O_24 = :O_24, S_42 = :S_42, D_07 = :D_07, O_31 = :O_31, S_01 = :S_01, S_04 = :S_04, O_02 = :O_02, O_26 = :O_26, N_09 = :N_09, O_05 = :O_05, O_06 = :O_06, N_02 = :N_02, S_73 = :S_73, N_51 = :N_51, S_31 = :S_31, S_22 = :S_22, S_34 = :S_34, S_05 = :S_05, S_39 = :S_39 where obj_id = :objId |
d3gsxy5k0u8hw | select * from v$_ST_Asset where ( orgId = :1 ) and OBJ_ID in (select /*+ INDEX ( ol$_associations NK_OL$_REFS_URI_A ) */ ol$_associations.b obj_id from ol$_associations where ol$_associations.ast_uri = :2 and ol$_associations.a = :3 ) |
d7qa0bq22h0p3 | SELECT A FROM OL$_ASSOCIATIONS WHERE B = :B1 |
dczy7gkm3mpax | update ol$_objects set S_04 = :S_04 where obj_id = :objId |
dnctudjagb520 | select * from v$_ST_AssetModel where ( orgId = :1 ) and OBJ_ID in (select /*+ INDEX ( ol$_associations NK_OL$_REFS_URI_A ) */ ol$_associations.b obj_id from ol$_associations where ol$_associations.ast_uri = :2 and ol$_associations.a = :3 ) |
dst5yk4vxcg04 |
select a.line_id,
a.line_name,
a.issue_unit_id,
a.issue_unit,
a.unit,
a.unit_id,
a.leader_id,
a.leader,
a.ticket_no,
a.working_unit_id,
a.working_unit,
a.working_staff_id,
a.working_staff,
a.total_staff,
a.work_site,
a.pulling_switch,
a.live_electrical_equipment,
a.other_security_measures,
to_char(a.start_date, 'yyyy-mm-dd hh24:mi') str_start_date,
to_char(a.end_date, 'yyyy-mm-dd hh24:mi') str_end_date,
a.start_date,
a.end_date,
a.issue_no,
a.issuer,
a.issue_date,
a.receive_leader_id,
a.receive_leader_name,
a.receive_date,
(select wmsys.wm_concat(permit_leader_id) from pms.t_wt_line_workticket1_permit b WHERE b.ticket_no = a.ticket_no) permit_leader_id,
(select wmsys.wm_concat(permit_working_man) from pms.t_wt_line_workticket1_permit b WHERE b.ticket_no = a.ticket_no) permit_working_man,
a.exec_working_staff_id,
(select wmsys.wm_concat(to_char(permit_working_time, 'yyyy-mm-dd hh24:mi:ss')) from pms.t_wt_line_workticket1_permit b WHERE b.ticket_no = a.ticket_no) SpermitWorkingTime,
(select wmsys.wm_concat(permit_working_man_id) from pms.t_wt_line_workticket1_permit b WHERE b.ticket_no = a.ticket_no) permit_working_man_id,
(select wmsys.wm_concat(permit_leader) from pms.t_wt_line_workticket1_permit b WHERE b.ticket_no = a.ticket_no) permit_leader,
(select wmsys.wm_concat(permit_mode) from pms.t_wt_line_workticket1_permit b WHERE b.ticket_no = a.ticket_no) permit_mode,
a.issuer_id,
a.working_condition,
a.reclose_equipment,
a.exec_working
_staff,
a.changed_date,
a.working_staff_changes,
a.exec_leader_id,
a.exec_leader,
a.deadline,
a.delay_permiter_id,
a.delay_permiter,
a.earth_wire_no,
a.terminal_mode,
a.earth_wire_total_set,
a.terminal_permiter_id,
a.terminal_permiter,
a.terminal_leader_id,
a.terminal_leader,
a.terminal_report_time,
a.permiter_audit_date,
a.leader_audit_date,
a.del_flg,
a.should_earth_wire_no,
a.should_earth_wire_total_set,
a.filler_id,
a.filler,
a.delay_leader,
a.former_leader,
a.former_leader_id,
a.changed_leader_id,
a.changed_leader,
a.exec_issuer_id,
a.exec_issuer,
a.work_team,
a.action_url,
a.actionname,
GETORGNAMES(a.issue_unit_id) orgName,
a.activity_name, a.week_plan_id from pms.V_LINE_TICKET1_QUERY a where 1=1 and del_flg = 'F' and org_no LIKE GETORGNO('1340308') |
f8uvk4ymbh19z | SELECT NAME, TYPE, ACTION_URL, actionname, activity_name, ticket_no, filler_id, filler, leader, leader_id, str_start_date, str_end_date, issuer, issuer_id, issue_date, permit_permiter_id, permit_permiter, week_plan_id FROM v_all_ticket1_query T WHERE T.WEEK_PLAN_ID =:1 |
fkc00x536y5kw |
select /*+rule*/ p.OBJ_ID as id,
p.NAME as psrName,
OL$_OBJECT_UTIL.GETPARENTID(P.PATHNAME) as parentID,
p.cls_uri as psrGroupID,
c.cls_disp_name AS psrGroupName,
to_number(getViewAttribute(c.cls_view, p.obj_id, 'lpsequence')) as lpsequence,
'' as attemperNumber,
c.cls_view as clsView,
p.VOLTAGELEVEL AS VOLTAGELEVEL
from v$_st_powersystemresource p, ol$_classes c, v$_st_powersystemresource power
where p.cls_uri = c.cls_uri
AND c.cls_uri IN
('OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentContainer/ST_Line/ST_Feeder', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_Equipment/ST_ConductingEquipment/ST_Switch/ST_Fuse/DropoutFuse', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentContainer/ST_TransmisPolePosition', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_Equipment/ST_DisTransformer', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentContainer/ST_HolePosition', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_Equipment/ST_ConductingEquipment/ST_Switch/ST_Disconnector', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_Equipment/ST_ConductingEquipment/ST_Switch/ST_ProtectedSwitch/ST_LoadBreakSwitch', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_Equipment/ST_ConductingEquipment/ST_Switch/ST_Fuse', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentCont
ainer/ST_Station/ST_CableBox', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentContainer/ST_CompositeSwitch/ST_RMU', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_Equipment/ST_ConductingEquipment/ST_Switch/ST_ProtectedSwitch/ST_Breaker', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentContainer/ST_Station/ST_BoxStation', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentContainer/ST_Station/ST_DisStation') and p.PATHNAME LIKE power.PATHNAME||'%'
AND p.RESOURCESTATUS <> 'I'
and power.OBJ_ID = :1
and power.orgId = :2
and p.orgId = :3
ORDER BY lpsequence |
g0mmxhhfz1q9g | select * from v$_LowArea where ( orgId = :1 and ResourceStatus = :2 ) and OBJ_ID in (select /*+ INDEX ( ol$_associations NK_OL$_REFS_URI_A ) */ ol$_associations.b obj_id from ol$_associations where ol$_associations.ast_uri = :3 and ol$_associations.a = :4 ) order by cls_uri |
g4rzpg6rj116d | BEGIN
OL$_RULE_CORE.SETSTRATTR(:1, :2);
END; |
g8kw89rqydxjm | select b.*
from t_plan_week_plan_items b
where 1=1 and b.item_state_cd='FILLED'
and b.plan_id=:1 order by b.fill_date desc |
gfaqgusc2hfr5 | SELECT org_no, org_name, p_org_no, org_type, sort_no FROM o_org WHERE org_no = :1 |
ggsus9qmhfqws |
SELECT COUNT(1) cnt FROM( With Temp_St_Transmispoleposition As (
Select v.OBJ_ID
From Olive.V$_St_Transmispoleposition v
Where v.Resourcestatus = 'E'
And v.Orgid =:1
And Exists (Select 1
From Olive.Ol$_Associations Aa
Where Aa.b in (Select a.b
From Olive.Ol$_Associations a,
Olive.V$_St_Pole p
Where a.a = v.Obj_Id
And a.b = p.Obj_Id
And a.ast_uri='OLASSOCIATIONTYPE://ST_PowerSystemResource_ST_Asset?A="OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource"&B="OLCLASS://Entity/ST_IdentifiedObject/ST_Asset"')
And Aa.a <> v.Obj_Id)
)
Select (Select o.Org_Name From Sgpm.o_Org o Where o.Org_No = f.Orgid) "ÏØµ¥Î»",
f.Obj_Id,
f.Name "Ïß·Ãû³Æ",
Olive.Pkg_Imp_Equi_Common.Getpathnamebypathid(f.Pathname) "Ïß··¾¶",
f.Tconnectid,
(Select Olive.Pkg_Imp_Equi_Common.Getpathnamebypathid(v.Pathname)
From Olive.V$_St_Transmispoleposition v
Where v.Obj_Id = f.Tconnectid
And v.RESOURCESTATUS='E'
) "T½Ó¸Ë·¾¶"
From Olive.V$_St_Feeder f
Where f.Resourcestatus = 'E'
And f.Tconnectname Is Not Null
And Length(f.Pathname) > 260
And f.Orgid = :2
and exists (select 1 f
rom Olive.V$_St_Transmispoleposition where obj_id = f.Tconnectid)
And Not Exists (Select 1
From Temp_St_Transmispoleposition t
Where t.Obj_Id = f.Tconnectid)) |
gk7v3zx64y3ma | INSERT INTO t_ypjc_lowlinesegment
(id,
loss_id,
low_area_id,
low_area_original_id,
low_area_name,
low_line_id,
low_line_original_id,
low_line_name,
low_line_segment_id,
low_line_segment_original_id,
low_line_segment_name,
location,
wire_length,
wire_type_code,
wire_type_name,
wire_unit_resistance,
wire_unit_reactance)
VALUES
(sys_guid(), :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16) |
gkw6wc3pm09j6 | SELECT USER_NAME FROM AMBER.INDY_USER_ACTION U WHERE U.ACTION_NAME=:1 |
grwydz59pu6mc | select text from view$ where rowid=:1 |
gxv1gvzu11p4a |
select T121580.BDSMC as c1,
T128574.HH as c7,
T121580.DSJXH as c8,
T136748.BHL as c10,
T136748.DATAID as c11,
T121580.DSJDM as c12,
T121580.XJDM as c13
from
(select t.dd, t.did, t.hh, t.hid from d_rq_by t where t.did = to_char(sysdate, 'yyyymmdd') ) T128574,
D_SB_DW$BDZ$ZB T121580,
F_SCADA_FHTB_BY T136748
where ( T121580.BDSDM = T136748.BDSDM and T128574.HID = T136748.DATAID and (T121580.DSJDM in ('134011612') or T121580.XJDM in (substr('134011612' , 1 , 7), '134011612')) ) |