View: ENG_ENGINEERING_CHANGES_ALL_V

Product:	ENG - Engineering
Description:	All engineering change orders
Implementation/DBA Data:	APPS.ENG_ENGINEERING_CHANGES_ALL_V

View Text

SELECT EEC.CHANGE_NOTICE
, EEC.DESCRIPTION
, EEC.ORGANIZATION_ID
, EEC.STATUS_TYPE
, EEC.LAST_UPDATE_DATE
, EEC.LAST_UPDATED_BY
, EEC.CREATION_DATE
, EEC.CREATED_BY
, EEC.LAST_UPDATE_LOGIN
, EEC.INITIATION_DATE
, EEC.IMPLEMENTATION_DATE
, EEC.CANCELLATION_DATE
, EEC.CANCELLATION_COMMENTS
, EEC.PRIORITY_CODE
, EEC.REASON_CODE
, EEC.ESTIMATED_ENG_COST
, EEC.ESTIMATED_MFG_COST
, EEC.REQUESTOR_ID
, EEC.ATTRIBUTE_CATEGORY
, EEC.ATTRIBUTE1
, EEC.ATTRIBUTE2
, EEC.ATTRIBUTE3
, EEC.ATTRIBUTE4
, EEC.ATTRIBUTE5
, EEC.ATTRIBUTE6
, EEC.ATTRIBUTE7
, EEC.ATTRIBUTE8
, EEC.ATTRIBUTE9
, EEC.ATTRIBUTE10
, EEC.ATTRIBUTE11
, EEC.ATTRIBUTE12
, EEC.ATTRIBUTE13
, EEC.ATTRIBUTE14
, EEC.ATTRIBUTE15
, EEC.REQUEST_ID
, EEC.PROGRAM_APPLICATION_ID
, EEC.PROGRAM_ID
, EEC.PROGRAM_UPDATE_DATE
, EEC.APPROVAL_STATUS_TYPE
, EEC.APPROVAL_DATE
, EEC.APPROVAL_LIST_ID
, EEC.CHANGE_ORDER_TYPE_ID
, EEC.RESPONSIBLE_ORGANIZATION_ID
, EEC.APPROVAL_REQUEST_DATE
, EEC.DDF_CONTEXT
, NVL(EEC.HIERARCHY_FLAG
, 2)
, EEC.ORGANIZATION_HIERARCHY
FROM ENG_ENGINEERING_CHANGES EEC

Columns