VIEW: APPS.ENG_ENG_CHANGES_API_V

Source

View Text - Preformatted

SELECT 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 ,MLU1.MEANING ECO_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 ,MEV.FULL_NAME REQUESTOR ,EEC.CHANGE_ORDER_TYPE_ID ,ECOT.TYPE_NAME CHANGE_ORDER_TYPE ,ECOT.DESCRIPTION CHANGE_ORDER_TYPE_DESCRIPTION ,ECOT.ASSEMBLY_TYPE ,EEC.RESPONSIBLE_ORGANIZATION_ID ,HOU.NAME ECO_DEPARTMENT ,EEC.APPROVAL_STATUS_TYPE ,MLU2.MEANING APPROVAL_STATUS ,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 FROM ENG_CHANGE_ORDER_TYPES_VL ECOT, ENG_CHANGE_REASONS ECR, ENG_CHANGE_PRIORITIES ECP, ENG_ECN_APPROVAL_LISTS EEAL, HR_ALL_ORGANIZATION_UNITS_TL HOU, MFG_LOOKUPS MLU1, MFG_LOOKUPS MLU2, MTL_EMPLOYEES_VIEW MEV, ENG_ENGINEERING_CHANGES EEC WHERE EEC.CHANGE_ORDER_TYPE_ID = ECOT.CHANGE_ORDER_TYPE_ID AND EEC.REASON_CODE = ECR.ENG_CHANGE_REASON_CODE(+) AND EEC.ORGANIZATION_ID = ECR.ORGANIZATION_ID(+) AND EEC.PRIORITY_CODE = ECP.ENG_CHANGE_PRIORITY_CODE(+) AND EEC.ORGANIZATION_ID = ECP.ORGANIZATION_ID(+) AND EEC.APPROVAL_LIST_ID = EEAL.APPROVAL_LIST_ID(+) AND EEC.RESPONSIBLE_ORGANIZATION_ID = HOU.ORGANIZATION_ID(+) AND EEC.STATUS_TYPE = MLU1.LOOKUP_CODE AND MLU1.LOOKUP_TYPE = 'ECG_ECN_STATUS' AND EEC.APPROVAL_STATUS_TYPE = MLU2.LOOKUP_CODE AND MLU2.LOOKUP_TYPE = 'ENG_ECN_APPROVAL_STATUS' AND EEC.REQUESTOR_ID = MEV.EMPLOYEE_ID(+) AND EEC.ORGANIZATION_ID = MEV.ORGANIZATION_ID(+)

View Text - HTML Formatted

SELECT 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
, MLU1.MEANING ECO_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
, MEV.FULL_NAME REQUESTOR
, EEC.CHANGE_ORDER_TYPE_ID
, ECOT.TYPE_NAME CHANGE_ORDER_TYPE
, ECOT.DESCRIPTION CHANGE_ORDER_TYPE_DESCRIPTION
, ECOT.ASSEMBLY_TYPE
, EEC.RESPONSIBLE_ORGANIZATION_ID
, HOU.NAME ECO_DEPARTMENT
, EEC.APPROVAL_STATUS_TYPE
, MLU2.MEANING APPROVAL_STATUS
, 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
FROM ENG_CHANGE_ORDER_TYPES_VL ECOT
, ENG_CHANGE_REASONS ECR
, ENG_CHANGE_PRIORITIES ECP
, ENG_ECN_APPROVAL_LISTS EEAL
, HR_ALL_ORGANIZATION_UNITS_TL HOU
, MFG_LOOKUPS MLU1
, MFG_LOOKUPS MLU2
, MTL_EMPLOYEES_VIEW MEV
, ENG_ENGINEERING_CHANGES EEC
WHERE EEC.CHANGE_ORDER_TYPE_ID = ECOT.CHANGE_ORDER_TYPE_ID
AND EEC.REASON_CODE = ECR.ENG_CHANGE_REASON_CODE(+)
AND EEC.ORGANIZATION_ID = ECR.ORGANIZATION_ID(+)
AND EEC.PRIORITY_CODE = ECP.ENG_CHANGE_PRIORITY_CODE(+)
AND EEC.ORGANIZATION_ID = ECP.ORGANIZATION_ID(+)
AND EEC.APPROVAL_LIST_ID = EEAL.APPROVAL_LIST_ID(+)
AND EEC.RESPONSIBLE_ORGANIZATION_ID = HOU.ORGANIZATION_ID(+)
AND EEC.STATUS_TYPE = MLU1.LOOKUP_CODE
AND MLU1.LOOKUP_TYPE = 'ECG_ECN_STATUS'
AND EEC.APPROVAL_STATUS_TYPE = MLU2.LOOKUP_CODE
AND MLU2.LOOKUP_TYPE = 'ENG_ECN_APPROVAL_STATUS'
AND EEC.REQUESTOR_ID = MEV.EMPLOYEE_ID(+)
AND EEC.ORGANIZATION_ID = MEV.ORGANIZATION_ID(+)