VIEW: ENG.ENG_CHANGE_ORDER_TYPES#

Source

View Text - Preformatted

select CHANGE_ORDER_TYPE_ID CHANGE_ORDER_TYPE_ID, CHANGE_ORDER_TYPE CHANGE_ORDER_TYPE, 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, CHANGE_ORDER_ORGANIZATION_ID CHANGE_ORDER_ORGANIZATION_ID, DESCRIPTION DESCRIPTION, ASSEMBLY_TYPE ASSEMBLY_TYPE, DISABLE_DATE DISABLE_DATE, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CHANGE_MGMT_TYPE_CODE CHANGE_MGMT_TYPE_CODE, START_DATE START_DATE, DEFAULT_ASSIGNEE_FROM_ROLE_ID DEFAULT_ASSIGNEE_FROM_ROLE_ID, DEFAULT_ASSIGNEE_ID DEFAULT_ASSIGNEE_ID, OBJECT_ID OBJECT_ID, SUBJECT_ID SUBJECT_ID, AUTO_NUMBERING_METHOD AUTO_NUMBERING_METHOD, DEFAULT_ASSIGNEE_TYPE DEFAULT_ASSIGNEE_TYPE, TYPE_CLASSIFICATION TYPE_CLASSIFICATION, CLASS_CODE_DERIVED_FLAG CLASS_CODE_DERIVED_FLAG, SEQUENCE_NUMBER SEQUENCE_NUMBER, BASE_CHANGE_MGMT_TYPE_CODE BASE_CHANGE_MGMT_TYPE_CODE, SEEDED_FLAG SEEDED_FLAG, ENABLE_ITEM_IN_LOCAL_ORG ENABLE_ITEM_IN_LOCAL_ORG, CREATE_BOM_IN_LOCAL_ORG CREATE_BOM_IN_LOCAL_ORG, SUBJECT_UPDATABLE_FLAG SUBJECT_UPDATABLE_FLAG, XML_DATA_SOURCE_CODE XML_DATA_SOURCE_CODE, ZD_EDITION_NAME ZD_EDITION_NAME from "ENG"."ENG_CHANGE_ORDER_TYPES"

View Text - HTML Formatted

SELECT CHANGE_ORDER_TYPE_ID CHANGE_ORDER_TYPE_ID
, CHANGE_ORDER_TYPE CHANGE_ORDER_TYPE
, 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
, CHANGE_ORDER_ORGANIZATION_ID CHANGE_ORDER_ORGANIZATION_ID
, DESCRIPTION DESCRIPTION
, ASSEMBLY_TYPE ASSEMBLY_TYPE
, DISABLE_DATE DISABLE_DATE
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CHANGE_MGMT_TYPE_CODE CHANGE_MGMT_TYPE_CODE
, START_DATE START_DATE
, DEFAULT_ASSIGNEE_FROM_ROLE_ID DEFAULT_ASSIGNEE_FROM_ROLE_ID
, DEFAULT_ASSIGNEE_ID DEFAULT_ASSIGNEE_ID
, OBJECT_ID OBJECT_ID
, SUBJECT_ID SUBJECT_ID
, AUTO_NUMBERING_METHOD AUTO_NUMBERING_METHOD
, DEFAULT_ASSIGNEE_TYPE DEFAULT_ASSIGNEE_TYPE
, TYPE_CLASSIFICATION TYPE_CLASSIFICATION
, CLASS_CODE_DERIVED_FLAG CLASS_CODE_DERIVED_FLAG
, SEQUENCE_NUMBER SEQUENCE_NUMBER
, BASE_CHANGE_MGMT_TYPE_CODE BASE_CHANGE_MGMT_TYPE_CODE
, SEEDED_FLAG SEEDED_FLAG
, ENABLE_ITEM_IN_LOCAL_ORG ENABLE_ITEM_IN_LOCAL_ORG
, CREATE_BOM_IN_LOCAL_ORG CREATE_BOM_IN_LOCAL_ORG
, SUBJECT_UPDATABLE_FLAG SUBJECT_UPDATABLE_FLAG
, XML_DATA_SOURCE_CODE XML_DATA_SOURCE_CODE
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "ENG"."ENG_CHANGE_ORDER_TYPES"