SELECT --+FIRST_ROWS
M.INSTITUTION_ID,
M.MULTIMEDIA_CONTENT_ID,
O.SERVICE_CODE,
O.SERVICE_SYS_ID,
-- O.PHYSIOLOGIC_TIME,
M.MIME_TYPE_CODE,
M.MULTIMEDIA_TEXT_CONTENT,
Q.ROWID AS QUEUE_ROWID,
M.PATIENT_ID
FROM Q
INNER JOIN RMRS.MULTIMEDIA_CONTENT M
ON( Q.MULTIMEDIA_CONTENT_ID=M.MULTIMEDIA_CONTENT_ID
AND Q.INSTITUTION_ID=M.INSTITUTION_ID)
INNER JOIN RMRS.MEDICAL_ORDER O
ON( O.MEDICAL_ORDER_ID=M.MEDICAL_ORDER_ID
AND O.INSTITUTION_ID=M.INSTITUTION_ID)
SELECT NAME_FIRST,
NAME_LAST
FROM RMRS.PATIENT_ALIAS_NAME
WHERE (INSTITUTION_ID = ? AND PATIENT_ID = ?)
UNION ALL
SELECT NAME_FIRST,
NAME_LAST
FROM RMRS.PATIENT
WHERE (INSTITUTION_ID = ? AND PATIENT_ID = ?)
UPDATE MULTIMEDIA_CONTENT
SET MULTIMEDIA_TEXT_CONTENT_SCRUB=?
WHERE INSTITUTION_ID=?
AND MULTIMEDIA_CONTENT_ID=?
DELETE FROM
WHERE ROWID=?
AND MULTIMEDIA_TEXT_CONTENT_SCRUB IS NULL
AND MOD(M.MULTIMEDIA_CONTENT_ID,10) IN () AND M.MULTIMEDIA_CONTENT_ID = AND (O.SERVICE_SYS_ID=1 AND O.SERVICE_CODE IN ('', '') ) AND M.PATIENT_ID = AND M.MEDICAL_ORDER_ID = AND M.INSTITUTION_ID = AND