VIEW: APPS.AHL_OPERATIONS_V

Source

View Text - Preformatted

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, O.MODEL_CODE, MODEL.MEANING, O.ENIGMA_OP_ID, O.ENIGMA_SOURCE_CODE, ES.MEANING, O.ENIGMA_DOC_ID 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, FND_LOOKUP_VALUES_VL MODEL, FND_LOOKUP_VALUES_VL ES 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 MODEL.LOOKUP_TYPE (+) = 'AHL_ENIGMA_MODEL_CODE' AND MODEL.LOOKUP_CODE (+) = O.MODEL_CODE AND ES.LOOKUP_TYPE (+) = 'AHL_ENIGMA_SOURCE_TYPE' AND ES.LOOKUP_CODE (+) = O.ENIGMA_SOURCE_CODE AND QAL.SHORT_CODE (+) = O.QA_INSPECTION_TYPE AND NVL(QAL.CHAR_ID,87)=87

View Text - HTML Formatted

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
, O.MODEL_CODE
, MODEL.MEANING
, O.ENIGMA_OP_ID
, O.ENIGMA_SOURCE_CODE
, ES.MEANING
, O.ENIGMA_DOC_ID
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
, FND_LOOKUP_VALUES_VL MODEL
, FND_LOOKUP_VALUES_VL ES
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 MODEL.LOOKUP_TYPE (+) = 'AHL_ENIGMA_MODEL_CODE'
AND MODEL.LOOKUP_CODE (+) = O.MODEL_CODE
AND ES.LOOKUP_TYPE (+) = 'AHL_ENIGMA_SOURCE_TYPE'
AND ES.LOOKUP_CODE (+) = O.ENIGMA_SOURCE_CODE
AND QAL.SHORT_CODE (+) = O.QA_INSPECTION_TYPE
AND NVL(QAL.CHAR_ID
, 87)=87