VIEW: APPS.ENG_CHANGE_ORDER_TYPES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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