View: ENG_CHANGES_V

Product:	ENG - Engineering
Description:
Implementation/DBA Data:	APPS.ENG_CHANGES_V

View Text

SELECT EEC.ROWID ROW_ID
, EEC.CHANGE_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
, 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.CHANGE_ORDER_TYPE_ID
, ECOT.TYPE_NAME CHANGE_ORDER_TYPE
, EEC.RESPONSIBLE_ORGANIZATION_ID
, EEC.APPROVAL_STATUS_TYPE
, MLU2.MEANING APPROVAL_STATUS
, EEC.APPROVAL_DATE
, EEC.APPROVAL_LIST_ID
, 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
, EEC.HIERARCHY_ID
, NVL(EEC.HIERARCHY_FLAG
, 2)
, POS.NAME
, EEC.ASSIGNEE_ID
, HZA.PARTY_NAME
, HZR.PARTY_NAME
, EEC.CHANGE_MGMT_TYPE_CODE
, EEC.NEED_BY_DATE
, EEC.INTERNAL_USE_ONLY
, EEC.SOURCE_TYPE_CODE
, EEC.SOURCE_ID
, EEC.SOURCE_NAME
, EEC.EFFORT
, EEC.CHANGE_NAME
, EEC.ROUTE_ID
, EEC.CHANGE_NOTICE_PREFIX
, EEC.CHANGE_NOTICE_NUMBER
, PPA.NAME PROJECT_NAME
, PPA.SEGMENT1 PROJECT_NUMBER
, EEC.PROJECT_ID
, PPE.NAME TASK_NAME
, PPE.ELEMENT_NUMBER TASK_NUMBER
, EEC.TASK_ID
, (TRUNC(SYSDATE) -TRUNC( NVL(INITIATION_DATE
, SYSDATE))) REPORTED_DAYS_SINCE
, (TRUNC(SYSDATE) -TRUNC( EEC.LAST_UPDATE_DATE)) DAYS_SINCE_UPDATED
, (TRUNC(EEC.NEED_BY_DATE) - TRUNC(SYSDATE)) DAYS_UNTIL_DUE
, EEC.STATUS_CODE
, EEC.RESOLUTION
, EEC.CLASSIFICATION_ID
, EEC. PLM_OR_ERP_CHANGE
, EEC.EXPIRATION_DATE
, CLASS.CLASSIFICATION_NAME
, LOOKUPS.MEANING
, EEC.IMPLEMENTATION_REQ_ID
, ECOT.ASSEMBLY_TYPE
, ECOT.BASE_CHANGE_MGMT_TYPE_CODE
FROM ENG_CHANGE_ORDER_TYPES_VL ECOT
, ENG_CHANGE_STATUSES_VL ECSVL
, MFG_LOOKUPS MLU2
, HZ_PARTIES HZA
, HZ_PARTIES HZR
, PER_ORGANIZATION_STRUCTURES POS
, ENG_ENGINEERING_CHANGES EEC
, PA_PROJECTS_ALL PPA
, PA_PROJ_ELEMENTS PPE
, ENG_CHANGE_CLASSIFICATIONS_VL CLASS
, FND_LOOKUP_VALUES LOOKUPS
WHERE EEC.CHANGE_ORDER_TYPE_ID = ECOT.CHANGE_ORDER_TYPE_ID
AND HZA.PARTY_ID(+) = EEC.ASSIGNEE_ID
AND HZR.PARTY_ID(+) = EEC.REQUESTOR_ID
AND EEC.STATUS_CODE = ECSVL.STATUS_CODE
AND EEC.APPROVAL_STATUS_TYPE = MLU2.LOOKUP_CODE(+)
AND MLU2.LOOKUP_TYPE(+) = 'ENG_ECN_APPROVAL_STATUS'
AND EEC.HIERARCHY_ID = POS.ORGANIZATION_STRUCTURE_ID (+)
AND PPA.PROJECT_ID(+) = EEC.PROJECT_ID
AND PPE.PROJECT_ID(+) = EEC.PROJECT_ID
AND PPE.PROJ_ELEMENT_ID(+) = EEC.TASK_ID
AND CLASS.CLASSIFICATION_ID(+) = EEC.CLASSIFICATION_ID
AND LOOKUPS.LOOKUP_CODE(+)=TO_CHAR(EEC.STATUS_TYPE)
AND LOOKUPS.TAG(+)='S'
AND LOOKUPS.LOOKUP_TYPE(+)='ECG_ECN_STATUS'
AND LOOKUPS.LANGUAGE (+)=USERENV('LANG')

Columns