VIEW: APPS.ENI_CHG_MGMT_TYPE_V

Source

View Text - Preformatted

SELECT tl.change_order_type_id AS id, tl.type_name AS value FROM eng_change_order_types t, eng_change_order_types_tl tl WHERE CHANGE_MGMT_TYPE_CODE = 'CHANGE_ORDER' and t.change_order_type_id = tl.change_order_type_id and tl.language = USERENV('LANG')

View Text - HTML Formatted

SELECT TL.CHANGE_ORDER_TYPE_ID AS ID
, TL.TYPE_NAME AS VALUE
FROM ENG_CHANGE_ORDER_TYPES T
, ENG_CHANGE_ORDER_TYPES_TL TL
WHERE CHANGE_MGMT_TYPE_CODE = 'CHANGE_ORDER'
AND T.CHANGE_ORDER_TYPE_ID = TL.CHANGE_ORDER_TYPE_ID
AND TL.LANGUAGE = USERENV('LANG')