| SQL Id | SQL Text |
|---|
| 05uqdabhzncdc | select role# from defrole$ d, user$ u where d.user#=:1 and u.user#=d.user# and u.defrole=2 union select privilege# from sysauth$ s, user$ u where (grantee#=:1 or grantee#=1) and privilege#>0 and not exists (select null from defrole$ where user#=:1 and role#=s.privilege#) and u.user#=:1 and u.defrole=3 |
| 0cjngzmtm4yv1 | select reason_id, object_id, subobject_id, internal_instance_number, time_suggested, context, reason_argument_1, reason_argument_2, reason_argument_3, reason_argument_4, reason_argument_5, action_argument_1, action_argument_2, action_argument_3, action_argument_4, action_argument_5, sequence_id, metric_value, instance_name from wri$_alert_outstanding where internal_instance_number > -2 |
| 0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
| 0p4bmfh3nsqf4 | SELECT SCI_ADR_TOWN FROM GCI_SOURCE_CUSTOMER_INFO, GCI_CUSTOMER_INFO WHERE SCI_CUST_INFO_ID=CIN_ID AND CIN_TEL_TYPE=0 AND CIN_TELNUM=:B1 AND ROWNUM=1 ORDER BY SCI_CDATE DESC |
| 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') |
| 19cmvrxqq51z6 | SELECT COD_ID FROM COM_ORDER_DETAILS@ORCHESTRATIO WHERE COD_ORDER_ID=:B1 AND COD_STATUS!=6 AND ROWNUM=1 |
| 1avaf8pd3vbvp | SELECT SCI_ADR_LINE2 FROM GCI_SOURCE_CUSTOMER_INFO, GCI_CUSTOMER_INFO WHERE SCI_CUST_INFO_ID=CIN_ID AND CIN_TEL_TYPE=0 AND CIN_TELNUM=:B1 AND ROWNUM=1 ORDER BY SCI_CDATE DESC |
| 214uhw2336bqs | SELECT distinct A1.APT_ID, A1.APT_ORDER_ID, nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, '')) as telnum, A1.APT_DATE, A1.APT_CDATE, A1.APT_TIMEFROM, A1.APT_TIMETO, CASE A1.APT_TYPE WHEN 1 THEN 'NORMAL' WHEN 2 THEN 'MISC' END APT_TYPE, CASE A1.APT_ACTIVE WHEN 1 THEN 'ACTIVE' WHEN 2 THEN 'CANCEL' END APT_ACTIVE, (select tem_name from gci_team where tem_id=apt_tem_id) TEAM, (select COT_NAME from gci_ref_contractor, gci_team where tem_cot_id=cot_id and tem_id=apt_tem_id) CONTRACTOR, nvl((select usr_lastname ||' '||usr_firstname from gci_user_tech where usr_login=A1.APT_CREATEDBY), A1.APT_CREATEDBY) REGISTERED_BY, A1.APT_MODBY MODIFIED_BY, FN_GET_FNAME(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as FNAME, (nvl(PRO_CONTACT, FN_GET_CONTACT_1(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))))) as CONTACTS, FN_GET_LNAME(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as LNAME, FN_GET_ADR_LINE1(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as ADDRESSNO, FN_GET_ADR_LINE2(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as ADDRESS, FN_GET_TOWN(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as TOWN, (select ftw_fdp1 from gci_ftth_wo where ftw_order_id=A1.APT_ORDER_ID and rownum=1) as fdp, (select ftw_ocab from gci_ftth_wo where ftw_order_id=A1.APT_ORDER_ID and rownum=1) as ocab, (select substr(ftw_olt, 10, 2) from gci_ftth_wo where ftw_order_id=A1.APT_ORDER_ID and rownum=1) as mdf, get_last_orderstatus@GAIA.MAURITIUSTELECOM.COM(apt_order_id) orderstatus, nvl((select usr_lastname ||' '||usr_firstname from gci_user_tech where usr_team=A1.APT_DEPLOYTO and rownum=1), 'NOT DEPLOYED') deploy_to, nvl((select cot_name from gci_ref_contractor where cot_id=A1.APT_CONTRACTTO and rownum=1), 'NOT CONTRACTED' ) contract_to, (select count(1) from gci_customer_order_photo where cop_order_id=pro_order_id) numphoto FROM gci_appointment A1 left join gci_preorder D on a1.apt_order_id=d.pro_order_id WHERE A1.APT_ID in( select distinct apt_id from ( (select apt_id from gci_appointment A , gci_team B, gci_ref_contractor C WHERE A.APT_TEM_ID = B.TEM_ID and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate and (B.TEM_COT_ID = C.COT_ID and C.COT_ID=:contractor) ) union (select apt_id from gci_appointment A , gci_team B, gci_ref_contractor C WHERE A.APT_TEM_ID = B.TEM_ID and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate and (B.TEM_COT_ID=C.COT_ID and C.COT_ID in (select cot_id from gci_ref_contractor where cot_group_id=:contractor)) ) union (select apt_id from gci_appointment a, gci_ref_contractor c, gci_team b where b.tem_active=1 and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate and (A.APT_CONTRACTTO=:contractor and a.apt_contractto=c.cot_id and c.cot_id=b.tem_cot_id) )) ) ORDER BY APT_DATE, APT_TIMEFROM |
| 24270097c1tsb | BEGIN SP_UP_ORDER_FAIL_STATUS(); END; |
| 2wvjcdckpfjqw | select * from (select v.*, p.pro_custcat from gci_techmig_voice v, gci_preorder p, dem_etape@GAIA.MAURITIUSTELECOM.COM e where p.pro_order_id=v.tmv_order_id and p.pro_active=1 and tmv_processed=0 and e.ndem=p.pro_order_id and (e.cmotif_if='OCOM' or (does_nd_ftth@gaia.mauritiustelecom.com(tmv_telnum)>0 and pro_cmot='TECH')) union select v.*, p.pro_custcat from gci_techmig_voice v, gci_preorder p, dem_etape@GAIA.MAURITIUSTELECOM.COM e where p.pro_order_id=v.tmv_order_id and p.pro_active=1 and tmv_processed=0 and e.ndem=p.pro_order_id and e.cmotif_if='CONVW' union select v.*, p.pro_custcat from gci_techmig_voice v, gci_preorder p, h_dem_etape@GAIA.MAURITIUSTELECOM.COM e, demande@GAIA.MAURITIUSTELECOM.COM d where p.pro_order_id=v.tmv_order_id and p.pro_active=1 and tmv_processed=0 and d.ndem=p.pro_order_id and d.etat_de=5 and e.ndem=p.pro_order_id and e.cmotif_if='OCOM' union select v.*, p.pro_custcat from gci_techmig_voice v, gci_preorder p, h_dem_etape@GAIA.MAURITIUSTELECOM.COM e, demande@GAIA.MAURITIUSTELECOM.COM d where p.pro_order_id=v.tmv_order_id and p.pro_active=1 and tmv_processed=0 and d.ndem=p.pro_order_id and d.etat_de=5 and e.ndem=p.pro_order_id and e.cmotif_if='CONVW' ) where rownum<20 |
| 2xp9j67sqzwbs | select nvl((select cot_name from gci_ref_contractor where cot_id=ftw_cot_id), 'CMC') Contractor, (select tem_name from gci_team where tem_id=ftw_tem_id) Team, (select apt_date||' '|| apt_timefrom||':'||apt_timeto from gci_appointment where apt_id=ftw_apt_id) appointment, ftw_lname as Name, ftw_fname as Firstname, ftw_contactno as Contactno, ftw_addressno as AddressNo, ftw_streetname as Streetname, ftw_locality as Locality, ftw_olt as OLT, ftw_ocab as OCAB, ftw_fdp1 as FDP_1, ftw_fdpport_id as FDPPort_id, ftw_ont_id as ONT_ID, ftw_ont_type as ONT_TYPE, ftw_onu_id as ONU_ID, ftw_shelf as SHELF, ftw_card as Card, ftw_port as Port, ftw_internet_vlan as Internet_vlan, ftw_iptv_vlan as IPTV_VLAN, ftw_order_id as Order_id, ftw_IPTV_PARENTID as IPTV_PARENT_ID, ftw_IPTV_PARENTPWD as IPTV_PARENT_PWD, ftw_stbaccounts as STBACCOUNTS, ftw_IPTV_PASSWORD as STB_PASSWORD, ftw_parentlock as parentlock, ftw_bboffername as offer, ftw_rbsusername as RBSusername, ftw_rbspassword as RBSPassowrd, (case ftw_custcat when 0 then 'Residential' when 1 then 'Business' end) as Category, ftw_ordercdate, to_char(ftw_ordercdate, 'hh24:mi:ss') as orderTime, (select pro_iptv_codes from gci_preorder where pro_order_id = ftw_order_id) as IPTV_CODES, ftw_refno, ftw_tvbouquetname, ftw_iptvaddonsname, ftw_we as WirelessExtender, ftw_powerline as PowerLine, ftw_dualroom as DualRoom, (case ftw_lb when 0 then 'No' when 1 then 'Yes' end) as large_building, (case ftw_ug when 0 then 'No' when 1 then 'Yes' end) as underground_cabling, (case ftw_iw when 0 then 'No' when 1 then 'Yes' end) as internal_wiring, ftw_telnum as telnum, (select GET_ND_BB_SERV_PROMOS@gaia.mauritiustelecom.com(ftw_telnum) from dual) as current_service, (select LART from p_cathors@gaia.mauritiustelecom.com where abrv_art =((select GET_ND_BB_SERV_PROMOS@gaia.mauritiustelecom.com(ftw_telnum) from dual)) and rownum=1) as current_service_label, (select count(ndem) from demande@gaia.mauritiustelecom.com where ndem = ftw_order_id) as ndemNotPS, (select count(cws_order_id) from gci_contractor_work_status where cws_order_id = ftw_order_id and cws_status = 'WWIP') as workSTART, (select count(cws_order_id) from gci_contractor_work_status where cws_order_id = ftw_order_id and cws_status = 'WCOM') as workCOM, (select count(cws_order_id) from gci_contractor_work_status where cws_order_id = ftw_order_id and cws_status = 'WAPRE') as workNOTCOM, (select nvl(apt_comments, '--') from gci_appointment where apt_order_id = ftw_order_id and rownum=1) as aptComments, ftw_offer as offer_comments from gci_ftth_wo where ftw_order_id=:orderid order by appointment, firstname |
| 3c1kubcdjnppq | update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln |
| 459f3z9u4fb3u | select value$ from props$ where name = 'GLOBAL_DB_NAME' |
| 4m7m0t6fjcs5x | update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1 |
| 59nhx3wwzvp35 | select a.apt_id, a.apt_tem_id, a.apt_date, a.apt_timefrom, a.apt_timeto, a.apt_order_id, a.apt_comments, P.PRO_OEXCHANGE, P.PRO_OCAB, P.PRO_ODP, a.apt_type, a.apt_status, nvl(P.PRO_TELNUM, (select nd_ref from demande@gaia.mauritiustelecom.com where ndem = apt_order_id)) PRO_TELNUM , P.PRO_CONTACT, (FN_GET_LNAME(nvl(P.PRO_TELNUM, (select nd_ref from demande@gaia.mauritiustelecom.com where ndem = apt_order_id))) || ' ' || FN_GET_FNAME(nvl(P.PRO_TELNUM, (select nd_ref from demande@gaia.mauritiustelecom.com where ndem = apt_order_id)))) CUSTNAME, (FN_GET_ADR_LINE2(nvl(P.PRO_TELNUM, (select nd_ref from demande@gaia.mauritiustelecom.com where ndem = apt_order_id))) || ' '||FN_GET_TOWN(nvl(P.PRO_TELNUM, (select nd_ref from demande@gaia.mauritiustelecom.com where ndem = apt_order_id)))) as ADDRESS from gci_appointment a left outer join gci_preorder p on a.apt_order_id=p.pro_order_id, gci_team t where t.tem_id=a.apt_tem_id and t.tem_cot_id=:contractor and a.apt_date = to_date(:date1, 'DD-MM-YYYY') and ( (select count(1) from gci_user_contractor_view where ucv_user=:user1)=0 or (apt_contractto in (select ucv_cot_id from gci_user_contractor_view where ucv_user=:user1))) and apt_active=1 and (select count(1) from demande@gaia.mauritiustelecom.com where ndem = apt_order_id)>0 union select distinct a.apt_id, a.apt_tem_id, a.apt_date, a.apt_timefrom, a.apt_timeto, a.apt_order_id, a.apt_comments, P.PRO_OEXCHANGE, P.PRO_OCAB, P.PRO_ODP, a.apt_type, a.apt_status, nvl(P.PRO_TELNUM, (select nd_ref from h_demande@gaia.mauritiustelecom.com where ndem = apt_order_id)) PRO_TELNUM , P.PRO_CONTACT, (FN_GET_LNAME(nvl(P.PRO_TELNUM, (select nd_ref from h_demande@gaia.mauritiustelecom.com where ndem = apt_order_id))) || ' ' || FN_GET_FNAME(nvl(P.PRO_TELNUM, (select nd_ref from h_demande@gaia.mauritiustelecom.com where ndem = apt_order_id)))) CUSTNAME, (FN_GET_ADR_LINE2(nvl(P.PRO_TELNUM, (select nd_ref from h_demande@gaia.mauritiustelecom.com where ndem = apt_order_id))) || ' '||FN_GET_TOWN(nvl(P.PRO_TELNUM, (select nd_ref from h_demande@gaia.mauritiustelecom.com where ndem = apt_order_id)))) as ADDRESS from gci_appointment a inner join gci_preorder p on a.apt_order_id=p.pro_order_id inner join h_demande@gaia.mauritiustelecom.com on ndem=p.pro_order_id, gci_team t where t.tem_id=a.apt_tem_id and t.tem_cot_id=:contractor and a.apt_date = to_date(:date1, 'DD-MM-YYYY') and ( (select count(1) from gci_user_contractor_view where ucv_user=:user1)=0 or (apt_contractto in (select ucv_cot_id from gci_user_contractor_view where ucv_user=:user1))) and apt_active=1 |
| 5hwhjqabvdcuw | SELECT COUNT(1) FROM GCI_FTTH_WO WHERE FTW_ORDER_ID=:B1 |
| 5rygsj4dbw6jt | insert into sys.mon_mods$ (obj#, inserts, updates, deletes, timestamp, flags, drop_segments) values (:1, :2, :3, :4, :5, :6, :7) |
| 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 |
| 5uy533jsc8hyh | DELETE MGMT_METRICS_1HOUR WHERE TARGET_GUID = :B3 AND ROLLUP_TIMESTAMP < :B2 AND ROWNUM <= :B1 |
| 5zqru3d571119 | SELECT NCLI, NDOS FROM DOSLIG0@GAIA.MAURITIUSTELECOM.COM WHERE ND=:B1 AND DATFIN_LD IS NULL |
| 69k5bhm12sz98 | SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time and dbin.instance_number = :inst |
| 6d9gv6u9vn1mf | INSERT INTO MGMT_METRICS_1HOUR ( TARGET_GUID, METRIC_GUID, ROLLUP_TIMESTAMP, KEY_VALUE, SAMPLE_COUNT, VALUE_AVERAGE, VALUE_MINIMUM, VALUE_MAXIMUM, VALUE_SDEV ) VALUES ( :B9 , :B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 ) |
| 75n0zz4t6a3wu | select s.*, (select pro_iptv_codes from gci_preorder where pro_order_id=s.ssi_order_id) iptvcodes, (select pro_old_iptvcodes from gci_preorder where pro_order_id=s.ssi_order_id) oldiptvcodes from gci_sms_info s where ssi_sent=0 and (has_order_ocom@GAIA.MAURITIUSTELECOM.COM(ssi_order_id) in (1, 3) or FN_HAS_TV_PROVISION(ssi_order_id)>0) |
| 8adtzvrzw9ncn | BEGIN SP_MIGRATE_TELNUM_FTTH ( :I_TELNUM, :I_FILEID, :O_RESPONSE, :O_MESSAGE ); END; |
| 8dqa7bn175qhu | UPDATE WRH$_SQLTEXT SET snap_id = :lah_snap_id WHERE dbid = :dbid AND (SQL_ID) IN (SELECT STR1_KEWRATTR FROM X$KEWRATTRSTALE) |
| 98ch135kz5hnk | Begin L2TCP.SP_APPOINTMENT_TAKEN(:v0, :v1); End; |
| 9fagk3bp50rfm | SELECT SCI_LNAME FROM GCI_SOURCE_CUSTOMER_INFO, GCI_CUSTOMER_INFO WHERE SCI_CUST_INFO_ID=CIN_ID AND CIN_TELNUM=:B1 AND CIN_TEL_TYPE=0 AND ROWNUM=1 ORDER BY SCI_CDATE DESC |
| 9fuuktgp1gjcz | SELECT SCI_FNAME FROM GCI_SOURCE_CUSTOMER_INFO, GCI_CUSTOMER_INFO WHERE SCI_CUST_INFO_ID=CIN_ID AND CIN_TEL_TYPE=0 AND CIN_TELNUM=:B1 AND ROWNUM=1 ORDER BY SCI_CDATE DESC |
| 9h6gruxdt21y7 | select pr.pro_id, pr.pro_order_id, pr.pro_telnum, FN_GET_FNAME(pro_telnum) firstname, FN_GET_LNAME(pro_telnum) lastname, FN_GET_CLIENTID@GAIA.MAURITIUSTELECOM.COM(pro_telnum) CLIENTID, FN_GET_ADR_LINE1(pro_telnum)||' '|| FN_GET_ADR_LINE2(pro_telnum) address, get_nd_ftth_const@GAIA.MAURITIUSTELECOM.COM(pro_telnum) ftthconst, FN_GET_CONTACT(pro_telnum) contactnum, nvl(pro_rbs_id, 'rbs_us') pro_rbs_id, nvl(pro_rbs_password, 'rbs_pw') pro_rbs_pwd, pro_product, (select rbc_value from gci_ref_bandwidth_cap, gci_ref_bb_offer bo where bo.rbo_id=pro_bboffer and rbc_id=rbo_cap_bw) volcap, (select rbw_value from gci_ref_bandwidth, gci_ref_bb_offer bo where bo.rbo_id=pro_bboffer and rbw_id=rbo_up_bw) uploadbw, (select rbw_value from gci_ref_bandwidth, gci_ref_bb_offer bo where bo.rbo_id=pro_bboffer and rbw_id=rbo_down_bw) downloadbw, '.' salutation, get_dn_switch@GAIA.MAURITIUSTELECOM.COM(pr.pro_telnum) switchinfo, pro_voip, pro_custcat from gci_preorder pr inner join demande@gaia.mauritiustelecom.com on ndem=pro_order_id where pro_cmot = 'TECH' and pro_Sdate is null -- and pro_bboffer is not null and pro_active = 1 and (pro_failure_code != 'CCF' or pro_failure_code is null or pro_failure_code = '0') and pro_order_id is not null -- and pro_order_id in ('9407247') and (select count(1) from doslig0@gaia.mauritiustelecom.com d0, client@gaia.mauritiustelecom.com c where d0.ncli=c.ncli and nd=pr.pro_telnum and datfin_ld is null)=1 and (select count(1) from mt_ftth_pcust@gaia.mauritiustelecom.com where nd=pr.pro_telnum and end_date is null and FDP_1 is not null)>0 and rownum <11 and pro_custcat=0 |
| 9yppwa0sj1ssr | select tdate, TTD_FROM, TTD_TO, sum( S.TTD_MAXRDV) totalslots from gci_team t, gci_wktemplate_slot w, gci_ref_slot s, ( select rownum-1+ to_date(:date1, 'DD-MM-YYYY') as tdate from all_objects where rownum < to_date(:date2, 'DD-MM-YYYY') - to_date(:date3, 'DD-MM-YYYY') + 2) f where T.TEM_COT_ID=:contractorid and W.WKI_WKT_ID=T.TEM_WKT_ID and s.ttd_canselect=1 and f.tdate not in (select cof_date from gci_contractor_off where cof_cot_id=:contractorid) and W.WKI_TTD_ID=S.TTD_ID and t.tem_active=1 and S.TTD_DAY= to_number(to_char(f.tdate, 'D'))-1 group by f.tdate, S.TTD_FROM, S.TTD_TO order by f.tdate, ttd_from |
| b3z033yhdff5u | SELECT "PRO_ID", "PRO_TELNUM", "PRO_EXCHANGE", "PRO_CABINET", "PRO_DP", "PRO_BBOFFER", "PRO_ORDER_ID", "PRO_CDATE", "PRO_CREATED_BY", "PRO_MDATE", "PRO_MOD_BY", "PRO_TECHNO", "PRO_ORDER_TYPE", "PRO_PRODUCT", "PRO_RBS_ID", "PRO_RBS_PASSWORD", "PRO_IPTV_PACK", "PRO_IPTV_PARENT_UID", "PRO_DEEZER_ID", "PRO_DEEZER_ACTION", "PRO_FEASIBLE_BBOFFERS", "PRO_RDATE", "PRO_SDATE", "PRO_OEXCHANGE", "PRO_OCAB", "PRO_ODP", "PRO_CONTACT", "PRO_COMMENTS", "PRO_CEASEDATE", "PRO_RESUMEDATE", "PRO_LIVEBOX", "PRO_SETUPBOX", "PRO_REMOTECONTROL", "PRO_ACCESSORIES", "PRO_WITHLINE", "PRO_FAILURE_CODE", "PRO_WITHINSTALLATION", "PRO_SERIALNO", "PRO_INSTAL_FEE", "PRO_BW_ACTION", "PRO_REINST", "PRO_CHANNELACTION", "PRO_CUSTCAT", "PRO_CMOT", "PRO_RESUMED_DATE", "PRO_OWNMODEM", "PRO_IPADDR", "PRO_IPTV_PARENT_PWD", "PRO_GAIA_COMMENT", "PRO_MULTIDEVICE", "PRO_APPT", "PRO_ACTIVE", "PRO_GAIA_STATUS", "PRO_OLDRBS_ID", "PRO_OLDPACKAGE", "PRO_PENALTY", "PRO_EMAIL", "PRO_DUAL", "PRO_DUALINSFEE", "PRO_IMSPWD", "PRO_OFFERTYPE", "PRO_BILLINGCOMMENTS", "PRO_POWERLINE", "PRO_IPTV_CODES", "PRO_WE", "PRO_LB", "PRO_UG", "PRO_IW", "PRO_OLD_IPTVCODES", "PRO_NEWLINE", "PRO_APPL_NAME", "PRO_APPL_FNAME", "PRO_APPL_NREGNO", "PRO_ISP", "PRO_SECONDLINE", "PRO_TRANSFER", "PRO_VOIP" FROM "GCI_PREORDER" "GCI_PREORDER" WHERE "PRO_CDATE">TO_DATE('2015-02-06 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND "PRO_GAIA_STATUS" IS NULL |
| b8j6sjgx4frbm | SELECT SCI_ADR_LINE1 FROM GCI_SOURCE_CUSTOMER_INFO, GCI_CUSTOMER_INFO WHERE SCI_CUST_INFO_ID=CIN_ID AND CIN_TELNUM=:B1 AND ROWNUM=1 ORDER BY SCI_CDATE DESC |
| bmncs6fxux0ab | BEGIN SP_GENERATE_WO_FOR_ORDERID1( :I_ORDERID); END; |
| bsagk16mvmcxg | SELECT COUNT(1) FROM GCI_TECHMIG_VOICE WHERE TMV_ORDER_ID= :B1 |
| c14yg17bhzqnr | SELECT COUNT(1) FROM GCI_FTTH_WO WHERE FTW_COT_ID=:B2 AND FTW_APTDATE=TRUNC(:B1 ) AND FTW_APT_ID NOT IN ( SELECT APT_ID FROM GCI_APPOINTMENT WHERE APT_DATE=TRUNC(:B1 ) AND APT_DEPLOYTO IN (SELECT TEM_ID FROM GCI_TEAM WHERE TEM_COT_ID=:B2 ) AND APT_ACTIVE=1 AND APT_TYPE=:B3 ) |
| c1db1096q20qn | SELECT COUNT(1) FROM GCI_APPOINTMENT WHERE APT_DATE=TRUNC(:B2 ) AND APT_DEPLOYTO IN (SELECT TEM_ID FROM GCI_TEAM WHERE TEM_COT_ID=:B3 ) AND APT_ACTIVE=1 AND APT_TYPE=:B1 AND APT_ID NOT IN (SELECT FTW_APT_ID FROM GCI_FTTH_WO WHERE FTW_COT_ID=:B3 AND FTW_APTDATE=TRUNC(:B2 )) |
| c920kzgsmm2j9 | DELETE FROM GCI_FTTH_WO WHERE FTW_ORDER_ID=:B1 |
| cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| cu9chm1msffm8 | SELECT COUNT(1) FROM "GCI_BILLED_ORDER" "A1" WHERE "A1"."STATUS"=3 AND "A1"."ND"=:B1 ORDER BY "A1"."DATOP_DE" DESC |
| cw4zts3yydvgs | SELECT APT_DATE AS APTDATE, APT_TYPE AS APTTYPE, (SELECT COT_NAME FROM GCI_REF_CONTRACTOR WHERE COT_ID=A.APT_CONTRACTTO) AS CONTRACTOR, A.APT_CONTRACTTO TEM_COT_ID, APT_ID, TEM_ID, TEM_NAME AS TEAM, APT_TIMEFROM||'-'||APT_TIMETO AS APPOINTMENT, NVL(PRO_TELNUM, '') AS ND, FN_GET_FNAME(PRO_TELNUM) AS FNAME, (NVL(PRO_CONTACT, FN_GET_CONTACT_1(PRO_TELNUM))) AS CONTACTS, FN_GET_LNAME(PRO_TELNUM) AS LNAME, FN_GET_ADR_LINE1(PRO_TELNUM) AS ADDRESSNO, FN_GET_ADR_LINE2(PRO_TELNUM) AS ADDRESS, FN_GET_TOWN(PRO_TELNUM) AS TOWN, FN_GET_EMAIL_WO(PRO_TELNUM, PRO_ORDER_ID) AS EMAIL, '' OLT, NVL(PRO_OCAB, '') OCAB, NVL(PRO_ODP, '') FDP, NVL(PRO_OEXCHANGE, '') EXCHANGE, '' FDP_PORT_ID, '' ONT_ID, '' ONT_TYPE, '' ONU_ID, '' SHELF, '' CARD, '' PORTONMMS, '' INTERNETVLAN, '' IPTVVLAN, APT_ORDER_ID AS ORDER_ID, (SELECT GIP_USERNAME FROM GCI_IPTV_ZTE WHERE GIP_TELNUM=PRO_TELNUM AND GIP_PARENT_ID IS NULL AND GIP_DATE_EXP IS NULL AND ROWNUM=1) AS ITPV_PARENT_ID, (SELECT GIP_PASSWORD FROM GCI_IPTV_ZTE WHERE GIP_TELNUM=PRO_TELNUM AND GIP_PARENT_ID IS NULL AND GIP_DATE_EXP IS NULL AND ROWNUM=1) AS IPTV_PARENT_PWD, FN_GET_STB_ACC(PRO_TELNUM) AS ITPV_CHILD_ID, NVL((SELECT GIP_PASSWORD FROM GCI_IPTV_ZTE WHERE GIP_TELNUM=PRO_TELNUM AND GIP_PARENT_ID IS NULL AND GIP_DATE_EXP IS NULL AND ROWNUM=1), PRO_IPTV_PARENT_PWD) AS ITPV_CHILD_PWD, '1234' AS PARENTLOCK, PRO_RBS_ID AS RBS_USERNAME, PRO_RBS_PASSWORD AS RBS_PWD, PRO_PRODUCT AS PRODUCT, PRO_CUSTCAT, (CASE PRO_CUSTCAT WHEN 0 THEN 'RESIDENTIAL' WHEN 1 THEN 'BUSINESS' END) CUSTCATEGORY, (SELECT C.CRQ_NAME || ' ' || C.CRQ_ONAME FROM GCI_CUSTOMER_REQUEST C WHERE C.CRQ_ORDER_ID=PRO_ORDER_ID) APPLICANT, PRO_LB, PRO_UG, PRO_IW, (CASE WHEN PRO_BBOFFER >50 THEN FN_GET_BIZ_BOOST_REMARKS(PRO_BBOFFER) ELSE '' END) REMARKS, PRO_NEWLINE FROM GCI_APPOINTMENT A LEFT OUTER JOIN GCI_PREORDER ON A.APT_ORDER_ID=PRO_ORDER_ID, GCI_TEAM T WHERE TRUNC(A.APT_DATE) = TRUNC(:B3 ) AND APT_TYPE=:B2 AND APT_ACTIVE=1 AND T.TEM_ID=A.APT_DEPLOYTO AND A.APT_CONTRACTTO=:B1 AND APT_ORDER_ID IS NOT NULL ORDER BY APT_TIMEFROM, TEM_ID |
| d8ubrz9puj1g8 | SELECT distinct A1.APT_ID, A1.APT_ORDER_ID, nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, '')) as telnum, A1.APT_DATE, A1.APT_CDATE, A1.APT_TIMEFROM, A1.APT_TIMETO, CASE A1.APT_TYPE WHEN 1 THEN 'NORMAL' WHEN 2 THEN 'MISC' END APT_TYPE, CASE A1.APT_ACTIVE WHEN 1 THEN 'ACTIVE' WHEN 2 THEN 'CANCEL' END APT_ACTIVE, (select tem_name from gci_team where tem_id=apt_tem_id) TEAM, (select COT_NAME from gci_ref_contractor, gci_team where tem_cot_id=cot_id and tem_id=apt_tem_id) CONTRACTOR, nvl((select usr_lastname ||' '||usr_firstname from gci_user_tech where usr_login=A1.APT_CREATEDBY), A1.APT_CREATEDBY) REGISTERED_BY, A1.APT_MODBY MODIFIED_BY, FN_GET_FNAME(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as FNAME, (nvl(PRO_CONTACT, FN_GET_CONTACT_1(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))))) as CONTACTS, FN_GET_LNAME(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as LNAME, FN_GET_ADR_LINE1(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as ADDRESSNO, FN_GET_ADR_LINE2(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as ADDRESS, FN_GET_TOWN(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as TOWN, (select ftw_fdp1 from gci_ftth_wo where ftw_order_id=A1.APT_ORDER_ID and rownum=1) as fdp, (select ftw_ocab from gci_ftth_wo where ftw_order_id=A1.APT_ORDER_ID and rownum=1) as ocab, (select substr(ftw_olt, 10, 2) from gci_ftth_wo where ftw_order_id=A1.APT_ORDER_ID and rownum=1) as mdf, get_last_orderstatus@GAIA.MAURITIUSTELECOM.COM(apt_order_id) orderstatus, nvl((select usr_lastname ||' '||usr_firstname from gci_user_tech where usr_team=A1.APT_DEPLOYTO and rownum=1), 'NOT DEPLOYED') deploy_to, nvl((select cot_name from gci_ref_contractor where cot_id=A1.APT_CONTRACTTO and rownum=1), 'NOT CONTRACTED' ) contract_to, (select count(1) from gci_customer_order_photo where cop_order_id=pro_order_id) numphoto FROM gci_appointment A1 left join gci_preorder D on a1.apt_order_id=d.pro_order_id WHERE A1.APT_ID in( select distinct apt_id from ( (select apt_id from gci_appointment A , gci_team B, gci_ref_contractor C WHERE A.APT_TEM_ID = B.TEM_ID and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate and (B.TEM_COT_ID = C.COT_ID and C.COT_ID=:contractor) and APT_ACTIVE=:active) union (select apt_id from gci_appointment A , gci_team B, gci_ref_contractor C WHERE A.APT_TEM_ID = B.TEM_ID and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate and (B.TEM_COT_ID=C.COT_ID and C.COT_ID in (select cot_id from gci_ref_contractor where cot_group_id=:contractor)) and APT_ACTIVE=:active) union (select apt_id from gci_appointment a, gci_ref_contractor c, gci_team b where b.tem_active=1 and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate and (A.APT_CONTRACTTO=:contractor and a.apt_contractto=c.cot_id and c.cot_id=b.tem_cot_id) and APT_ACTIVE=:active)) ) ORDER BY APT_DATE, APT_TIMEFROM |
| dbycq2n43t7n5 | SELECT snap_id , SQL_ID FROM (SELECT /*+ ordered use_nl(t2) index(t2) */ t2.snap_id , t1.SQLID_KEWRSIE SQL_ID FROM X$KEWRSQLIDTAB t1, WRH$_SQLTEXT t2 WHERE t2.dbid(+) = :dbid AND t2.SQL_ID(+) = t1.SQLID_KEWRSIE) WHERE nvl(snap_id, 0) < :snap_id |
| f711myt0q6cma | insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22) |
| g0wc1rhrab1pf | BEGIN SP_GENERATE_WO2(to_date(:apt_date, 'DD-MM-YYYY'), :cot_id, :apt_type); END; |
| g1bcfg698634h | select nvl((select cot_name from gci_ref_contractor where cot_id=ftw_cot_id), 'CMC') Contractor, (select tem_name from gci_team where tem_id=ftw_tem_id) Team, (select apt_date||' '|| apt_timefrom||':'||apt_timeto from gci_appointment where apt_id=ftw_apt_id) appointment, ftw_lname as Name, ftw_fname as Firstname, ftw_contactno as Contactno, ftw_addressno as AddressNo, ftw_streetname as Streetname, ftw_locality as Locality, ftw_olt as OLT, ftw_ocab as OCAB, ftw_fdp1 as FDP_1, ftw_fdpport_id as FDPPort_id, ftw_ont_id as ONT_ID, ftw_ont_type as ONT_TYPE, ftw_onu_id as ONU_ID, ftw_shelf as SHELF, ftw_card as Card, ftw_port as Port, ftw_internet_vlan as Internet_vlan, ftw_iptv_vlan as IPTV_VLAN, ftw_order_id as Order_id, ftw_IPTV_PARENTID as IPTV_PARENT_ID, ftw_IPTV_PARENTPWD as IPTV_PARENT_PWD, ftw_stbaccounts as STBACCOUNTS, ftw_IPTV_PASSWORD as STB_PASSWORD, ftw_parentlock as parentlock, ftw_bboffername as offer, ftw_rbsusername as RBSusername, ftw_rbspassword as RBSPassowrd, (case ftw_custcat when 0 then 'Residential' when 1 then 'Business' end) as Category, ftw_ordercdate, to_char(ftw_ordercdate, 'hh24:mi:ss') as orderTime, (select pro_iptv_codes from gci_preorder where pro_order_id = ftw_order_id) as IPTV_CODES, ftw_refno, ftw_tvbouquetname, ftw_iptvaddonsname, ftw_we as WirelessExtender, ftw_powerline as PowerLine, ftw_dualroom as DualRoom, (case ftw_lb when 0 then 'No' when 1 then 'Yes' end) as large_building, (case ftw_ug when 0 then 'No' when 1 then 'Yes' end) as underground_cabling, (case ftw_iw when 0 then 'No' when 1 then 'Yes' end) as internal_wiring, ftw_telnum as telnum, (select GET_ND_BB_SERV_PROMOS@gaia.mauritiustelecom.com(ftw_telnum) from dual) as current_service, (select LART from p_cathors@gaia.mauritiustelecom.com where abrv_art =((select GET_ND_BB_SERV_PROMOS@gaia.mauritiustelecom.com(ftw_telnum) from dual)) and rownum=1) as current_service_label, (select count(ndem) from demande@gaia.mauritiustelecom.com where ndem = ftw_order_id) as ndemNotPS, (select count(cws_order_id) from gci_contractor_work_status where cws_order_id = ftw_order_id and cws_status = 'WWIP') as workSTART, (select count(cws_order_id) from gci_contractor_work_status where cws_order_id = ftw_order_id and cws_status = 'WCOM') as workCOM, (select count(cws_order_id) from gci_contractor_work_status where cws_order_id = ftw_order_id and cws_status = 'WAPRE') as workNOTCOM, (select nvl(apt_comments, '--') from gci_appointment where apt_order_id = ftw_order_id and apt_date=to_date(:i_aptdate, 'DD-MM-YYYY') and rownum=1) as aptComments, ftw_offer as offer_comments from gci_ftth_wo where ftw_tem_id=:i_tem_id and ftw_aptdate=to_date(:i_aptdate, 'DD-MM-YYYY') and ftw_survey=0 order by appointment, firstname |
| g3bjqa5xz1hg7 | select pr.pro_id, pr.pro_order_id, pr.pro_telnum, FN_GET_FNAME(pro_telnum) firstname, FN_GET_LNAME(pro_telnum) lastname, FN_GET_CLIENTID@GAIA.MAURITIUSTELECOM.COM(pro_telnum) CLIENTID, FN_GET_ADR_LINE1(pro_telnum)||' '|| FN_GET_ADR_LINE2(pro_telnum) address, get_nd_ftth_const@GAIA.MAURITIUSTELECOM.COM(pro_telnum) ftthconst, FN_GET_CONTACT(pro_telnum) contactnum, nvl(pro_rbs_id, 'rbs_us') pro_rbs_id, nvl(pro_rbs_password, 'rbs_pw') pro_rbs_pwd, pro_product, (select rbc_value from gci_ref_bandwidth_cap, gci_ref_bb_offer bo where bo.rbo_id=pro_bboffer and rbc_id=rbo_cap_bw) volcap, (select rbw_value from gci_ref_bandwidth, gci_ref_bb_offer bo where bo.rbo_id=pro_bboffer and rbw_id=rbo_up_bw) uploadbw, (select rbw_value from gci_ref_bandwidth, gci_ref_bb_offer bo where bo.rbo_id=pro_bboffer and rbw_id=rbo_down_bw) downloadbw, '.' salutation, get_dn_switch@GAIA.MAURITIUSTELECOM.COM(pr.pro_telnum) switchinfo, pro_voip, pro_custcat from gci_preorder pr inner join demande@gaia.mauritiustelecom.com on ndem=pro_order_id where pro_cmot = 'TECH' and pro_Sdate is null -- and pro_bboffer is not null and pro_active = 1 and (pro_failure_code != 'CCF' or pro_failure_code is null or pro_failure_code = '0') and pro_order_id is not null -- and pro_order_id in ('9407247') and (select count(1) from doslig0@gaia.mauritiustelecom.com d0, client@gaia.mauritiustelecom.com c where d0.ncli=c.ncli and nd=pr.pro_telnum and datfin_ld is null)=1 and (select count(1) from mt_ftth_pcust@gaia.mauritiustelecom.com where nd=pr.pro_telnum and end_date is null and FDP_1 is not null)>0 and rownum <11 and pro_custcat=1 |
| ghy4b5kc6an36 | SELECT distinct A1.APT_ID, A1.APT_ORDER_ID, D.PRO_TELNUM telnum, A1.APT_DATE, A1.APT_TIMEFROM, A1.APT_TIMETO, FN_APPT_MISSED_RESCH(A1.APT_ORDER_ID) as APT_STATUS, CASE A1.APT_TYPE WHEN 1 THEN 'NORMAL' WHEN 2 THEN 'MISC' END APT_TYPE, CASE A1.APT_ACTIVE WHEN 1 THEN 'ACTIVE' WHEN 2 THEN 'CANCEL' END APT_ACTIVE, (select tem_name from gci_team where tem_id=apt_tem_id) TEAM, (select COT_NAME from gci_ref_contractor, gci_team where tem_cot_id=cot_id and tem_id=apt_tem_id) CONTRACTOR, nvl((select usr_lastname ||' '||usr_firstname from gci_user_tech where usr_login=A1.APT_CREATEDBY), A1.APT_CREATEDBY) REGISTERED_BY, A1.APT_MODBY MODIFIED_BY, FN_GET_FNAME(pro_telnum) as FNAME, (nvl(PRO_CONTACT, FN_GET_CONTACT_1(PRO_TELNUM))) as CONTACTS, FN_GET_LNAME(pro_telnum) as LNAME, FN_GET_ADR_LINE1(pro_telnum) as ADDRESSNO, FN_GET_ADR_LINE2(pro_telnum) as ADDRESS, FN_GET_TOWN(pro_telnum) as TOWN, get_last_orderstatus@GAIA.MAURITIUSTELECOM.COM(apt_order_id) orderstatus, nvl((select usr_lastname ||' '||usr_firstname from gci_user_tech where usr_team=A1.APT_DEPLOYTO and rownum=1), 'NOT DEPLOYED') deploy_to, nvl((select cot_name from gci_ref_contractor where cot_id=A1.APT_CONTRACTTO and rownum=1), 'NOT CONTRACTED' ) contract_to, (select count(1) from gci_customer_order_photo where cop_order_id=pro_order_id) numphoto FROM gci_appointment A1 left join gci_preorder D on a1.apt_order_id=d.pro_order_id WHERE A1.APT_ID in( select distinct apt_id from ( (select apt_id from gci_appointment A , gci_team B, gci_ref_contractor C WHERE A.APT_TEM_ID = B.TEM_ID and APT_ORDER_ID=:orderid) union (select apt_id from gci_appointment A , gci_team B, gci_ref_contractor C WHERE A.APT_TEM_ID = B.TEM_ID and APT_ORDER_ID=:orderid) union (select apt_id from gci_appointment a, gci_ref_contractor c, gci_team b where b.tem_active=1 and APT_ORDER_ID=:orderid)) ) ORDER BY APT_DATE, APT_TIMEFROM |
| gm9t6ycmb1yu6 | delete from smon_scn_time where scn = (select min(scn) from smon_scn_time) |
| gp1d1xbnqurs6 | SELECT distinct A1.APT_ID, A1.APT_ORDER_ID, nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, '')) as telnum, A1.APT_DATE, A1.APT_CDATE, A1.APT_TIMEFROM, A1.APT_TIMETO, CASE A1.APT_TYPE WHEN 1 THEN 'NORMAL' WHEN 2 THEN 'MISC' END APT_TYPE, CASE A1.APT_ACTIVE WHEN 1 THEN 'ACTIVE' WHEN 2 THEN 'CANCEL' END APT_ACTIVE, (select tem_name from gci_team where tem_id=apt_tem_id) TEAM, (select COT_NAME from gci_ref_contractor, gci_team where tem_cot_id=cot_id and tem_id=apt_tem_id) CONTRACTOR, nvl((select usr_lastname ||' '||usr_firstname from gci_user_tech where usr_login=A1.APT_CREATEDBY), A1.APT_CREATEDBY) REGISTERED_BY, A1.APT_MODBY MODIFIED_BY, FN_GET_FNAME(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as FNAME, (nvl(PRO_CONTACT, FN_GET_CONTACT_1(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))))) as CONTACTS, FN_GET_LNAME(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as LNAME, FN_GET_ADR_LINE1(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as ADDRESSNO, FN_GET_ADR_LINE2(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as ADDRESS, FN_GET_TOWN(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as TOWN, (select ftw_fdp1 from gci_ftth_wo where ftw_order_id=A1.APT_ORDER_ID and rownum=1) as fdp, (select ftw_ocab from gci_ftth_wo where ftw_order_id=A1.APT_ORDER_ID and rownum=1) as ocab, (select substr(ftw_olt, 10, 2) from gci_ftth_wo where ftw_order_id=A1.APT_ORDER_ID and rownum=1) as mdf, get_last_orderstatus@GAIA.MAURITIUSTELECOM.COM(apt_order_id) orderstatus, nvl((select usr_lastname ||' '||usr_firstname from gci_user_tech where usr_team=A1.APT_DEPLOYTO and rownum=1), 'NOT DEPLOYED') deploy_to, nvl((select cot_name from gci_ref_contractor where cot_id=A1.APT_CONTRACTTO and rownum=1), 'NOT CONTRACTED' ) contract_to, (select count(1) from gci_customer_order_photo where cop_order_id=pro_order_id) numphoto FROM gci_appointment A1 left join gci_preorder D on a1.apt_order_id=d.pro_order_id WHERE A1.APT_ID in( select distinct apt_id from ( (select apt_id from gci_appointment A , gci_team B, gci_ref_contractor C WHERE A.APT_TEM_ID = B.TEM_ID and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate and (B.TEM_COT_ID = C.COT_ID and C.COT_ID=:contractor) and APT_ORDER_ID=:orderid) union (select apt_id from gci_appointment A , gci_team B, gci_ref_contractor C WHERE A.APT_TEM_ID = B.TEM_ID and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate and (B.TEM_COT_ID=C.COT_ID and C.COT_ID in (select cot_id from gci_ref_contractor where cot_group_id=:contractor)) and APT_ORDER_ID=:orderid) union (select apt_id from gci_appointment a, gci_ref_contractor c, gci_team b where b.tem_active=1 and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate and (A.APT_CONTRACTTO=:contractor and a.apt_contractto=c.cot_id and c.cot_id=b.tem_cot_id) and APT_ORDER_ID=:orderid)) ) ORDER BY APT_DATE, APT_TIMEFROM |
| gs9jd5zqsngx2 | SELECT COUNT(1) FROM "GCI_BILLED_ORDER" "A1" WHERE "A1"."STATUS"=3 AND "A1"."ND"=:B1 AND UPPER("A1"."REMARKS") LIKE '%FTTH%' |
| gsdu2p1wkasu9 | SELECT distinct A1.APT_ID, A1.APT_ORDER_ID, D.PRO_TELNUM telnum, A1.APT_DATE, A1.APT_TIMEFROM, A1.APT_TIMETO, FN_APPT_MISSED_RESCH(A1.APT_ORDER_ID) as APT_STATUS, CASE A1.APT_TYPE WHEN 1 THEN 'NORMAL' WHEN 2 THEN 'MISC' END APT_TYPE, CASE A1.APT_ACTIVE WHEN 1 THEN 'ACTIVE' WHEN 2 THEN 'CANCEL' END APT_ACTIVE, (select tem_name from gci_team where tem_id=apt_tem_id) TEAM, (select COT_NAME from gci_ref_contractor, gci_team where tem_cot_id=cot_id and tem_id=apt_tem_id) CONTRACTOR, nvl((select usr_lastname ||' '||usr_firstname from gci_user_tech where usr_login=A1.APT_CREATEDBY), A1.APT_CREATEDBY) REGISTERED_BY, A1.APT_MODBY MODIFIED_BY, FN_GET_FNAME(pro_telnum) as FNAME, (nvl(PRO_CONTACT, FN_GET_CONTACT_1(PRO_TELNUM))) as CONTACTS, FN_GET_LNAME(pro_telnum) as LNAME, FN_GET_ADR_LINE1(pro_telnum) as ADDRESSNO, FN_GET_ADR_LINE2(pro_telnum) as ADDRESS, FN_GET_TOWN(pro_telnum) as TOWN, get_last_orderstatus@GAIA.MAURITIUSTELECOM.COM(apt_order_id) orderstatus, nvl((select usr_lastname ||' '||usr_firstname from gci_user_tech where usr_team=A1.APT_DEPLOYTO and rownum=1), 'NOT DEPLOYED') deploy_to, nvl((select cot_name from gci_ref_contractor where cot_id=A1.APT_CONTRACTTO and rownum=1), 'NOT CONTRACTED' ) contract_to, (select count(1) from gci_customer_order_photo where cop_order_id=pro_order_id) numphoto FROM gci_appointment A1 left join gci_preorder D on a1.apt_order_id=d.pro_order_id WHERE A1.APT_ID in( select distinct apt_id from ( (select apt_id from gci_appointment A , gci_team B, gci_ref_contractor C WHERE A.APT_TEM_ID = B.TEM_ID and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate) union (select apt_id from gci_appointment A , gci_team B, gci_ref_contractor C WHERE A.APT_TEM_ID = B.TEM_ID and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate) union (select apt_id from gci_appointment a, gci_ref_contractor c, gci_team b where b.tem_active=1 and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate)) ) ORDER BY APT_DATE, APT_TIMEFROM |
| Statistic | Total | per Second | per Trans |
|---|
| Batched IO (bound) vector count | 0 | 0.00 | 0.00 |
| Batched IO (full) vector count | 0 | 0.00 | 0.00 |
| Batched IO block miss count | 0 | 0.00 | 0.00 |
| Batched IO buffer defrag count | 0 | 0.00 | 0.00 |
| Batched IO double miss count | 0 | 0.00 | 0.00 |
| Batched IO same unit count | 0 | 0.00 | 0.00 |
| Batched IO single block count | 0 | 0.00 | 0.00 |
| Batched IO slow jump count | 0 | 0.00 | 0.00 |
| Batched IO vector block count | 0 | 0.00 | 0.00 |
| Batched IO vector read count | 0 | 0.00 | 0.00 |
| Block Cleanout Optim referenced | 131 | 0.04 | 0.03 |
| CCursor + sql area evicted | 1 | 0.00 | 0.00 |
| CPU used by this session | 156,924 | 43.34 | 33.42 |
| CPU used when call started | 153,340 | 42.35 | 32.66 |
| CR blocks created | 188 | 0.05 | 0.04 |
| Cached Commit SCN referenced | 338 | 0.09 | 0.07 |
| Commit SCN cached | 5 | 0.00 | 0.00 |
| DB time | 1,131,417 | 312.50 | 240.98 |
| DBWR checkpoint buffers written | 5,019 | 1.39 | 1.07 |
| DBWR checkpoints | 12 | 0.00 | 0.00 |
| DBWR object drop buffers written | 0 | 0.00 | 0.00 |
| DBWR revisited being-written buffer | 0 | 0.00 | 0.00 |
| DBWR tablespace checkpoint buffers written | 35 | 0.01 | 0.01 |
| DBWR thread checkpoint buffers written | 0 | 0.00 | 0.00 |
| DBWR transaction table writes | 223 | 0.06 | 0.05 |
| DBWR undo block writes | 2,068 | 0.57 | 0.44 |
| Effective IO time | 0 | 0.00 | 0.00 |
| HSC Heap Segment Block Changes | 22,725 | 6.28 | 4.84 |
| HSC IDL Compressed Blocks | 0 | 0.00 | 0.00 |
| Heap Segment Array Inserts | 145 | 0.04 | 0.03 |
| Heap Segment Array Updates | 112 | 0.03 | 0.02 |
| IMU CR rollbacks | 1 | 0.00 | 0.00 |
| IMU Flushes | 510 | 0.14 | 0.11 |
| IMU Redo allocation size | 728,956 | 201.34 | 155.26 |
| IMU commits | 1,409 | 0.39 | 0.30 |
| IMU contention | 0 | 0.00 | 0.00 |
| IMU ktichg flush | 0 | 0.00 | 0.00 |
| IMU pool not allocated | 0 | 0.00 | 0.00 |
| IMU recursive-transaction flush | 0 | 0.00 | 0.00 |
| IMU undo allocation size | 5,411,288 | 1,494.62 | 1,152.56 |
| IMU- failed to get a private strand | 0 | 0.00 | 0.00 |
| LOB table id lookup cache misses | 0 | 0.00 | 0.00 |
| Misses for writing mapping | 0 | 0.00 | 0.00 |
| Number of read IOs issued | 4,656 | 1.29 | 0.99 |
| Requests to/from client | 66,932 | 18.49 | 14.26 |
| RowCR - row contention | 2 | 0.00 | 0.00 |
| RowCR attempts | 307 | 0.08 | 0.07 |
| RowCR hits | 304 | 0.08 | 0.06 |
| SMON posted for undo segment recovery | 1 | 0.00 | 0.00 |
| SMON posted for undo segment shrink | 2 | 0.00 | 0.00 |
| SQL*Net roundtrips to/from client | 66,946 | 18.49 | 14.26 |
| SQL*Net roundtrips to/from dblink | 281,665 | 77.80 | 59.99 |
| TBS Extension: bytes extended | 0 | 0.00 | 0.00 |
| TBS Extension: files extended | 0 | 0.00 | 0.00 |
| TBS Extension: tasks created | 0 | 0.00 | 0.00 |
| TBS Extension: tasks executed | 0 | 0.00 | 0.00 |
| active txn count during cleanout | 186 | 0.05 | 0.04 |
| application wait time | 131 | 0.04 | 0.03 |
| background checkpoints completed | 1 | 0.00 | 0.00 |
| background checkpoints started | 1 | 0.00 | 0.00 |
| background timeouts | 21,972 | 6.07 | 4.68 |
| branch node splits | 0 | 0.00 | 0.00 |
| buffer is not pinned count | 1,617,636 | 446.80 | 344.54 |
| buffer is pinned count | 6,386,874 | 1,764.08 | 1,360.36 |
| bytes received via SQL*Net from client | 19,339,346 | 5,341.62 | 4,119.14 |
| bytes received via SQL*Net from dblink | 233,309,939 | 64,441.31 | 49,693.28 |
| bytes sent via SQL*Net to client | 3,223,970,637 | 890,475.89 | 686,681.71 |
| bytes sent via SQL*Net to dblink | 52,085,388 | 14,386.23 | 11,093.80 |
| calls to get snapshot scn: kcmgss | 589,660 | 162.87 | 125.59 |
| calls to kcmgas | 28,543 | 7.88 | 6.08 |
| calls to kcmgcs | 1,147,868 | 317.05 | 244.49 |
| cell physical IO interconnect bytes | 5,313,589,248 | 1,467,638.40 | 1,131,754.90 |
| change write time | 378 | 0.10 | 0.08 |
| cleanout - number of ktugct calls | 302 | 0.08 | 0.06 |
| cleanouts and rollbacks - consistent read gets | 56 | 0.02 | 0.01 |
| cleanouts only - consistent read gets | 36 | 0.01 | 0.01 |
| cluster key scan block gets | 197,882 | 54.66 | 42.15 |
| cluster key scans | 197,638 | 54.59 | 42.10 |
| commit batch performed | 1,512 | 0.42 | 0.32 |
| commit batch requested | 1,512 | 0.42 | 0.32 |
| commit batch/immediate performed | 1,577 | 0.44 | 0.34 |
| commit batch/immediate requested | 1,577 | 0.44 | 0.34 |
| commit cleanout failures: block lost | 0 | 0.00 | 0.00 |
| commit cleanout failures: buffer being written | 0 | 0.00 | 0.00 |
| commit cleanout failures: callback failure | 52 | 0.01 | 0.01 |
| commit cleanout failures: cannot pin | 58 | 0.02 | 0.01 |
| commit cleanouts | 25,580 | 7.07 | 5.45 |
| commit cleanouts successfully completed | 25,470 | 7.03 | 5.42 |
| commit immediate performed | 65 | 0.02 | 0.01 |
| commit immediate requested | 65 | 0.02 | 0.01 |
| commit txn count during cleanout | 466 | 0.13 | 0.10 |
| concurrency wait time | 21,098 | 5.83 | 4.49 |
| consistent changes | 664 | 0.18 | 0.14 |
| consistent gets | 131,857,133 | 36,419.56 | 28,084.59 |
| consistent gets - examination | 782,143 | 216.03 | 166.59 |
| consistent gets direct | 574,176 | 158.59 | 122.30 |
| consistent gets from cache | 131,282,957 | 36,260.97 | 27,962.29 |
| consistent gets from cache (fastpath) | 129,368,237 | 35,732.12 | 27,554.47 |
| cursor authentications | 36 | 0.01 | 0.01 |
| data blocks consistent reads - undo records applied | 652 | 0.18 | 0.14 |
| db block changes | 126,169 | 34.85 | 26.87 |
| db block gets | 151,712 | 41.90 | 32.31 |
| db block gets direct | 33 | 0.01 | 0.01 |
| db block gets from cache | 151,679 | 41.89 | 32.31 |
| db block gets from cache (fastpath) | 19,862 | 5.49 | 4.23 |
| deferred (CURRENT) block cleanout applications | 12,440 | 3.44 | 2.65 |
| dirty buffers inspected | 0 | 0.00 | 0.00 |
| enqueue conversions | 768,913 | 212.38 | 163.77 |
| enqueue releases | 281,784 | 77.83 | 60.02 |
| enqueue requests | 281,799 | 77.83 | 60.02 |
| enqueue timeouts | 0 | 0.00 | 0.00 |
| enqueue waits | 17 | 0.00 | 0.00 |
| exchange deadlocks | 0 | 0.00 | 0.00 |
| execute count | 587,427 | 162.25 | 125.12 |
| failed probes on index block reclamation | 0 | 0.00 | 0.00 |
| file io service time | 0 | 0.00 | 0.00 |
| file io wait time | 87,049,986 | 24,043.62 | 18,541.00 |
| free buffer inspected | 100 | 0.03 | 0.02 |
| free buffer requested | 6,459 | 1.78 | 1.38 |
| heap block compress | 302 | 0.08 | 0.06 |
| hot buffers moved to head of LRU | 5,865 | 1.62 | 1.25 |
| immediate (CR) block cleanout applications | 92 | 0.03 | 0.02 |
| immediate (CURRENT) block cleanout applications | 1,132 | 0.31 | 0.24 |
| in call idle wait time | 19,998,973 | 5,523.81 | 4,259.63 |
| index crx upgrade (positioned) | 0 | 0.00 | 0.00 |
| index crx upgrade (prefetch) | 0 | 0.00 | 0.00 |
| index fast full scans (full) | 133,475 | 36.87 | 28.43 |
| index fetch by key | 167,885 | 46.37 | 35.76 |
| index scans kdiixs1 | 475,401 | 131.31 | 101.26 |
| leaf node 90-10 splits | 35 | 0.01 | 0.01 |
| leaf node splits | 50 | 0.01 | 0.01 |
| lob reads | 0 | 0.00 | 0.00 |
| lob writes | 50 | 0.01 | 0.01 |
| lob writes unaligned | 50 | 0.01 | 0.01 |
| logical read bytes from cache | 1,076,712,538,112 | 297,393,079.94 | 229,331,744.01 |
| logons cumulative | 8,393 | 2.32 | 1.79 |
| max cf enq hold time | 0 | 0.00 | 0.00 |
| messages received | 23,990 | 6.63 | 5.11 |
| messages sent | 23,990 | 6.63 | 5.11 |
| min active SCN optimization applied on CR | 273 | 0.08 | 0.06 |
| no buffer to keep pinned count | 0 | 0.00 | 0.00 |
| no work - consistent read gets | 129,942,132 | 35,890.63 | 27,676.71 |
| non-idle wait count | 2,455,134 | 678.12 | 522.93 |
| non-idle wait time | 564,117 | 155.81 | 120.15 |
| opened cursors cumulative | 574,333 | 158.63 | 122.33 |
| parse count (describe) | 0 | 0.00 | 0.00 |
| parse count (failures) | 0 | 0.00 | 0.00 |
| parse count (hard) | 102 | 0.03 | 0.02 |
| parse count (total) | 82,191 | 22.70 | 17.51 |
| parse time cpu | 2,877 | 0.79 | 0.61 |
| parse time elapsed | 28,533 | 7.88 | 6.08 |
| physical read IO requests | 8,305 | 2.29 | 1.77 |
| physical read bytes | 4,732,461,056 | 1,307,128.06 | 1,007,978.93 |
| physical read total IO requests | 29,592 | 8.17 | 6.30 |
| physical read total bytes | 5,095,897,600 | 1,407,510.95 | 1,085,388.20 |
| physical read total multi block requests | 4,531 | 1.25 | 0.97 |
| physical reads | 577,693 | 159.56 | 123.04 |
| physical reads cache | 3,649 | 1.01 | 0.78 |
| physical reads cache prefetch | 0 | 0.00 | 0.00 |
| physical reads direct | 574,044 | 158.55 | 122.27 |
| physical reads direct (lob) | 0 | 0.00 | 0.00 |
| physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
| physical reads prefetch warmup | 0 | 0.00 | 0.00 |
| physical write IO requests | 2,512 | 0.69 | 0.54 |
| physical write bytes | 41,385,984 | 11,431.00 | 8,814.91 |
| physical write total IO requests | 32,292 | 8.92 | 6.88 |
| physical write total bytes | 217,691,648 | 60,127.46 | 46,366.70 |
| physical write total multi block requests | 73 | 0.02 | 0.02 |
| physical writes | 5,052 | 1.40 | 1.08 |
| physical writes direct | 33 | 0.01 | 0.01 |
| physical writes direct (lob) | 0 | 0.00 | 0.00 |
| physical writes direct temporary tablespace | 0 | 0.00 | 0.00 |
| physical writes from cache | 5,019 | 1.39 | 1.07 |
| physical writes non checkpoint | 1,485 | 0.41 | 0.32 |
| pinned buffers inspected | 0 | 0.00 | 0.00 |
| pinned cursors current | 1 | 0.00 | 0.00 |
| prefetch clients - default | 912 | 0.25 | 0.19 |
| prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
| prefetched blocks aged out before use | 0 | 0.00 | 0.00 |
| process last non-idle time | 4,239 | 1.17 | 0.90 |
| recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
| recursive calls | 4,803,968 | 1,326.88 | 1,023.21 |
| recursive cpu usage | 29,248 | 8.08 | 6.23 |
| redo KB read | 54,306 | 15.00 | 11.57 |
| redo KB read (memory) | 26,372 | 7.28 | 5.62 |
| redo KB read (memory) for transport | 26,372 | 7.28 | 5.62 |
| redo KB read for transport | 26,373 | 7.28 | 5.62 |
| redo blocks checksummed by FG (exclusive) | 8,154 | 2.25 | 1.74 |
| redo blocks written | 59,086 | 16.32 | 12.58 |
| redo buffer allocation retries | 0 | 0.00 | 0.00 |
| redo entries | 63,632 | 17.58 | 13.55 |
| redo log space requests | 0 | 0.00 | 0.00 |
| redo log space wait time | 0 | 0.00 | 0.00 |
| redo ordering marks | 1,971 | 0.54 | 0.42 |
| redo size | 24,016,044 | 6,633.34 | 5,115.24 |
| redo size for direct writes | 271,568 | 75.01 | 57.84 |
| redo subscn max counts | 2,958 | 0.82 | 0.63 |
| redo synch long waits | 72 | 0.02 | 0.02 |
| redo synch poll writes | 0 | 0.00 | 0.00 |
| redo synch polls | 0 | 0.00 | 0.00 |
| redo synch time | 36,520 | 10.09 | 7.78 |
| redo synch time (usec) | 369,814,872 | 102,144.61 | 78,767.81 |
| redo synch writes | 19,390 | 5.36 | 4.13 |
| redo wastage | 5,245,256 | 1,448.76 | 1,117.20 |
| redo write time | 19,561 | 5.40 | 4.17 |
| redo writes | 22,571 | 6.23 | 4.81 |
| remote Oradebug requests | 0 | 0.00 | 0.00 |
| rollback changes - undo records applied | 60 | 0.02 | 0.01 |
| rollbacks only - consistent read gets | 139 | 0.04 | 0.03 |
| root node splits | 0 | 0.00 | 0.00 |
| rows fetched via callback | 49,051 | 13.55 | 10.45 |
| scheduler wait time | 0 | 0.00 | 0.00 |
| securefile direct read bytes | 0 | 0.00 | 0.00 |
| securefile direct read ops | 0 | 0.00 | 0.00 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 492,131 | 135.93 | 104.82 |
| session logical reads | 132,008,845 | 36,461.47 | 28,116.90 |
| shared hash latch upgrades - no wait | 10,478 | 2.89 | 2.23 |
| shared hash latch upgrades - wait | 13 | 0.00 | 0.00 |
| shared io pool buffer get success | 0 | 0.00 | 0.00 |
| sorts (memory) | 927,490 | 256.18 | 197.55 |
| sorts (rows) | 301,590,638 | 83,300.76 | 64,236.56 |
| sql area evicted | 151 | 0.04 | 0.03 |
| sql area purged | 0 | 0.00 | 0.00 |
| summed dirty queue length | 0 | 0.00 | 0.00 |
| switch current to new buffer | 1,218 | 0.34 | 0.26 |
| table fetch by rowid | 3,562,408 | 983.95 | 758.77 |
| table fetch continued row | 103,013 | 28.45 | 21.94 |
| table scan blocks gotten | 127,468,827 | 35,207.49 | 27,149.91 |
| table scan rows gotten | 3,303,408,277 | 912,416.94 | 703,601.34 |
| table scans (direct read) | 12 | 0.00 | 0.00 |
| table scans (long tables) | 21 | 0.01 | 0.00 |
| table scans (rowid ranges) | 0 | 0.00 | 0.00 |
| table scans (short tables) | 148,785 | 41.10 | 31.69 |
| temp space allocated (bytes) | 0 | 0.00 | 0.00 |
| total cf enq hold time | 5,990 | 1.65 | 1.28 |
| total number of cf enq holders | 88 | 0.02 | 0.02 |
| total number of times SMON posted | 8 | 0.00 | 0.00 |
| transaction rollbacks | 1,573 | 0.43 | 0.34 |
| transaction tables consistent read rollbacks | 0 | 0.00 | 0.00 |
| transaction tables consistent reads - undo records applied | 0 | 0.00 | 0.00 |
| undo change vector size | 6,399,200 | 1,767.49 | 1,362.98 |
| user I/O wait time | 1,156 | 0.32 | 0.25 |
| user calls | 95,458 | 26.37 | 20.33 |
| user commits | 3,471 | 0.96 | 0.74 |
| user rollbacks | 1,224 | 0.34 | 0.26 |
| workarea executions - onepass | 0 | 0.00 | 0.00 |
| workarea executions - optimal | 532,253 | 147.01 | 113.37 |
| write clones created in background | 0 | 0.00 | 0.00 |
| write clones created in foreground | 15 | 0.00 | 0.00 |