1       11:31:16  Log started for: 药库管理系统
2       11:31:34  SQL Execute: ORACLE - SELECT * FROM BM_YPLB00

3       11:31:34  SQL Execute: ORACLE - SELECT * FROM BM_YPYL00
 WHERE LBBH00=''

4       11:31:34  SQL Execute: ORACLE - SELECT * FROM BM_YPJX00
 WHERE LBBH00=''

5       11:31:34  SQL Execute: ORACLE - select distinct DBGRIN,YGBH00 from XT_ZDYLXS where (YGBH00=0 or YGBH00=816) and  (BMBH00=0 or  BMBH00=118)
 and DLXTMC='药库管理系统' and CTMC00='frmYK_RKMXCX' order by YGBH00 

6       11:31:34  SQL Execute: ORACLE - select distinct MC0000,BH0000 from BM_TYZD00 where ZDMC00='药品性质' order by BH0000

7       11:31:37  SQL Execute: ORACLE - SELECT RCLXMC,YPMC00,YPGG00,FPH000,FPRQ00,PFDJ00,decode(RCLXBH,'10',decode((select 'Y' from xt_xtcs00 where name00='YK_CJJESFDLGL' and VALUE0 in ('Y','M')),'Y',0,nvl(YGJJE0,GJJE00)),
NVL(nvl(YGJJE0,nvl(GJJE00,decode(nvl(SLDJ00,0),0,0,round(SLJE00/SLDJ00*GJDJ00,2)))),0)) GJJE00,
JZRQ00,SHRQ00,JZSJ00,CRBMBH,ZY0000,JZDW00,ZHL000,NVL(GJDJ00,0) GJDJ00,
SLDJ00,SLSL00,SLJE00,NVL(YGJDJ0,GJDJ00) AS SLGJDJ,DJH000 AS RKDH00,SFSH00,YPBM00,PYSM00, 
SCCJZW,GHDWMC,YPSXRQ,NVL(SLJE00,0)-decode(RCLXBH,'10',decode((select 'Y' from xt_xtcs00 where name00='YK_CJJESFDLGL' and VALUE0 in ('Y','M')),'Y',0,nvl(YGJJE0,GJJE00)),
NVL(nvl(YGJJE0,nvl(GJJE00,decode(nvl(SLDJ00,0),0,0,round(SLJE00/SLDJ00*GJDJ00,2)))),0)) JXCJ00,JXMC00,
LSDJH0,LBMC00,YLMC00,YPMLBZ,SCPH00,PZWH00,SCRQ00,JHRQ00,
decode((select 'Y' from xt_xtcs00 where name00='YK_CJJESFDLGL' and VALUE0 in ('Y','M')),'Y',decode(RCLXBH,'10',nvl(YGJJE0,GJJE00),0),0) C_CJGJJE, 
ZBQ000,YPXZ00 
 FROM VW_YK_RKJZCX 
WHERE YKBMBH=118
 AND CRBMBH like '%'
AND JZRQ00>='20220601' AND JZRQ00<='20220601' 
AND JZRQ00||JZSJ00>='2022060100:00:00' AND JZRQ00||JZSJ00<='2022060123:59:59' 
 AND LBBH00 LIKE '%'
 AND YLBH00 LIKE '%'
 AND JXBH00 LIKE '%'
ORDER BY JZRQ00,JZSJ00,DJH000,MXZLSH