View: AHL_MR_INSTANCES_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	View To get all the Maintenance Requirements in Production
Implementation/DBA Data:	APPS.AHL_MR_INSTANCES_V

View Text

SELECT DISTINCT UE.UNIT_EFFECTIVITY_ID
, UE.OBJECT_VERSION_NUMBER
, UE.CSI_ITEM_INSTANCE_ID
, UE.MR_HEADER_ID
, UE.CS_INCIDENT_ID
, DECODE( UE.MR_HEADER_ID
, NULL
, UE.CS_INCIDENT_NUMBER
, UE.TITLE )
, UE.CS_INCIDENT_NUMBER
, UE.INSTANCE_NUMBER
, FL.LOOKUP_CODE
, FL.MEANING
, VST.VISIT_ID
, VST.VISIT_NUMBER
, VST.START_DATE_TIME
, UE.QA_INSPECTION_TYPE_CODE
, UE.CS_INCIDENT_NUMBER
, AHL_UTILITY_PVT.GET_UNIT_NAME(UE.CSI_ITEM_INSTANCE_ID)
, VST.ORGANIZATION_ID
, ORG.ORGANIZATION_NAME
, VST.DEPARTMENT_ID
, BOM.DESCRIPTION
, DECODE(FL.LOOKUP_CODE
, 'ACCOMPLISHED'
, WO.ACTUAL_END_DATE
, 'ALL_JOBS_COMPLETE'
, WO.ACTUAL_END_DATE
, 'ALL_JOBS_CLOSED'
, WO.ACTUAL_END_DATE
, NULL)
, UE.QA_PLAN_ID
, UE.QA_COLLECTION_ID
FROM BOM_DEPARTMENTS BOM
, ORG_ORGANIZATION_DEFINITIONS ORG
, FND_LOOKUP_VALUES_VL FL
, AHL_UE_DEFERRAL_DETAILS_V UE
, AHL_VISITS_B VST
, AHL_VISIT_TASKS_B VT
, AHL_WORKORDERS WO
WHERE BOM.DEPARTMENT_ID (+) = VST.DEPARTMENT_ID
AND ORG.ORGANIZATION_ID = VST.ORGANIZATION_ID
AND FL.LOOKUP_TYPE = 'AHL_PRD_MR_STATUS'
AND FL.LOOKUP_CODE = AHL_COMPLETIONS_PVT.GET_MR_STATUS( UE.UNIT_EFFECTIVITY_ID )
AND UE.UNIT_EFFECTIVITY_ID = VT.UNIT_EFFECTIVITY_ID
AND VST.VISIT_ID = VT.VISIT_ID
AND VT.VISIT_TASK_ID = WO.VISIT_TASK_ID
AND WO.MASTER_WORKORDER_FLAG = 'Y'

Columns