| SQL Id | SQL Text |
|---|
| 02djppxs4a73n | update ol$_locks t set t.obj = null |
| 0cxypy0hx9g11 | select /*+ index(o PK_OL$_OBJECTS) */ * from v$_FamilyLine o where obj_id=:1 |
| 0h6b2sajwb74n | select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| 0jat7ccc9fvct |
Select Pc.Obj_Id,
Pc.Cls_Uri,
Pc.Voltagelevel,
Pc.Pathname,
Ass.Obj_Id Assetid,
Ass.Name Assetname,
Ass.Cls_Uri Asseturi,
Getnamepathbyidpath(Pc.Pathname || Ass.Pathname) Assetnamepath,
c.Cls_Uri Clsuri,
c.Cls_Disp_Name,
Ass.Assetsstatus,
Ass.Manufacturer,
Ass.Sbxh,
Ass.Inservicedate,
Ass.Code
From V$_St_Powersystemresource Pp,
V$_St_Powersystemresource Pc,
Ol$_Associations a,
V$_St_Asset Ass,
Ol$_Classes c
Where Pc.Pathname Like Pp.Pathname || '%'
And Ass.Pathname Like '\' || a.b || '%'
And Pp.Obj_Id =:1
And Pc.Obj_Id = a.a
And Ass.Cls_Uri = c.Cls_Uri
And a.Ast_Uri = 'OLASSOCIATIONTYPE://ST_PowerSystemResource_ST_Asset?A="OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource"&B="OLCLASS://Entity/ST_IdentifiedObject/ST_Asset"' and Pc.orgId=:2 and Ass.orgId=Pc.orgId
and ass.Assetsstatus in( 'S', 'W') and ass.CLS_URI in( 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_AssetContainer/ST_Structure/ST_Pole', 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_LinearConductorAsset/ST_OHConductorAsset', 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_EarthWire/OHEarthWireAsset', 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_LinearConductorAsset/ST_CableAsset', 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_Terminal', 'OLCLASS://Entity/ST_Identifie
dObject/ST_Asset/ST_ElectricalAsset/IntermediateConnectortAsset') |
| 0js73phthdt42 | select t.TASK_CD,
t.TASK_NO,
t.TASK_NAME,
t.GRID_KIND_CD,
t.GRID_KIND,
t.STOP_TARGET_ID,
t.STOP_TARGET,
t.SPEC_CD,
t.SPEC,
t.BEGIN_DATE,
t.END_DATE,
t.TASK_STATE_CD,
t.TASK_STATE taskState,
t.FILLER_CD,
t.FILLER,
t.FILL_DATE,
t.LEADER_CD,
t.LEADER,
t.PATROLMAN_CD,
t.PATROLMAN,
t.AUDITOR_CD,
t.AUDITOR,
t.APPROVER_CD,
t.APPROVER,
t.LAST_UPDATE_DATE,
t.LAST_UPDATER_CD,
t.LAST_UPDATER,
t.CREATE_DATE,
t.CREATER_CD,
t.CREATER,
t.REASON_CD,
t.REASON,
t.org_name orgNo ,
getorgnames(t.org_no) ORGNAME
from PMS.T_PATROL_TASK t where 1=1 and t.task_no like :1 and t.grid_kind_cd = :2 and t.org_no like GETORGNO( :3 ) order by t.fill_date desc |
| 0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
| 0ptxn6whczpaj | begin insert into indy_online_user(log_id, log_link_id, log_user_id, log_person_id, log_web_path, log_server_path, log_logon_time, log_machine_ip, log_machine_name) values(:1, :2, :3, :4, :5, :6, sysdate, :7, :8); end; |
| 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 |
| 1gcnmuw9xtb3k | SELECT CLS_URI FROM OL$_CLASSES WHERE CLS_ID = SUBSTR(:B1 , 1, 32) |
| 1hnz140zn79uv | SELECT T.ORG_NAME FROM SGPM.O_ORG T WHERE T.ORG_NO=:B1 |
| 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 |
| 21w7mktubd1dq | SELECT :B2 , T.CAN_BE_NULL, T.MIN_STR_LEN, T.MAX_STR_LEN, T.MIN_NUM_VAL, T.MAX_NUM_VAL, T.NUM_PRECISION, T.MIN_DATE_VAL, T.MAX_DATE_VAL, T.ATTR_CLS FROM OL$_ATTR_CONSTRAINTS T WHERE T.ATTR_URI = :B1 |
| 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 |
| 2p70njsc3jdvy | DELETE FROM SGPM.P_TASK_ASSIGN A WHERE A.APP_NO = :B1 |
| 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# |
| 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 |
| 3tw8g2mwh4kgc | SELECT *
FROM (SELECT D.OBJ_ID,
D.CLS_URI,
D.NAME,
GETNAMEPATHBYIDPATH(M.PATHNAME || '\' || D.OBJ_ID) PATHNAME,
C.CLS_DISP_NAME DISNAME
FROM (SELECT ASS.A, ASS.B
FROM OLIVE.OL$_ASSOCIATIONS ASS
START WITH ASS.A = :1 ---- ¶¥²ãÉ豸ÈÝÆ÷id
CONNECT BY PRIOR ASS.B = A) E,
OLIVE.V$_ST_ASSET D,
OLIVE.OL$_CLASSES C,
OLIVE.V$_ST_IDENTIFIEDOBJECT M
WHERE D.OBJ_ID = E.B
AND M.OBJ_ID = E.A
AND D.CLS_URI IN(:2)
AND C.CLS_URI = D.CLS_URI
AND D.ASSETSSTATUS = 'S'
AND D.ORGID = :3) E
ORDER BY E.PATHNAME |
| 41wp41sp2ns44 | SELECT TASKID FROM WF_TASK WHERE ITEM_TYPE=:B2 AND ITEM_KEY=:B1 |
| 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; |
| 47r1y8yn34jmj | select default$ from col$ where rowid=:1 |
| 4m7m0t6fjcs5x | update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1 |
| 4nwucqtxta4mt | SELECT T.INSTANCE_LABEL, T.ACTIVITY_NAME FROM WF_PROCESS_ACTIVITIES T WHERE T.INSTANCE_ID = :B1 |
| 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 |
| 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 |
| 5n9d2rmutsfqv | select t.* from ol$_attr_categories t where t.cls_uri=:1 order by t.cat_index |
| 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
|
| 5v8y4xqjc73kv | SELECT Q1.B OBJ_ID
FROM OLIVE.OL$_QUOTEASSOCIATIONS Q1, OLIVE.OL$_QUOTEASSOCIATIONS Q2
WHERE Q1.AST_URI = Q2.AST_URI AND Q1.A = Q2.A
AND Q2.B = :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 )) |
| 6229274rb7bpc | 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
, 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_com a
WHERE a.user_no = :1 ORDER BY a.rcv_time DESC ) row_ WHERE ROWNUM <:2) WHERE rownum_ >=:3 |
| 646v5z184310m | select t.s_01 from olive.ol$_objects t where t.obj_id= :1 |
| 6769wyy3yf66f | select pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1 |
| 6aq34nj2zb2n7 | select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee# |
| 6pcrpqf5dkunf | select /*+ index(o PK_OL$_OBJECTS) */ * from v$_DYPolePosition o where obj_id=:1 |
| 6xjqy1675jdyr | select * from v$_ST_EquipmentContainer 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 name |
| 6xz0c679sk859 | SELECT NAME FROM V$_ST_IDENTIFIEDOBJECT WHERE OBJ_ID = :B1 |
| 750bnanjunuhh | DELETE FROM OWF_MGR.WF_NOTIFICATIONS T WHERE EXISTS( SELECT 1 FROM OWF_MGR.WF_ITEM_ACTIVITY_STATUSES B WHERE B.ITEM_TYPE=:B2 AND B.ITEM_KEY = :B1 AND B.NOTIFICATION_ID=T.NOTIFICATION_ID) |
| 7hft0rhsu4hh2 | UPDATE WF_NOTIFICATIONS SET FROM_USER = :B5 , FROM_ROLE = NVL(:B4 , FROM_ROLE), TO_USER = :B3 , SUBJECT = :B2 , LANGUAGE = USERENV('LANG') WHERE NOTIFICATION_ID = :B1 |
| 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# |
| 7wgzpzkd96b4p | SELECT n.id id,
n.name name,
n.node_type_code node_type_code,
n.span / 1000 span,
n.lpsequence lp_sequence,
n.dist_line_id dist_line_id
FROM v_dist_line_node n
WHERE n.pathname LIKE :1
AND n.org_no = :2
ORDER BY n.dist_line_id ASC, n.lpsequence ASC |
| 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 |
| 830q1znx77va1 | BEGIN
OL$_CORE_EXPAND.LINESUPPORTACCESS(:1, :2, :3);
END; |
| 83taa7kaw59c1 | select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol# |
| 88awc7wsyhuwm | update ol$_objects set S_73 = :S_73, N_06 = :N_06, S_03 = :S_03, N_52 = :N_52, S_32 = :S_32, N_09 = :N_09, S_01 = :S_01, O_01 = :O_01, D_03 = :D_03, S_60 = :S_60, N_51 = :N_51, S_39 = :S_39, S_30 = :S_30, N_42 = :N_42, O_08 = :O_08, S_22 = :S_22, O_06 = :O_06, D_07 = :D_07, O_07 = :O_07, O_31 = :O_31, O_05 = :O_05, S_63 = :S_63, O_14 = :O_14, S_40 = :S_40, S_33 = :S_33, O_04 = :O_04, S_57 = :S_57, S_43 = :S_43, S_75 = :S_75, D_05 = :D_05, S_05 = :S_05, N_07 = :N_07, O_29 = :O_29, O_02 = :O_02, O_10 = :O_10, D_06 = :D_06, S_34 = :S_34, O_25 = :O_25, N_10 = :N_10, S_42 = :S_42, O_15 = :O_15, O_26 = :O_26, D_10 = :D_10, S_15 = :S_15, D_04 = :D_04, O_24 = :O_24, S_27 = :S_27, S_04 = :S_04, O_27 = :O_27, S_02 = :S_02, D_08 = :D_08, S_76 = :S_76, O_03 = :O_03, S_68 = :S_68, D_01 = :D_01, S_21 = :S_21, S_35 = :S_35, S_31 = :S_31, S_36 = :S_36 where obj_id = :objId |
| 88h1jt12xms4p | INSERT INTO WF_AMBER.INDYSP_TASK_USER_HIS (APP_NO, TASKID, PRIV_CODE, TASK_TYPE, USER_NO, USER_DEPT_NO, USER_ORG_NO, PROCESS_ORG_NO, CREATE_TIME, CREATE_TYPE, WORKLIST_TYPE) SELECT A.APP_NO, A.TASKID, A.PRIV_CODE, A.TASK_TYPE, A.USER_NO, A.USER_DEPT_NO, A.USER_ORG_NO, A.PROCESS_ORG_NO, SYSDATE, CREATE_TYPE, WORKLIST_TYPE FROM WF_AMBER.INDYSP_TASK_USER_CUR A WHERE TASKID = :B1 |
| 8b9zc43w360qt | SELECT O_28 partitionField FROM ol$_objects t WHERE t.obj_id=:1 |
| 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 |
| 8p7gycr8uy2j7 | update ol$_objects set S_04 = :S_04, S_27 = :S_27, S_32 = :S_32, O_04 = :O_04, O_05 = :O_05, S_06 = :S_06, N_07 = :N_07, O_07 = :O_07, D_05 = :D_05, S_68 = :S_68, N_42 = :N_42, O_25 = :O_25, O_03 = :O_03, O_06 = :O_06, S_40 = :S_40, O_31 = :O_31, S_63 = :S_63, N_51 = :N_51, S_31 = :S_31, D_04 = :D_04, S_17 = :S_17, O_08 = :O_08, D_06 = :D_06, O_01 = :O_01, S_05 = :S_05, S_75 = :S_75, N_52 = :N_52, S_42 = :S_42, S_02 = :S_02, O_26 = :O_26, N_10 = :N_10, S_34 = :S_34, N_01 = :N_01, O_29 = :O_29, N_09 = :N_09, S_35 = :S_35, S_01 = :S_01, N_02 = :N_02, S_03 = :S_03, O_02 = :O_02, S_22 = :S_22, D_03 = :D_03, S_15 = :S_15, S_07 = :S_07, O_27 = :O_27, O_24 = :O_24, S_14 = :S_14, D_10 = :D_10, S_76 = :S_76, S_21 = :S_21, S_73 = :S_73, D_07 = :D_07, S_39 = :S_39, S_36 = :S_36, D_08 = :D_08, D_01 = :D_01 where obj_id = :objId |
| 8rdg2n7g8ftk3 | update ol$_objects set O_10 = :O_10, S_37 = :S_37, S_27 = :S_27, S_63 = :S_63, S_06 = :S_06, O_20 = :O_20, O_05 = :O_05, O_25 = :O_25, O_21 = :O_21, O_02 = :O_02, S_38 = :S_38, N_07 = :N_07, D_07 = :D_07, S_12 = :S_12, O_23 = :O_23, S_13 = :S_13, O_18 = :O_18, S_17 = :S_17, S_47 = :S_47, S_31 = :S_31, S_05 = :S_05, O_17 = :O_17, N_20 = :N_20, S_03 = :S_03, S_01 = :S_01, S_30 = :S_30, N_10 = :N_10, S_25 = :S_25, O_04 = :O_04, O_01 = :O_01, N_42 = :N_42, S_11 = :S_11, S_14 = :S_14, O_13 = :O_13, S_32 = :S_32, S_34 = :S_34, S_35 = :S_35, S_09 = :S_09, N_04 = :N_04, O_15 = :O_15, N_03 = :N_03, N_02 = :N_02, O_19 = :O_19, D_01 = :D_01, S_33 = :S_33, O_11 = :O_11, N_09 = :N_09, N_11 = :N_11, S_44 = :S_44, N_18 = :N_18, S_07 = :S_07, N_19 = :N_19, O_14 = :O_14, N_12 = :N_12, S_15 = :S_15, D_05 = :D_05, O_24 = :O_24, D_04 = :D_04, D_03 = :D_03, O_09 = :O_09, N_01 = :N_01, N_05 = :N_05, O_07 = :O_07, N_06 = :N_06, O_12 = :O_12, N_15 = :N_15, S_02 = :S_02, O_16 = :O_16, S_36 = :S_36, N_08 = :N_08, O_03 = :O_03, D_06 = :D_06, S_04 = :S_04, O_08 = :O_08, N_13 = :N_13, S_16 = :S_16, S_28 = :S_28, O_22 = :O_22, S_43 = :S_43, O_06 = :O_06, S_18 = :S_18 where obj_id = :objId |
| 8txqupfzzqh39 | select * from v$_ST_EquipmentContainer 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 |
| 8u5s8xhp48xm2 | SELECT *
FROM (SELECT D.OBJ_ID,
D.CLS_URI,
D.NAME,
GETNAMEPATHBYIDPATH(M.PATHNAME || '\' || D.OBJ_ID) PATHNAME,
C.CLS_DISP_NAME DISNAME
FROM (SELECT ASS.A, ASS.B
FROM OLIVE.OL$_ASSOCIATIONS ASS
START WITH ASS.A = :1 ---- ¶¥²ãÉ豸ÈÝÆ÷id
CONNECT BY PRIOR ASS.B = A) E,
OLIVE.V$_ST_ASSET D,
OLIVE.OL$_CLASSES C,
OLIVE.V$_ST_IDENTIFIEDOBJECT M
WHERE D.OBJ_ID = E.B
AND M.OBJ_ID = E.A
AND D.CLS_URI IN(:2)
AND D.NAME LIKE :3
AND C.CLS_URI = D.CLS_URI
AND D.ASSETSSTATUS = 'S'
AND D.ORGID = :4) E
ORDER BY E.PATHNAME |
| 91d0kuahyy84b | SELECT tmp.*
FROM (SELECT l.obj_id id,
l.name,
l.orgid org_no,
(SELECT o.org_name FROM sgpm.o_org o WHERE o.org_no = l.orgid) org_name, l.pathname path_name,
length(l.pathname) / 65 - 4 tree_level,
l.voltagelevel voltage_level,
l.tconnectid branch_dist_line_node_id,
(SELECT p.lpsequence
FROM olive.v$_st_transmispoleposition p
WHERE l.tconnectid = p.obj_id
AND p.resourcestatus = :1) branch_node_lpsequence,
olive.ol$_object_util.getparentid(l.pathname) parent_distline_id,
l.starsubstation substation_id,
l.kgbh dist_breaker_id
FROM olive.v$_st_feeder l
WHERE l.pathname LIKE :2
AND l.resourcestatus = :3) tmp
ORDER BY tmp.tree_level ASC, tmp.branch_node_lpsequence ASC |
| 93dtuy0vt2k7q | SELECT task_id FROM p_task WHERE set_emp_no = :1 AND content LIKE '%methodName=notifyDeskMessage%' |
| 95jvxjj84rcct | select /*+ index(o PK_OL$_OBJECTS) */ * from v$_MeterBox o where obj_id=:1 |
| 95ugsq968zru6 | SELECT T.ORG_NAME FROM SGPM.O_ORG T WHERE T.ORG_NO = SUBSTR(:B1 , 0, 5) |
| 964zgsudcdac7 | SELECT D.ATTR_URI FROM OL$_ATTR_DEFS D WHERE D.CLS_URI = :B2 AND D.ATTR_NAME = :B1 |
| 96g93hntrzjtr | select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2 |
| 9g4jrwq86jnb7 | BEGIN
OL$_RULE_CORE.CHECKANDUPDATELOWERNAME(:1);
END; |
| 9qgtwh66xg6nz | update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3 |
| 9rn5ah9npmbc8 | WITH CLS_LIST AS (SELECT (SELECT CLS_ID FROM OL$_CLASSES WHERE CLS_URI = C.CLS_URI) CLS_ID, MAIN_ID, C.LINE_TYPE 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 UP_TARGET_CLS = :B1 AND UPPER(UP_COL) = 'NAME' AND RULE_TYPE = 'C1' AND RULE_ID = D.RULE_ID))), OBJ_LIST AS (SELECT B OBJ_ID, (SELECT S_01 FROM OL$_OBJECTS WHERE OBJ_ID = B) NAME, LEVEL LEL FROM (SELECT T.* FROM OL$_ASSOCIATIONS T WHERE AST_URI = :B3 AND B LIKE SUBSTR(:B2 , 1, 32) || '%' AND A LIKE SUBSTR(:B2 , 1, 32) || '%' START WITH A = :B2 CONNECT BY PRIOR B = A) WHERE SUBSTR(B, 1, 32) IN (SELECT CLS_ID FROM CLS_LIST C) START WITH A = :B2 CONNECT BY PRIOR B = A)SELECT * FROM OBJ_LIST, CLS_LIST WHERE SUBSTR(OBJ_LIST.OBJ_ID, 1, 32) = CLS_LIST.CLS_ID AND DECODE(OBJ_LIST.LEL, 1, '02', '03') = CLS_LIST.LINE_TYPE |
| 9vrbr3jjprusn | SELECT B OBJ_ID, (SELECT S_01 FROM OL$_OBJECTS WHERE OBJ_ID = B) NAME FROM (SELECT T.*, LEVEL FROM OL$_ASSOCIATIONS T WHERE AST_URI = :B2 AND SUBSTR(B, 1, 32) != SUBSTR(:B1 , 1, 32) AND SUBSTR(DECODE(A, :B1 , '1', A), 1, 32) != SUBSTR(:B1 , 1, 32) START WITH A = :B1 CONNECT BY PRIOR B = A) WHERE 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 UP_TARGET_CLS = :B3 AND UPPER(UP_COL) = 'NAME' AND RULE_TYPE = 'C' AND RULE_ID = D.RULE_ID))) START WITH A = :B1 CONNECT BY PRIOR B = A |
| 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 |
| a3rvzd26ud0vu | DELETE INDYWF_WORKLIST_CUR WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND DEPT_NAME = :B1 |
| 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 |
| abhn803avcumh | SELECT A.USER_BUREAU_NAME FROM AMBER.INDY_USER A WHERE A.USER_NAME=UPPER(:B1 ) |
| apd7t7sfn2wxd | SELECT Getnamepathbyidpath(Pc.Pathname || Ass.Pathname) pathName, Pc.OBJ_ID resourceId FROM V$_ST_ASSET Ass, OL$_ASSOCIATIONS O, V$_ST_POWERSYSTEMRESOURCE Pc
WHERE Ass.OBJ_ID =:1 AND O.B = SUBSTR(Ass.PATHNAME, 2, 64)
AND Pc.OBJ_ID = O.A AND O.AST_URI =:2 |
| apsygukcr19bq | SELECT R.NAME, SUBSTRB(R.DISPLAY_NAME, 1, 360), SUBSTRB(R.DESCRIPTION, 1, 1000), R.NOTIFICATION_PREFERENCE, R.LANGUAGE, R.TERRITORY, SUBSTRB(R.EMAIL_ADDRESS, 1, 320), R.FAX, R.STATUS, R.EXPIRATION_DATE, R.ORIG_SYSTEM, R.ORIG_SYSTEM_ID FROM WF_ROLES R WHERE R.NAME = :B1 AND R.ORIG_SYSTEM NOT IN ('HZ_PARTY', 'POS', 'ENG_LIST', 'AMV_CHN', 'HZ_GROUP', 'CUST_CONT') |
| avjzuwm5npxv7 | select * from indy_menu where menu_id in ( select menu_id from indy_menu start with menu_id in ( select n.menu_id from indy_menu n where menu_state = '01' and n.action_normal = 'T' and n.action_id in ( select ua.action_id from indy_user_action ua where ua.user_id = :1 ) union all select m.menu_id from indy_menu m where menu_state = '01' and m.action_normal = 'T' and m.action_authorized = 'F' and m.action_id is not null ) connect by menu_id = prior menu_parent_id ) and menu_kind in ('MenuFolder', 'MenuItem') and decode(:2, menu_parent_id, 1, menu_grant_id, 1, 0) = 1 and menu_state = :3 order by menu_index |
| 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 |
| b3gxg1nhmrvnf | select /*+ index(o PK_OL$_OBJECTS) */ * from v$_ST_CountySubRegion o where obj_id=:1 |
| bsm6gmajgmhuu | select * from indy_menu where menu_id in ( select menu_id from indy_menu start with menu_id in ( select n.menu_id from indy_menu n where menu_state = '01' and n.action_normal = 'T' and n.action_id in ( select ua.action_id from indy_user_action ua where ua.user_id = :1 ) union all select m.menu_id from indy_menu m where menu_state = '01' and m.action_normal = 'T' and m.action_authorized = 'F' and m.action_id is not null ) connect by menu_id = prior menu_parent_id ) and menu_kind in ('MenuFolder', 'MenuItem') and menu_parent_id=:2 and menu_state = :3 order by menu_index |
| 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) |
| cfrwbnuu2xtam | select side_b from ol$_association_constraints where association_type = :1 and side_a = :2 |
| cjy09frsxfv7n | SELECT COUNT(*) FROM T_YXDZ_CZPBH WHERE PROCESSID IN (SELECT PROCESSID FROM T_YXDZ_CZPXX T WHERE JHRDM = :B3 AND TO_CHAR(NPSJ, 'yyyymm') = :B2 AND CZPZL = :B1 AND T.CZPBH IS NOT NULL) |
| cma6d053zrny3 | update ol$_objects set S_35 = :S_35, D_01 = :D_01, S_76 = :S_76, S_15 = :S_15, S_03 = :S_03, O_25 = :O_25, O_26 = :O_26, D_08 = :D_08, S_22 = :S_22, O_03 = :O_03, S_21 = :S_21, N_07 = :N_07, S_36 = :S_36, O_07 = :O_07, O_24 = :O_24, N_42 = :N_42, S_04 = :S_04, O_29 = :O_29, O_27 = :O_27, N_09 = :N_09, O_31 = :O_31, D_03 = :D_03, S_02 = :S_02, S_05 = :S_05, O_01 = :O_01, N_10 = :N_10, O_05 = :O_05, D_05 = :D_05, D_04 = :D_04, S_40 = :S_40, N_52 = :N_52, S_39 = :S_39, S_42 = :S_42, D_07 = :D_07, N_02 = :N_02, O_04 = :O_04, N_51 = :N_51, S_27 = :S_27, S_34 = :S_34, D_06 = :D_06, S_68 = :S_68, D_10 = :D_10, S_73 = :S_73, S_01 = :S_01, O_06 = :O_06, S_32 = :S_32, S_75 = :S_75, S_63 = :S_63, S_31 = :S_31 where obj_id = :objId |
| cr5dhraqryr2f | Insert Into V$_St_Transmispoleposition_Tem
Select /*+index(V$_St_Transmispoleposition, IDX_OL$_OBJECTS_CLS_PATHNAME)*/
V$_St_Transmispoleposition.*, 'D'
From V$_St_Transmispoleposition
Where Pathname Like :1
And Pathname = :2 ||Obj_Id
And Resourcestatus = 'E'
And Orgid= :3 |
| 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 )) |
| cv0rtthxrhdxy | SELECT O.S_04 || :B2 FROM OL$_ASSOCIATIONS A, OL$_OBJECTS O WHERE A.A = O.OBJ_ID AND A.B = :B1 AND ROWNUM = 1 |
| czknwx2xjru6y | SELECT COUNT(*) FROM T_YXDZ_CZPXX T WHERE JHRDM = :B3 AND TO_CHAR(NPSJ, 'yyyymm') = :B2 AND CZPZL = :B1 AND T.CZPBH IS NOT NULL |
| 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 ) |
| db78fxqxwxt7r | select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket |
| dbgctn9f6071v |
SELECT a.obj_id objid,
a.cls_uri,
a.orgid,
getorgnamebyorgno(a.orgid) org_name,
a.name linename,
a.voltagelevel volcode,
b.id,
b.count_date countDate,
b.active_power,
b.active_load,
b.reactive_load,
b.actual_line_lose,
b.actual_line_lose_rate,
b.academic_line_lose,
b.academic_line_lose_rate,
b.algorithm,
b.compute_date,
s.name qdbdz
FROM OLIVE.V$_ST_FEEDER a
LEFT JOIN (SELECT l.id,
l.line_id,
l.count_date,
l.active_power,
l.active_load,
l.reactive_load,
l.actual_line_lose,
l.actual_line_lose_rate,
l.academic_line_lose,
l.academic_line_lose_rate,
l.algorithm,
l.compute_date,
row_number() over(PARTITION BY line_id ORDER BY count_date DESC) count_date_ord
FROM T_YPJC_LINELOSE l
WHERE NOT EXISTS (SELECT 1
FROM t_ypjc_loss_expend_relation r
WHERE r.loss_id = l.id)
) b ON a.obj_id = b.line_id
AND b.count_date_ord = 1
LEFT JOIN olive.v$_st_substation s ON a.starsubstation = s.obj_id
WHERE a.resourcestatus = :1
AND length(a.pathname) = :2
AND a.orgid = :3
ORDER BY compute_date
|
| 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 ) |
| dpqpcqn109dcj | select * from st_institution_resource sr, olive.ol$_classes c
where sr.childresourcetype=c.cls_uri(+) and sr.INSTITUTIONID =:1 |
| dtun9pmgvp9a8 | SELECT COUNT(*) FROM T_YXDZ_CZPBH WHERE PROCESSID IN (SELECT PROCESSID FROM (SELECT T.PROCESSID, T.SHRDM, T.SHSJ FROM T_YXDZ_CZPXX T WHERE T.SHRDM LIKE '%' || :B3 || '%' AND TO_CHAR(T.SHSJ, 'yyyymm') = :B2 AND T.CZPZL = :B1 UNION SELECT H.PROCESSID, H.SHRID SHRDM, H.SHSJ FROM T_YXDZ_CZP_SHHJSHXX H, T_YXDZ_CZPXX X WHERE H.SHRID LIKE '%' || :B3 || '%' AND TO_CHAR(H.SHSJ, 'yyyymm') = :B2 AND H.PROCESSID = X.PROCESSID AND X.CZPZL = :B1 )) |
| dvqv84updkxnc | SELECT T.OBJ_ID, T.CLS_URI, T.LPSEQUENCE, (SELECT C.CLS_VIEW FROM OL$_CLASSES C WHERE C.CLS_URI = T.CLS_URI) CLS_VIEW FROM V$_ST_POSITION T, OL$_ASSOCIATIONS S WHERE T.OBJ_ID = S.B AND S.AST_URI = 'OLASSOCIATIONTYPE://ST_IdentifiedObject_ST_IdentifiedObject?A="OLCLASS://Entity/ST_IdentifiedObject"&B="OLCLASS://Entity/ST_IdentifiedObject"' AND T.LPSEQUENCE > :B3 AND S.A = :B2 AND T.ORGID = :B1 |
| f8pavn1bvsj7t | select con#, obj#, rcon#, enabled, nvl(defer, 0) from cdef$ where robj#=:1 |
| 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 |
| fasvw7q199577 | select u.name, o.name, t.update$, t.insert$, t.delete$, t.enabled from obj$ o, user$ u, trigger$ t where t.baseobject=:1 and t.obj#=o.obj# and o.owner#=u.user# and bitand(property, 16)=0 and bitand(property, 8)=0 order by o.obj# |
| fbg5fqdjsvbw9 | DELETE INDYWF_WORKLIST_COM WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND DEPT_NAME = :B1 |
| fc42s7rxq7chg | SELECT CLS_URI FROM OL$_CLASSES WHERE CLS_ID = :B1 |
| fdckt0yps3750 |
SELECT a.obj_id objid,
a.cls_uri,
a.orgid,
getorgnamebyorgno(a.orgid) org_name,
a.name linename,
a.voltagelevel volcode,
b.id,
b.count_date countDate,
b.active_power,
b.active_load,
b.reactive_load,
b.actual_line_lose,
b.actual_line_lose_rate,
b.academic_line_lose,
b.academic_line_lose_rate,
b.algorithm,
b.compute_date,
s.name qdbdz
FROM OLIVE.V$_ST_FEEDER a
LEFT JOIN (SELECT l.id,
l.line_id,
l.count_date,
l.active_power,
l.active_load,
l.reactive_load,
l.actual_line_lose,
l.actual_line_lose_rate,
l.academic_line_lose,
l.academic_line_lose_rate,
l.algorithm,
l.compute_date,
row_number() over(PARTITION BY line_id ORDER BY count_date DESC) count_date_ord
FROM T_YPJC_LINELOSE l
WHERE NOT EXISTS (SELECT 1
FROM t_ypjc_loss_expend_relation r
WHERE r.loss_id = l.id)
) b ON a.obj_id = b.line_id
AND b.count_date_ord = 1
LEFT JOIN olive.v$_st_substation s ON a.starsubstation = s.obj_id
WHERE a.resourcestatus = :1
AND length(a.pathname) = :2
AND a.orgid = :3
AND a.name LIKE :4
ORDER BY compute_date |
| ff40ndudptw4c | DELETE FROM INDY_ONLINE_USER WHERE LOG_LINK_ID=:B1 |
| fkg1futrvwzbg | SELECT COUNT(1) FROM OL$_ASSOCIATIONS ASS WHERE B = :B1 |
| 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; |
| g73tzgnm4722f | select u.name, o.name, trigger$.sys_evts, trigger$.type# from obj$ o, user$ u, trigger$ where bitand(trigger$.property, 16) = 16 and trigger$.baseobject = :1 and trigger$.obj# = o.obj# and o.owner# = u.user# order by o.obj# |
| gf8k0n5kg6hy2 | SELECT T.OBJ_ID, T.CLS_URI,
T.NAME, T.PATHNAME, GETNAMEPATHBYIDPATH(T.PATHNAME) PATHNAMEVALUE ,
T.RESOURCESTATUS, T.INSERVICEDATE,
T.VOLTAGELEVEL, T.LPSEQUENCE,
T.OPERATEDEPTID, T.XPOSITION, T.YPOSITION
FROM V$_ST_POSITION T, OL$_ASSOCIATIONS S
WHERE T.OBJ_ID = S.B AND S.AST_URI = :1 AND S.A = :2 AND T.orgId='1340612'
AND RESOURCESTATUS= :3 |
| gkw6wc3pm09j6 | SELECT USER_NAME FROM AMBER.INDY_USER_ACTION U WHERE U.ACTION_NAME=:1 |
| grwydz59pu6mc | select text from view$ where rowid=:1 |