SELECT /*+FIRST_ROWS*/
C.INSTITUTION_ID,
M.MULTIMEDIA_CONTENT_ID,
C.PATIENT_ID,
O.SERVICE_CODE,
O.SERVICE_SYS_ID,
O.PHYSIOLOGIC_TIME,
M.MIME_TYPE_CODE,
M.MULTIMEDIA_TEXT_CONTENT,
C.ITEM_400 AS ICDO_SITE,
C.ITEM_410 AS ICDO_LATERALITY,
NVL(C.ITEM_420,C.ITEM_522) AS ICDO_MORPHOLOGY,
NVL(C.ITEM_430,C.ITEM_523) AS ICDO_BEHAVIOR
FROM CRL_REPORT_GOLD C
INNER JOIN RMRS.MEDICAL_ORDER O
USING(MEDICAL_ORDER_ID)
INNER JOIN RMRS.MULTIMEDIA_CONTENT M
USING(MEDICAL_ORDER_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 = ?)
AND M.MULTIMEDIA_CONTENT_ID >=
AND M.MULTIMEDIA_CONTENT_ID =
AND ( O.SERVICE_SYS_ID=1 AND O.SERVICE_CODE IN (''
, '
'
) )
AND O.PATIENT_ID =
AND O.MEDICAL_ORDER_ID =
AND O.INSTITUTION_ID =
AND O.PHYSIOLOGIC_TIME > TO_DATE('
')
AND O.PHYSIOLOGIC_TIME BETWEEN TO_DATE('
') AND TO_DATE('
')
AND ROWNUM <=