View: AHL_ROUTE_OPERATIONS_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	View based on the table AHL_ROUTE_OPERATIONS and the view AHL_OPERATIONS_VL to include some attributes of the operations.
Implementation/DBA Data:	APPS.AHL_ROUTE_OPERATIONS_V

View Text

SELECT ARO.ROUTE_OPERATION_ID
, ARO.OBJECT_VERSION_NUMBER
, ARO.LAST_UPDATE_DATE
, ARO.LAST_UPDATED_BY
, ARO.CREATION_DATE
, ARO.CREATED_BY
, ARO.LAST_UPDATE_LOGIN
, ARO.ROUTE_ID
, ARO.OPERATION_ID
, ARO.STEP
, ARO.REVISION_NUMBER
, AO.STANDARD_OPERATION_FLAG
, STD.MEANING
, AO.DESCRIPTION
, AO.START_DATE_ACTIVE
, AO.END_DATE_ACTIVE
, ARO.CHECK_POINT_FLAG
, CHKPT.MEANING
, AO.CONCATENATED_SEGMENTS
, ARO.ATTRIBUTE_CATEGORY
, ARO.ATTRIBUTE1
, ARO.ATTRIBUTE2
, ARO.ATTRIBUTE3
, ARO.ATTRIBUTE4
, ARO.ATTRIBUTE5
, ARO.ATTRIBUTE6
, ARO.ATTRIBUTE7
, ARO.ATTRIBUTE8
, ARO.ATTRIBUTE9
, ARO.ATTRIBUTE10
, ARO.ATTRIBUTE11
, ARO.ATTRIBUTE12
, ARO.ATTRIBUTE13
, ARO.ATTRIBUTE14
, ARO.ATTRIBUTE15
FROM AHL_OPERATIONS_VL AO
, AHL_ROUTE_OPERATIONS ARO
, FND_LOOKUP_VALUES_VL CHKPT
, FND_LOOKUP_VALUES_VL STD
WHERE CHKPT.LOOKUP_TYPE = 'AHL_YES_NO_TYPE'
AND CHKPT.LOOKUP_CODE (+) = ARO.CHECK_POINT_FLAG
AND STD.LOOKUP_TYPE (+) = 'AHL_YES_NO_TYPE'
AND STD.LOOKUP_CODE = AO.STANDARD_OPERATION_FLAG
AND AO.OPERATION_ID = ARO.OPERATION_ID

Columns