Product: | AHL - Complex Maintenance Repair and Overhaul |
---|---|
Description: | This view gives both translation-independent and translatable Master Configuration header information. |
Implementation/DBA Data: | APPS.AHL_MC_HEADERS_VL |
SELECT MCHB.ROWID ROW_ID
, MCHB.MC_HEADER_ID
, MCHB.OBJECT_VERSION_NUMBER
, MCHB.CREATION_DATE
, MCHB.CREATED_BY
, MCHB.LAST_UPDATE_DATE
, MCHB.LAST_UPDATED_BY
, MCHB.LAST_UPDATE_LOGIN
, MCHB.NAME
, MCHB.MC_ID
, MCHB.VERSION_NUMBER
, MCHB.REVISION
, MCHB.CONFIG_STATUS_CODE
, MCHB.SECURITY_GROUP_ID
, MCHB.ATTRIBUTE_CATEGORY
, MCHB.ATTRIBUTE1
, MCHB.ATTRIBUTE2
, MCHB.ATTRIBUTE3
, MCHB.ATTRIBUTE4
, MCHB.ATTRIBUTE5
, MCHB.ATTRIBUTE6
, MCHB.ATTRIBUTE7
, MCHB.ATTRIBUTE8
, MCHB.ATTRIBUTE9
, MCHB.ATTRIBUTE10
, MCHB.ATTRIBUTE11
, MCHB.ATTRIBUTE12
, MCHB.ATTRIBUTE13
, MCHB.ATTRIBUTE14
, MCHB.ATTRIBUTE15
, MCHTL.DESCRIPTION
FROM AHL_MC_HEADERS_B MCHB
, AHL_MC_HEADERS_TL MCHTL
WHERE MCHB.MC_HEADER_ID = MCHTL.MC_HEADER_ID
AND MCHTL.LANGUAGE = USERENV('LANG')