VIEW: APPS.AHL_VISIT_MR_V

Source

View Text - Preformatted

SELECT ATSK.VISIT_TASK_ID, AMRH.MR_HEADER_ID, ATSK.OBJECT_VERSION_NUMBER, AMRH.TITLE, AMRH.DESCRIPTION, AMRH.REVISION, AMRH.TYPE_CODE, CSIS.SERIAL_NUMBER, MTSB.CONCATENATED_SEGMENTS, AVST.VISIT_ID, AVST.STATUS_CODE VISIT_STATUS_CODE, ATSK.STATUS_CODE TASK_STATUS_CODE FROM AHL_VISITS_VL AVST, AHL_VISIT_TASKS_VL ATSK, AHL_MR_HEADERS_VL AMRH, MTL_SYSTEM_ITEMS_B_KFV MTSB, CSI_ITEM_INSTANCES CSIS WHERE ATSK.INSTANCE_ID = CSIS.INSTANCE_ID (+) AND NVL(ATSK.STATUS_CODE,'X') <> 'DELETED' AND ATSK.MR_ID = AMRH.MR_HEADER_ID AND ATSK.INVENTORY_ITEM_ID = MTSB.INVENTORY_ITEM_ID AND ATSK.ITEM_ORGANIZATION_ID = MTSB.ORGANIZATION_ID AND ATSK.TASK_TYPE_CODE='SUMMARY' AND ATSK.MR_ID IS NOT NULL AND ( ATSK.ORIGINATING_TASK_ID IS NULL or EXISTS(SELECT 'X' FROM AHL_VISIT_TASKS_VL WHERE VISIT_task_id = ATSK.ORIGINATING_TASK_ID and TASK_TYPE_CODE='SUMMARY' AND SERVICE_REQUEST_ID IS NOT NULL) ) AND AVST.VISIT_ID = ATSK.VISIT_ID

View Text - HTML Formatted

SELECT ATSK.VISIT_TASK_ID
, AMRH.MR_HEADER_ID
, ATSK.OBJECT_VERSION_NUMBER
, AMRH.TITLE
, AMRH.DESCRIPTION
, AMRH.REVISION
, AMRH.TYPE_CODE
, CSIS.SERIAL_NUMBER
, MTSB.CONCATENATED_SEGMENTS
, AVST.VISIT_ID
, AVST.STATUS_CODE VISIT_STATUS_CODE
, ATSK.STATUS_CODE TASK_STATUS_CODE
FROM AHL_VISITS_VL AVST
, AHL_VISIT_TASKS_VL ATSK
, AHL_MR_HEADERS_VL AMRH
, MTL_SYSTEM_ITEMS_B_KFV MTSB
, CSI_ITEM_INSTANCES CSIS
WHERE ATSK.INSTANCE_ID = CSIS.INSTANCE_ID (+)
AND NVL(ATSK.STATUS_CODE
, 'X') <> 'DELETED'
AND ATSK.MR_ID = AMRH.MR_HEADER_ID
AND ATSK.INVENTORY_ITEM_ID = MTSB.INVENTORY_ITEM_ID
AND ATSK.ITEM_ORGANIZATION_ID = MTSB.ORGANIZATION_ID
AND ATSK.TASK_TYPE_CODE='SUMMARY'
AND ATSK.MR_ID IS NOT NULL
AND ( ATSK.ORIGINATING_TASK_ID IS NULL OR EXISTS(SELECT 'X'
FROM AHL_VISIT_TASKS_VL
WHERE VISIT_TASK_ID = ATSK.ORIGINATING_TASK_ID
AND TASK_TYPE_CODE='SUMMARY'
AND SERVICE_REQUEST_ID IS NOT NULL) )
AND AVST.VISIT_ID = ATSK.VISIT_ID