VIEW: APPS.ENI_CHG_MGMT_PRIORITY_V

Source

View Text - Preformatted

SELECT eng_change_priority_code AS id, eng_change_priority_code AS value, priority_level FROM eng_change_priorities ecpr WHERE organization_id = -1 union all select LOOKUP_CODE AS id, MEANING AS value, to_number(LOOKUP_CODE) AS priority_level FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'ITEM_CATG' AND LOOKUP_CODE = '-1' AND LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT ENG_CHANGE_PRIORITY_CODE AS ID
, ENG_CHANGE_PRIORITY_CODE AS VALUE
, PRIORITY_LEVEL
FROM ENG_CHANGE_PRIORITIES ECPR
WHERE ORGANIZATION_ID = -1 UNION ALL SELECT LOOKUP_CODE AS ID
, MEANING AS VALUE
, TO_NUMBER(LOOKUP_CODE) AS PRIORITY_LEVEL
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'ITEM_CATG'
AND LOOKUP_CODE = '-1'
AND LANGUAGE = USERENV('LANG')