This View contains the definition for the Open Issues' Reason dimension
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT DISTINCT D.REASON_CODE AS ID , E.DESCRIPTION AS VALUE FROM ENG_CHANGE_ORDER_TYPES A , ENG_CHANGE_ORDER_TYPES B , ENG_CHANGE_TYPE_APPLICATIONS C , ENG_CHANGE_TYPE_REASONS D , ENG_CHANGE_REASONS E WHERE A.TYPE_CLASSIFICATION = 'HEADER' AND A.CHANGE_MGMT_TYPE_CODE = B.CHANGE_MGMT_TYPE_CODE AND B.TYPE_CLASSIFICATION = 'CATEGORY' AND C.CHANGE_TYPE_ID = B.CHANGE_ORDER_TYPE_ID AND C.APPLICATION_ID = 242 AND D.CHANGE_TYPE_ID = A.CHANGE_ORDER_TYPE_ID AND E.ENG_CHANGE_REASON_CODE = D.REASON_CODE AND E.ORGANIZATION_ID = -1