Product: | AHL - Complex Maintenance Repair and Overhaul |
---|---|
Description: | View based on join of AHL_MR_DETAILS_V, AHL_MR_ITEMS_V so that, each row corresponds to a unique Item Effectivity for the Maintenance requirement. This view is used by the Search MR UI to search by the associated item number along with othe |
Implementation/DBA Data: |
![]() |
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
, MR.PARENT_MR_HEADER_ID
, MR.PARENT_MR_TITLE
, MR.SOURCE_DOC_ID
, MR.SOURCE_DOC_TITLE
, MRI.INVENTORY_ITEM_ID
, MRI.ITEM_NUMBER
, 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_DETAILS_V MR
, AHL_MR_ITEMS_V MRI
WHERE MR.MR_HEADER_ID = MRI.MR_HEADER_ID (+)