| SQL Id | SQL Text |
|---|
| 06q34m4hkfnnf | INSERT INTO TMP_YS_DTSPKEY@DCNTR54(DTSPKEY1) SELECT "ID" FROM YS_ATTENDRECORD@DCNTR54 A INNER JOIN YS_BRANCH B ON A.CREATEBRANCHID = B.BRANCHID INNER JOIN YS_CLIENT C ON C.CLIENTID = B.KEEPERCLIENTID WHERE C.MANAGENTCLIENTID='AGD' |
| 0h51sut5098dz | select to_char(WNO, :"SYS_B_0") DAYS, count(*) QTY from YS_STKSBAL m inner join ys_branch b on m.branchid=trim(b.oldbranchdescid) where m.WNO >=:V_S and m.WNO<:V_E and b.BRANCHID=:"SYS_B_1" group by to_char(WNO, :"SYS_B_2") order by to_char(WNO, :"SYS_B_3") |
| 0ztpkwgxphw20 | select B.Name as BranchName, A.CardNo , A.Name, A.GENDER, A.Discount, C.VALIDPOINT from ys_vip A left join ys_branch B ON A.Branchid=B.Branchid LEFT JOIN ys_VipPointTotal C ON A.VIPID=C.VIPID where :"SYS_B_0"=:"SYS_B_1" and A.Name=:Name |
| 163mms90r0n9u | INSERT INTO YS_SALECASHCARRYFORWARD ( ACTUSERID , BEGINAMT , BRANCHID , BUSINESSDATE , CHGOUTAMT , COLLECTAMT , CREATEBRANCHID , CREATEDATE , CREATEUSERID , DESCRIPTION , FINALLYAMT , FORWARDID , FREQUENCYID , ISDONEFLAG , ISSYNC , REMARK , SYSTIME ) SELECT ACTUSERID , BEGINAMT , BRANCHID , BUSINESSDATE , CHGOUTAMT , COLLECTAMT , CREATEBRANCHID , CREATEDATE , CREATEUSERID , DESCRIPTION , FINALLYAMT , FORWARDID , FREQUENCYID , ISDONEFLAG , ISSYNC , REMARK , SYSTIME FROM YS_SALECASHCARRYFORWARD@DCNTR54 A JOIN TMP_YS_DTSPKEY@DCNTR54 B ON A.FORWARDID=B.DTSPKEY1 WHERE NVL(A.DMLFLAG, 0) <>3 |
| 166g704pk7ruw | select m.* from ( select * from ( select rownum rn, z.* from ( select * from YS_FLOOR m1 where branchid=:"SYS_B_0" and createdate >= to_date(:"SYS_B_1", :"SYS_B_2") and createdate <to_date(:"SYS_B_3", :"SYS_B_4") order by m1.createdate, m1.FloorId ) z ) where rownum<=:"SYS_B_5") q inner join YS_FLOOR m on m.FloorId=q.FloorId where rn>:"SYS_B_6" order by m.createdate, m.FloorId |
| 177qs708hm35b | select m.* from ( select * from ( select rownum rn, z.* from ( select * from YS_STKSBAL m1 inner join ys_branch b on Rtrim(b.oldbranchdescid)=m1.branchid where b.branchid=:"SYS_B_0" and (wno >= to_date(:"SYS_B_1", :"SYS_B_2") and wno <to_date(:"SYS_B_3", :"SYS_B_4")) order by m1.wno, m1.Id ) z ) where rownum<=:"SYS_B_5") q inner join YS_STKSBAL m on m.Id=q.Id where rn>:"SYS_B_6" order by m.wno, m.Id |
| 19dq682ns7fg1 | select to_char(SYSTIME, 'yyyy-mm-dd') DAYS, count(*) QTY from YS_STKSCASED m inner join ys_stksmoved d on d.scno=m.scno inner join ys_stksmove h on h.smno=d.smno where m.SYSTIME >=:V_S and m.SYSTIME<:V_E and BRANCHID='Y755115' group by to_char(m.SYSTIME, 'yyyy-mm-dd') order by to_char(SYSTIME, 'yyyy-mm-dd') |
| 1qg8bzaq1w7zn | select m.* from ( select * from ( select rownum rn, z.* from ( select m1.* from ys_inventory m1 where m1.branchcode=:"SYS_B_0" and m1.systime >= to_date(:"SYS_B_1", :"SYS_B_2") and m1.systime <to_date(:"SYS_B_3", :"SYS_B_4") order by m1.systime, m1.BRANCHCODE, m1.PRODUCTID ) z ) where rownum<=:"SYS_B_5") q inner join YS_INVENTORY m on m.BRANCHCODE=q.BRANCHCODE AND m.PRODUCTID=q.PRODUCTID where rn>:"SYS_B_6" order by m.systime, m.BRANCHCODE, m.PRODUCTID |
| 1smutknr85snz | select to_char(SYSTIME, 'yyyy-mm-dd') DAYS, count(*) QTY from YS_STKSCASED m inner join ys_stksmoved d on d.scno=m.scno inner join ys_stksmove h on h.smno=d.smno where m.SYSTIME >=:V_S and m.SYSTIME<:V_E and BRANCHID='Y75592' group by to_char(m.SYSTIME, 'yyyy-mm-dd') order by to_char(SYSTIME, 'yyyy-mm-dd') |
| 1v363hzs3kq2d | DELETE FROM YS_ATTENDRECORD@DCNTR54 A WHERE EXISTS ( SELECT NULL FROM TMP_YS_DTSPKEY@DCNTR54 B WHERE A. "ID" = B.DTSPKEY1 ) |
| 1yhvd817u8yvu | DELETE FROM YS_SALECASHCARRYFORWARD@DCNTR54 A WHERE EXISTS ( SELECT NULL FROM TMP_YS_DTSPKEY@DCNTR54 B WHERE A.FORWARDID = B.DTSPKEY1 ) |
| 248jkuvv3mmjb | MERGE INTO YS_SALCASHREGISTER P USING (SELECT CASHREGISTERID, BRANCHID, PRINTTYPE, PRINTPORT, CASHDRAWEROPERWAY, CASHDRAWEROPERWAYDESC, CUSTOMERMSGWAY, CUSTOMERMSGPORT, PAGELEFTMARGIN, PAGEBOTTOMMARGIN, CREATEUSERID, CREATEDATE, ID, ISSYNC, CREATEBRANCHID, DECIMALCOUNT, SALERESULT, SALEOFFSTYLE, SYSTIME, BUSINESSDATE FROM YS_SALCASHREGISTER@DCNTR54 WHERE ID IN (SELECT KEY1 FROM TMP_CLS_DATA ) ) Q ON (P.ID=Q.ID) WHEN MATCHED THEN UPDATE SET P.CASHREGISTERID=Q.CASHREGISTERID, P.BRANCHID=Q.BRANCHID, P.PRINTTYPE=Q.PRINTTYPE, P.PRINTPORT=Q.PRINTPORT, P.CASHDRAWEROPERWAY=Q.CASHDRAWEROPERWAY, P.CASHDRAWEROPERWAYDESC=Q.CASHDRAWEROPERWAYDESC, P.CUSTOMERMSGWAY=Q.CUSTOMERMSGWAY, P.CUSTOMERMSGPORT=Q.CUSTOMERMSGPORT, P.PAGELEFTMARGIN=Q.PAGELEFTMARGIN, P.PAGEBOTTOMMARGIN=Q.PAGEBOTTOMMARGIN, P.CREATEUSERID=Q.CREATEUSERID, P.CREATEDATE=Q.CREATEDATE, P.ISSYNC=Q.ISSYNC, P.CREATEBRANCHID=Q.CREATEBRANCHID, P.DECIMALCOUNT=Q.DECIMALCOUNT, P.SALERESULT=Q.SALERESULT, P.SALEOFFSTYLE=Q.SALEOFFSTYLE, P.SYSTIME=Q.SYSTIME, P.BUSINESSDATE=Q.BUSINESSDATE WHEN NOT MATCHED THEN INSERT (CASHREGISTERID, BRANCHID, PRINTTYPE, PRINTPORT, CASHDRAWEROPERWAY, CASHDRAWEROPERWAYDESC, CUSTOMERMSGWAY, CUSTOMERMSGPORT, PAGELEFTMARGIN, PAGEBOTTOMMARGIN, CREATEUSERID, CREATEDATE, ID, ISSYNC, CREATEBRANCHID, DECIMALCOUNT, SALERESULT, SALEOFFSTYLE, SYSTIME, BUSINESSDATE) VALUES(Q.CASHREGISTERID, Q.BRANCHID, Q.PRINTTYPE, Q.PRINTPORT, Q.CASHDRAWEROPERWAY, Q.CASHDRAWEROPERWAYDESC, Q.CUSTOMERMSGWAY, Q.CUSTOMERMSGPORT, Q.PAGELEFTMARGIN, Q.PAGEBOTTOMMARGIN, Q.CREATEUSERID, Q.CREATEDATE, Q.ID, Q.ISSYNC, Q.CREATEBRANCHID, Q.DECIMALCOUNT, Q.SALERESULT, Q.SALEOFFSTYLE, Q.SYSTIME, Q.BUSINESSDATE) |
| 2697r833nqhbs | select m.* from ( select * from ( select rownum rn, z.* from ( select m1.* from YS_STKSMOVED m1 inner join ys_stksmove h on h.smno=m1.smno where h.branchid=:"SYS_B_0" and m1.CREATEDATE >= to_date(:"SYS_B_1", :"SYS_B_2")-interval :"SYS_B_3" MINUTE and m1.CREATEDATE <to_date(:"SYS_B_4", :"SYS_B_5") order by m1.CREATEDATE, m1.Id ) z ) where rownum<=:"SYS_B_6") q inner join YS_STKSMOVED m on m.Id=q.Id where rn>:"SYS_B_7" order by m.CREATEDATE, m.Id |
| 294uu29y8ps4p | select m.* from ( select * from ( select rownum rn, z.* from ( select * from YS_STKSMOVE m1 where branchid=:"SYS_B_0" and Workdate >= to_date(:"SYS_B_1", :"SYS_B_2") and Workdate <=to_date(:"SYS_B_3", :"SYS_B_4") order by m1.createdate, m1.Id ) z ) where rownum<=:"SYS_B_5") q inner join YS_STKSMOVE m on m.Id=q.Id where rn>:"SYS_B_6" order by m.createdate, m.Id |
| 2b1g7v27jgn8v | SELECT BRANCHID FROM YS_BRANCH WHERE RTRIM(OLDBRANCHDESCID)= :V_BRACODE |
| 2fu8mbu4hd108 | select a.branchcode as branchid , a.ProductId, a.Qty From ys_Inventory a inner join tmp_branchid b on a.branchcode=b.BranchId inner join product_inf c on a.ProductId=c.ProductId where c.StyleNo between :v_FromStyleNo and :v_ToStyleNo |
| 2j0fw19fph49j | 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 |
| 2kgddsswfn7qk | select m.* from ( select * from ( select rownum rn, z.* from ( select * from YS_STAFF m1 where systime >= to_date(:"SYS_B_0", :"SYS_B_1") and systime<to_date(:"SYS_B_2", :"SYS_B_3") and branchid=:"SYS_B_4" order by m1.systime, m1.StaffId ) z ) where rownum<=:"SYS_B_5") q inner join YS_STAFF m on m.StaffId=q.StaffId where rn>:"SYS_B_6" order by m.systime, m.StaffId |
| 2s4hnb1htm4wk | select vipid, BranchCode, keeperclientid, branchdesc, cardno, discount, CardDescription, Cellphone, Telephone, VIPDesc, VALIDPOINT From (select a.VipId, b.OldBranchDescId as Branchcode, b.keeperclientid, b.Name as BranchDesc, a.CardNo, a.Discount, a.CardDescription, a.Cellphone, a.Telephone, a.Name as VIPDesc, C.VALIDPOINT from ys_Vip a left join ys_Branch b on a.BranchId=b.BranchId LEFT JOIN ys_VipPointTotal C ON A.VIPID=C.VIPID where a.CardNo=:VipNo union all select a.VipId, b.OldBranchDescId as Branchcode, b.keeperclientid, b.Name as BranchDesc, a.CardNo, a.Discount, a.CardDescription, a.Cellphone, a.Telephone, a.Name as VIPDesc, C.VALIDPOINT from ys_Vip a left join ys_Branch b on a.BranchId=b.BranchId LEFT JOIN ys_VipPointTotal C ON A.VIPID=C.VIPID where a.Cellphone= :VipNo ) t0 |
| 2y2nt3xvnsta0 | select to_char(SYSTIME, 'yyyy-mm-dd') DAYS, count(*) QTY from YS_STKSCASED m inner join ys_stksmoved d on d.scno=m.scno inner join ys_stksmove h on h.smno=d.smno where m.SYSTIME >=:V_S and m.SYSTIME<:V_E and BRANCHID='Y75573' group by to_char(m.SYSTIME, 'yyyy-mm-dd') order by to_char(SYSTIME, 'yyyy-mm-dd') |
| 2yn1z1cjm51wd | select t.*, o.*, m.comments from sys.dba_tables t, sys.dba_tab_comments m, sys.dba_objects o where t.owner = :object_owner and t.table_name = :object_name and m.owner (+) = :object_owner and m.table_name (+) = :object_name and o.owner (+) = :object_owner and o.object_name (+) = :object_name and :object_type is not null and :sub_object is null |
| 304f69uwmt8fv | select m.* from ( select * from ( select rownum rn, z.* from ( select * from YS_BRANCHPARTNER m1 where (branchid=:"SYS_B_0" or partnerbranchid=:"SYS_B_1") and systime >= to_date(:"SYS_B_2", :"SYS_B_3") and systime<to_date(:"SYS_B_4", :"SYS_B_5") order by m1.systime, m1.PartnerId ) z ) where rownum<=:"SYS_B_6") q inner join YS_BRANCHPARTNER m on m.PartnerId=q.PartnerId where rn>:"SYS_B_7" order by m.systime, m.PartnerId |
| 36mjrcr1nv1ak | INSERT INTO YS_DBSETTING ( DESCRIPTION , VALUE , CREATEDATE , BRANCHID , DATABASETYPE , LASTUPDATETIME , SYSTIME ) SELECT DESCRIPTION , VALUE , CREATEDATE , BRANCHID , DATABASETYPE , LASTUPDATETIME , SYSTIME FROM YS_DBSETTING@DCNTR54 A INNER JOIN TMP_YS_DTSPKEY2@DCNTR54 B ON A.DESCRIPTION=B.PKEYC1 AND A.BRANCHID=B.PKEYC2 |
| 3d587cw7w40jv | select to_char(WNO, :"SYS_B_0") DAYS, count(*) QTY from YS_STKSCASE m inner join ys_stksmoved d on d.scno=m.scno inner join ys_stksmove h on h.smno=d.smno where m.WNO >=:V_S and m.WNO<:V_E and h.BRANCHID=:"SYS_B_1" group by to_char(m.WNO, :"SYS_B_2") order by to_char(m.WNO, :"SYS_B_3") |
| 3nkd3g3ju5ph1 | select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null |
| 43q76r7wsjs48 | select m.* from ( select * from ( select rownum rn, z.* from ( select * from YS_SALEPAYDETAIL m1 inner join ys_sale h on h.saleid=m1.saleid inner join ys_branch A0 on A0.branchid=h.BranchId where h.branchid=:"SYS_B_00" and A0.branchtype!=:"SYS_B_01" and m1.createdate >= to_date(:"SYS_B_02", :"SYS_B_03") and m1.createdate<to_date(:"SYS_B_04", :"SYS_B_05") and h.workdate >= to_date(:"SYS_B_06", :"SYS_B_07")-:"SYS_B_08" and h.workdate<=to_date(:"SYS_B_09", :"SYS_B_10")+:"SYS_B_11" order by m1.createdate, m1.PayDetailId ) z ) where rownum<=:"SYS_B_12") q inner join YS_SALEPAYDETAIL m on m.PayDetailId=q.PayDetailId where rn>:"SYS_B_13" order by m.createdate, m.PayDetailId |
| 45bv8pz1znkhr | UPDATE WRI$_ADV_RECOMMENDATIONS SET FILTERED = 'Y' WHERE TASK_ID = :B1 AND ID IN (SELECT REC_ID FROM (SELECT A.REC_ID AS REC_ID, COUNT(*) AS TOTAL_CNT, SUM(CASE WHEN A.FILTERED = 'Y' THEN 1 ELSE 0 END) AS FILT_CNT FROM DBA_ADVISOR_ACTIONS A WHERE A.TASK_ID = :B1 GROUP BY A.REC_ID) WHERE TOTAL_CNT = FILT_CNT) |
| 4m9bapf9sj3sf | SELECT mgmt_metric_value_obj.new(target_guid, null, null, mgmt_namevalue_array(mgmt_namevalue_obj.new('privTransferRate', privTransferRate))) from ( SELECT ta.source_target_guid target_guid, SUM(c.value) privTransferRate FROM mgmt_current_metrics c, mgmt_current_availability a, mgmt_targets t2, mgmt_target_assocs ta, mgmt_target_assoc_defs td, mgmt_ha_cls_intr_conn i, mgmt_ecm_gen_snapshot s WHERE c.metric_guid = HEXTORAW('F77CC469F1DBA385991ACF69FEB4E329') AND c.target_guid = t2.target_guid AND a.target_guid = t2.target_guid AND a.current_status > 0 AND t2.target_guid = ta.assoc_target_guid AND ta.assoc_guid = td.assoc_guid AND td.assoc_def_name = 'contains' AND td.scope_target_type = ' ' AND (i.ic_node = 'global' or i.ic_node = t2.target_name) AND i.ic_public = 'NO' AND i.ecm_snapshot_id = s.snapshot_guid AND s.snapshot_type = 'ha_cls_intrconn' AND s.is_current = 'Y' AND s.target_guid = ta.source_target_guid AND i.ic_name = c.key_value AND t2.target_type = 'host' GROUP BY ta.source_target_guid ) WHERE target_guid IN (SELECT target_guid FROM MGMT_COLLECTION_METRIC_TASKS WHERE TASK_ID = :task_id) order by target_guid |
| 4mzycbda77mw1 | select m.* from ( select * from ( select rownum rn, z.* from ( select m1.* from YS_ATTENDRECORD m1 where m1.createbranchid=:"SYS_B_0" and m1.systime >= to_date(:"SYS_B_1", :"SYS_B_2") and m1.systime <to_date(:"SYS_B_3", :"SYS_B_4") order by m1.systime, m1.ID ) z ) where rownum<=:"SYS_B_5") q inner join YS_ATTENDRECORD m on m.ID=q.ID where rn>:"SYS_B_6" order by m.systime, m.ID |
| 4xzgu3zb1r1jm | select cast( 'Y' as char(1)) as Status, a.ID , c.branchid, a.styleno, a.startdate, a.enddate, a.discount, a.createuserid , a.createdate, a.updateuserid, a.updatedate, a.createbranchid, a.discountprice, a.usediscountprice, a.isbmsp From ys_spglobalstyle a inner join ys_SPGlobalBra b on a.id=b.spglobalid inner join ys_Branch c on b.branchcode=rtrim(c.oldbranchdescid) where b.isactive=1 and b.download=0 and b.branchcode=:v_BranchCode AND ROWNUM<=300 union all select cast('N' as char(1)), SpGlobalId, null, null, null, null, null, null, null, null, null, null, null, null, null from ys_SPGlobalBra where download=0 and isactive=0 and branchcode=:v_BranchCode |
| 56cv7fvjpavw9 | select to_char(m.CreateDate, :"SYS_B_0") DAYS, count(*) QTY from YS_STKSMOVED m inner join ys_stksmove h on h.smno=m.smno where m.CreateDate >=:V_S and m.CreateDate<:V_E and h.BRANCHID=:"SYS_B_1" group by to_char(m.CreateDate, :"SYS_B_2") order by to_char(m.CreateDate, :"SYS_B_3") |
| 5k5gfscjjd5u7 | select m.* from ( select * from ( select rownum rn, z.* from ( select m1.* from YS_STKSMOVED m1 inner join ys_stksmove h on h.smno=m1.smno where h.branchid=:"SYS_B_0" and h.Workdate >= to_date(:"SYS_B_1", :"SYS_B_2") and h.Workdate <=to_date(:"SYS_B_3", :"SYS_B_4") order by m1.CREATEDATE, m1.Id ) z ) where rownum<=:"SYS_B_5") q inner join YS_STKSMOVED m on m.Id=q.Id where rn>:"SYS_B_6" order by m.CREATEDATE, m.Id |
| 5k8wdx6jrwt1b | select 'Y' as Status, a.promotionid, a.isactive, a.branchtype, a.branchid, a.name, a.description, a.startdate, a.finishdate, a.createuserid, a.createdate, a.updateuserid, a.updatedate, a.code , a.issuperposition, a.sort, a.moneysort, a.formuladetail, a.createbranchid, a.formulaparameters from ys_salepromotion a where a.branchtype=3 and a.isactive=1 and not exists (select 'Y' From ys_spbranch b where a.promotionid=b.spid and b.branchcode= :V_BRACODE and b.download=1 and b.isactive=1 ) and rownum<=1 |
| 5ms6rbzdnq16t | select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job |
| 5pff77kjrygut | select m.* from ( select * from ( select rownum rn, z.* from ( select * from YS_SALE m1 inner join ys_branch A0 on A0.branchid=m1.BranchId where WorkDate >= to_date(:"SYS_B_0", :"SYS_B_1") and A0.branchtype!=:"SYS_B_2" and WorkDate<=to_date(:"SYS_B_3", :"SYS_B_4") and m1.branchid=:"SYS_B_5" order by m1.systime, m1.SaleId ) z ) where rownum<=:"SYS_B_6") q inner join YS_SALE m on m.SaleId=q.SaleId where rn>:"SYS_B_7" order by m.systime, m.SaleId |
| 5ruu3nmkdajsj | select m.* from ( select * from ( select rownum rn, z.* from ( select * from YS_STKSMOVE m1 where branchid=:"SYS_B_0" and createdate >= to_date(:"SYS_B_1", :"SYS_B_2")-interval :"SYS_B_3" MINUTE and createdate <to_date(:"SYS_B_4", :"SYS_B_5") order by m1.createdate, m1.Id ) z ) where rownum<=:"SYS_B_6") q inner join YS_STKSMOVE m on m.Id=q.Id where rn>:"SYS_B_7" order by m.createdate, m.Id |
| 5s34t44u10q4g | SELECT a.name task_name, nvl(e.status, a.status) status#, a.last_exec_name as last_execution, e.exec_type_id as execution_type# FROM wri$_adv_tasks a, wri$_adv_executions e WHERE a.id = e.task_id(+) and a.advisor_id = e.advisor_id(+) and a.last_exec_name = e.name(+) and a.id = :1 |
| 5wagu5m7n666z | select m.* from ( select * from ( select rownum rn, z.* from ( select * from YS_SALEFREQUENCY m1 where systime >= to_date(:"SYS_B_0", :"SYS_B_1") and systime<to_date(:"SYS_B_2", :"SYS_B_3") and branchid=:"SYS_B_4" order by m1.systime, m1.FrequencyId ) z ) where rownum<=:"SYS_B_5") q inner join YS_SALEFREQUENCY m on m.FrequencyId=q.FrequencyId where rn>:"SYS_B_6" order by m.systime, m.FrequencyId |
| 5wf1qhagkttm8 | INSERT INTO YS_USER ( BRANCHID , BUSINESSDATE , CREATEBRANCHID , CREATEDATE , CREATEUSERID , DISCOUNT , DISCOUNTOPERATEPASSWORD , ISACTIVE , ISSYNC , LASTLOGINDATE , LOGINUSERID , PASSWORD , STAFFID , UPDATEDATE , UPDATEUSERID , USERID , USERNAME ) SELECT BRANCHID , BUSINESSDATE , CREATEBRANCHID , CREATEDATE , CREATEUSERID , DISCOUNT , DISCOUNTOPERATEPASSWORD , ISACTIVE , ISSYNC , LASTLOGINDATE , LOGINUSERID , PASSWORD , STAFFID , UPDATEDATE , UPDATEUSERID , USERID , USERNAME FROM YS_USER@DCNTR54 A JOIN TMP_YS_DTSPKEY@DCNTR54 B ON A.USERID=B.DTSPKEY1 WHERE NVL(A.DMLFLAG, 0)<>3 |
| 61tn3mam0vq0b | SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC |
| 62z95xmjf5zrp | DELETE FROM YS_SALEFREQUENCY@DCNTR54 A WHERE EXISTS ( SELECT NULL FROM TMP_YS_DTSPKEY@DCNTR54 B WHERE A.FREQUENCYID = B.DTSPKEY1 ) |
| 63t3ufgq37m0c | SELECT instance_number, instance_name, host_name FROM ( SELECT dbin.instance_number as instance_number, max(dbin.instance_name) as instance_name, max(dbin.host_name) as host_name, sum(case when s.snap_id in (:bid, :eid) then 1 else 0 end) as cnt_edge FROM WRM$_SNAPSHOT s , WRM$_DATABASE_INSTANCE dbin WHERE s.dbid = :dbid AND dbin.instance_number = s.instance_number AND s.snap_id >= :bid AND s.snap_id <= :eid AND dbin.dbid = s.dbid AND dbin.startup_time = s.startup_time GROUP BY dbin.instance_number ) WHERE cnt_edge < 2 |
| 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 |
| 6crff73m0zdgv | select m.* from ( select * from ( select rownum rn, z.* from ( select m1.* from ys_stkscase m1 inner join (select B0.scno, A0.BRANCHID from ys_stksmove A0 inner join ys_stksmoved B0 on A0.smno=B0.smno UNION ALL SELECT B1.SCNo, trim(A1.BranchID) AS BRANCHID from ys_StkSTake A1 inner join ys_StkSTakeBalCount B1 ON A1.STNO=B1.STNO ) AA ON m1.SCNO=AA.SCNO where AA.branchid=:"SYS_B_0" and m1.wno >= to_date(:"SYS_B_1", :"SYS_B_2")-interval :"SYS_B_3" MINUTE and m1.wno <to_date(:"SYS_B_4", :"SYS_B_5") order by m1.wno, m1.Id ) z ) where rownum<=:"SYS_B_6") q inner join YS_STKSCASE m on m.Id=q.Id where rn>:"SYS_B_7" order by m.wno, m.Id |
| 6fyc1w0yw866x | DELETE FROM YS_SALEPROMOTION@DCNTR54 A WHERE EXISTS (SELECT 'Y' FROM TMP_CLS_DATA B WHERE A.PROMOTIONID=B.KEY1 ) |
| 6ps3avjcm7n15 | select m.* from ( select * from ( select rownum rn, z.* from ( select m1.* from ys_stkscase m1 inner join (select B0.scno, A0.BRANCHID, A0.WorkDate from ys_stksmove A0 inner join ys_stksmoved B0 on A0.smno=B0.smno UNION ALL SELECT B1.SCNo, trim(A1.BranchID) AS BRANCHID, A1.Workdate from ys_StkSTake A1 inner join ys_StkSTakeBalCount B1 ON A1.STNO=B1.STNO ) AA ON m1.SCNO=AA.SCNO where AA.branchid=:"SYS_B_0" and AA.WORKDATE >= to_date(:"SYS_B_1", :"SYS_B_2") and AA.WORKDATE <=to_date(:"SYS_B_3", :"SYS_B_4") order by m1.wno, m1.Id ) z ) where rownum<=:"SYS_B_5") q inner join YS_STKSCASE m on m.Id=q.Id where rn>:"SYS_B_6" order by m.wno, m.Id |
| 6wm3n4d7bnddg | SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC |
| 760fzmuvq2jb8 | INSERT INTO YS_ATTENDRECORD ( FID, FSTAFFID, FRECORDTIME, FFLAG, FSIGNID, FRESERVER, FNOTE, "ID", ISSYNC, CREATEBRANCHID, SYSTIME ) SELECT FID, FSTAFFID, FRECORDTIME, FFLAG, FSIGNID, FRESERVER, FNOTE, "ID", ISSYNC, CREATEBRANCHID, SYSTIME FROM YS_ATTENDRECORD@DCNTR54 A JOIN TMP_YS_DTSPKEY@DCNTR54 B ON A. "ID"=B.DTSPKEY1 WHERE NVL(A.DMLFLAG, 0)<>3 |
| 76d7q6as0azfw | select 'Y' as Status, a.promotionid, a.isactive, a.branchtype, c.branchid, a.name, a.description, a.startdate, a.finishdate, a.createuserid, a.createdate, a.updateuserid, a.updatedate, a.code , a.issuperposition, a.sort, a.moneysort, a.formuladetail, a.createbranchid, a.formulaparameters from ys_salepromotion a inner join ys_SpBranch b on a.Promotionid=b.spid inner join ys_branch c on b.branchcode=rtrim(c.oldbranchdescid) where b.download=0 and b.branchcode= :v_BranchCode and b.Isactive=1 and A.branchtype in (2, 8) and rownum<=1 union all select 'N', SpId, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null From ys_SpBranch where Download=0 and IsActive=0 and BranchCode=:v_BranchCode |
| 76vdkwjp32xz1 | MERGE INTO "POS"."YS_VIP" "A1" USING (SELECT /*+ NO_MERGE */ "A5"."VIPID" "VIPID", "A5"."BRANCHID" "BRANCHID", "A5"."CARDNO" "CARDNO", "A5"."CARDDESCRIPTION" "CARDDESCRIPTION", "A5"."DISCOUNT" "DISCOUNT", "A5"."PROVINCEID" "PROVINCEID", "A5"."CITYID" "CITYID", "A5"."NAME" "NAME", "A5"."ADDRESS" "ADDRESS", "A5"."POSTCODE" "POSTCODE", "A5"."TELEPHONE" "TELEPHONE", "A5"."CELLPHONE" "CELLPHONE", "A5"."EMAIL" "EMAIL", "A5"."BIRTHDAY" "BIRTHDAY", "A5"."BUYCOUNT" "BUYCOUNT", "A5"."CREATEUSERID" "CREATEUSERID", "A5"."CREATEDATE" "CREATEDATE", "A5"."UPDATEUSERID" "UPDATEUSERID", "A5"."UPDATEDATE" "UPDATEDATE", "A5"."GENDER" "GENDER", "A5"."IDCODE" "IDCODE", "A5"."CARDTIME" "CARDTIME", "A5"."SYSTIME" "SYSTIME", "A5"."BUSINESSDATE" "BUSINESSDATE" FROM "YS_VIP"@! "A5" WHERE REGEXP_LIKE ("A5"."CARDNO", '[0-9]{10}') AND "A5"."SYSTIME">=:B1 AND EXISTS (SELECT 'Y' FROM "POS"."YS_VIP" "A7" WHERE "A5"."VIPID"="A7"."VIPID") AND NOT EXISTS (SELECT 'Y' FROM "TMP_CLS_DATA"@! "A6" WHERE "A5"."VIPID"="A6"."KEY1")) "A2" ON ("A1"."VIPID"="A2"."VIPID") WHEN MATCHED THEN UPDATE SET "A1"."CARDDESCRIPTION" = "A2"."CARDDESCRIPTION", "A1"."DISCOUNT" = "A2"."DISCOUNT", "A1"."PROVINCEID" = "A2"."PROVINCEID", "A1"."CITYID" = "A2"."CITYID", "A1"."NAME" = "A2"."NAME", "A1"."ADDRESS" = "A2"."ADDRESS", "A1"."POSTCODE" = "A2"."POSTCODE", "A1"."TELEPHONE" = "A2"."TELEPHONE", "A1"."CELLPHONE" = "A2"."CELLPHONE", "A1"."EMAIL" = "A2"."EMAIL", "A1"."BIRTHDAY" = "A2"."BIRTHDAY", "A1"."BUYCOUNT" = "A2"."BUYCOUNT", "A1"."CREATEUSERID" = "A2"."CREATEUSERID", "A1"."CREATEDATE" = "A2"."CREATEDATE", "A1"."UPDATEUSERID" = "A2"."UPDATEUSERID", "A1"."UPDATEDATE" = CURRENT_DATE, "A1"."GENDER" = "A2"."GENDER", "A1"."IDCODE" = "A2"."IDCODE", "A1"."CARDTIME" = "A2"."CARDTIME", "A1"."SYSTIME" = "A2"."SYSTIME", "A1"."BUSINESSDATE" = "A2"."BUSINESSDATE" |
| 774wgksg2t9w6 | INSERT INTO TMP_YS_DTSPKEY2@DCNTR54(PKEYC1, PKEYC2) SELECT FBRANCHCODE, FBILLTYPE FROM YS_BILLNO@DCNTR54 A INNER JOIN YS_BRANCH B ON B.BRANCHID = A.FBRANCHCODE INNER JOIN YS_CLIENT C ON C.CLIENTID = B.KEEPERCLIENTID WHERE C.MANAGENTCLIENTID='AGD' |
| 7rhajab1r7869 | INSERT INTO TMP_YS_DTSPKEY2@DCNTR54(PKEYC1, PKEYC2) SELECT DESCRIPTION, A.BRANCHID FROM YS_DBSETTING@DCNTR54 A INNER JOIN YS_BRANCH B ON B.BRANCHID = A.BRANCHID INNER JOIN YS_CLIENT C ON C.CLIENTID= B.KEEPERCLIENTID WHERE C.MANAGENTCLIENTID='AGD' |
| 7tmf7d3qtjbqc | INSERT INTO YS_SETTING ( SETTINGID , BRANCHID , DESCRIPTION , SETTINGTYPE , SETTINGOBJECTTYPE , SETTINGDATA , CREATEUSERID , CREATEDATE , UPDATEUSERID , UPDATEDATE , ISSYNC , CREATEBRANCHID , BUSINESSDATE ) SELECT SETTINGID , BRANCHID , DESCRIPTION , SETTINGTYPE , SETTINGOBJECTTYPE , SETTINGDATA , CREATEUSERID , CREATEDATE , UPDATEUSERID , UPDATEDATE , ISSYNC , CREATEBRANCHID , BUSINESSDATE FROM YS_SETTING@DCNTR54 A JOIN TMP_YS_DTSPKEY@DCNTR54 B ON A.SETTINGID=B.DTSPKEY1 WHERE NVL(A.DMLFLAG, 0)<>3 |
| 7zrg8n9745t2r | select m.* from ( select * from ( select rownum rn, z.* from ( select * from YS_SALE m1 inner join ys_branch A0 on A0.branchid=m1.BranchId where synctime >= to_date(:"SYS_B_0", :"SYS_B_1") and A0.branchtype!=:"SYS_B_2" and synctime<to_date(:"SYS_B_3", :"SYS_B_4") and m1.branchid=:"SYS_B_5" order by m1.synctime, m1.SaleId ) z ) where rownum<=:"SYS_B_6") q inner join YS_SALE m on m.SaleId=q.SaleId where rn>:"SYS_B_7" order by m.synctime, m.SaleId |
| 7zxu8qz3qup2y | select :"SYS_B_0" from ys_Vip A left join ys_branch B on B.Branchid=A.Branchid where A.CardNo=:VipNo |
| 87gaftwrm2h68 | select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1 |
| 89sdz401dc5uf | select program_oid, schedule_expr, schedule_id, queue_owner, queue_name, queue_agent, event_rule, mxdur_msgid, last_enabled_time, class_oid, next_run_date, last_start_date, last_end_date, retry_count, run_count, failure_count, running_instance, running_slave, flags, job_status, creator, client_id, guid, char_env, start_date, end_date, instance_id, fw_name, fw_oid, destination, credential_name, credential_owner, credential_oid, dest_oid, job_dest_id, run_invoker, program_action, schedule_limit, priority, job_weight, number_of_args, max_runs, max_failures, max_run_duration, comments, user_callback, user_callback_ctx, nls_env, source, env, database_role, owner_udn, dist_flags from sys.scheduler$_job where obj# = :1 |
| 8p9z2ztb272bm | SELECT sx.instance_number, sx.id, sum(decode(e.snap_id, NULL, 0, 1)) as cnt FROM (SELECT s.instance_number, s.snap_id, x.id, x.name FROM WRM$_SNAPSHOT s , X$KEHSQT x WHERE s.dbid = :dbid AND s.instance_number = :inst AND s.snap_id >= :bid AND s.snap_id <= :eid AND s.status = 0 AND x.ver_type = :existence ) sx, WRM$_SNAP_ERROR e WHERE e.dbid(+) = :dbid AND e.instance_number(+) = sx.instance_number AND e.snap_id(+) = sx.snap_id AND e.table_name(+) = sx.name GROUP BY sx.instance_number, sx.id ORDER BY sx.instance_number |
| 8s6nvdkdpsmrw | with cte_SaleDet(BranchId, StaffName, FloorName, LocationName, WorkDate, Hour, StyleNo, StyleName, ColorName, SizeName, Qty, Amt )as ( select a.BranchId, a.Staff_Name, a.Floordesc, a.locationdesc, a.workdate , extract(hour from b.salesdate) , a.style_name , a.style_desc, a.color_name , a.size_name , a.quantity, a.amt From tmpsaleanalyse_dan a inner join ys_Sale b on a.Saleid=b.saleid INNER JOIN TMP_GACBRANCH c on a.BRANCHID=C.BRANCHID where a.workdate between :v_FromDate and :v_ToDate ) select BranchId, StaffName, FloorName, LocationName, WorkDate, Hour, StyleNo, StyleName, ColorName, SizeName, sum(Qty) as Qty, sum(Amt) as Amt From cte_SaleDet group by BranchId, StaffName, FloorName, LocationName, WorkDate, Hour, StyleNo, StyleName, ColorName, SizeName |
| 8tp7w6b8s603s | select to_char(SYSTIME, :"SYS_B_0") DAYS, count(*) QTY from YS_STKSCASED m inner join ys_stksmoved d on d.scno=m.scno inner join ys_stksmove h on h.smno=d.smno where m.SYSTIME >=:V_S and m.SYSTIME<:V_E and BRANCHID=:"SYS_B_1" group by to_char(m.SYSTIME, :"SYS_B_2") order by to_char(SYSTIME, :"SYS_B_3") |
| 8vwv6hx92ymmm | UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1 |
| 8x4ujzr3wd2fh | DELETE FROM YS_BILLNO@DCNTR54 A WHERE EXISTS ( SELECT NULL FROM TMP_YS_DTSPKEY2@DCNTR54 B WHERE A.FBRANCHCODE=B.PKEYC1 AND A.FBILLTYPE=B.PKEYC2 ) |
| 95gm4gwpttasc | SELECT /*+ PARALLEL(10) */ * FROM ( SELECT DENSE_RANK() OVER( ORDER BY NVL(NEWAMT, :"SYS_B_00") DESC) AS XUHAO, T.MANAGENTCLIENTID, DENSE_RANK() OVER(PARTITION BY T.MANAGENTCLIENTID ORDER BY NVL(NEWAMT, :"SYS_B_01") DESC) AS MRANKING, T.CLIENTID, T.CLIENTNAME, DENSE_RANK() OVER(PARTITION BY T.MANAGENTCLIENTID, T.CLIENTID ORDER BY NVL(NEWAMT, :"SYS_B_02") DESC) AS CRANKING, B.BRANCHID, B.NAME, NVL(OLDAMT, :"SYS_B_03") OLDAMT, NVL(NEWAMT, :"SYS_B_04") NEWAMT FROM YS_BRANCH B LEFT JOIN (SELECT BRANCHID, MANAGENTCLIENTID, CLIENTID, CLIENT_NAME AS CLIENTNAME, SUM(AMT) AS NEWAMT FROM TMPSALEANALYSE_DAN WHERE WORKDATE BETWEEN TO_DATE(TO_CHAR(TO_DATE(:"SYS_B_05", :"SYS_B_06"), :"SYS_B_07")||(:"SYS_B_08"), :"SYS_B_09") AND LAST_DAY(TO_DATE(:"SYS_B_10", :"SYS_B_11")) GROUP BY BRANCHID, MANAGENTCLIENTID, CLIENTID, CLIENT_NAME) T ON B.BRANCHID=T.BRANCHID LEFT JOIN (SELECT BRANCHID, SUM(AMT) OLDAMT FROM TMPSALEANALYSE_DAN WHERE WORKDATE BETWEEN ADD_MONTHS(TO_DATE(TO_CHAR(TO_DATE(:"SYS_B_12", :"SYS_B_13"), :"SYS_B_14")||(:"SYS_B_15"), :"SYS_B_16"), -:"SYS_B_17") AND ADD_MONTHS(TO_DATE(:"SYS_B_18", :"SYS_B_19"), -:"SYS_B_20") GROUP BY BRANCHID) TT ON B.BRANCHID=TT.BRANCHID WHERE B.BRANCHTYPE IN (:"SYS_B_21", :"SYS_B_22") AND B.ISACTIVE=:"SYS_B_23" AND NEWAMT>:"SYS_B_24") TAL WHERE TAL.BRANCHID IN ( :"SYS_B_25", :"SYS_B_26", :"SYS_B_27", :"SYS_B_28", :"SYS_B_29", :"SYS_B_30", :"SYS_B_31", :"SYS_B_32", :"SYS_B_33", :"SYS_B_34", :"SYS_B_35", :"SYS_B_36", :"SYS_B_37", :"SYS_B_38", :"SYS_B_39", :"SYS_B_40", :"SYS_B_41", :"SYS_B_42" ) |
| 98vwqhcamqa66 | select to_char(SYSTIME, 'yyyy-mm-dd') DAYS, count(*) QTY from YS_STKSCASED m inner join ys_stksmoved d on d.scno=m.scno inner join ys_stksmove h on h.smno=d.smno where m.SYSTIME >=:V_S and m.SYSTIME<:V_E and BRANCHID='YS75542' group by to_char(m.SYSTIME, 'yyyy-mm-dd') order by to_char(SYSTIME, 'yyyy-mm-dd') |
| 9dhn1b8d88dpf |
select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.obj# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.owner# = 0 and g.name
= 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.owner# = 0 and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID |
| 9faf0f2mncppu | select m.* from ( select * from ( select rownum rn, z.* from ( select m1.* from ys_stkscased m1 inner join ys_stkscase hc on hc.scno=m1.scno inner join (select B0.scno, A0.BRANCHID from ys_stksmove A0 inner join ys_stksmoved B0 on A0.smno=B0.smno UNION ALL SELECT B1.SCNo, trim(A1.BranchID) AS BRANCHID from ys_StkSTake A1 inner join ys_StkSTakeBalCount B1 ON A1.STNO=B1.STNO ) AA ON hc.SCNO=AA.SCNO where AA.branchid=:"SYS_B_0" and m1.systime >= to_date(:"SYS_B_1", :"SYS_B_2")-interval :"SYS_B_3" MINUTE and m1.systime <to_date(:"SYS_B_4", :"SYS_B_5") order by m1.systime, m1.Id ) z ) where rownum<=:"SYS_B_6") q inner join YS_STKSCASED m on m.Id=q.Id where rn>:"SYS_B_7" order by m.systime, m.Id |
| 9mn5r2z2zg55d | select m.* from ( select * from ( select rownum rn, z.* from ( select m1.* from ys_stkscased m1 inner join ys_stkscase hc on hc.scno=m1.scno inner join (select B0.scno, A0.BRANCHID, A0.WORKDATE from ys_stksmove A0 inner join ys_stksmoved B0 on A0.smno=B0.smno UNION ALL SELECT B1.SCNo, trim(A1.BranchID) AS BRANCHID, A1.WORKDATE from ys_StkSTake A1 inner join ys_StkSTakeBalCount B1 ON A1.STNO=B1.STNO ) AA ON hc.SCNO=AA.SCNO where AA.branchid=:"SYS_B_0" and AA.WORKDATE >= to_date(:"SYS_B_1", :"SYS_B_2") and AA.WORKDATE <=to_date(:"SYS_B_3", :"SYS_B_4") order by m1.systime, m1.Id ) z ) where rownum<=:"SYS_B_5") q inner join YS_STKSCASED m on m.Id=q.Id where rn>:"SYS_B_6" order by m.systime, m.Id |
| a1pj3n5hscmqk | INSERT INTO YS_BILLNO ( FBRANCHCODE, FBILLTYPE, FNAME, FPREFIX, FSERIALBIT, FFILLCHAR, FSERIALFORMAT, FLSTSERIALPREFIX, FLSTNUMBER, FMAXID, FMULTICHECK ) SELECT FBRANCHCODE, FBILLTYPE, FNAME, FPREFIX, FSERIALBIT, FFILLCHAR, FSERIALFORMAT, FLSTSERIALPREFIX, FLSTNUMBER, FMAXID, FMULTICHECK FROM YS_BILLNO@DCNTR54 A JOIN TMP_YS_DTSPKEY2@DCNTR54 B ON A.FBRANCHCODE=B.PKEYC1 AND A.FBILLTYPE=B.PKEYC2 WHERE NVL(A.DMLFLAG, 0)<>3 |
| a2d96g1mb6v57 | select m.* from ( select * from ( select rownum rn, z.* from ( select * from YS_SALEPROMOTION m1 where systime >= to_date(:"SYS_B_0", :"SYS_B_1") and systime<to_date(:"SYS_B_2", :"SYS_B_3") and branchid=:"SYS_B_4" order by m1.systime, m1.PromotionId ) z ) where rownum<=:"SYS_B_5") q inner join YS_SALEPROMOTION m on m.PromotionId=q.PromotionId where rn>:"SYS_B_6" order by m.systime, m.PromotionId |
| auft5gq267xbf | select to_char(CreateDate, :"SYS_B_0") DAYS, count(*) QTY from YS_STKSMOVE m where m.CreateDate >=:V_S and m.CreateDate<:V_E and BRANCHID=:"SYS_B_1" group by to_char(CreateDate, :"SYS_B_2") order by to_char(CreateDate, :"SYS_B_3") |
| b41wak2bb7atw | SELECT sum(delta_cpu_time) as total_cpu, sum(case when session_type in ( 'Logminer Reader' , 'Logminer Preparer' , 'Logminer Builder' ) then delta_cpu_time else 0 end) as logmr_cpu, sum(case when session_type in ( 'STREAMS Capture' ) then delta_cpu_time else 0 end) as captr_cpu, sum(case when session_type in ( 'Propagation Sender' , 'Propagation Receiver' ) then delta_cpu_time else 0 end) as prpgt_cpu, sum(case when session_type in ( 'STREAMS Apply Reader' , 'STREAMS Apply Server' , 'STREAMS Apply Coordinator' ) then delta_cpu_time else 0 end) as apply_cpu, sum(case when session_type in ( 'QMON Slaves' , 'QMON Coordinator' ) then delta_cpu_time else 0 end) as qmon_cpu FROM ( SELECT b.session_type, (case when b.min_logon_time = e.min_logon_time then e.sum_cpu_time - b.sum_cpu_time else e.sum_cpu_time end) as delta_cpu_time FROM wrh$_sess_time_stats b, wrh$_sess_time_stats e WHERE b.dbid = :dbid AND b.instance_number = :inst_num AND b.snap_id = :begin_snap_id AND e.dbid = :dbid AND e.instance_number = :inst_num AND e.snap_id = :end_snap_id AND e.session_type = b.session_type AND e.session_type in ( 'Logminer Reader' , 'Logminer Preparer' , 'Logminer Builder' , 'STREAMS Capture' , 'Propagation Sender' , 'Propagation Receiver' , 'STREAMS Apply Reader' , 'STREAMS Apply Server' , 'STREAMS Apply Coordinator' , 'QMON Slaves' , 'QMON Coordinator' ) ) all_types |
| batm1w3m1ruyu | INSERT INTO TMP_YS_DTSPKEY@DCNTR54(DTSPKEY1) SELECT FREQUENCYID FROM YS_SALEFREQUENCY@DCNTR54 A INNER JOIN YS_BRANCH B ON B.BRANCHID=A.BRANCHID INNER JOIN YS_CLIENT C ON C.CLIENTID=B.KEEPERCLIENTID WHERE C.MANAGENTCLIENTID='AGD' |
| bn4b3vjw2mj3u | SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.schedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1 |
| c79yr8bgvwa1p | SELECT * FROM ys_salesumsimple WHERE BRANCHID IN(:"SYS_B_0") |
| c8gnrhxma4tas | SELECT owner#, property FROM sys.wri$_adv_tasks WHERE id = :1 |
| c9q876k3yr27p | begin execute immediate 'truncate table tmp_branchid'; INSERT INTO TMP_BRANCHID(BRANCHID)VALUES('Y020153'); end; |
| cctgnwxkzz0da | select m.* from ( select * from ( select rownum rn, z.* from ( select m1.detailid from YS_SALEDETAIL m1 inner join ys_sale h on h.saleid=m1.saleid inner join ys_branch A0 on A0.branchid=h.BranchId where m1.branchid=:"SYS_B_00" and A0.branchtype!=:"SYS_B_01" and h.Workdate >= to_date(:"SYS_B_02", :"SYS_B_03") and h.Workdate<=to_date(:"SYS_B_04", :"SYS_B_05") and m1.BUSINESSDATE >= to_date(:"SYS_B_06", :"SYS_B_07") and m1.BUSINESSDATE<=to_date(:"SYS_B_08", :"SYS_B_09") order by m1.systime, m1.DetailId ) z ) where rownum<=:"SYS_B_10") q inner join YS_SALEDETAIL m on m.DetailId=q.DetailId where rn>:"SYS_B_11" order by m.systime, m.DetailId |
| ctn0r1msnr4rh | INSERT INTO YS_SALEFREQUENCY ( BRANCHID , BUSINESSBEGINDATE , BUSINESSDATE , BUSINESSENDDATE , CASHCOLLECTNO , CASHREGISTERID , CREATEBRANCHID , CREATEDATE , CREATEUSERID , FREQUENCYID , ISDONEFLAG , ISSYNC , REMARK , SYSTIME , USERID , WORKDATE ) SELECT BRANCHID , BUSINESSBEGINDATE , BUSINESSDATE , BUSINESSENDDATE , CASHCOLLECTNO , CASHREGISTERID , CREATEBRANCHID , CREATEDATE , CREATEUSERID , FREQUENCYID , ISDONEFLAG , ISSYNC, REMARK , SYSTIME , USERID , WORKDATE FROM YS_SALEFREQUENCY@DCNTR54 A JOIN TMP_YS_DTSPKEY@DCNTR54 B ON A.FREQUENCYID=B.DTSPKEY1 WHERE NVL(A.DMLFLAG, 0)<>3 |
| cymsmy2r176b1 | select B.Name as BranchName, A.CardNo , A.Name, A.GENDER, A.Discount, C.VALIDPOINT from ys_vip A left join ys_branch B ON A.Branchid=B.Branchid LEFT JOIN ys_VipPointTotal C ON A.VIPID=C.VIPID where :"SYS_B_0"=:"SYS_B_1" and (A.Telephone=:Telephone or A.Cellphone=:Telephone) |
| czgna7dsw403v | SELECT 'Y' FROM YS_BRANCH A INNER JOIN YS_CLIENT B ON A.KEEPERCLIENTID=B.CLIENTID WHERE RTRIM(A.OLDBRANCHDESCID)= :V_BRACODE AND EXISTS (SELECT 'Y' FROM DBSetting C WHERE C.SETTINGID='AGENT' AND B.MANAGENTCLIENTID=C.SETTINGVAL ) |
| d53nc7j6n1057 | SELECT decode(es.name, 'cache', 0, 'dlm', 1, 'ipq', 2, 3) as client_id, (es.bytes_sent - bs.bytes_sent) as bytes FROM WRH$_IC_CLIENT_STATS es , WRH$_IC_CLIENT_STATS bs WHERE es.dbid = :dbid AND es.instance_number = :inst AND es.snap_id = :eid AND bs.dbid = :dbid AND bs.instance_number = es.instance_number AND bs.snap_id = :bid AND es.name = bs.name |
| d6fr9460wpvyj | INSERT INTO YS_LOCATION ( BRANCHID, ISACTIVE, LOCATIONID, LOCATIONDESC, LOCATIONPER, ISSYNC, CREATEBRANCHID, CREATEDATE, CREATEUSERID, UPDATEDATE, UPDATEUSERID, SYSTIME ) SELECT BRANCHID, ISACTIVE, LOCATIONID, LOCATIONDESC, LOCATIONPER, ISSYNC, CREATEBRANCHID, CREATEDATE, CREATEUSERID, UPDATEDATE, UPDATEUSERID, SYSTIME FROM YS_LOCATION@DCNTR54 A JOIN TMP_YS_DTSPKEY@DCNTR54 B ON A.LOCATIONID=B.DTSPKEY1 WHERE NVL(A.DMLFLAG, 0)<>3 |
| db5jty65jgj8w | select m.* from ( select * from ( select rownum rn, z.* from ( select * from YS_SALECASHCARRYFORWARD m1 where systime >= to_date(:"SYS_B_0", :"SYS_B_1") and systime<to_date(:"SYS_B_2", :"SYS_B_3") and branchid=:"SYS_B_4" order by m1.systime, m1.ForwardId ) z ) where rownum<=:"SYS_B_5") q inner join YS_SALECASHCARRYFORWARD m on m.ForwardId=q.ForwardId where rn>:"SYS_B_6" order by m.systime, m.ForwardId |
| f8c5cux6capd7 | SELECT B.DATATYPE, B.DATAID FROM DistributeHistory A INNER JOIN DistributeData B ON A.ID=B.ID WHERE A.ISACTIVE=:"SYS_B_0" AND A.DOWNLOADED=:"SYS_B_1" AND A.BRANCHCODE=:BRANCHCODE |
| g4bdxf39v9fd1 | select m.* from ( select * from ( select rownum rn, z.* from ( select m1.detailid from YS_SALEDETAIL m1 inner join ys_sale h on h.saleid=m1.saleid inner join ys_branch A0 on A0.branchid=h.BranchId where m1.branchid=:"SYS_B_00" and A0.branchtype!=:"SYS_B_01" and m1.createdate >= to_date(:"SYS_B_02", :"SYS_B_03") and m1.createdate<to_date(:"SYS_B_04", :"SYS_B_05") and m1.BUSINESSDATE >= to_date(:"SYS_B_06", :"SYS_B_07") -:"SYS_B_08" and m1.BUSINESSDATE<=to_date(:"SYS_B_09", :"SYS_B_10") +:"SYS_B_11" order by m1.createdate, m1.DetailId ) z ) where rownum<=:"SYS_B_12") q inner join YS_SALEDETAIL m on m.DetailId=q.DetailId where rn>:"SYS_B_13" order by m.createdate, m.DetailId |
| gf4fzt8pa0023 | INSERT INTO TMP_YS_DTSPKEY@DCNTR54(DTSPKEY1) SELECT FORWARDID FROM YS_SALECASHCARRYFORWARD@DCNTR54 A INNER JOIN YS_BRANCH B ON B.BRANCHID =A.BRANCHID INNER JOIN YS_CLIENT C ON C.CLIENTID = B.KEEPERCLIENTID WHERE C.MANAGENTCLIENTID='AGD' |
| gg54zd767t5nh | select m.* from ( select * from ( select rownum rn, z.* from ( select * from YS_USER m1 where branchid=:"SYS_B_0" and createdate >= to_date(:"SYS_B_1", :"SYS_B_2") and createdate <to_date(:"SYS_B_3", :"SYS_B_4") order by m1.createdate, m1.UserId ) z ) where rownum<=:"SYS_B_5") q inner join YS_USER m on m.UserId=q.UserId where rn>:"SYS_B_6" order by m.createdate, m.UserId |
| ghr9u45ynhuuj | with cte_ClientBra(BRANCHID, OLDBRANCHDESCID, NAME) AS ( select A.BRANCHID, RTRIM(A.OLDBRANCHDESCID), A.NAME FROM YS_BRANCH A where A.ISACTIVE=:"SYS_B_0" AND a.keeperclientid IN (select keeperclientid from ys_branch where rtrim(OLDBRANCHDESCID) = :V_BRACODE ) ), cte_Grand(BRANCHID, OLDBRANCHDESCID, NAME) AS ( SELECT A.BRANCHID, RTRIM(A.OLDBRANCHDESCID), A.NAME FROM BranchRelation B INNER JOIN YS_BRANCH A ON B.BRANCHID2=RTRIM(A.OLDBRANCHDESCID) WHERE B.RELATIONTYPE= :V_TYPE AND B.BRANCHID=:V_BRACODE AND B.FLAG=:"SYS_B_1" AND NOT EXISTS (SELECT :"SYS_B_2" FROM CTE_CLIENTBRA c where B.branchid2=c.OLDBRANCHDESCID ) ) SELECT t0.BRANCHID, t0.OLDBRANCHDESCID, t0.NAME FROM ( SELECT BRANCHID, OLDBRANCHDESCID, NAME FROM cte_ClientBra UNION ALL SELECT BRANCHID, OLDBRANCHDESCID, NAME FROM cte_Grand ) t0 where NOT EXISTS (SELECT :"SYS_B_3" FROM BranchRelation t1 WHERE t1.RELATIONTYPE= :V_TYPE AND t1.FLAG=:"SYS_B_4" and t0.OLDBRANCHDESCID=t1.Branchid2 and t1.Branchid=:V_BRACODE ) |
| gjm43un5cy843 | SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME) |
| Statistic | Total | per Second | per Trans |
|---|
| Batched IO (bound) vector count | 714 | 0.07 | 0.15 |
| Batched IO (full) vector count | 13,635 | 1.26 | 2.78 |
| Batched IO (space) vector count | 0 | 0.00 | 0.00 |
| Batched IO block miss count | 108,661 | 10.06 | 22.19 |
| Batched IO buffer defrag count | 123 | 0.01 | 0.03 |
| Batched IO double miss count | 3,546 | 0.33 | 0.72 |
| Batched IO same unit count | 15,516 | 1.44 | 3.17 |
| Batched IO single block count | 12,992 | 1.20 | 2.65 |
| Batched IO slow jump count | 4 | 0.00 | 0.00 |
| Batched IO vector block count | 93,541 | 8.66 | 19.10 |
| Batched IO vector read count | 4,070 | 0.38 | 0.83 |
| Block Cleanout Optim referenced | 106 | 0.01 | 0.02 |
| CCursor + sql area evicted | 15 | 0.00 | 0.00 |
| CPU used by this session | 11,659,964 | 1,079.18 | 2,381.04 |
| CPU used when call started | 11,557,042 | 1,069.65 | 2,360.02 |
| CR blocks created | 255 | 0.02 | 0.05 |
| Cached Commit SCN referenced | 286,207,612 | 26,489.67 | 58,445.50 |
| Clusterwide global transactions | 1,227 | 0.11 | 0.25 |
| Clusterwide global transactions spanning RAC nodes | 0 | 0.00 | 0.00 |
| Commit SCN cached | 884 | 0.08 | 0.18 |
| DB time | 14,592,317 | 1,350.58 | 2,979.85 |
| DBWR checkpoint buffers written | 14,071 | 1.30 | 2.87 |
| DBWR checkpoints | 60 | 0.01 | 0.01 |
| DBWR fusion writes | 705 | 0.07 | 0.14 |
| DBWR object drop buffers written | 14 | 0.00 | 0.00 |
| DBWR parallel query checkpoint buffers written | 0 | 0.00 | 0.00 |
| DBWR tablespace checkpoint buffers written | 0 | 0.00 | 0.00 |
| DBWR thread checkpoint buffers written | 0 | 0.00 | 0.00 |
| DBWR transaction table writes | 296 | 0.03 | 0.06 |
| DBWR undo block writes | 5,009 | 0.46 | 1.02 |
| DFO trees parallelized | 63 | 0.01 | 0.01 |
| DX/BB enqueue lock background get time | 49 | 0.00 | 0.01 |
| DX/BB enqueue lock background gets | 2,454 | 0.23 | 0.50 |
| DX/BB enqueue lock foreground requests | 489,312 | 45.29 | 99.92 |
| DX/BB enqueue lock foreground wait time | 2,069 | 0.19 | 0.42 |
| Effective IO time | 23,385,933 | 2,164.46 | 4,775.56 |
| HSC Heap Segment Block Changes | 63,783 | 5.90 | 13.02 |
| HSC IDL Compressed Blocks | 0 | 0.00 | 0.00 |
| Heap Segment Array Inserts | 667 | 0.06 | 0.14 |
| 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 | 103,339 | 9.56 | 21.10 |
| PX local messages recv'd | 5,910 | 0.55 | 1.21 |
| PX local messages sent | 5,910 | 0.55 | 1.21 |
| PX remote messages recv'd | 216 | 0.02 | 0.04 |
| PX remote messages sent | 216 | 0.02 | 0.04 |
| Parallel operations downgraded to serial | 0 | 0.00 | 0.00 |
| Parallel operations not downgraded | 63 | 0.01 | 0.01 |
| Requests to/from client | 1,106,422 | 102.40 | 225.94 |
| RowCR - row contention | 0 | 0.00 | 0.00 |
| RowCR attempts | 902 | 0.08 | 0.18 |
| RowCR hits | 986 | 0.09 | 0.20 |
| SMON posted for undo segment recovery | 0 | 0.00 | 0.00 |
| SMON posted for undo segment shrink | 2 | 0.00 | 0.00 |
| SQL*Net roundtrips to/from client | 1,106,601 | 102.42 | 225.98 |
| SQL*Net roundtrips to/from dblink | 336,695 | 31.16 | 68.76 |
| TBS Extension: bytes extended | 0 | 0.00 | 0.00 |
| TBS Extension: files extended | 0 | 0.00 | 0.00 |
| TBS Extension: tasks created | 58 | 0.01 | 0.01 |
| TBS Extension: tasks executed | 58 | 0.01 | 0.01 |
| active txn count during cleanout | 888 | 0.08 | 0.18 |
| application wait time | 13,724 | 1.27 | 2.80 |
| auto extends on undo tablespace | 0 | 0.00 | 0.00 |
| background checkpoints completed | 26 | 0.00 | 0.01 |
| background checkpoints started | 27 | 0.00 | 0.01 |
| background timeouts | 119,047 | 11.02 | 24.31 |
| branch node splits | 0 | 0.00 | 0.00 |
| buffer is not pinned count | 13,406,384,823 | 1,240,815.27 | 2,737,673.03 |
| buffer is pinned count | 197,822,800,903 | 18,309,302.22 | 40,396,732.88 |
| bytes received via SQL*Net from client | 630,211,145 | 58,328.60 | 128,693.31 |
| bytes received via SQL*Net from dblink | 104,305,448 | 9,653.89 | 21,299.87 |
| bytes sent via SQL*Net to client | 953,063,132 | 88,209.86 | 194,621.84 |
| bytes sent via SQL*Net to dblink | 78,364,249 | 7,252.93 | 16,002.50 |
| calls to get snapshot scn: kcmgss | 1,072,262 | 99.24 | 218.96 |
| calls to kcmgas | 150,435 | 13.92 | 30.72 |
| calls to kcmgcs | 2,634,064 | 243.79 | 537.89 |
| cell physical IO interconnect bytes | 3,589,304,320 | 332,204.67 | 732,959.84 |
| change write time | 148 | 0.01 | 0.03 |
| cleanout - number of ktugct calls | 3,768 | 0.35 | 0.77 |
| cleanouts and rollbacks - consistent read gets | 58 | 0.01 | 0.01 |
| cleanouts only - consistent read gets | 2,848 | 0.26 | 0.58 |
| cluster key scan block gets | 11,004 | 1.02 | 2.25 |
| cluster key scans | 8,333 | 0.77 | 1.70 |
| cluster wait time | 50,105 | 4.64 | 10.23 |
| commit batch performed | 225 | 0.02 | 0.05 |
| commit batch requested | 225 | 0.02 | 0.05 |
| commit batch/immediate performed | 361 | 0.03 | 0.07 |
| commit batch/immediate requested | 361 | 0.03 | 0.07 |
| commit cleanout failures: block lost | 4,378 | 0.41 | 0.89 |
| commit cleanout failures: buffer being written | 0 | 0.00 | 0.00 |
| commit cleanout failures: callback failure | 50 | 0.00 | 0.01 |
| commit cleanout failures: cannot pin | 4 | 0.00 | 0.00 |
| commit cleanouts | 21,613 | 2.00 | 4.41 |
| commit cleanouts successfully completed | 17,181 | 1.59 | 3.51 |
| commit immediate performed | 136 | 0.01 | 0.03 |
| commit immediate requested | 136 | 0.01 | 0.03 |
| commit nowait performed | 10 | 0.00 | 0.00 |
| commit nowait requested | 10 | 0.00 | 0.00 |
| commit txn count during cleanout | 3,219 | 0.30 | 0.66 |
| commit wait/nowait performed | 10 | 0.00 | 0.00 |
| commit wait/nowait requested | 10 | 0.00 | 0.00 |
| concurrency wait time | 2,222 | 0.21 | 0.45 |
| consistent changes | 268,826 | 24.88 | 54.90 |
| consistent gets | 14,796,296,556 | 1,369,457.23 | 3,021,502.26 |
| consistent gets - examination | 117,594,454 | 10,883.84 | 24,013.57 |
| consistent gets direct | 103,673 | 9.60 | 21.17 |
| consistent gets from cache | 14,796,192,875 | 1,369,447.64 | 3,021,481.09 |
| consistent gets from cache (fastpath) | 14,672,546,614 | 1,358,003.67 | 2,996,231.70 |
| cursor authentications | 1,559 | 0.14 | 0.32 |
| data blocks consistent reads - undo records applied | 135,891 | 12.58 | 27.75 |
| db block changes | 338,299 | 31.31 | 69.08 |
| db block gets | 424,586 | 39.30 | 86.70 |
| db block gets direct | 3,153 | 0.29 | 0.64 |
| db block gets from cache | 421,433 | 39.01 | 86.06 |
| db block gets from cache (fastpath) | 37,831 | 3.50 | 7.73 |
| deferred (CURRENT) block cleanout applications | 9,534 | 0.88 | 1.95 |
| dirty buffers inspected | 9 | 0.00 | 0.00 |
| doubling up with imu segment | 0 | 0.00 | 0.00 |
| enqueue conversions | 8,513 | 0.79 | 1.74 |
| enqueue releases | 308,394 | 28.54 | 62.98 |
| enqueue requests | 308,698 | 28.57 | 63.04 |
| enqueue timeouts | 302 | 0.03 | 0.06 |
| enqueue waits | 3,538 | 0.33 | 0.72 |
| exchange deadlocks | 0 | 0.00 | 0.00 |
| execute count | 921,130 | 85.25 | 188.10 |
| failed probes on index block reclamation | 0 | 0.00 | 0.00 |
| file io service time | 0 | 0.00 | 0.00 |
| file io wait time | 125,869,616 | 11,649.74 | 25,703.41 |
| free buffer inspected | 309,384 | 28.63 | 63.18 |
| free buffer requested | 360,855 | 33.40 | 73.69 |
| gc blocks compressed | 47,169 | 4.37 | 9.63 |
| gc blocks lost | 0 | 0.00 | 0.00 |
| gc cr block flush time | 86 | 0.01 | 0.02 |
| gc cr block receive time | 11,428 | 1.06 | 2.33 |
| gc cr blocks received | 150,956 | 13.97 | 30.83 |
| gc cr blocks served | 5,017 | 0.46 | 1.02 |
| gc current block flush time | 14 | 0.00 | 0.00 |
| gc current block pin time | 59 | 0.01 | 0.01 |
| gc current block receive time | 9,826 | 0.91 | 2.01 |
| gc current blocks received | 117,729 | 10.90 | 24.04 |
| gc current blocks served | 166,594 | 15.42 | 34.02 |
| gc kbytes saved | 152,979 | 14.16 | 31.24 |
| gc kbytes sent | 1,219,910 | 112.91 | 249.11 |
| gc local grants | 13,541 | 1.25 | 2.77 |
| gc read wait time | 0 | 0.00 | 0.00 |
| gc read wait timeouts | 0 | 0.00 | 0.00 |
| gc read waits | 0 | 0.00 | 0.00 |
| gc remote grants | 54,422 | 5.04 | 11.11 |
| gcs messages sent | 1,110,943 | 102.82 | 226.86 |
| ges messages sent | 52,583,262 | 4,866.79 | 10,737.85 |
| global enqueue get time | 99,477 | 9.21 | 20.31 |
| global enqueue gets async | 5,445 | 0.50 | 1.11 |
| global enqueue gets sync | 722,762 | 66.89 | 147.59 |
| global enqueue releases | 604,025 | 55.90 | 123.35 |
| heap block compress | 1,846 | 0.17 | 0.38 |
| hot buffers moved to head of LRU | 19,130 | 1.77 | 3.91 |
| immediate (CR) block cleanout applications | 2,906 | 0.27 | 0.59 |
| immediate (CURRENT) block cleanout applications | 3,897 | 0.36 | 0.80 |
| in call idle wait time | 64,195,558 | 5,941.56 | 13,109.16 |
| index crx upgrade (positioned) | 338,509 | 31.33 | 69.13 |
| index fast full scans (full) | 32,537 | 3.01 | 6.64 |
| index fast full scans (rowid ranges) | 0 | 0.00 | 0.00 |
| index fetch by key | 20,732,527 | 1,918.88 | 4,233.72 |
| index scans kdiixs1 | 110,388,595 | 10,216.91 | 22,542.09 |
| leaf node 90-10 splits | 166 | 0.02 | 0.03 |
| leaf node splits | 268 | 0.02 | 0.05 |
| lob reads | 93,378 | 8.64 | 19.07 |
| lob writes | 10,172 | 0.94 | 2.08 |
| lob writes unaligned | 9,913 | 0.92 | 2.02 |
| logical read bytes from cache | 121,213,863,985,152 | 11,218,834,526.51 | 24,752,677,963.07 |
| logons cumulative | 1,204 | 0.11 | 0.25 |
| max cf enq hold time | 0 | 0.00 | 0.00 |
| messages received | 102,278 | 9.47 | 20.89 |
| messages sent | 102,278 | 9.47 | 20.89 |
| min active SCN optimization applied on CR | 261 | 0.02 | 0.05 |
| no buffer to keep pinned count | 0 | 0.00 | 0.00 |
| no work - consistent read gets | 14,670,402,240 | 1,357,805.20 | 2,995,793.80 |
| non-idle wait count | 4,231,757 | 391.67 | 864.15 |
| non-idle wait time | 541,651 | 50.13 | 110.61 |
| opened cursors cumulative | 786,608 | 72.80 | 160.63 |
| parse count (describe) | 10 | 0.00 | 0.00 |
| parse count (failures) | 35 | 0.00 | 0.01 |
| parse count (hard) | 6,695 | 0.62 | 1.37 |
| parse count (total) | 84,776 | 7.85 | 17.31 |
| parse time cpu | 10,631 | 0.98 | 2.17 |
| parse time elapsed | 14,211 | 1.32 | 2.90 |
| physical read IO requests | 168,039 | 15.55 | 34.31 |
| physical read bytes | 1,380,458,496 | 127,767.03 | 281,898.81 |
| physical read total IO requests | 244,701 | 22.65 | 49.97 |
| physical read total bytes | 2,789,785,088 | 258,205.92 | 569,692.69 |
| physical read total multi block requests | 169 | 0.02 | 0.03 |
| physical reads | 168,513 | 15.60 | 34.41 |
| physical reads cache | 60,014 | 5.55 | 12.26 |
| physical reads cache prefetch | 15,657 | 1.45 | 3.20 |
| physical reads direct | 108,484 | 10.04 | 22.15 |
| physical reads direct (lob) | 103,618 | 9.59 | 21.16 |
| physical reads direct temporary tablespace | 1,097 | 0.10 | 0.22 |
| physical reads prefetch warmup | 0 | 0.00 | 0.00 |
| physical write IO requests | 21,132 | 1.96 | 4.32 |
| physical write bytes | 225,402,880 | 20,861.95 | 46,028.77 |
| physical write total IO requests | 71,981 | 6.66 | 14.70 |
| physical write total bytes | 799,519,232 | 73,998.75 | 163,267.15 |
| physical write total multi block requests | 441 | 0.04 | 0.09 |
| physical writes | 27,515 | 2.55 | 5.62 |
| physical writes direct | 4,162 | 0.39 | 0.85 |
| physical writes direct (lob) | 2,111 | 0.20 | 0.43 |
| physical writes direct temporary tablespace | 1,656 | 0.15 | 0.34 |
| physical writes from cache | 23,353 | 2.16 | 4.77 |
| physical writes non checkpoint | 15,013 | 1.39 | 3.07 |
| pinned buffers inspected | 9 | 0.00 | 0.00 |
| pinned cursors current | 26 | 0.00 | 0.01 |
| prefetch clients - default | 0 | 0.00 | 0.00 |
| prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
| prefetch warmup blocks flushed out before use | 0 | 0.00 | 0.00 |
| prefetched blocks aged out before use | 224,011 | 20.73 | 45.74 |
| process last non-idle time | 10,561 | 0.98 | 2.16 |
| queries parallelized | 63 | 0.01 | 0.01 |
| recovery blocks read | 15 | 0.00 | 0.00 |
| recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
| recursive calls | 796,643 | 73.73 | 162.68 |
| recursive cpu usage | 13,595 | 1.26 | 2.78 |
| redo KB read | 84,584 | 7.83 | 17.27 |
| redo blocks checksummed by FG (exclusive) | 67,903 | 6.28 | 13.87 |
| redo blocks read for recovery | 0 | 0.00 | 0.00 |
| redo blocks written | 164,483 | 15.22 | 33.59 |
| redo buffer allocation retries | 16 | 0.00 | 0.00 |
| redo entries | 173,647 | 16.07 | 35.46 |
| redo k-bytes read for recovery | 0 | 0.00 | 0.00 |
| redo log space requests | 23 | 0.00 | 0.00 |
| redo log space wait time | 114 | 0.01 | 0.02 |
| redo ordering marks | 5,408 | 0.50 | 1.10 |
| redo size | 72,573,336 | 6,716.96 | 14,819.96 |
| redo size for direct writes | 12,709,180 | 1,176.29 | 2,595.30 |
| redo subscn max counts | 937 | 0.09 | 0.19 |
| redo synch long waits | 37 | 0.00 | 0.01 |
| redo synch time | 1,493 | 0.14 | 0.30 |
| redo synch time (usec) | 15,303,533 | 1,416.40 | 3,125.08 |
| redo synch writes | 4,281 | 0.40 | 0.87 |
| redo wastage | 8,468,044 | 783.75 | 1,729.23 |
| redo write broadcast ack count | 49 | 0.00 | 0.01 |
| redo write broadcast ack time | 750,606 | 69.47 | 153.28 |
| redo write broadcast lgwr post count | 0 | 0.00 | 0.00 |
| redo write time | 6,088 | 0.56 | 1.24 |
| redo writes | 26,004 | 2.41 | 5.31 |
| remote Oradebug requests | 0 | 0.00 | 0.00 |
| rollback changes - undo records applied | 133 | 0.01 | 0.03 |
| rollbacks only - consistent read gets | 4,350 | 0.40 | 0.89 |
| root node splits | 0 | 0.00 | 0.00 |
| rows fetched via callback | 4,342,527 | 401.92 | 886.77 |
| scheduler wait time | 0 | 0.00 | 0.00 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 180,439 | 16.70 | 36.85 |
| session logical reads | 14,796,721,494 | 1,369,496.56 | 3,021,589.03 |
| shared hash latch upgrades - no wait | 5,815,137 | 538.21 | 1,187.49 |
| shared hash latch upgrades - wait | 43,873 | 4.06 | 8.96 |
| sorts (disk) | 0 | 0.00 | 0.00 |
| sorts (memory) | 532,676 | 49.30 | 108.78 |
| sorts (rows) | 382,329,909 | 35,386.18 | 78,074.31 |
| sql area evicted | 851 | 0.08 | 0.17 |
| sql area purged | 2,536 | 0.23 | 0.52 |
| summed dirty queue length | 1 | 0.00 | 0.00 |
| switch current to new buffer | 3,158 | 0.29 | 0.64 |
| table fetch by rowid | 105,572,914,846 | 9,771,201.27 | 21,558,692.02 |
| table fetch continued row | 187,238 | 17.33 | 38.24 |
| table scan blocks gotten | 608,597,366 | 56,328.15 | 124,279.63 |
| table scan rows gotten | 20,473,062,895 | 1,894,864.97 | 4,180,735.74 |
| table scans (direct read) | 1 | 0.00 | 0.00 |
| table scans (long tables) | 274 | 0.03 | 0.06 |
| table scans (rowid ranges) | 273 | 0.03 | 0.06 |
| table scans (short tables) | 148,220 | 13.72 | 30.27 |
| temp space allocated (bytes) | 22,020,096 | 2,038.05 | 4,496.65 |
| total cf enq hold time | 9,790 | 0.91 | 2.00 |
| total number of cf enq holders | 575 | 0.05 | 0.12 |
| total number of times SMON posted | 116 | 0.01 | 0.02 |
| transaction lock background gets | 0 | 0.00 | 0.00 |
| transaction lock foreground requests | 0 | 0.00 | 0.00 |
| transaction rollbacks | 358 | 0.03 | 0.07 |
| transaction tables consistent read rollbacks | 4 | 0.00 | 0.00 |
| transaction tables consistent reads - undo records applied | 104 | 0.01 | 0.02 |
| undo change vector size | 32,553,212 | 3,012.93 | 6,647.58 |
| user I/O wait time | 15,068 | 1.39 | 3.08 |
| user calls | 1,794,588 | 166.10 | 366.47 |
| user commits | 4,888 | 0.45 | 1.00 |
| user rollbacks | 9 | 0.00 | 0.00 |
| workarea executions - onepass | 2 | 0.00 | 0.00 |
| workarea executions - optimal | 613,687 | 56.80 | 125.32 |
| write clones created in background | 8,726 | 0.81 | 1.78 |
| write clones created in foreground | 2 | 0.00 | 0.00 |
| Tablespace | Filename | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
|---|
| OGG | +DATA/dcrac/datafile/ogg01.dbf |
10 | 0 | 0.00 | 1.00 | 7 | 0 | 0 | 0.00 |
| OGG | +DATA/dcrac/datafile/ogg02.dbf |
10 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_BASE | +DATA/dcrac/datafile/pos_base01.dbf |
13 | 0 | 0.77 | 1.00 | 29 | 0 | 0 | 0.00 |
| POS_BASE | +DATA/dcrac/datafile/pos_base02.dbf |
21 | 0 | 2.38 | 1.00 | 44 | 0 | 0 | 0.00 |
| POS_DATA | +DATA/dcrac/datafile/pos_data01.dbf |
64,718 | 6 | 0.00 | 1.00 | 119 | 0 | 1 | 10.00 |
| POS_DATA | +DATA/dcrac/datafile/pos_data02.dbf |
23,030 | 2 | 0.01 | 1.00 | 299 | 0 | 0 | 0.00 |
| POS_DATA | +DATA/dcrac/datafile/pos_data03.dbf |
667 | 0 | 0.22 | 1.00 | 91 | 0 | 0 | 0.00 |
| POS_DATA | +DATA/dcrac/datafile/pos_data04.dbf |
277 | 0 | 0.54 | 1.00 | 113 | 0 | 1 | 0.00 |
| POS_DATA | +DATA/dcrac/datafile/pos_data05.dbf |
2,254 | 0 | 0.14 | 1.08 | 223 | 0 | 4 | 0.00 |
| POS_DATA | +DATA/dcrac/datafile/pos_data06.dbf |
1,085 | 0 | 0.19 | 1.00 | 141 | 0 | 2 | 5.00 |
| POS_DATA | +DATA/dcrac/datafile/pos_data07.dbf |
328 | 0 | 0.40 | 1.00 | 145 | 0 | 4 | 0.00 |
| POS_DATA | +DATA/dcrac/datafile/pos_data08.dbf |
3,109 | 0 | 0.08 | 1.00 | 204 | 0 | 2 | 0.00 |
| POS_DATA | +DATA/dcrac/datafile/pos_data09.dbf |
268 | 0 | 0.67 | 1.00 | 93 | 0 | 0 | 0.00 |
| POS_DATA | +DATA/dcrac/datafile/pos_data10.dbf |
291 | 0 | 0.65 | 1.00 | 104 | 0 | 2 | 5.00 |
| POS_DATA | +DATA/dcrac/datafile/pos_data11.dbf |
368 | 0 | 0.57 | 1.00 | 84 | 0 | 1 | 0.00 |
| POS_DATA | +DATA/dcrac/datafile/pos_data12.dbf |
486 | 0 | 0.60 | 1.00 | 128 | 0 | 0 | 0.00 |
| POS_DATA | +DATA/dcrac/datafile/pos_data13.dbf |
468 | 0 | 0.51 | 1.00 | 157 | 0 | 1 | 0.00 |
| POS_DATA | +DATA/dcrac/datafile/pos_data14.dbf |
1,056 | 0 | 0.16 | 1.00 | 217 | 0 | 0 | 0.00 |
| POS_DATA | +DATA/dcrac/datafile/pos_data15.dbf |
426 | 0 | 0.77 | 1.00 | 101 | 0 | 2 | 0.00 |
| POS_DATA | +DATA/dcrac/datafile/pos_data16.dbf |
485 | 0 | 1.30 | 1.00 | 165 | 0 | 1 | 0.00 |
| POS_DATA | +DATA/dcrac/datafile/pos_data17.dbf |
1,973 | 0 | 0.22 | 1.00 | 85 | 0 | 0 | 0.00 |
| POS_DATA | +DATA/dcrac/datafile/pos_data18.dbf |
825 | 0 | 0.41 | 1.00 | 181 | 0 | 441 | 0.02 |
| POS_DATA | +DATA/dcrac/datafile/pos_data19.dbf |
2,968 | 0 | 0.12 | 1.00 | 141 | 0 | 1 | 0.00 |
| POS_DATA | +DATA/dcrac/datafile/pos_data20.dbf |
1,356 | 0 | 0.26 | 1.00 | 171 | 0 | 2 | 0.00 |
| POS_DATA | +DATA/dcrac/datafile/pos_data21.dbf |
1,783 | 0 | 0.17 | 1.00 | 180 | 0 | 2 | 0.00 |
| POS_DATA | +DATA/dcrac/datafile/pos_data22.dbf |
2,026 | 0 | 0.11 | 1.00 | 101 | 0 | 3 | 0.00 |
| POS_ETL | +DATA/dcrac/datafile/pos_etl01.dbf |
25 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_ETL | +DATA/dcrac/datafile/pos_etl02.dbf |
25 | 0 | 0.00 | 1.00 | 12 | 0 | 0 | 0.00 |
| POS_IDX | +DATA/dcrac/datafile/pos_idx01.dbf |
710 | 0 | 1.15 | 1.00 | 401 | 0 | 0 | 0.00 |
| POS_IDX | +DATA/dcrac/datafile/pos_idx02.dbf |
584 | 0 | 1.22 | 1.00 | 464 | 0 | 0 | 0.00 |
| POS_IDX | +DATA/dcrac/datafile/pos_idx03.dbf |
662 | 0 | 1.18 | 1.00 | 454 | 0 | 0 | 0.00 |
| POS_REPORTSUM | +DATA/dcrac/datafile/pos_reportsum01.dbf |
17 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_REPORTSUM | +DATA/dcrac/datafile/pos_reportsum02.dbf |
17 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_REPORTSUM | +DATA/dcrac/datafile/pos_reportsum03.dbf |
17 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_REPORTSUM | +DATA/dcrac/datafile/pos_reportsum04.dbf |
17 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_REPORTSUM | +DATA/dcrac/datafile/pos_reportsum05.dbf |
17 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_REPORTSUM | +DATA/dcrac/datafile/pos_reportsum06.dbf |
17 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_REPORTSUM | +DATA/dcrac/datafile/pos_reportsum07.dbf |
17 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_REPORTSUM | +DATA/dcrac/datafile/pos_reportsum08.dbf |
17 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_REPORTSUM | +DATA/dcrac/datafile/pos_reportsum09.dbf |
17 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_REPORTSUM | +DATA/dcrac/datafile/pos_reportsum10.dbf |
17 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_REPORTSUM | +DATA/dcrac/datafile/pos_reportsum11.dbf |
17 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_REPORTSUM | +DATA/dcrac/datafile/pos_reportsum12.dbf |
17 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_REPORTSUM | +DATA/dcrac/datafile/pos_reportsum13.dbf |
17 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_REPORTSUM | +DATA/dcrac/datafile/pos_reportsum14.dbf |
17 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_REPORTSUM | +DATA/dcrac/datafile/pos_reportsum15.dbf |
17 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_REPORTSUM2010 | +DATA/dcrac/datafile/pos_reportsum201001.dbf |
4 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_REPORTSUM2011 | +DATA/dcrac/datafile/pos_reportsum201101.dbf |
23 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_REPORTSUM2011 | +DATA/dcrac/datafile/pos_reportsum201102.dbf |
23 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_REPORTSUM2011 | +DATA/dcrac/datafile/pos_reportsum201103.dbf |
23 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_REPORTSUM2011 | +DATA/dcrac/datafile/pos_reportsum201104.dbf |
23 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_REPORTSUM2011 | +DATA/dcrac/datafile/pos_reportsum201105.dbf |
23 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_REPORTSUM2011 | +DATA/dcrac/datafile/pos_reportsum201106.dbf |
23 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_REPORTSUM2011 | +DATA/dcrac/datafile/pos_reportsum201107.dbf |
23 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_REPORTSUM2011 | +DATA/dcrac/datafile/pos_reportsum201108.dbf |
23 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_REPORTSUM2011 | +DATA/dcrac/datafile/pos_reportsum201109.dbf |
23 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_REPORTSUM2011 | +DATA/dcrac/datafile/pos_reportsum201110.dbf |
23 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_REPORTSUM2011 | +DATA/dcrac/datafile/pos_reportsum201111.dbf |
23 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_REPORTSUM2011 | +DATA/dcrac/datafile/pos_reportsum201112.dbf |
23 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_REPORTSUM2011 | +DATA/dcrac/datafile/pos_reportsum201113.dbf |
23 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_REPORTSUM2011 | +DATA/dcrac/datafile/pos_reportsum201114.dbf |
23 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_REPORTSUM2012 | +DATA/dcrac/datafile/pos_reportsum201201.dbf |
24 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_REPORTSUM2012 | +DATA/dcrac/datafile/pos_reportsum201202.dbf |
23 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_REPORTSUM2012 | +DATA/dcrac/datafile/pos_reportsum201203.dbf |
23 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_REPORTSUM2012 | +DATA/dcrac/datafile/pos_reportsum201204.dbf |
23 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_REPORTSUM2012 | +DATA/dcrac/datafile/pos_reportsum201205.dbf |
23 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_REPORTSUM2012 | +DATA/dcrac/datafile/pos_reportsum201206.dbf |
23 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_REPORTSUM2012 | +DATA/dcrac/datafile/pos_reportsum201207.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_REPORTSUM2012 | +DATA/dcrac/datafile/pos_reportsum201208.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_REPORTSUM2012 | +DATA/dcrac/datafile/pos_reportsum201209.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_REPORTSUM2012 | +DATA/dcrac/datafile/pos_reportsum201210.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_REPORTSUM2012 | +DATA/dcrac/datafile/pos_reportsum201211.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_REPORTSUM2012 | +DATA/dcrac/datafile/pos_reportsum201212.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_REPORTSUM2012 | +DATA/dcrac/datafile/pos_reportsum201213.dbf |
23 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_REPORTSUM2012 | +DATA/dcrac/datafile/pos_reportsum201214.dbf |
23 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_REPORTSUM2013 | +DATA/dcrac/datafile/pos_reportsum201301.dbf |
269 | 0 | 0.71 | 1.00 | 32 | 0 | 0 | 0.00 |
| POS_REPORTSUM2013 | +DATA/dcrac/datafile/pos_reportsum201302.dbf |
241 | 0 | 1.45 | 1.00 | 30 | 0 | 0 | 0.00 |
| POS_REPORTSUM2013 | +DATA/dcrac/datafile/pos_reportsum201303.dbf |
246 | 0 | 0.41 | 1.00 | 26 | 0 | 1 | 0.00 |
| POS_REPORTSUM2014 | +DATA/dcrac/datafile/pos_reportsum201401.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_REPORTSUM_IDX | +DATA/dcrac/datafile/pos_reportsum_idx01.dbf |
36 | 0 | 0.83 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_REPORTSUM_IDX | +DATA/dcrac/datafile/pos_reportsum_idx02.dbf |
24 | 0 | 0.42 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_REPORTSUM_IDX | +DATA/dcrac/datafile/pos_reportsum_idx03.dbf |
37 | 0 | 0.81 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_REPORTSUM_IDX | +DATA/dcrac/datafile/pos_reportsum_idx04.dbf |
34 | 0 | 0.88 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_REPORTSUM_IDX | +DATA/dcrac/datafile/pos_reportsum_idx05.dbf |
31 | 0 | 0.65 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_REPORTSUM_IDX | +DATA/dcrac/datafile/pos_reportsum_idx06.dbf |
27 | 0 | 0.37 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_REPORTSUM_IDX | +DATA/dcrac/datafile/pos_reportsum_idx07.dbf |
29 | 0 | 0.34 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_REPORTSUM_IDX | +DATA/dcrac/datafile/pos_reportsum_idx08.dbf |
25 | 0 | 0.40 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_REPORTSUM_IDX | +DATA/dcrac/datafile/pos_reportsum_idx09.dbf |
99 | 0 | 2.63 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_REPORTSUM_IDX | +DATA/dcrac/datafile/pos_reportsum_idx10.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALE1006 | +DATA/dcrac/datafile/pos_sale100601.dbf |
4 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALE1012 | +DATA/dcrac/datafile/pos_sale101201.dbf |
4 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALE1104 | +DATA/dcrac/datafile/pos_sale110401.dbf |
4 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALE1108 | +DATA/dcrac/datafile/pos_sale110801.dbf |
4 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALE1112 | +DATA/dcrac/datafile/pos_sale111201.dbf |
4 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALE1204 | +DATA/dcrac/datafile/pos_sale120401.dbf |
4 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALE1208 | +DATA/dcrac/datafile/pos_sale120801.dbf |
4 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALE1212 | +DATA/dcrac/datafile/pos_sale121201.dbf |
4 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALE13 | +DATA/dcrac/datafile/pos_sale1301.dbf |
4 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALE1304 | +DATA/dcrac/datafile/pos_sale130401.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALE1308 | +DATA/dcrac/datafile/pos_sale130801.dbf |
53 | 0 | 1.13 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALE1312 | +DATA/dcrac/datafile/pos_sale131201.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALE1404 | +DATA/dcrac/datafile/pos_sale140401.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1006 | +DATA/dcrac/datafile/pos_saledetail100601.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1006 | +DATA/dcrac/datafile/pos_saledetail100602.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1012 | +DATA/dcrac/datafile/pos_saledetail101201.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1012 | +DATA/dcrac/datafile/pos_saledetail101202.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1012 | +DATA/dcrac/datafile/pos_saledetail101203.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1104 | +DATA/dcrac/datafile/pos_saledetail110401.dbf |
24 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1104 | +DATA/dcrac/datafile/pos_saledetail110402.dbf |
24 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1108 | +DATA/dcrac/datafile/pos_saledetail110801.dbf |
24 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1108 | +DATA/dcrac/datafile/pos_saledetail110802.dbf |
24 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1108 | +DATA/dcrac/datafile/pos_saledetail110803.dbf |
24 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1112 | +DATA/dcrac/datafile/pos_saledetail111201.dbf |
24 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1112 | +DATA/dcrac/datafile/pos_saledetail111202.dbf |
24 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1112 | +DATA/dcrac/datafile/pos_saledetail111203.dbf |
24 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1203 | +DATA/dcrac/datafile/pos_saledetail120301.dbf |
24 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1203 | +DATA/dcrac/datafile/pos_saledetail120302.dbf |
24 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1206 | +DATA/dcrac/datafile/pos_saledetail120601.dbf |
4 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1209 | +DATA/dcrac/datafile/pos_saledetail120901.dbf |
24 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1209 | +DATA/dcrac/datafile/pos_saledetail120902.dbf |
24 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1212 | +DATA/dcrac/datafile/pos_saledetail121201.dbf |
24 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1212 | +DATA/dcrac/datafile/pos_saledetail121202.dbf |
24 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL13 | +DATA/dcrac/datafile/pos_saledetail1301.dbf |
30 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_SALEDETAIL13 | +DATA/dcrac/datafile/pos_saledetail1302.dbf |
30 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1303 | +DATA/dcrac/datafile/pos_saledetail130301.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1303 | +DATA/dcrac/datafile/pos_saledetail130302.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1306 | +DATA/dcrac/datafile/pos_saledetail130601.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1309 | +DATA/dcrac/datafile/pos_saledetail130901.dbf |
45 | 0 | 1.11 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1312 | +DATA/dcrac/datafile/pos_saledetail131201.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL1403 | +DATA/dcrac/datafile/pos_saledetail140301.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL_IND | +DATA/dcrac/datafile/pos_saledetail_ind01.dbf |
30 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_SALEDETAIL_IND | +DATA/dcrac/datafile/pos_saledetail_ind02.dbf |
30 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_SALEDETAIL_IND | +DATA/dcrac/datafile/pos_saledetail_ind03.dbf |
30 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_SALEDETAIL_IND | +DATA/dcrac/datafile/pos_saledetail_ind04.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALEDETAIL_IND | +DATA/dcrac/datafile/pos_saledetail_ind05.dbf |
26 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_SALESUMSIMPLE10 | +DATA/dcrac/datafile/pos_salesumsimple1001.dbf |
2,860 | 0 | 3.89 | 1.01 | 5 | 0 | 0 | 0.00 |
| POS_SALESUMSIMPLE1103 | +DATA/dcrac/datafile/pos_salesumsimple110301.dbf |
7,711 | 1 | 2.80 | 1.00 | 5 | 0 | 0 | 0.00 |
| POS_SALESUMSIMPLE1106 | +DATA/dcrac/datafile/pos_salesumsimple110601.dbf |
9,155 | 1 | 2.79 | 1.00 | 5 | 0 | 0 | 0.00 |
| POS_SALESUMSIMPLE1109 | +DATA/dcrac/datafile/pos_salesumsimple110901.dbf |
7,391 | 1 | 2.61 | 1.00 | 5 | 0 | 0 | 0.00 |
| POS_SALESUMSIMPLE1112 | +DATA/dcrac/datafile/pos_salesumsimple111201.dbf |
5,532 | 1 | 2.17 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALESUMSIMPLE1203 | +DATA/dcrac/datafile/pos_salesumsimple120301.dbf |
7 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_SALESUMSIMPLE1206 | +DATA/dcrac/datafile/pos_salesumsimple120601.dbf |
7 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_SALESUMSIMPLE1209 | +DATA/dcrac/datafile/pos_salesumsimple120901.dbf |
7 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_SALESUMSIMPLE1212 | +DATA/dcrac/datafile/pos_salesumsimple121201.dbf |
7 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_SALESUMSIMPLE13 | +DATA/dcrac/datafile/pos_salesumsimple1301.dbf |
7 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_SALESUMSIMPLE1303 | +DATA/dcrac/datafile/pos_salesumsimple130301.dbf |
75 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALESUMSIMPLE1306 | +DATA/dcrac/datafile/pos_salesumsimple130601.dbf |
21 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_SALESUMSIMPLE1309 | +DATA/dcrac/datafile/pos_salesumsimple130901.dbf |
21 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_SALESUMSIMPLE1312 | +DATA/dcrac/datafile/pos_salesumsimple131201.dbf |
25 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SALESUMSIMPLE1403 | +DATA/dcrac/datafile/pos_salesumsimple140301.dbf |
25 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_SBALSUMSIMPLEALL10 | +DATA/dcrac/datafile/pos_sbalsumsimpleall1001.dbf |
7 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_SBALSUMSIMPLEALL11 | +DATA/dcrac/datafile/pos_sbalsumsimpleall1101.dbf |
7 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_SBALSUMSIMPLEALL12 | +DATA/dcrac/datafile/pos_sbalsumsimpleall1201.dbf |
7 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STKSCASED11 | +DATA/dcrac/datafile/pos_stkscased1101.dbf |
7 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STKSCASED13 | +DATA/dcrac/datafile/pos_stkscased1301.dbf |
30 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_STKSCASED13 | +DATA/dcrac/datafile/pos_stkscased1302.dbf |
27 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_STKSCASED15 | +DATA/dcrac/datafile/pos_stkscased1501.dbf |
7 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STKSCASED17 | +DATA/dcrac/datafile/pos_stkscased1701.dbf |
7 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STKSCASED19 | +DATA/dcrac/datafile/pos_stkscased1901.dbf |
7 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STKSCASED21 | +DATA/dcrac/datafile/pos_stkscased2101.dbf |
7 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STKSCASED23 | +DATA/dcrac/datafile/pos_stkscased2301.dbf |
26 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STKSCASED25 | +DATA/dcrac/datafile/pos_stkscased2501.dbf |
26 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STKSCASED27 | +DATA/dcrac/datafile/pos_stkscased2701.dbf |
26 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STKSCASED29 | +DATA/dcrac/datafile/pos_stkscased2901.dbf |
26 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STKSCASED31 | +DATA/dcrac/datafile/pos_stkscased3101.dbf |
26 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STOCKINSUMSIMPLE10 | +DATA/dcrac/datafile/pos_stockinsumsimple1001.dbf |
7 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STOCKINSUMSIMPLE1106 | +DATA/dcrac/datafile/pos_stockinsumsimple110601.dbf |
7 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STOCKINSUMSIMPLE1112 | +DATA/dcrac/datafile/pos_stockinsumsimple111201.dbf |
7 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STOCKINSUMSIMPLE1206 | +DATA/dcrac/datafile/pos_stockinsumsimple120601.dbf |
7 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STOCKINSUMSIMPLE1212 | +DATA/dcrac/datafile/pos_stockinsumsimple121201.dbf |
7 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STOCKINSUMSIMPLE13 | +DATA/dcrac/datafile/pos_stockinsumsimple1301.dbf |
7 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STOCKOUTSUMSIMPLE10 | +DATA/dcrac/datafile/pos_stockoutsumsimple1001.dbf |
10 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STOCKOUTSUMSIMPLE1106 | +DATA/dcrac/datafile/pos_stockoutsumsimple110601.dbf |
10 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STOCKOUTSUMSIMPLE1112 | +DATA/dcrac/datafile/pos_stockoutsumsimple111201.dbf |
10 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STOCKOUTSUMSIMPLE1206 | +DATA/dcrac/datafile/pos_stockoutsumsimple120601.dbf |
10 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STOCKOUTSUMSIMPLE1212 | +DATA/dcrac/datafile/pos_stockoutsumsimple121201.dbf |
10 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STOCKOUTSUMSIMPLE13 | +DATA/dcrac/datafile/pos_stockoutsumsimple1301.dbf |
10 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STOCKSUMSIMPLE10 | +DATA/dcrac/datafile/pos_stocksumsimple1001.dbf |
10 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STOCKSUMSIMPLE1104 | +DATA/dcrac/datafile/pos_stocksumsimple110401.dbf |
10 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STOCKSUMSIMPLE1108 | +DATA/dcrac/datafile/pos_stocksumsimple110801.dbf |
10 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STOCKSUMSIMPLE1112 | +DATA/dcrac/datafile/pos_stocksumsimple111201.dbf |
10 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STOCKSUMSIMPLE1204 | +DATA/dcrac/datafile/pos_stocksumsimple120401.dbf |
10 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STOCKSUMSIMPLE1208 | +DATA/dcrac/datafile/pos_stocksumsimple120801.dbf |
10 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STOCKSUMSIMPLE1212 | +DATA/dcrac/datafile/pos_stocksumsimple121201.dbf |
10 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_STOCKSUMSIMPLE13 | +DATA/dcrac/datafile/pos_stocksumsimple1301.dbf |
10 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_SUM | +DATA/dcrac/datafile/pos_sum01.dbf |
27 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_SUM | +DATA/dcrac/datafile/pos_sum02.dbf |
27 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| POS_SUM_IDX | +DATA/dcrac/datafile/pos_sum_idx01.dbf |
27 | 0 | 0.00 | 1.00 | 6 | 0 | 116 | 340.95 |
| POS_SUM_IDX | +DATA/dcrac/datafile/pos_sum_idx02.dbf |
130 | 0 | 0.54 | 1.00 | 6 | 0 | 5 | 0.00 |
| POS_SUM_IDX | +DATA/dcrac/datafile/pos_sum_idx03.dbf |
520 | 0 | 0.29 | 1.00 | 6 | 0 | 73 | 296.58 |
| POS_SUM_IDX | +DATA/dcrac/datafile/pos_sum_idx04.dbf |
27 | 0 | 0.00 | 1.00 | 6 | 0 | 418 | 482.15 |
| POS_SUM_IDX | +DATA/dcrac/datafile/pos_sum_idx05.dbf |
28 | 0 | 0.00 | 1.00 | 6 | 0 | 106 | 0.38 |
| POS_SUM_IDX | +DATA/dcrac/datafile/pos_sum_idx06.dbf |
25 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_TRAN | +DATA/dcrac/datafile/pos_tran01.dbf |
1,502 | 0 | 0.34 | 1.00 | 202 | 0 | 31 | 0.97 |
| POS_TRAN | +DATA/dcrac/datafile/pos_tran02.dbf |
1,352 | 0 | 0.36 | 1.00 | 198 | 0 | 16 | 0.63 |
| POS_TRAN | +DATA/dcrac/datafile/pos_tran03.dbf |
1,610 | 0 | 0.37 | 1.01 | 267 | 0 | 16 | 0.63 |
| POS_TRAN | +DATA/dcrac/datafile/pos_tran04.dbf |
1,439 | 0 | 0.47 | 1.00 | 151 | 0 | 62 | 556.29 |
| POS_TRAN | +DATA/dcrac/datafile/pos_tran05.dbf |
2,064 | 0 | 0.65 | 1.00 | 210 | 0 | 37 | 0.54 |
| POS_TRAN | +DATA/dcrac/datafile/pos_tran06.dbf |
1,922 | 0 | 0.76 | 1.00 | 376 | 0 | 37 | 0.27 |
| POS_TRAN | +DATA/dcrac/datafile/pos_tran07.dbf |
1,837 | 0 | 0.80 | 1.00 | 245 | 0 | 40 | 1.75 |
| POS_TRAN | +DATA/dcrac/datafile/pos_tran08.dbf |
1,766 | 0 | 0.62 | 1.01 | 181 | 0 | 57 | 560.35 |
| POS_TRAN_IDX | +DATA/dcrac/datafile/pos_tran_idx01.dbf |
87 | 0 | 1.15 | 1.01 | 28 | 0 | 7 | 0.00 |
| POS_TRAN_IDX | +DATA/dcrac/datafile/pos_tran_idx02.dbf |
49 | 0 | 0.41 | 1.02 | 9 | 0 | 0 | 0.00 |
| POS_TRAN_IDX | +DATA/dcrac/datafile/pos_tran_idx03.dbf |
75 | 0 | 0.27 | 1.04 | 11 | 0 | 308 | 0.03 |
| POS_TRAN_IDX | +DATA/dcrac/datafile/pos_tran_idx04.dbf |
127 | 0 | 1.65 | 1.06 | 12 | 0 | 0 | 0.00 |
| POS_TRAN_IDX | +DATA/dcrac/datafile/pos_tran_idx05.dbf |
27 | 0 | 0.37 | 1.00 | 12 | 0 | 0 | 0.00 |
| POS_TRAN_IDX | +DATA/dcrac/datafile/pos_tran_idx06.dbf |
29 | 0 | 0.34 | 1.00 | 40 | 0 | 1 | 10.00 |
| POS_TRAN_IDX | +DATA/dcrac/datafile/pos_tran_idx07.dbf |
77 | 0 | 0.39 | 1.03 | 33 | 0 | 1 | 0.00 |
| POS_TRAN_IDX | +DATA/dcrac/datafile/pos_tran_idx08.dbf |
44 | 0 | 0.45 | 1.00 | 39 | 0 | 27 | 921.11 |
| POS_TRAN_IDX | +DATA/dcrac/datafile/pos_tran_idx09.dbf |
39 | 0 | 1.79 | 1.00 | 62 | 0 | 1 | 0.00 |
| POS_TRAN_IDX | +DATA/dcrac/datafile/pos_tran_idx10.dbf |
69 | 0 | 1.74 | 1.00 | 108 | 0 | 8 | 2.50 |
| POS_TRAN_IDX | +DATA/dcrac/datafile/pos_tran_idx11.dbf |
25 | 0 | 0.40 | 1.04 | 16 | 0 | 0 | 0.00 |
| POS_VIP | +DATA/dcrac/datafile/pos_vip01.dbf |
88 | 0 | 3.64 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_YSSTKSBAL11 | +DATA/dcrac/datafile/pos_ysstksbal1101.dbf |
10 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_YSSTKSBAL1204 | +DATA/dcrac/datafile/pos_ysstksbal120401.dbf |
26 | 0 | 0.00 | 1.00 | 28 | 0 | 0 | 0.00 |
| POS_YSSTKSBAL1204 | +DATA/dcrac/datafile/pos_ysstksbal120402.dbf |
26 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_YSSTKSBAL1208 | +DATA/dcrac/datafile/pos_ysstksbal120801.dbf |
415 | 0 | 0.41 | 1.00 | 32 | 0 | 0 | 0.00 |
| POS_YSSTKSBAL1208 | +DATA/dcrac/datafile/pos_ysstksbal120802.dbf |
190 | 0 | 0.42 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_YSSTKSBAL1212 | +DATA/dcrac/datafile/pos_ysstksbal121201.dbf |
410 | 0 | 0.37 | 1.00 | 31 | 0 | 0 | 0.00 |
| POS_YSSTKSBAL1212 | +DATA/dcrac/datafile/pos_ysstksbal121202.dbf |
37 | 0 | 0.54 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_YSSTKSBAL13 | +DATA/dcrac/datafile/pos_ysstksbal1301.dbf |
26 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_YSSTKSBAL13 | +DATA/dcrac/datafile/pos_ysstksbal1302.dbf |
26 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_YSSTKSCASED11 | +DATA/dcrac/datafile/pos_ysstkscased1101.dbf |
10 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_YSSTKSCASED1204 | +DATA/dcrac/datafile/pos_ysstkscased120401.dbf |
30 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_YSSTKSCASED1204 | +DATA/dcrac/datafile/pos_ysstkscased120402.dbf |
30 | 0 | 0.00 | 1.00 | 35 | 0 | 0 | 0.00 |
| POS_YSSTKSCASED1208 | +DATA/dcrac/datafile/pos_ysstkscased120801.dbf |
30 | 0 | 0.00 | 1.00 | 18 | 0 | 0 | 0.00 |
| POS_YSSTKSCASED1208 | +DATA/dcrac/datafile/pos_ysstkscased120802.dbf |
30 | 0 | 0.00 | 1.00 | 16 | 0 | 0 | 0.00 |
| POS_YSSTKSCASED1212 | +DATA/dcrac/datafile/pos_ysstkscased121201.dbf |
30 | 0 | 0.00 | 1.00 | 12 | 0 | 0 | 0.00 |
| POS_YSSTKSCASED1212 | +DATA/dcrac/datafile/pos_ysstkscased121202.dbf |
30 | 0 | 0.00 | 1.00 | 28 | 0 | 0 | 0.00 |
| POS_YSSTKSCASED13 | +DATA/dcrac/datafile/pos_ysstkscased1301.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_YSSTKSCASED13 | +DATA/dcrac/datafile/pos_ysstkscased1302.dbf |
27 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| POS_YSSTKSCASED1304 | +DATA/dcrac/datafile/pos_ysstkscased130401.dbf |
21 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_YSSTKSCASED1304 | +DATA/dcrac/datafile/pos_ysstkscased130402.dbf |
21 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_YSSTKSCASED1308 | +DATA/dcrac/datafile/pos_ysstkscased130801.dbf |
21 | 0 | 0.00 | 1.00 | 22 | 0 | 0 | 0.00 |
| POS_YSSTKSCASED1312 | +DATA/dcrac/datafile/pos_ysstkscased131201.dbf |
21 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| POS_YSSTKSCASED1404 | +DATA/dcrac/datafile/pos_ysstkscased140401.dbf |
21 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| SYSAUX | +DATA/dcrac/datafile/sysaux.271.809049455 |
546 | 0 | 0.84 | 1.00 | 2,548 | 0 | 0 | 0.00 |
| SYSTEM | +DATA/dcrac/datafile/system.270.809049451 |
221 | 0 | 0.50 | 1.00 | 286 | 0 | 20 | 0.50 |
| TEMP | +DATA/dcrac/tempfile/temp.273.809049457 |
1,579 | 0 | 0.12 | 1.07 | 9,471 | 1 | 0 | |
| TEMP | +DATA/dcrac/tempfile/temp05.dbf |
4 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | |
| UNDOTBS1 | +DATA/dcrac/datafile/undotbs1.272.809049457 |
4 | 0 | 0.00 | 1.00 | 4 | 0 | 1 | 0.00 |
| UNDOTBS2 | +DATA/dcrac/datafile/undotbs2.274.809049463 |
23 | 0 | 1.30 | 1.00 | 899 | 0 | 5 | 0.00 |
| USERS | +DATA/dcrac/datafile/users.275.809049463 |
4 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| YS_STKSBAL1304 | +DATA/dcrac/datafile/pos_ysstksbal130401.dbf |
160 | 0 | 0.25 | 1.00 | 31 | 0 | 0 | 0.00 |
| YS_STKSBAL1304 | +DATA/dcrac/datafile/pos_ysstksbal130402.dbf |
104 | 0 | 0.48 | 1.00 | 4 | 0 | 0 | 0.00 |
| YS_STKSBAL1308 | +DATA/dcrac/datafile/pos_ysstksbal130801.dbf |
113 | 0 | 0.80 | 1.00 | 3 | 0 | 1,215 | 0.35 |
| YS_STKSBAL1312 | +DATA/dcrac/datafile/pos_ysstksbal131201.dbf |
21 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| YS_STKSBAL1404 | +DATA/dcrac/datafile/pos_ysstksbal140401.dbf |
21 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |