View: AHL_OPERATIONS_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	View based on the views AHL_OPERATIONS_VL and FND_LOOKUP_VALUES_VL to include all the codes and their corresponding descriptions.
Implementation/DBA Data:	APPS.AHL_OPERATIONS_V

View Text

SELECT O.OPERATION_ID
, O.OBJECT_VERSION_NUMBER
, O.LAST_UPDATE_DATE
, O.LAST_UPDATED_BY
, O.CREATION_DATE
, O.CREATED_BY
, O.LAST_UPDATE_LOGIN
, O.STANDARD_OPERATION_FLAG
, ST.MEANING
, O.REVISION_NUMBER
, O.REVISION_STATUS_CODE
, REVST.MEANING
, O.SUMMARY_FLAG
, O.ENABLED_FLAG
, O.START_DATE_ACTIVE
, O.END_DATE_ACTIVE
, O.OPERATION_TYPE_CODE
, OPTYPE.MEANING
, O.PROCESS_CODE
, PROCESS.MEANING
, O.QA_INSPECTION_TYPE
, QAL.DESCRIPTION
, O.SEGMENT1
, O.SEGMENT2
, O.SEGMENT3
, O.SEGMENT4
, O.SEGMENT5
, O.SEGMENT6
, O.SEGMENT7
, O.SEGMENT8
, O.SEGMENT9
, O.SEGMENT10
, O.SEGMENT11
, O.SEGMENT12
, O.SEGMENT13
, O.SEGMENT14
, O.SEGMENT15
, O.CONCATENATED_SEGMENTS
, O.DESCRIPTION
, O.REMARKS
, O.REVISION_NOTES
, O.APPROVER_NOTE
, O.ATTRIBUTE_CATEGORY
, O.ATTRIBUTE1
, O.ATTRIBUTE2
, O.ATTRIBUTE3
, O.ATTRIBUTE4
, O.ATTRIBUTE5
, O.ATTRIBUTE6
, O.ATTRIBUTE7
, O.ATTRIBUTE8
, O.ATTRIBUTE9
, O.ATTRIBUTE10
, O.ATTRIBUTE11
, O.ATTRIBUTE12
, O.ATTRIBUTE13
, O.ATTRIBUTE14
, O.ATTRIBUTE15
FROM AHL_OPERATIONS_VL O
, FND_LOOKUP_VALUES_VL ST
, FND_LOOKUP_VALUES_VL REVST
, FND_LOOKUP_VALUES_VL OPTYPE
, FND_LOOKUP_VALUES_VL PROCESS
, QA_CHAR_VALUE_LOOKUPS_V QAL
WHERE REVST.LOOKUP_TYPE = 'AHL_REVISION_STATUS'
AND REVST.LOOKUP_CODE = O.REVISION_STATUS_CODE
AND ST.LOOKUP_TYPE = 'AHL_YES_NO_TYPE'
AND ST.LOOKUP_CODE = O.STANDARD_OPERATION_FLAG
AND OPTYPE.LOOKUP_TYPE (+) = 'AHL_OPERATION_TYPE'
AND OPTYPE.LOOKUP_CODE (+) = O.OPERATION_TYPE_CODE
AND PROCESS.LOOKUP_TYPE (+) = 'AHL_PROCESS_CODE'
AND PROCESS.LOOKUP_CODE (+) = O.PROCESS_CODE
AND QAL.SHORT_CODE (+) = O.QA_INSPECTION_TYPE

Columns