1       23:30:01  SQL Execute: ORACLE - SELECT '住院'MZZYBZ,CFLSH0,F.BMMC00 YFBMMC,ZYH000,decode(YEXM00,'全部',BRXM00,'母亲',BRXM00,null,BRXM00,YEXM00) BRXM00,
decode(YEXM00,'全部',C.XB0000,'母亲',C.XB0000,null,C.XB0000,(select yexb00 from bq_jsxx00 where zyid00=c.zyid00 and yexm00=c.yexm00)) xb0000,
decode(YEXM00,'全部',substr(SF_BQ_CSRQTONL(CSRQ00),1,5),'母亲',substr(SF_BQ_CSRQTONL(CSRQ00),1,5),null,substr(SF_BQ_CSRQTONL(CSRQ00),1,5),(select substr(SF_BQ_CSRQTONL(YECSRQ),1,5) from bq_jsxx00 where zyid00=c.zyid00 and yexm00=c.yexm00)) nl0000,
DJH000,YSXM00,B.BMMC00 BQMC00,ZYTS00,
DECODE(YPDLBH,'0','西药','1','成药','2','草药')YPLB00,
DECODE(CFXZ00,'1','毒','2','麻','3','神经')CFXZ00,BZMC00, 
DECODE(CFZT00,'0','未记账','1','已记账','2','已发药','3','作废')CFZT00, 
Y.ZWXM00 LRRXM0,L.ZWXM00 LYRXM0, 
TO_DATE(SRRQ00||SRSJ00,'YYYYMMDDHH24:MI:SS')SRRQSJ,  
TO_DATE(JZRQ00||JZSJ00,'YYYYMMDDHH24:MI:SS')JZRQSJ,CFZJE0,  
DECODE(NVL(BCCFH0,0),0,'','冲销')CXBZ00,ZYDJS0,THBZ00 
FROM YF_ZYCF00 C,BM_BMBM00 B,BM_YGBM00 Y,BM_YGBM00 L,BM_BMBM00 F 
WHERE DQBQ00=B.BMBH00(+) AND C.CZY000=Y.YGBH00 AND  
      C.LYR000=L.YGBH00(+) AND C.YFBMBH=F.BMBH00 AND 
        ZYH000 LIKE '%%' AND  
      SRRQ00 BETWEEN '20250414'
 AND '20250414' AND DQKS00= 608

2       23:30:01  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
3       23:30:01  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
4       23:30:01  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
5       23:30:01  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
6       23:30:01  SQL Execute: ORACLE - SELECT YPMC00,YPGG00,TO_CHAR(CSL000)||JLDW00 CSL000,
LSDJ00,NVL(YPYFMC,ZJYFMC)YPYF00,
TO_CHAR(YPZSL0)||CFDW00 YPZSL0,
PCMC00,TO_CHAR(YYSJ00)||YYSJDW YYSJ00,
DECODE(SFZBY0,'Y','是','否')SFZB00,CXBZ00,PSMC00,ZB0000,' ' BRXM00
FROM YF_ZYCFMX C,BM_PS0000 P
WHERE C.PSLBID=P.PSID00(+) AND CFLSH0=? AND '住院'=?
UNION ALL
SELECT YPMC00,YPGG00,TO_CHAR(CSL000)||JLDW00 CSL000,
LSDJ00,NVL(YPYFMC,ZJYFMC)YPYF00,
TO_CHAR(YPZSL0)||CFDW00 YPZSL0,
PCMC00,TO_CHAR(YYSJ00)||YYSJDW YYSJ00,
DECODE(SFZBY0,'Y','是','否')SFZB00,CXBZ00,PSMC00,ZB0000,' ' BRXM00
FROM YF_MZCFMX C,BM_PS0000 P
WHERE C.PSLBID=P.PSID00(+) AND CFLSH0=? AND '门诊'=?