VIEW: APPS.ENI_CHG_MGMT_REASON_V

Source

View Text - Preformatted

SELECT eng_change_reason_code AS id, eng_change_reason_code AS value FROM eng_change_reasons WHERE organization_id = -1 union all select LOOKUP_CODE AS id, MEANING AS value FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'ITEM_CATG' AND LOOKUP_CODE = '-1' AND LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT ENG_CHANGE_REASON_CODE AS ID
, ENG_CHANGE_REASON_CODE AS VALUE
FROM ENG_CHANGE_REASONS
WHERE ORGANIZATION_ID = -1 UNION ALL SELECT LOOKUP_CODE AS ID
, MEANING AS VALUE
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'ITEM_CATG'
AND LOOKUP_CODE = '-1'
AND LANGUAGE = USERENV('LANG')