View: RCI_ISSUE_PRIORITY_V

Product:	AMW - Internal Controls Manager
Description:	This View contains the definition for the Open Issues' Priority dimension
Implementation/DBA Data:	APPS.RCI_ISSUE_PRIORITY_V

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

Columns