| SQL Id | SQL Text |
|---|
| 01264nv3gt9gw | BEGIN PKG_FINANCE.PRC_comebackbyaaz083(:1 , :2 , :3 , :4 , :5 ); END; |
| 05q7my8f09wsk | SELECT a.bz as aae013, b.aac003 as aac003, b.aac002 as aac002, a.aic160 as aic160, a.aac001 as aac001, a.aae016 as aae016, a.aic162 as aic162, (select count(distinct aae003) from ac43 where aac001 = a.aac001) as aae003, (select sum(aae022) from ac43 where aac001 = a.aac001 and aae341='1') as aae022, (select aac003 from ad53a4 where yae092=a.aae011) as aae011, (select aac003 from ad53a4 where yae092=a.aae014) as aae014, sum(case when AAA036 in ('150011', '150031', '150041', '150021') then aae129 else 0 end) as AAE019 , SUM(DECODE( f.AAA036, '150012', AAE129, 0)) AAE020, a.aae036 as aae036, a.aae015 as aae015 FROM ac71 a, ac01 b, af02 c, af08 d, ac73 f WHERE 1 = 1 and a.aac001 = b.aac001 and a.aaz170 = f.aaz170 AND c.aaz070=b.aaz070 AND a.aaa076='15' and c.aaf015=d.aaf013 and a.aaa027 like substr(f_getqx(:1 ), 1, 6) group by a.bz, b.aac003, b.aac002, a.aic160, a.aac001, a.aae016, a.aic162, aae011, aae014, a.aae036, a.aae015 |
| 06bs1zz3508a7 | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PKG_YHCIP.PRC_TREATMENTPAYPLAN_1('201406' , '1000004807', '20140623', '510921'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 0jd05u27h1cav | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PKG_MON_COLLECTPLAN.PROC_MON_COLLECT('201406', '511028', '1000003734', '16', '60', '201101', '201406', '20', '53791'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 0k69508jwymdc | SELECT C.* FROM AC40 A, AC41 B, AC42 C WHERE A.AAZ192 = B.AAZ192 AND B.AAZ204 = C.AAZ204 AND A.AAE016 = '1' AND C.AAB033 = '1' AND C.AAE140 IN ('150') AND C.AAA027 LIKE :B1 || '%' AND EXISTS(SELECT 1 FROM AC02 WHERE AAC001 = A.AAC001 AND AAC008 = '1') AND (EXISTS (SELECT 1 FROM AC20 WHERE AC20.AAC031 IN ('1', '2') AND AC20.AAC001 = A.AAC001) OR EXISTS (SELECT 1 FROM YH00_BCRZB WHERE C.AAZ204 = YH00_BCRZB.AAZ204 AND NVL(YH00_BCRZB.DZBZ, '0') = '0')) AND NOT EXISTS (SELECT 1 FROM AC43 D WHERE D.AAZ223 = C.AAZ223) AND NOT EXISTS (SELECT 1 FROM AC27 WHERE AC27.AAC001=A.AAC001 AND AC27.AAE016='0') |
| 0m2fkap14ubf5 | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PKG_MON_COLLECTPLAN.PROC_MON_COLLECT('201406', '510903', '1000014490', '16', '60', '0', '999999', '20', '53770'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 0nkybc406gnt1 | DELETE FROM AC43 WHERE AAC001 = :B1 AND AAE003 IN ( SELECT AAE003 FROM AC43 WHERE AAC001 = :B1 AND AAZ083 = :B2 AND AAE341 = '1' AND AAE078 = '0' AND AAE017 = '0' ) AND AAE341 IN ('1', '2', '3', '4', '5', '7', '8', '9', '10', '21', '20') AND AAZ083 NOT IN (SELECT AAZ083_CZBZ FROM YH00_BCRZB WHERE AAZ083_GRJF = :B2 ) AND AAZ083 NOT IN (SELECT AAZ083_CZDJ FROM YH00_BCRZB WHERE AAZ083_GRJF = :B2 ) AND AAE078 <> '1' |
| 1aapbkrs2hnpk | BEGIN PKG_SCTJBB.report_1_any_new(:1 , :2 , :3 , :4 , :5 , :6 ); END; |
| 1c1jyxz8quk4k |
SELECT a.aaz070 as aaz070, f_iy02(c.aac002) as czsfcb, a.aac001 as aac001, f_sfbdqs(a.aac001) as sfbdqs , b.aae140 as aae140, a.aae016 as aae016_2, a.aae013 as aae013, b.aaz165 as aaz165, b.aaz158 as aaz158, c.aac003 as aac003, c.aac002 as aac002, c.aac010 as aac010, c.aac004 as aac004, d.aab069 as aab069_5, g.aaf031 as aaf031, (SELECT aab069 FROM AE03 , ae10 WHERE AAZ003 = (SELECT MAX(AAZ003) FROM AE03 WHERE AAZ010 = C.AAC001) AND ae03.aaz065 = ae10.aaz001) AS AAZ065 , (SELECT aae010 FROM AE03, ae10 WHERE AAZ003 = (SELECT MAX(AAZ003) FROM AE03 WHERE AAZ010 =C.AAC001) AND ae03.aaz065 = ae10.aaz001) AS aae010, b.aae030 as aae030, c.aac005 as aac005, c.aae005 as aae005, c.aae006 as aae006, c.aae007 as aae007, c.aac009 as aac009, c.aac010 as aac010, c.yh_dabh as yh_dabh, nvl(c.aac118, 0) as aac118, nvl(c.aac117, 0) as aac117, nvl(c.ync301, 0) as ync301, nvl(c.ync311, 0) as ync311, to_char(c.ync303) ||'-'|| to_char(c.ync304) as ync301_kj, to_char(c.ync305) ||'-'|| to_char(c.ync306) as aac117_kj, to_char(c.ync307) ||'-'|| to_char(c.ync308) as ync311_kj, to_char(c.aac006) as aac0
06, to_char(b.aaz289) as aaz289, f.aaa044 as aaa044, (SELECT aaa041 FROM aa28 WHERE aaz289=to_char(b.aaz289) AND aae341='1') as aaz289grjf, b.aab033 as aab033, b.ync309 as ync309, to_char(b.aac049) as aac049, Fun_GetCbSfStr_pzh(a.aac001, b.aae140, :1 ) as aac066, b.aae200 as aae200 , (select aac003 from ad53a4 where yae092 = a.aae011) as aae011, (select aac003 from ad53a4 where yae092 = a.aae014) as aae014, to_char(aae036, 'yyyymmdd') as aae036, to_char(aae015, 'yyyymmdd') as aae015, c.yh_group as yh_group FROM ac21 a, ac22 b, ac01 c, ae10 d, af02 e, aa05 f, af08 g WHERE a.aac001 = c.aac001 AND b.aaz289 = f.aaz289 AND a.aac001 = b.aac001 AND c.aaz070 = d.aaz001 AND b.aae140 = '150' AND a.aac001 = b.aac001 and e.aaf015=g.aaf013 AND a.aae016 = :2 and a.aaz158 = b.aaz158 and c.aaz070 = e.aaz070 AND e.aaf030 like f_getqx(:3 ) AND c.yh_dabz=:4 |
| 1hu0mhadtdu2d |
SELECT round((select to_char(ac50.aae240 * ac60.aic167) from ac60, ac50 where ac60.aac001 = ac50.aac001 and ac60.aac001 = a.aac001 ), 2) as zzje, round((select to_char(ac50.aae240 * (1-ac60.aic167)) from ac60, ac50 where ac60.aac001 = ac50.aac001 and ac60.aac001 = a.aac001 ), 2) as zzbt, f_getwfylj(b.aac001, a.aae016) as ybkfylj, a.aac001 AS aac001, a.aac002 AS aac002, a.aae160 AS aae160, a.aae041 AS aae041, a.aae013 AS aae013, a.aae145 AS aae145, (select aab069 from ae10 where ae10.aaz001 = a.aae006) AS aae006, a.aae007 AS aae007, a.aae010 as aae010, a.aae008 AS aae008, a.aaa027 AS aaa027, a.aae016 AS aae016, (SELECT aac003 FROM ad53a4 WHERE yae092 = a.aae011) as aae011, to_char(a.aae228, 'yyyymmdd') as aae036, (SELECT ad53a4.aac003 FROM ac95 , ad53a4 WHERE ac95.aac001 = a.aac001 AND ac95.aae014 = ad53a4.yae092 and ac95.rowid = (select max(rowid) from ac95 where ac95.aac001 = a.aac001) ) as aae014, (select to_char(max(aae015), 'yyyymmdd') from ac95 where aac001 = a.aac001) as aae015, b.aac006 as aac006, b.aac004 as aac004, b.aac003 as aac003, c.aa
e030 as aae030 , (SELECT zhje FROM yh03_zzlog WHERE ROWID = (SELECT MAX(ROWID) FROM yh03_zzlog WHERE aac001 = b.aac001)) as zhje FROM ac95_check a , (select * from ac01 where aab301 like substr(f_getqx(:1 ), 1, 6)) b , ac20 c , af02 d, af08 e WHERE 1=1 and a.aac001=b.aac001 and b.aac001=c.aac001 and d.aaf015=e.aaf013 and d.aaz070 = b.aaz070 and a.aaa027 like substr(f_getqx(:2 ), 1, 6) |
| 1k9ur0m1trhtz | SELECT COUNT(DISTINCT B.AAC001) FROM AC84 A, (SELECT AAC001 FROM AC75 WHERE AAA027 = :B1 AND AAE016 = '1' AND AAZ166 IN (SELECT AAZ166 FROM AC76 WHERE AAE002 = :B2 )) B WHERE A.AAZ010 = B.AAC001 AND A.AAE117 = '3' AND NOT EXISTS (SELECT 1 FROM AC60 WHERE AAC001 = B.AAC001 AND AAE116 = '3') |
| 1kgtxv9k4mhfv |
select ''''||a.aac001||'''' ||', '''||a.aac003||'''' ||', '''||(select aaa103 from aa10 where aaa100='AAC004' and aaa102=a.aac004 and rownum=1) ||'''' ||', '''||a.aac002||'''' ||', '''||b.aab069||'''' as outstring from ac01 a, ae10 b, af02 c where to_char(a.aac001) = :1 and c.aaf015 like f_getqx(:2 ) and a.aaz070 = b.aaz001 and a.aaz070 = c.aaz070 union select ''''||a.aac001||'''' ||', '''||a.aac003||'''' ||', '''||(select aaa103 from aa10 where aaa100='AAC004' and aaa102=a.aac004 and rownum=1) ||'''' ||', '''||a.aac002||'''' ||', '''||b.aab069||'''' as outstring from ac01 a, ae10 b, af02 c where ( a.aac002 = :3 ) and c.aaf015 like f_getqx(:4 ) and a.aaz070 = b.aaz001 and a.aaz070 = c.aaz070 union select ''''||a.aac001||'''' ||', '''||a.aac003||'''' ||', '''||(select aaa103 from aa10 where aaa100='AAC004' and aaa102=a.aac004 and rownum=1) ||'''' ||', '''||a.aac002||'''' ||', '''||b.aab069||'''' as outstring from ac01 a, ae10 b, af02 c where ( a.aac003 = :5 ) and c.aaf015 like f_getqx(:6 ) and a.aaz070 = b.aaz001 and a.aaz070 = c.aaz070
union select ''''||a.aac001||'''' ||', '''||a.aac003||'''' ||', '''||(select aaa103 from aa10 where aaa100='AAC004' and aaa102=a.aac004 and rownum=1) ||'''' ||', '''||a.aac002||'''' ||', '''||b.aab069||'''' as outstring from ac01 a, ae10 b, af02 c where ( a.yh_dabh = :7 ) and c.aaf015 like f_getqx(:8 ) and a.aaz070 = b.aaz001 and a.aaz070 = c.aaz070 and rownum <100 |
| 26t6hdsh2qj2f | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PKG_MON_COLLECTPLAN.PROC_MON_COLLECT('201406', '510322', '1000006585', '16', '60', '200912', '201406', '20', '53810'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 26vzppw0zcxz5 | SELECT AC01.AAC001, AC01.AAC002, AC01.AAC003, AE10.AAB069, AF08.AAF031, AA10.AAA103, ac01.yh_group, AC01.AAC010 FROM AC01, AE10, AF08, AA10, AC20, AF02, ac21 WHERE AC01.AAC001 = AC20.AAC001 AND AE10.AAZ001 = AC01.AAZ070 and ac01.aac001 = ac21.aac001 AND AA10.AAA100 = 'AAB033' AND AF02.AAZ070 = AC01.AAZ070 AND AF02.AAF015 = AF08.AAF013 AND AC20.AAB033 = AA10.AAA102 and ac20.aac031 = '1' AND ac01.aab301 = :1 AND AC20.AAB033=:2 AND to_char(ac21.aae015, 'yyyymmdd') <= :3 order by AF08.AAF031 |
| 2fxtsdj69r6y3 |
SELECT /*+rule+*/ c.aaz288 as aaz288, c.aae002 as aae002, c.aab033 as aab033, c.aae142 as aae142, c.aaa121 as aaa121, c.aae221 as aae221, c.aae281 as aae281, d.aac003 as zsdxmc, c.aaz295 as aaz295 FROM ae23 a, ae25 b, ad21 c, ac01 d WHERE a.aaz083 = b.aaz083 AND c.aaz288 = b.aaz288 AND a.aaz010 = d.aac001 AND a.aae078 = '0' AND NVL(a.aae079, '0') = '0' AND c.aae142 = '5' AND c.aae281 is null AND c.aab033 = :1 AND c.aaa027 = :2 AND d.aac002 = :3 UNION SELECT /*+rule+*/ c.aaz288 as aaz288, c.aae002 as aae002, c.aab033 as aab033, c.aae142 as aae142, c.aaa121 as aaa121, c.aae221 as aae221, c.aae281 as aae281, d.aab069 as zsdxmc, c.aaz295 as aaz295 FROM ae23 a, ae25 b, ad21 c, ae10 d WHERE a.aaz083 = b.aaz083 AND c.aaz288 = b.aaz288 AND a.aaz010 = d.aaz001 AND a.aae078 = '0' AND NVL(a.aae079, '0') = '0' AND c.aae142 = '4' AND c.aae281 is null AND c.aab033 = :4 AND c.aaa027 = :5 AND 1 = 2 UNION SELECT /*+rule+*/ c.aaz288 as aaz288, c.aae002 as aae002, c.aab033 as aab033, c.aae142 as aae142, c.aaa121 as aaa121, c.aae221 as aae221, c.aae281 as aae281,
d.AAB069 as zsdxmc, c.aaz295 as aaz295 FROM ad21 c, ae23 a, ae25 b, ae10 d WHERE c.aae142 in ('1', '2', '5') AND c.aab033 = :6 AND a.aae078 = '0' AND NVL(a.aae079, '0') = '0' AND a.aaz083 = b.aaz083 AND c.aaz288 = b.aaz288 AND c.aaz295 = d.aaz001 AND c.aae281 is null AND c.aaa027 = :7 AND 1 = 2 UNION SELECT /*+rule+*/ a.aaz288 as aaz288, a.aae002 as aae002, a.aab033 as aab033, a.aae142 as aae142, a.aaa121 as aaa121, a.aae221 as aae221, a.aae281 as aae281, d.aab069 as zsdxmc, a.aaz295 as aaz295 FROM ad21 a, ae10 d WHERE a.aae142 in ('6', '7', '8', '9', '10', '15') AND a.aab033 = :8 AND a.aaz295 = d.aaz001 AND a.aae281 is null AND 1 = 2 AND a.aaa027 = :9 |
| 2jfqzrxhrm93b | select /*+ rule */ c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user# |
| 2ra93n07ajuk2 | SELECT * FROM ( select a.aab301 as aab301, a.aac001 as aac001, a.aac002 as aac002, a.aac003 as aac003, e.aae002 as aae002, c.aaf031 AS aaf031, (SELECT aab069 FROM ae10 WHERE aaz001 = a.aaz070) AS aab069, a.yh_group AS z, a.aac010 AS aac010, a.aae006 as aae006, d.aae117 AS aae117, (SELECT SUM(aae019) FROM ac83 WHERE aaz220 = d.aaz220) AS aae019 from ac01 a, af02 b, af08 c, ac84 d, ad34 e where a.aac001 = d.aaz010 AND e.aaa027 = :1 AND a.aab301 = e.aaa027 AND e.aae002 = :2 AND a.aaz070 = b.aaz070 AND b.aaf015 = c.aaf013 AND e.aaz031 = d.aaz031 AND b.aaf030 LIKE f_getqx(:3 ) AND c.aaf013 = :4 ) WHERE 1= 1 AND aae117 = :5 |
| 2rg9b617bdvkm |
SELECT /*+rule+*/ c.aaz288 as aaz288, c.aae002 as aae002, c.aab033 as aab033, c.aae142 as aae142, c.aaa121 as aaa121, c.aae221 as aae221, c.aae281 as aae281, d.aac003 as zsdxmc, c.aaz295 as aaz295 FROM ae23 a, ae25 b, ad21 c, ac01 d WHERE a.aaz083 = b.aaz083 AND c.aaz288 = b.aaz288 AND a.aaz010 = d.aac001 AND a.aae078 = '0' AND NVL(a.aae079, '0') = '0' AND c.aae142 = '5' AND c.aae281 is not null AND c.aab033 = :1 AND c.aaa027 = :2 AND c.aaz295 = :3 UNION SELECT /*+rule+*/ c.aaz288 as aaz288, c.aae002 as aae002, c.aab033 as aab033, c.aae142 as aae142, c.aaa121 as aaa121, c.aae221 as aae221, c.aae281 as aae281, d.aab069 as zsdxmc, c.aaz295 as aaz295 FROM ae23 a, ae25 b, ad21 c, ae10 d WHERE a.aaz083 = b.aaz083 AND c.aaz288 = b.aaz288 AND a.aaz010 = d.aaz001 AND a.aae078 = '0' AND NVL(a.aae079, '0') = '0' AND c.aae142 = '4' AND c.aae281 is not null AND c.aab033 = :4 AND c.aaa027 = :5 AND c.aaz295 = :6 UNION SELECT /*+rule+*/ c.aaz288 as aaz288, c.aae002 as aae002, c.aab033 as aab033, c.aae142 as aae142, c.aaa121 as aaa121, c.aae221 as aae221, c.aae281 as a
ae281, d.AAB069 as zsdxmc, c.aaz295 as aaz295 FROM ad21 c, ae23 a, ae25 b, ae10 d WHERE c.aae142 in ('1', '2', '5') AND c.aab033 = :7 AND a.aae078 = '0' AND NVL(a.aae079, '0') = '0' AND a.aaz083 = b.aaz083 AND c.aaz288 = b.aaz288 AND c.aaz295 = d.aaz001 AND c.aae281 is not null AND c.aaa027 = :8 AND c.aaz295 = :9 UNION SELECT /*+rule+*/ a.aaz288 as aaz288, a.aae002 as aae002, a.aab033 as aab033, a.aae142 as aae142, a.aaa121 as aaa121, a.aae221 as aae221, a.aae281 as aae281, d.aab069 as zsdxmc, a.aaz295 as aaz295 FROM ad21 a, ae10 d WHERE a.aae142 in ('6', '7', '8', '9', '10', '15') AND a.aab033 = :10 AND a.aaz295 = d.aaz001 AND a.aae281 is not null AND a.aaz295 = :11 AND a.aaa027 = :12 |
| 2ym6hhaq30r73 | select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3 |
| 31a06rpq4506f | INSERT INTO SCGY.YLHL_AA10@TEST_GY (ID , BATCHNO , BATCHDSC , BANKCODE , BANKNAME , BANKCARDCODE , BXBANKNAME , BXBANKCARDCODE , THIRDCODE , PERCODE , PERNAME , PERCARD , BILLCODE , SHOULDSHOUMONEY , RESULTFLAG , FAILCODE , XIANZHONG , AAB034 , YWDJH , AAE002 ) SELECT D.AAZ083||A.AAC001, 'X', :B7 , :B6 , :B5 , F.AAE010, :B4 , :B3 , '0', A.AAC001, A.AAC003, A.AAC002, D.AAZ083||A.AAC001, SUM(C.AAE022), '1', '00', '140', :B2 , D.AAZ083, E.AAE002 FROM AC01 A, AC20 B, AC43 C, AE25 D, AD21 E, AE03 F WHERE A.AAC001=B.AAC001 AND B.AAC001=C.AAC001 AND E.AAZ288= :B1 AND D.AAZ288= :B1 AND D.AAZ083= C.AAZ083 AND B.AAZ003= F.AAZ003 AND C.AAE341 = '1' AND C.AAE078 = '0' AND C.AAE022 > 0 AND C.AAB033 = '1' GROUP BY D.AAZ083||A.AAC001 , F.AAE010, A.AAC001, A.AAC002, A.AAC003, E.AAE002, D.AAZ083 |
| 32nzxcu7x2uw9 | SELECT COUNT(1) FROM AC02 WHERE AAA027 = :B1 AND AAC008 = '1' AND EXISTS (SELECT 1 FROM AC01 WHERE AAC001 = AC02.AAC001 AND AAC009 = '10') |
| 39bu9491mfyq5 |
SELECT c.aac001, c.aac002, c.aac003, d.aae009, d.aae010, (SELECT aab069 FROM ae10 WHERE aaz001 = d.aaz065 ) AS aaz065, (SELECT MAX(aae002) FROM ac76 WHERE aaz166 = a.aae357) AS aae002, (SELECT SUM(aae128) FROM ac76 WHERE aaz166 = a.aae357) AS aae019 FROM AC84 A, AC60 B, AC01 C, AE03 D, AC63 E WHERE AAE117 = '3' AND A.AAZ010 = B.AAC001 AND B.AAC001 = C.AAC001 AND B.AAZ257 = E.AAZ257 AND E.AAZ003 = D.AAZ003 AND b.aaa027 = :1 union all select c.aac001, c.aac002, c.aac003, e.aae009, e.aae010, (select aab069 from ae10 where aaz001 = e.aaz009) as aaz065, b.aae211, (select sum(aae129) from ac73 where aaz170 = b.aaz170) as aae019 from ac84 a, ac71 b, ac73 d, ac01 c, ac74 e where a.aaz010 = b.aac001 and b.aaz170 = d.aaz170 and b.aaz099 = e.aaz097 and a.aaz010 = c.aac001 and a.aae117 = '3' and b.aaa076 in ('16', '17') and b.aaa027 = :2 and not exists (select 1 from ac60 where aac001 = c.aac001)
|
| 3j8a6yc0v842k | SELECT /*+ first_rows*/ a.lsh as lsh, a.sfz as sfz, pkg_common.fun_p_getAge(to_date(b.aac006, 'yyyymmdd'), sysdate, 2) as nl, (select yh_group from ac01 where aac001 = a.aac001) as z, a.xm as xm, a.je as je , a.kkrq as kkrq, a.cgbz as cgbz, a.bz as bz, a.yh as yh, a.zh as zh, a.cz as cz, a.xz as xz, a.dz as dz, a.aac001 as aac001 FROM v1_ad51 a, (select * from ac01 where aab301 like substr(f_getqx(:1 ), 1, 6)) b, af02 d WHERE 1=1 and a.czbm = d.aaz070 and a.aac001 = b.aac001 and d.aaf030 like f_getqx(:2 ) AND xzbm =:3 AND cgbz =:4 and a.kkrq >= nvl(:5 , '190001') ||'01' and nvl(:6 , '205001')||'31' >= a.kkrq and kkrq >= nvl(:7 , '19000101') and nvl(:8 , '20500101') >= kkrq AND yhbm =:9 and a.aaa027 = substr(f_getqx(:10 ), 1, 6) |
| 3upqmfat2h78x |
SELECT a.aaz070 as aaz070_q, a.aac001 as aac001_q, f_iy02(c.aac002) as czsfcb, f_sfbdqs(a.aac001) as sfbdqs_q , b.aae140 as aae140_q, a.aae016 as aae016_2_q, a.aae013 as aae013_q, b.aaz165 as aaz165_q, b.aaz158 as aaz158_q, c.aac003 as aac003_q, c.aac002 as aac002_q, c.aac004 as aac004_q, d.aab069 as aab069_5_q, b.aae030 as aae030_q, c.aac005 as aac005_q, c.aae005 as aae005_q, c.aae006 as aae006_q, c.aae007 as aae007_q, c.aac009 as aac009_q, c.aac010 as aac010_q, a.aae011 as aae011_q, a.aae014 as aae014_q, a.aae036 as aae036_q, a.aae015 as aae015_q, c.yh_dabh as yh_dabh_q, nvl(c.aac118, 0) as aac118_q, nvl(c.aac117, 0) as aac117_q, nvl(c.ync301, 0) as ync301_q, nvl(c.ync311, 0) as ync311_q, to_char(c.ync303) ||'-'|| to_char(c.ync304) as ync301_kj_q, to_char(c.ync305) ||'-'|| to_char(c.ync306) as aac117_kj_q, to_char(c.ync307) ||'-'|| to_char(c.ync308) as ync311_kj_q, to_char(c.aac006) as aac006_q, to_char(b.aaz289) as aaz289_q, f.aaa044 as aaa044_q, (SELECT aaa041 FROM aa28 WHERE aaz289=to_char(b.aaz289) AND aae341='1') as aaz289grjf_q, b.aab033 as aab033_q, b.ync309 as ync309_q, to_char(
b.aac049) as aac049_q, (select aac003 from ad53a4 where yae092 = a.aae011) as aae011_q, (select aac003 from ad53a4 where yae092 = a.aae014) as aae014_q, Fun_GetCbSfStr(a.aac001, b.aae140, :1 ) as aac066_q, b.aae200 as aae200_q FROM ac21 a, ac22 b, ac01 c, ae10 d, af02 e, aa05 f WHERE a.aac001 = c.aac001 AND b.aaz289 = f.aaz289 AND a.aac001 = b.aac001 AND c.aaz070 = d.aaz001 AND b.aae140 = '150' AND a.aac001 = b.aac001 AND e.aaf015 = :2 AND a.aae016 = :3 and a.aaz158 = b.aaz158 and c.aaz070 = e.aaz070 and e.aaf030 like f_getqx(:4 ) and c.yh_dabz=:5 AND to_char(a.aae036, 'yyyymm') >= :6 AND to_char(a.aae036, 'yyyymm') <= :7 AND (a.aac001, a.aae036) = (select g.aac001, max(g.aae036) from ac21 g where a.aac001 = g.aac001 group by g.aac001 ) |
| 3v12z3rdvx4yw | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PKG_YHCIP.PRC_TREATMENTPAYPLAN_1('201406' , '1000014708', '20140623', '511525'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 3ys0a078t31b5 | SELECT A.aac001, A.aac002, A.aac003, a.aac004, A.yh_dabh, a.yh_dajj, d.aaa044, (SELECT aab069 FROM ae10 WHERE aaz001 = A.aaz070) AS aab069_5, aab033, e.aae036 FROM AC01 A, AC22 B, AF02 C , aa05 d, ac17 e WHERE A.AAC001 = B.AAC001 AND A.AAZ070 = C.AAZ070 AND b.aaz289 = d.aaz289 and a.aac001 = e.aac001 AND nvl(a.yh_dabz, '0') = :1 AND aaf030 LIKE f_getqx(:2 )||'%' AND a.yh_dabh >= :3 ||:4 AND a.yh_dabh <= :5 ||:6 |
| 41dxprdugrqk3 | BEGIN PKG_YHHL.PRC_YHDK_SEND_DK(:1 , :2 , :3 , :4 , :5 , :6 ); END; |
| 4kv5rmsu5s26m | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PKG_YHCIP.PRC_TREATMENTPAYPLAN_1('201406' , '1000021127', '20140623', '511011'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 4m7m0t6fjcs5x | update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1 |
| 54vb3nu284wpd | BEGIN PKG_BENEFIT.prc_insertintoac82_check(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 ); END; |
| 57pm526uuz2fa | Insert Into SBDS_LOG values(sb_opseno.nextval, 1, 'ORA$PIPE$06F404B20002') |
| 5a1nvu17tf2jw | DELETE FROM SBDS_LOG WHERE USERFLAG = 'ORA$PIPE$078000F50002' |
| 5gbu08grw4cy5 |
SELECT a.aaz070 as aaz070, f_iy02(c.aac002) as czsfcb, a.aac001 as aac001, f_sfbdqs(a.aac001) as sfbdqs , b.aae140 as aae140, a.aae016 as aae016_2, a.aae013 as aae013, b.aaz165 as aaz165, b.aaz158 as aaz158, c.aac003 as aac003, c.aac002 as aac002, c.aac004 as aac004, d.aab069 as aab069_5, b.aae030 as aae030, c.aac005 as aac005, c.aae005 as aae005, c.aac010 as aac010, c.aae006 as aae006, c.aae007 as aae007, (select aaf031 from af08 where aaf013 = e.aaf015) as aaf031, (SELECT aab069 FROM AE03 , ae10 WHERE AAZ003 = (SELECT MAX(AAZ003) FROM AE03 WHERE AAZ010 = C.AAC001) AND ae03.aaz065 = ae10.aaz001) AS AAZ065 , (SELECT aae010 FROM AE03, ae10 WHERE AAZ003 = (SELECT MAX(AAZ003) FROM AE03 WHERE AAZ010 =C.AAC001) AND ae03.aaz065 = ae10.aaz001 ) AS aae010, c.aac009 as aac009, c.aac010 as aac010, (select aac003 from ad53a4 where yae092 = a.aae011) as aae011, (select aac003 from ad53a4 where yae092 = a.aae014) as aae014, a.aae036 as aae036, a.aae015 as aae015, c.yh_dabh as yh_dabh, nvl(c.aac118, 0) as aac118, nvl(c.aac117, 0) as aac117, nvl(c.ync301, 0) as ync301, nvl(c.ync311, 0) as ync311,
to_char(c.ync303) ||'-'|| to_char(c.ync304) as ync301_kj, to_char(c.ync305) ||'-'|| to_char(c.ync306) as aac117_kj, to_char(c.ync307) ||'-'|| to_char(c.ync308) as ync311_kj, to_char(c.aac006) as aac006, to_char(b.aaz289) as aaz289, f.aaa044 as aaa044, (SELECT aaa041 FROM aa28 WHERE aaz289=to_char(b.aaz289) AND aae341='1') as aaz289grjf, b.aab033 as aab033, b.ync309 as ync309, to_char(b.aac049) as aac049, Fun_GetCbSfStr_pzh(a.aac001, b.aae140, :1 ) as aac066, (select aac003 from ad53a4 where yae092 = a.aae011) as aae011, (select aac003 from ad53a4 where yae092 = a.aae014) as aae014, to_char(aae036, 'yyyymmdd') as aae036, to_char(aae015, 'yyyymmdd') as aae015, b.aae200 as aae200 FROM ac21 a, ac22 b, ac01 c, ae10 d, af02 e, aa05 f WHERE a.aac001 = c.aac001 AND b.aaz289 = f.aaz289 AND a.aac001 = b.aac001 AND c.aaz070 = d.aaz001 AND b.aae140 = '150' AND a.aac001 = b.aac001 AND c.aac001 not in(select aac001 from ac93) AND NOT EXISTS (select 1 from ac93 where aac001 = c.aac001) AND a.aae016 = :2 and a.aaz158 = b.aaz158 and c.aaz070 = e.aaz070 and e.aaf030 like f_getqx(:3 ) and c.yh_dabz=:4
AND to_char(a.aae036, 'yyyymm') <= :5 AND (a.aac001, a.aae036) = (select g.aac001, max(g.aae036) from ac21 g where a.aac001 = g.aac001 group by g.aac001 ) |
| 5xggrnkkyvajm | BEGIN PKG_MON_TREATMENTPAY.Prc_yhhp(:1 , :2 , :3 , :4 , :5 , :6 , :7 ); END; |
| 64pw7njhm6hj4 |
SELECT AF02.AAF030, AE10.AAB069, (select aaz065 from ae03, ac20 where ae03.aaz003 = ac20.aaz003 and ac20.aac001 = ac01.aac001) as aaz065, (select aae010 from ae03, ac20 where ae03.aaz003 = ac20.aaz003 and ac20.aac001 = ac01.aac001) as aae010, AC01.AAC001, AC01.AAC003, AC01.AAC002, AC01.AAC004, AC01.AAC006, (AC01.AAC006+600000) as aic162, ac01.aae013, AC01.aac010 as aac010, AC01.aae006 as aae006, AC01.yh_group as yh_group, AC01.AAE005, AC02.AAE030 AAE250, (select count(1)*12 from ac43 where ac02.aac001 =ac43.aac001 and ac43.aae341='1' and ac43.aae078='1') as sjjfnx, (SELECT SUM(NVL(AAE090, 0) + NVL(AAE092, 0) + NVL(AAE093, 0)) from AC56 WHERE AAZ304 = (SELECT MAX(AAZ304) FROM AC56 WHERE AAC001 = TO_NUMBER(ac01.aac001))) as stjfnx FROM AF02, AE10, AC01, AC02 WHERE AF02.AAZ070 = AE10.AAZ001 AND AC01.AAZ070 = AF02.AAZ070 AND AC02.AAC001 = AC01.AAC001 AND nvl(AC02.AAC008, '1') = '1' AND nvl(AC02.AAE140, '15
0') = '150' AND AC01.AAC084 = '0' and af02.aaf030 like f_getqx(:1 ) AND ac01.aab301 like substr(f_getqx(:2 ), 1, 6) AND (MONTHS_BETWEEN(TO_DATE(:3 , 'YYYY-MM-DD'), TO_DATE(TO_CHAR(AC01.AAC006), 'YYYY-MM-DD'))) >= 720 AND NOT EXISTS (SELECT 1 FROM AC71 WHERE AC71.AAE016 IN('1', '0') AND AC71.AAC001 = AC01.AAC001) |
| 6hfwap9cvgc8j |
SELECT a.bz as aae013, b.aac003 as aac003, b.aac002 as aac002, a.aic160 as aic160, a.aac001 as aac001, a.aae016 as aae016, a.aic162 as aic162, (select count(distinct aae003) from ac43 where aac001 = a.aac001) as aae003, (select sum(aae022) from ac43 where aac001 = a.aac001 and aae341='1') as aae022, (select aac003 from ad53a4 where yae092=a.aae011) as aae011, (select aac003 from ad53a4 where yae092=a.aae014) as aae014, sum(case when AAA036 in ('150011', '150031', '150041', '150021') then aae129 else 0 end) as AAE019 , SUM(DECODE( f.AAA036, '150012', AAE129, 0)) AAE020, a.aae036 as aae036, a.aae015 as aae015 FROM ac71 a, ac01 b, af02 c, af08 d, ac73 f WHERE 1 = 1 and a.aac001 = b.aac001 and a.aaz170 = f.aaz170 AND c.aaz070=b.aaz070 AND a.aaa076='15' and c.aaf015=d.aaf013 and a.aaa027 like substr(f_getqx(:1 ), 1, 6) AND to_date(to_char(A.AAE036, 'YYYYMM'), 'YYYYMM') >= to_date(:2 , 'YYYYMM') AND to_date(to_char(A.AAE036, 'YYYYMM'), 'YYYYMM') <= to_date(:3 , 'YYYYMM') AND a.aae016 = :4 AND (a.aac001, a.aae036) = (select g.aac001, max(g.aae036) from ac71 g where a.aac001 = g.aac001 group by g.aac001 ) group by a.bz, b.aac003, b.aac002, a.aic160, a.aac001, a.aae016, a.aic162, aae011, aae014, a.aae036, a.aae015
|
| 6rw4n0bba5x25 | SELECT COUNT(*) FROM AD53A4 WHERE YAE092 = :B1 |
| 767ctwqn7y1qv |
SELECT A.AAC001 as aac001_q, A.AAC002 as aac002_q, A.AAC003 as aac003_q, A.AAC003 as aac003_q1, A.AAB301 as aab301_q, A.AAZ070 as aaz070_q, A.AAC004 as aac004_q, A.AAC005 as aac005_q, A.AAC006 as aac006_q, A.AAC007 as aac007_q, A.AAC009 as aa009_q, A.AAC010 as aac010_q, A.AAC011 as aac011_q, A.AAC012 as aac012_q, A.AAC014 as aac014_q, A.AAC015 as aac015_q, A.AAC017 as aac017_q, A.AAC020 as aac020_q, A.AAE005 as aae005_q, A.AAE006 as aae006_q, A.AAE007 as aae007_q, B.AAE013 as aae013_q, A.AAE159 as aae159_q, A.AAZ177 as aaz177_q, A.AAB401 as aab401_q, A.AAC033 as aac033_q, A.AAE004 as aae004_q, A.AAC084 as aac084_q, A.AAC060 as aac060_q, A.AAC016 as aac016_q, A.AAE146 as aae146_q, A.AJA004 as aja004_q, A.AAC114 as aac114_q, A.AAC115 as aac115_q, A.AAC116 as aac116_q, C.AAA027 as aaa027_q, C.AAZ159 as aaz159_q, C.AAZ157 as aaz157_q, C.AAZ192 as aaz192_q, C.AAZ070 as aaz070_q, C.AAE140 as aae140_q, C.AAZ204 as aaz204_q, C.AAE041 as aae041_q,
C.AAE042 as aae042_q, (select aaa044 from aa05 where aaz289 = C.aaz289) as AAZ289_q, C.AAB033 as aab033_q, D.AAB069 as aab069_q, B.AAE127 as aae127_q, (SELECT DISTINCT AAZ288 FROM AE25 G WHERE G.AAZ083 IN (SELECT DISTINCT AAZ083 FROM AC43 F WHERE F.AAZ223 IN (SELECT AAZ223 FROM AC42 H WHERE H.AAZ204 = C.AAZ204) AND f.aae341 = 1)) AS aaz083_q, (select aac003 from ad53a4 where yae092 = b.aae011) as aae011_q, b.aae036 as aae036_q, (select aac003 from ad53a4 where yae092 = b.aae014) as aae014_q, b.aae015 as aae015_q FROM AC01 A, AC40 B, AC41 C, AE10 D, AF02 E WHERE A.AAC001 = C.AAC001 AND EXISTS (SELECT NULL FROM AC42 D WHERE D.AAZ204 = C.AAZ204 AND D.AAE341 <> :1 ) AND B.AAA115 = :2 AND B.AAZ192 = C.AAZ192 AND A.AAZ070 = D.AAZ001 AND NVL(B.AAE016, 0) = :3 AND (b.aac001, b.aae036) = (select g.aac001, max(g.aae036) from ac40 g where a.aac001 = g.aac001 and g.aaa115=:4 group by g.aac001 ) AND A.AAZ070 = E.AAZ070 AND E.AAF030 LIKE F_GETQX(:
5 ) |
| 7hda4gg99g5rz | SELECT /*+ rule*/ C.AAC001, C.AAC002, C.AAC003, D.AAE009, D.AAE010, (SELECT AAB069 FROM AE10 WHERE AAZ001 = D.AAZ065) AS AAZ065, A.AAZ220, D.AAZ065 AS AAZ065_1, (SELECT SUM(aae019) FROM ac83 WHERE aaz220 = A.aaz220) AS aae019, b.aae116 FROM AC84 A, AC60 B, AC01 C, AE03 D, AC63 E , ac83 F WHERE AAE117 = '2' AND A.AAZ010 = B.AAC001 AND B.AAC001 = C.AAC001 AND B.AAZ257 = E.AAZ257 AND E.AAZ003 = D.AAZ003 AND a.aaz220 = f.aaz220 AND F.aaa085 = '1' AND B.AAA027 = :1 UNION SELECT /*+ rule*/ C.AAC001, C.AAC002, C.AAC003, D.AAE009, D.AAE010, (SELECT AAB069 FROM AE10 WHERE AAZ001 = D.AAZ065) AS AAZ065, A.AAZ220, D.AAZ065 AS AAZ065_1, (SELECT SUM(aae019) FROM ac83 WHERE aaz220 = A.aaz220) AS aae019, (select aae116 from ac60 where aac001 = c.aac001) as aae116 FROM AC84 A, ac71 B, AC01 C, AE03 D, ac74 E , ac83 f WHERE AAE117 = '2' AND A.AAZ010 = B.AAC001 AND B.AAC001 = C.AAC001 AND B.aaz099 = E.aaz097 and b.aaa076 in('16', '17') AND b.aae016 = '1' AND E.AAZ003 = D.AAZ003 AND a.aaz220 = f.aaz220 AND f.aaa085 = '0' AND B.AAA027 = :2 |
| 7m08860zaq27g |
SELECT /*+rule+*/ c.aaz288 as aaz288, c.aae002 as aae002, c.aab033 as aab033, c.aae142 as aae142, c.aaa121 as aaa121, c.aae221 as aae221, c.aae281 as aae281, d.aac003 as zsdxmc, c.aaz295 as aaz295 FROM ae23 a, ae25 b, ad21 c, ac01 d WHERE a.aaz083 = b.aaz083 AND c.aaz288 = b.aaz288 AND a.aaz010 = d.aac001 AND a.aae078 = '0' AND NVL(a.aae079, '0') = '0' AND c.aae142 = '5' AND c.aae281 is not null AND c.aab033 = :1 AND c.aaa027 = :2 UNION SELECT /*+rule+*/ c.aaz288 as aaz288, c.aae002 as aae002, c.aab033 as aab033, c.aae142 as aae142, c.aaa121 as aaa121, c.aae221 as aae221, c.aae281 as aae281, d.aab069 as zsdxmc, c.aaz295 as aaz295 FROM ae23 a, ae25 b, ad21 c, ae10 d WHERE a.aaz083 = b.aaz083 AND c.aaz288 = b.aaz288 AND a.aaz010 = d.aaz001 AND a.aae078 = '0' AND NVL(a.aae079, '0') = '0' AND c.aae142 = '4' AND c.aae281 is not null AND c.aab033 = :3 AND c.aaa027 = :4 UNION SELECT /*+rule+*/ c.aaz288 as aaz288, c.aae002 as aae002, c.aab033 as aab033, c.aae142 as aae142, c.aaa121 as aaa121, c.aae221 as aae221, c.aae281 as aae281, d.AAB069 as zsdxmc, c.aaz29
5 as aaz295 FROM ad21 c, ae23 a, ae25 b, ae10 d WHERE c.aae142 in ('1', '2', '5') AND c.aab033 = :5 AND a.aae078 = '0' AND NVL(a.aae079, '0') = '0' AND a.aaz083 = b.aaz083 AND c.aaz288 = b.aaz288 AND c.aaz295 = d.aaz001 AND c.aae281 is not null AND c.aaa027 = :6 UNION SELECT /*+rule+*/ a.aaz288 as aaz288, a.aae002 as aae002, a.aab033 as aab033, a.aae142 as aae142, a.aaa121 as aaa121, a.aae221 as aae221, a.aae281 as aae281, d.aab069 as zsdxmc, a.aaz295 as aaz295 FROM ad21 a, ae10 d WHERE a.aae142 in ('6', '7', '8', '9', '10', '15') AND a.aab033 = :7 AND a.aaz295 = d.aaz001 AND a.aae281 is not null AND a.aaa027 = :8 |
| 7ysu26dcuuxwf |
SELECT A.AAC001, A.AAC002, A.AAC003, A.AAB301, A.AAZ070, A.AAC004, A.AAC005, A.AAC006, A.AAC007, A.AAC009, A.AAC010, A.AAC011, A.AAC012, A.AAC014, A.AAC015, A.AAC017, A.AAC020, A.AAE005, A.AAE006, A.AAE007, B.AAE013, A.AAE159, A.AAZ177, A.AAB401, A.AAC033, A.AAE004, A.AAC084, A.AAC060, A.AAC016, A.AAE146, A.AJA004, A.AAC114, A.AAC115, A.AAC116, C.AAA027, C.AAZ159, C.AAZ157, C.AAZ192, C.AAZ070, C.AAE140, C.AAZ204, C.AAE041, C.AAE042, (select aaa044 from aa05 where aaz289 = C.aaz289) as AAZ289, C.AAB033, D.AAB069, B.AAE127, (SELECT DISTINCT AAZ288 FROM AE25 G WHERE G.AAZ083 IN (SELECT DISTINCT AAZ083 FROM AC43 F WHERE F.AAZ223 IN (SELECT AAZ223 FROM AC42 H WHERE H.AAZ204 = C.AAZ204)
AND f.aae341 = 1)) AS aaz083, (select aac003 from ad53a4 where yae092 = b.aae011) as aae011, b.aae036, (select aac003 from ad53a4 where yae092 = b.aae014) as aae014, b.aae015 FROM AC01 A, AC40 B, AC41 C, AE10 D, AF02 E WHERE A.AAC001 = C.AAC001 AND EXISTS (SELECT NULL FROM AC42 D WHERE D.AAZ204 = C.AAZ204 AND D.AAE341 <> :1 ) AND B.AAA115 = :2 AND B.AAZ192 = C.AAZ192 AND A.AAZ070 = D.AAZ001 AND NVL(B.AAE016, 0) = :3 AND (b.aac001, b.aae036) = (select g.aac001, max(g.aae036) from ac40 g where a.aac001 = g.aac001 and g.aaa115=:4 group by g.aac001 ) AND A.AAZ070 = E.AAZ070 AND E.AAF030 LIKE F_GETQX(:5 ) |
| 813u52f5tt0n6 | BEGIN PKG_TJ.REPORT_YH02_SSTJ02_ANY(:1 , :2 , :3 , :4 , :5 , :6 ); END; |
| 83uzk9n6uz7bj | Insert Into SBDS_LOG values(sb_opseno.nextval, 1, 'ORA$PIPE$06DC02520002') |
| 842cvc373ysfd |
select a.aac002 as aac002, a.aac003 as aac003, (select ae10.aab069 from ae10 where ae10.aaz001 = a.aaz070) as c, (select aaf031 from af08 where aaf013 =(select aaf015 from af02 where aaz070 = a.aaz070)) as xz, (select yh_group from ac01 where aac001 = a.aac001) as z, a.aac010 as aac010, a.aaz223 as aaz223, a.aaa027 as aaa027, a.aaz157 as aaz157, a.aaz159 as aaz159, a.aac001 as aac001, a.aae140 as aae140, a.aaa115 as aaa115, a.aab033 as aab033, a.aae002 as aae002, a.aae003 as aae003, a.aae341 as aae341, a.aae340 as aae340, a.aae022 as aae022, a.aae023 as aae023, a.aae078 as aae078, a.aae079 as aae079, a.aae180 as aae180, a.aae181 as aae181, a.aae202 as aae202, a.aaz083 as aaz083, a.aaz289 as aaz289, a.aaz070 as aaz070, a.aae017 as aae017, a.aae018 as aae018, a.aaa044 as aaa044, a.aaz136 as aaz136, a.aac066 as aac066, a.prseno as prseno from ( SELECT b.aac002 as aac002, b.aac003 as aac003, b.aac010 as aac010, a.aaz223 as aaz223, a.aaa027 as aaa027, a.aaz157 as aaz157, a.aaz159 as aaz159, a.aac001 as aac001, a.aae140 as aae140, a.aaa115 as aaa115, a.aab033 as aab033, a.aae002 as aae002, a.aae003 as aae003, a.aae341 as aae341, a.aae340 as aae340, a.aae022 as aae022, a.aae023 as aae023, a.aae078 as aae078, a.aae079 as aae079, a.aae180 as aae180, a.aae181 as aae181, a.aae202 as aae202, a.aaz083 as aaz083, a.
aaz289 as aaz289, a.aaz070 as aaz070, a.aae017 as aae017, a.aae018 as aae018, c.aaa044 as aaa044, a.aaz136 as aaz136, Fun_GetCbSfStr_pzh(b.aac001, a.aae140, :1 ) as aac066, a.prseno as prseno FROM ac43 a, ac01 b, aa05 c WHERE 1=1 AND a.aac001 = b.aac001 AND a.aaz289 = c.aaz289 AND exists (select 1 from af02 af where af.aaf015 = :2 and af.aaz070 = b.aaz070 ) AND a.aaa027 like substr(f_getqx(:3 ), 1, 6) AND a.aae140 = :4 AND a.aab033 = :5 AND a.aae341 = :6 AND a.aae078 = :7 UNION ALL SELECT ('ºÏ¼Æ') as aac002, null as aac003, null as aac010, null as aaz223, null as aaa027, null as aaz157, null as aaz159, null as aac001, null as aae140, null as aaa115, null as aab033, null as aae002, count(aae003) as aae003, null as aae341, null as aae340, SUM(a.aae022) as aae022, null as aae023, null as aae078, null as aae079, null as aae180, null as aae181, null as aae202, null as aaz083, null as aaz289, null as aaz070, null as aae017, null as aae018, null as aaa044, null as aaz136, null as aac066, null as prseno FROM ac43 a, ac01 b, aa05 c WHERE 1=1
AND a.aac001 = b.aac001 AND a.aaz289 = c.aaz289 AND exists (select 1 from af02 af where af.aaf015 = :8 and af.aaz070 = b.aaz070 ) AND a.aaa027 like substr(f_getqx(:9 ), 1, 6) AND a.aae140 = :10 AND a.aab033 = :11 AND a.aae341 = :12 AND a.aae078 = :13 ) a |
| 8cf326ktrgzw4 | select * from ( SELECT aae076, SUM(AAE019) as aae019, (CASE WHEN AAA039 = 1 THEN 'ÊÕÈë' when aaa039 = 2 then 'Ö§³ö' ELSE 'µ÷ÕË' END) as aaa039, aae002, aae008 as aaz065, AA26.aaa146, aad017 as aad017 FROM AD54CW, AA26 WHERE AD54CW.aaa027 = AA26.AAB301 AND AD54CW.aab301 = :1 AND aaa039 = :2 AND aae008 like nvl(:3 , '%') AND aad027 is null GROUP BY AAE076, aaa039, aae002, aaa146, aae008, aad017 ) |
| 8rdxhh6yx3r2p |
SELECT 'ÑøÀÏ´ýÓö' as dylx, to_char(ac01.aac001) as aac001, ac60.aaz257, ac01.aac003, ac01.aac004, SUBSTR(TO_CHAR(ac01.aac006), 1, 4) || ' Äê ' || SUBSTR(TO_CHAR(ac01.aac006), 5, 2) || ' ÔÂ' aac006, ac01.aac002, SUBSTR(TO_CHAR(ac20.aae030), 1, 4) || ' Äê ' || SUBSTR(TO_CHAR(ac20.aae030), 5, 2) || ' ÔÂ' aae030, ac60.aic165, (SELECT NVL(SUM(aae019), 0) FROM ac61 WHERE aaz257 = ac60.aaz257 and aaa036 ='150011' and aae042 is null ) jcylj, (SELECT NVL(SUM(aae019), 0) FROM ac61 WHERE aaz257 = ac60.aaz257 and aaa036 = '150012' and aae042 is null) zhylj, (SELECT NVL(SUM(aae019), 0) FROM ac61 WHERE aaz257 = ac60.aaz257 and aae042 is null ) dyhj, SUBSTR(TO_CHAR(ac60.aic160), 1, 4) || ' Äê ' || SUBSTR(TO_CHAR(ac60.aic160), 5, 2) || ' ÔÂ' aic160 FROM ac01, ac20, ac60, af02 WHERE ac60.aac001 = ac01.aac001 AND ac60.aac001 = ac20.aac001 AND ac01.aaz070 = af02.aaz070 AND ac60.aaa027 = :1
AND
af02.aaf030 LIKE f_getqx(:2 ) AND ac01.aac002 = :3 union SELECT 'ÕË»§Óà¶î·µ»¹' as dylx, to_char(ac01.aac001) as aac001, null as aaz257, ac01.aac003, ac01.aac004, SUBSTR(TO_CHAR(ac01.aac006), 1, 4) || ' Äê ' || SUBSTR(TO_CHAR(ac01.aac006), 5, 2) || ' ÔÂ' aac006, ac01.aac002, SUBSTR(TO_CHAR(ac20.aae030), 1, 4) || ' Äê ' || SUBSTR(TO_CHAR(ac20.aae030), 5, 2) || ' ÔÂ' aae030, ac73.aae129, 0 jcylj, 0 zhylj, 0 dyhj, substr(ac71.aae211, 1, 4)||'Äê'||substr(ac71.aae211, 5, 2)||'ÔÂ' as aic160 FROM ac01, ac20, af02, ac73, ac71 WHERE ac20.aac001 = ac01.aac001 and ac01.aab301 = :4 AND ac01.aaz070 = af02.aaz070 and ac73.aaz170 = ac71.aaz170 and ac71.aaz157 = ac20.aaz157 and ac71.aae016 <>'2' and ac71.aaa076 in ('17', '16') and ac20.AAE140 = '150' and ac20.aac031 in ('3') AND af02.aaf030 LIKE f_getqx(:5 ) AND ac01.aac002 = :6
|
| 8wwxn7h40k6k4 | SELECT NVL(MAX(aae281) + 1, aae002 || aab033 || aae142 || REPLACE(:1 , '-', '') || '0001') AS aae281 FROM ad21 a WHERE aae002 = :2 AND aab033 = :3 AND aae142 = :4 AND aae221 = REPLACE(:5 , '-', '') GROUP BY aae002, aab033, aae142 |
| 8x6nf1nthur88 | SELECT c.aac001 as aac001_q, c.aac003 as aac003_q, c.aac002 as aac002_q, c.aac004 as aac004_q, c.yh_dabh as yh_dabh_q, a.aae016 as aae016_2_q, a.aae013 as aae013_q, a.aaz002 as aaz002_q, a.aae160 as aae160_q, (select aac003 from ad53a4 where yae092 = a.aae011) as aae011_q, a.aae036 as aae036_q, (select aac003 from ad53a4 where yae092 = a.aae014) as aae014_q, a.aae015 as aae015_q, d.aab069 as aab069_5_q FROM ac95 a, ac20 b, ac01 c, ae10 d, af02 e, af08 f WHERE a.aac001 = c.aac001 AND a.aac001 = b.aac001 AND c.aaz070 = d.aaz001 AND b.aae140 = '150' and e.aaf015=f.aaf013 AND c.aac002 like '%' || nvl(:1 , '%') || '%' AND c.aac003 like '%' || nvl(:2 , '%') || '%' AND a.aae016 = :3 and c.aaz070 = e.aaz070 and e.aaf030 like f_getqx(:4 ) |
| 9assj6yda40vr | SELECT a.aac001 as aac001_q, a.aae016 as aae016_2_q, a.aae013 as aae013_q, c.aac003 as aac003_q, c.aac002 as aac002_q, c.aac004 as aac004_q, c.yh_dabh as yh_dabh_q, a.aaz206 as aaz206_q, (select aac003 from ad53a4 where yae092 = a.aae011) as aae011_q, (select aac003 from ad53a4 where yae092 = a.aae014) as aae014_q, a.aae036 as aae036_q, a.aae015 as aae015_q, f_iy02(c.aac002) as czsfcb, d.aab069 as aab069_5_q FROM v_ac30 a, ac20 b, ac01 c, ae10 d, af02 e, af08 f WHERE a.aac001 = c.aac001 AND a.aac001 = b.aac001 AND b.aae100 = '1' AND c.aaz070 = d.aaz001 AND b.aae140 = '150' and e.aaf015=f.aaf013 AND c.aac002 like '%' || nvl(:1 , '%') || '%' AND c.aac003 like '%' || nvl(:2 , '%') || '%' AND a.aae016 = :3 AND a.aaz206 in (select aaz206 from ac31 where AAE326 in ('ac20', 'ac02', 'ae03')) and c.aaz070 = e.aaz070 and e.aaf030 like f_getqx(:4 ) |
| 9jks1srb91tmq | DELETE FROM SBDS_LOG WHERE USERFLAG = 'ORA$PIPE$0723035A0002' |
| 9qy4bgdmc83c5 | SELECT /*+ first_rows*/ a.lsh as lsh, a.sfz as sfz, pkg_common.fun_p_getAge(to_date(b.aac006, 'yyyymmdd'), sysdate, 2) as nl, (select yh_group from ac01 where aac001 = a.aac001) as z, a.xm as xm, a.je as je , a.kkrq as kkrq, a.cgbz as cgbz, a.bz as bz, a.yh as yh, a.zh as zh, a.cz as cz, a.xz as xz, a.dz as dz, a.aac001 as aac001 FROM v1_ad51 a, (select * from ac01 where aab301 like substr(f_getqx(:1 ), 1, 6)) b, af02 d WHERE 1=1 and a.czbm = d.aaz070 and a.aac001 = b.aac001 and d.aaf030 like f_getqx(:2 ) AND czbm =:3 AND cgbz =:4 and a.kkrq >= nvl(:5 , '190001') ||'01' and nvl(:6 , '205001')||'31' >= a.kkrq and kkrq >= nvl(:7 , '19000101') and nvl(:8 , '20500101') >= kkrq AND yhbm =:9 and a.aaa027 = substr(f_getqx(:10 ), 1, 6) |
| 9vd3458bx83tv | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PKG_YHCIP.PRC_TREATMENTPAYPLAN_1('201406' , '1000013844', '20140623', '511527'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 9y34bppmu9jft |
SELECT lsh, aac003, aae010, '01' AS leixing, aac002, je FROM (SELECT A.AAZ083 AS LSH, (SELECT AAC003 FROM AC01 WHERE AAC001 = A.AAC001) AS AAC003, (SELECT AAE010 FROM AE03 WHERE AAZ003 = A.AAZ003) AS AAE010, (SELECT AAC002 FROM AC01 WHERE AAC001 = A.AAC001) AS AAC002, A.AAE022 AS JE, ROWNUM AS FINALROW FROM (SELECT AAZ083, MAX(AAC001) AS AAC001, MAX(AAZ003) AS AAZ003, SUM(AAE022) AS AAE022 FROM AC43 WHERE aae341 = '1' and aae022 = 0 and aab033 = '1' and AAZ083 IN (SELECT AAZ083 FROM AE25 WHERE AAZ288 in (SELECT aaz288 FROM AD21 WHERE AAA027 LIKE :1 || '%' AND AAB033 = '1' and aae221 is not null)) AND aae078 = 0 AND aae017 = '0' GROUP BY AAZ083 ORDER BY AAZ083) A order by aaz083) where 1=1 and rownum <=:2
and rownum >= :3 |
| 9ycx4pw8bxmsr | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PKG_MON_COLLECTPLAN.PROC_MON_COLLECT('201406', '511923', '1000012428', '16', '60', '0', '999999', '20', '53830'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| a7q1jc5kpz3ra | INSERT INTO AC43 (AAZ223, AAA027, AAZ157, AAZ159, AAC001, AAE140, AAA115, AAB033, AAE002, AAE003, AAE341, AAE340, AAE022, AAE023, AAE078, AAE079, AAE180, AAE181, AAE202, AAZ083, AAZ289, AAZ070, AAE017, AAE018, AAZ136, AAZ003, AAZ065, AAE010, YH_WH, PCH) VALUES (SQ_AAZ223.NEXTVAL, :B21 , :B20 , :B19 , :B18 , :B17 , '10', :B16 , :B15 , :B14 , :B10 , :B11 , :B13 , :B12 , '0', NULL, :B11 , :B11 , DECODE(:B10 , '1', 12, 0), :B9 , :B3 , :B8 , '0', NULL, :B7 , :B6 , :B5 , :B4 , F_GETWH(:B3 , :B2 ), :B1 ) |
| a93jw041n0pt4 | SELECT a.aaz288 as aaz288, a.aae002 as aae002 , b.aac003 AS zsdxmc , a.aab033 as aab033, a.aae142 as aae142, (SELECT SUM(aae022) FROM ac43 WHERE aaz083 = c.aaz083) AS je FROM AD21 A, AC01 B, AE25 C, af02 d WHERE A.AAZ288 = C.AAZ288 AND A.AAZ295 = B.AAC001 and b.aaz070 = d.aaz070 AND aab033 = '3' and a.aaa027 like substr(f_getqx(:1 ), 1, 6) and d.aaf030 like f_getqx(:2 ) AND aae142 IN('5', '4') AND exists(SELECT 1 FROM ac43 WHERE aaz083 = c.aaz083 AND aae078 = 0) AND A.aae002 = :3 UNION ALL SELECT a.aaz288 as aaz288, a.aae002 as aae002, b.aab069 AS zsdxmc , a.aab033 as aab033, a.aae142 as aae142, (SELECT SUM(aae022) FROM ac43 WHERE aaz083 = c.aaz083) AS je FROM AD21 A, AE10 B, AE25 C, af02 d WHERE A.AAZ288 = C.AAZ288 AND A.AAZ295 = B.AAZ001 and b.aaz001 = d.aaz070 AND a.aab033 = '3' and a.aaa027 like substr(f_getqx(:4 ), 1, 6) AND aae142 IN('5', '4') and d.aaf030 like f_getqx(:5 ) AND exists(SELECT 1 FROM ac43 WHERE aaz083 = c.aaz083 AND aae078 = 0) AND a.aae002 = :6 |
| abzdcvk0jpw2m | INSERT INTO TMP_AC44 (AAC001) SELECT DISTINCT C.AAC001 FROM AC40 A, AC41 B, AC42 C WHERE A.AAZ192 = B.AAZ192 AND B.AAZ204 = C.AAZ204 AND A.AAE016 = '1' AND C.AAB033 = '1' AND C.AAE140 IN ('150') AND C.AAA027 LIKE :B1 || '%' AND (EXISTS (SELECT 1 FROM AC20 WHERE AC20.AAC031 IN ('1', '2') AND AC20.AAC001 = A.AAC001) OR EXISTS (SELECT 1 FROM YH00_BCRZB WHERE C.AAZ204 = YH00_BCRZB.AAZ204 AND NVL(YH00_BCRZB.DZBZ, '0') = '0')) AND NOT EXISTS (SELECT 1 FROM AC43 D WHERE D.AAZ223 = C.AAZ223) |
| afy30t5u11fgm | INSERT INTO AE23 (AAZ010, AAE002, AAZ002, AAZ021, AAZ083, AAE014, AAE015, AAE016, AAE011, AAE036, AAE019, AAZ003, AAB033, AAE078, AAE079, PCH) VALUES (:B10 , :B9 , :B8 , :B7 , :B6 , :B5 , SYSDATE, '1', :B4 , SYSDATE, :B3 , :B2 , '1', '0', NULL, :B1 ) |
| artdbgvupcrpj |
SELECT MAX(A.AAA027) AAA027, MAX(A.AAC001) AAC001, MAX(A.AAC031) AAC031, MAX(A.AAE030) AAE030, MAX(A.AAE140) AAE140, MAX(A.AAZ003) AAZ003, MAX(A.AAZ157) AAZ157, MAX(A.AAZ159) AAZ159, MAX(AAZ165) AAZ165, MAX(AAZ289) AAZ289, MAX(AAB033) AAB033, MAX(B.AAZ070) AAZ070, MAX(A.AAE100) AAE100, MAX(A.PRSENO) PRSENO, MAX(A.YNC309) YNC309, MAX(A.YNC310) YNC310, MAX(NVL(C.AAC066, '20')) AS AAC066 FROM AC20 A, AC01 B, AC93 C WHERE A.AAC001=B.AAC001 AND A.AAC001=C.AAC001(+) AND A.AAB033 = '1' AND A.AAE100 = '1' AND A.AAC031 = '1' AND A.AAE140 IN ('150') AND PKG_COMMON.FUN_P_GETAGE(TO_DATE(TO_CHAR(B.AAC006), 'YYYYMMDD'), TO_DATE(TO_CHAR(:B6 ), 'YYYYMM'), '1')<=TO_NUMBER(:B7 ) AND PKG_COMMON.FUN_P_GETAGE(TO_DATE(TO_CHAR(B.AAC006), 'YYYYMMDD'), TO_DATE(TO_CHAR(:B6 ), 'YYYYMM'), '1')>=CASE WHEN TO_NUMBER(:B5 ) < 16 THEN 16 ELSE TO_NUMBER(:B5 ) END AND TO_NUMBER(SUBSTR(A.AAE030, 1, 6))>=TO_NUMBER(:B4 ) AND TO_NUMBER(SUBSTR(A.AAE030, 1, 6))<=TO_NUMBER(:B3 ) AND NOT EXISTS(SELECT 1 FROM AC43 WHERE A.AAC001 = AC43.AAC001 AND AC43.AAE003 = TO_NUMBER(:B1 ) AND AC43.AAE341 = '1') AND SUBSTR(TO_CHAR(B.AAC006), 1, 6)+6000 >= TO_CHAR(SYSDATE, 'yyyy')||'01' AND A.AAA027 LIKE :B2 ||'%' AND NOT EXISTS(SELECT 1 FROM AC71 WHERE AC71.AAC001 = A.AAC001 AND AAE016 IN ('0', '1') ) AND SUBSTR(TO_CHAR(A.AAE030), 1, 4) <= TO_CHAR(:B1 ) AND NOT EXISTS (SELECT 1 FROM AC27 WHERE AC27.AAC001=A.AAC001 AND AC27.AAE016='0') GROUP BY A.AAC001
|
| axmdf8vq7k1rh | select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1 |
| aytv7zh0sd94p | SELECT AAA027 FROM AA13 WHERE AAB301 IN (SELECT SUBSTR(YAB003, 1, 6) FROM AD53A4 WHERE YAE092 = :B1 ) |
| bstuf0cvj7upj |
SELECT round((select to_char(ac50.aae240 * ac60.aic167) from ac60, ac50 where ac60.aac001 = ac50.aac001 and ac60.aac001 = a.aac001 ), 2) as zzje, round((select to_char(ac50.aae240 * (1-ac60.aic167)) from ac60, ac50 where ac60.aac001 = ac50.aac001 and ac60.aac001 = a.aac001 ), 2) as zzbt, f_getwfylj(b.aac001, a.aae016) as ybkfylj, a.aac001 AS aac001, a.aac002 AS aac002, a.aae160 AS aae160, a.aae041 AS aae041, a.aae013 AS aae013, a.aae145 AS aae145, (select aab069 from ae10 where ae10.aaz001 = a.aae006) AS aae006, a.aae007 AS aae007, a.aae010 as aae010, a.aae008 AS aae008, a.aaa027 AS aaa027, a.aae016 AS aae016, (SELECT aac003 FROM ad53a4 WHERE yae092 = a.aae011) as aae011, to_char(a.aae228, 'yyyymmdd') as aae036, (SELECT ad53a4.aac003 FROM ac95 , ad53a4 WHERE ac95.aac001 = a.aac001 AND ac95.aae014 = ad53a4.yae092 and ac95.rowid = (select max(rowid) from ac95 where ac95.aac001 = a.aac001) ) as aae014, (select to_char(max(aae015), 'yyyymmdd') from ac95 where aac001 = a.aac001) as aae015, b.aac006 as aac006, b.aac004 as aac004, b.aac003 as aac003, c.aa
e030 as aae030 , (SELECT zhje FROM yh03_zzlog WHERE ROWID = (SELECT MAX(ROWID) FROM yh03_zzlog WHERE aac001 = b.aac001)) as zhje FROM ac95_check a , (select * from ac01 where aab301 like substr(f_getqx(:1 ), 1, 6)) b , ac20 c , af02 d, af08 e WHERE 1=1 and a.aac001=b.aac001 and b.aac001=c.aac001 and d.aaf015=e.aaf013 and d.aaz070 = b.aaz070 and a.aaa027 like substr(f_getqx(:2 ), 1, 6) AND a.aae016=:3 AND to_date(to_char(A.aae228, 'YYYYMM'), 'YYYYMM') >= to_date(:4 , 'YYYYMM') AND to_date(to_char(A.aae228, 'YYYYMM'), 'YYYYMM') <= to_date(:5 , 'YYYYMM') |
| bz7dh04smpdzg | SELECT COUNT(DISTINCT A.AAC001) AS SFRS, SUM(CASE WHEN A.AAA038 = '151' THEN AAE019 ELSE 0 END) AS SFJCYLJ, SUM(CASE WHEN A.AAA038 = '152' THEN AAE019 ELSE 0 END) AS SFZHYLJ FROM AC83 A, AC84 B WHERE A.AAZ220 = B.AAZ220 AND A.AAE002 = :B2 AND A.AAA027 = :B1 AND A.AAA038 IN ('151', '152') AND B.AAE117 = '1' |
| cr5jk2msbd66p |
SELECT /*+rule+*/ c.aaz288 as aaz288, c.aae002 as aae002, c.aab033 as aab033, c.aae142 as aae142, c.aaa121 as aaa121, c.aae221 as aae221, c.aae281 as aae281, d.aac003 as zsdxmc, c.aaz295 as aaz295 FROM ae23 a, ae25 b, ad21 c, ac01 d WHERE a.aaz083 = b.aaz083 AND c.aaz288 = b.aaz288 AND a.aaz010 = d.aac001 AND a.aae078 = '0' AND NVL(a.aae079, '0') = '0' AND c.aae142 = '5' AND c.aae281 is not null AND c.aab033 = :1 AND c.aaa027 = :2 AND d.aac002 = :3 UNION SELECT /*+rule+*/ c.aaz288 as aaz288, c.aae002 as aae002, c.aab033 as aab033, c.aae142 as aae142, c.aaa121 as aaa121, c.aae221 as aae221, c.aae281 as aae281, d.aab069 as zsdxmc, c.aaz295 as aaz295 FROM ae23 a, ae25 b, ad21 c, ae10 d WHERE a.aaz083 = b.aaz083 AND c.aaz288 = b.aaz288 AND a.aaz010 = d.aaz001 AND a.aae078 = '0' AND NVL(a.aae079, '0') = '0' AND c.aae142 = '4' AND c.aae281 is not null AND c.aab033 = :4 AND c.aaa027 = :5 AND 1 = 2 UNION SELECT /*+rule+*/ c.aaz288 as aaz288, c.aae002 as aae002, c.aab033 as aab033, c.aae142 as aae142, c.aaa121 as aaa121, c.aae221 as aae221, c.aae281 as aae281,
d.AAB069 as zsdxmc, c.aaz295 as aaz295 FROM ad21 c, ae23 a, ae25 b, ae10 d WHERE c.aae142 in ('1', '2', '5') AND c.aab033 = :6 AND a.aae078 = '0' AND NVL(a.aae079, '0') = '0' AND a.aaz083 = b.aaz083 AND c.aaz288 = b.aaz288 AND c.aaz295 = d.aaz001 AND c.aae281 is not null AND c.aaa027 = :7 AND 1 = 2 UNION SELECT /*+rule+*/ a.aaz288 as aaz288, a.aae002 as aae002, a.aab033 as aab033, a.aae142 as aae142, a.aaa121 as aaa121, a.aae221 as aae221, a.aae281 as aae281, d.aab069 as zsdxmc, a.aaz295 as aaz295 FROM ad21 a, ae10 d WHERE a.aae142 in ('6', '7', '8', '9', '10', '15') AND a.aab033 = :8 AND a.aaz295 = d.aaz001 AND a.aae281 is not null AND 1 = 2 AND a.aaa027 = :9 |
| dd0yhdbfypmj9 | SELECT YAB003 FROM AD53A4 WHERE YAE092 = :B1 |
| dgw8xpmjm5ru4 | SELECT /*+ OPAQUE_TRANSFORM */ "AAC001", "AAZ003" FROM "AC20" "A6" WHERE "AAC001"=:1 |
| djmzursc2cgnv | SELECT f_zzxs(:1 , 'ycxff0') as ycxff0, f_zzxs(:2 , 'ycxff') as ycxff, f_zzxs(:3 , 'aae002') as aae002, f_zzxs(:4 , 'dqff') as dqff, f_zzxs(:5 , 'bydqxz') as bydqxz, f_zzxs(:6 , 'ztff') as ztff, f_zzxs(:7 , 'zzrykwbf') as zzrykwbf, f_zzxs(:8 , 'ffzrs') as ffzrs FROM dual |
| dy39awhw0g5px | select a.AAC001 aac001_q, b.aac002 aac002_q, b.aac003 aac003_q, a.AAE009 aae009_q, a.AAE010 aae010_q, d.aab069 aaz065_q, a.AAE016 aae016_q, (select aac003 from ad53a4 where yae092 = a.aae011) aae011_q, a.AAE036 aae036_q, (select aac003 from ad53a4 where yae092 = a.aae014) aae014_q, a.aae013 aae013_q, a.AAE015 aae015_q from yh00_fffs a, ac01 b, af02 c, ae10 d where a.aac001 = b.aac001 and b.aaz070 = c.aaz070 and a.aaz065 = d.aaz001 and c.aaf030 like f_getqx(:1 ) AND a.aae016 =:2 |
| f589xutsqnzcq | SELECT /*+ first_rows*/ a.lsh as lsh, a.sfz as sfz, pkg_common.fun_p_getAge(to_date(b.aac006, 'yyyymmdd'), sysdate, 2) as nl, (select yh_group from ac01 where aac001 = a.aac001) as z, a.xm as xm, a.je as je , a.kkrq as kkrq, a.cgbz as cgbz, a.bz as bz, a.yh as yh, a.zh as zh, a.cz as cz, a.xz as xz, a.dz as dz, a.aac001 as aac001 FROM v1_ad51 a, (select * from ac01 where aab301 like substr(f_getqx(:1 ), 1, 6)) b, af02 d WHERE 1=1 and a.czbm = d.aaz070 and a.aac001 = b.aac001 and d.aaf030 like f_getqx(:2 ) AND cgbz =:3 and a.kkrq >= nvl(:4 , '190001') ||'01' and nvl(:5 , '205001')||'31' >= a.kkrq and kkrq >= nvl(:6 , '19000101') and nvl(:7 , '20500101') >= kkrq AND yhbm =:8 and a.aaa027 = substr(f_getqx(:9 ), 1, 6) |
| fdt65hrn3dngu |
SELECT a.aaz070 as aaz070_q, a.aac001 as aac001_q, f_iy02(c.aac002) as czsfcb, f_sfbdqs(a.aac001) as sfbdqs_q , b.aae140 as aae140_q, a.aae016 as aae016_2_q, a.aae013 as aae013_q, b.aaz165 as aaz165_q, b.aaz158 as aaz158_q, c.aac003 as aac003_q, c.aac002 as aac002_q, c.aac004 as aac004_q, d.aab069 as aab069_5_q, b.aae030 as aae030_q, c.aac005 as aac005_q, c.aae005 as aae005_q, c.aae006 as aae006_q, c.aae007 as aae007_q, c.aac009 as aac009_q, c.aac010 as aac010_q, a.aae011 as aae011_q, a.aae014 as aae014_q, a.aae036 as aae036_q, a.aae015 as aae015_q, c.yh_dabh as yh_dabh_q, nvl(c.aac118, 0) as aac118_q, nvl(c.aac117, 0) as aac117_q, nvl(c.ync301, 0) as ync301_q, nvl(c.ync311, 0) as ync311_q, to_char(c.ync303) ||'-'|| to_char(c.ync304) as ync301_kj_q, to_char(c.ync305) ||'-'|| to_char(c.ync306) as aac117_kj_q, to_char(c.ync307) ||'-'|| to_char(c.ync308) as ync311_kj_q, to_char(c.aac006) as aac006_q, to_char(b.aaz289) as aaz289_q, f.aaa044 as aaa044_q, (SELECT aaa041 FROM aa28 WHERE aaz289=to_char(b.aaz289) AND aae341='1') as aaz289grjf_q, b.aab033 as aab033_q, b.ync309 as ync309_q, to_char(
b.aac049) as aac049_q, (select aac003 from ad53a4 where yae092 = a.aae011) as aae011_q, (select aac003 from ad53a4 where yae092 = a.aae014) as aae014_q, Fun_GetCbSfStr(a.aac001, b.aae140, :1 ) as aac066_q, b.aae200 as aae200_q FROM ac21 a, ac22 b, ac01 c, ae10 d, af02 e, aa05 f WHERE a.aac001 = c.aac001 AND b.aaz289 = f.aaz289 AND a.aac001 = b.aac001 AND c.aaz070 = d.aaz001 AND b.aae140 = '150' AND a.aac001 = b.aac001 AND c.aac002 like '%' || nvl(:2 , '%') || '%' AND c.aac003 like '%' || nvl(:3 , '%') || '%' AND a.aae016 = :4 and a.aaz158 = b.aaz158 and c.aaz070 = e.aaz070 and e.aaf030 like f_getqx(:5 ) and c.yh_dabz=:6 AND to_char(a.aae036, 'yyyymm') >= :7 AND to_char(a.aae036, 'yyyymm') <= :8 |
| fhw2qjm168nwy | SELECT SB_PRSENO.NEXTVAL FROM DUAL |
| fmwsw7rmajwzw | SELECT SQ_AAZ083.NEXTVAL FROM DUAL |
| fmz52d0fyzy8c | select opseno, ordnum from sbds_log where userflag = 'ORA$PIPE$06DC02520002' |
| fwydxrpjbk88h | select to_char(aaz289) as aaz289, to_char(aaa044) as aaa044 from aa05 where aae140 = '150' and AAA027 = f_gettcq(:1 ) and nvl(AAA118, '0') = :2 |
| g114mqn6k9s8k | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PKG_MON_COLLECTPLAN.PROC_MON_COLLECT('201406', '511521', '1000015248', '16', '60', '0', '999999', '20', '53591'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| g387zdv3ct098 | INSERT INTO AC83 VALUES (:B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 , :B9 , :B10 , :B11 , :B12 , :B13 , :B14 , :B15 ) |
| g51ag523qj9va |
SELECT /*+rule+*/ c.aaz288 as aaz288, c.aae002 as aae002, c.aab033 as aab033, c.aae142 as aae142, c.aaa121 as aaa121, c.aae221 as aae221, c.aae281 as aae281, d.aac003 as zsdxmc, c.aaz295 as aaz295 FROM ae23 a, ae25 b, ad21 c, ac01 d WHERE a.aaz083 = b.aaz083 AND c.aaz288 = b.aaz288 AND a.aaz010 = d.aac001 AND a.aae078 = '0' AND NVL(a.aae079, '0') = '0' AND c.aae142 = '5' AND c.aae281 is not null AND c.aab033 = :1 AND c.aaa027 = :2 AND d.aac003 like '%' || :3 || '%' UNION SELECT /*+rule+*/ c.aaz288 as aaz288, c.aae002 as aae002, c.aab033 as aab033, c.aae142 as aae142, c.aaa121 as aaa121, c.aae221 as aae221, c.aae281 as aae281, d.aab069 as zsdxmc, c.aaz295 as aaz295 FROM ae23 a, ae25 b, ad21 c, ae10 d WHERE a.aaz083 = b.aaz083 AND c.aaz288 = b.aaz288 AND a.aaz010 = d.aaz001 AND a.aae078 = '0' AND NVL(a.aae079, '0') = '0' AND c.aae142 = '4' AND c.aae281 is not null AND c.aab033 = :4 AND c.aaa027 = :5 AND d.aab069 like '%' || :6 || '%' UNION SELECT /*+rule+*/ c.aaz288 as aaz288, c.aae002 as aae002, c.aab033 as aab033, c.aae142 as aae142, c.aaa121 as aaa121, c.aa
e221 as aae221, c.aae281 as aae281, d.AAB069 as zsdxmc, c.aaz295 as aaz295 FROM ad21 c, ae23 a, ae25 b, ae10 d WHERE c.aae142 in ('1', '2', '5') AND c.aab033 = :7 AND a.aae078 = '0' AND NVL(a.aae079, '0') = '0' AND a.aaz083 = b.aaz083 AND c.aaz288 = b.aaz288 AND c.aaz295 = d.aaz001 AND c.aae281 is not null AND c.aaa027 = :8 AND d.AAB069 like '%' || :9 || '%' UNION SELECT /*+rule+*/ a.aaz288 as aaz288, a.aae002 as aae002, a.aab033 as aab033, a.aae142 as aae142, a.aaa121 as aaa121, a.aae221 as aae221, a.aae281 as aae281, d.aab069 as zsdxmc, a.aaz295 as aaz295 FROM ad21 a, ae10 d WHERE a.aae142 in ('6', '7', '8', '9', '10', '15') AND a.aab033 = :10 AND a.aaz295 = d.aaz001 AND a.aae281 is not null AND d.aab069 like '%' || :11 || '%' AND a.aaa027 = :12 |
| ghqxnt59samst | SELECT to_char(a.aaz289) as aaz289, a.aaa044 as aaa044 FROM aa05 a WHERE a.aae100 = '1' AND AAA027 = f_gettcq(:1 ) and a.aaa118 = '0' and substr(to_char(sysdate, 'yyyymmdd'), 1, 4)>=a.aae041 and a.aae042>=substr(to_char(sysdate, 'yyyymmdd'), 1, 4) order by aaz289 asc |
| gq30gsj5rcy7r | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PKG_MON_COLLECTPLAN.PROC_MON_COLLECT('201406', '511602', '1000018408', '16', '60', '0', '999999', '20', '53590'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| grj7914jc90zm | select opseno, ordnum from sbds_log where userflag = 'ORA$PIPE$06F404B20002' |
| grjf6kq909a5h |
SELECT AC60.AAC001, AC63.AAE145, AC63.AAZ099, AC60.AAZ157, AC60.AAZ159, AC61.AAA036, '' AAA038, '' AAA085, '1' AAA088, :B2 AAE002, :B2 AAE003, AC61.AAE019, AC63.AAZ003 AAZ003, NVL(AC63.AAZ009, '999999') AAZ009, AC01.AAE006, AC01.AAE007, '150' AAE140, '1' AAA079, AC60.AAA027, AC60.AAZ170 ID, 'ac61' FROM AC60, AC61, AC63, AC01 WHERE AC60.AAZ257 = AC61.AAZ257 AND AC60.AAZ099 = AC63.AAZ099 AND AC60.AAE140 = AC61.AAE140 AND AC60.AAC001 = AC01.AAC001 AND AC61.AAE041 <= :B2 AND (AC61.AAE042 >= :B2 OR AC61.AAE042 IS NULL) AND AC60.AAE116 = '1' AND AC61.AAE140 = '150' AND AC60.AAA027 LIKE :B1 ||'%' UNION ALL SELECT AC01.AAC001, AC74.AAE145, AC74.AAZ097, AC71.AAZ157, AC71.AAZ159, AC73.AAA036, '' AAA038, '' AAA085, '4' AAA088, :B2 AAE002, AC73.AAE041 AAE003, AC73.AAE129 AAE019, AC74.AAZ003 AAZ003, NVL(AC74.AAZ009, '999999') AAZ009, AC01.AAE006, AC01.AAE007, '150' AAE140, '1' AAA079, AC71.AAA027, AC71.AAZ170 ID, 'ac73' FROM AC01, AC73, AC71, AC74 WHERE AC71.AAZ170 = AC73.AAZ170 AND AC71.AAZ002 = AC74.AAZ002 AND AC01.AAC001 = AC71.AAC001 AND AC71.AAE211 = :B2 AND AC73.AAA085 = '0' AND AC71.AAA079 = '1' AND AC71.AAE016 = '1' AND AC71.AAE140 = '150' AND AC71.AAA027 LIKE :B1 ||'%' UNION ALL SELECT AC60.AAC001, AC63.AAE145, AC63.AAZ099, AC75.AAZ157, AC75.AAZ159, AC76.AAA036, '' AAA038, '' AAA085, '2' AAA088, AC76.AAE002 AAE002, AC76.AAE003 AAE003, AC76.AAE129 AAE019, AC63.AAZ003 AAZ003, NVL(AC63.AAZ009, '999999') AAZ009, AC0
1.AAE006, AC01.AAE007, '150' AAE140, '1' AAA079, AC75.AAA027, AC75.AAZ166 ID, 'ac76' FROM AC60, AC76, AC63, AC75, AC01 WHERE AC75.AAZ166 = AC76.AAZ166 AND AC75.AAE140 = AC60.AAE140 AND AC75.AAC001 = AC60.AAC001 AND AC01.AAC001 = AC60.AAC001 AND AC75.AAZ099 = AC63.AAZ099 AND AC76.AAE002 = :B2 AND AC76.AAA078 = '1' AND AC75.AAE016 = '1' AND AC75.AAE140 = '150' AND AC75.AAA027 LIKE :B1 ||'%' UNION ALL SELECT AC66.AAC001, AC63.AAE145, AC63.AAZ099, AC60.AAZ157 AAZ157, AC60.AAZ159 AAZ159, AC66.AAA036, '' AAA038, '' AAA085, '3' AAA088, :B2 AAE002, :B2 AAE003, AC66.AAE019 AAE019, AC63.AAZ003 AAZ003, NVL(AC63.AAZ009, '999999') AAZ009, AC01.AAE006, AC01.AAE007, '150' AAE140, '1' AAA079, AC60.AAA027, AC66.AAZ298 ID, 'ac66' FROM AC60, AC63, AC66, AC01 WHERE AC66.AAC001 = AC60.AAC001 AND AC01.AAC001 = AC60.AAC001 AND AC60.AAE140 = '150' AND AC60.AAE140 = AC66.AAE140 AND AC60.AAZ099 = AC63.AAZ099 AND AC66.AAE019 > 0 AND AC60.AAA027 LIKE :B1 ||'%' |
| gru82x270852w | DELETE FROM SBDS_LOG WHERE USERFLAG = 'ORA$PIPE$06F404B20002' |