This View contains the definition for the Open Issues' Priority dimension
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT DISTINCT D.PRIORITY_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_PRIORITIES D , ENG_CHANGE_PRIORITIES 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_PRIORITY_CODE = D.PRIORITY_CODE AND E.ORGANIZATION_ID = -1