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 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
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')