View: AHL_MR_HEADERS_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	View based on the views AHL_MR_HEADERS_VL with FND_LOOKUP_VALUES_VL to include all the corresponding descriptions of the codes and with AHL_MR_HEADERS_B to get the Preceding MR Title & Revision.
Implementation/DBA Data:	APPS.AHL_MR_HEADERS_V

View Text

SELECT MR.MR_HEADER_ID
, MR.OBJECT_VERSION_NUMBER
, MR.LAST_UPDATE_DATE
, MR.LAST_UPDATED_BY
, MR.CREATION_DATE
, MR.CREATED_BY
, MR.LAST_UPDATE_LOGIN
, MR.TITLE
, MR.VERSION_NUMBER
, MR.PRECEDING_MR_HEADER_ID
, PMR.TITLE
, PMR.REVISION
, MR.CATEGORY_CODE
, CATEGORY.MEANING
, MR.SERVICE_TYPE_CODE
, SERVICE.MEANING
, MR.MR_STATUS_CODE
, STATUS.MEANING
, MR.IMPLEMENT_STATUS_CODE
, IMPLEMENT.MEANING
, MR.REPETITIVE_FLAG
, REPETITIVE.MEANING
, MR.SHOW_REPETITIVE_CODE
, SHOW.MEANING
, MR.WHICHEVER_FIRST_CODE
, FIRST.MEANING
, MR.COPY_ACCOMPLISHMENT_FLAG
, COPY.MEANING
, MR.PROGRAM_TYPE_CODE
, PROGTYPE.MEANING
, MR.PROGRAM_SUBTYPE_CODE
, SUBTYPE.MEANING
, MR.EFFECTIVE_FROM
, MR.EFFECTIVE_TO
, MR.REVISION
, MR.DESCRIPTION
, MR.COMMENTS
, MR.SERVICE_REQUEST_TEMPLATE_ID
, MR.TYPE_CODE
, TYPE.MEANING
, MR.DOWN_TIME
, MR.UOM_CODE
, UOM.MEANING
, MR.SPACE_CATEGORY_CODE
, SPACAT.MEANING
, MR.BILLING_ITEM_ID
, MR.BILLING_ORG_ID
, (SELECT DISTINCT CONCATENATED_SEGMENTS
FROM MTL_SYSTEM_ITEMS_KFV
WHERE INVENTORY_ITEM_ID=MR.BILLING_ITEM_ID) MTL
, MR.QA_INSPECTION_TYPE_CODE
, QA.DESCRIPTION
, MR.ATTRIBUTE_CATEGORY
, MR.ATTRIBUTE1
, MR.ATTRIBUTE2
, MR.ATTRIBUTE3
, MR.ATTRIBUTE4
, MR.ATTRIBUTE5
, MR.ATTRIBUTE6
, MR.ATTRIBUTE7
, MR.ATTRIBUTE8
, MR.ATTRIBUTE9
, MR.ATTRIBUTE10
, MR.ATTRIBUTE11
, MR.ATTRIBUTE12
, MR.ATTRIBUTE13
, MR.ATTRIBUTE14
, MR.ATTRIBUTE15
, MR.APPLICATION_USG_CODE
FROM AHL_MR_HEADERS_APP_V MR
, FND_LOOKUP_VALUES_VL CATEGORY
, FND_LOOKUP_VALUES_VL PROGTYPE
, FND_LOOKUP_VALUES_VL SUBTYPE
, FND_LOOKUP_VALUES_VL SERVICE
, FND_LOOKUP_VALUES_VL STATUS
, FND_LOOKUP_VALUES_VL IMPLEMENT
, FND_LOOKUP_VALUES_VL REPETITIVE
, FND_LOOKUP_VALUES_VL SHOW
, FND_LOOKUP_VALUES_VL COPY
, FND_LOOKUP_VALUES_VL FIRST
, FND_LOOKUP_VALUES_VL UOM
, FND_LOOKUP_VALUES_VL TYPE
, FND_LOOKUP_VALUES_VL SPACAT
, QA_CHAR_VALUE_LOOKUPS_V QA
, AHL_MR_HEADERS_APP_V PMR
WHERE CATEGORY.LOOKUP_TYPE = 'AHL_FMP_MR_CATEGORY'
AND CATEGORY.LOOKUP_CODE = MR.CATEGORY_CODE
AND PROGTYPE.LOOKUP_TYPE = 'AHL_FMP_MR_PROGRAM_TYPE'
AND PROGTYPE.LOOKUP_CODE = MR.PROGRAM_TYPE_CODE
AND SUBTYPE.LOOKUP_TYPE (+) = 'AHL_FMP_MR_PROGRAM_SUBTYPE'
AND SUBTYPE.LOOKUP_CODE (+) = MR.PROGRAM_SUBTYPE_CODE
AND SERVICE.LOOKUP_TYPE (+) = 'AHL_FMP_MR_SERVICE_TYPE'
AND SERVICE.LOOKUP_CODE (+) = MR.SERVICE_TYPE_CODE
AND STATUS.LOOKUP_TYPE = 'AHL_FMP_REVISION_STATUS'
AND STATUS.LOOKUP_CODE = MR.MR_STATUS_CODE
AND IMPLEMENT.LOOKUP_TYPE = 'AHL_FMP_MR_IMPLEMENT_STATUS'
AND IMPLEMENT.LOOKUP_CODE = MR.IMPLEMENT_STATUS_CODE
AND REPETITIVE.LOOKUP_TYPE = 'AHL_YES_NO_TYPE'
AND REPETITIVE.LOOKUP_CODE = MR.REPETITIVE_FLAG
AND SHOW.LOOKUP_TYPE = 'AHL_FMP_MR_SHOW_REPETITIVE'
AND SHOW.LOOKUP_CODE = MR.SHOW_REPETITIVE_CODE
AND COPY.LOOKUP_TYPE = 'AHL_YES_NO_TYPE'
AND COPY.LOOKUP_CODE = MR.COPY_ACCOMPLISHMENT_FLAG
AND FIRST.LOOKUP_TYPE = 'AHL_FMP_THRESHOLD_FIRST'
AND FIRST.LOOKUP_CODE = MR.WHICHEVER_FIRST_CODE
AND TYPE.LOOKUP_TYPE (+) = 'AHL_FMP_MR_TYPE'
AND TYPE.LOOKUP_CODE (+) = MR.TYPE_CODE
AND UOM.LOOKUP_CODE (+) = MR.UOM_CODE
AND UOM.LOOKUP_TYPE(+)= 'AHL_FMP_PM_DOWNTIME_UOM'
AND PMR.MR_HEADER_ID (+) = MR.PRECEDING_MR_HEADER_ID
AND SPACAT.LOOKUP_TYPE(+)= 'AHL_LTP_SPACE_CATEGORY'
AND SPACAT.LOOKUP_CODE(+)= MR.SPACE_CATEGORY_CODE
AND MR.QA_INSPECTION_TYPE_CODE=QA.SHORT_CODE(+)
AND QA.CHAR_ID(+)=87

Columns