View: AHL_MR_HEADERS_APP_V

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_APP_V

View Text

SELECT MR_HEADER_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, TITLE
, VERSION_NUMBER
, PRECEDING_MR_HEADER_ID
, CATEGORY_CODE
, SERVICE_TYPE_CODE
, MR_STATUS_CODE
, IMPLEMENT_STATUS_CODE
, REPETITIVE_FLAG
, SHOW_REPETITIVE_CODE
, WHICHEVER_FIRST_CODE
, COPY_ACCOMPLISHMENT_FLAG
, PROGRAM_TYPE_CODE
, PROGRAM_SUBTYPE_CODE
, EFFECTIVE_FROM
, EFFECTIVE_TO
, REVISION
, BILLING_ITEM_ID
, BILLING_ORG_ID
, SPACE_CATEGORY_CODE
, QA_INSPECTION_TYPE_CODE
, DESCRIPTION
, COMMENTS
, SERVICE_REQUEST_TEMPLATE_ID
, TYPE_CODE
, DOWN_TIME
, UOM_CODE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, APPLICATION_USG_CODE
FROM AHL_MR_HEADERS_VL
WHERE APPLICATION_USG_CODE=RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')))

Columns