VIEW: AHL.AHL_OPERATIONS_B#

Source

View Text - Preformatted

select OPERATION_ID OPERATION_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REVISION_NUMBER REVISION_NUMBER, REVISION_STATUS_CODE REVISION_STATUS_CODE, STANDARD_OPERATION_FLAG STANDARD_OPERATION_FLAG, ACTIVE_START_DATE ACTIVE_START_DATE, ACTIVE_END_DATE ACTIVE_END_DATE, OPERATION_NUMBER OPERATION_NUMBER, SEGMENT1 SEGMENT1, SEGMENT2 SEGMENT2, SEGMENT3 SEGMENT3, SEGMENT4 SEGMENT4, SEGMENT5 SEGMENT5, SEGMENT6 SEGMENT6, SEGMENT7 SEGMENT7, PRODUCT_TYPE_CODE PRODUCT_TYPE_CODE, ZONE_CODE ZONE_CODE, SUB_ZONE_CODE SUB_ZONE_CODE, OPERATION_CATEGORY_CODE OPERATION_CATEGORY_CODE, OPERATION_TYPE_CODE OPERATION_TYPE_CODE, WORK_CENTER_CODE WORK_CENTER_CODE, SYSTEM_CODE1 SYSTEM_CODE1, SYSTEM_CODE2 SYSTEM_CODE2, SYSTEM_CODE3 SYSTEM_CODE3, PROCESS_CODE PROCESS_CODE, OPERATOR_CODE OPERATOR_CODE, OPERATOR_PARTY_ID OPERATOR_PARTY_ID, OPRPRIM_SKILL_TYPE_CODE OPRPRIM_SKILL_TYPE_CODE, SKILL_COMPETENCE_ID SKILL_COMPETENCE_ID, TIME_SPAN TIME_SPAN, SECURITY_GROUP_ID SECURITY_GROUP_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, QA_PLAN_ID QA_PLAN_ID, SEGMENT8 SEGMENT8, SEGMENT9 SEGMENT9, SEGMENT10 SEGMENT10, SEGMENT11 SEGMENT11, SEGMENT12 SEGMENT12, SEGMENT13 SEGMENT13, SEGMENT14 SEGMENT14, SEGMENT15 SEGMENT15, SUMMARY_FLAG SUMMARY_FLAG, ENABLED_FLAG ENABLED_FLAG, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, QA_INSPECTION_TYPE QA_INSPECTION_TYPE, MODEL_CODE MODEL_CODE, ENIGMA_OP_ID ENIGMA_OP_ID, ENIGMA_SOURCE ENIGMA_SOURCE, ENIGMA_DOC_ID ENIGMA_DOC_ID from "AHL"."AHL_OPERATIONS_B"

View Text - HTML Formatted

SELECT OPERATION_ID OPERATION_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REVISION_NUMBER REVISION_NUMBER
, REVISION_STATUS_CODE REVISION_STATUS_CODE
, STANDARD_OPERATION_FLAG STANDARD_OPERATION_FLAG
, ACTIVE_START_DATE ACTIVE_START_DATE
, ACTIVE_END_DATE ACTIVE_END_DATE
, OPERATION_NUMBER OPERATION_NUMBER
, SEGMENT1 SEGMENT1
, SEGMENT2 SEGMENT2
, SEGMENT3 SEGMENT3
, SEGMENT4 SEGMENT4
, SEGMENT5 SEGMENT5
, SEGMENT6 SEGMENT6
, SEGMENT7 SEGMENT7
, PRODUCT_TYPE_CODE PRODUCT_TYPE_CODE
, ZONE_CODE ZONE_CODE
, SUB_ZONE_CODE SUB_ZONE_CODE
, OPERATION_CATEGORY_CODE OPERATION_CATEGORY_CODE
, OPERATION_TYPE_CODE OPERATION_TYPE_CODE
, WORK_CENTER_CODE WORK_CENTER_CODE
, SYSTEM_CODE1 SYSTEM_CODE1
, SYSTEM_CODE2 SYSTEM_CODE2
, SYSTEM_CODE3 SYSTEM_CODE3
, PROCESS_CODE PROCESS_CODE
, OPERATOR_CODE OPERATOR_CODE
, OPERATOR_PARTY_ID OPERATOR_PARTY_ID
, OPRPRIM_SKILL_TYPE_CODE OPRPRIM_SKILL_TYPE_CODE
, SKILL_COMPETENCE_ID SKILL_COMPETENCE_ID
, TIME_SPAN TIME_SPAN
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, QA_PLAN_ID QA_PLAN_ID
, SEGMENT8 SEGMENT8
, SEGMENT9 SEGMENT9
, SEGMENT10 SEGMENT10
, SEGMENT11 SEGMENT11
, SEGMENT12 SEGMENT12
, SEGMENT13 SEGMENT13
, SEGMENT14 SEGMENT14
, SEGMENT15 SEGMENT15
, SUMMARY_FLAG SUMMARY_FLAG
, ENABLED_FLAG ENABLED_FLAG
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, QA_INSPECTION_TYPE QA_INSPECTION_TYPE
, MODEL_CODE MODEL_CODE
, ENIGMA_OP_ID ENIGMA_OP_ID
, ENIGMA_SOURCE ENIGMA_SOURCE
, ENIGMA_DOC_ID ENIGMA_DOC_ID
FROM "AHL"."AHL_OPERATIONS_B"