VIEW: APPS.MST_EXCEPTION_PREFS_V

Source

View Text - Preformatted

SELECT mep.user_id as user_id, ml.lookup_code as exception_type, mep.exception_group as exception_group, ml.meaning as exception_name, mep.rank as rank, mep.release_option as release_option, mep.threshold_value as threshold_value, mep.threshold_uom as threshold_unit, mep.work_flow_item_type as work_flow_item_type From mfg_lookups ml, mst_excep_preferences mep WHERE ml.lookup_type ='MST_EXCEPTION_TYPE' and mep.exception_type (+) = ml.lookup_code and ml.enabled_flag='Y'

View Text - HTML Formatted

SELECT MEP.USER_ID AS USER_ID
, ML.LOOKUP_CODE AS EXCEPTION_TYPE
, MEP.EXCEPTION_GROUP AS EXCEPTION_GROUP
, ML.MEANING AS EXCEPTION_NAME
, MEP.RANK AS RANK
, MEP.RELEASE_OPTION AS RELEASE_OPTION
, MEP.THRESHOLD_VALUE AS THRESHOLD_VALUE
, MEP.THRESHOLD_UOM AS THRESHOLD_UNIT
, MEP.WORK_FLOW_ITEM_TYPE AS WORK_FLOW_ITEM_TYPE
FROM MFG_LOOKUPS ML
, MST_EXCEP_PREFERENCES MEP
WHERE ML.LOOKUP_TYPE ='MST_EXCEPTION_TYPE'
AND MEP.EXCEPTION_TYPE (+) = ML.LOOKUP_CODE
AND ML.ENABLED_FLAG='Y'