VIEW: APPS.ENG_ENGINEERING_CHANGES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'