ACA_QI_PR_V

Details

• Schema: FUSION

• Object owner: ACA

• Object type: VIEW

Columns

Name
ISSUE_ID ISSUE_NUMBER NAME DESCRIPTION ORIGIN SEVERITY ORGANIZATION_ID QUALITY_TYPE_ID REPORTED_BY REPORTED_DATE LIKELIHOOD_OF_RECURRENCE SOURCE SUPPLIER_ID WORKFLOW_STATUS_ID ACTUAL_RESOLUTION_DATE ASSIGNED_TO CUSTOMER_ID DISPOSITION DISPOSITION_COMMENT DOWNTIME

Query

SQL_Statement

SELECT ISSUE_ID, ISSUE_NUMBER, NAME, DESCRIPTION, ORIGIN, SEVERITY, ORGANIZATION_ID, QUALITY_TYPE_ID, REPORTED_BY, REPORTED_DATE, LIKELIHOOD_OF_RECURRENCE, SOURCE, SUPPLIER_ID, WORKFLOW_STATUS_ID, ACTUAL_RESOLUTION_DATE, ASSIGNED_TO, CUSTOMER_ID, DISPOSITION, DISPOSITION_COMMENT, DOWNTIME FROM ( SELECT ISSUE_ID AS ISSUE_ID,ISSUE_NUMBER AS ISSUE_NUMBER,NAME, DESCRIPTION, 'QI' AS ORIGIN, SEVERITY, ORGANIZATION_ID, QUALITY_TYPE_ID, REPORTED_BY, REPORTED_DATE, LIKELIHOOD_OF_RECURRENCE, SOURCE, SUPPLIER_ID, WORKFLOW_STATUS_ID, ACTUAL_RESOLUTION_DATE, ASSIGNED_TO, CUSTOMER_ID, DISPOSITION, DISPOSITION_COMMENT, DOWNTIME FROM ENQ_ISSUES_VL UNION ALL SELECT CHANGE_ID AS ISSUE_ID, CHANGE_NOTICE AS ISSUE_NUMBER, CHANGE_NAME AS NAME, TO_CLOB(DESCRIPTION) AS DESCRIPTION, 'PR' AS ORIGIN, PRIORITY_CODE AS SEVERITY, ORGANIZATION_ID, CHANGE_TYPE_ID AS QUALITY_TYPE_ID, NULL AS REPORTED_BY, NULL AS REPORTED_DATE, NULL AS LIKELIHOOD_OF_RECURRENCE, SOURCE_CODE AS SOURCE, SUPPLIER_ID, NULL AS WORKFLOW_STATUS_ID, NULL AS ACTUAL_RESOLUTION_DATE, (SELECT NVL(USERNAME,ASSIGNEE_ID) FROM PER_USERS WHERE USER_GUID = ASSIGNEE_ID) AS ASSIGNED_TO, CUSTOMER_ID, NULL AS DISPOSITION,NULL AS DISPOSITION_COMMENT, NULL AS DOWNTIME FROM EGO_ENGINEERING_CHANGES_VL)