| SQL Id | SQL Text |
|---|
| 09cv393nkw8x7 |
SELECT T.OURID, T.WINDOWSID, T.HOUSEID, T.OURSTATE, T.CREATETIME, A.PATIID, A.PATINAME PATIENTNAME, A.SEX, A.AGE, A.REGINUMBER, B.PATITYPEID, A.CARDTYPE, T.RECIPEID, C.RECIPETYPE, C.ASKDEPTID DEPTID, C.CREATORID EMPID, T.SETTLEID CHARGEID, B.BILLNUMBER CHARGECODE, B.INVONUMBER INVOICECODE, B.AMOUNT, C.RECINUMBER RECINUMBER, (SELECT TO_CHAR(WMSYS.WM_CONCAT(TO_CHAR(D.DISEASENAME))) FROM OP_DIAGNOSE D WHERE D.REGISTERID = A.OURID) DIAGNOSE FROM AMSH_MIXALLOT T LEFT JOIN OP_SETT
LE B ON T.SETTLEID = B.OURID LEFT JOIN OP_REGISTER A ON T.REGISTERID = A.OURID LEFT JOIN OP_RECIPE C ON T.RECIPEID = C.OURID WHERE T.HOUSEID IN (SELECT ANYID AS BTYPE FROM TABLE(SPLITSTRINGBYSIGN(:B10 , ', '))) AND T.RECIPEID > 0 AND (:B9 IS NULL OR T.GROUPNAME = :B9 ) AND (:B8 = 0 OR (T.WINDOWSID = :B8 OR T.WINDOWSID = -1)) AND (T.OURSTATE <> 20 AND T.OURSTATE <> 30) AND (:B7 IS NULL OR B.INVONUMBER = :B7 ) AND (:B6 IS NULL OR B.BILLNUMBER = :B6 ) AND (:B5 IS NULL OR A.REGINUMBE
R = :B5 ) AND (:B3 IS NULL OR UPPER(A.PINYINCODE) = :B4 OR UPPER(A.WUBICODE) = :B4 OR A.PATINAME = :B3 ) AND (:B2 IS NULL OR T.CREATETIME <= TO_DATE(:B2 , 'yyyy-mm-dd hh24:mi:ss')) AND (:B1 IS NULL OR T.CREATETIME >= TO_DATE(:B1 , 'yyyy-mm-dd hh24:mi:ss')) UNION SELECT T.OURID, T.WINDOWSID, T.HOUSEID, T.OURSTATE, T.CREATETIME, E.PATIID, E.PATINAME PATIENTNAME, E.SEX, E.AGE, E.REGINUMBER, C.PATITYPEID, E.CARDTYPE, T.RECIPEID, 0 RECIPETYPE, (SELECT NVL(A.ASKDEPTID, 0) FROM O
P_COSTDTL A WHERE A.SETTLEID = C.OURID AND ROWNUM = 1) DEPTID, (SELECT NVL(A.ASKDOCTORID, 0) FROM OP_COSTDTL A WHERE A.SETTLEID = C.OURID AND ROWNUM = 1) EMPID, T.SETTLEID CHARGEID, C.BILLNUMBER CHARGECODE, C.INVONUMBER INVOICECODE, C.AMOUNT, NULL RECINUMBER, '' DIAGNOSE FROM AMSH_MIXALLOT T LEFT JOIN OP_SETTLE C ON C.OURID = T.SETTLEID LEFT JOIN OP_REGISTER E ON E.OURID = T.REGISTERID WHERE T.HOUSEID IN (SELECT ANYID AS BTYPE FROM TABLE(SPLITSTRINGBYSIGN(:B10 , ', '))) AND NVL(T.RECIPE
ID, 0) = 0 AND (:B9 IS NULL OR T.GROUPNAME = :B9 ) AND (:B8 = 0 OR (T.WINDOWSID = :B8 OR T.WINDOWSID = -1)) AND (T.OURSTATE <> 20 AND T.OURSTATE <> 30) AND (:B7 IS NULL OR C.INVONUMBER = :B7 ) AND (:B6 IS NULL OR C.BILLNUMBER = :B6 ) AND (:B5 IS NULL OR E.REGINUMBER = :B5 ) AND (:B3 IS NULL OR E.PINYINCODE = :B4 OR E.WUBICODE = :B4 OR E.PATINAME = :B3 ) AND (:B2 IS NULL OR T.CREATETIME <= TO_DATE(:B2 , 'yyyy-mm-dd hh24:mi:ss')) AND (:B1 IS NULL OR T.CREATETIME >= TO_DATE(:B1
, 'yyyy-mm-dd hh24:mi:ss')) ORDER BY CREATETIME, PATIID |
| 5g1bdckrq90q9 | SELECT COUNT(CT.OURID) FROM IP_COST CT INNER JOIN IP_CHECKIN CK ON CT.IPID = CK.OURID WHERE CT.STATE = 1 AND CT.IPID = :B1 AND (CK.SURGERY IS NOT NULL OR EXISTS (SELECT 1 FROM SBAS_DATAPOOL DL WHERE DL.OURTYPE = 259 AND CT.CHARGEID = TO_NUMBER(DL.OURVALUE)) OR EXISTS (SELECT 1 FROM SBAS_DATAPOOL DL WHERE DL.OURTYPE = 258 AND CT.CHARGEID = TO_NUMBER(DL.OURVALUE) AND CT.NOWPATIDEPTID = TO_NUMBER(DL.UN
IQUELYCODE)) ) |
| 7tzu283hmdsky | SELECT SSET_CREATEOURID.NEXTVAL FROM DUAL |
| ckrqxdhpttrqu |
SELECT A.*, B.* FROM AMSH_MEDIAPPLY A, (SELECT MAINID, COUNT(1) AS SUMCOUNT, SUM(AMOUNT1) AS SUMAMOUNT1, SUM(AMOUNT2) AS SUMAMOUNT2, SUM(AMOUNT3) AS SUMAMOUNT3 FROM AMSH_MEDIAPPLYDTL GROUP BY MAINID) B, ((SELECT DISTINCT C.MAINID FROM AMSH_MEDIAPPLYDTL C, (SELECT MEDIID FROM TABLE(SBAS_MEDIIDBYTYPE(:B1 ))) D WHERE C.MEDIID = D.MEDIID)) E WHERE A.OURID = B.MAINID AND (:B10 IS NULL OR (SENDERID IN (SELECT ANYID AS BTYPE FROM TABLE(SPLITSTRINGBYSIGN(:B10 , ', '))))) AND (:B9 IS NULL OR (LA
NDERID IN (SELECT ANYID AS BTYPE FROM TABLE(SPLITSTRINGBYSIGN(:B9 , ', '))))) AND ((A.LANDERNAME = 0 AND OURSTATE IN (SELECT ANYID AS STATE FROM TABLE(SPLITSTRINGBYSIGN(:B11 , ', ')))) OR (A.LANDERNAME > 0 AND A.OURSTATE != '317001' AND A.OURSTATE IN (SELECT ANYID AS STATE FROM TABLE(SPLITSTRINGBYSIGN(:B11 , ', '))))) AND (:B8 = 0 OR INOUT = :B8 ) AND (:B7 = 0 OR BILLTYPE = :B7 ) AND (:B6 IS NULL OR A.SENDSUMCODE = :B6 OR A.SENDCODE = :B6 ) AND (:B5 IS NULL OR BILLDATE >= TO_DATE(:B5 ,
'yyyy-mm-dd hh24:mi:ss')) AND (:B4 IS NULL OR BILLDATE <= TO_DATE(:B4 , 'yyyy-mm-dd hh24:mi:ss')) AND (:B3 = 0 OR A.OURID IN (SELECT B.MAINID FROM AMSH_MEDIAPPLYDTL B WHERE B.MEDIID = :B3 )) AND (A.OURID = E.MAINID ) AND (:B2 = 0 OR A.OURID IN (SELECT D.MAINID OURID FROM AMSH_MEDIAPPLYDTL D LEFT JOIN SBAS_CHARGE E ON D.MEDIID = E.OURID WHERE E.OURTYPE = :B2 )) ORDER BY A.CREATETIME
|
| gqyxa4pws6y3h |
SELECT A.DEPTID, A.DOCTORID, A.ACCFEEID, A.FACTAMOUNT, B.REGISTCNT, A.MEDIAMOUNT, A.ZZMEDIAMOUNT, A.ISMEDI, A.PLXAMOUNT FROM (SELECT T2.ASKDEPTID DEPTID, T2.ASKDOCTORID DOCTORID, T4.OURID ACCFEEID, SUM(T2.FACTAMOUNT) FACTAMOUNT, CASE WHEN CH.OURTYPE =104001 OR CH.OURTYPE = 104002 OR CH.OURTYPE = 104006 OR CH.OURTYPE =104033 THEN SUM(T2.FACTAMOUNT) ELSE 0 END MEDIAMOUNT, CASE WHEN CH.OURTYPE =104032 OR CH.OURTYPE = 104062 THEN SUM(T2.FACTAMOUNT) ELSE 0 END ZZMEDIAMOUNT, T4.ISMEDI IS
MEDI, SUM(CASE WHEN T2.CHARGEID IN (SELECT SL.MEDIID FROM SBAS_MEDIATTRIBUTEDTL SL WHERE SL.MAINID = 4) THEN T2.FACTAMOUNT ELSE 0 END) PLXAMOUNT FROM OP_COSTDTL T2, OP_SETTLE ST, SBAS_INCOMEITEM T3, SBAS_CHARGE CH, SBAS_ACCFEE T4 WHERE T3.ACCFEEID = T4.OURID AND CH.OURID = T2.CHARGEID AND T2.SETTLEID = ST.OURID AND T2.INCOMEITEMID = T3.OURID AND ST.SETTLETIME >= :B4 AND ST.SETTLETIME <= :B3 AND ST.STATE <> 115001 AND ST.SETTLEPLACEID = 101001 AND (:B2 = 0 OR T2.ASKDEPTID = :B2 )
AND (:B1 = 0 OR T2.ASKDOCTORID = :B1 ) AND ST.ORGID IN (SELECT ANYID AS BTYPE FROM TABLE(SPLITSTRINGBYSIGN(:B5 , ', '))) GROUP BY T2.ASKDEPTID, T2.ASKDOCTORID, T4.OURID, CH.OURTYPE, T4.ISMEDI) A, (SELECT CD.ASKDEPTID DEPTID, CD.ASKDOCTORID DOCTORID, COUNT(DISTINCT CD.REGISTERID) REGISTCNT FROM OP_COSTDTL CD, OP_SETTLE ST WHERE CD.SETTLEID = ST.OURID AND ST.SETTLETIME >= :B4 AND ST.SETTLETIME <= :B3 AND ST.STATE <> 115001 AND ST.SETTLEPLACEID = 101003 AND (:B2 = 0 OR CD.ASKDE
PTID = :B2 ) AND (:B1 = 0 OR CD.ASKDOCTORID = :B1 ) AND ST.ORGID IN (SELECT ANYID AS BTYPE FROM TABLE(SPLITSTRINGBYSIGN(:B5 , ', '))) GROUP BY CD.ASKDEPTID, CD.ASKDOCTORID) B WHERE A.DEPTID = B.DEPTID(+) AND A.DOCTORID = B.DOCTORID(+) ORDER BY A.DEPTID, A.DOCTORID |