VIEW: APPS.ENG_CHANGES_V

Source

View Text - Preformatted

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, EEC.COMPLETION_DATE 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')

View Text - HTML Formatted

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
, EEC.COMPLETION_DATE
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')