1       16:04:12  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL'

2       16:04:12  SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='3'

3       16:04:12  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

4       16:04:12  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 = ''

5       16:04:12  SQL Execute: ORACLE - select BMXZ00 from BM_BMBM00 where BMBH00=130 

6       16:04:12  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00=130 

7       16:04:12  SQL Execute: ORACLE - select max(YYJC00) as YYJC00 from XT_YYXX00 where YYID00='222212'

8       16:04:12  SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from DUAL

9       16:04:12  SQL Execute: ORACLE - select SF_XT_GETDJSFEXIST as SFBZDJ from dual

10      16:04:12  SQL Execute: ORACLE - select SF_XT_GETSFDJBYBMBH(130) as SFBZDJ from dual

11      16:04:12  SQL Execute: ORACLE - select * from VW_XT_BGSZJY where MKDLL0 = 'DLL_YK_CXTJ.dll' and YGBH00 = 1 and XTDM00 = '3'

12      16:04:12  SQL Execute: ORACLE - select * from XT_BGSZMX where BGSZID = 1070.00 order by BDINDX,BDCLDX,CLINDX,MXID00

13      16:04:12  SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=1 and NAME00 in (
 'YK_HZSRM','YK_DJYS','YK_FZSRM_FHJLS','YK_FZSRM_PPFX','YK_FZSRM_CXFS' 
)

14      16:04:12  SQL Execute: ORACLE - select a.YLBH00,a.LBBH00,a.YLMC00 from Bm_YPYL00 a where a.SJYLBH='##' and exists (select 1 from YK_YPKCXX b,BM_YD0000 c where c.LBBH00=a.LBBH00 and b.YPNM00=c.YPNM00 and b.YKBMBH=130) order by a.LBBH00

15      16:04:12  SQL Execute: ORACLE -  select LBBH00, LEVEL, a.FLBBH0, a.YPFLBH, a.YPFLMC, a.YPNM00, a.PYSM00, a.FLAG00,a.WZSX00 from VW_BM_YPFLTREEVIEW a  where a.FLAG00 <= 0 connect by a.FLBBH0 = Prior a.YPFLBH start with a.YPFLBH in ('A') order by LEVEL,FLBBH0,YPFLBH 

16      16:04:12  SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1 and BMBH00=130
 and DLXTMC='Ò©¿â¹ÜÀíϵͳ' and CTMC00='frmYK_RKMXCX'

17      16:04:12  SQL Execute: ORACLE -  select LBBH00, LEVEL, a.FLBBH0, a.YPFLBH, a.YPFLMC, a.YPNM00, a.PYSM00, a.ZT0000, a.FLAG00,a.WZSX00  from VW_BM_YPZDFL a  connect by a.FLBBH0 = Prior a.YPFLBH start with a.FLBBH0 in ('A') 

18      16:04:13  SQL Execute: ORACLE - SELECT V.RCLXMC,V.YPMC00,V.YPGG00,NVL(decode(V.RCLXBH,'09',decode(V.GJSLJE,0,V.GJFCJE,V.GJSLJE),NVL(V.YGJJE0,V.GJJE00)),0) GJJE00,
 decode(RCLXBH,'09',nvl((select FPH000 from YK_YPCKMX where YPRKPC = V.YPRKPC and YPCKPC = V.YPCKPC and ypqldh=V.DJH000 and rownum=1),V.fph000),V.fph000) FPH000, 
V.JZRQ00,V.SHRQ00,V.JZSJ00,V.CRBMBH,V.ZY0000, 
(select CGDBH0 from YK_YPDHD0 where RKDH00=V.DJH000 and rownum=1) CGJHDH,0 FLAG00,V.YPNM00,
(select B.CGMXXH from YK_YPDHD0 A,YK_CGJHMX B where to_char(A.CGDBH0)=B.CGJHDH and A.YPNM00=B.YPNM00 and A.RKDH00=V.DJH000 and A.YPNM00=V.YPNM00 and rownum = 1) CGMXXH,
 B.KCDW00 JZDW00,B.K2J000 ZHL000,V.GJDJ00,V.SLDJ00,V.PFDJ00,
ROUND(V.SLSL00*V.ZHL000/B.K2J000,3) SLSL00,V.GJDJ00 as SLGJDJ,
V.SLJE00,V.DJH000 AS RKDH00,V.SFSH00,V.YPBM00,V.PYSM00,V.ZBQ000,V.SF4J70, 
V.SCCJZW,V.CDMC00,V.GHDWMC,V.YPSXRQ,NVL(V.SLJE00,0)-NVL(decode(V.RCLXBH,'09',decode(V.GJSLJE,0,V.GJFCJE,V.GJSLJE),NVL(V.YGJJE0,V.GJJE00)),0) JXCJ00,V.JXMC00,
B.GJBZBM,B.GJBZMC, B.SFJCYY,
(select MC0000 from VW_YK_YDYPXZ where BH0000=B.YPXZ00) YPXZ00,
 V.JZRQ00 DDRQ00,' ' ZCZXX0,' ' ZCZMC0,' ' ZCSXRQ,' ' ZCSXRQ1,' ' WZXH00,' ' BZ0000,' ' DDRQ01,V.MXBZ00,' ' FPRQ01,' ' SFSB00, 
V.LBMC00,V.YLMC00,V.YPMLBZ,V.SCPH00,V.PZWH00,V.FPDM00,V.FPRQ00,V.PTGWJ0, 
V.LSDJH0 
 ,' ' WZSX00  
 ,' ' WZSXMC 
 ,' ' SFSF00
 ,' ' SSRQ00
 ,' ' JCLBMC
 ,' ' SFFYWZ
, v.CGYYID,V.CGYYMC
FROM VW_YK_RKJZ00 V,BM_YD0000 B
WHERE V.YKBMBH+0=130
 and B.YPNM00=V.YPNM00
 and V.RCLXBH<>'09' 
 AND CRBMBH like '%'
AND V.JZRQ00>='20230420' AND V.JZRQ00<='20230420' 
AND V.JZRQ00||V.JZSJ00>='2023042000:00:00' AND V.JZRQ00||V.JZSJ00<='2023042023:59:59' 
 and ( (V.YLBH00 like 'A%'   ) or  ('0'='-1')  or  ('A'='WZ') )    
 and ((V.TYMBH0='ALL' or 'ALL'='ALL') or ('0'='-1') ) 
 AND V.CRBMBH like '%'
ORDER BY V.JZRQ00,V.JZSJ00,V.DJH000,V.MXZLSH

19      16:04:13  SQL Error: ORACLE - ORA-06553: PLS-306: wrong number or types of arguments in call to 'V'

20      16:04:13  SQL Error: ORACLE - Unmapped SQL Error Code: 6553
21      16:04:13  SQL Data In: ORACLE - Rows affected = 0