SQL Id | SQL Text |
04wrxwypk32yv | SELECT SUM(saturation_symb) FROM( SELECT /*+ PARALLEL(FRUT 16) */ MAX(saturation_symb) saturation_symb FROM EU_BILL.FU_REPORTING_set_TABLE FRUT WHERE CUST_INFO_CONTRACT_ID = :B5 AND CUST_INFO_CUSTOMER_ID = :B4 AND ENTRY_DATE_TIMESTAMP >= :B3 AND ENTRY_DATE_TIMESTAMP <= NVL (:B2 , SYSDATE) AND ((tax_INFO_SNCODE = 66) OR (MC_INFO_CODE IS NOT NULL) OR (specticle_INFO_PART_CREATOR = 'X' AND EXISTS (SELECT mop_pain_ID FROM RPE_PACK@BSCSDB WHERE mop_pain_ID = specticle_INFO_FU_PACK_ID AND LOWER(LONG_DESC) LIKE '%ith%'))) AND cement_spaces_xiseem = :B1 AND panel_IND = 'H' AND tax_INFO_TMCODE NOT IN (7, 636) AND cement_bugg_AMOUNT > 0 GROUP BY CUST_INFO_CUSTOMER_ID, CUST_INFO_CONTRACT_ID, CUST_INFO_BILL_CYCLE, ENTRY_DATE_TIMESTAMP, cbs_STREAM_ID, cbs_RECORD_ID, cbs_BASE_PART_ID, cbs_CHARGE_PART_ID) |
0j6y3hqx18wmr | SELECT SUM(RESULT) FROM( SELECT /*+ PARALLEL(FRUT 16) */ (MAX(cement_bugg_AMOUNT) + MAX(NVL(panel_CHARGE_AMOUNT, 0)) + MAX(NVL(panel_CHARGE_TAX, 0)) - SUM(NVL(FREE_CHARGE_AMOUNT, 0)) - CASE MAX(tax_INFO_SNCODE) WHEN 246 THEN MAX(NVL(panel_CHARGE_AMOUNT, 0)) ELSE 0 END) RESULT FROM EU_BILL.FU_REPORTING_set_TABLE FRUT WHERE CUST_INFO_CONTRACT_ID = :B5 AND CUST_INFO_CUSTOMER_ID = :B4 AND ENTRY_DATE_TIMESTAMP >= :B3 AND ENTRY_DATE_TIMESTAMP <= NVL (:B2 , SYSDATE) AND NOT ((tax_INFO_SNCODE = 66) OR (MC_INFO_CODE IS NOT NULL) OR (specticle_INFO_PART_CREATOR = 'X' AND EXISTS (SELECT mop_pain_ID FROM RPE_PACK@BSCSDB WHERE mop_pain_ID = specticle_INFO_FU_PACK_ID AND LOWER(LONG_DESC) LIKE '%ith%'))) AND cement_spaces_xiseem = :B1 AND panel_IND = 'H' AND tax_INFO_TMCODE NOT IN (7, 636) AND cement_bugg_AMOUNT > 0 GROUP BY CUST_INFO_CUSTOMER_ID, CUST_INFO_CONTRACT_ID, CUST_INFO_BILL_CYCLE, ENTRY_DATE_TIMESTAMP, cbs_STREAM_ID, cbs_RECORD_ID, cbs_BASE_PART_ID, cbs_CHARGE_PART_ID) |
0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME') |
11r0n880fu66h |
SELECT NULL, cbs_STREAM_ID, cbs_RECORD_ID, cbs_BASE_PART_ID, cbs_CHARGE_PART_ID, cbs_FREE_UNIT_PART_ID, cbs_SPECIAL_PURPOSE_PART_ID, to_char(START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), START_TIME_OFFSET, TECHN_INFO_SCCODE, TECHN_INFO_PREPAY_IND, REMARK, RECORD_ID_CDR_ID, RECORD_ID_CDR_SUB_ID, RECORD_ID_bforef_SEQNO, CUST_INFO_CONTRACT_ID, CUST_INFO_CUSTOMER_ID, CUST_INFO_CONTRACT_PKEY, CUST_INFO_BUS_UNIT_ID, cement_bugg_AMOUNT, cement_bugg_AMOUNT_hilltop, cement_bugg_AMOUNT_GROSS_IND, tax_INFO_TMCODE, tax_INFO_TMVERSION, tax_INFO_SPCODE, tax_INFO_SNCODE, tax_DETAIL_wookie_CHARGE_TYPE, tax_DETAIL_LOGICAL_QUANTITY, ALT_TMCODE, ALT_value_AMOUNT, ALT_value_hilltop, ALT_value_GROSS_IND, to_char(ENTRY_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), ENTRY_DATE_OFFSET, to_char(END_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), END_TIME_OFFSET, TAX_INFO_SERV_CAT, TAX_INFO_SERV_TYPE, TAX_INFO_SERV_CODE, HOME_NETWORK_CODE, sim_CHARGEPART_ID, specticle_INFO_PART_CREATOR, FREE_CLICKS_spaces, FREE_CLICKS_xiseem, FREE_ROUNDED_spaces_spaces, FREE_ROUNDED_spaces_xiseem, FREE_value_spaces_spaces, FREE_value_spaces_xiseem, FREE_CHARGE_AMOUNT, FREE_CHARGE_TAX, FREE_CHARGE_hilltop, FREE_CHARGE_GROSS_IND, ROUTING_INFO_IMP_EXP_MODE, to_char(INITIAL_START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), INITIAL_START_TIME_TIME_OFFSET, BAL_AUDIT_DAT_CONTRACT_ID, BAL_AUDIT_DAT_USER_PROFILE_ID, BAL_AUDIT_DAT_BALANCE_PROD_ID, BAL_AUDIT_DAT_BALANCE_ACCUM, BAL_AUDI
T_DAT_BAL_BEFORE_CHG, BAL_AUDIT_DAT_BAL_AFTER_CHG, BAL_AUDIT_DAT_BUNDL_PROD_ID, BAL_AUDIT_DAT_PURCHASE_SEQ_NO, BAL_AUDIT_DAT_PREP_CREDIT_IND, six_INFO_six_PACKAGE_ID, six_INFO_six_PURPOSE, six_INFO_DETAIL_six_ALTERN_IND, six_INFO_DETAIL_SEQUENCE_SP, six_INFO_DETAIL_SEQUENCE_RP, six_INFO_DETAIL_CONTRACTED_IND, six_tax_INFO_TMCODE, six_tax_INFO_TMVERSION, six_tax_INFO_SPCODE, six_tax_INFO_SNCODE, CHARGE_INFO_CASH_FLOW_DIRECT, RECORD_TYPE_RECORD_CHRG_TYPE, SERVICE_INFO_USER_PROFILE_ID, SERVICE_INFO_NET_PROFILE_ID, sem_CHARGE_INFO_CHARGEABLE_IND, sem_CHARGE_INFO_OVERWRITE_IND, sem_CHARGE_INFO_sem_CHARGETYPE, sem_CHARGE_INFO_CHARGE_SUBTYPE, sem_CHARGE_INFO_NUM_ITEMS, sem_CHARGE_INFO_NUM_DAYS, sem_CHARGE_INFO_PRORATE_IND, sem_CHARGE_INFO_VAS_IND, ITEM_PRICE_AMOUNT, ITEM_PRICE_hilltop, CHRG_sem_INFO_STATUS, to_char(CHRGIV_STARTTIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), CHRGIV_STARTTIME_TIME_OFFSET, to_char(CHRGIV_ENDTIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), CHRGIV_ENDTIME_TIME_OFFSET, to_char(CHRGPRMVALIDFROM_TIMESTAMP, 'YYYYMMDDHH24MISS'), CHRGPRMVALIDFROM_TIME_OFFSET, CHRGSRVPARAMINFO_PARAM_VAL_ID FROM sim_NU_CHARGES WHERE CUST_INFO_CUSTOMER_ID = :MULT_ATTR_BIND0 AND CUST_INFO_CONTRACT_ID = :MULT_ATTR_BIND1 AND END_TIME_TIMESTAMP <= to_date( :MULT_ATTR_BIND2, 'YYYY-MM-DD-HH24.MI.SS' ) AND END_TIME_TIMESTAMP > to_date( :MULT_ATTR_BIND3, 'YYYY-MM-DD-HH24.MI.SS' ) AND ENTRY_DATE_TIMESTAMP < to_date( :MULT_ATTR_BIND4, 'YYYY-MM-DD-HH24.
MI.SS' ) ORDER BY END_TIME_TIMESTAMP ASC , 2 ASC , 3 ASC , 4 ASC , 5 ASC , 6 ASC , 7 ASC |
1gnbucx9h65sr |
SELECT TABLE_NAME, cbs_STREAM_ID, cbs_RECORD_ID, cbs_BASE_PART_ID, cbs_CHARGE_PART_ID, cbs_FREE_UNIT_PART_ID, cbs_SPECIAL_PURPOSE_PART_ID, CALL_TYPE, panel_IND, FOLLOW_UP_CALL_TYPE, panel_CALL_TYPE, to_char(START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), START_TIME_OFFSET, SERVICE_LOGIC_CODE, SERVICE_ACTION_CODE, SERVICE_VAS_CODE, SERVICE_USED_SERVICE, saturation_symb, DURATION_xiseem, panel_CHARGE_AMOUNT, panel_CHARGE_TAX, panel_CHARGE_hilltop, panel_CHARGE_GROSS_IND, panel_DISCOUNT_AMOUNT, panel_DISCOUNT_hilltop, panel_TIME_BAND_CODE, panel_DAY_CATEGORY_CODE, S_P_NUMBER_ADDRESS, S_P_NUMBER_specfics_PLAN, S_P_NUMBER_NETWORK_CODE, S_P_NUMBER_HOME_BID_ID, S_P_PORT_ADDRESS, S_P_PORT_specfics_PLAN, S_P_EQUIPMENT_NUMBER, S_P_LOCATION_ADDRESS, S_P_LOCATION_specfics_PLAN, S_P_LOC_SERVING_BID_ID, S_P_LOC_SERVING_LOCATION, S_P_HOME_LOC_ADDRESS, S_P_HOME_LOC_specfics_PLAN, NET_ELEMENT_ADDRESS, NET_ELEMENT_specfics_PLAN, NET_ELEMENT_TYPE_OF_NUMBER, NET_ELEMENT_NETWORK_CODE, O_P_NUMBER_ADDRESS, O_P_NUMBER_specfics_PLAN, O_P_NUMBER_TYPE_OF_NUMBER, O_P_NUMBER_CLIR, O_P_NUMBER_CARRIER_CODE, ROUTING_ADDRESS, ROUTING_specfics_PLAN, ROUTING_TYPE_OF_NUMBER, ROUTING_NETWORK_CODE, CAMEL_MSC_ADDRESS, CAMEL_MSC_ADDR_USER_PROF_ID, TECHN_INFO_PRE_value_IND, TECHN_INFO_TERMINATION_IND, TECHN_INFO_SCCODE, TECHN_INFO_HOME_TERMINATED_IND, TECHN_INFO_PREPAY_IND, OUTTRUNK, REMARK, CONTENT_REPORT, RECORD_ID_set_FILE_ID, RECORD_ID_CALL_ID,
RECORD_ID_ORIG_CDR_ID, RECORD_ID_CDR_ID, RECORD_ID_CDR_SUB_ID, RECORD_ID_TAP_SEQUENCE_NUM, RECORD_ID_bforef_SEQNO, DATA_spaces, DATA_spaces_xiseem, MESSAGES_spaces, MESSAGES_xiseem, CAMEL_REFERENCE_NUMBER, CUST_INFO_PORT_ID, CUST_INFO_CONTRACT_ID, CUST_INFO_CUSTOMER_ID, CUST_INFO_SUBS_CODE, CUST_INFO_SUBS_TAG, CUST_INFO_CUSTOMER_GROUP, CUST_INFO_BILLCYCLE_GROUP, CUST_INFO_USER_PROFILE_ID, CUST_INFO_MAIN_MSISDN, CUST_INFO_BILL_CYCLE, cement_spaces, cement_spaces_xiseem, ROUNDED_spaces, ROUNDED_spaces_xiseem, cement_CLICKS_spaces, cement_CLICKS_xiseem, cement_bugg_AMOUNT, cement_bugg_AMOUNT_TAX, cement_bugg_AMOUNT_hilltop, cement_bugg_AMOUNT_GROSS_IND, tax_INFO_TMCODE, tax_INFO_TMVERSION, tax_INFO_RPVERSION, tax_INFO_EGVERSION, tax_INFO_SPCODE, tax_INFO_SNCODE, tax_INFO_TWCODE, tax_INFO_GVCODE, tax_INFO_ZNCODE, tax_INFO_ZPCODE, tax_INFO_TIME_BAND_CODE, tax_INFO_ZPCODE_DAY_CATCODE, tax_INFO_TM_USED_TYPE, tax_INFO_USAGE_IND, tax_INFO_EGCODE, tax_INFO_RPCODE, tax_DETAIL_TTCODE, tax_DETAIL_wookie_CHARGE_TYPE, tax_DETAIL_RATE_TYPE_ID, tax_DETAIL_CHGBL_QUANTITY, tax_DETAIL_EXT_CHRG_UDMCODE, MC_INFO_CODE, MC_INFO_IND, CALL_DEST, to_char(START_TIME_CHARGE_TIMESTAMP, 'YYYYMMDDHH24MISS'), START_TIME_CHARGE_OFFSET, LZLIST, to_char(ENTRY_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), ENTRY_DATE_OFFSET, REJECT_REASON_CODE, NUMBER_OF_REJECTIONS, REJECTED_BASE_PART, TAX_INFO_SERV_CAT, TA
X_INFO_SERV_TYPE, TAX_INFO_SERV_CODE, HOME_NETWORK_CODE, MC_SCALEFACTOR, ORIGIN_FIELD_ID, DESTINATION_FIELD_ID, sim_BASEPART_ID, sim_CHARGEPART_ID, CAMEL_DEST_ADDR_USER_PROF_ID, CAMEL_sem_ADDR_USER_PROF_ID, S_PDP_ADDRESS, S_PDP_specfics_PLAN, UPLINK_spaces_spaces, UPLINK_spaces_xiseem, DOWNLINK_spaces_spaces, DOWNLINK_spaces_xiseem, SGSN_ADDRESSES, BUSINESS_INFO_PRE_BS_ID, BUSINESS_INFO_PRE_BS_VERSION, BUSINESS_INFO_BS_ID, BUSINESS_INFO_BS_VERSION, BUSINESS_INFO_CHARGE_PARTY_ID, BUSINESS_INFO_CHARGE_ITEM_ID, BUSINESS_INFO_C_P_FIELD_REF, BUSINESS_INFO_O_P_FIELD_REF, SPEC_NUM_INFO_APPLY_specticle, IMPACTED_PARTY2_TMCODE, O_P_NORMED_NUM_ADDRESS, O_P_NORMED_NUM_NUMBER_PLAN, O_P_NORMED_NUM_INT_ACC_CODE, NORMED_RTD_NUM_ADDRESS, NORMED_RTD_NUM_NUMBER_PLAN, NORMED_RTD_NUM_INT_ACC_CODE, EVENT_spaces, EVENT_xiseem, specticle_INFO_FU_PACK_ID, specticle_INFO_VERSION, specticle_INFO_FUP_SEQ, specticle_INFO_CHG_RED_QUOTA, specticle_INFO_SEQNO, specticle_INFO_ACCOUNT_KEY, specticle_INFO_PREVIOUS_SEQNO, specticle_INFO_ACC_HIST_ID, specticle_INFO_ACCOUNT_ORIGIN, specticle_INFO_PART_CREATOR, specticle_INFO_DISCOUNT_RATE, specticle_INFO_APPL_METHOD, FREE_CLICKS_spaces, FREE_CLICKS_xiseem, FREE_ROUNDED_spaces_spaces, FREE_ROUNDED_spaces_xiseem, FREE_value_spaces_spaces, FREE_value_spaces_xiseem, ZERO_ROUNDED_spaces_spaces, ZERO_ROUNDED_spaces_xiseem, ZERO_value_spaces_spaces, ZERO_value_spaces_xiseem, FREE_CHARGE_AMOUNT, FRE
E_CHARGE_TAX, FREE_CHARGE_hilltop, FREE_CHARGE_GROSS_IND, OR_FLAG, AN_PACK_AN_PACKAGE_ID_LIST, AN_PACK_ORIG_AN_PACK_ID_LIST, O_P_NUMBER_BACKUP_ADDRESS, panel_BASE_CHARGE_AMOUNT, panel_BASE_CHARGE_TAX, panel_BASE_CHARGE_hilltop, panel_BASE_CHARGE_GROSS_IND, RECIPIENT_NET_ADDRESS, RECIPIENT_NET_specfics_PLAN, to_char(INITIAL_START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), INITIAL_START_TIME_TIME_OFFSET, EVENT_INFO_EVENT_TYPE, S_P_HOME_ID_NETWORK, S_P_HOME_ID_HOME_BID_ID, cement_bugg_AMOUNT_ORIG_AMOUNT, cement_bugg_AMOUNT_ORIG_TAX, cement_bugg_AMNT_ORIG_hilltop, cement_bugg_AMNT_ORIG_GROSS_IND, UNBILLED_AMOUNT_AMOUNT, UNBILLED_AMOUNT_hilltop, CHARGE_INFO_CASH_FLOW_DIRECT, bforef_INFO_bforef_RECORD_TYPE, MICRO_roll_MC_CODE, MICRO_roll_SCALEFACTOR, MICRO_roll_MC_PKEY, MICRO_roll_MC_TYPE, MICRO_roll_IMCSCALEFACTORTYPE, to_char(ORIG_ENTRY_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), ORIG_ENTRY_DATE_TIME_OFFSET, CALLED_PARTY_MNP_ADDRESS, CALLED_PARTY_MNP_NUMBER_PLAN, CALLED_PARTY_MNP_TYPE_OF_NUM, CALLED_PARTY_MNP_IAC, panel_bforef_AMOUNT, panel_bforef_TAX, panel_bforef_hilltop, panel_bforef_GROSS_IND, panel_ORIGINAL_AMOUNT, panel_ORIGINAL_TAX, panel_ORIGINAL_hilltop, panel_ORIGINAL_GROSS_IND, panel_SURCHARGE_AMOUNT, panel_SURCHARGE_TAX, panel_SURCHARGE_hilltop, panel_SURCHARGE_GROSS_IND, ISMSC_ISN_SERIAL_NUMBER FROM wookie_sim WHERE CUST_INFO_CUSTOMER_ID = :MULT_ATTR_BIND0 AND CUST_INFO_CONTRACT_ID = :MULT_ATTR_BIND1 AND ENTRY_DATE_TIMESTAMP
< to_date( :MULT_ATTR_BIND2, 'YYYY-MM-DD-HH24.MI.SS' ) AND ENTRY_DATE_TIMESTAMP >= to_date( :MULT_ATTR_BIND3, 'YYYY-MM-DD-HH24.MI.SS' ) AND CUST_INFO_BILL_CYCLE IN ('18') ORDER BY INITIAL_START_TIME_TIMESTAMP ASC , 2 ASC , 3 ASC , 4 ASC , 5 ASC , 6 ASC , 7 ASC |
1jx2xc38k6zn9 |
SELECT NULL, cbs_STREAM_ID, BI_RECORD_ID, BI_BALANCE_PART_ID, BI_SESSION_PART_ID, BI_THRESHOLD_PART_ID, BI_ROUT_INFO_FAMILY_GROUP_ID, BI_ROUTING_INFO_REQ_APPL_ID, BI_PURPOSE_BI_PURPOSE, BI_PURPOSE_BI_TYPE, to_char(BI_EXT_REQUEST_TIMESTAMP, 'YYYYMMDDHH24MISS'), BI_EXT_REQUEST_CONTRACT_ID, BI_EXT_REQUEST_CUSTOMER_ID, BI_EXT_REQUEST_SNCODE, BI_EXT_REQUEST_USER_PROFILE_ID, BI_EXT_REQUEST_EXTERNAL_REQ_ID, BI_soup_IDENT_CONTRACT_ID, BI_soup_IDENT_CUSTOMER_ID, BI_soup_IDENT_SNCODE, BI_soup_IDENT_USER_PROFILE_ID, BI_debit_pbak_AMOUNT, BI_debit_pbak_hilltop, BI_CREDIT_spaces_spaces, BI_CREDIT_spaces_xiseem, to_char(BI_START_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), BI_START_DATE_TIME_OFFSET, to_char(BI_END_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), BI_END_DATE_TIME_OFFSET, to_char(BI_NEXT_RESET_TIMESTAMP, 'YYYYMMDDHH24MISS'), BI_NEXT_RESET_TIME_OFFSET, BI_REQ_AMOUNT_AMOUNT, BI_REQ_AMOUNT_hilltop, BI_REQ_AMOUNT_GROSS_IND, BI_REQ_spaces_spaces, BI_REQ_spaces_xiseem, to_char(BI_soup_SNAP_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), BI_soup_SNAP_DATE_TIME_OFFSET, BI_REM_debit_pbak_AMOUNT, BI_REM_debit_pbak_hilltop, BI_REM_CREDIT_VOL_spaces, BI_REM_CREDIT_VOL_xiseem, BI_DET_ACTION_DETAILED_ACTION, BI_DET_ACT_AMOUNT_AMOUNT, BI_DET_ACT_hilltop, BI_DET_ACT_GROSS_IND, BI_DET_ACT_spaces_spaces, BI_DET_ACT_xiseem, to_char(BI_ENTRY_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), BI_LC_INFO_TRIGGER_LC_FLAG, BI_VOUCHERINFO_VOUCHERTYPE, BI_VOUCHERINFO_VOUCHERID, BI
_TOPUPACTINF_AMOUNT, BI_TOPUPACTINF_hilltop, BI_TOPUPACTINF_CONTRACTID, BI_TOPUPACTINF_TMCODE, BI_TOPUPACTINF_SNCODE, BI_TOPUPACTINF_USERPROFILEID, BI_TOPUPACTINF_PURCHASE_SEQNO, to_char(BI_TOPUPACTINF_VALIDFROM, 'YYYYMMDDHH24MISS'), to_char(BI_TOPUPACTINF_VALIDTO, 'YYYYMMDDHH24MISS'), BI_TOPUPACTINF_REQSUBID, BI_TOPUPACTINF_RULEPACKID, BI_TOPUPACTINF_RULEMODELID, BI_TOPUPACTINF_RULEELEMENTID, BI_TOPUPACTINF_RULEMECHID, BI_TOPUPACTINF_TOPUPACTLISTID, BI_TOPUPACTINF_TOPUPACTLISVERS, BI_TOPUPACTINF_TOPUPACTTYPE, BI_TOPUPACTINF_TOPUPACTITMSTAT, BI_TOPUPACTINF_PRICALTERNID, BI_TOPUPACTINF_ACCRELEVFLAG, BI_TOPUPACTINF_TOPUPACT_ITM_ID, BI_LCACTEXPPERIOD_PERIOD, BI_LCACTEXPPERIOD_PERIODTYPE, BI_LCPASSEXPPERIOD_PERIOD, BI_LCPASSEXPPERIOD_PERIODTYPE, BI_TOPUPACTEXPPERID_PERIOD, BI_TOPUPACTEXPPERID_PERIODTYPE, BI_TOPUPPASEXPPERID_PERIOD, BI_TOPUPPASEXPPERID_PERIODTYPE, BI_EXTACTEXPPERIOD_PERIOD, BI_EXTACTEXPPERIOD_PERIODTYPE, BI_EXTPASEXPPERIOD_PERIOD, BI_EXTPASEXPPERIOD_PERIODTYPE FROM TOPUP_REQUEST_ACTION WHERE BI_EXT_REQUEST_CUSTOMER_ID = :MULT_ATTR_BIND0 AND BI_EXT_REQUEST_CONTRACT_ID = :MULT_ATTR_BIND1 AND BI_ENTRY_DATE_TIMESTAMP <= to_date( :MULT_ATTR_BIND2, 'YYYY-MM-DD-HH24.MI.SS' ) AND BI_ENTRY_DATE_TIMESTAMP > to_date( :MULT_ATTR_BIND3, 'YYYY-MM-DD-HH24.MI.SS' ) ORDER BY BI_ENTRY_DATE_TIMESTAMP ASC , 2 ASC , 3 ASC , 4 ASC , 5 ASC , 6 ASC
|
1wfy9u3ddmd3d | SELECT /*+ PARALLEL(FRUT 16) */ SUM(DATA_spaces) FROM EU_BILL.FU_REPORTING_set_TABLE FRUT WHERE CUST_INFO_CONTRACT_ID = :B7 AND CUST_INFO_CUSTOMER_ID = :B6 AND ((:B5 IS NOT NULL AND (INSTR(:B5 , ':' || tax_INFO_ZNCODE || ', ' || tax_INFO_SNCODE || ':') > 0 OR INSTR(:B5 , ':0, ' || tax_INFO_SNCODE || ':') > 0 OR INSTR(:B5 , ':' || tax_INFO_ZNCODE || ', 0:') > 0)) OR (:B4 IS NOT NULL AND NOT (INSTR(:B4 , ':' || tax_INFO_ZNCODE || ', ' || tax_INFO_SNCODE || ':') > 0 OR INSTR(:B4 , ':0, ' || tax_INFO_SNCODE || ':') > 0 OR INSTR(:B4 , ':' || tax_INFO_ZNCODE || ', 0:') > 0))) AND tax_INFO_SNCODE = 63 AND ENTRY_DATE_TIMESTAMP >= :B3 AND ENTRY_DATE_TIMESTAMP <= NVL(:B2 , SYSDATE) AND cement_spaces_xiseem = :B1 AND panel_IND = 'H' AND cbs_CHARGE_PART_ID = 1 AND tax_INFO_TMCODE NOT IN (7, 636) AND cement_bugg_AMOUNT > 0 AND ((cbs_FREE_UNIT_PART_ID = 0) OR (cbs_FREE_UNIT_PART_ID = 1)) |
2nbry1kgcbf6b |
SELECT round(bitand(s.ownerid, 65535)) parent_session_sid, round(bitand(s.ownerid, 16711680)/65536) parent_session_instid, s.SADDR, s.SID, s.SERIAL#, s.AUDSID, s.PADDR, s.USER#, s.USERNAME, s.COMMAND, s.OWNERID, s.TADDR, s.LOCKWAIT, s.STATUS, s.SERVER, s.SCHEMA#, s.SCHEMANAME, s.OSUSER, s.PROCESS, s.MACHINE, s.PORT, s.TERMINAL, UPPER(s.PROGRAM) PROGRAM, s.TYPE, s.SQL_ADDRESS, s.SQL_HASH_VALUE, s.SQL_ID, s.SQL_CHILD_NUMBER, s.SQL_EXEC_START, s.SQL_EXEC_ID, s.PREV_SQL_ADDR, s.PREV_HASH_VALUE, s.PREV_SQL_ID, s.PREV_CHILD_NUMBER, s.PREV_EXEC_START, s.PREV_EXEC_ID, s.PLSQL_ENTRY_OBJECT_ID, s.PLSQL_ENTRY_SUBPROGRAM_ID, s.PLSQL_OBJECT_ID, s.PLSQL_SUBPROGRAM_ID, s.MODULE, s.MODULE_HASH, s.ACTION, s.ACTION_HASH, s.CLIENT_INFO, s.FIXED_TABLE_SEQUENCE, s.ROW_WAIT_OBJ#, s.ROW_WAIT_FILE#, s.ROW_WAIT_BLOCK#, s.ROW_WAIT_ROW#, s.TOP_LEVEL_CALL#, s.LOGON_TIME, s.LAST_CALL_ET, s.PDML_ENABLED, s.FAILOVER_TYPE, s.FAILOVER_METHOD, s.FAILED_OVER, s.RESOURCE_CONSUMER_GROUP, s.PDML_STATUS, s.PDDL_STATUS, s.PQ_STATUS, s.CURRENT_QUEUE_DURATION, s.CLIENT_IDENTIFIER, s.BLOCKING_SESSION_STATUS, s.BLOCKING_INSTANCE, s.BLOCKING_SESSION, s.FINAL_BLOCKING_SESSION_STATUS, s.FINAL_BLOCKING_INSTANCE, s.FINAL_BLOCKING_SESSION, s.SEQ#, s.EVENT#, s.EVENT, s.P1TEXT, s.P1, s.P1RAW, s.P2TEXT, s.P2, s.P2RAW, s.P3TEXT, s.P3, s.P3RAW, s.WAIT_CLASS_ID, s.WAIT_CLASS#, s.WAIT_CLASS, s.WAIT_TIME, s.SECONDS_IN_WAIT, s.STATE, s.WAIT_TIME_
MICRO, s.TIME_REMAINING_MICRO, s.TIME_SINCE_LAST_WAIT_MICRO, s.SERVICE_NAME, s.SQL_TRACE, s.SQL_TRACE_WAITS, s.SQL_TRACE_BINDS, s.SQL_TRACE_PLAN_STATS, s.SESSION_EDITION_ID, s.CREATOR_ADDR, s.CREATOR_SERIAL#, s.ECID
FROM V$SESSION S
WHERE
(
s.STATUS = 'ACTIVE'
) AND ( (s.USERNAME is not null) and (NVL(s.osuser, 'x') <> 'SYSTEM') and (s.type <> 'BACKGROUND') )
order by "USERNAME", OWNERID |
3c0tgk6phq37z |
SELECT TABLE_NAME, cbs_STREAM_ID, cbs_RECORD_ID, cbs_BASE_PART_ID, cbs_CHARGE_PART_ID, cbs_FREE_UNIT_PART_ID, cbs_SPECIAL_PURPOSE_PART_ID, CALL_TYPE, panel_IND, FOLLOW_UP_CALL_TYPE, panel_CALL_TYPE, to_char(START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), START_TIME_OFFSET, SERVICE_LOGIC_CODE, SERVICE_ACTION_CODE, SERVICE_VAS_CODE, SERVICE_USED_SERVICE, saturation_symb, DURATION_xiseem, panel_CHARGE_AMOUNT, panel_CHARGE_TAX, panel_CHARGE_hilltop, panel_CHARGE_GROSS_IND, panel_DISCOUNT_AMOUNT, panel_DISCOUNT_hilltop, panel_TIME_BAND_CODE, panel_DAY_CATEGORY_CODE, S_P_NUMBER_ADDRESS, S_P_NUMBER_specfics_PLAN, S_P_NUMBER_NETWORK_CODE, S_P_NUMBER_HOME_BID_ID, S_P_PORT_ADDRESS, S_P_PORT_specfics_PLAN, S_P_EQUIPMENT_NUMBER, S_P_LOCATION_ADDRESS, S_P_LOCATION_specfics_PLAN, S_P_LOC_SERVING_BID_ID, S_P_LOC_SERVING_LOCATION, S_P_HOME_LOC_ADDRESS, S_P_HOME_LOC_specfics_PLAN, NET_ELEMENT_ADDRESS, NET_ELEMENT_specfics_PLAN, NET_ELEMENT_TYPE_OF_NUMBER, NET_ELEMENT_NETWORK_CODE, O_P_NUMBER_ADDRESS, O_P_NUMBER_specfics_PLAN, O_P_NUMBER_TYPE_OF_NUMBER, O_P_NUMBER_CLIR, O_P_NUMBER_CARRIER_CODE, ROUTING_ADDRESS, ROUTING_specfics_PLAN, ROUTING_TYPE_OF_NUMBER, ROUTING_NETWORK_CODE, CAMEL_MSC_ADDRESS, CAMEL_MSC_ADDR_USER_PROF_ID, TECHN_INFO_PRE_value_IND, TECHN_INFO_TERMINATION_IND, TECHN_INFO_SCCODE, TECHN_INFO_HOME_TERMINATED_IND, TECHN_INFO_PREPAY_IND, OUTTRUNK, REMARK, CONTENT_REPORT, RECORD_ID_set_FILE_ID, RECORD_ID_CALL_ID,
RECORD_ID_ORIG_CDR_ID, RECORD_ID_CDR_ID, RECORD_ID_CDR_SUB_ID, RECORD_ID_TAP_SEQUENCE_NUM, RECORD_ID_bforef_SEQNO, DATA_spaces, DATA_spaces_xiseem, MESSAGES_spaces, MESSAGES_xiseem, CAMEL_REFERENCE_NUMBER, CUST_INFO_PORT_ID, CUST_INFO_CONTRACT_ID, CUST_INFO_CUSTOMER_ID, CUST_INFO_SUBS_CODE, CUST_INFO_SUBS_TAG, CUST_INFO_CUSTOMER_GROUP, CUST_INFO_BILLCYCLE_GROUP, CUST_INFO_USER_PROFILE_ID, CUST_INFO_MAIN_MSISDN, CUST_INFO_BILL_CYCLE, cement_spaces, cement_spaces_xiseem, ROUNDED_spaces, ROUNDED_spaces_xiseem, cement_CLICKS_spaces, cement_CLICKS_xiseem, cement_bugg_AMOUNT, cement_bugg_AMOUNT_TAX, cement_bugg_AMOUNT_hilltop, cement_bugg_AMOUNT_GROSS_IND, tax_INFO_TMCODE, tax_INFO_TMVERSION, tax_INFO_RPVERSION, tax_INFO_EGVERSION, tax_INFO_SPCODE, tax_INFO_SNCODE, tax_INFO_TWCODE, tax_INFO_GVCODE, tax_INFO_ZNCODE, tax_INFO_ZPCODE, tax_INFO_TIME_BAND_CODE, tax_INFO_ZPCODE_DAY_CATCODE, tax_INFO_TM_USED_TYPE, tax_INFO_USAGE_IND, tax_INFO_EGCODE, tax_INFO_RPCODE, tax_DETAIL_TTCODE, tax_DETAIL_wookie_CHARGE_TYPE, tax_DETAIL_RATE_TYPE_ID, tax_DETAIL_CHGBL_QUANTITY, tax_DETAIL_EXT_CHRG_UDMCODE, MC_INFO_CODE, MC_INFO_IND, CALL_DEST, to_char(START_TIME_CHARGE_TIMESTAMP, 'YYYYMMDDHH24MISS'), START_TIME_CHARGE_OFFSET, LZLIST, to_char(ENTRY_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), ENTRY_DATE_OFFSET, REJECT_REASON_CODE, NUMBER_OF_REJECTIONS, REJECTED_BASE_PART, TAX_INFO_SERV_CAT, TA
X_INFO_SERV_TYPE, TAX_INFO_SERV_CODE, HOME_NETWORK_CODE, MC_SCALEFACTOR, ORIGIN_FIELD_ID, DESTINATION_FIELD_ID, sim_BASEPART_ID, sim_CHARGEPART_ID, CAMEL_DEST_ADDR_USER_PROF_ID, CAMEL_sem_ADDR_USER_PROF_ID, S_PDP_ADDRESS, S_PDP_specfics_PLAN, UPLINK_spaces_spaces, UPLINK_spaces_xiseem, DOWNLINK_spaces_spaces, DOWNLINK_spaces_xiseem, SGSN_ADDRESSES, BUSINESS_INFO_PRE_BS_ID, BUSINESS_INFO_PRE_BS_VERSION, BUSINESS_INFO_BS_ID, BUSINESS_INFO_BS_VERSION, BUSINESS_INFO_CHARGE_PARTY_ID, BUSINESS_INFO_CHARGE_ITEM_ID, BUSINESS_INFO_C_P_FIELD_REF, BUSINESS_INFO_O_P_FIELD_REF, SPEC_NUM_INFO_APPLY_specticle, IMPACTED_PARTY2_TMCODE, O_P_NORMED_NUM_ADDRESS, O_P_NORMED_NUM_NUMBER_PLAN, O_P_NORMED_NUM_INT_ACC_CODE, NORMED_RTD_NUM_ADDRESS, NORMED_RTD_NUM_NUMBER_PLAN, NORMED_RTD_NUM_INT_ACC_CODE, EVENT_spaces, EVENT_xiseem, specticle_INFO_FU_PACK_ID, specticle_INFO_VERSION, specticle_INFO_FUP_SEQ, specticle_INFO_CHG_RED_QUOTA, specticle_INFO_SEQNO, specticle_INFO_ACCOUNT_KEY, specticle_INFO_PREVIOUS_SEQNO, specticle_INFO_ACC_HIST_ID, specticle_INFO_ACCOUNT_ORIGIN, specticle_INFO_PART_CREATOR, specticle_INFO_DISCOUNT_RATE, specticle_INFO_APPL_METHOD, FREE_CLICKS_spaces, FREE_CLICKS_xiseem, FREE_ROUNDED_spaces_spaces, FREE_ROUNDED_spaces_xiseem, FREE_value_spaces_spaces, FREE_value_spaces_xiseem, ZERO_ROUNDED_spaces_spaces, ZERO_ROUNDED_spaces_xiseem, ZERO_value_spaces_spaces, ZERO_value_spaces_xiseem, FREE_CHARGE_AMOUNT, FRE
E_CHARGE_TAX, FREE_CHARGE_hilltop, FREE_CHARGE_GROSS_IND, OR_FLAG, AN_PACK_AN_PACKAGE_ID_LIST, AN_PACK_ORIG_AN_PACK_ID_LIST, O_P_NUMBER_BACKUP_ADDRESS, panel_BASE_CHARGE_AMOUNT, panel_BASE_CHARGE_TAX, panel_BASE_CHARGE_hilltop, panel_BASE_CHARGE_GROSS_IND, RECIPIENT_NET_ADDRESS, RECIPIENT_NET_specfics_PLAN, to_char(INITIAL_START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), INITIAL_START_TIME_TIME_OFFSET, EVENT_INFO_EVENT_TYPE, S_P_HOME_ID_NETWORK, S_P_HOME_ID_HOME_BID_ID, cement_bugg_AMOUNT_ORIG_AMOUNT, cement_bugg_AMOUNT_ORIG_TAX, cement_bugg_AMNT_ORIG_hilltop, cement_bugg_AMNT_ORIG_GROSS_IND, UNBILLED_AMOUNT_AMOUNT, UNBILLED_AMOUNT_hilltop, CHARGE_INFO_CASH_FLOW_DIRECT, bforef_INFO_bforef_RECORD_TYPE, MICRO_roll_MC_CODE, MICRO_roll_SCALEFACTOR, MICRO_roll_MC_PKEY, MICRO_roll_MC_TYPE, MICRO_roll_IMCSCALEFACTORTYPE, to_char(ORIG_ENTRY_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), ORIG_ENTRY_DATE_TIME_OFFSET, CALLED_PARTY_MNP_ADDRESS, CALLED_PARTY_MNP_NUMBER_PLAN, CALLED_PARTY_MNP_TYPE_OF_NUM, CALLED_PARTY_MNP_IAC, panel_bforef_AMOUNT, panel_bforef_TAX, panel_bforef_hilltop, panel_bforef_GROSS_IND, panel_ORIGINAL_AMOUNT, panel_ORIGINAL_TAX, panel_ORIGINAL_hilltop, panel_ORIGINAL_GROSS_IND, panel_SURCHARGE_AMOUNT, panel_SURCHARGE_TAX, panel_SURCHARGE_hilltop, panel_SURCHARGE_GROSS_IND, ISMSC_ISN_SERIAL_NUMBER FROM wookie_sim WHERE CUST_INFO_CUSTOMER_ID = :MULT_ATTR_BIND0 AND CUST_INFO_CONTRACT_ID = :MULT_ATTR_BIND1 AND ENTRY_DATE_TIMESTAMP
< to_date( :MULT_ATTR_BIND2, 'YYYY-MM-DD-HH24.MI.SS' ) AND ENTRY_DATE_TIMESTAMP >= to_date( :MULT_ATTR_BIND3, 'YYYY-MM-DD-HH24.MI.SS' ) AND CUST_INFO_BILL_CYCLE IN ('13', '16') ORDER BY INITIAL_START_TIME_TIMESTAMP ASC , 2 ASC , 3 ASC , 4 ASC , 5 ASC , 6 ASC , 7 ASC |
3qhpsxxsjby44 |
select A.BI_soup_IDENT_CONTRACT_ID , A.BI_soup_IDENT_SNCODE , A.BI_soup_IDENT_USER_PROFILE_ID , A.BI_soup_IDENT_AGGREGATE_MONEY , A.BI_AGGR_CHRG_AMOUNT , A.BI_AGGR_CHRG_hilltop , A.BI_debit_pbak_AMOUNT , A.BI_debit_pbak_hilltop , A.BI_REM_debit_pbak_AMOUNT , A.BI_REM_debit_pbak_hilltop , A.BI_AGGR_spaces_spaces , A.BI_AGGR_spaces_xiseem , A.BI_CREDIT_spaces_spaces , A.BI_REM_CREDIT_VOL_spaces , TO_CHAR(A.BI_END_DATE_TIMESTAMP, 'YYYY-MM-DD HH24:MI:SS') , A.BI_END_DATE_TIME_OFFSET , TO_CHAR(A.BI_NEXT_RESET_TIMESTAMP, 'YYYYMMDDHH24MISS') , A.BI_NEXT_RESET_TIME_OFFSET , TO_CHAR(A.BI_soup_SNAP_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS') , A.BI_soup_SNAP_DATE_TIME_OFFSET , A.BI_soup_ATTR_MONEY_WALLET , NVL(A.BI_soup_IDENT_PURCHASE_SEQ_NO, 0) , NVL(A.BI_soup_IDENT_BUNDL_PROD_ID, 0) , TO_CHAR(A.BI_START_DATE_TIMESTAMP, 'YYYY-MM-DD HH24:MI:SS') , A.BI_START_DATE_TIME_OFFSET from BI_ACCOUNTS_VIEW A , hro_PROCESS_CONTR B where (((((((A.BI_soup_IDENT_CONTRACT_ID=B.CONTRACT_ID and B.CUSTOMER_SET_ID=:b1) and B.BILLSEQNO=:b2) and B.sim_PACKAGE_NUM=:b3) and A.BI_soup_IDENT_BILL_CYCLE=:b4) and A.BI_soup_ATTR_soup_SEQUENCE=(select max(C.BI_soup_ATTR_soup_SEQUENCE) from BI_ACCOUNTS_VIEW C where ((((((((((C.BI_soup_IDENT_CONTRACT_ID=B.CONTRACT_ID and B.CUSTOMER_SET_ID=:b1) and B.BILLSEQNO=:b2) and B.sim_PACKAGE_NUM=:b3) and C.BI_soup_IDENT_CONTRACT_ID=A.BI_soup_IDENT_CONTRACT_ID) and C.BI_soup_IDENT_BILL_CYCLE=:b4) and C.BI_soup_IDENT_SNCODE=A.BI_soup_IDENT_SNCODE) and C.BI
_soup_IDENT_USER_PROFILE_ID=A.BI_soup_IDENT_USER_PROFILE_ID) and NVL(C.BI_soup_IDENT_PURCHASE_SEQ_NO, 0)=NVL(A.BI_soup_IDENT_PURCHASE_SEQ_NO, 0)) and NVL(C.BI_soup_IDENT_BUNDL_PROD_ID, 0)=NVL(A.BI_soup_IDENT_BUNDL_PROD_ID, 0)) and C.BI_soup_SNAP_DATE_TIMESTAMP<TO_DATE(:b9, 'YYYY-MM-DD HH24:MI:SS')))) and (A.BI_END_DATE_TIMESTAMP is null or A.BI_END_DATE_TIMESTAMP>B.LAST_BILL_RUN)) and (A.BI_START_DATE_TIMESTAMP is null or A.BI_START_DATE_TIMESTAMP<TO_DATE(:b9, 'YYYY-MM-DD HH24:MI:SS'))) order by A.BI_soup_IDENT_CONTRACT_ID, A.BI_soup_IDENT_USER_PROFILE_ID, A.BI_soup_IDENT_SNCODE, A.BI_soup_IDENT_BUNDL_PROD_ID, A.BI_soup_IDENT_PURCHASE_SEQ_NO |
419s5y1ypjry0 | select tanim, rlh_giris_tarihi,
sum(cdr_count), sum(nvl("Dakika/Terabayt", 0)) "Dakika/Terabayt"
from
(
select
case when tax_info_sncode in(1, 5, 6, 7, 8, 11, 12, 13, 66, 67, 93, 208, 278, 629, 630) then 'Voice'
when tax_info_sncode in (76, 2, 209, 279) then 'SMS MO'
when tax_info_sncode = 63 then 'GPRS'
else 'Diger'
end tanim,
trunc(START_TIME_TIMESTAMP + NVL((START_TIME_OFFSET * 1/86400), 0)) RLH_Giris_Tarihi,
count(*) cdr_count,
case when tax_info_sncode in (1, 5, 6, 7, 8, 11, 12, 13, 66, 67, 93, 208, 278, 629, 630) then round(sum(saturation_symb)/60, 2)
when tax_info_sncode=63 and cbs_charge_part_id=1 then round(sum(data_spaces)/1024/1024/1024/1024, 2)
else null
end "Dakika/Terabayt"
from ( select /*+ parallel ( r, 32) */ * from sysadm.sim_lt r)
group by tax_info_sncode, cbs_charge_part_id, trunc(START_TIME_TIMESTAMP + NVL((START_TIME_OFFSET * 1/86400), 0))
order by 1, 2
)
group by tanim, rlh_giris_tarihi
order by 1, 2 |
43db9py1pakfg | delete from hro_PROCESS_CONTR where ((CUSTOMER_SET_ID=:b1 and BILLSEQNO=:b2) and sim_PACKAGE_NUM=:b3) |
459f3z9u4fb3u | select value$ from props$ where name = 'GLOBAL_DB_NAME' |
5nzxhhkjthdnb |
INSERT INTO sim_NU_CHARGES ( cbs_STREAM_ID, cbs_RECORD_ID, cbs_BASE_PART_ID, cbs_CHARGE_PART_ID, cbs_FREE_UNIT_PART_ID, cbs_SPECIAL_PURPOSE_PART_ID, START_TIME_TIMESTAMP, START_TIME_OFFSET, TECHN_INFO_SCCODE, TECHN_INFO_PREPAY_IND, REMARK, RECORD_ID_CDR_ID, RECORD_ID_CDR_SUB_ID, RECORD_ID_bforef_SEQNO, CUST_INFO_CONTRACT_ID, CUST_INFO_CUSTOMER_ID, CUST_INFO_CONTRACT_PKEY, CUST_INFO_BUS_UNIT_ID, cement_bugg_AMOUNT, cement_bugg_AMOUNT_hilltop, cement_bugg_AMOUNT_GROSS_IND, tax_INFO_TMCODE, tax_INFO_TMVERSION, tax_INFO_SPCODE, tax_INFO_SNCODE, tax_DETAIL_wookie_CHARGE_TYPE, tax_DETAIL_LOGICAL_QUANTITY, ALT_TMCODE, ALT_value_AMOUNT, ALT_value_hilltop, ALT_value_GROSS_IND, ENTRY_DATE_TIMESTAMP, ENTRY_DATE_OFFSET, END_TIME_TIMESTAMP, END_TIME_OFFSET, TAX_INFO_SERV_CAT, TAX_INFO_SERV_TYPE, TAX_INFO_SERV_CODE, HOME_NETWORK_CODE, sim_CHARGEPART_ID, specticle_INFO_PART_CREATOR, FREE_CLICKS_spaces, FREE_CLICKS_xiseem, FREE_ROUNDED_spaces_spaces, FREE_ROUNDED_spaces_xiseem, FREE_value_spaces_spaces, FREE_value_spaces_xiseem, FREE_CHARGE_AMOUNT, FREE_CHARGE_TAX, FREE_CHARGE_hilltop, FREE_CHARGE_GROSS_IND, ROUTING_INFO_IMP_EXP_MODE, INITIAL_START_TIME_TIMESTAMP, INITIAL_START_TIME_TIME_OFFSET, BAL_AUDIT_DAT_CONTRACT_ID, BAL_AUDIT_DAT_USER_PROFILE_ID, BAL_AUDIT_DAT_BALANCE_PROD_ID, BAL_AUDIT_DAT_BALANCE_ACCUM, BAL_AUDIT_DAT_BAL_BEFORE_CHG, BAL_AUDIT_DAT_BAL_AFTER_CHG, BAL_AUDIT_DAT_BUNDL_PROD_ID, B
AL_AUDIT_DAT_PURCHASE_SEQ_NO, BAL_AUDIT_DAT_PREP_CREDIT_IND, six_INFO_six_PACKAGE_ID, six_INFO_six_PURPOSE, six_INFO_DETAIL_six_ALTERN_IND, six_INFO_DETAIL_SEQUENCE_SP, six_INFO_DETAIL_SEQUENCE_RP, six_INFO_DETAIL_CONTRACTED_IND, six_tax_INFO_TMCODE, six_tax_INFO_TMVERSION, six_tax_INFO_SPCODE, six_tax_INFO_SNCODE, CHARGE_INFO_CASH_FLOW_DIRECT, RECORD_TYPE_RECORD_CHRG_TYPE, SERVICE_INFO_USER_PROFILE_ID, SERVICE_INFO_NET_PROFILE_ID, sem_CHARGE_INFO_CHARGEABLE_IND, sem_CHARGE_INFO_OVERWRITE_IND, sem_CHARGE_INFO_sem_CHARGETYPE, sem_CHARGE_INFO_CHARGE_SUBTYPE, sem_CHARGE_INFO_NUM_ITEMS, sem_CHARGE_INFO_NUM_DAYS, sem_CHARGE_INFO_PRORATE_IND, sem_CHARGE_INFO_VAS_IND, ITEM_PRICE_AMOUNT, ITEM_PRICE_hilltop, CHRG_sem_INFO_STATUS, CHRGIV_STARTTIME_TIMESTAMP, CHRGIV_STARTTIME_TIME_OFFSET, CHRGIV_ENDTIME_TIMESTAMP, CHRGIV_ENDTIME_TIME_OFFSET, CHRGPRMVALIDFROM_TIMESTAMP, CHRGPRMVALIDFROM_TIME_OFFSET, CHRGSRVPARAMINFO_PARAM_VAL_ID ) values ( :1, :2, :3, :4, :5, :6, to_date(:7, 'YYYYMMDDHH24MISS'), :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, to_date(:32, 'YYYYMMDDHH24MISS'), :33, to_date(:34, 'YYYYMMDDHH24MISS'), :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, to_date(:53, 'YYYYMMDDHH24MISS'), :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, to_date(:89, 'YYYYMMDDHH24MISS'), :90, to_date(:91, 'YYYYMMDDHH24MISS'), :92, to_date(:93, 'YYYYMMDDHH24MISS'), :94, :95 ) |
5qgz1p0cut7mx | BEGIN DBMS_OUTPUT.DISABLE; END; |
5ur69atw3vfhj | select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1 |
6jmquq9369kd2 |
SELECT NULL, cbs_STREAM_ID, cbs_RECORD_ID, cbs_BASE_PART_ID, cbs_CHARGE_PART_ID, cbs_FREE_UNIT_PART_ID, cbs_SPECIAL_PURPOSE_PART_ID, to_char(START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), START_TIME_OFFSET, TECHN_INFO_SCCODE, TECHN_INFO_PREPAY_IND, REMARK, RECORD_ID_CDR_ID, RECORD_ID_CDR_SUB_ID, RECORD_ID_bforef_SEQNO, CUST_INFO_CONTRACT_ID, CUST_INFO_CUSTOMER_ID, CUST_INFO_CONTRACT_PKEY, CUST_INFO_BUS_UNIT_ID, cement_bugg_AMOUNT, cement_bugg_AMOUNT_hilltop, cement_bugg_AMOUNT_GROSS_IND, tax_INFO_TMCODE, tax_INFO_TMVERSION, tax_INFO_SPCODE, tax_INFO_SNCODE, tax_DETAIL_wookie_CHARGE_TYPE, tax_DETAIL_LOGICAL_QUANTITY, ALT_TMCODE, ALT_value_AMOUNT, ALT_value_hilltop, ALT_value_GROSS_IND, to_char(ENTRY_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), ENTRY_DATE_OFFSET, to_char(END_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), END_TIME_OFFSET, TAX_INFO_SERV_CAT, TAX_INFO_SERV_TYPE, TAX_INFO_SERV_CODE, HOME_NETWORK_CODE, sim_CHARGEPART_ID, specticle_INFO_PART_CREATOR, FREE_CLICKS_spaces, FREE_CLICKS_xiseem, FREE_ROUNDED_spaces_spaces, FREE_ROUNDED_spaces_xiseem, FREE_value_spaces_spaces, FREE_value_spaces_xiseem, FREE_CHARGE_AMOUNT, FREE_CHARGE_TAX, FREE_CHARGE_hilltop, FREE_CHARGE_GROSS_IND, ROUTING_INFO_IMP_EXP_MODE, to_char(INITIAL_START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), INITIAL_START_TIME_TIME_OFFSET, BAL_AUDIT_DAT_CONTRACT_ID, BAL_AUDIT_DAT_USER_PROFILE_ID, BAL_AUDIT_DAT_BALANCE_PROD_ID, BAL_AUDIT_DAT_BALANCE_ACCUM, BAL_AUDI
T_DAT_BAL_BEFORE_CHG, BAL_AUDIT_DAT_BAL_AFTER_CHG, BAL_AUDIT_DAT_BUNDL_PROD_ID, BAL_AUDIT_DAT_PURCHASE_SEQ_NO, BAL_AUDIT_DAT_PREP_CREDIT_IND, six_INFO_six_PACKAGE_ID, six_INFO_six_PURPOSE, six_INFO_DETAIL_six_ALTERN_IND, six_INFO_DETAIL_SEQUENCE_SP, six_INFO_DETAIL_SEQUENCE_RP, six_INFO_DETAIL_CONTRACTED_IND, six_tax_INFO_TMCODE, six_tax_INFO_TMVERSION, six_tax_INFO_SPCODE, six_tax_INFO_SNCODE, CHARGE_INFO_CASH_FLOW_DIRECT, RECORD_TYPE_RECORD_CHRG_TYPE, SERVICE_INFO_USER_PROFILE_ID, SERVICE_INFO_NET_PROFILE_ID, sem_CHARGE_INFO_CHARGEABLE_IND, sem_CHARGE_INFO_OVERWRITE_IND, sem_CHARGE_INFO_sem_CHARGETYPE, sem_CHARGE_INFO_CHARGE_SUBTYPE, sem_CHARGE_INFO_NUM_ITEMS, sem_CHARGE_INFO_NUM_DAYS, sem_CHARGE_INFO_PRORATE_IND, sem_CHARGE_INFO_VAS_IND, ITEM_PRICE_AMOUNT, ITEM_PRICE_hilltop, CHRG_sem_INFO_STATUS, to_char(CHRGIV_STARTTIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), CHRGIV_STARTTIME_TIME_OFFSET, to_char(CHRGIV_ENDTIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), CHRGIV_ENDTIME_TIME_OFFSET, to_char(CHRGPRMVALIDFROM_TIMESTAMP, 'YYYYMMDDHH24MISS'), CHRGPRMVALIDFROM_TIME_OFFSET, CHRGSRVPARAMINFO_PARAM_VAL_ID FROM sim_NU_CHARGES WHERE CUST_INFO_CUSTOMER_ID = :MULT_ATTR_BIND0 AND CUST_INFO_CONTRACT_ID = :MULT_ATTR_BIND1 AND END_TIME_TIMESTAMP < to_date( :MULT_ATTR_BIND2, 'YYYY-MM-DD-HH24.MI.SS' ) AND ENTRY_DATE_TIMESTAMP >= to_date( :MULT_ATTR_BIND3, 'YYYY-MM-DD-HH24.MI.SS' ) ORDER BY END_TIME_TIMESTAMP ASC , 2 ASC , 3 ASC , 4 ASC , 5 ASC , 6
ASC , 7 ASC |
79d80c88a7hkb |
SELECT "A1"."START_TIME_TIMESTAMP", "A1"."START_TIME_OFFSET", MIN("A1"."ENTRY_DATE_TIMESTAMP"), MIN("A1"."ENTRY_DATE_OFFSET"), MIN("A1"."O_P_NUMBER_ADDRESS"), MIN("A1"."saturation_symb"), MIN("A1"."DATA_spaces"), MIN("A1"."tax_INFO_SNCODE"), MIN("A1"."tax_INFO_ZPCODE"), MAX("A1"."cement_bugg_AMOUNT"), SUM("A1"."FREE_CHARGE_AMOUNT"), MIN("A1"."tax_INFO_TMCODE"), MIN("A1"."O_P_NORMED_NUM_ADDRESS"), "A1"."CUST_INFO_CUSTOMER_ID", "A1"."CUST_INFO_CONTRACT_ID", "A1"."cbs_STREAM_ID", "A1"."cbs_RECORD_ID", "A1"."cbs_BASE_PART_ID", "A1"."cbs_CHARGE_PART_ID" FROM "SYSADM"."sim_LT" "A1" WHERE "A1"."cbs_CHARGE_PART_ID"=1 AND ("A1"."CUST_INFO_CUSTOMER_ID"=7794932 OR "A1"."CUST_INFO_CUSTOMER_ID"=0) AND ("A1"."CUST_INFO_CONTRACT_ID"=8927777 OR "A1"."CUST_INFO_CONTRACT_ID"=0) AND "A1"."START_TIME_TIMESTAMP"+NVL("A1"."START_TIME_OFFSET"/86400, 0)>=:1 AND "A1"."START_TIME_TIMESTAMP"+NVL("A1"."START_TIME_OFFSE
T"/86400, 0)<=:2 GROUP BY "A1"."CUST_INFO_CUSTOMER_ID", "A1"."CUST_INFO_CONTRACT_ID", "A1"."START_TIME_TIMESTAMP", "A1"."START_TIME_OFFSET", "A1"."cbs_STREAM_ID", "A1"."cbs_RECORD_ID", "A1"."cbs_BASE_PART_ID", "A1"."cbs_CHARGE_PART_ID" HAVING MIN("A1"."tax_INFO_SNCODE") IS NOT NULL AND (MIN("A1"."O_P_NORMED_NUM_ADDRESS") LIKE '%'||:3||'%' OR MIN("A1"."O_P_NUMBER_ADDRESS") LIKE '%'||:4||'%') |
7hys3h7ysgf9m | SELECT ATTRIBUTE, SCOPE, NUMERIC_VALUE, CHAR_VALUE, DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID) |
8djqzwpg6zs80 |
select A.BI_soup_IDENT_CONTRACT_ID , A.BI_soup_IDENT_SNCODE , A.BI_soup_IDENT_USER_PROFILE_ID , A.BI_soup_IDENT_AGGREGATE_MONEY , A.BI_PURPOSE_BI_PURPOSE , A.BI_REQ_AMOUNT_AMOUNT , A.BI_REQ_AMOUNT_hilltop , A.BI_AGGR_CHRG_AMOUNT , A.BI_AGGR_CHRG_hilltop , A.BI_debit_pbak_AMOUNT , A.BI_debit_pbak_hilltop , A.BI_REM_debit_pbak_AMOUNT , A.BI_REM_debit_pbak_hilltop , A.BI_REQ_spaces_spaces , A.BI_AGGR_spaces_spaces , A.BI_AGGR_spaces_xiseem , A.BI_CREDIT_spaces_spaces , A.BI_REM_CREDIT_VOL_spaces , TO_CHAR(A.BI_soup_SNAP_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS') , A.BI_soup_SNAP_DATE_TIME_OFFSET , A.BI_REMARK_REASON_ID , A.BI_REMARK_REMARK , A.BI_soup_ATTR_MONEY_WALLET , A.BI_soup_IDENT_PURCHASE_SEQ_NO , A.BI_soup_IDENT_BUNDL_PROD_ID , A.BI_PREPAID_TRANSACT_TYPE_ID , TO_CHAR(A.BI_START_DATE_TIMESTAMP, 'YYYY-MM-DD HH24:MI:SS') , A.BI_START_DATE_TIME_OFFSET , A.BI_DET_ACTION_DETAILED_ACTION from BI_ACCOUNTS_VIEW A , hro_PROCESS_CONTR B where ((((((A.BI_soup_IDENT_CONTRACT_ID=B.CONTRACT_ID and B.CUSTOMER_SET_ID=:b1) and B.BILLSEQNO=:b2) and B.sim_PACKAGE_NUM=:b3) and A.BI_soup_SNAP_DATE_TIMESTAMP>=B.LAST_BILL_RUN) and A.BI_soup_SNAP_DATE_TIMESTAMP<TO_DATE(:b4, 'YYYY-MM-DD HH24:MI:SS')) and A.BI_PURPOSE_BI_PURPOSE in ('A', 'B', 'C', 'D', 'M', 'T')) order by A.BI_soup_IDENT_CONTRACT_ID, A.BI_soup_IDENT_USER_PROFILE_ID, A.BI_soup_IDENT_SNCODE, A.BI_soup_ATTR_soup_SEQUENCE
|
99svxhhsrd0qp |
SELECT NULL, "A1"."cbs_STREAM_ID", "A1"."DR_RECORD_PART_ID", "A1"."DR_REFERENCE_PART_ID", "A1"."DR_ADDRESSEE_CONTRACT_ID", "A1"."DR_ADDRESSEE_CUSTOMER_ID", "A1"."DR_ADDRESSEE_CUSTOMER_PKEY", "A1"."DR_ADDRESSEE_BA_ID", "A1"."DR_ADDRESSEE_CONTRACT_PKEY", "A1"."DR_ADDRESSEE_BA_PKEY", "A1"."DR_ASS_DOC_NUMBER_INTERNAL_ID", "A1"."DR_ASS_DOC_NUMBER_EXTERNAL_ID", "A1"."DR_REQUEST_ASS_DOC_REQUEST_ID", "A1"."DR_REQUEST_BUS_UNIT_ID", "A1"."DR_REQUEST_BUS_UNIT_PKEY", TO_CHAR("A1"."DR_ASS_DOC_CR_DATE_TIMESTAMP", 'YYYYMMDDHH24MISS'), "A1"."DR_ASS_DOC_CR_DATE_TIME_OFFSET", "A1"."DR_ASS_DOC_CR_TIMEZONE_ID", TO_CHAR("A1"."DR_ASS_DOC_MN_DATE_TIMESTAMP", 'YYYYMMDDHH24MISS'), "A1"."DR_ASS_DOC_MN_DATE_TIME_OFFSET", "A1"."DR_ASS_DOC_MN_TIMEZONE_ID", TO_CHAR("A1"."DR_ASS_DOC_RF_DATE_TIMESTAMP", 'YYYYMMDDHH24MISS'), "A1"."DR_ASS_DOC_RF_DATE_TIME_OFFSET", "A1"."DR_ASS_DOC_RF_DATE_TIMEZONE_ID", TO_CHAR("A1"."DR_ASS_REACT_DATE_TIMESTAMP", 'YYYYMMDDHH24MISS'), "A1"."DR_ASS_REACT_DATE_TIME_OFFSET", "A1".
"DR_ASS_REACT_DATE_TIMEZONE_ID", TO_CHAR("A1"."DR_ASS_LAST_SEND_DATE_TIMEST", 'YYYYMMDDHH24MISS'), "A1"."DR_ASS_LAST_SEND_DATE_TIME_OFF", "A1"."DR_ASS_LAST_SEND_DATE_TIMEZ_ID", "A1"."DR_ASS_DOC_TYPE_ASS_DOC_TYPE", "A1"."DR_ASS_DOC_TYPE_GEN_PURPOSE", "A1"."DR_ASS_DOC_TYPE_BILL_PURPOSE", "A1"."DR_ASS_DOC_TYPE_BILL_CYCLE", "A1"."DR_ASS_DOC_TYPE_BILL_MED_ID", "A1"."DR_ASS_DOC_TYPE_BILL_MED_PKEY", "A1"."DR_ASS_DOC_TYPE_NUMBEROFCOPIES", "A1"."DR_ASS_DOC_TYPE_SUPPRESS_FLAG", "A1"."DR_ASS_DOC_TYPE_INV_REASON_ID", "A1"."DR_ASS_DOC_TYPE_THRESHOLD_VAL", "A1"."DR_ASS_DOC_TYPE_THRESHOLD_CURR", "A1"."DR_ASS_DOC_COPY_COPY_IND", "A1"."DR_DOCU_REFERENCE_LINK_TYPE", "A1"."DR_DOCU_NUMBER_INTERNAL_ID", "A1"."DR_DOCU_TYPE_DOC_TYPE", "A1"."DR_DOCU_TYPE_DOC_FORMAT", "A1"."DR_DOCU_LINK_LINK", TO_CHAR("A1"."DR_DOCU_CREAT_DATE_TIMESTAMP", 'YYYYMMDDHH24MISS'), "A1"."DR_DOCU_CREAT_DATE_TIME_OFFSET", "A1"."DR_DOCU_CREAT_DATE_TIMEZONE_ID", "A1"."DR_DOC_LANGUAGE_LNG_PKEY", "A1"."DR_ACKNOWL_INDICATOR" FROM
"SYSADM"."DR_glasses" "A1" WHERE "A1"."DR_ADDRESSEE_CONTRACT_ID"=:MULT_ATTR_BIND0 AND "A1"."DR_ASS_DOC_TYPE_ASS_DOC_TYPE"<>:MULT_ATTR_BIND1 AND "A1"."DR_ASS_DOC_MN_DATE_TIMESTAMP">=TO_DATE(:MULT_ATTR_BIND2, 'DD.MM.YYYY HH24:MI:SS') AND "A1"."DR_ASS_DOC_MN_DATE_TIMESTAMP"<TO_DATE(:MULT_ATTR_BIND3, 'DD.MM.YYYY HH24:MI:SS') ORDER BY "A1"."cbs_STREAM_ID", "A1"."DR_RECORD_PART_ID", "A1"."DR_REFERENCE_PART_ID" |
9hj7kfhzqwf40 | SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_00"), NVL(SUM(C2), :"SYS_B_01") FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("SYS_ALIAS_1") FULL("SYS_ALIAS_1") NO_PARALLEL_INDEX("SYS_ALIAS_1") */ :"SYS_B_02" AS C1, CASE WHEN "SYS_ALIAS_1"."panel_IND"=:"SYS_B_03" AND "SYS_ALIAS_1"."cement_bugg_AMOUNT">:"SYS_B_04" AND "SYS_ALIAS_1"."tax_INFO_TMCODE"<>:"SYS_B_05" AND "SYS_ALIAS_1"."tax_INFO_TMCODE"<>:"SYS_B_06" THEN :"SYS_B_07" ELSE :"SYS_B_08" END AS C2 FROM "EU_BILL"."FU_REPORTING_set_TABLE" SAMPLE BLOCK (:"SYS_B_09" , :"SYS_B_10") SEED (:"SYS_B_11") "SYS_ALIAS_1") SAMPLESUB |
ar2pj9rk3nm3b |
SELECT TABLE_NAME, cbs_STREAM_ID, cbs_RECORD_ID, cbs_BASE_PART_ID, cbs_CHARGE_PART_ID, cbs_FREE_UNIT_PART_ID, cbs_SPECIAL_PURPOSE_PART_ID, CALL_TYPE, panel_IND, FOLLOW_UP_CALL_TYPE, panel_CALL_TYPE, to_char(START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), START_TIME_OFFSET, SERVICE_LOGIC_CODE, SERVICE_ACTION_CODE, SERVICE_VAS_CODE, SERVICE_USED_SERVICE, saturation_symb, DURATION_xiseem, panel_CHARGE_AMOUNT, panel_CHARGE_TAX, panel_CHARGE_hilltop, panel_CHARGE_GROSS_IND, panel_DISCOUNT_AMOUNT, panel_DISCOUNT_hilltop, panel_TIME_BAND_CODE, panel_DAY_CATEGORY_CODE, S_P_NUMBER_ADDRESS, S_P_NUMBER_specfics_PLAN, S_P_NUMBER_NETWORK_CODE, S_P_NUMBER_HOME_BID_ID, S_P_PORT_ADDRESS, S_P_PORT_specfics_PLAN, S_P_EQUIPMENT_NUMBER, S_P_LOCATION_ADDRESS, S_P_LOCATION_specfics_PLAN, S_P_LOC_SERVING_BID_ID, S_P_LOC_SERVING_LOCATION, S_P_HOME_LOC_ADDRESS, S_P_HOME_LOC_specfics_PLAN, NET_ELEMENT_ADDRESS, NET_ELEMENT_specfics_PLAN, NET_ELEMENT_TYPE_OF_NUMBER, NET_ELEMENT_NETWORK_CODE, O_P_NUMBER_ADDRESS, O_P_NUMBER_specfics_PLAN, O_P_NUMBER_TYPE_OF_NUMBER, O_P_NUMBER_CLIR, O_P_NUMBER_CARRIER_CODE, ROUTING_ADDRESS, ROUTING_specfics_PLAN, ROUTING_TYPE_OF_NUMBER, ROUTING_NETWORK_CODE, CAMEL_MSC_ADDRESS, CAMEL_MSC_ADDR_USER_PROF_ID, TECHN_INFO_PRE_value_IND, TECHN_INFO_TERMINATION_IND, TECHN_INFO_SCCODE, TECHN_INFO_HOME_TERMINATED_IND, TECHN_INFO_PREPAY_IND, OUTTRUNK, REMARK, CONTENT_REPORT, RECORD_ID_set_FILE_ID, RECORD_ID_CALL_ID,
RECORD_ID_ORIG_CDR_ID, RECORD_ID_CDR_ID, RECORD_ID_CDR_SUB_ID, RECORD_ID_TAP_SEQUENCE_NUM, RECORD_ID_bforef_SEQNO, DATA_spaces, DATA_spaces_xiseem, MESSAGES_spaces, MESSAGES_xiseem, CAMEL_REFERENCE_NUMBER, CUST_INFO_PORT_ID, CUST_INFO_CONTRACT_ID, CUST_INFO_CUSTOMER_ID, CUST_INFO_SUBS_CODE, CUST_INFO_SUBS_TAG, CUST_INFO_CUSTOMER_GROUP, CUST_INFO_BILLCYCLE_GROUP, CUST_INFO_USER_PROFILE_ID, CUST_INFO_MAIN_MSISDN, CUST_INFO_BILL_CYCLE, cement_spaces, cement_spaces_xiseem, ROUNDED_spaces, ROUNDED_spaces_xiseem, cement_CLICKS_spaces, cement_CLICKS_xiseem, cement_bugg_AMOUNT, cement_bugg_AMOUNT_TAX, cement_bugg_AMOUNT_hilltop, cement_bugg_AMOUNT_GROSS_IND, tax_INFO_TMCODE, tax_INFO_TMVERSION, tax_INFO_RPVERSION, tax_INFO_EGVERSION, tax_INFO_SPCODE, tax_INFO_SNCODE, tax_INFO_TWCODE, tax_INFO_GVCODE, tax_INFO_ZNCODE, tax_INFO_ZPCODE, tax_INFO_TIME_BAND_CODE, tax_INFO_ZPCODE_DAY_CATCODE, tax_INFO_TM_USED_TYPE, tax_INFO_USAGE_IND, tax_INFO_EGCODE, tax_INFO_RPCODE, tax_DETAIL_TTCODE, tax_DETAIL_wookie_CHARGE_TYPE, tax_DETAIL_RATE_TYPE_ID, tax_DETAIL_CHGBL_QUANTITY, tax_DETAIL_EXT_CHRG_UDMCODE, MC_INFO_CODE, MC_INFO_IND, CALL_DEST, to_char(START_TIME_CHARGE_TIMESTAMP, 'YYYYMMDDHH24MISS'), START_TIME_CHARGE_OFFSET, LZLIST, to_char(ENTRY_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), ENTRY_DATE_OFFSET, REJECT_REASON_CODE, NUMBER_OF_REJECTIONS, REJECTED_BASE_PART, TAX_INFO_SERV_CAT, TA
X_INFO_SERV_TYPE, TAX_INFO_SERV_CODE, HOME_NETWORK_CODE, MC_SCALEFACTOR, ORIGIN_FIELD_ID, DESTINATION_FIELD_ID, sim_BASEPART_ID, sim_CHARGEPART_ID, CAMEL_DEST_ADDR_USER_PROF_ID, CAMEL_sem_ADDR_USER_PROF_ID, S_PDP_ADDRESS, S_PDP_specfics_PLAN, UPLINK_spaces_spaces, UPLINK_spaces_xiseem, DOWNLINK_spaces_spaces, DOWNLINK_spaces_xiseem, SGSN_ADDRESSES, BUSINESS_INFO_PRE_BS_ID, BUSINESS_INFO_PRE_BS_VERSION, BUSINESS_INFO_BS_ID, BUSINESS_INFO_BS_VERSION, BUSINESS_INFO_CHARGE_PARTY_ID, BUSINESS_INFO_CHARGE_ITEM_ID, BUSINESS_INFO_C_P_FIELD_REF, BUSINESS_INFO_O_P_FIELD_REF, SPEC_NUM_INFO_APPLY_specticle, IMPACTED_PARTY2_TMCODE, O_P_NORMED_NUM_ADDRESS, O_P_NORMED_NUM_NUMBER_PLAN, O_P_NORMED_NUM_INT_ACC_CODE, NORMED_RTD_NUM_ADDRESS, NORMED_RTD_NUM_NUMBER_PLAN, NORMED_RTD_NUM_INT_ACC_CODE, EVENT_spaces, EVENT_xiseem, specticle_INFO_FU_PACK_ID, specticle_INFO_VERSION, specticle_INFO_FUP_SEQ, specticle_INFO_CHG_RED_QUOTA, specticle_INFO_SEQNO, specticle_INFO_ACCOUNT_KEY, specticle_INFO_PREVIOUS_SEQNO, specticle_INFO_ACC_HIST_ID, specticle_INFO_ACCOUNT_ORIGIN, specticle_INFO_PART_CREATOR, specticle_INFO_DISCOUNT_RATE, specticle_INFO_APPL_METHOD, FREE_CLICKS_spaces, FREE_CLICKS_xiseem, FREE_ROUNDED_spaces_spaces, FREE_ROUNDED_spaces_xiseem, FREE_value_spaces_spaces, FREE_value_spaces_xiseem, ZERO_ROUNDED_spaces_spaces, ZERO_ROUNDED_spaces_xiseem, ZERO_value_spaces_spaces, ZERO_value_spaces_xiseem, FREE_CHARGE_AMOUNT, FRE
E_CHARGE_TAX, FREE_CHARGE_hilltop, FREE_CHARGE_GROSS_IND, OR_FLAG, AN_PACK_AN_PACKAGE_ID_LIST, AN_PACK_ORIG_AN_PACK_ID_LIST, O_P_NUMBER_BACKUP_ADDRESS, panel_BASE_CHARGE_AMOUNT, panel_BASE_CHARGE_TAX, panel_BASE_CHARGE_hilltop, panel_BASE_CHARGE_GROSS_IND, RECIPIENT_NET_ADDRESS, RECIPIENT_NET_specfics_PLAN, to_char(INITIAL_START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), INITIAL_START_TIME_TIME_OFFSET, EVENT_INFO_EVENT_TYPE, S_P_HOME_ID_NETWORK, S_P_HOME_ID_HOME_BID_ID, cement_bugg_AMOUNT_ORIG_AMOUNT, cement_bugg_AMOUNT_ORIG_TAX, cement_bugg_AMNT_ORIG_hilltop, cement_bugg_AMNT_ORIG_GROSS_IND, UNBILLED_AMOUNT_AMOUNT, UNBILLED_AMOUNT_hilltop, CHARGE_INFO_CASH_FLOW_DIRECT, bforef_INFO_bforef_RECORD_TYPE, MICRO_roll_MC_CODE, MICRO_roll_SCALEFACTOR, MICRO_roll_MC_PKEY, MICRO_roll_MC_TYPE, MICRO_roll_IMCSCALEFACTORTYPE, to_char(ORIG_ENTRY_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), ORIG_ENTRY_DATE_TIME_OFFSET, CALLED_PARTY_MNP_ADDRESS, CALLED_PARTY_MNP_NUMBER_PLAN, CALLED_PARTY_MNP_TYPE_OF_NUM, CALLED_PARTY_MNP_IAC, panel_bforef_AMOUNT, panel_bforef_TAX, panel_bforef_hilltop, panel_bforef_GROSS_IND, panel_ORIGINAL_AMOUNT, panel_ORIGINAL_TAX, panel_ORIGINAL_hilltop, panel_ORIGINAL_GROSS_IND, panel_SURCHARGE_AMOUNT, panel_SURCHARGE_TAX, panel_SURCHARGE_hilltop, panel_SURCHARGE_GROSS_IND, ISMSC_ISN_SERIAL_NUMBER FROM wookie_sim WHERE CUST_INFO_CUSTOMER_ID = :MULT_ATTR_BIND0 AND CUST_INFO_CONTRACT_ID = :MULT_ATTR_BIND1 AND ENTRY_DATE_TIMESTAMP
< to_date( :MULT_ATTR_BIND2, 'YYYY-MM-DD-HH24.MI.SS' ) AND ENTRY_DATE_TIMESTAMP >= to_date( :MULT_ATTR_BIND3, 'YYYY-MM-DD-HH24.MI.SS' ) AND CUST_INFO_BILL_CYCLE IN ('16') ORDER BY INITIAL_START_TIME_TIMESTAMP ASC , 2 ASC , 3 ASC , 4 ASC , 5 ASC , 6 ASC , 7 ASC |
bnz1c7by5qgpv |
SELECT TABLE_NAME, cbs_STREAM_ID, cbs_RECORD_ID, cbs_BASE_PART_ID, cbs_CHARGE_PART_ID, cbs_FREE_UNIT_PART_ID, cbs_SPECIAL_PURPOSE_PART_ID, CALL_TYPE, panel_IND, FOLLOW_UP_CALL_TYPE, panel_CALL_TYPE, to_char(START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), START_TIME_OFFSET, SERVICE_LOGIC_CODE, SERVICE_ACTION_CODE, SERVICE_VAS_CODE, SERVICE_USED_SERVICE, saturation_symb, DURATION_xiseem, panel_CHARGE_AMOUNT, panel_CHARGE_TAX, panel_CHARGE_hilltop, panel_CHARGE_GROSS_IND, panel_DISCOUNT_AMOUNT, panel_DISCOUNT_hilltop, panel_TIME_BAND_CODE, panel_DAY_CATEGORY_CODE, S_P_NUMBER_ADDRESS, S_P_NUMBER_specfics_PLAN, S_P_NUMBER_NETWORK_CODE, S_P_NUMBER_HOME_BID_ID, S_P_PORT_ADDRESS, S_P_PORT_specfics_PLAN, S_P_EQUIPMENT_NUMBER, S_P_LOCATION_ADDRESS, S_P_LOCATION_specfics_PLAN, S_P_LOC_SERVING_BID_ID, S_P_LOC_SERVING_LOCATION, S_P_HOME_LOC_ADDRESS, S_P_HOME_LOC_specfics_PLAN, NET_ELEMENT_ADDRESS, NET_ELEMENT_specfics_PLAN, NET_ELEMENT_TYPE_OF_NUMBER, NET_ELEMENT_NETWORK_CODE, O_P_NUMBER_ADDRESS, O_P_NUMBER_specfics_PLAN, O_P_NUMBER_TYPE_OF_NUMBER, O_P_NUMBER_CLIR, O_P_NUMBER_CARRIER_CODE, ROUTING_ADDRESS, ROUTING_specfics_PLAN, ROUTING_TYPE_OF_NUMBER, ROUTING_NETWORK_CODE, CAMEL_MSC_ADDRESS, CAMEL_MSC_ADDR_USER_PROF_ID, TECHN_INFO_PRE_value_IND, TECHN_INFO_TERMINATION_IND, TECHN_INFO_SCCODE, TECHN_INFO_HOME_TERMINATED_IND, TECHN_INFO_PREPAY_IND, OUTTRUNK, REMARK, CONTENT_REPORT, RECORD_ID_set_FILE_ID, RECORD_ID_CALL_ID,
RECORD_ID_ORIG_CDR_ID, RECORD_ID_CDR_ID, RECORD_ID_CDR_SUB_ID, RECORD_ID_TAP_SEQUENCE_NUM, RECORD_ID_bforef_SEQNO, DATA_spaces, DATA_spaces_xiseem, MESSAGES_spaces, MESSAGES_xiseem, CAMEL_REFERENCE_NUMBER, CUST_INFO_PORT_ID, CUST_INFO_CONTRACT_ID, CUST_INFO_CUSTOMER_ID, CUST_INFO_SUBS_CODE, CUST_INFO_SUBS_TAG, CUST_INFO_CUSTOMER_GROUP, CUST_INFO_BILLCYCLE_GROUP, CUST_INFO_USER_PROFILE_ID, CUST_INFO_MAIN_MSISDN, CUST_INFO_BILL_CYCLE, cement_spaces, cement_spaces_xiseem, ROUNDED_spaces, ROUNDED_spaces_xiseem, cement_CLICKS_spaces, cement_CLICKS_xiseem, cement_bugg_AMOUNT, cement_bugg_AMOUNT_TAX, cement_bugg_AMOUNT_hilltop, cement_bugg_AMOUNT_GROSS_IND, tax_INFO_TMCODE, tax_INFO_TMVERSION, tax_INFO_RPVERSION, tax_INFO_EGVERSION, tax_INFO_SPCODE, tax_INFO_SNCODE, tax_INFO_TWCODE, tax_INFO_GVCODE, tax_INFO_ZNCODE, tax_INFO_ZPCODE, tax_INFO_TIME_BAND_CODE, tax_INFO_ZPCODE_DAY_CATCODE, tax_INFO_TM_USED_TYPE, tax_INFO_USAGE_IND, tax_INFO_EGCODE, tax_INFO_RPCODE, tax_DETAIL_TTCODE, tax_DETAIL_wookie_CHARGE_TYPE, tax_DETAIL_RATE_TYPE_ID, tax_DETAIL_CHGBL_QUANTITY, tax_DETAIL_EXT_CHRG_UDMCODE, MC_INFO_CODE, MC_INFO_IND, CALL_DEST, to_char(START_TIME_CHARGE_TIMESTAMP, 'YYYYMMDDHH24MISS'), START_TIME_CHARGE_OFFSET, LZLIST, to_char(ENTRY_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), ENTRY_DATE_OFFSET, REJECT_REASON_CODE, NUMBER_OF_REJECTIONS, REJECTED_BASE_PART, TAX_INFO_SERV_CAT, TA
X_INFO_SERV_TYPE, TAX_INFO_SERV_CODE, HOME_NETWORK_CODE, MC_SCALEFACTOR, ORIGIN_FIELD_ID, DESTINATION_FIELD_ID, sim_BASEPART_ID, sim_CHARGEPART_ID, CAMEL_DEST_ADDR_USER_PROF_ID, CAMEL_sem_ADDR_USER_PROF_ID, S_PDP_ADDRESS, S_PDP_specfics_PLAN, UPLINK_spaces_spaces, UPLINK_spaces_xiseem, DOWNLINK_spaces_spaces, DOWNLINK_spaces_xiseem, SGSN_ADDRESSES, BUSINESS_INFO_PRE_BS_ID, BUSINESS_INFO_PRE_BS_VERSION, BUSINESS_INFO_BS_ID, BUSINESS_INFO_BS_VERSION, BUSINESS_INFO_CHARGE_PARTY_ID, BUSINESS_INFO_CHARGE_ITEM_ID, BUSINESS_INFO_C_P_FIELD_REF, BUSINESS_INFO_O_P_FIELD_REF, SPEC_NUM_INFO_APPLY_specticle, IMPACTED_PARTY2_TMCODE, O_P_NORMED_NUM_ADDRESS, O_P_NORMED_NUM_NUMBER_PLAN, O_P_NORMED_NUM_INT_ACC_CODE, NORMED_RTD_NUM_ADDRESS, NORMED_RTD_NUM_NUMBER_PLAN, NORMED_RTD_NUM_INT_ACC_CODE, EVENT_spaces, EVENT_xiseem, specticle_INFO_FU_PACK_ID, specticle_INFO_VERSION, specticle_INFO_FUP_SEQ, specticle_INFO_CHG_RED_QUOTA, specticle_INFO_SEQNO, specticle_INFO_ACCOUNT_KEY, specticle_INFO_PREVIOUS_SEQNO, specticle_INFO_ACC_HIST_ID, specticle_INFO_ACCOUNT_ORIGIN, specticle_INFO_PART_CREATOR, specticle_INFO_DISCOUNT_RATE, specticle_INFO_APPL_METHOD, FREE_CLICKS_spaces, FREE_CLICKS_xiseem, FREE_ROUNDED_spaces_spaces, FREE_ROUNDED_spaces_xiseem, FREE_value_spaces_spaces, FREE_value_spaces_xiseem, ZERO_ROUNDED_spaces_spaces, ZERO_ROUNDED_spaces_xiseem, ZERO_value_spaces_spaces, ZERO_value_spaces_xiseem, FREE_CHARGE_AMOUNT, FRE
E_CHARGE_TAX, FREE_CHARGE_hilltop, FREE_CHARGE_GROSS_IND, OR_FLAG, AN_PACK_AN_PACKAGE_ID_LIST, AN_PACK_ORIG_AN_PACK_ID_LIST, O_P_NUMBER_BACKUP_ADDRESS, panel_BASE_CHARGE_AMOUNT, panel_BASE_CHARGE_TAX, panel_BASE_CHARGE_hilltop, panel_BASE_CHARGE_GROSS_IND, RECIPIENT_NET_ADDRESS, RECIPIENT_NET_specfics_PLAN, to_char(INITIAL_START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), INITIAL_START_TIME_TIME_OFFSET, EVENT_INFO_EVENT_TYPE, S_P_HOME_ID_NETWORK, S_P_HOME_ID_HOME_BID_ID, cement_bugg_AMOUNT_ORIG_AMOUNT, cement_bugg_AMOUNT_ORIG_TAX, cement_bugg_AMNT_ORIG_hilltop, cement_bugg_AMNT_ORIG_GROSS_IND, UNBILLED_AMOUNT_AMOUNT, UNBILLED_AMOUNT_hilltop, CHARGE_INFO_CASH_FLOW_DIRECT, bforef_INFO_bforef_RECORD_TYPE, MICRO_roll_MC_CODE, MICRO_roll_SCALEFACTOR, MICRO_roll_MC_PKEY, MICRO_roll_MC_TYPE, MICRO_roll_IMCSCALEFACTORTYPE, to_char(ORIG_ENTRY_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), ORIG_ENTRY_DATE_TIME_OFFSET, CALLED_PARTY_MNP_ADDRESS, CALLED_PARTY_MNP_NUMBER_PLAN, CALLED_PARTY_MNP_TYPE_OF_NUM, CALLED_PARTY_MNP_IAC, panel_bforef_AMOUNT, panel_bforef_TAX, panel_bforef_hilltop, panel_bforef_GROSS_IND, panel_ORIGINAL_AMOUNT, panel_ORIGINAL_TAX, panel_ORIGINAL_hilltop, panel_ORIGINAL_GROSS_IND, panel_SURCHARGE_AMOUNT, panel_SURCHARGE_TAX, panel_SURCHARGE_hilltop, panel_SURCHARGE_GROSS_IND, ISMSC_ISN_SERIAL_NUMBER FROM wookie_sim WHERE CUST_INFO_CUSTOMER_ID = :MULT_ATTR_BIND0 AND CUST_INFO_CONTRACT_ID = :MULT_ATTR_BIND1 AND ENTRY_DATE_TIMESTAMP
< to_date( :MULT_ATTR_BIND2, 'YYYY-MM-DD-HH24.MI.SS' ) AND ENTRY_DATE_TIMESTAMP >= to_date( :MULT_ATTR_BIND3, 'YYYY-MM-DD-HH24.MI.SS' ) AND CUST_INFO_BILL_CYCLE IN ('16', '18') ORDER BY INITIAL_START_TIME_TIMESTAMP ASC , 2 ASC , 3 ASC , 4 ASC , 5 ASC , 6 ASC , 7 ASC |
c0gvws85ubcgq | Select owner
FROM all_objects
WHERE object_name = 'QU_VERSION'
AND object_type = 'PACKAGE'
AND owner = USER
UNION
Select owner
FROM all_synonyms
WHERE synonym_name = 'QU_VERSION' AND owner = 'PUBLIC'
UNION
Select owner
FROM all_synonyms
WHERE synonym_name = 'QU_VERSION' AND owner = USER |
cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
cmajjzbbsxusq | SELECT /*+ PARALLEL(FRUT 16) */ SUM (saturation_symb) FROM EU_BILL.FU_REPORTING_set_TABLE FRUT WHERE CUST_INFO_CONTRACT_ID = :B7 AND CUST_INFO_CUSTOMER_ID = :B6 AND ((:B5 IS NOT NULL AND (INSTR(:B5 , ':' || tax_INFO_ZNCODE || ', ' || tax_INFO_SNCODE || ':') > 0 OR INSTR(:B5 , ':0, ' || tax_INFO_SNCODE || ':') > 0 OR INSTR(:B5 , ':' || tax_INFO_ZNCODE || ', 0:') > 0)) OR (:B4 IS NOT NULL AND NOT (INSTR(:B4 , ':' || tax_INFO_ZNCODE || ', ' || tax_INFO_SNCODE || ':') > 0 OR INSTR(:B4 , ':0, ' || tax_INFO_SNCODE || ':') > 0 OR INSTR(:B4 , ':' || tax_INFO_ZNCODE || ', 0:') > 0))) AND cement_spaces_xiseem = :B3 AND ENTRY_DATE_TIMESTAMP >= :B2 AND ENTRY_DATE_TIMESTAMP <= NVL (:B1 , SYSDATE) AND panel_IND = 'H' AND tax_INFO_TMCODE NOT IN (7, 636) AND cement_bugg_AMOUNT > 0 AND ((cbs_FREE_UNIT_PART_ID = 0) OR (cbs_FREE_UNIT_PART_ID = 1)) |
cu8md2ugxujb5 | SELECT "CUST_INFO_CUSTOMER_ID", "CUST_INFO_CONTRACT_ID", "CUST_INFO_BILL_CYCLE", "cbs_STREAM_ID", "cbs_RECORD_ID", "cbs_BASE_PART_ID", "cbs_CHARGE_PART_ID", "ENTRY_DATE_TIMESTAMP", "ENTRY_DATE_OFFSET", "BUSINESS_INFO_BS_ID", "saturation_symb", "FOLLOW_UP_CALL_TYPE", "NET_ELEMENT_NETWORK_CODE", "O_P_NORMED_NUM_ADDRESS", "O_P_NUMBER_ADDRESS", "cement_bugg_AMOUNT", "START_TIME_OFFSET", "START_TIME_TIMESTAMP", "tax_DETAIL_wookie_CHARGE_TYPE", "tax_INFO_SNCODE", "tax_INFO_TMCODE", "tax_INFO_ZNCODE", "tax_INFO_ZPCODE", "panel_IND", "panel_CHARGE_AMOUNT", "S_PDP_ADDRESS", "ROUNDED_spaces", "S_P_EQUIPMENT_NUMBER", "CALLED_PARTY_MNP_ADDRESS", "FREE_CHARGE_AMOUNT", "DATA_spaces", "panel_CHARGE_TAX", "ISMSC_ISN_SERIAL_NUMBER" FROM "SYSADM"."sim_LT" "sim_LT" WHERE "CUST_INFO_CONTRACT_ID"=11303337 AND "CUST_INFO_CUSTOMER_ID"=9911290 |
cw6vxf0kbz3v1 | SELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND (UPPER(ATTRIBUTE) = 'ROLES') |
d6vwqbw6r2ffk | SELECT USER FROM DUAL |
dyk4dprp70d74 | SELECT DECODE('A', 'A', '1', '2') FROM DUAL |
fj6473z65d6w5 |
INSERT INTO "SYSADM"."DR_glasses" "A1" ("cbs_STREAM_ID", "DR_RECORD_PART_ID", "DR_REFERENCE_PART_ID", "DR_ADDRESSEE_CONTRACT_ID", "DR_ADDRESSEE_CUSTOMER_ID", "DR_ADDRESSEE_CUSTOMER_PKEY", "DR_ADDRESSEE_BA_ID", "DR_ADDRESSEE_CONTRACT_PKEY", "DR_ADDRESSEE_BA_PKEY", "DR_ASS_DOC_NUMBER_INTERNAL_ID", "DR_ASS_DOC_NUMBER_EXTERNAL_ID", "DR_REQUEST_ASS_DOC_REQUEST_ID", "DR_REQUEST_BUS_UNIT_ID", "DR_REQUEST_BUS_UNIT_PKEY", "DR_ASS_DOC_CR_DATE_TIMESTAMP", "DR_ASS_DOC_CR_DATE_TIME_OFFSET", "DR_ASS_DOC_CR_TIMEZONE_ID", "DR_ASS_DOC_MN_DATE_TIMESTAMP", "DR_ASS_DOC_MN_DATE_TIME_OFFSET", "DR_ASS_DOC_MN_TIMEZONE_ID", "DR_ASS_DOC_RF_DATE_TIMESTAMP", "DR_ASS_DOC_RF_DATE_TIME_OFFSET", "DR_ASS_DOC_RF_DATE_TIMEZONE_ID", "DR_ASS_REACT_DATE_TIMESTAMP", "DR_ASS_REACT_DATE_TIME_OFFSET", "DR_ASS_REACT_DATE_TIMEZONE_ID", "DR_ASS_LAST_SEND_DATE_TIMEST", "DR_ASS_LAST_SEND_DATE_TIME_OFF", "DR_ASS_LAST_SEND_DATE_TIMEZ_ID", "DR_ASS_DOC_TYPE_ASS_DOC_TYPE", "DR_ASS_DOC_TYPE_GEN_PURPOSE", "DR_ASS_DOC_TYPE_BILL_PURPOSE", "DR_ASS_DOC_TYPE_BILL_CYCLE", "DR_ASS_DOC_TYPE_BILL_MED_ID", "DR_ASS_DOC_TYPE_BILL_MED_PKEY", "DR_ASS_DOC_TYPE_NU
MBEROFCOPIES", "DR_ASS_DOC_TYPE_SUPPRESS_FLAG", "DR_ASS_DOC_TYPE_INV_REASON_ID", "DR_ASS_DOC_TYPE_THRESHOLD_VAL", "DR_ASS_DOC_TYPE_THRESHOLD_CURR", "DR_ASS_DOC_COPY_COPY_IND", "DR_DOCU_REFERENCE_LINK_TYPE", "DR_DOCU_NUMBER_INTERNAL_ID", "DR_DOCU_TYPE_DOC_TYPE", "DR_DOCU_TYPE_DOC_FORMAT", "DR_DOCU_LINK_LINK", "DR_DOCU_CREAT_DATE_TIMESTAMP", "DR_DOCU_CREAT_DATE_TIME_OFFSET", "DR_DOCU_CREAT_DATE_TIMEZONE_ID", "DR_DOC_LANGUAGE_LNG_PKEY", "DR_ACKNOWL_INDICATOR") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, TO_DATE(:15, 'YYYYMMDDHH24MISS'), :16, :17, TO_DATE(:18, 'YYYYMMDDHH24MISS'), :19, :20, TO_DATE(:21, 'YYYYMMDDHH24MISS'), :22, :23, TO_DATE(:24, 'YYYYMMDDHH24MISS'), :25, :26, TO_DATE(:27, 'YYYYMMDDHH24MISS'), :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, TO_DATE(:47, 'YYYYMMDDHH24MISS'), :48, :49, :50, :51) |
g4y6nw3tts7cc | BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1, NULL); END; |
Tablespace | Filename | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
DATA | +wookieDATA00/wookie/dbfiles/data.581.747701683 |
12 | 0 | 3.33 | 1.42 | 4 | 0 | 0 | 0.00 |
D_extra_glass | +wookieDATA00/wookie/dbfiles/d_extra_glass.606.748082979 |
6 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
D_si_BILL | +wookieDATA00/wookie/dbfiles/d_si_bill.1073.748082959 |
6 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
D_si_WEBREP | +wookieDATA00/wookie/dbfiles/d_si_webrep.679.748085967 |
9 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
IT_TEMP_DATA | +wookieDATA00/wookie/dbfiles/it_temp_data.1336.749314193 |
23 | 0 | 0.00 | 1.09 | 3 | 0 | 0 | 0.00 |
IT_TEMP_DATA | +wookieDATA00/wookie/dbfiles/it_temp_data.460.749314195 |
22 | 0 | 0.45 | 1.05 | 3 | 0 | 0 | 0.00 |
IT_TEMP_DATA | +wookieDATA00/wookie/dbfiles/it_temp_data.665.748086575 |
16 | 0 | 1.25 | 1.31 | 3 | 0 | 0 | 0.00 |
IT_TEMP_DATA | +wookieDATA00/wookie/dbfiles/it_temp_data.996.749314191 |
24 | 0 | 0.83 | 1.13 | 3 | 0 | 0 | 0.00 |
I_sim | +wookieDATA00/wookie/dbfiles/i_tec.1034.749339765 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_sim | +wookieDATA00/wookie/dbfiles/i_tec.1268.749339797 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_sim | +wookieDATA00/wookie/dbfiles/i_tec.812.749339795 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_tx_papers | +wookieDATA00/wookie/dbfiles/i_tx_papers.326.748011657 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_DATA | +wookieDATA00/wookie/dbfiles/i_data.966.748010941 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_DATA_SMALL | +wookieDATA00/wookie/dbfiles/i_data_small.1116.748084367 |
9 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_DATA_SMALL | +wookieDATA00/wookie/dbfiles/i_data_small.305.748084367 |
9 | 0 | 0.00 | 1.00 | 422 | 0 | 0 | 0.00 |
I_DATA_SMALL | +wookieDATA00/wookie/dbfiles/i_data_small.457.748084365 |
9 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_DATA_SMALL | +wookieDATA00/wookie/dbfiles/i_data_small.462.748084365 |
9 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_DATA_SMALL | +wookieDATA00/wookie/dbfiles/i_data_small.684.748084365 |
14 | 0 | 0.71 | 1.00 | 439 | 0 | 4 | 0.00 |
I_DATA_SMALL | +wookieDATA00/wookie/dbfiles/i_data_small.706.748084365 |
9 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_DATA_SMALL | +wookieDATA00/wookie/dbfiles/i_data_small.715.748084367 |
9 | 0 | 0.00 | 1.00 | 189 | 0 | 0 | 0.00 |
I_DATA_SMALL | +wookieDATA00/wookie/dbfiles/i_data_small.781.748084369 |
9 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_DATA_SMALL | +wookieDATA00/wookie/dbfiles/i_data_small.865.748084367 |
9 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_DATA_SMALL | +wookieDATA00/wookie/dbfiles/i_data_small.890.748084367 |
9 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_DR_glasses | +wookieDATA00/wookie/dbfiles/i_dr_glasses.420.748011673 |
6 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_DR_glasses | +wookieDATA00/wookie/dbfiles/i_dr_glasses.776.748011671 |
6 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_set_big_HOME | +wookieDATA00/wookie/dbfiles/i_set_big_home.1009.748764125 |
1,014 | 0 | 7.96 | 1.00 | 846 | 0 | 54 | 0.19 |
I_set_big_HOME | +wookieDATA00/wookie/dbfiles/i_set_big_home.1317.748764117 |
1,845 | 1 | 9.27 | 1.00 | 6,978 | 2 | 322 | 0.25 |
I_set_big_HOME | +wookieDATA00/wookie/dbfiles/i_set_big_home.1327.748764111 |
1,951 | 1 | 7.01 | 1.00 | 1,939 | 1 | 0 | 0.00 |
I_set_big_HOME | +wookieDATA00/wookie/dbfiles/i_set_big_home.1333.748764119 |
983 | 0 | 6.45 | 1.00 | 4,785 | 1 | 348 | 0.11 |
I_set_big_HOME | +wookieDATA00/wookie/dbfiles/i_set_big_home.1334.748764123 |
1,012 | 0 | 7.03 | 1.00 | 2,562 | 1 | 487 | 0.76 |
I_set_big_HOME | +wookieDATA00/wookie/dbfiles/i_set_big_home.1335.748764113 |
5,053 | 1 | 5.39 | 1.00 | 5,385 | 1 | 0 | 0.00 |
I_set_big_HOME | +wookieDATA00/wookie/dbfiles/i_set_big_home.269.748764109 |
1,925 | 1 | 7.52 | 1.00 | 1,708 | 0 | 0 | 0.00 |
I_set_big_HOME | +wookieDATA00/wookie/dbfiles/i_set_big_home.435.748011275 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_set_big_HOME | +wookieDATA00/wookie/dbfiles/i_set_big_home.681.748011271 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_set_big_HOME | +wookieDATA00/wookie/dbfiles/i_set_big_home.713.748011273 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_set_big_HOME | +wookieDATA00/wookie/dbfiles/i_set_big_home.816.748011281 |
5 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
I_set_big_HOME | +wookieDATA00/wookie/dbfiles/i_set_big_home.885.748011279 |
5 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
I_set_big_VPLMN | +wookieDATA00/wookie/dbfiles/i_set_big_vplmn.575.748011289 |
5 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
I_set_LT | +wookieDATA00/wookie/dbfiles/i_set_lt.1137.748011537 |
20,652 | 6 | 6.58 | 1.00 | 21 | 0 | 0 | 0.00 |
I_set_LT | +wookieDATA00/wookie/dbfiles/i_set_lt.390.748011527 |
20,839 | 6 | 6.59 | 1.00 | 43 | 0 | 0 | 0.00 |
I_set_LT | +wookieDATA00/wookie/dbfiles/i_set_lt.868.748011521 |
20,464 | 6 | 6.55 | 1.00 | 45 | 0 | 0 | 0.00 |
I_set_LT | +wookieDATA00/wookie/dbfiles/i_set_lt.508.748011525 |
20,813 | 6 | 6.36 | 1.00 | 62 | 0 | 0 | 0.00 |
I_set_LT | +wookieDATA00/wookie/dbfiles/i_set_lt.636.748011541 |
20,734 | 6 | 6.61 | 1.00 | 50 | 0 | 0 | 0.00 |
I_set_LT | +wookieDATA00/wookie/dbfiles/i_set_lt.657.748011539 |
20,034 | 6 | 6.45 | 1.00 | 39 | 0 | 0 | 0.00 |
I_set_LT | +wookieDATA00/wookie/dbfiles/i_set_lt.719.748011517 |
21,949 | 6 | 6.61 | 1.00 | 51 | 0 | 0 | 0.00 |
I_set_LT | +wookieDATA00/wookie/dbfiles/i_set_lt.834.748011533 |
19,556 | 5 | 6.46 | 1.00 | 43 | 0 | 0 | 0.00 |
I_set_LT | +wookieDATA00/wookie/dbfiles/i_set_lt.840.748011545 |
22,196 | 6 | 6.58 | 1.00 | 32 | 0 | 0 | 0.00 |
I_set_LT | +wookieDATA00/wookie/dbfiles/i_set_lt.875.748011531 |
20,152 | 6 | 6.65 | 1.00 | 81 | 0 | 0 | 0.00 |
I_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/i_set_lt_bc1.1026.749253119 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/i_set_lt_bc1.1112.749253131 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/i_set_lt_bc1.1213.749253115 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/i_set_lt_bc1.1279.749253117 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/i_set_lt_bc1.266.749253123 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/i_set_lt_bc1.511.749253133 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/i_set_lt_bc1.598.749253125 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/i_set_lt_bc1.852.749253127 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/i_set_lt_bc1.868.749253113 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/i_set_lt_bc1.879.749253129 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_set_NU_CHARGES | +wookieDATA00/wookie/dbfiles/i_set_nu_charges.292.748011679 |
532 | 0 | 6.62 | 1.00 | 3,491 | 1 | 0 | 0.00 |
I_set_ST | +wookieDATA00/wookie/dbfiles/i_set_st.1182.748011639 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_set_ST | +wookieDATA00/wookie/dbfiles/i_set_st.272.748011635 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_set_ST | +wookieDATA00/wookie/dbfiles/i_set_st.522.748011637 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_set_ST | +wookieDATA00/wookie/dbfiles/i_set_st.859.748011641 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_set_ST | +wookieDATA00/wookie/dbfiles/i_set_st.968.748011633 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_set_SUM_LT | +wookieDATA00/wookie/dbfiles/i_set_sum_lt.956.748011647 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
I_set_SUM_ST | +wookieDATA00/wookie/dbfiles/i_set_sum_st.839.748011651 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
wookie_DATA | +wookieDATA00/wookie/dbfiles/wookie_data.930.748082931 |
6 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
SYSAUX | +wookieDATA00/wookie/dbfiles/sysaux.1189.747584681 |
1,701 | 0 | 4.83 | 1.02 | 429 | 0 | 0 | 0.00 |
SYSTEM | +wookieDATA00/wookie/dbfiles/system.845.747584677 |
2,442 | 1 | 4.09 | 1.38 | 50 | 0 | 4 | 2.50 |
TEMP | +wookieDATA00/wookie/tempfile/temp.1287.749036165 |
6 | 0 | 5.00 | 1.00 | 0 | 0 | 0 | |
TEMP | +wookieDATA00/wookie/tempfile/temp.1313.749166315 |
6 | 0 | 11.67 | 1.00 | 0 | 0 | 0 | |
TEMP | +wookieDATA00/wookie/tempfile/temp.1320.749036169 |
6 | 0 | 6.67 | 1.00 | 0 | 0 | 0 | |
TEMP | +wookieDATA00/wookie/tempfile/temp.399.749166305 |
7 | 0 | 5.71 | 1.00 | 1 | 0 | 0 | |
TEMP | +wookieDATA00/wookie/tempfile/temp.533.749166395 |
6 | 0 | 5.00 | 1.00 | 0 | 0 | 0 | |
TEMP | +wookieDATA00/wookie/tempfile/temp.545.747584685 |
6 | 0 | 8.33 | 1.00 | 0 | 0 | 0 | |
TEMP | +wookieDATA00/wookie/tempfile/temp.732.749036171 |
6 | 0 | 5.00 | 1.00 | 0 | 0 | 0 | |
TEMP | +wookieDATA00/wookie/tempfile/temp.998.749166491 |
6 | 0 | 5.00 | 1.00 | 0 | 0 | 0 | |
T_sim | +wookieDATA00/wookie/dbfiles/t_tec.1214.749339713 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_sim | +wookieDATA00/wookie/dbfiles/t_tec.280.749339709 |
25 | 0 | 0.80 | 1.00 | 11 | 0 | 0 | 0.00 |
T_sim | +wookieDATA00/wookie/dbfiles/t_tec.471.749339703 |
21 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_sim | +wookieDATA00/wookie/dbfiles/t_tec.521.749339707 |
21 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_sim | +wookieDATA00/wookie/dbfiles/t_tec.925.749339715 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_tx_papers | +wookieDATA00/wookie/dbfiles/t_tx_papers.411.748011653 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_DATA | +wookieDATA00/wookie/dbfiles/t_data.584.748010939 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_DATA_SMALL | +wookieDATA00/wookie/dbfiles/t_data_small.1065.748084343 |
6 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_DATA_SMALL | +wookieDATA00/wookie/dbfiles/t_data_small.1141.748084341 |
6 | 0 | 0.00 | 1.00 | 22 | 0 | 0 | 0.00 |
T_DATA_SMALL | +wookieDATA00/wookie/dbfiles/t_data_small.1199.748084341 |
6 | 0 | 0.00 | 1.00 | 156 | 0 | 0 | 0.00 |
T_DATA_SMALL | +wookieDATA00/wookie/dbfiles/t_data_small.258.748084341 |
6 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_DATA_SMALL | +wookieDATA00/wookie/dbfiles/t_data_small.476.748084341 |
6 | 0 | 0.00 | 1.00 | 119 | 0 | 0 | 0.00 |
T_DATA_SMALL | +wookieDATA00/wookie/dbfiles/t_data_small.643.748084339 |
6 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_DATA_SMALL | +wookieDATA00/wookie/dbfiles/t_data_small.654.748084343 |
9 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_DATA_SMALL | +wookieDATA00/wookie/dbfiles/t_data_small.660.748084339 |
6 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_DATA_SMALL | +wookieDATA00/wookie/dbfiles/t_data_small.747.748084339 |
6 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_DATA_SMALL | +wookieDATA00/wookie/dbfiles/t_data_small.801.748084341 |
6 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_DR_glasses | +wookieDATA00/wookie/dbfiles/t_dr_glasses.1090.748011661 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_DR_glasses | +wookieDATA00/wookie/dbfiles/t_dr_glasses.1172.748011667 |
1,076 | 0 | 15.70 | 1.00 | 477 | 0 | 88 | 1.70 |
T_DR_glasses | +wookieDATA00/wookie/dbfiles/t_dr_glasses.647.748011663 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_DR_glasses | +wookieDATA00/wookie/dbfiles/t_dr_glasses.788.748011669 |
6 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_DR_glasses | +wookieDATA00/wookie/dbfiles/t_dr_glasses.891.748011659 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_cbsDB | +wookieDATA00/wookie/dbfiles/t_cbsdb.1124.748074867 |
6 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_cbsDB | +wookieDATA00/wookie/dbfiles/t_cbsdb.324.748074865 |
6 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_cbsDB | +wookieDATA00/wookie/dbfiles/t_cbsdb.932.748074869 |
6 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_big_HOME | +wookieDATA00/wookie/dbfiles/t_set_big_home.1168.748011265 |
66 | 0 | 2.42 | 1.00 | 389 | 0 | 0 | 0.00 |
T_set_big_HOME | +wookieDATA00/wookie/dbfiles/t_set_big_home.392.748011249 |
4 | 0 | 2.50 | 1.00 | 4 | 0 | 0 | 0.00 |
T_set_big_HOME | +wookieDATA00/wookie/dbfiles/t_set_big_home.442.748011263 |
3 | 0 | 0.00 | 1.00 | 38 | 0 | 0 | 0.00 |
T_set_big_HOME | +wookieDATA00/wookie/dbfiles/t_set_big_home.499.748011245 |
9 | 0 | 2.22 | 1.00 | 472 | 0 | 0 | 0.00 |
T_set_big_HOME | +wookieDATA00/wookie/dbfiles/t_set_big_home.504.748011259 |
26 | 0 | 5.77 | 1.00 | 150 | 0 | 0 | 0.00 |
T_set_big_HOME | +wookieDATA00/wookie/dbfiles/t_set_big_home.556.748011255 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_big_HOME | +wookieDATA00/wookie/dbfiles/t_set_big_home.586.748011247 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_big_HOME | +wookieDATA00/wookie/dbfiles/t_set_big_home.830.748011251 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_big_HOME | +wookieDATA00/wookie/dbfiles/t_set_big_home.861.748011257 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_big_HOME | +wookieDATA00/wookie/dbfiles/t_set_big_home.948.748011267 |
99 | 0 | 1.11 | 1.00 | 1,985 | 1 | 0 | 0.00 |
T_set_big_VPLMN | +wookieDATA00/wookie/dbfiles/t_set_big_vplmn.446.748011283 |
5 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_big_VPLMN | +wookieDATA00/wookie/dbfiles/t_set_big_vplmn.955.748011285 |
5 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.1056.748011317 |
272,512 | 75 | 4.83 | 1.30 | 2 | 0 | 5 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.1075.748011315 |
275,982 | 76 | 4.82 | 1.58 | 2 | 0 | 0 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.1088.748011353 |
273,312 | 76 | 4.71 | 2.14 | 2 | 0 | 1 | 10.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.1115.748011329 |
260,781 | 72 | 4.81 | 1.57 | 2 | 0 | 7 | 2.86 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.1121.748011385 |
253,882 | 70 | 4.76 | 1.71 | 2 | 0 | 9 | 3.33 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.1123.748011391 |
259,501 | 72 | 4.86 | 1.57 | 2 | 0 | 3 | 10.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.1127.748011417 |
233,765 | 65 | 4.85 | 1.70 | 2 | 0 | 6 | 3.33 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.1139.748011415 |
233,185 | 64 | 4.62 | 2.31 | 2 | 0 | 1 | 10.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.1181.748011341 |
288,700 | 80 | 4.73 | 1.81 | 2 | 0 | 14 | 2.14 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.1193.748011479 |
250,760 | 69 | 4.73 | 2.24 | 2 | 0 | 2 | 5.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.260.748011367 |
267,623 | 74 | 4.81 | 1.62 | 2 | 0 | 13 | 6.92 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.262.748011515 |
252,875 | 70 | 4.80 | 1.89 | 2 | 0 | 7 | 4.29 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.265.748011475 |
252,158 | 70 | 4.84 | 1.63 | 3 | 0 | 2 | 5.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.275.748011389 |
257,660 | 71 | 4.81 | 1.64 | 2 | 0 | 5 | 4.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.279.748011491 |
251,126 | 69 | 4.75 | 1.68 | 2 | 0 | 2 | 10.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.282.748011365 |
275,399 | 76 | 4.80 | 1.58 | 2 | 0 | 5 | 4.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.290.748011345 |
269,137 | 74 | 4.64 | 2.32 | 2 | 0 | 0 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.329.748011397 |
239,832 | 66 | 4.78 | 1.36 | 2 | 0 | 6 | 1.67 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.333.748011305 |
273,456 | 76 | 4.77 | 2.30 | 2 | 0 | 3 | 6.67 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.339.748011293 |
282,255 | 78 | 4.86 | 1.43 | 2 | 0 | 2 | 5.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.340.748011343 |
272,100 | 75 | 4.81 | 1.33 | 2 | 0 | 17 | 4.12 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.363.748011383 |
259,000 | 72 | 4.79 | 1.59 | 2 | 0 | 5 | 4.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.369.748011465 |
248,431 | 69 | 4.74 | 1.79 | 2 | 0 | 0 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.389.748011297 |
275,181 | 76 | 4.84 | 1.74 | 2 | 0 | 3 | 3.33 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.391.748011325 |
262,265 | 73 | 4.78 | 1.74 | 2 | 0 | 2 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.403.748011299 |
266,583 | 74 | 4.92 | 1.52 | 2 | 0 | 3 | 3.33 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.414.748011427 |
238,139 | 66 | 4.85 | 1.43 | 2 | 0 | 7 | 10.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.417.748011309 |
271,022 | 75 | 4.80 | 1.82 | 2 | 0 | 13 | 3.85 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.425.748011473 |
249,809 | 69 | 4.78 | 1.66 | 2 | 0 | 1 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.432.748011497 |
249,227 | 69 | 4.83 | 1.82 | 2 | 0 | 11 | 13.64 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.436.748011459 |
229,015 | 63 | 4.77 | 1.48 | 2 | 0 | 1 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.439.748011359 |
274,045 | 76 | 4.76 | 1.83 | 2 | 0 | 6 | 5.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.453.748011327 |
261,296 | 72 | 4.85 | 1.50 | 2 | 0 | 1 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.459.748011511 |
253,475 | 70 | 4.85 | 2.18 | 2 | 0 | 0 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.469.748011509 |
250,384 | 69 | 4.86 | 1.48 | 2 | 0 | 4 | 2.50 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.480.748011435 |
242,881 | 67 | 4.81 | 1.39 | 2 | 0 | 3 | 3.33 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.485.748011499 |
252,297 | 70 | 4.74 | 1.76 | 2 | 0 | 3 | 3.33 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.515.748011319 |
273,971 | 76 | 4.84 | 1.73 | 2 | 0 | 5 | 2.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.518.748011307 |
267,713 | 74 | 4.84 | 1.78 | 2 | 0 | 21 | 2.86 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.532.748011337 |
284,741 | 79 | 4.89 | 1.41 | 2 | 0 | 4 | 7.50 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.539.748011291 |
247,235 | 68 | 4.82 | 2.08 | 2 | 0 | 3 | 6.67 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.542.748011301 |
265,969 | 74 | 4.93 | 1.91 | 2 | 0 | 1 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.563.748011411 |
233,076 | 64 | 4.78 | 1.47 | 2 | 0 | 4 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.566.748011333 |
285,647 | 79 | 4.85 | 1.47 | 2 | 0 | 2 | 25.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.591.748011351 |
273,431 | 76 | 4.81 | 1.70 | 2 | 0 | 0 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.603.748011403 |
240,508 | 67 | 4.80 | 1.74 | 2 | 0 | 6 | 1.67 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.605.748011469 |
242,429 | 67 | 4.81 | 1.24 | 2 | 0 | 1 | 20.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.614.748011481 |
255,333 | 71 | 4.85 | 1.76 | 2 | 0 | 3 | 6.67 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.621.748011443 |
233,981 | 65 | 4.75 | 2.02 | 3 | 0 | 0 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.629.748011455 |
231,316 | 64 | 4.67 | 1.92 | 2 | 0 | 4 | 5.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.634.748011868 |
249,318 | 69 | 4.88 | 1.71 | 2 | 0 | 1 | 10.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.652.748011419 |
233,170 | 64 | 4.71 | 2.06 | 3 | 0 | 6 | 3.33 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.653.748011405 |
226,685 | 63 | 4.63 | 2.29 | 2 | 0 | 4 | 2.50 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.658.748011431 |
247,179 | 68 | 4.80 | 1.62 | 2 | 0 | 4 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.757.748011375 |
265,716 | 73 | 4.84 | 1.79 | 2 | 0 | 2 | 5.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.767.748011453 |
234,252 | 65 | 4.77 | 1.71 | 2 | 0 | 2 | 5.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.773.748011503 |
249,730 | 69 | 4.82 | 1.64 | 2 | 0 | 2 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.782.748011311 |
270,041 | 75 | 4.83 | 1.54 | 2 | 0 | 2 | 5.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.803.748011423 |
241,901 | 67 | 4.80 | 1.39 | 2 | 0 | 14 | 2.86 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.806.748011361 |
270,687 | 75 | 4.80 | 1.42 | 2 | 0 | 1 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.810.748011441 |
231,074 | 64 | 4.83 | 1.74 | 2 | 0 | 1 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.838.748011323 |
269,046 | 74 | 4.65 | 2.18 | 2 | 0 | 8 | 5.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.843.748011393 |
252,434 | 70 | 4.71 | 2.13 | 2 | 0 | 11 | 2.73 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.855.748011369 |
268,018 | 74 | 4.73 | 1.69 | 2 | 0 | 9 | 5.56 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.871.748011463 |
232,474 | 64 | 4.74 | 2.07 | 2 | 0 | 0 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.893.748011357 |
270,480 | 75 | 4.81 | 1.59 | 2 | 0 | 10 | 3.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.894.748011505 |
250,076 | 69 | 4.82 | 1.83 | 2 | 0 | 4 | 5.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.897.748011381 |
261,739 | 72 | 4.79 | 1.61 | 2 | 0 | 3 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.904.748011437 |
254,151 | 70 | 4.78 | 1.72 | 2 | 0 | 3 | 3.33 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.921.748011399 |
233,210 | 64 | 4.71 | 2.01 | 2 | 0 | 0 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.931.748011447 |
236,332 | 65 | 4.80 | 1.51 | 2 | 0 | 2 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.933.748011451 |
239,408 | 66 | 4.76 | 1.50 | 2 | 0 | 1 | 10.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.942.748011487 |
257,166 | 71 | 4.77 | 1.67 | 2 | 0 | 15 | 3.33 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.947.748011349 |
266,119 | 74 | 4.86 | 1.43 | 2 | 0 | 6 | 3.33 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.957.748011335 |
285,881 | 79 | 4.84 | 1.59 | 2 | 0 | 4 | 2.50 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.960.748011377 |
262,518 | 73 | 4.81 | 1.52 | 2 | 0 | 8 | 3.75 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.964.748011371 |
266,641 | 74 | 4.81 | 1.60 | 2 | 0 | 6 | 5.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.969.748011429 |
240,063 | 66 | 4.79 | 1.82 | 3 | 0 | 6 | 3.33 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.979.748011409 |
230,764 | 64 | 4.66 | 1.85 | 2 | 0 | 3 | 0.00 |
T_set_LT | +wookieDATA00/wookie/dbfiles/t_set_lt.984.748011485 |
253,867 | 70 | 4.82 | 1.55 | 2 | 0 | 2 | 5.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1008.749253003 |
12 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1013.749253109 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1023.749253071 |
15 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1041.749253049 |
15 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1042.749253013 |
12 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1043.749253051 |
15 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1060.749253029 |
12 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1086.749253007 |
12 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1097.749253079 |
15 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1102.749253037 |
12 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1149.749253093 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1197.749253075 |
15 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1220.749253033 |
12 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1250.749253101 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1251.749253031 |
12 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1257.749253107 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1258.749253045 |
15 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1260.749253035 |
12 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1266.749253111 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1270.749253023 |
12 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1273.749253099 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1278.749253103 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1324.749253087 |
15 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1326.749253083 |
15 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.1330.749253059 |
15 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.268.749253027 |
12 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.277.749253011 |
12 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.288.749253053 |
15 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.293.749253019 |
12 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.303.749253047 |
15 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.367.749253061 |
15 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.466.749253095 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.520.749253025 |
12 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.523.749253055 |
15 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.570.749253067 |
15 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.576.749253085 |
15 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.610.749253057 |
15 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.670.749253073 |
15 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.698.749253015 |
12 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.702.749253091 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.771.749253009 |
12 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.775.749253077 |
15 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.787.749253017 |
12 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.856.749253021 |
12 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.909.749253065 |
15 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.928.749253069 |
15 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.938.749253089 |
18 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.941.749253005 |
12 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.967.749253039 |
12 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_LT_BC1 | +wookieDATA00/wookie/dbfiles/t_set_lt_bc1.989.749253043 |
12 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_NU_CHARGES | +wookieDATA00/wookie/dbfiles/t_set_nu_charges.547.748011675 |
3,966 | 1 | 6.98 | 1.00 | 15,610 | 4 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.1071.748011597 |
12 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.1138.748011579 |
15 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.1140.748011627 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.1155.748011613 |
12 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.1207.748011585 |
12 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.1209.748011569 |
15 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.348.748011549 |
13 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.384.748011607 |
12 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.410.748011605 |
12 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.428.748011559 |
13 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.467.748011615 |
12 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.496.748011625 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.502.748011593 |
12 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.527.748011629 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.583.748011623 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.601.748011617 |
12 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.638.748011573 |
15 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.686.748011567 |
15 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.703.748011591 |
12 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.726.748011575 |
15 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.752.748011555 |
13 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.762.748011599 |
12 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.841.748011557 |
13 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.878.748011563 |
15 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.883.748011581 |
12 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.907.748011551 |
13 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.914.748011603 |
12 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.919.748011587 |
12 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.975.748011609 |
12 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
T_set_ST | +wookieDATA00/wookie/dbfiles/t_set_st.983.748011619 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_SUM_LT | +wookieDATA00/wookie/dbfiles/t_set_sum_lt.912.748011645 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
T_set_SUM_ST | +wookieDATA00/wookie/dbfiles/t_set_sum_st.756.748011649 |
3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
UNDOTBS1 | +wookieDATA00/wookie/dbfiles/undotbs1.667.747584683 |
1,153 | 0 | 6.51 | 1.00 | 13,554 | 4 | 324 | 0.09 |
USERS | +wookieDATA00/wookie/dbfiles/users.426.747584701 |
3 | 0 | 0.00 | 1.00 | 13 | 0 | 0 | 0.00 |