FND Design Data [Home] [Help]

View: ENG_CHANGE_ORDER_TYPES_V

Product: ENG - Engineering
Description: Engineering change order types - all records
Implementation/DBA Data: ViewAPPS.ENG_CHANGE_ORDER_TYPES_V
View Text

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

Columns

Name
CHANGE_ORDER_TYPE_ID
CHANGE_ORDER_TYPE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
CHANGE_ORDER_ORGANIZATION_ID
DESCRIPTION
ASSEMBLY_TYPE
ASSEMBLY_TYPE_DESCRIPTION
DISABLE_DATE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
CHANGE_MGMT_TYPE_CODE
SUBJECT_ID
AUTO_NUMBERING_METHOD
DEFAULT_ASSIGNEE_TYPE
TYPE_CLASSIFICATION
CLASS_CODE_DERIVED_FLAG
SEQUENCE_NUMBER
BASE_CHANGE_MGMT_TYPE_CODE
SEEDED_FLAG
ENABLE_ITEM_IN_LOCAL_ORG
TAB_TEXT
CREATE_BOM_IN_LOCAL_ORG
START_DATE
TYPE_NAME
DEFAULT_ASSIGNEE_ID
OBJECT_ID
SUBJECT_UPDATABLE_FLAG
XML_DATA_SOURCE_CODE