View: AHL_VISIT_MR_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This view is used to query data from AHL_VISITS_VL,AHL_VISIT_TASKS_V,MTL_SYSTEM_ITEMS_B,CSI_ITEM_INSTANCES,AHL_MR_HEADERS_VL
Implementation/DBA Data:	APPS.AHL_VISIT_MR_V

View Text

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
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 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.ORIGINATING_TASK_ID IS NULL
AND ATSK.MR_ID IS NOT NULL
AND ATSK.TASK_TYPE_CODE = 'SUMMARY'
AND AVST.VISIT_ID = ATSK.VISIT_ID

Columns