Product: | ENG - Engineering |
---|---|
Description: | Engineering change order types - all records |
Implementation/DBA Data: | APPS.ENG_CHANGE_ORDER_TYPES_V |
SELECT ECOT.CHANGE_ORDER_TYPE_ID
, ECOT. CHANGE_ORDER_TYPE
, ECOT.LAST_UPDATE_DATE
, ECOT.LAST_UPDATED_BY
, ECOT.CREATION_DATE
, ECOT.CREATED_BY
, ECOT.LAST_UPDATE_LOGIN
, ECOT.CHANGE_ORDER_ORGANIZATION_ID
, ECOT.DESCRIPTION
, ECOT.ASSEMBLY_TYPE
, ECOT. ASSEMBLY_TYPE_DESCRIPTION
, ECOT.DISABLE_DATE
, ECOT.ATTRIBUTE_CATEGORY
, ECOT.ATTRIBUTE1
, ECOT.ATTRIBUTE2
, ECOT.ATTRIBUTE3
, ECOT.ATTRIBUTE4
, ECOT.ATTRIBUTE5
, ECOT.ATTRIBUTE6
, ECOT.ATTRIBUTE7
, ECOT.ATTRIBUTE8
, ECOT.ATTRIBUTE9
, ECOT.ATTRIBUTE10
, ECOT.ATTRIBUTE11
, ECOT.ATTRIBUTE12
, ECOT.ATTRIBUTE13
, ECOT.ATTRIBUTE14
, ECOT.ATTRIBUTE15
, ECOT.REQUEST_ID
, ECOT.PROGRAM_APPLICATION_ID
, ECOT.PROGRAM_ID
, ECOT.PROGRAM_UPDATE_DATE
, ECOT.CHANGE_MGMT_TYPE_CODE
, ECOT.SUBJECT_ID
, ECOT.AUTO_NUMBERING_METHOD
, ECOT.DEFAULT_ASSIGNEE_TYPE
, ECOT.TYPE_CLASSIFICATION
, ECOT.CLASS_CODE_DERIVED_FLAG
, ECOT.SEQUENCE_NUMBER
, ECOT.BASE_CHANGE_MGMT_TYPE_CODE
, ECOT.SEEDED_FLAG
, ECOT.ENABLE_ITEM_IN_LOCAL_ORG
, ECOT.TAB_TEXT
, ECOT.CREATE_BOM_IN_LOCAL_ORG
, ECOT.START_DATE
, ECOT.TYPE_NAME
, ECOT.DEFAULT_ASSIGNEE_ID
, ECOT.OBJECT_ID
, ECOT.SUBJECT_UPDATABLE_FLAG
, ECOT.XML_DATA_SOURCE_CODE
FROM ENG_CHANGE_ORDER_TYPES_VL ECOT