SELECT TO_NUMBER(l.lookup_code) lookup_code, l.meaning, l.description from mfg_lookups l WHERE l.lookup_type = 'MST_CONSTRAINT_TYPE' and l.enabled_flag = 'Y'
View Text - HTML Formatted
SELECT TO_NUMBER(L.LOOKUP_CODE) LOOKUP_CODE , L.MEANING , L.DESCRIPTION FROM MFG_LOOKUPS L WHERE L.LOOKUP_TYPE = 'MST_CONSTRAINT_TYPE' AND L.ENABLED_FLAG = 'Y'