View: AHL_MR_HEADERS_VL

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	View based on the table AHL_MR_HEADERS_B and the translated columns from the table AHL_MR_HEADERS_TL
Implementation/DBA Data:	APPS.AHL_MR_HEADERS_VL

View Text

SELECT B.MR_HEADER_ID
, B.OBJECT_VERSION_NUMBER
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.TITLE
, B.VERSION_NUMBER
, B.PRECEDING_MR_HEADER_ID
, B.CATEGORY_CODE
, B.SERVICE_TYPE_CODE
, B.MR_STATUS_CODE
, B.IMPLEMENT_STATUS_CODE
, B.REPETITIVE_FLAG
, B.SHOW_REPETITIVE_CODE
, B.WHICHEVER_FIRST_CODE
, B.COPY_ACCOMPLISHMENT_FLAG
, B.PROGRAM_TYPE_CODE
, B.PROGRAM_SUBTYPE_CODE
, B.EFFECTIVE_FROM
, B.EFFECTIVE_TO
, B.REVISION
, B.BILLING_ITEM_ID
, B.BILLING_ORG_ID
, B.SPACE_CATEGORY_CODE
, B.QA_INSPECTION_TYPE
, T.DESCRIPTION
, T.COMMENTS
, B.SERVICE_REQUEST_TEMPLATE_ID
, B.TYPE_CODE
, B.DOWN_TIME
, B.UOM_CODE
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.APPLICATION_USG_CODE
FROM AHL_MR_HEADERS_B B
, AHL_MR_HEADERS_TL T
WHERE B.MR_HEADER_ID = T.MR_HEADER_ID
AND T.LANGUAGE = USERENV('LANG')

Columns