View: AHL_OPERATIONS_H_VL

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

View Text

SELECT AHOP.ROWID ROW_ID
, AHOP.OPERATIONS_H_ID
, AHOP.OBJECT_VERSION_NUMBER
, AHOP.LAST_UPDATE_DATE
, AHOP.LAST_UPDATED_BY
, AHOP.CREATION_DATE
, AHOP.CREATED_BY
, AHOP.LAST_UPDATE_LOGIN
, AHOP.OPERATION_ID
, AHOP.REVISION_NUMBER
, AHOP.REVISION_STATUS_CODE
, AHOP.STANDARD_OPERATION_FLAG
, AHOPTL.OPERATION_DESCRIPTION
, AHOP.ACTIVE_START_DATE
, AHOP.ACTIVE_END_DATE
, AHOP.OPERATION_NUMBER
, AHOP.SEGMENT1
, AHOP.SEGMENT2
, AHOP.SEGMENT3
, AHOP.SEGMENT4
, AHOP.SEGMENT5
, AHOP.SEGMENT6
, AHOP.SEGMENT7
, AHOP.PRODUCT_TYPE_CODE
, AHOP.ZONE_CODE
, AHOP.SUB_ZONE_CODE
, AHOP.OPERATION_CATEGORY_CODE
, AHOP.OPERATION_TYPE_CODE
, AHOP.WORK_CENTER_CODE
, AHOP.SYSTEM_CODE1
, AHOP.SYSTEM_CODE2
, AHOP.SYSTEM_CODE3
, AHOP.PROCESS_CODE
, AHOP.OPERATOR_PARTY_ID
, AHOP.SKILL_COMPETENCE_ID
, AHOP.TIME_SPAN
, AHOPTL.REMARKS
, AHOPTL.NOTE
, AHOP.ATTRIBUTE_CATEGORY
, AHOP.ATTRIBUTE1
, AHOP.ATTRIBUTE2
, AHOP.ATTRIBUTE3
, AHOP.ATTRIBUTE4
, AHOP.ATTRIBUTE5
, AHOP.ATTRIBUTE6
, AHOP.ATTRIBUTE7
, AHOP.ATTRIBUTE8
, AHOP.ATTRIBUTE9
, AHOP.ATTRIBUTE10
, AHOP.ATTRIBUTE11
, AHOP.ATTRIBUTE12
, AHOP.ATTRIBUTE13
, AHOP.ATTRIBUTE14
, AHOP.ATTRIBUTE15
FROM AHL_OPERATIONS_H_B AHOP
, AHL_OPERATIONS_H_TL AHOPTL
WHERE AHOP. OPERATIONS_H_ID = AHOPTL. OPERATIONS_H_ID
AND AHOPTL.LANGUAGE =USERENV('LANG')

Columns