View: ENG_ENGINEERING_CHANGES_V

Product:	ENG - Engineering
Description:	Engineering change orders
Implementation/DBA Data:	APPS.ENG_ENGINEERING_CHANGES_V

View Text

SELECT EEC.ROWID ROW_ID
, EEC.CHANGE_NOTICE
, EEC.ORGANIZATION_ID
, EEC.LAST_UPDATE_DATE
, EEC.LAST_UPDATED_BY
, EEC.CREATION_DATE
, EEC.CREATED_BY
, EEC.LAST_UPDATE_LOGIN
, EEC.DESCRIPTION
, EEC.STATUS_TYPE
, ECSVL.STATUS_NAME ECO_STATUS
, MLU2.MEANING APPROVAL_STATUS
, EEC.INITIATION_DATE
, EEC.IMPLEMENTATION_DATE
, EEC.CANCELLATION_DATE
, EEC.CANCELLATION_COMMENTS
, EEC.PRIORITY_CODE
, ECP.DESCRIPTION PRIORITY_CODE_DESCRIPTION
, EEC.REASON_CODE
, ECR.DESCRIPTION REASON_CODE_DESCRIPTION
, EEC.ESTIMATED_ENG_COST
, EEC.ESTIMATED_MFG_COST
, EEC.REQUESTOR_ID
, EEC.CHANGE_ORDER_TYPE_ID
, ECOT.TYPE_NAME CHANGE_ORDER_TYPE
, ECOT.DESCRIPTION CHANGE_ORDER_TYPE_DESCRIPTION
, ECOT.ASSEMBLY_TYPE ASSEMBLY_TYPE
, EEC.RESPONSIBLE_ORGANIZATION_ID
, HOU.NAME ECO_DEPARTMENT
, EEC.APPROVAL_STATUS_TYPE
, EEC.APPROVAL_DATE
, EEC.APPROVAL_LIST_ID
, EEAL.APPROVAL_LIST_NAME APPROVAL_LIST_NAME
, EEAL.DESCRIPTION APPROVAL_LIST_NAME_DESCRIPTION
, EEC.APPROVAL_REQUEST_DATE
, (EEC.APPROVAL_DATE - EEC.APPROVAL_REQUEST_DATE) DAYS_TO_APPROVE
, 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
, PPA.PROJECT_NAME
, PPA.PROJECT_NUMBER
, EEC.PROJECT_ID
, PT.TASK_NAME
, PT.TASK_NUMBER
, EEC.TASK_ID
, NVL(EEC.HIERARCHY_FLAG
, 2)
, EEC.HIERARCHY_ID
, POS.NAME
, EEC.CHANGE_ID
, EEC.CHANGE_MGMT_TYPE_CODE
, EEC.ASSIGNEE_ID
, EEC.PLM_OR_ERP_CHANGE
, EEC.STATUS_CODE
FROM ENG_CHANGE_ORDER_TYPES_V ECOT
, ENG_CHANGE_REASONS ECR
, ENG_CHANGE_PRIORITIES ECP
, ENG_ECN_APPROVAL_LISTS EEAL
, HR_ORGANIZATION_UNITS HOU
, MFG_LOOKUPS MLU2
, ENG_ENGINEERING_CHANGES EEC
, PJM_PROJECTS_V PPA
, PA_TASKS PT
, PER_ORGANIZATION_STRUCTURES POS
, ENG_CHANGE_STATUSES_VL ECSVL
WHERE EEC.CHANGE_ORDER_TYPE_ID = ECOT.CHANGE_ORDER_TYPE_ID
AND EEC.REASON_CODE = ECR.ENG_CHANGE_REASON_CODE(+)
AND ECR.ORGANIZATION_ID(+) = -1
AND EEC.PRIORITY_CODE = ECP.ENG_CHANGE_PRIORITY_CODE(+)
AND ECP.ORGANIZATION_ID(+) = -1
AND EEC.APPROVAL_LIST_ID = EEAL.APPROVAL_LIST_ID(+)
AND EEC.RESPONSIBLE_ORGANIZATION_ID = HOU.ORGANIZATION_ID(+)
AND EEC.PROJECT_ID = PPA.PROJECT_ID(+)
AND EEC.PROJECT_ID = PT.PROJECT_ID(+)
AND EEC.TASK_ID = PT.TASK_ID(+)
AND EEC.STATUS_TYPE = ECSVL.STATUS_CODE(+)
AND EEC.APPROVAL_STATUS_TYPE = MLU2.LOOKUP_CODE(+)
AND MLU2.LOOKUP_TYPE = 'ENG_ECN_APPROVAL_STATUS'
AND HIERARCHY_ID = POS.ORGANIZATION_STRUCTURE_ID(+)
AND ECOT.CHANGE_MGMT_TYPE_CODE =EEC.CHANGE_MGMT_TYPE_CODE
AND ECOT.BASE_CHANGE_MGMT_TYPE_CODE='CHANGE_ORDER'

Columns