View: AHL_MR_DETAILS_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	View based on the views AHL_MR_HEADERS_V with a)AHL_MR_RELATIONSHIPS_V to include the Parent Title & Revision and with b)AHL_DOC_TITLE_ASSOS_B & AHL_DOCUMENTS_VL to include the originating document. This View is used for Search MR.
Implementation/DBA Data:	APPS.AHL_MR_DETAILS_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
, MR.PRECEDING_MR_TITLE
, MR.CATEGORY_CODE
, MR.CATEGORY
, MR.SERVICE_TYPE_CODE
, MR.SERVICE_TYPE
, MR.MR_STATUS_CODE
, MR.STATUS
, MR.IMPLEMENT_STATUS_CODE
, MR.IMPLEMENT_STATUS
, MR.REPETITIVE_FLAG
, MR.REPETITIVE
, MR.SHOW_REPETITIVE_CODE
, MR.SHOW_REPETITIVE
, MR.WHICHEVER_FIRST_CODE
, MR.WHICHEVER_FIRST
, MR.COPY_ACCOMPLISHMENT_FLAG
, MR.COPY_ACCOMPLISHMENT
, MR.PROGRAM_TYPE_CODE
, MR.PROGRAM_TYPE
, MR.PROGRAM_SUBTYPE_CODE
, MR.PROGRAM_SUBTYPE
, MR.EFFECTIVE_FROM
, MR.EFFECTIVE_TO
, MR.REVISION
, MR.DESCRIPTION
, MR.COMMENTS
, MRR.MR_HEADER_ID
, PMR.TITLE
, DV.DOCUMENT_ID
, DV.DOCUMENT_TITLE
, MR.SERVICE_REQUEST_TEMPLATE_ID
, MR.TYPE_CODE
, MR.TYPE
, MR.DOWN_TIME
, MR.UOM_CODE
, MR.UOM
, MR.SPACE_CATEGORY_CODE
, MR.SPACE_CATEGORY
, MR.BILLING_ITEM_ID
, MR.BILLING_ORG_ID
, MR.BILLING_ITEM
, MR.QA_INSPECTION_TYPE_CODE
, MR.QA_INSPECTION_TYPE
, 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_V MR
, AHL_MR_RELATIONSHIPS MRR
, AHL_MR_HEADERS_APP_V PMR
, AHL_DOCUMENT_ASSOS_V DV
WHERE MR.MR_HEADER_ID = MRR.RELATED_MR_HEADER_ID (+)
AND MRR.RELATIONSHIP_CODE (+) = 'PARENT'
AND PMR.MR_HEADER_ID (+) = MRR.MR_HEADER_ID
AND DV.ASO_OBJECT_TYPE_CODE (+) = 'MR'
AND DV.SOURCE_REF_CODE (+) = 'SOURCE'
AND DV.ASO_OBJECT_ID (+) = MR.MR_HEADER_ID

Columns