| SQL Id | SQL Text |
|---|
| 06vtacjatdsgn | SELECT SUM(bytes) FROM SYS.DBA_SEGMENTS WHERE UPPER(owner) = UPPER('AIOX') |
| 0kcz9apr14gar | insert into CD.CM_BUSI_201307(SO_NBR, OUTER_SO_NBR, BATCH_FLAG, PARENT_SO_NBR, REC_TYPE, BUSI_SPEC_ID, BUSI_CODE, CHANNEL, BUSI_DIRECT, OP_ID, PHONE_ID, RESOURCE_ID, ACCT_ID, CUST_ID, STS, CANCEL_DATE, ORIG_SO_NBR, DONE_DATE, OTC_FLAG, OTC_SO_NBR, REWARD_FLAG, REWARD_SO_NBR, AUTH_FLAG, AUTH_SO_NBR, SOURCE_SYSTEM, STEP_ID, SO_DATE, PROV_CODE, REGION_CODE, COUNTY_CODE, ORG_ID, IS_MONITOR, ISNORMAL, NOTIFY_FLAG, HOST, ERROR_CODE, ERROR_MESSAGE, COST_TIME, EXT1, EXT2, EXT3, EXT4, EXT5, EXT6) values(: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 ) |
| 13nn9tvh45avf | select p.value-s.value from v$parameter p, V$SYSSTAT s where p.name='sessions' and s.name='logons current' |
| 13u83qfzhh56a | SELECT S.TABLE_OWNER, S.TABLE_NAME FROM SYS.ALL_SYNONYMS S WHERE S.SYNONYM_NAME = :B1 AND S.OWNER = 'PUBLIC' AND ROWNUM = 1 |
| 1f964qa21d6z2 | declare
sql_str varchar2(1024);
begin
for i in 0.. 100000 loop
sql_str := 'insert into AD.CA_QUEUE_CRECTRL_W_0_2 select t.seq_num-'||i||', t.acct_id, t.obb_string, t.deal_date, t.deal_sts, t.create_date, t.module_type, t.remark from AD.CA_QUEUE_CRECTRL_W_0_3_bak_jgh t' ;
execute immediate sql_str;
end loop;
commit;
end;
|
| 236pb8q6nxc29 | select t.* from CD.CM_CUSTOMER_40 t where t.CUST_ID=:1 and t.EXPIRE_DATE>:2 |
| 2f0fc8gbstcyx | SELECT SUM(bytes/initial_extent) FROM DBA_TABLESPACES ts, DBA_FREE_SPACE fs WHERE ts.tablespace_name = fs.tablespace_name AND ts.tablespace_name='DATA01' |
| 2rfkk0mnyb0jw | select FLOW_ID, FLOW_NAME, FLOW_STATE, FLOW_TB_NAME_REPORTED, FLOW_START_TIME, PARENT_FLOW_ID, FLOW_PARAM, START_ROLLBACK_MSG_TYPE, START_ROLLBACK_PARAM, STOP_ROLLBACK_MSG_TYPE, STOP_ROLLBACK_PARAM, FLOW_HAVE_TB from RDC_FLOW where FLOW_ID = :0 |
| 2yq5ysnm9jwgh |
SELECT USER_OPERATOR_ID||':'||STS||':'||BRAND_ID||':'||CUSTOMER_SEGMENT||':'||AGEING||':'||ROAM_TYPE_ID||':'||CALL_TYPE_ID AS KEY1, WILDCARD, SEG_ID, POLICY_ID, ACTION_ID, PRIORITY, ACCEPT_FLAG, IS_EXPORT_XDR, RATING_FLAG, ALARM_ID, ACTION_CODE, PRIORITY_ACTION, PROCESS_FLAG, TIME_MODE, START_VAL, END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM ( SELECT 5 AS WILDCARD, A.USER_OPERATOR_ID, A.STS, A.BRAND_ID, A.CUSTOMER_SEGMENT, A.AGEING, A.CALL_TYPE_ID, A.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID != -1 AND A.CUSTOMER_SEGMENT != -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID !=0 UNION ALL SELECT 4 AS WILDCARD, A.USER_OPERATOR_ID, A.STS, E.BRAND_ID, A.CUSTOMER_SEGMENT, A.AGEING, A.CALL_TYPE_ID, A.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORI
TY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND E WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID = -1 AND A.CUSTOMER_SEGMENT != -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID !=0 UNION ALL SELECT 4 AS WILDCARD, A.USER_OPERATOR_ID, A.STS, A.BRAND_ID, F.CUSTOMER_SEGMENT, A.AGEING, A.CALL_TYPE_ID, A.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, SD.SYS_CUSTOMER_SEGMENT_DEF F WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID != -1 AND A.CUSTOMER_SEGMENT = -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID !=0 UNION ALL SELECT 4 AS WILDCARD, A.USER_OPERATOR_ID, A.STS, A.BRAND_ID, A.CUSTOMER_SEGMENT, A.AGEING, TO_NUMBER(G.CALL_TYPE_ID), A.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG,
C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID != -1 AND A.CUSTOMER_SEGMENT != -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID !=0 UNION ALL SELECT 4 AS WILDCARD, A.USER_OPERATOR_ID, A.STS, A.BRAND_ID, A.CUSTOMER_SEGMENT, A.AGEING, A.CALL_TYPE_ID, H.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, BD.RS_SYS_ELEMENT_ROAM_TYPE H WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID != -1 AND A.CUSTOMER_SEGMENT != -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID !=0 UNION ALL SELECT 3 AS WILDCARD, A.USER_OPERATOR_ID, A.STS, E.BRAND_ID, F.CUSTOMER_SEGMENT, A.AGEING, A.CALL_TYPE_ID, A.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY A
S PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND E, SD.SYS_CUSTOMER_SEGMENT_DEF F WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID = -1 AND A.CUSTOMER_SEGMENT = -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID !=0 UNION ALL SELECT 3 AS WILDCARD, A.USER_OPERATOR_ID, A.STS, E.BRAND_ID, A.CUSTOMER_SEGMENT, A.AGEING, TO_NUMBER(G.CALL_TYPE_ID), A.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND E, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID = -1 AND A.CUSTOMER_SEGMENT != -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID !=0 UNION ALL SELECT 3 AS WILDCARD, A.USER_OPERATOR_ID, A.STS, E.BRAND_ID, A.CUSTOMER_SEGMENT, A.AGEING, A.CALL_TYPE_ID, H.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG,
B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND E, BD.RS_SYS_ELEMENT_ROAM_TYPE H WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID = -1 AND A.CUSTOMER_SEGMENT != -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID !=0 UNION ALL SELECT 3 AS WILDCARD, A.USER_OPERATOR_ID, A.STS, A.BRAND_ID, F.CUSTOMER_SEGMENT, A.AGEING, TO_NUMBER(G.CALL_TYPE_ID), A.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, SD.SYS_CUSTOMER_SEGMENT_DEF F, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID != -1 AND A.CUSTOMER_SEGMENT = -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID !=0 UNION ALL SELECT 3 AS WILDCARD, A.USER_OPERATOR_ID, A.STS, A.BRAND_ID, F.CUSTOMER_SEGMENT, A.AGEING, A.CALL_TY
PE_ID, H.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, SD.SYS_CUSTOMER_SEGMENT_DEF F, BD.RS_SYS_ELEMENT_ROAM_TYPE H WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID != -1 AND A.CUSTOMER_SEGMENT = -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID !=0 UNION ALL SELECT 3 AS WILDCARD, A.USER_OPERATOR_ID, A.STS, A.BRAND_ID, A.CUSTOMER_SEGMENT, A.AGEING, TO_NUMBER(G.CALL_TYPE_ID), H.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, BD.RS_SYS_ELEMENT_ROAM_TYPE H WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID != -1 AND A.CUSTOMER_SEGMENT != -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID !=0 UNION AL
L SELECT 2 AS WILDCARD, A.USER_OPERATOR_ID, A.STS, E.BRAND_ID, F.CUSTOMER_SEGMENT, A.AGEING, TO_NUMBER(G.CALL_TYPE_ID), A.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND E, SD.SYS_CUSTOMER_SEGMENT_DEF F, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID = -1 AND A.CUSTOMER_SEGMENT = -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID !=0 UNION ALL SELECT 2 AS WILDCARD, A.USER_OPERATOR_ID, A.STS, E.BRAND_ID, F.CUSTOMER_SEGMENT, A.AGEING, A.CALL_TYPE_ID, H.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND E, SD.SYS_CUSTOMER_SEGMENT_DEF F, BD.RS_SYS_ELEMENT_ROAM_TYPE H WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.S
EG_ID AND A.BRAND_ID = -1 AND A.CUSTOMER_SEGMENT = -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID !=0 UNION ALL SELECT 2 AS WILDCARD, A.USER_OPERATOR_ID, A.STS, E.BRAND_ID, A.CUSTOMER_SEGMENT, A.AGEING, TO_NUMBER(G.CALL_TYPE_ID), H.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND E, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, BD.RS_SYS_ELEMENT_ROAM_TYPE H WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID = -1 AND A.CUSTOMER_SEGMENT != -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID !=0 UNION ALL SELECT 2 AS WILDCARD, A.USER_OPERATOR_ID, A.STS, A.BRAND_ID, F.CUSTOMER_SEGMENT, A.AGEING, TO_NUMBER(G.CALL_TYPE_ID), H.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, SD.
SYS_CUSTOMER_SEGMENT_DEF F, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, BD.RS_SYS_ELEMENT_ROAM_TYPE H WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID != -1 AND A.CUSTOMER_SEGMENT = -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID !=0 UNION ALL SELECT 1 AS WILDCARD, A.USER_OPERATOR_ID, A.STS, E.BRAND_ID, F.CUSTOMER_SEGMENT, A.AGEING, TO_NUMBER(G.CALL_TYPE_ID), H.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND E, SD.SYS_CUSTOMER_SEGMENT_DEF F, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, BD.RS_SYS_ELEMENT_ROAM_TYPE H WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID = -1 AND A.CUSTOMER_SEGMENT = -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID !=0 UNION ALL SELECT 5 AS WILDCARD, K.OPERATOR_ID AS USER_OPERATOR_ID, A.STS, A.BRAND_ID, A.CUSTOMER_SEGMENT, A.AGEING, A.CALL_TYPE_ID, A.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RA
TING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, (select OPERATOR_ID from SD.sys_operator_def where operator_type = 3) K WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID != -1 AND A.CUSTOMER_SEGMENT != -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT 4 AS WILDCARD, K.OPERATOR_ID AS USER_OPERATOR_ID, A.STS, E.BRAND_ID, A.CUSTOMER_SEGMENT, A.AGEING, A.CALL_TYPE_ID, A.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND E, (select OPERATOR_ID from SD.sys_operator_def where operator_type = 3) K WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID = -1 AND A.CUSTOMER_SEGMENT != -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT 4 AS WILDCARD, K.OPERATOR_ID AS USER_OPERATOR_ID, A.STS, A.BRAND_ID, F.CUSTOMER_SEGMENT, A.AGEING, A.CALL_TYPE_ID, A.ROAM_TYP
E_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, SD.SYS_CUSTOMER_SEGMENT_DEF F, (select OPERATOR_ID from SD.sys_operator_def where operator_type = 3) K WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID != -1 AND A.CUSTOMER_SEGMENT = -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT 4 AS WILDCARD, K.OPERATOR_ID AS USER_OPERATOR_ID, A.STS, A.BRAND_ID, A.CUSTOMER_SEGMENT, A.AGEING, TO_NUMBER(G.CALL_TYPE_ID), A.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, (select OPERATOR_ID from SD.sys_operator_def where operator_type = 3) K WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID != -1 AND A.CUSTOMER_SEGMENT != -1 A
ND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT 4 AS WILDCARD, K.OPERATOR_ID AS USER_OPERATOR_ID, A.STS, A.BRAND_ID, A.CUSTOMER_SEGMENT, A.AGEING, A.CALL_TYPE_ID, H.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, BD.RS_SYS_ELEMENT_ROAM_TYPE H, (select OPERATOR_ID from SD.sys_operator_def where operator_type = 3) K WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID != -1 AND A.CUSTOMER_SEGMENT != -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT 3 AS WILDCARD, K.OPERATOR_ID AS USER_OPERATOR_ID, A.STS, E.BRAND_ID, F.CUSTOMER_SEGMENT, A.AGEING, A.CALL_TYPE_ID, A.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND E, SD.SYS_CUSTOMER_SEGMENT_DEF F, (select OPERATOR_ID from SD.sys_operator_de
f where operator_type = 3) K WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID = -1 AND A.CUSTOMER_SEGMENT = -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT 3 AS WILDCARD, K.OPERATOR_ID AS USER_OPERATOR_ID, A.STS, E.BRAND_ID, A.CUSTOMER_SEGMENT, A.AGEING, TO_NUMBER(G.CALL_TYPE_ID), A.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND E, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, (select OPERATOR_ID from SD.sys_operator_def where operator_type = 3) K WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID = -1 AND A.CUSTOMER_SEGMENT != -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT 3 AS WILDCARD, K.OPERATOR_ID AS USER_OPERATOR_ID, A.STS, E.BRAND_ID, A.CUSTOMER_SEGMENT, A.AGEING, A.CALL_TYPE_ID, H.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D
.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND E, BD.RS_SYS_ELEMENT_ROAM_TYPE H, (select OPERATOR_ID from SD.sys_operator_def where operator_type = 3) K WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID = -1 AND A.CUSTOMER_SEGMENT != -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT 3 AS WILDCARD, K.OPERATOR_ID AS USER_OPERATOR_ID, A.STS, A.BRAND_ID, F.CUSTOMER_SEGMENT, A.AGEING, TO_NUMBER(G.CALL_TYPE_ID), A.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, SD.SYS_CUSTOMER_SEGMENT_DEF F, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, (select OPERATOR_ID from SD.sys_operator_def where operator_type = 3) K WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID != -1 AND A.CUSTOMER_SEGMENT = -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT 3 AS WILDCARD, K.OPERATOR_ID AS USER_OPERATOR_ID, A.STS, A.
BRAND_ID, F.CUSTOMER_SEGMENT, A.AGEING, A.CALL_TYPE_ID, H.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, SD.SYS_CUSTOMER_SEGMENT_DEF F, BD.RS_SYS_ELEMENT_ROAM_TYPE H, (select OPERATOR_ID from SD.sys_operator_def where operator_type = 3) K WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID != -1 AND A.CUSTOMER_SEGMENT = -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT 3 AS WILDCARD, K.OPERATOR_ID AS USER_OPERATOR_ID, A.STS, A.BRAND_ID, A.CUSTOMER_SEGMENT, A.AGEING, TO_NUMBER(G.CALL_TYPE_ID), H.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, BD.RS_SYS_ELEMENT_ROAM_TYPE H, (select OPERATOR_ID from SD.sys_operator_def where operator_type = 3)
K WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID != -1 AND A.CUSTOMER_SEGMENT != -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT 2 AS WILDCARD, K.OPERATOR_ID AS USER_OPERATOR_ID, A.STS, E.BRAND_ID, F.CUSTOMER_SEGMENT, A.AGEING, TO_NUMBER(G.CALL_TYPE_ID), A.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND E, SD.SYS_CUSTOMER_SEGMENT_DEF F, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, (select OPERATOR_ID from SD.sys_operator_def where operator_type = 3) K WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID = -1 AND A.CUSTOMER_SEGMENT = -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT 2 AS WILDCARD, K.OPERATOR_ID AS USER_OPERATOR_ID, A.STS, E.BRAND_ID, F.CUSTOMER_SEGMENT, A.AGEING, A.CALL_TYPE_ID, H.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE
, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND E, SD.SYS_CUSTOMER_SEGMENT_DEF F, BD.RS_SYS_ELEMENT_ROAM_TYPE H, (select OPERATOR_ID from SD.sys_operator_def where operator_type = 3) K WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID = -1 AND A.CUSTOMER_SEGMENT = -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT 2 AS WILDCARD, K.OPERATOR_ID AS USER_OPERATOR_ID, A.STS, E.BRAND_ID, A.CUSTOMER_SEGMENT, A.AGEING, TO_NUMBER(G.CALL_TYPE_ID), H.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND E, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, BD.RS_SYS_ELEMENT_ROAM_TYPE H, (select OPERATOR_ID from SD.sys_operator_def where operator_type = 3) K WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID = -1 AND A.CUSTOMER_SEGMENT != -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT 2 AS WILDCAR
D, K.OPERATOR_ID AS USER_OPERATOR_ID, A.STS, A.BRAND_ID, F.CUSTOMER_SEGMENT, A.AGEING, TO_NUMBER(G.CALL_TYPE_ID), H.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, SD.SYS_CUSTOMER_SEGMENT_DEF F, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, BD.RS_SYS_ELEMENT_ROAM_TYPE H, (select OPERATOR_ID from SD.sys_operator_def where operator_type = 3) K WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID != -1 AND A.CUSTOMER_SEGMENT = -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT 1 AS WILDCARD, K.OPERATOR_ID AS USER_OPERATOR_ID, A.STS, E.BRAND_ID, F.CUSTOMER_SEGMENT, A.AGEING, TO_NUMBER(G.CALL_TYPE_ID), H.ROAM_TYPE_ID, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, A.PRIORITY, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, A.VALID_DATE, A.EXPIRE_DATE FROM BD.RS_SYS_RESOURCE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND E, SD.SYS_CUSTOMER_SEGMENT_DE
F F, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, BD.RS_SYS_ELEMENT_ROAM_TYPE H, (select OPERATOR_ID from SD.sys_operator_def where operator_type = 3) K WHERE A.ACTION_ID = B.ACTION_ID AND A.SEG_ID = C.SEG_ID AND C.SEG_ID = D.SEG_ID AND A.BRAND_ID = -1 AND A.CUSTOMER_SEGMENT = -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID = 0 ) T ORDER BY T.PRIORITY DESC, T.WILDCARD DESC |
| 304jwdgs4jb5u | select HANDLE_RATE from id.RDC_TS_HANDLE_RATE where srv_id = :1 AND PROC_ID = :2 AND UPDATE_TIME = (select max(UPDATE_TIME) from id.RDC_TS_HANDLE_RATE where srv_id = :3 AND PROC_ID = :4 ) |
| 35wycwk1jhyk5 | SELECT SUM(bytes) FROM SYS.DBA_SEGMENTS WHERE UPPER(owner) = UPPER('SYS') |
| 3p5y5gwf7xvvg | SELECT SUM(bytes) FROM SYS.DBA_SEGMENTS WHERE UPPER(owner) = UPPER('SD') |
| 3uf21fzvtv3ds | insert into CD.OCS_EVENT (EVENT_ID, ACCT_ID, USER_ID, PHONE_ID, EVENT_TYPE, COMMIT_DATE, SRC, SO_NBR ) values(:0 , :2 , :3 , :4 , :5 , :7 , :8 , :9 ) |
| 42u72h67qckgp | SELECT TRANSACTION_ID, SEQ_ID, SOURCE_SYSTEM, REQUEST_XML, RESPONSE_XML, REQUEST_BMP, RESPONSE_BMP, REQUEST_API, RESPONSE_API FROM BSS_BROKER_XML WHERE (((SEQ_ID = :1 ) AND (SOURCE_SYSTEM = :2 )) AND (TRANSACTION_ID = :3 )) |
| 5pd1z587dr240 | update id.dbm_warn_log set notify_state = :1 where log_id = :2 |
| 5rsrrnc8mmcaq | insert into CD.OCS_STS_CHG (USER_ID, ACCT_ID, OLD_AMOUNT, NEW_AMOUNT, BILLING_TYPE, TRIGGER_EVENT_TYPE, COMMIT_DATE, EVENT_ID ) values(:0 , :1 , :3 , :4 , :5 , :6 , :7 , :11 ) |
| 6fh680j7gvkws | SELECT RESOURCE_ID, ACCT_ID, EFFECTIVE_DATE from ZD.SYS_SITE_ROUTER_RESOURCEID WHERE RESOURCE_ID=:1 |
| 6ny3bhrdqvzd0 | SELECT COUNT(*) FROM SYS.DBA_INDEXES WHERE UPPER(owner) = UPPER('SYS')AND UPPER(STATUS) <> UPPER('VALID') |
| 6upxxxcd0zqsk |
with sess as (
select a.seq#,
a.event,
a.p1text,
decode(a.p1text, 'address', 'A',
'file#', 'f# ',
'requests', 'Req',
'count', 'Cnt',
'name|mode', 'n|m',
'files', 'fil',
'buffer#', 'Buf# ',
'handle address', 'hdlA', --library cache lock
'object address', 'ObjA', --library cache load lock
'file number', 'filN', --direct path read
a.p1text)
||': '||
decode(a.event, 'enqueue', chr(bitand(a.P1, -16777216)/16777215)||chr(bitand(a.P1, 16711680)/65535)||'|'||mod(a.P1, 65536), a.p1 ) p1,
a.p1raw,
a.p2text,
decode(a.p2text, 'block#', 'bk# ',
'number', 'nbr ',
null, ' ',
'blocks', 'blks',
'interrupt', 'itrp',
'pin address', 'pinA', --library cache pin
'lock address', 'lckA', --library cache lock
'first dba', 'first dba', --direct path read
a.p2text)||': '|| a.p2 p2,
a.p2raw,
a.p3text,
decode(a.p3text, 'blocks', 'bks',
'timeout', 'tot',
'tries', 'try',
'le', 'le ',
'id', 'id ',
'requests', 'req',
null, ' ',
'100*mode+namespace', '100*mode+NS', --library cache pin / library cache lock
'100*mask+namespace', '100*mask+NS', --library cache load lock
a.p3text)||': '|| a.p3 p3,
a.p3raw,
a.wait_time,
a.seconds_in_wait,
b.inst_id,
b.saddr,
b.sid,
b.serial#,
-- only 10g:...
--b.BLOCKING_INST
ANCE||'-'||b.BLOCKING_SESSION||'-'||b.BLOCKING_SESSION_STATUS blocker,
-- only 10g:^^^
b.paddr,
b.user#,
b.username,
decode(to_char(b.command),
'-67', 'MERGE',
'1', 'C-TAB', '2', 'INS', '3', 'SEL', '4', 'C-CLU', '5', 'A-CLU',
'6', 'UPD', '7', 'DEL', '8', 'D-CLU', '9', 'C-IND', '10', 'D-IND',
'11', 'A-IND', '12', 'D-TAB', '13', 'C-SEQ', '14', 'A-SEQ', '15', 'A-TAB',
'16', 'D-SEQ', '17', 'GRANT OBJ', '18', 'REVOKE OBJ', '19', 'C-SYNONYM', '20', 'D-SYN',
'21', 'C-VIEW', '22', 'D-VIEW', '23', 'VALIDATE INDEX', '24', 'C-PROC', '25', 'A-PROC',
'26', 'LOCK', '27', 'NO-OP', '28', 'RENAME', '29', 'COMMENT', '30', 'AUDIT OBJ',
'31', 'NOAUDIT OBJECT', '32', 'C-DBLINK', '33', 'D-DBLINK', '34', 'C-DB', '35', 'A-DB',
'36', 'C-RBSEG', '37', 'A-RBSEG', '38', 'D-RBSEG', '39', 'C-TBS', '40', 'A-TBS',
'41', 'D-TBS', '42', 'A-SESS', '43', 'A-USER', '44', 'COMMIT', '45', 'RB',
'46', 'SAVEPOINT', '47', 'PLSQL', '48', 'SET TRANS', '49', 'A-SYSTEM', '50', 'EXPLN',
'51', 'C-USER', '52', 'C-ROLE', '53', 'D-USER', '54', 'D-ROLE', '55', 'SET ROLE',
'56', 'C-SCHEMA', '57', 'C-CTRL FILE', '59', 'C-TRI', '60', 'A-TRIGGER',
'61', 'D-TRI', '62', 'ANA-TAB', '63', 'ANA-IND', '64', 'ANA-CLU', '65', 'C-PROFILE',
'66', 'D-PROFILE', '67', 'A-PROFILE', '68', 'D-PROC', '77', 'C-TYPE', '78',
'D-TYPE', '79', 'A-ROLE', '80', 'A-TYPE',
'81', 'C-TYPE BODY', '82', 'A-TYPE BODY', '83', 'D-TYPE BODY', '84', 'D-LIBRARY', '85', 'TRUNCATE TABLE',
'86', 'T-CLU',
'91', 'C-FUNC', '92', 'A-FUNC', '93', 'D-FUNC', '94', 'C-PACK', '95', 'A-PACK',
'96', 'D-PACK', '97', 'C-PACK BODY', '98', 'A-PACK BODY', '99', 'D-PACK BODY', '100', 'LOGON',
'101', 'LOGOFF', '102', 'LOGOFF BY CLEANUP', '103', 'SESSION REC', '104', 'SYSTEM AUDIT', '105', 'SYSTEM NOAUDIT',
'106', 'AUDIT DEFAULT', '107', 'NOAUDIT DEFAULT', '108', 'SYSTEM GRANT', '109', 'SYSTEM REVOKE', '110', 'C-PUB SYN',
'111', 'D-PUB SYN', '112', 'C-PUB DBLINK', '113', 'D-PUB DBLINK', '114', 'GRANT ROLE', '115', 'REVOKE ROLE',
'116', 'EXEC PROC', '117', 'USER COMMENT', '118', 'ENA TRI', '119', 'DIS TRI',
to_char(b.command)) cmd,
b.ownerid,
b.taddr,
b.lockwait,
--rpad(decode(a.state, 'WAITED KNOWN TIME', 'KT', 'WAITED SHORT TIME', 'ST', 'WAITING', 'W', a.state ), 2)||':'||a.seconds_in_wait wait_sec,
--10g:...
decode(a.wait_time,
0, 'W-ing:'||a.SECONDS_IN_WAIT,
-1, 'LW<0.01',
-2, 'LWUKN',
'A:'||(a.SECONDS_IN_WAIT-a.wait_time/100)) wait_sec,
--10g:^^^
b.server,
b.schema#,
b.schemaname,
b.osuser,
b.process,
b.machine,
b.terminal,
decode(instr(b.program, ' (TNS V1-V3)'), 0, b.PROGRAM, substr(b.program, 1,
instr(b.program, ' (TNS V1-V3)'))) program,
b.type,
b.sql_address,
b.sql_hash_value,
b.prev_sql_addr,
b.prev_hash_value,
b.module,
b.module_hash,
b.action,
b.action_hash,
b.client_info,
b.fixed_table_sequence,
b.row_wait_obj#,
b.row_wait_file#,
b.row_wait_block#,
b.row_wait_row#,
b.logon_time,
b.last_call_et,
b.pdml_enabled,
b.failover_type,
b.failover_method,
b.failed_over,
b.resource_consumer_group,
b.pddl_status,
b.pdml_status,
b.pq_status,
b.current_queue_duration,
b.client_identifier
from gv$session_wait a,
gv$session b
where a.event not IN (
'smon timer', 'pmon timer', 'rdbms ipc message', 'Null event', 'parallel query dequeue', 'pipe get',
'client message', 'SQL*Net message to client', 'SQL*Net message from client',
--'SQL*Net more data from client',
'dispatcher timer', 'virtual circuit status', 'lock manager wait for remote message', 'PX Idle Wait',
'PX Deq: Execution Msg', 'PX Deq: Table Q Normal', 'PX Deq: reap credit',
'wakeup time manager', 'slave wait', 'i/o slave wait', 'jobq slave wait',
'null event', 'gcs remote message', 'gcs for action', 'ges remote message', 'queue messages',
--'SQL*Net more data to client
', 'control file sequential read',
'Streams AQ: waiting for time management or cleanup tasks',
'Streams AQ: qmn slave idle wait',
'Streams AQ: qmn coordinator idle wait',
'Streams AQ: waiting for messages in the queue',
'DIAG idle wait',
'PX Deq: Execute Reply' --?????, sess?????, ????????
, 'wait for unread message on broadcast channel' --11g
, 'VKTM Logical Idle Wait'
, 'Space Manager: slave idle wait'
, 'GCR sleep'
--, 'LNS ASYNC end of log'
, 'PING'
, 'xxxxxxxxxxxx'
)
AND b.SID = a.sid
and a.inst_id=b.inst_id
--and (lower(b.program) like lower('%&program%') or b.program is null)
--and lower(a.event) like lower('%&event%')
)
SELECT
s.inst_id i,
s.sid||', '||s.serial# sess,
decode(s.program, null, 'NULL(job??)', s.program) program,
s.event,
case when s.row_wait_obj#<=0 then
to_char(s.row_wait_obj#)
else
u.name||'.'||o.name||
'('||
s.ROW_WAIT_OBJ#||', '||
decode(o.type#, 1, 'I', 2, 'T', 3, 'CLU',
4, 'V', 5, 'SYN', 6, 'SEQ',
7, 'PROC', 8, 'FUNCTION', 9, 'PACK',
11, 'PACKAGE BODY', 12, 'TRIGGER',
13, 'TYPE', 14, 'TYPE BODY',
19, 'TP', 20, 'IP', 21, 'LOB',
22, 'LIBRARY', 23, 'DIRECTORY', 24, 'QUEUE',
28, 'JAVA SOURCE', 29, 'JAVA CLASS', 30, 'JAVA RESOURCE',
32, 'INDEXTYPE', 33, 'OPERATOR',
34, 'TABLE SUBPARTITION', 35, 'INDEX SUBPARTITION',
40, 'LOB PARTITION', 41, 'LOB SUBPARTITION',
42, 'MATERIALIZED VIEW',
43, 'DIMENSION',
44, 'CONTEXT', 46, 'RULE SET', 47, 'RESOURCE PLAN',
48, 'CONSUMER GROUP',
51, 'SUBSCRIPTION', 52, 'LOCATION',
55, 'XML SCHEMA', 56, 'JAVA DATA',
57, 'SECURITY PROFILE', 59, 'RULE',
62, 'EVALUATION CONTEXT',
'UNDEFINED') ||
')' end obj,
s.cmd,
s.sql_hash_value sql_hash,
s.wait_sec,
--only 10g...
--s.blocker,
--only 10g^^^
--s.wait_time w,
case when s.prev_hash_value = s.sql_hash_value then '=' else to_char(s.prev_hash_value) end prev_sql,
s.p1||';'||s.p2 p12,
s.p3,
s.ROW_WAIT_ROW# ,
s.row_wait_obj# ,
s.p1raw, s.p2raw, s.p3raw,
s.ROW_WAIT_FILE# file#,
s.MACHINE,
s.OSUSER,
s.seq#,
s.USER#,
s.SQL_ADDRESS,
s.PREV_SQL_ADDR
FROM sess s , sys.obj$ o , sys.user$ u
where s.row_wait_obj#=o.obj#(+)
and o.owner#=u.user#(+)
/*or
(s.row_wait_obj#<=0 and o.name ='DUAL' and o.owner#=1)*/
ORDER BY 3, 2, 1, i, P1, P2, P3
|
| 6wm3n4d7bnddg |
SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l ,
DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER B
Y source ASC, time_secs DESC, log_id ASC |
| 6xapk6h7z94ts |
SELECT A.USER_OPERATOR_ID||':'||A.STS||':'||A.SERVICE_SPEC_ID||':'||A.BRAND_ID||':'||A.CALL_TYPE_ID||':'||A.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID != -1 AND A.BRAND_ID != -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID != 0 UNION ALL SELECT A.USER_OPERATOR_ID||':'||A.STS||':'||E.SERVICE_SPEC_ID||':'||A.BRAND_ID||':'||A.CALL_TYPE_ID||':'||A.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE , B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_T
IME_SEG_DTL D, PD.PM_SERVICE_SPEC E WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID = -1 AND A.BRAND_ID != -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID != 0 UNION ALL SELECT A.USER_OPERATOR_ID||':'||A.STS||':'||A.SERVICE_SPEC_ID||':'||F.BRAND_ID||':'||A.CALL_TYPE_ID||':'||A.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND F WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID != -1 AND A.BRAND_ID = -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID != 0 UNION ALL SELECT A.USER_OPERATOR_ID||':'||A.STS||':'||A.SERVICE_SPEC_ID||':'||A.BRAND_ID||':'||G.CALL_TYPE_ID||':'||A.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1
925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID != -1 AND A.BRAND_ID != -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID != 0 UNION ALL SELECT A.USER_OPERATOR_ID||':'||A.STS||':'||A.SERVICE_SPEC_ID||':'||A.BRAND_ID||':'||A.CALL_TYPE_ID||':'||H.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, BD.RS_SYS_ELEMENT_ROAM_TYPE H WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID != -1 AND A.BRAND_ID != -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID != 0 UNION ALL SELECT
A.USER_OPERATOR_ID||':'||A.STS||':'||E.SERVICE_SPEC_ID||':'||F.BRAND_ID||':'||A.CALL_TYPE_ID||':'||A.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_SERVICE_SPEC E, PD.PM_BRAND F WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID = -1 AND A.BRAND_ID = -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID != 0 UNION ALL SELECT A.USER_OPERATOR_ID||':'||A.STS||':'||E.SERVICE_SPEC_ID||':'||A.BRAND_ID||':'||G.CALL_TYPE_ID||':'||A.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD
.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_SERVICE_SPEC E, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID = -1 AND A.BRAND_ID != -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID != 0 UNION ALL SELECT A.USER_OPERATOR_ID||':'||A.STS||':'||E.SERVICE_SPEC_ID||':'||A.BRAND_ID||':'||A.CALL_TYPE_ID||':'||H.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_SERVICE_SPEC E, BD.RS_SYS_ELEMENT_ROAM_TYPE H WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID = -1 AND A.BRAND_ID != -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID != 0 UNION ALL SELECT A.USER_OPERATOR_ID||':'||A.STS||':'||A.SERVICE_SPEC_ID||':'||F.BRAND_ID||':'||G.CALL_TYPE_ID||':'||A.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_X
DR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND F, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID != -1 AND A.BRAND_ID = -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID != 0 UNION ALL SELECT A.USER_OPERATOR_ID||':'||A.STS||':'||A.SERVICE_SPEC_ID||':'||F.BRAND_ID||':'||A.CALL_TYPE_ID||':'||H.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND F, BD.RS_SYS_ELEMENT_ROAM_TYPE H WHERE A.SEG_ID = C.SEG_
ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID != -1 AND A.BRAND_ID = -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID != 0 UNION ALL SELECT A.USER_OPERATOR_ID||':'||A.STS||':'||A.SERVICE_SPEC_ID||':'||A.BRAND_ID||':'||G.CALL_TYPE_ID||':'||H.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, BD.RS_SYS_ELEMENT_ROAM_TYPE H WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID != -1 AND A.BRAND_ID != -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID != 0 UNION ALL SELECT A.USER_OPERATOR_ID||':'||A.STS||':'||E.SERVICE_SPEC_ID||':'||F.BRAND_ID||':'||G.CALL_TYPE_ID||':'||A.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.
START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_SERVICE_SPEC E, PD.PM_BRAND F, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID = -1 AND A.BRAND_ID = -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID != 0 UNION ALL SELECT A.USER_OPERATOR_ID||':'||A.STS||':'||E.SERVICE_SPEC_ID||':'||F.BRAND_ID||':'||A.CALL_TYPE_ID||':'||H.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_SERVICE_SPEC E, PD.PM_BRAND F, BD.RS_SYS_ELEMENT_ROAM_TYPE H WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVI
CE_SPEC_ID = -1 AND A.BRAND_ID = -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID != 0 UNION ALL SELECT A.USER_OPERATOR_ID||':'||A.STS||':'||E.SERVICE_SPEC_ID||':'||A.BRAND_ID||':'||G.CALL_TYPE_ID||':'||H.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_SERVICE_SPEC E, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, BD.RS_SYS_ELEMENT_ROAM_TYPE H WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID = -1 AND A.BRAND_ID != -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID != 0 UNION ALL SELECT A.USER_OPERATOR_ID||':'||A.STS||':'||A.SERVICE_SPEC_ID||':'||F.BRAND_ID||':'||G.CALL_TYPE_ID||':'||H.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 A
S EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND F, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, BD.RS_SYS_ELEMENT_ROAM_TYPE H WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID != -1 AND A.BRAND_ID = -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID != 0 UNION ALL SELECT A.USER_OPERATOR_ID||':'||A.STS||':'||E.SERVICE_SPEC_ID||':'||F.BRAND_ID||':'||G.CALL_TYPE_ID||':'||H.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_SERVICE_SPEC E, PD.PM_BRAND F, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, BD.RS_SYS_ELEMENT_ROAM_TYPE H WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_
ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID = -1 AND A.BRAND_ID = -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID != 0 UNION ALL SELECT K.OPERATOR_ID||':'||A.STS||':'||A.SERVICE_SPEC_ID||':'||A.BRAND_ID||':'||A.CALL_TYPE_ID||':'||A.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, (SELECT OPERATOR_ID FROM SD.SYS_OPERATOR_DEF WHERE OPERATOR_TYPE= 3) K WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID != -1 AND A.BRAND_ID != -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT K.OPERATOR_ID||':'||A.STS||':'||E.SERVICE_SPEC_ID||':'||A.BRAND_ID||':'||A.CALL_TYPE_ID||':'||A.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE , B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER
(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_SERVICE_SPEC E, (SELECT OPERATOR_ID FROM SD.SYS_OPERATOR_DEF WHERE OPERATOR_TYPE= 3) K WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID = -1 AND A.BRAND_ID != -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT K.OPERATOR_ID||':'||A.STS||':'||A.SERVICE_SPEC_ID||':'||F.BRAND_ID||':'||A.CALL_TYPE_ID||':'||A.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND F, (SELECT OPERATOR_ID FROM SD.SYS_OPERATOR_DEF WHERE OPERATOR_TYPE= 3) K WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID != -1 AND A.BRAND_ID = -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID = 0 UNION A
LL SELECT K.OPERATOR_ID||':'||A.STS||':'||A.SERVICE_SPEC_ID||':'||A.BRAND_ID||':'||G.CALL_TYPE_ID||':'||A.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, (SELECT OPERATOR_ID FROM SD.SYS_OPERATOR_DEF WHERE OPERATOR_TYPE= 3) K WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID != -1 AND A.BRAND_ID != -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT K.OPERATOR_ID||':'||A.STS||':'||A.SERVICE_SPEC_ID||':'||A.BRAND_ID||':'||A.CALL_TYPE_ID||':'||H.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64,
TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, BD.RS_SYS_ELEMENT_ROAM_TYPE H, (SELECT OPERATOR_ID FROM SD.SYS_OPERATOR_DEF WHERE OPERATOR_TYPE= 3) K WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID != -1 AND A.BRAND_ID != -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT K.OPERATOR_ID||':'||A.STS||':'||E.SERVICE_SPEC_ID||':'||F.BRAND_ID||':'||A.CALL_TYPE_ID||':'||A.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_SERVICE_SPEC E, PD.PM_BRAND F, (SELECT OPERATOR_ID FROM SD.SYS_OPERATOR_DEF WHERE OPERATOR_TYPE= 3) K WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID = -1 AND A.BRAND_ID = -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT K.OPERATOR_ID||':'||A.S
TS||':'||E.SERVICE_SPEC_ID||':'||A.BRAND_ID||':'||G.CALL_TYPE_ID||':'||A.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_SERVICE_SPEC E, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, (SELECT OPERATOR_ID FROM SD.SYS_OPERATOR_DEF WHERE OPERATOR_TYPE= 3) K WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID = -1 AND A.BRAND_ID != -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT K.OPERATOR_ID||':'||A.STS||':'||E.SERVICE_SPEC_ID||':'||A.BRAND_ID||':'||A.CALL_TYPE_ID||':'||H.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(T
O_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_SERVICE_SPEC E, BD.RS_SYS_ELEMENT_ROAM_TYPE H, (SELECT OPERATOR_ID FROM SD.SYS_OPERATOR_DEF WHERE OPERATOR_TYPE= 3) K WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID = -1 AND A.BRAND_ID != -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT K.OPERATOR_ID||':'||A.STS||':'||A.SERVICE_SPEC_ID||':'||F.BRAND_ID||':'||G.CALL_TYPE_ID||':'||A.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND F, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, (SELECT OPERATOR_ID FROM SD.SYS_OPERATOR_DEF WHERE OPERATOR_TYPE= 3) K WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID != -1 AND A.BRAND_ID = -1 AND A.CALL_TYPE_ID = -1 AND
A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT K.OPERATOR_ID||':'||A.STS||':'||A.SERVICE_SPEC_ID||':'||F.BRAND_ID||':'||A.CALL_TYPE_ID||':'||H.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND F, BD.RS_SYS_ELEMENT_ROAM_TYPE H, (SELECT OPERATOR_ID FROM SD.SYS_OPERATOR_DEF WHERE OPERATOR_TYPE= 3) K WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID != -1 AND A.BRAND_ID = -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT K.OPERATOR_ID||':'||A.STS||':'||A.SERVICE_SPEC_ID||':'||A.BRAND_ID||':'||G.CALL_TYPE_ID||':'||H.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64,
TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, BD.RS_SYS_ELEMENT_ROAM_TYPE H, (SELECT OPERATOR_ID FROM SD.SYS_OPERATOR_DEF WHERE OPERATOR_TYPE= 3) K WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID != -1 AND A.BRAND_ID != -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT K.OPERATOR_ID||':'||A.STS||':'||E.SERVICE_SPEC_ID||':'||F.BRAND_ID||':'||G.CALL_TYPE_ID||':'||A.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_SERVICE_SPEC E, PD.PM_BRAND F, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, (SELECT OPERATOR_ID FROM SD.SYS_OPERATOR_DEF WHERE OPERATOR_TYPE= 3) K WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID =
D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID = -1 AND A.BRAND_ID = -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID != -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT K.OPERATOR_ID||':'||A.STS||':'||E.SERVICE_SPEC_ID||':'||F.BRAND_ID||':'||A.CALL_TYPE_ID||':'||H.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_SERVICE_SPEC E, PD.PM_BRAND F, BD.RS_SYS_ELEMENT_ROAM_TYPE H, (SELECT OPERATOR_ID FROM SD.SYS_OPERATOR_DEF WHERE OPERATOR_TYPE= 3) K WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID = -1 AND A.BRAND_ID = -1 AND A.CALL_TYPE_ID != -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT K.OPERATOR_ID||':'||A.STS||':'||E.SERVICE_SPEC_ID||':'||A.BRAND_ID||':'||G.CALL_TYPE_ID||':'||H.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VA
L, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_SERVICE_SPEC E, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, BD.RS_SYS_ELEMENT_ROAM_TYPE H, (SELECT OPERATOR_ID FROM SD.SYS_OPERATOR_DEF WHERE OPERATOR_TYPE= 3) K WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID = -1 AND A.BRAND_ID != -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT K.OPERATOR_ID||':'||A.STS||':'||A.SERVICE_SPEC_ID||':'||F.BRAND_ID||':'||G.CALL_TYPE_ID||':'||H.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_BRAND F, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G,
BD.RS_SYS_ELEMENT_ROAM_TYPE H, (SELECT OPERATOR_ID FROM SD.SYS_OPERATOR_DEF WHERE OPERATOR_TYPE= 3) K WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID != -1 AND A.BRAND_ID = -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID = 0 UNION ALL SELECT K.OPERATOR_ID||':'||A.STS||':'||E.SERVICE_SPEC_ID||':'||F.BRAND_ID||':'||G.CALL_TYPE_ID||':'||H.ROAM_TYPE_ID AS KEY1, A.SEG_ID, A.POLICY_ID, A.ACTION_ID, B.ACCEPT_FLAG, B.IS_EXPORT_XDR, B.RATING_FLAG, B.ALARM_ID, B.ACTION_CODE, B.PRIORITY AS PRIORITY_ACTION, B.PROCESS_FLAG, C.TIME_MODE, D.START_VAL, D.END_VAL, 1293856231 AS VALID_DATE_32, 1925008231 AS EXPIRE_DATE_32, TO_NUMBER(TO_CHAR(A.VALID_DATE, 'YYYYMMDDHH24MISS')) AS VALID_DATE_64, TO_NUMBER(TO_CHAR(A.EXPIRE_DATE, 'YYYYMMDDHH24MISS')) AS EXPIRE_DATE_64 FROM BD.RS_SYS_SERVICE_STATE_CTRL A, SD.SYS_ACTION_DEF B, SD.SYS_TIME_SEG_DEF C, SD.SYS_TIME_SEG_DTL D, PD.PM_SERVICE_SPEC E, PD.PM_BRAND F, ( select code_value as call_type_id from sd.sys_enum_data N where N.table_name='SYS_CALL_TYPE' ) G, BD.RS_SYS_ELEMENT_ROAM_TYPE H, (SELECT OPERATOR_ID FROM SD.SYS_OPERATOR_DEF WHERE OPERATOR_TYPE= 3) K WHERE A.SEG_ID = C.SEG_ID AND A.SEG_ID = D.SEG_ID AND A.ACTION_ID = B.ACTION_ID AND A.SERVICE_SPEC_ID = -1 AND A.BRAND_ID = -1 AND A.CALL_TYPE_ID = -1 AND A.ROAM_TYPE_ID = -1 AND A.USER_OPERATOR_ID = 0
|
| 72as46bznfuam | insert into AD.CA_RESCYC_REG_40(SO_NBR, PVALID_DATE, PEXPIRE_DATE, NVALID_DATE, NEXPIRE_DATE, RESOURCE_ID, PSTS, NSTS, UN_SO_NBR, DEAL_DATE, UN_DEAL_DATE, VALID_DATE, EXPIRE_DATE, CREATE_DATE, SO_DATE, OLD_SUSPEND_STOP_DATE, OLD_DISABLE_STOP_DATE, NEW_SUSPEND_STOP_DATE, NEW_DISABLE_STOP_DATE) values(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 ) |
| 7ku3hnjv7678h | insert into AD.CA_BUSI_REC_1_201307(SO_NBR, START_DATE, END_DATE, STS, PROV_CODE, REGION_CODE, COUNTY_CODE, ORG_ID, I_REGION_CODE, I_COUNTY_CODE, I_ORG_ID, BUSI_SPEC_ID, OP_ID, ACCT_ID, RESOURCE_ID, CHANNEL, ASSET_TYPE, ASSET_AMOUNT, MEASURE_ID, CALL_LOCATION, ERROR_CODE, REMARKS, FAIL_REASON, OUT_SO_DATE, OUT_SO_NBR, PHONE_ID, BUSI_PLAN_ID, RECHARGE_METHOD, OWNER_TYPE, SERVICE_ID, SOURCE_SYSTEM) values(: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 ) |
| 7ysx42ss4bp1j | SELECT TRANSACTION_ID, SEQ_ID, PHONE_ID, INTERFACE_ID, SOURCE_SYSTEM, SO_MODE, ORDER_ID, TRANSACTION_TYPE, TRANSACTION_SUB_TYPE, SUBMIT_DATE, BROKER_ERROR_CODE, BROKER_ERROR_MSG, BMP_START_DATE, BMP_FINISH_DATE, BMP_ERROR_CODE, BMP_ERROR_MSG, AIOB_START_DATE, AIOB_FINISH_DATE, AIOB_ERROR_CODE, AIOB_ERROR_MSG, RESPONSE_DATE, CREATED_BY, CREATED, LAST_UPD_BY, LAST_UPD, STATUS, ASYNC_STATUS, ASYNC_ERROR_CODE, ASYNC_ERROR_MSG FROM BSS_BROKER_STATUS WHERE (((SEQ_ID = :1 ) AND (SOURCE_SYSTEM = :2 )) AND (TRANSACTION_ID = :3 )) |
| 96n8kc3w0pgbs | SELECT SUM(bytes) FROM SYS.DBA_SEGMENTS WHERE UPPER(owner) = UPPER('ZD') |
| 98hrkqqcd4g7d | update CD.CM_RES_LIFECYCLE_40 set EXPIRE_DATE = :1 , NEXT_STS_EXPIREDATE = :2 , REC_STS = :3 where RESOURCE_ID=:4 and REC_STS=:5 and SO_NBR=:6 and STS=:7 |
| 99hw0d6y68qt4 | select t.* from CD.CM_RES_LIFECYCLE_40 t where t.RESOURCE_ID=:1 and t.REC_STS in (:2 , :3 ) |
| 9a6c6ax1cpa9g | select FLOW_HAVE_TB from RDC_FLOW where FLOW_ID = :0 |
| 9bb3rmgp4rq2v | insert into CD.IMS_RES_STS_SYNC(ID, RESOURCE_ID, ACCT_ID, PHONE_ID, PEXPIRE_DATE, NEXPIRE_DATE, PSTS, NSTS, PSUB_TYPE, NSUB_TYPE, PFRAULD_FLAG, NFRAULD_FLAG, PUSERREQUEST_FLAG, NUSERREQUEST_FLAG, REASON_CODE, PBALANCE, NBALANCE, SO_NBR, CREATE_DATE, STS, CHANGE_TIME, ERROR_MSG, ERROR_CODE, DEAL_COUNT, DEAL_DATE, NOTIFY_FLAG, OP_ID, ORG_ID) values(: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 ) |
| 9w59grwwhjrfx | select t.* from CD.CM_RES_IDENTITY_40 t where t.RESOURCE_ID=:1 and t.IDENTITY_TYPE=:2 and t.EXPIRE_DATE>:3 |
| 9z56x31083d5m | select t.* from AD.CA_MAIL_GROUP_LINK t where t.ACCT_ID=:1 and t.EXPIRE_DATE>:2 |
| ab3swhv5g138y |
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, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), 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, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 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.instance_id is null 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))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY'
)) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob
j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) 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 <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, 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 <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), 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, 4, 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 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 and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID |
| awc50ubwytcwd | insert into AD.CA_MAIL_GROUP_LINK(MAIL_GROUP_ID, ACCT_ID, CUST_ID, VALID_DATE, EXPIRE_DATE, SO_NBR, CREATE_DATE, SO_DATE) values(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 ) |
| b5fv7d8394my2 | SELECT SUM(bytes) FROM SYS.DBA_SEGMENTS WHERE UPPER(owner) = UPPER('MD') |
| b84cknyvnyq25 | update user$ set exptime=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :2), ltime=DECODE(to_char(:3, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :3), astatus = :4, lcount = :5 where user#=:1 |
| bacnaxp1tka0n | SELECT SUM(bytes) FROM SYS.DBA_SEGMENTS WHERE UPPER(owner) = UPPER('BSSBROKER') |
| bhcaxw4q507zk | select * from BD.RS_MOBILE_HEAD where expire_date >= sysdate AND number_head IS NOT NULL |
| bnv5f9dkj42nz | UPDATE BSS_BROKER_XML SET RESPONSE_XML = :1 , REQUEST_API = :2 , RESPONSE_API = :3 WHERE (((SEQ_ID = :4 ) AND (SOURCE_SYSTEM = :5 )) AND (TRANSACTION_ID = :6 )) |
| bunvx480ynf57 | SELECT 1 FROM DUAL |
| bvasnwzzn30w6 | select t.* from SD.SYS_CYCLE_PATTERN_DETAIL t where t.STS=:1 and t.PATTERN_ID=:2 |
| byc3rbgramtg8 | select t.* from AD.CA_ACCOUNT_40 t where t.ACCT_ID=:1 and t.EXPIRE_DATE>:2 |
| byxm9zakb0yd8 | SELECT COUNT(*) FROM SYS.DBA_TABLES WHERE UPPER(owner) = UPPER('UD')AND LAST_ANALYZED IS NULL |
| cnu8yzf3sy5ku | SELECT OBJECT_TYPE, USER, :B1 FROM SYS.ALL_OBJECTS WHERE OWNER = USER AND OBJECT_NAME = :B1 AND OBJECT_TYPE IN ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') AND ROWNUM = 1 |
| d3vdgnnm2x4f7 | SELECT O.OBJECT_TYPE, O.OWNER, O.OBJECT_NAME FROM SYS.ALL_OBJECTS O WHERE O.OWNER = :B2 AND O.OBJECT_NAME = :B1 AND OBJECT_TYPE IN ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') AND ROWNUM = 1 |
| dcxcpxj9s2aqq | SELECT SUM(bytes) FROM SYS.DBA_SEGMENTS WHERE UPPER(owner) = UPPER('UD') |
| dzxnau6h6yfg0 | SELECT SUM(bytes) FROM SYS.DBA_SEGMENTS WHERE UPPER(owner) = UPPER('ID') |
| fbj6d9r093a0u | UPDATE BSS_BROKER_STATUS SET AIOB_START_DATE = :1 , AIOB_FINISH_DATE = :2 , RESPONSE_DATE = :3 , LAST_UPD = :4 , STATUS = :5 WHERE (((SEQ_ID = :6 ) AND (SOURCE_SYSTEM = :7 )) AND (TRANSACTION_ID = :8 )) |
| fqmpmkfr6pqyk | select s.synonym_name object_name, o.object_type
from sys.all_synonyms s,
sys.all_objects o
where s.owner in ('PUBLIC', user)
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')
|
| fzfbajk7suy3u | SELECT TRANSACTION_ID, SEQ_ID, SOURCE_SYSTEM, REQUEST_XML, RESPONSE_XML, REQUEST_BMP, RESPONSE_BMP, REQUEST_API, RESPONSE_API FROM BSS_BROKER_XML WHERE (TRANSACTION_ID = :1 ) AND (SOURCE_SYSTEM = :2 ) ORDER BY SEQ_ID DESC |
| g0cc4d37yrc61 | select t.* from CD.CO_PROD_40 t where t.OBJECT_ID=:1 and t.OBJECT_TYPE=:2 and t.IS_MAIN=:3 and t.EXPIRE_DATE>:4 |
| g6t6xntmsumcq | select t.* from CD.CM_RESOURCE_40 t where t.RESOURCE_ID=:1 and t.EXPIRE_DATE>:2 |