View: RCI_ISSUE_REASON_V

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

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

Columns