| 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 |
| 0j04apvxtp0wn | DELETE FROM SBDS_LOG WHERE USERFLAG = 'ORA$PIPE$071323A90001' |
| 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') |
| 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' |
| 0nvv1fsugkyfm | DELETE FROM SBDS_LOG WHERE USERFLAG = 'ORA$PIPE$06FF00E20001' |
| 0q0bvpr4a3fcy | DELETE FROM SBDS_LOG WHERE USERFLAG = 'ORA$PIPE$06A202280001' |
| 123jjg1kw1qp5 | 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 ) VALUES (:B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B8 , NVL(:B14 , 0), :B16 , :B15 , '0', NULL, NVL(:B14 , 0), NVL(:B14 , 0), :B13 , CASE WHEN :B9 = 1 THEN TO_NUMBER(TO_CHAR(:B12 ) || TO_CHAR(:B8 )) WHEN :B9 = 0 AND :B8 = '1' THEN :B11 WHEN :B9 = 0 AND :B8 IN ('2', '3', '4', '5', '20') THEN :B10 WHEN :B9 = 0 AND :B8 IN ('7', '8', '9', '10', '21') THEN :B7 ELSE 0 END, :B6 , :B5 , '0', NULL, :B4 , :B3 , :B2 , :B1 ) |
| 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) |
| 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 |
| 1t3938j9jw629 | SELECT COUNT(*) FROM AC02 A, AC01 B, AF02 C WHERE A.AAC001 = B.AAC001 AND B.AAZ070 = C.AAZ070 AND EXISTS (SELECT 1 FROM AC53 WHERE AAE341 IN ('10', '21', '7', '8', '9') AND AAC001 = A.AAC001) AND C.AAF015 = :B1 |
| 1z9v9yha73jkx | select id, name, remark , org_id, type from tr_bill where org_id = :1 |
| 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 |
| 2dna8dfbz2s9b | SELECT REPLACE(:1 , '00', '') FROM dual |
| 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 |
| 2pm85n3251vka | 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 a.aae016 = :2 and c.aaz070 = e.aaz070 and e.aaf030 like f_getqx(:3 ) |
| 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 |
| 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)
|
| 3gun43593k2m3 | SELECT a.aae155 as aae155, a.aae123 as aae123, a.aae124 as aae124, b.aae035 as aae035 FROM ac31 a, v_ac30 b, ac01 c, af02 d WHERE a.aaz206 = b.aaz206 AND b.aac001 = :1 and c.aac001 = b.aac001 and c.aaz070 = d.aaz070 and d.aaf030 like f_getqx(:2 ) |
| 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 ) |
| 3vuau78m0v3fy |
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 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 = :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.aaz295 as a
az295 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 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 null AND a.aaa027 = :8 |
| 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; |
| 44ahk80u26y9c | SELECT AAC002 FROM AC01 WHERE AAC001 = :B1 |
| 4cvrw3wwn6jqb |
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 d.aaf013 = :4 AND a.aae016 = :5 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
|
| 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 |
| 4pmxs9mjxfpc9 | SELECT AAZ003 FROM AC63 A WHERE A.AAZ257 = (SELECT AAZ257 FROM AC60 WHERE AAC001 = :B1 ) |
| 4vpph4y6nzfrq | UPDATE ac40 SET aae016 = '2', aae015 = SYSDATE, aae014 = aae011 WHERE aaz192 = :1 |
| 4vrj06q2z5hb0 | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PKG_YHCIP.PRC_TREATMENTPAYPLAN_1('201406' , '1000018556', '20140623', '510304'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 4xbwjav4vnxqf | SELECT COUNT(*) FROM AC53 WHERE AAC001 = :B2 AND SUBSTR(TO_CHAR(AAE228), 1, 4) = :B1 AND AAE341 = '1' |
| 58r4ays02qfhf |
select a.aac001, b.aac003, a.aae001, nvl(sum(aae254 + aae264), 0) personalfee, nvl(sum(aae262 + aae253), 0) colfee, nvl(sum(aae338 + aae348), 0) countyfee, nvl(sum(aae337 + aae346), 0) cityfee, nvl(sum(aae336 + aae344), 0) provincefee, nvl(sum(aae335 + aae342), 0) centerfee, nvl(sum(aae435 + aae442), 0) alldegreefee, nvl(sum(a.aae538 + a.aae548), 0) countyreplacefee, nvl(sum(a.aae537 + a.aae546), 0) cityreplacefee, nvl(sum(a.aae536 + a.aae544), 0) provincereplacefee, nvl(sum(aae257 + aae260 + aae258 + aae261 + aae263 + aae265 + aae267 + aae256 + aae259 +a.aae558+a.aae561+a.aae567 - nvl((aae309 + aae321 + aae284), 0)), 0) interest, nvl(sum(aae250 + aae308), 0) payfee, nvl(sum(aae642+aae635), 0) alldegreereplacefee, nvl(sum(aae254 + aae257 + aae260 + aae253 + aae256 + aae259 + aae255 + aae258 + aae261 + aae264 + aae265 + aae262 + aae263 + aae266 + aae267 +nvl(a.aae555, 0)+nvl(a.aae566, 0)+nvl(a.aae558, 0)+nvl(a.aae561, 0)+nvl(a.aae567, 0)- aae308 - aae309 - aae321 - aae250 - aae284), 0) totalfee from ac51 a, ac01 b, af02 c where a.aac001 = b.aac001 AND b.aaz070 = c.aaz070 and a.aaa027 like substr(f_getqx(:1 ), 1, 6) AND c.aaf030 like (select f_getqx(:2 ) from dual)
group by a.aae001, a.aac001, b.aac003 |
| 5c093y8ckgrcv | SELECT A.AAC066 VARAAC066, A.AAC150 VARAAC150 FROM AC93 A WHERE A.AAC001=:B1 AND A.AAE339=(SELECT MAX(TO_NUMBER(AAE339)) FROM AC93 WHERE AAC001=:B1 ) |
| 5xggrnkkyvajm | BEGIN PKG_MON_TREATMENTPAY.Prc_yhhp(:1 , :2 , :3 , :4 , :5 , :6 , :7 ); END; |
| 642ncvsmb6mmw | select account_name from ma_co_acc where account_id = :1 and co_code=:2 and nd=:3 |
| 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) |
| 690rmf3yzyrs1 | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PKG_MON_COLLECTPLAN.PROC_MON_COLLECT('201406', '510812', '1000023481', '16', '60', '0', '999999', '20', '53790'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 6rw4n0bba5x25 | SELECT COUNT(*) FROM AD53A4 WHERE YAE092 = :B1 |
| 6ypf44q7ctdpn | SELECT MAX(AAF016) FROM AF02 WHERE AAZ070 IN ( SELECT AAZ070 FROM AC01 WHERE AAC001 = :B1 ) |
| 7f92vb43q30pa | SELECT /*+ rule*/ A.aaz083 AS aaz083, A.AAC002 AS aac002, A.AAZ010 AS aaz010, A.AAC003 AS aac003, A.AAE010 AS aae010, A.AAE019 AS aae019, A.AAD017 AS aad017, A.aae354 as aae354, A.aad008 as aad008 FROM AD51 A WHERE a.aaa027 like substr(f_getqx(:1 ), 1, 6) AND a.aaz065 = :2 AND a.aae356 = :3 AND a.aae354 = :4 union all SELECT /*+ rule*/ A.aaz083 AS aaz083, A.AAC002 AS aac002, A.AAZ010 AS aaz010, A.AAC003 AS aac003, A.AAE010 AS aae010, A.AAE019 AS aae019, A.AAD017 AS aad017, A.aae354 as aae354, A.aad008 as aad008 FROM AD51_bak A WHERE a.aaa027 = :5 AND a.aaz065 = :6 AND a.aae356 = :7 AND a.aae354 = :8 |
| 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 |
| 7kz40scmua0zh |
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 AND to_char(a.aae036, 'yyyymm') >= :5 AND to_char(a.aae036, 'yyyymm') <= :6 AND (a.aac001, a.aae036) = (select g.aac001, max(g.aae036) from ac21 g where a.aac001 = g.aac001 group by g.aa
c001 ) |
| 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 |
| 7vkqft51mhqc5 | select cur_name from tr_currency where cur_code=:1 |
| 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; |
| 89ywcjt881yu2 | SELECT NVL(SUM(NVL(AAE019, 0)), 0) FROM AC83 WHERE AAA038 IN ('171', '152', '711', '712', '713', '714', '715', '716') AND AAC001 = :B1 AND AAZ220 IN (SELECT AAZ220 FROM AC84 WHERE AAZ031 = :B2 AND AAE117 = '0') |
| 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 ) |
| 8qnq6nqydybu4 | DELETE FROM SBDS_LOG WHERE USERFLAG = 'ORA$PIPE$06F600240001' |
| 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
|
| 8vcs81rqn6p64 |
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.aaa115 = :5 AND a.aab033 = :6 AND a.aae341 = :7 AND a.aae078 = :8 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, ac0
1
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 = :9 and af.aaz070 = b.aaz070 ) AND a.aaa027 like substr(f_getqx(:10 ), 1, 6) AND a.aae140 = :11 AND a.aaa115 = :12 AND a.aab033 = :13 AND a.aae341 = :14 AND a.aae078 = :15 ) a |
| 8vx2cf81135uu | BEGIN PKG_TJ.REPORT_YH02_SSTJ03_ANY(:1 , :2 , :3 , :4 , :5 , :6 ); END; |
| 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 ) |
| 8xzms4bm8zd55 | SELECT a.aac001 as aac001, a.aac002 as aac002, a.aac003 as aac003, a.aac004 as aac004, a.aac005 as aac005, a.aac006 as aac006, a.aac009 as aac009, a.aac012 as aac012, a.aac010 as aac010, a.aab401 as aab401, b.aaa044 as aaa044, b.aae140 as aae140, b.aaa027 as aaa027, c.aac031 as aac031, d.aaf013 as aaf013, (SELECT aac003 FROM ad53a4 WHERE yae092 = g.aae011) as aae011, (SELECT aac003 FROM ad53a4 WHERE yae092 = g.aae014) as aae014, (select aae015 from ac17 where aac001 = a.aac001) as aae015, (select aae036 from ac17 where aac001 = a.aac001) as aae036, Fun_GetCbSfStr_pzh(a.aac001, b.aae140, :1 ) as aac066, f.aac008 as aac008 FROM ac01 a, aa05 b, ac20 c, af08 d, af02 e, ac02 f, ac21 g WHERE a.aac001 = c.aac001 AND b.aaz289 = c.aaz289 AND d.aaf013 = e.aaf015 AND e.aaz070 = a.aaz070 AND a.aac001 = f.aac001 AND f.aac008 = '1' AND b.aaa027 like substr(f_getqx(:2 ), 1, 6) AND a.aac001 = g.aac001 AND a.aac004 = :3 |
| 97ru394khq0fk | BEGIN PKG_PERSON.PRC_updatePersonInfoCheck(:1 , :2 , :3 , :4 , :5 , :6 ); END; |
| 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 ) |
| 9cnp0w2sqx0tb | 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.aac002 = :3 AND a.yh_dabh >= :4 ||:5 AND a.yh_dabh <= :6 ||:7 |
| 9yr36ajk7pg9p | 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, max(aae036) as aae036 FROM AD54CW, AA26 WHERE AD54CW.aaa027 = AA26.AAB301 AND AD54CW.aab301 = :1 AND aae002 like nvl(:2 , '%') and substr(aae036, 1, 6) like nvl(:3 , '%') AND aaa039 = :4 AND aad027 is not null GROUP BY AAE076, aaa039, aae002, aaa146, aae008 union 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, max(aae036) as aae036 FROM AD54CW_bak, AA26 WHERE AD54CW_bak.aaa027 = AA26.AAB301 AND AD54CW_bak.aab301 = :5 AND aae002 like nvl(:6 , '%') and substr(aae036, 1, 6) like nvl(:7 , '%') AND aaa039 = :8 AND aad027 is not null GROUP BY AAE076, aaa039, aae002, aaa146, aae008) |
| 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 |
| 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 ) |
| ahqpn4gfqkj2a |
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 g.aaf013=: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 ) |
| ap40mq9zqa0nx | SELECT AAB301 FROM AC01 WHERE AAC001 = :B1 |
| 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 ) |
| b6qjnrgsy7cs8 | SELECT COUNT(1) FROM AD54CW WHERE AAD027 IS NULL AND AAB301 = :B1 AND AAE076 IS NULL |
| bcq133nbjxfs9 | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PKG_MON_COLLECTPLAN.PROC_MON_COLLECT('201406', '511524', '1000012854', '16', '60', '0', '999999', '20', '53610'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| bhjpjyxnsvvpp |
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.aaa115 = :5 AND a.aab033 = :6 AND a.aae003 >= :7 AND a.aae003 <= :8 AND a.aae341 = :9 AND a.aae078 = :10 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 aaz1
36
, 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 = :11 and af.aaz070 = b.aaz070 ) AND a.aaa027 like substr(f_getqx(:12 ), 1, 6) AND a.aae140 = :13 AND a.aaa115 = :14 AND a.aab033 = :15 AND a.aae003 >= :16 AND a.aae003 <= :17 AND a.aae341 = :18 AND a.aae078 = :19 ) a |
| bs7sasa31mdjt | BEGIN PKG_TJ.REPORT_SRTJ_NEW (:1 , :2 , :3 , :4 , :5 , :6 ); END; |
| bsmv6fra80vnv | SELECT AAE009, AAE010, AAZ065, (SELECT AAB069 FROM AE10 WHERE AAZ001 = AAZ065) FROM AE03 WHERE AAZ003 = :B1 |
| 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 |
| csqzba6r8u14s | select acc_name from gl_coa_acc where fiscal=:1 and co_code=:2 and account_id=:3 and acc_code=:4 |
| cx5tnw3wsh7hq |
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.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.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.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 1 = 2 AND a.aaa027 = :9 |
| d4vv8g24uj4kn | SELECT AAC001 FROM AC20 WHERE AAZ157 = :B1 |
| dajxzqph3kxc5 | SELECT count(*) cnt FROM AD54CW, AA26 WHERE AD54CW.AAB301 = AA26.AAB301 AND aaa027 = :1 AND aae002 = :2 AND aae076= :3 and aaa039 = :4 AND aad027 is not null and nvl(aae008, 0) = :5 |
| dd0yhdbfypmj9 | SELECT YAB003 FROM AD53A4 WHERE YAE092 = :B1 |
| ddu19g2r02p17 | 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 a.aaa027 = substr(f_getqx(:9 ), 1, 6) |
| 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 |
| duww0h36c6dab | BEGIN pkg_benefit.PRC_Benefit_Check_YH(:1 , :2 , :3 , :4 , :5 , :6 , :7 ); END; |
| dvrd70y5ptnv1 | SELECT a.aaz220, a.aaz219, a.aac001, a. aae002, a.aae003, a.aae019, aae016, (select aac003 from ad53a4 where yae092 = b.aae011) as aae011, b.aae036, (select aac003 from ad53a4 where yae092 = b.aae012) as aae012, aae035 FROM ac83 a, yh00_dyzh b WHERE a.aac001 = b.aac001 and a.aaz220 = b.aaz220 and a.aaa038 in('151', '152') and a.aaz219 = b.aaz219 and b.aae016 in('0', '1') and b.aac001 = :1 order by aae016 |
| 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 |
| f0pm18a7fyphu | 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', '53630'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 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) |
| f63sqjkwsu4a9 | UPDATE AD54CW SET AAE076 = TO_NUMBER(:B3 ), AAD017 = :B2 WHERE AAD027 IS NULL AND AAA027 = :B1 AND AAE076 IS NULL |
| f7gwdpc8nm29x | 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', '53730'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| fhw2qjm168nwy | SELECT SB_PRSENO.NEXTVAL FROM DUAL |
| ftcwgpj0rcvk2 | SELECT b.aaa079 as aaa079, b.aae006 as aae006, b.aae007 as aae007, b.aae010 as aae010, b.aae009 as aae009, c.aaz065 as aaz065 FROM ac60 a, ac74 b, ae03 c, ac01 d, af02 e WHERE a.aaz257 = b.aaz257 AND b.aaz003 = c.aaz003(+) AND a.aac001 = :1 AND a.aac001 = d.aac001 AND d.aaz070 = e.aaz070 and e.aaf030 like f_getqx(:2 ) |
| 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 |
| 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 |
| gp7zuzx9bmx9r | UPDATE AC50 SET AAE238 = NVL(AAE238, 0) + NVL(:B3 , 0), AAE240 = NVL(AAE240, 0) + NVL(:B3 , 0), AAE245 = NVL(AAE245, 0) + NVL(:B3 , 0) * NVL(:B2 , 0) WHERE AAZ116 = :B1 |
| 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 ||'%' |
| grznh8vcqkupq |
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) AND (MONTHS_BETWEEN(TO_DATE(:4 , 'YYYY-MM-DD'), TO_DATE(TO_CHAR(AC01.AAC006), 'YYYY-MM-DD'))) <= 720 |