VIEW: AHL.AHL_ROUTES_B#

Source

View Text - Preformatted

select ROUTE_ID ROUTE_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, ROUTE_NO ROUTE_NO, REVISION_NUMBER REVISION_NUMBER, REVISION_STATUS_CODE REVISION_STATUS_CODE, ACTIVE_START_DATE ACTIVE_START_DATE, ACTIVE_END_DATE ACTIVE_END_DATE, PRODUCT_TYPE_CODE PRODUCT_TYPE_CODE, ZONE_CODE ZONE_CODE, ROUTE_CATEGORY_CODE ROUTE_CATEGORY_CODE, ROUTE_TYPE_CODE ROUTE_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, RTPRIM_SKILL_TYPE_CODE RTPRIM_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, SERVICE_ITEM_ID SERVICE_ITEM_ID, SERVICE_ITEM_ORG_ID SERVICE_ITEM_ORG_ID, TASK_TEMPLATE_GROUP_ID TASK_TEMPLATE_GROUP_ID, ACCOUNTING_CLASS_CODE ACCOUNTING_CLASS_CODE, ACCOUNTING_CLASS_ORG_ID ACCOUNTING_CLASS_ORG_ID, SUB_ZONE_CODE SUB_ZONE_CODE, SEGMENT1 SEGMENT1, SEGMENT2 SEGMENT2, SEGMENT3 SEGMENT3, SEGMENT4 SEGMENT4, SEGMENT5 SEGMENT5, SEGMENT6 SEGMENT6, SEGMENT7 SEGMENT7, 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, APPLICATION_USG_CODE APPLICATION_USG_CODE, UNIT_RECEIPT_UPDATE_FLAG UNIT_RECEIPT_UPDATE_FLAG, MODEL_CODE MODEL_CODE, ENIGMA_ROUTE_ID ENIGMA_ROUTE_ID, ENIGMA_DOC_ID ENIGMA_DOC_ID, FILE_ID FILE_ID, ENIGMA_PUBLISH_DATE ENIGMA_PUBLISH_DATE, JOBCARDLYT_CODE JOBCARDLYT_CODE, ENIGMA_SOURCE_CODE ENIGMA_SOURCE_CODE, WARRANTY_TEMPLATE_ID WARRANTY_TEMPLATE_ID, DUPLICATE_FLAG DUPLICATE_FLAG, RETURN_TO_SUPPLY_FLAG RETURN_TO_SUPPLY_FLAG from "AHL"."AHL_ROUTES_B"

View Text - HTML Formatted

SELECT ROUTE_ID ROUTE_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
, ROUTE_NO ROUTE_NO
, REVISION_NUMBER REVISION_NUMBER
, REVISION_STATUS_CODE REVISION_STATUS_CODE
, ACTIVE_START_DATE ACTIVE_START_DATE
, ACTIVE_END_DATE ACTIVE_END_DATE
, PRODUCT_TYPE_CODE PRODUCT_TYPE_CODE
, ZONE_CODE ZONE_CODE
, ROUTE_CATEGORY_CODE ROUTE_CATEGORY_CODE
, ROUTE_TYPE_CODE ROUTE_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
, RTPRIM_SKILL_TYPE_CODE RTPRIM_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
, SERVICE_ITEM_ID SERVICE_ITEM_ID
, SERVICE_ITEM_ORG_ID SERVICE_ITEM_ORG_ID
, TASK_TEMPLATE_GROUP_ID TASK_TEMPLATE_GROUP_ID
, ACCOUNTING_CLASS_CODE ACCOUNTING_CLASS_CODE
, ACCOUNTING_CLASS_ORG_ID ACCOUNTING_CLASS_ORG_ID
, SUB_ZONE_CODE SUB_ZONE_CODE
, SEGMENT1 SEGMENT1
, SEGMENT2 SEGMENT2
, SEGMENT3 SEGMENT3
, SEGMENT4 SEGMENT4
, SEGMENT5 SEGMENT5
, SEGMENT6 SEGMENT6
, SEGMENT7 SEGMENT7
, 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
, APPLICATION_USG_CODE APPLICATION_USG_CODE
, UNIT_RECEIPT_UPDATE_FLAG UNIT_RECEIPT_UPDATE_FLAG
, MODEL_CODE MODEL_CODE
, ENIGMA_ROUTE_ID ENIGMA_ROUTE_ID
, ENIGMA_DOC_ID ENIGMA_DOC_ID
, FILE_ID FILE_ID
, ENIGMA_PUBLISH_DATE ENIGMA_PUBLISH_DATE
, JOBCARDLYT_CODE JOBCARDLYT_CODE
, ENIGMA_SOURCE_CODE ENIGMA_SOURCE_CODE
, WARRANTY_TEMPLATE_ID WARRANTY_TEMPLATE_ID
, DUPLICATE_FLAG DUPLICATE_FLAG
, RETURN_TO_SUPPLY_FLAG RETURN_TO_SUPPLY_FLAG
FROM "AHL"."AHL_ROUTES_B"