VIEW: APPS.AHL_ROUTE_OPERATIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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