3468 16:33:48 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3469 16:33:48 SQL Execute: ORACLE - rollback 3470 16:33:48 SQL Data In: ORACLE - Rows affected = 0 3471 16:33:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3472 16:33:48 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3473 16:33:48 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3474 16:33:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3475 16:33:48 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3476 16:33:53 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3477 16:33:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3478 16:33:53 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3479 16:33:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3480 16:33:53 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3481 16:33:53 SQL Execute: ORACLE - rollback 3482 16:33:53 SQL Data In: ORACLE - Rows affected = 0 3483 16:33:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3484 16:33:53 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3485 16:33:53 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3486 16:33:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3487 16:33:53 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3488 16:33:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:33:54 3489 16:33:53 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 3490 16:33:53 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 3491 16:33:58 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3492 16:33:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3493 16:33:58 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3494 16:33:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3495 16:33:58 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3496 16:33:58 SQL Execute: ORACLE - rollback 3497 16:33:58 SQL Data In: ORACLE - Rows affected = 0 3498 16:33:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3499 16:33:58 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3500 16:33:58 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3501 16:33:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3502 16:33:58 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3503 16:34:03 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3504 16:34:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3505 16:34:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3506 16:34:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3507 16:34:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3508 16:34:03 SQL Execute: ORACLE - rollback 3509 16:34:03 SQL Data In: ORACLE - Rows affected = 0 3510 16:34:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3511 16:34:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3512 16:34:03 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3513 16:34:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3514 16:34:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3515 16:34:08 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3516 16:34:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3517 16:34:08 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3518 16:34:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3519 16:34:08 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3520 16:34:08 SQL Execute: ORACLE - rollback 3521 16:34:08 SQL Data In: ORACLE - Rows affected = 0 3522 16:34:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3523 16:34:08 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3524 16:34:08 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3525 16:34:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3526 16:34:08 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3527 16:34:13 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3528 16:34:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3529 16:34:13 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3530 16:34:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3531 16:34:13 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3532 16:34:13 SQL Execute: ORACLE - rollback 3533 16:34:13 SQL Data In: ORACLE - Rows affected = 0 3534 16:34:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3535 16:34:13 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3536 16:34:13 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3537 16:34:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3538 16:34:13 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3539 16:34:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:34:14 3540 16:34:13 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 3541 16:34:13 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 3542 16:34:18 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3543 16:34:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3544 16:34:18 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3545 16:34:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3546 16:34:18 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3547 16:34:18 SQL Execute: ORACLE - rollback 3548 16:34:18 SQL Data In: ORACLE - Rows affected = 0 3549 16:34:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3550 16:34:18 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3551 16:34:18 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3552 16:34:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3553 16:34:18 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3554 16:34:23 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3555 16:34:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3556 16:34:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3557 16:34:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3558 16:34:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3559 16:34:23 SQL Execute: ORACLE - rollback 3560 16:34:23 SQL Data In: ORACLE - Rows affected = 0 3561 16:34:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3562 16:34:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3563 16:34:23 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3564 16:34:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3565 16:34:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3566 16:34:28 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3567 16:34:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3568 16:34:28 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3569 16:34:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3570 16:34:28 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3571 16:34:28 SQL Execute: ORACLE - rollback 3572 16:34:28 SQL Data In: ORACLE - Rows affected = 0 3573 16:34:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3574 16:34:28 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3575 16:34:28 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3576 16:34:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3577 16:34:28 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3578 16:34:33 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3579 16:34:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3580 16:34:33 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3581 16:34:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3582 16:34:33 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3583 16:34:33 SQL Execute: ORACLE - rollback 3584 16:34:33 SQL Data In: ORACLE - Rows affected = 0 3585 16:34:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3586 16:34:33 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3587 16:34:33 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3588 16:34:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3589 16:34:33 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3590 16:34:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:34:34 3591 16:34:33 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 3592 16:34:33 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 3593 16:34:38 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3594 16:34:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3595 16:34:38 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3596 16:34:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3597 16:34:38 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3598 16:34:38 SQL Execute: ORACLE - rollback 3599 16:34:38 SQL Data In: ORACLE - Rows affected = 0 3600 16:34:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3601 16:34:38 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3602 16:34:38 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3603 16:34:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3604 16:34:38 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3605 16:34:43 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3606 16:34:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3607 16:34:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3608 16:34:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3609 16:34:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3610 16:34:43 SQL Execute: ORACLE - rollback 3611 16:34:43 SQL Data In: ORACLE - Rows affected = 0 3612 16:34:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3613 16:34:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3614 16:34:43 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3615 16:34:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3616 16:34:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3617 16:34:48 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3618 16:34:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3619 16:34:48 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3620 16:34:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3621 16:34:48 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3622 16:34:48 SQL Execute: ORACLE - rollback 3623 16:34:48 SQL Data In: ORACLE - Rows affected = 0 3624 16:34:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3625 16:34:48 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3626 16:34:48 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3627 16:34:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3628 16:34:48 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3629 16:34:53 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3630 16:34:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3631 16:34:53 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3632 16:34:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3633 16:34:53 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3634 16:34:53 SQL Execute: ORACLE - rollback 3635 16:34:53 SQL Data In: ORACLE - Rows affected = 0 3636 16:34:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3637 16:34:53 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3638 16:34:53 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3639 16:34:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3640 16:34:53 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3641 16:34:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:34:54 3642 16:34:53 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 3643 16:34:53 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 3644 16:34:58 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3645 16:34:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3646 16:34:58 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3647 16:34:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3648 16:34:58 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3649 16:34:58 SQL Execute: ORACLE - rollback 3650 16:34:58 SQL Data In: ORACLE - Rows affected = 0 3651 16:34:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3652 16:34:58 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3653 16:34:58 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3654 16:34:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3655 16:34:58 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3656 16:35:03 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3657 16:35:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3658 16:35:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3659 16:35:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3660 16:35:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3661 16:35:03 SQL Execute: ORACLE - rollback 3662 16:35:03 SQL Data In: ORACLE - Rows affected = 0 3663 16:35:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3664 16:35:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3665 16:35:03 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3666 16:35:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3667 16:35:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3668 16:35:08 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3669 16:35:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3670 16:35:08 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3671 16:35:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3672 16:35:08 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3673 16:35:08 SQL Execute: ORACLE - rollback 3674 16:35:08 SQL Data In: ORACLE - Rows affected = 0 3675 16:35:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3676 16:35:08 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3677 16:35:08 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3678 16:35:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3679 16:35:08 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3680 16:35:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:35:14 3681 16:35:13 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 3682 16:35:13 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 3683 16:35:13 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3684 16:35:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3685 16:35:13 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3686 16:35:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3687 16:35:13 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3688 16:35:13 SQL Execute: ORACLE - rollback 3689 16:35:13 SQL Data In: ORACLE - Rows affected = 0 3690 16:35:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3691 16:35:13 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3692 16:35:13 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3693 16:35:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3694 16:35:13 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3695 16:35:18 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3696 16:35:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3697 16:35:18 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3698 16:35:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3699 16:35:18 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3700 16:35:18 SQL Execute: ORACLE - rollback 3701 16:35:18 SQL Data In: ORACLE - Rows affected = 0 3702 16:35:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3703 16:35:18 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3704 16:35:18 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3705 16:35:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3706 16:35:18 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3707 16:35:23 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3708 16:35:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3709 16:35:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3710 16:35:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3711 16:35:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3712 16:35:23 SQL Execute: ORACLE - rollback 3713 16:35:23 SQL Data In: ORACLE - Rows affected = 0 3714 16:35:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3715 16:35:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3716 16:35:23 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3717 16:35:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3718 16:35:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3719 16:35:28 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3720 16:35:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3721 16:35:28 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3722 16:35:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3723 16:35:28 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3724 16:35:28 SQL Execute: ORACLE - rollback 3725 16:35:29 SQL Data In: ORACLE - Rows affected = 0 3726 16:35:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3727 16:35:29 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3728 16:35:29 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3729 16:35:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3730 16:35:29 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3731 16:35:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:35:34 3732 16:35:33 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 3733 16:35:33 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 3734 16:35:34 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3735 16:35:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3736 16:35:34 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3737 16:35:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3738 16:35:34 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3739 16:35:34 SQL Execute: ORACLE - rollback 3740 16:35:34 SQL Data In: ORACLE - Rows affected = 0 3741 16:35:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3742 16:35:34 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3743 16:35:34 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3744 16:35:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3745 16:35:34 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3746 16:35:39 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3747 16:35:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3748 16:35:39 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3749 16:35:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3750 16:35:39 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3751 16:35:39 SQL Execute: ORACLE - rollback 3752 16:35:39 SQL Data In: ORACLE - Rows affected = 0 3753 16:35:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3754 16:35:39 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3755 16:35:39 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3756 16:35:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3757 16:35:39 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3758 16:35:44 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3759 16:35:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3760 16:35:44 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3761 16:35:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3762 16:35:44 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3763 16:35:44 SQL Execute: ORACLE - rollback 3764 16:35:44 SQL Data In: ORACLE - Rows affected = 0 3765 16:35:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3766 16:35:44 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3767 16:35:44 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3768 16:35:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3769 16:35:44 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3770 16:35:49 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3771 16:35:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3772 16:35:49 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3773 16:35:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3774 16:35:49 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3775 16:35:49 SQL Execute: ORACLE - rollback 3776 16:35:49 SQL Data In: ORACLE - Rows affected = 0 3777 16:35:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3778 16:35:49 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3779 16:35:49 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3780 16:35:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3781 16:35:49 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3782 16:35:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:35:54 3783 16:35:53 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 3784 16:35:53 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 3785 16:35:54 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3786 16:35:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3787 16:35:54 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3788 16:35:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3789 16:35:54 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3790 16:35:54 SQL Execute: ORACLE - rollback 3791 16:35:54 SQL Data In: ORACLE - Rows affected = 0 3792 16:35:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3793 16:35:54 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3794 16:35:54 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3795 16:35:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3796 16:35:54 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3797 16:35:59 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3798 16:35:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3799 16:35:59 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3800 16:35:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3801 16:35:59 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3802 16:35:59 SQL Execute: ORACLE - rollback 3803 16:35:59 SQL Data In: ORACLE - Rows affected = 0 3804 16:35:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3805 16:35:59 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3806 16:35:59 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3807 16:35:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3808 16:35:59 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3809 16:36:04 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3810 16:36:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3811 16:36:04 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3812 16:36:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3813 16:36:04 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3814 16:36:04 SQL Execute: ORACLE - rollback 3815 16:36:04 SQL Data In: ORACLE - Rows affected = 0 3816 16:36:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3817 16:36:04 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3818 16:36:04 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3819 16:36:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3820 16:36:04 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3821 16:36:09 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3822 16:36:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3823 16:36:09 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3824 16:36:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3825 16:36:09 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3826 16:36:09 SQL Execute: ORACLE - rollback 3827 16:36:09 SQL Data In: ORACLE - Rows affected = 0 3828 16:36:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3829 16:36:09 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3830 16:36:09 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3831 16:36:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3832 16:36:09 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3833 16:36:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:36:14 3834 16:36:13 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 3835 16:36:13 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 3836 16:36:14 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3837 16:36:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3838 16:36:14 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3839 16:36:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3840 16:36:14 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3841 16:36:14 SQL Execute: ORACLE - rollback 3842 16:36:14 SQL Data In: ORACLE - Rows affected = 0 3843 16:36:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3844 16:36:14 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3845 16:36:14 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3846 16:36:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3847 16:36:14 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3848 16:36:19 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3849 16:36:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3850 16:36:19 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3851 16:36:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3852 16:36:19 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3853 16:36:19 SQL Execute: ORACLE - rollback 3854 16:36:19 SQL Data In: ORACLE - Rows affected = 0 3855 16:36:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3856 16:36:19 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3857 16:36:19 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3858 16:36:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3859 16:36:19 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3860 16:36:24 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3861 16:36:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3862 16:36:24 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3863 16:36:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3864 16:36:24 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3865 16:36:24 SQL Execute: ORACLE - rollback 3866 16:36:24 SQL Data In: ORACLE - Rows affected = 0 3867 16:36:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3868 16:36:24 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3869 16:36:24 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3870 16:36:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3871 16:36:24 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3872 16:36:29 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3873 16:36:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3874 16:36:29 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3875 16:36:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3876 16:36:29 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3877 16:36:29 SQL Execute: ORACLE - rollback 3878 16:36:29 SQL Data In: ORACLE - Rows affected = 0 3879 16:36:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3880 16:36:29 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3881 16:36:29 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3882 16:36:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3883 16:36:29 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3884 16:36:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:36:34 3885 16:36:33 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 3886 16:36:33 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 3887 16:36:34 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3888 16:36:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3889 16:36:34 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3890 16:36:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3891 16:36:34 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3892 16:36:34 SQL Execute: ORACLE - rollback 3893 16:36:34 SQL Data In: ORACLE - Rows affected = 0 3894 16:36:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3895 16:36:34 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3896 16:36:34 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3897 16:36:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3898 16:36:34 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3899 16:36:39 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3900 16:36:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3901 16:36:39 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3902 16:36:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3903 16:36:39 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3904 16:36:39 SQL Execute: ORACLE - rollback 3905 16:36:39 SQL Data In: ORACLE - Rows affected = 0 3906 16:36:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3907 16:36:39 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3908 16:36:39 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3909 16:36:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3910 16:36:39 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3911 16:36:44 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3912 16:36:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3913 16:36:44 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3914 16:36:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3915 16:36:44 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3916 16:36:44 SQL Execute: ORACLE - rollback 3917 16:36:44 SQL Data In: ORACLE - Rows affected = 0 3918 16:36:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3919 16:36:44 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3920 16:36:44 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3921 16:36:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3922 16:36:44 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3923 16:36:49 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3924 16:36:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3925 16:36:49 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3926 16:36:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3927 16:36:49 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3928 16:36:49 SQL Execute: ORACLE - rollback 3929 16:36:49 SQL Data In: ORACLE - Rows affected = 0 3930 16:36:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3931 16:36:49 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3932 16:36:49 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3933 16:36:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3934 16:36:49 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3935 16:36:52 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2832.000000 3936 16:36:52 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2275.000000 3937 16:36:52 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 133516788.000000 3938 16:36:52 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 3939 16:36:52 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 2832 and CZXH00 = 133516788.00) 3940 16:36:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:36:54 3941 16:36:53 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 3942 16:36:53 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 3943 16:36:54 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3944 16:36:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3945 16:36:54 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3946 16:36:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3947 16:36:54 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3948 16:36:54 SQL Execute: ORACLE - rollback 3949 16:36:54 SQL Data In: ORACLE - Rows affected = 0 3950 16:36:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3951 16:36:54 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3952 16:36:54 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3953 16:36:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3954 16:36:54 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3955 16:36:59 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3956 16:36:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3957 16:36:59 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3958 16:36:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3959 16:36:59 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3960 16:36:59 SQL Execute: ORACLE - rollback 3961 16:36:59 SQL Data In: ORACLE - Rows affected = 0 3962 16:36:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3963 16:36:59 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3964 16:36:59 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3965 16:36:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3966 16:36:59 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3967 16:37:04 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3968 16:37:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3969 16:37:04 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3970 16:37:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3971 16:37:04 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3972 16:37:04 SQL Execute: ORACLE - rollback 3973 16:37:04 SQL Data In: ORACLE - Rows affected = 0 3974 16:37:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3975 16:37:04 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3976 16:37:04 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3977 16:37:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3978 16:37:04 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3979 16:37:09 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3980 16:37:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3981 16:37:09 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3982 16:37:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3983 16:37:09 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3984 16:37:09 SQL Execute: ORACLE - rollback 3985 16:37:09 SQL Data In: ORACLE - Rows affected = 0 3986 16:37:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3987 16:37:09 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3988 16:37:09 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3989 16:37:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3990 16:37:09 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3991 16:37:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:37:14 3992 16:37:13 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 3993 16:37:13 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 3994 16:37:14 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3995 16:37:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3996 16:37:14 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3997 16:37:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 3998 16:37:14 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 3999 16:37:14 SQL Execute: ORACLE - rollback 4000 16:37:14 SQL Data In: ORACLE - Rows affected = 0 4001 16:37:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4002 16:37:14 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 4003 16:37:14 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4004 16:37:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4005 16:37:14 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 4006 16:37:19 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4007 16:37:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4008 16:37:19 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 4009 16:37:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4010 16:37:19 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 4011 16:37:19 SQL Execute: ORACLE - rollback 4012 16:37:19 SQL Data In: ORACLE - Rows affected = 0 4013 16:37:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4014 16:37:19 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 4015 16:37:19 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4016 16:37:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4017 16:37:19 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 4018 16:37:24 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4019 16:37:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4020 16:37:24 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 4021 16:37:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4022 16:37:24 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 4023 16:37:24 SQL Execute: ORACLE - rollback 4024 16:37:24 SQL Data In: ORACLE - Rows affected = 0 4025 16:37:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4026 16:37:24 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 4027 16:37:24 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4028 16:37:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4029 16:37:24 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 4030 16:37:29 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4031 16:37:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4032 16:37:29 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 4033 16:37:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4034 16:37:30 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 4035 16:37:30 SQL Execute: ORACLE - rollback 4036 16:37:30 SQL Data In: ORACLE - Rows affected = 0 4037 16:37:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4038 16:37:30 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 4039 16:37:30 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4040 16:37:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4041 16:37:30 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 4042 16:37:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 203 4043 16:37:30 SQL Execute: ORACLE - select ZT0000 from BM_CKBM00 where CKBH00 = ? 4044 16:37:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 203 4045 16:37:30 SQL Execute: ORACLE - select count(*) from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3,'YYYYMMDD') and ZT0000 ='0' and YFBMBH=2275 and PYCKBH = ? 4046 16:37:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 203 4047 16:37:32 SQL Execute: ORACLE - update BM_CKBM00 set ZT0000 = '2', JQMC00=null,TCRQSJ=to_char(sysdate,'yyyymmdd hh24:mi:ss') where CKBH00 = ? 4048 16:37:32 SQL Data In: ORACLE - Rows affected = 1 4049 16:37:32 SQL Execute: ORACLE - commit 4050 16:37:32 SQL Data In: ORACLE - Rows affected = 0 4051 16:37:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 203 4052 16:37:32 SQL Execute: ORACLE - select ZT0000 from BM_CKBM00 where CKBH00 = ? 4053 16:37:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 303 4054 16:37:32 SQL Execute: ORACLE - select ZT0000 from BM_CKBM00 where CKBH00 = ? and JQMC00='SRM-20240805WSM' 4055 16:37:32 SQL Execute: ORACLE - RollBack 4056 16:37:32 SQL Data In: ORACLE - Rows affected = 0 4057 16:37:32 SQL Execute: ORACLE - Commit 4058 16:37:32 SQL Data In: ORACLE - Rows affected = 0 4059 16:37:32 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000= 21740847 4060 16:37:32 SQL Data In: ORACLE - Rows affected = 1 4061 16:37:32 SQL Execute: ORACLE - Commit 4062 16:37:32 SQL Data In: ORACLE - Rows affected = 0 4063 16:37:39 Log started for: 易联众医院信息综合管理平台 4064 16:37:39 SQL Execute: ORACLE - Select * from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 4065 16:37:39 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,BZ0000) select '129.7.13.226','99',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4066 16:37:39 SQL Data In: ORACLE - Rows affected = 1 4067 16:37:39 SQL Execute: ORACLE - Commit 4068 16:37:39 SQL Data In: ORACLE - Rows affected = 0 4069 16:37:39 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 4070 16:37:39 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='00498' and CZBZ00 in ('0','1') 4071 16:37:39 SQL Execute: ORACLE - select count(*) COUNT0 from XT_XTYCRZ where XKH000 = '00498' and YCLBBZ ='0' and CLBZ00 = '0' 4072 16:37:39 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_YHMMZDCSCS' 4073 16:37:39 SQL Execute: ORACLE - select distinct XTDM00,XTMC00,XTBMXZ,DLFS00,TPSYH0,BJTP00,XTBB00,BBXH00 from VW_XT_YHBMQX_EXT where YGBH00=2832 and XTDM00 not in ('OE','MC') order by XTDM00 4074 16:37:39 SQL Execute: ORACLE - Select SYSDATE from Dual 4075 16:37:39 SQL Execute: ORACLE - Select SYSDATE from Dual 4076 16:37:39 SQL Execute: ORACLE - select XKH000,ZWXM00,BMBH00,BMMC00,BMYYID,BMYYMC,YBYGDM,YBYGDM_EX from VW_BM_YGBM00_EXT where YGBH00= 2832 4077 16:37:39 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where YGBH00 = 2832 4078 16:37:39 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where DECODE(SYXT00,NULL,'-1',SYXT00) in ('999','-1') 4079 16:37:40 SQL Execute: ORACLE - select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 4080 16:37:40 SQL Execute: ORACLE - select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 4081 16:37:40 SQL Execute: ORACLE - select SJKYH0,DBBB00 from XT_DBMS00 where upper(SJKYH0) = upper('sd_hospital') 4082 16:37:40 SQL Execute: ORACLE - select INSTANCE_NAME,HOST_NAME from V$INSTANCE 4083 16:37:40 SQL Execute: ORACLE - select ZBDM00 from XT_YHZB00 where YGBH00 = 2832 4084 16:37:40 SQL Execute: ORACLE - select YGBH00,YGXKH0,YGXM00,JSID00,JSMC00,JSDESC,JSLX00 from VW_PT_YGJSB0 where YGBH00 = 2832 4085 16:37:40 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000= '129.7.13.226' 4086 16:37:40 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_MMQDYZTSDJ' 4087 16:37:40 SQL Execute: ORACLE - select YGBH00,XKH000,ZWXM00,XTDM00,XTMC00,DLKS00,BMMC00,DLRQSJ from VW_XT_XTDLRZ where YGBH00 = 2832 and RowNum <= 10 order by DLRQSJ DESC 4088 16:37:40 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 2832 and XTDM00='2' order by BMPLXH,BMBH00 4089 16:37:41 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 2832 and XTDM00='R' order by BMPLXH,BMBH00 4090 16:37:41 SQL Execute: ORACLE - select MKNBMC from VW_XT_XTKJMK where XTDM00='R' and KJLB00 ='3' 4091 16:37:41 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKWBJC,KJLB00,KJJ000,XH0000,TBSYH0,KJQDFS from VW_XT_XTKJMK where XTDM00 = 'R' and KJLB00 < '3' order by XH0000 4092 16:37:41 SQL Execute: ORACLE - select * from XT_XTCS00 where instr(','||SYXT00||',',','||'R'||',')>0 4093 16:37:41 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKDLL0,TBSYH0 from VW_PT_YHGNMK where YGBH00 = 2832 and XTDM00 = 'R' 4094 16:37:41 SQL Execute: ORACLE - select XTDM00,JHGNID,RQLMC0,KJNAME,KJLMC0,KJMS00,MKNBMC,MKDLL0 from VW_XT_XTGNKJ where XTDM00 = 'R' 4095 16:37:41 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 2275 and FLAG00 like '0' order by decode(CKBH00,523,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 4096 16:37:41 SQL Execute: ORACLE - select * from XT_XTLJ00 where (SID000,SERIAL) in (select to_char(SID),to_char(serial#) from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)) 4097 16:37:41 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,SERIAL,BZ0000,JCID00) select '129.7.13.226','R',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@',AUDSID from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4098 16:37:41 SQL Data In: ORACLE - Rows affected = 1 4099 16:37:41 SQL Execute: ORACLE - Commit 4100 16:37:41 SQL Data In: ORACLE - Rows affected = 0 4101 16:37:41 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 4102 16:37:41 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select to_char(SID),to_char(SERIAL#) from V$session where AUDSID= userenv('SESSIONID')) 4103 16:37:41 SQL Execute: ORACLE - insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00,IP0000) values(21740851,2832,'SRM-20240805WSM','R',nvl('403488877',' '),'129.7.13.226#1707:2939@appYLZHis.exe',2275,'129.7.13.226') 4104 16:37:41 SQL Data In: ORACLE - Rows affected = 1 4105 16:37:41 SQL Execute: ORACLE - Commit 4106 16:37:41 SQL Data In: ORACLE - Rows affected = 0 4107 16:37:41 SQL Execute: ORACLE - select count(*) from VW_XT_YHKJMK where YGBH00=2832 and XTDM00='R' 4108 16:37:42 SQL Execute: ORACLE - select * from XT_BJCS00 where IP0000 = '129.7.13.226' and NAME00 = 'QDXTJZ' 4109 16:37:42 SQL Execute: ORACLE - select JGID00,MKNBMC,MKWBMC,XTDM00,MKDLL0,JGLB00,FJGID0,XH0000,MKFGF0,XSLB00,TBSYH0 from ( select a.JGID00,a.MKNBMC,a.MKWBMC,a.XTDM00,a.MKDLL0,a.JGLB00,a.FJGID0,a.XH0000,a.MKFGF0,a.XSLB00, -1 as TBSYH0 from XT_MKJG00 a where a.JGLB00+0 =0 and a.XTDM00 = 'R' union all select a.JGID00,a.MKNBMC,a.MKWBMC,a.XTDM00,a.MKDLL0,a.JGLB00,a.FJGID0,a.XH0000,a.MKFGF0,a.XSLB00,a.TBSYH0 from VW_PT_YHCDMK_JG a where YGBH00 = 2832 and XTDM00 = 'R') c order by c.XH0000,c.JGLB00,c.FJGID0,c.JGID00 4110 16:37:42 SQL Execute: ORACLE - select MKNBMC,MKWBMC,XTDM00,MKDLL0,TBSYH0 from VW_PT_YHCDMK where YGBH00 = 2832 and XTDM00= '+' and MKDLL0 in ('DLL_GGMK_ZHYW.dll','DLL_GGMK_CXTJ.dll') 4111 16:37:42 SQL Execute: ORACLE - select KJID00,YGBH00,XTDM00,MKNBMC,MKWBMC,MKDLL0,XH0000,TBSYH0 from VW_XT_YHKJMK where YGBH00=2832 and XTDM00='R' order by XH0000 4112 16:37:42 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2832.000000 4113 16:37:42 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2275.000000 4114 16:37:42 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 4115 16:37:42 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 4116 16:37:42 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2832.000000 4117 16:37:42 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2275.000000 4118 16:37:42 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 133516795.000000 4119 16:37:42 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 4120 16:37:42 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 2832 and CZXH00 = 133516795.00) 4121 16:37:42 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL' 4122 16:37:42 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='R' 4123 16:37:42 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 4124 16:37:42 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 4125 16:37:42 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 4126 16:37:42 SQL Execute: ORACLE - select BMXZ00 from BM_BMBM00 where BMBH00=2275 4127 16:37:42 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00=2275 4128 16:37:42 SQL Execute: ORACLE - select max(YYJC00) as YYJC00 from XT_YYXX00 where YYID00='220006' 4129 16:37:42 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from DUAL 4130 16:37:42 SQL Execute: ORACLE - select SF_XT_GETDJSFEXIST as SFBZDJ from dual 4131 16:37:42 SQL Execute: ORACLE - select SF_XT_GETSFDJBYBMBH(2275) as SFBZDJ from dual 4132 16:37:42 SQL Execute: ORACLE - select * from VW_XT_BGSZJY where MKDLL0 = 'DLL_MZPY_ZHYW.dll' and YGBH00 = 2832 and XTDM00 = 'R' 4133 16:37:42 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 = '门诊审方退回原因' and LBBZ00='0' order by XSXH00 4134 16:37:42 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保追溯码配置' and BH0000 = 'YBZSMSFQY' 4135 16:37:42 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保追溯码配置' and BH0000 = 'YF_SFZZSM' 4136 16:37:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 203 4137 16:37:42 SQL Execute: ORACLE - select JZCKBZ from BM_CKBM00 where CKBH00 = ? 4138 16:37:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 303 4139 16:37:42 SQL Execute: ORACLE - select BMBH00 from BM_CKBM00 where CKBH00 = ? 4140 16:37:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 303 4141 16:37:42 SQL Execute: ORACLE - select BMBH00 from BM_CKBM00 where CKBH00 = ? 4142 16:37:42 SQL Execute: ORACLE - select ZWXM00||'|'||XKH000 from VW_PY_PYXTRY A 4143 16:37:42 SQL Execute: ORACLE - select SF_PY_GetYFLB(2275) from dual 4144 16:37:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 303 4145 16:37:42 SQL Execute: ORACLE - select CKMC00 from VW_BM_CKBM00 where CKBH00 = ? 4146 16:37:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 203 4147 16:37:42 SQL Execute: ORACLE - select CKMC00 from VW_BM_CKBM00 where CKBH00 = ? 4148 16:37:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 303 4149 16:37:42 SQL Execute: ORACLE - select ZT0000 from BM_CKBM00 where CKBH00 = ? 4150 16:37:42 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '取药队列字典' and BH0000 = 'DSFBYJK_MZ' 4151 16:37:42 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '排队叫号通用接口参数配置' and BH0000 = 'PDJHJK_YFBMBH' 4152 16:37:42 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '排队叫号通用接口参数配置' and BH0000 = 'PDJHJK_SFQY' 4153 16:37:42 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '发药信息推送接口配置' and BH0000 = 'QY' 4154 16:37:42 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='发药信息推送接口配置' 4155 16:37:42 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'CA认证接口配置' and BH0000 = 'CA_QY' 4156 16:37:42 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'CA认证接口配置' and BH0000 = 'CA_YFQY' 4157 16:37:42 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'CA认证接口配置' and BH0000 = 'CA_PYCKQY' 4158 16:37:42 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'CA认证接口配置' and BH0000 = 'CA_PYCKQY' 4159 16:37:42 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='CA认证接口配置' 4160 16:37:42 SQL Execute: ORACLE - select * from BM_SZZSXX where YGBH00 = 2832 4161 16:37:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = YWX 4162 16:37:42 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 4163 16:37:42 SQL Execute: ORACLE - select SF_YF_CAURL0( ?,? ) from dual 4164 16:37:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = YWX 4165 16:37:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 02 4166 16:37:45 SQL Execute: ORACLE - select SF_YF_CAURL0( ?,? ) from dual 4167 16:37:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = YWX 4168 16:37:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 02 4169 16:37:49 SQL Execute: ORACLE - select SF_YF_CAURL0( ?,? ) from dual 4170 16:37:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = YWX 4171 16:37:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 02 4172 16:37:52 SQL Execute: ORACLE - select SF_YF_CAURL0( ?,? ) from dual 4173 16:37:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = YWX 4174 16:37:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 02 4175 16:37:55 SQL Execute: ORACLE - select SF_YF_CAURL0( ?,? ) from dual 4176 16:37:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = YWX 4177 16:37:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 02 4178 16:37:58 SQL Execute: ORACLE - select SF_YF_CAURL0( ?,? ) from dual 4179 16:38:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = YWX 4180 16:38:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 02 4181 16:38:01 SQL Execute: ORACLE - select SF_YF_CAURL0( ?,? ) from dual 4182 16:38:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈成辉 4183 16:38:01 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where ZWXM00 = ? 4184 16:38:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈成辉 4185 16:38:01 SQL Execute: ORACLE - select XKH000 from BM_YGBM00 where ZWXM00 = ? 4186 16:38:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:38:02 4187 16:38:01 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4188 16:38:01 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4189 16:38:01 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '3' order by FYDLXH desc ) A 4190 16:38:01 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子病历与电子申请单配置' and BH0000 = 'MZDZBL_CJ' 4191 16:38:01 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,2832,'陈成辉','129.7.13.226','6C-4B-90-74-EE-7F','R','ACT_PY_MZPYXT','403488877') 4192 16:38:01 SQL Data In: ORACLE - Rows affected = 1 4193 16:38:01 SQL Execute: ORACLE - Commit 4194 16:38:01 SQL Data In: ORACLE - Rows affected = 0 4195 16:38:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:38:02 4196 16:38:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4197 16:38:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4198 16:38:05 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL' 4199 16:38:05 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='R' 4200 16:38:05 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 4201 16:38:05 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 4202 16:38:05 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 4203 16:38:09 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL' 4204 16:38:09 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='R' 4205 16:38:09 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 4206 16:38:09 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 4207 16:38:09 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 4208 16:38:09 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'CA认证接口配置' and BH0000 = 'CA_QY' 4209 16:38:09 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'CA认证接口配置' and BH0000 = 'CA_YFQY' 4210 16:38:09 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'CA认证接口配置' and BH0000 = 'CA_PYCKQY' 4211 16:38:09 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'CA认证接口配置' and BH0000 = 'CA_PYCKQY' 4212 16:38:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 203 4213 16:38:09 SQL Execute: ORACLE - select BMBH00 from BM_CKBM00 where CKBH00 = ? 4214 16:38:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 203 4215 16:38:09 SQL Execute: ORACLE - select JQMC00 from BM_CKBM00 where CKBH00 = ? and ZT0000='0' and JQMC00 is not null 4216 16:38:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 203 4217 16:38:09 SQL Execute: ORACLE - select count(*) from YF_PYCKRY where PYCKBH = ? and YGBH00 is not null and RYZT00 = '1' 4218 16:38:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 203 4219 16:38:09 SQL Execute: ORACLE - select CKMC00 from VW_BM_CKBM00 where CKBH00 = ? 4220 16:38:09 SQL Execute: ORACLE - select SF_PY_GetYFLB(2275) from dual 4221 16:38:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 203 4222 16:38:09 SQL Execute: ORACLE - select count(*) from YF_PYCKRY where PYCKBH = ? and YGBH00 is not null and RYZT00 = '1' 4223 16:38:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 203 4224 16:38:09 SQL Execute: ORACLE - select JQMC00 from BM_CKBM00 where CKBH00 = ? and ZT0000 = '0' and JQMC00 is not null 4225 16:38:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 203 4226 16:38:09 SQL Execute: ORACLE - update BM_CKBM00 set ZT0000 = '0', JQMC00='SRM-20240805WSM',GZRQSJ=to_char(sysdate,'yyyymmdd hh24:mi:ss') where CKBH00 = ? 4227 16:38:09 SQL Data In: ORACLE - Rows affected = 1 4228 16:38:09 SQL Execute: ORACLE - commit 4229 16:38:09 SQL Data In: ORACLE - Rows affected = 0 4230 16:38:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 203 4231 16:38:09 SQL Execute: ORACLE - select ZT0000 from BM_CKBM00 where CKBH00 = ? 4232 16:38:09 SQL Execute: ORACLE - select A.CFLSH0 from yf_mzcf00 A,SF_BRXXB0 B where A.GHID00=B.GHID00 and B.SJLY00 = '2' and A.CFZT00='1' and A.JZRQ00 >= to_char( sysdate - 1,'YYYYMMDD') and not exists ( select 1 from YF_CFDL00 M where M.CFLSH0 = A.CFLSH0) 4233 16:38:09 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4234 16:38:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4235 16:38:09 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 4236 16:38:09 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,2832,'陈成辉','129.7.13.226','6C-4B-90-74-EE-7F','R','ACT_PY_PYDY00','403488877') 4237 16:38:09 SQL Data In: ORACLE - Rows affected = 1 4238 16:38:09 SQL Execute: ORACLE - Commit 4239 16:38:09 SQL Data In: ORACLE - Rows affected = 0 4240 16:38:14 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4241 16:38:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4242 16:38:14 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 4243 16:38:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4244 16:38:14 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 4245 16:38:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = YWX 4246 16:38:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 04 4247 16:38:14 SQL Execute: ORACLE - select SF_YF_CAURL0( ?,? ) from dual 4248 16:38:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = YWX 4249 16:38:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4250 16:38:14 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 4251 16:38:14 SQL Execute: ORACLE - select SF_CA_POSTHS( ?,?,? ) from dual 4252 16:38:14 SQL Execute: ORACLE - select nvl(A.FYR000,2832) FYR000,nvl(A.PFR000,2832) PFR000 from YF_MZCF00 A where A.CFLSH0 = '47931122' 4253 16:38:14 SQL Execute: ORACLE - select * from BM_SZZSXX where YGBH00 = 2832 4254 16:38:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = YWX 4255 16:38:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 07 4256 16:38:14 SQL Execute: ORACLE - select SF_YF_CAURL0( ?,? ) from dual 4257 16:38:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = YWX 4258 16:38:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2832 4259 16:38:14 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 35, Scale = 0, Data = e1db16f7cd56dfaaq06e4wc4d0y40020e78 4260 16:38:14 SQL Execute: ORACLE - select SF_CA_ZDQMSC2( ?,?,? ) from dual 4261 16:38:14 SQL Execute: ORACLE - select SQ_JK_WZTJK0_SID000.NEXTVAL from dual 4262 16:38:14 SQL Execute: ORACLE - select SF_CA_POSTXX( 'YWX',2832,'47931122','0','791|0QeUe9sqpTxeToFKSaOEAXhbKDXRBAs+DUWrKAkanvs=' ) from dual 4263 16:38:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = YWX 4264 16:38:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 05 4265 16:38:15 SQL Execute: ORACLE - select SF_YF_CAURL0( ?,? ) from dual 4266 16:38:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 791 4267 16:38:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4268 16:38:15 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2832 4269 16:38:15 SQL Execute: ORACLE - insert into JK_WZTJK0(SID000,SCCJ00,QRCID0,PIC640,SIGN64,SCCZY0) values ( ?,'CA_DATAQM',?,?,?,?) 4270 16:38:16 SQL Data In: ORACLE - Rows affected = 1 4271 16:38:16 SQL Execute: ORACLE - Commit 4272 16:38:16 SQL Data In: ORACLE - Rows affected = 0 4273 16:38:16 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'CA认证接口配置' and BH0000 = 'CA_QYPYYMS' 4274 16:38:16 SQL Execute: ORACLE - select * from BM_SZZSXX where YGBH00 = 2832 4275 16:38:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = YWX 4276 16:38:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 07 4277 16:38:16 SQL Execute: ORACLE - select SF_YF_CAURL0( ?,? ) from dual 4278 16:38:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = YWX 4279 16:38:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2832 4280 16:38:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 35, Scale = 0, Data = e1db16f7cd56dfaaq06e4wc4d0y40020e78 4281 16:38:16 SQL Execute: ORACLE - select SF_CA_ZDQMSC2( ?,?,? ) from dual 4282 16:38:16 SQL Execute: ORACLE - select SQ_JK_WZTJK0_SID000.NEXTVAL from dual 4283 16:38:16 SQL Execute: ORACLE - select SF_CA_POSTXX( 'YWX',2832,'47931122','0','792|0QeUe9sqpTxeToFKSaOEAXhbKDXRBAs+DUWrKAkanvs=' ) from dual 4284 16:38:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = YWX 4285 16:38:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 05 4286 16:38:16 SQL Execute: ORACLE - select SF_YF_CAURL0( ?,? ) from dual 4287 16:38:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 792 4288 16:38:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4289 16:38:17 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2832 4290 16:38:17 SQL Execute: ORACLE - insert into JK_WZTJK0(SID000,SCCJ00,QRCID0,PIC640,SIGN64,SCCZY0) values ( ?,'CA_DATAQM',?,?,?,?) 4291 16:38:17 SQL Data In: ORACLE - Rows affected = 1 4292 16:38:17 SQL Execute: ORACLE - Commit 4293 16:38:17 SQL Data In: ORACLE - Rows affected = 0 4294 16:38:17 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 4295 16:38:17 SQL Data In: ORACLE - Param = 2, Name = PCFLSH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4296 16:38:17 SQL Data In: ORACLE - Param = 3, Name = PFHRBH0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2832 4297 16:38:17 SQL Data In: ORACLE - Param = 4, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2832 4298 16:38:17 SQL Data In: ORACLE - Param = 5, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2275 4299 16:38:17 SQL Data In: ORACLE - Param = 6, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 4300 16:38:17 SQL Data In: ORACLE - Param = 7, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 4301 16:38:17 SQL Data In: ORACLE - Param = 8, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 4302 16:38:17 SQL Data In: ORACLE - Param = 9, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 4303 16:38:17 SQL Data In: ORACLE - Param = 10, Name = PPFR000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 4304 16:38:17 SQL Execute: ORACLE - BEGIN "SP_PY_MZPFYCZ" (POPFLAG => :POPFLAG,PCFLSH0 => :PCFLSH0,PFHRBH0 => :PFHRBH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PPFR000 => :PPFR000); END; 4305 16:38:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 25, Scale = 0, Data = MZPY_SFBDYPRINTMZPY_FYBQ1 4306 16:38:17 SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 4307 16:38:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 15, Scale = 0, Data = MZPY_CFEWMDYJSZ 4308 16:38:17 SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 4309 16:38:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 25, Scale = 0, Data = MZPY_SFBDYPRINTMZPY_FYBQ1 4310 16:38:17 SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 4311 16:38:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = MZPY_CFDYPAHWHPX 4312 16:38:17 SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 4313 16:38:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2832 4314 16:38:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4315 16:38:17 SQL Execute: ORACLE - select dycs00,decode(dycs00,0,'',1,'(重制)','(重制第'||to_char(dycs00)||'次)')as dycz00,decode(nvl(SFCAQM,'0'),'1',(select DZQM00 from BM_ZJ0000 where YGBH00=?)) DZQM00 from yf_mzcf00 WHERE CFLSH0 = ? 4316 16:38:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4317 16:38:17 SQL Execute: ORACLE - select a.* from VW_PY_BRCF00_MSQL a WHERE a.CFLSH0 = ? 4318 16:38:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4319 16:38:17 SQL Execute: ORACLE - select substr(ypmc00,1,10)as ypmc00,a.* from VW_PY_BRCFMX_DSQL a WHERE a.CFLSH0 = ? order by QWM000,CFID00 4320 16:38:17 SQL Execute: ORACLE - select nvl(SF_PY_PYBZ00('47931122'),' ') as PYBZ00 from dual 4321 16:38:17 SQL Execute: ORACLE - select '*' as BZ0000,' ' szs from dual 4322 16:38:17 SQL Execute: ORACLE - select 2832 as UserId,'00498' as UserCode,'陈成辉' as UserName,2275 as UserLogDepId,'西药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'220006' as HospitalCode,'福建中医药大学附属人民医院' as HospitalName, '220006' as UserLogDepYYID,'福建中医药大学附属人民医院' as UserLogDepYYMC from dual 4323 16:38:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:38:23 4324 16:38:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4325 16:38:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4326 16:38:25 SQL Execute: ORACLE - update YF_MZCF00 set CFBDCS = nvl(CFBDCS, 0) + 1,DYCS00=nvl(DYCS00, 0) + 1 where CFLSH0 = '47931122' 4327 16:38:25 SQL Data In: ORACLE - Rows affected = 1 4328 16:38:25 SQL Execute: ORACLE - Commit 4329 16:38:25 SQL Data In: ORACLE - Rows affected = 0 4330 16:38:25 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '门诊配药_接收预配药_打印药签顺序' and BH0000 = '0' 4331 16:38:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 25, Scale = 0, Data = MZPY_SFBDYPRINTMZPY_FYBQ1 4332 16:38:25 SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 4333 16:38:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = MZPY_SFHQHZJYEWM 4334 16:38:25 SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 4335 16:38:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = MZPY_SFHQHZJYEWMBM 4336 16:38:25 SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 4337 16:38:25 SQL Execute: ORACLE - select SF_SQSF_HLYY_HZJY_ESB_Content('47931122','0', 220006) as content from dual 4338 16:38:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = YS_JCPTURL 4339 16:38:25 SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 4340 16:38:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4341 16:38:25 SQL Execute: ORACLE - select count(*) from VW_PY_FYBQ00_MSQL where CFLSH0 = ? 4342 16:38:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4343 16:38:25 SQL Execute: ORACLE - select dycs00,decode(dycs00,0,'','重制')as dycz00 from yf_mzcf00 WHERE CFLSH0 = ? 4344 16:38:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4345 16:38:25 SQL Execute: ORACLE - select a.*, ' ' as QRURL0 from VW_PY_FYBQ00_MSQL a where a.CFLSH0 = ? 4346 16:38:25 SQL Execute: ORACLE - select 2832 as UserId,'00498' as UserCode,'陈成辉' as UserName,2275 as UserLogDepId,'西药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'220006' as HospitalCode,'福建中医药大学附属人民医院' as HospitalName, '220006' as UserLogDepYYID,'福建中医药大学附属人民医院' as UserLogDepYYMC from dual 4347 16:38:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 47931122 4348 16:38:28 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 4349 16:38:28 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4350 16:38:33 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4351 16:38:33 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4352 16:38:38 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4353 16:38:38 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4354 16:38:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:38:43 4355 16:38:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4356 16:38:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4357 16:38:43 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4358 16:38:43 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4359 16:38:48 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4360 16:38:48 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4361 16:38:53 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4362 16:38:53 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4363 16:38:58 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4364 16:38:58 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4365 16:39:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:39:03 4366 16:39:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4367 16:39:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4368 16:39:03 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4369 16:39:03 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4370 16:39:08 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4371 16:39:08 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4372 16:39:13 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4373 16:39:13 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4374 16:39:18 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4375 16:39:18 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4376 16:39:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:39:23 4377 16:39:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4378 16:39:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4379 16:39:23 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4380 16:39:23 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4381 16:39:28 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4382 16:39:28 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4383 16:39:33 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4384 16:39:33 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4385 16:39:38 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4386 16:39:38 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4387 16:39:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:39:43 4388 16:39:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4389 16:39:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4390 16:39:43 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4391 16:39:43 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4392 16:39:48 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4393 16:39:48 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4394 16:39:53 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4395 16:39:53 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4396 16:39:58 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4397 16:39:58 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4398 16:40:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:40:03 4399 16:40:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4400 16:40:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4401 16:40:03 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4402 16:40:03 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4403 16:40:08 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4404 16:40:08 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4405 16:40:13 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4406 16:40:13 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4407 16:40:18 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4408 16:40:18 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4409 16:40:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:40:23 4410 16:40:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4411 16:40:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4412 16:40:23 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4413 16:40:23 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4414 16:40:28 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4415 16:40:28 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4416 16:40:33 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4417 16:40:33 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4418 16:40:38 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4419 16:40:38 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4420 16:40:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:40:43 4421 16:40:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4422 16:40:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4423 16:40:43 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4424 16:40:43 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4425 16:40:48 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4426 16:40:48 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4427 16:40:53 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4428 16:40:53 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4429 16:40:58 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4430 16:40:58 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4431 16:41:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:41:03 4432 16:41:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4433 16:41:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4434 16:41:03 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4435 16:41:03 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4436 16:41:08 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4437 16:41:08 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4438 16:41:13 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4439 16:41:13 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4440 16:41:18 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4441 16:41:18 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4442 16:41:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:41:23 4443 16:41:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4444 16:41:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4445 16:41:23 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4446 16:41:23 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4447 16:41:28 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4448 16:41:28 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4449 16:41:33 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4450 16:41:33 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4451 16:41:38 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4452 16:41:38 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4453 16:41:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:41:43 4454 16:41:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4455 16:41:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4456 16:41:44 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4457 16:41:44 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4458 16:41:49 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4459 16:41:49 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4460 16:41:54 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4461 16:41:54 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4462 16:41:59 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4463 16:41:59 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4464 16:42:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:42:03 4465 16:42:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4466 16:42:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4467 16:42:04 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4468 16:42:04 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4469 16:42:09 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4470 16:42:09 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4471 16:42:14 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4472 16:42:14 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4473 16:42:19 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4474 16:42:19 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4475 16:42:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:42:23 4476 16:42:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4477 16:42:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4478 16:42:24 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4479 16:42:24 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4480 16:42:29 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4481 16:42:29 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4482 16:42:34 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4483 16:42:34 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4484 16:42:39 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4485 16:42:39 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4486 16:42:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:42:43 4487 16:42:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4488 16:42:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4489 16:42:44 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4490 16:42:44 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4491 16:42:49 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4492 16:42:49 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4493 16:42:54 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4494 16:42:54 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4495 16:42:59 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4496 16:42:59 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4497 16:43:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:43:03 4498 16:43:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4499 16:43:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4500 16:43:04 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4501 16:43:04 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4502 16:43:09 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4503 16:43:09 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4504 16:43:14 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4505 16:43:14 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4506 16:43:19 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4507 16:43:19 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4508 16:43:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:43:23 4509 16:43:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4510 16:43:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4511 16:43:24 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4512 16:43:24 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4513 16:43:29 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4514 16:43:29 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4515 16:43:34 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4516 16:43:34 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4517 16:43:39 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4518 16:43:39 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4519 16:43:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:43:43 4520 16:43:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4521 16:43:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4522 16:43:44 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4523 16:43:44 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4524 16:43:49 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4525 16:43:49 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4526 16:43:54 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4527 16:43:54 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4528 16:43:59 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4529 16:43:59 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4530 16:44:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:44:03 4531 16:44:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4532 16:44:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4533 16:44:04 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4534 16:44:04 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4535 16:44:09 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4536 16:44:09 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4537 16:44:14 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4538 16:44:14 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4539 16:44:19 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4540 16:44:19 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4541 16:44:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:44:23 4542 16:44:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4543 16:44:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4544 16:44:24 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4545 16:44:24 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4546 16:44:29 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4547 16:44:29 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4548 16:44:34 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4549 16:44:34 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4550 16:44:39 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4551 16:44:39 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4552 16:44:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:44:43 4553 16:44:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4554 16:44:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4555 16:44:44 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4556 16:44:44 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4557 16:44:49 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4558 16:44:49 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4559 16:44:54 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4560 16:44:54 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4561 16:44:59 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4562 16:44:59 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4563 16:45:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:45:03 4564 16:45:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4565 16:45:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4566 16:45:04 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4567 16:45:04 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4568 16:45:09 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4569 16:45:09 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4570 16:45:14 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4571 16:45:14 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4572 16:45:19 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4573 16:45:19 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4574 16:45:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:45:23 4575 16:45:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4576 16:45:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4577 16:45:24 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4578 16:45:24 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4579 16:45:29 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4580 16:45:29 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4581 16:45:34 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4582 16:45:34 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4583 16:45:39 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4584 16:45:39 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4585 16:45:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:45:43 4586 16:45:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4587 16:45:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4588 16:45:44 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4589 16:45:44 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4590 16:45:49 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4591 16:45:49 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4592 16:45:54 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4593 16:45:54 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4594 16:45:59 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL' 4595 16:45:59 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='R' 4596 16:45:59 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 4597 16:45:59 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 4598 16:45:59 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 4599 16:45:59 SQL Execute: ORACLE - select nvl(MC0000,'0') MC0000 from BM_TYZD00 where ZDMC00='事前审方-事前审方系统' and BZ0000='是否启用审方系统' 4600 16:45:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2275 4601 16:45:59 SQL Execute: ORACLE - select b.zwxm00,c.* from (select rownum RN, A.* from VW_BM_CKBM00 A where BMBH00 = ? and FLAG00 = '2' )c ,BM_YGBM00 b where c.fyr000 = b.ygbh00(+) 4602 16:45:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 47 4603 16:45:59 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 4604 16:45:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 47 4605 16:45:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 47 4606 16:45:59 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 47 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2275 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 4607 16:45:59 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 4608 16:45:59 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 4609 16:45:59 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 4610 16:45:59 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2275 4611 16:45:59 SQL Execute: ORACLE - select rownum RN, A.* from (select * from VW_PY_KDKS00 where 1=1 ) A 4612 16:45:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2325 4613 16:45:59 SQL Execute: ORACLE - select * from VW_PY_ZKFYCK where BMBH00 = ? 4614 16:45:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2325 4615 16:45:59 SQL Execute: ORACLE - select * from VW_PY_FYCK00 A where not exists (select 1 from YF_ZKFYCK where BMBH00 = ? and FYCKBH = A.CKBH00) 4616 16:45:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2275 4617 16:45:59 SQL Execute: ORACLE - select * from VW_PY_BMCKRY where BMBH00 = ? and CZBZ00='1' order by ryzt00 desc,PYCKBH,XKH000 4618 16:45:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 47 4619 16:45:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 47 4620 16:45:59 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 47 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2275 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 4621 16:45:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2275 4622 16:45:59 SQL Execute: ORACLE - select b.zwxm00, c.* from (select rownum RN, A.* from VW_BM_CKBM00 A where BMBH00 = ? and FLAG00 = '3' )c ,BM_YGBM00 b where c.fyr000 = b.ygbh00(+) 4623 16:45:59 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,2832,'陈成辉','129.7.13.226','6C-4B-90-74-EE-7F','R','ACT_PY_CKRYWH','403488877') 4624 16:45:59 SQL Data In: ORACLE - Rows affected = 1 4625 16:45:59 SQL Execute: ORACLE - Commit 4626 16:45:59 SQL Data In: ORACLE - Rows affected = 0 4627 16:45:59 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4628 16:45:59 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4629 16:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:46:03 4630 16:46:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4631 16:46:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4632 16:46:04 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4633 16:46:04 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4634 16:46:09 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4635 16:46:09 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4636 16:46:14 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4637 16:46:14 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4638 16:46:19 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4639 16:46:19 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4640 16:46:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:46:23 4641 16:46:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4642 16:46:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4643 16:46:24 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4644 16:46:24 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4645 16:46:29 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4646 16:46:29 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4647 16:46:34 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4648 16:46:34 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4649 16:46:39 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4650 16:46:39 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4651 16:46:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:46:43 4652 16:46:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4653 16:46:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4654 16:46:44 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4655 16:46:44 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4656 16:46:49 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4657 16:46:49 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4658 16:46:54 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4659 16:46:54 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4660 16:46:59 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4661 16:46:59 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4662 16:47:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:47:03 4663 16:47:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4664 16:47:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4665 16:47:04 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4666 16:47:04 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4667 16:47:09 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4668 16:47:09 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4669 16:47:14 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4670 16:47:14 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4671 16:47:19 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4672 16:47:19 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4673 16:47:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:47:23 4674 16:47:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4675 16:47:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4676 16:47:24 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4677 16:47:25 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4678 16:47:30 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4679 16:47:30 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4680 16:47:35 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4681 16:47:35 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4682 16:47:40 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4683 16:47:40 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4684 16:47:42 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2832.000000 4685 16:47:42 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2275.000000 4686 16:47:42 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 133516796.000000 4687 16:47:42 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 4688 16:47:42 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 2832 and CZXH00 = 133516796.00) 4689 16:47:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:47:43 4690 16:47:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4691 16:47:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4692 16:47:45 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4693 16:47:45 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4694 16:47:50 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4695 16:47:50 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4696 16:47:55 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4697 16:47:55 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4698 16:48:00 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4699 16:48:00 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4700 16:48:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:48:03 4701 16:48:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 4702 16:48:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250515' and '20250515' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4703 16:48:05 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4704 16:48:05 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4705 16:48:10 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4706 16:48:10 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4707 16:48:15 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4708 16:48:15 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=2275 and PYCKBH = 203 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00