VIEW: APPS.RCI_ISSUE_PRIORITY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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