View: AHL_ROUTES_H_VL

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

View Text

SELECT AHRO.ROWID ROW_ID
, AHRO.ROUTES_H_ID
, AHRO.OBJECT_VERSION_NUMBER
, AHRO.LAST_UPDATE_DATE
, AHRO.LAST_UPDATED_BY
, AHRO.CREATION_DATE
, AHRO.CREATED_BY
, AHRO.LAST_UPDATE_LOGIN
, AHRO.ROUTE_ID
, AHRO.ROUTE_NO
, AHRO.REVISION_NUMBER
, AHRO.REVISION_STATUS_CODE
, AHRO.ACTIVE_START_DATE
, AHRO.ACTIVE_END_DATE
, AHROTL.TITLE
, AHRO.PRODUCT_TYPE_CODE
, AHRO.ZONE_CODE
, AHRO.ROUTE_CATEGORY_CODE
, AHRO.ROUTE_TYPE_CODE
, AHRO.WORK_CENTER_CODE
, AHRO.SYSTEM_CODE1
, AHRO.SYSTEM_CODE2
, AHRO.SYSTEM_CODE3
, AHRO.PROCESS_CODE
, AHRO.OPERATOR_PARTY_ID
, AHRO.SKILL_COMPETENCE_ID
, AHRO.TIME_SPAN
, AHROTL.NOTE
, AHRO.ATTRIBUTE_CATEGORY
, AHRO.ATTRIBUTE1
, AHRO.ATTRIBUTE2
, AHRO.ATTRIBUTE3
, AHRO.ATTRIBUTE4
, AHRO.ATTRIBUTE5
, AHRO.ATTRIBUTE6
, AHRO.ATTRIBUTE7
, AHRO.ATTRIBUTE8
, AHRO.ATTRIBUTE9
, AHRO.ATTRIBUTE10
, AHRO.ATTRIBUTE11
, AHRO.ATTRIBUTE12
, AHRO.ATTRIBUTE13
, AHRO.ATTRIBUTE14
, AHRO.ATTRIBUTE15
FROM AHL_ROUTES_H_B AHRO
, AHL_ROUTES_H_TL AHROTL
WHERE AHRO.ROUTES_H_ID = AHROTL.ROUTES_H_ID
AND AHROTL.LANGUAGE = USERENV('LANG')

Columns