| 3080tpmsr4uxc |
SELECT A.*, C.AMOUNT1, C.AMOUNT2, C.ITEMSCOUNT FROM AMSH_MEDIOUTER A LEFT JOIN (SELECT B.MAINID, SUM(B.AMOUNT1) AMOUNT1, SUM(B.AMOUNT2) AMOUNT2, COUNT(*) ITEMSCOUNT FROM AMSH_MEDIOUTERDTL B GROUP BY B.MAINID) C ON A.OURID=C.MAINID JOIN (SELECT DISTINCT D.MAINID FROM AMSH_MEDIOUTERDTL D, (SELECT MEDIID FROM TABLE(SBAS_MEDIIDBYTYPE(:B1 ))) E WHERE D.MEDIID=E.MEDIID) F ON A.OURID=F.MAINID WHERE (:B19 =0 OR A.OURID=:B19 ) AND A.BILLTYPE=:B18 AND (:B17 IS NULL OR A.CREATETIME>=TO_DATE(:B17 , 'yyy
y-mm-dd hh24:mi:ss')) AND (:B16 IS NULL OR A.CREATETIME<=TO_DATE(:B16 , 'yyyy-mm-dd hh24:mi:ss')) AND (:B15 IS NULL OR A.LANDTALLYTIME>=TO_DATE(:B15 , 'yyyy-mm-dd hh24:mi:ss')) AND (:B14 IS NULL OR A.LANDTALLYTIME<=TO_DATE(:B14 , 'yyyy-mm-dd hh24:mi:ss')) AND (:B13 IS NULL OR A.LANDERID IN (SELECT ANYID AS BTYPE FROM TABLE(SPLITSTRINGBYSIGN(:B13 , ', ')))) AND (:B12 IS NULL OR A.SENDERID IN (SELECT ANYID AS BTYPE FROM TABLE(SPLITSTRINGBYSIGN(:B12 , ', ')))) AND (:B11 =0 OR A.ISRUSH=:B11
) AND (:B10 =0 OR A.OURSTATE=:B10 ) AND (:B9 =0 OR A.LANDCHECKID>0) AND (:B8 IS NULL OR (A.LANDSUMCODE=:B8 OR A.LANDCODE = :B8 )) AND (:B7 IS NULL OR A.SENDCODE = :B7 ) AND (:B6 =0 OR A.OURID IN (SELECT B.MAINID FROM AMSH_MEDIOUTERDTL B WHERE B.MAINID=A.OURID AND B.MEDIID=:B6 )) AND (:B5 IS NULL OR A.OURID IN (SELECT B.MAINID FROM AMSH_MEDIOUTERDTL B WHERE B.MAINID=A.OURID AND B.INVOICECODE = :B5 )) AND (:B4 =0 OR A.LANDATOMMONTH >= :B4 ) AND (:B3 =0 OR A.LANDATOMMONTH <= :B3 ) AND ( :
B2 =0 OR A.OURID IN (SELECT D.MAINID OURID FROM AMSH_MEDIOUTERDTL D LEFT JOIN SBAS_CHARGE E ON D.MEDIID=E.OURID WHERE E.OURTYPE=:B2 )) ORDER BY A.LANDSUMCODE, A.CREATETIME |
| ahu5rv7x0129q |
SELECT DISTINCT A.PATINAME, A.BEDCODE, A.IPNUMBER, A.PATITYPEID, A.PATIID, A.AGE, A.SEX, A.WARDID PATIWARDID, A.DEPTID PATIDEPTID, B.*, :B3 ENDTIME FROM (SELECT C.OURID, C.PATINAME, C.PATIID, C.AGE, C.SEX, CHAN.BEDCODE, CHAN.WARDID, CHAN.DEPTID, CHAN.ENDNATURE, C.IPNUMBER, C.PATITYPEID FROM IP_CHECKIN C INNER JOIN IP_CHANGE CHAN ON CHAN.IPID = C.OURID WHERE CHAN.ENDTIME IS NULL AND CHAN.ISADDITION = 0 AND (:B2 =-1 OR C.OURID=:B2 ) ) A INNER JOIN (SELECT A.OURID AS ADVICEID,
A.ADVICETYPE, A.IPID, A.ORGID, A.RECIPEID, A.ABOUTID, A.CHARGEID, A.ADVICENAME, 0 USAGEID, '' USAGENAME, 0 USAGEEXECDEPTID, 0 USAGETREATTYPEID, 0 USAGEISSELFBRING, A.OURGROUP, A.EACHQUANTITY, A.DOSEUNIT, A.FREQNAME, A.FREQTIMES, A.FREQGAP, A.GAPUNIT, A.TIMESCHEME, A.GLOZE, A.EXECDEPTID, A.RECENTEXECTIME, A.STARTEXECTIME FIRSTTIME, DECODE(A.RECENTEXECTIME, NULL, A.STARTEXECTIME, A.RECENTEXECTIME) AS STARTEXECTIME, A.ENDEXECTIME, A.ISSELFBRING, A.ISOUTBRING, A.BABYSE
RIAL, A.SERIAL, A.STARTDOCTORID, A.TREATTYPEID, A.INPUTTYPE, DECODE(NVL(A.DOSEFACTOR, 0), 0, 1, A.DOSEFACTOR) DOSEFACTOR, A.DOSE, A.TREATID, A.ADVICEDEPTID, A.EXECNATURE, A.PATIWARDID WARDID, A.NOWPATIWARDID, A.NOWPATIDEPTID, A.ENDTIMES, A.STARTTIMES, A.OWNFEEGLOZE, A.LASTCHANGED, A.QUANTITY, A.MEDIPACK, A.MEDIUNIT FROM IP_ADVICE A WHERE (:B4 =-1 OR A.PATIWARDID = :B4 ) AND A.ADVICETYPE = 440001 AND A.EXECNATURE = 424001 AND NVL(A.ISCANCEL, 0)=0 AND NVL(A.ISPAUSE, 0)=0 AND
(A.RECENTEXECTIME <> A.ENDEXECTIME OR A.ENDEXECTIME IS NULL OR A.RECENTEXECTIME IS NULL) AND A.AUDITTIME IS NOT NULL AND (A.RECENTEXECTIME IS NULL OR A.RECENTEXECTIME < :B3 ) AND A.STARTEXECTIME <= :B3 AND (:B2 =-1 OR A.IPID=:B2 ) AND (:B1 =-1 OR A.OURID=:B1 ) AND EXISTS(SELECT 8 FROM IP_PRICING P WHERE P.ADVICEID = A.OURID) AND EXISTS (SELECT 1 FROM SBAS_TREATTYPE TR WHERE (TR.TOPKIND =401002 OR TR.TOPKIND = 401003) AND TR.ISFORBIDDEN=0 AND A.TREATTYPEID=TR.OURID)) B ON A.OURID = B.
IPID ORDER BY B.ABOUTID, B.SERIAL |
| 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
|