VIEW: APPS.MST_REL_CM_EXCP_V

Source

View Text - Preformatted

SELECT distinct med.plan_id , med.continuous_move_id , ml.meaning from mst_exception_details med , mfg_lookups ml WHERE ml.lookup_type = 'MST_EXCEPTION_TYPE' and med.exception_type = ml.lookup_code

View Text - HTML Formatted

SELECT DISTINCT MED.PLAN_ID
, MED.CONTINUOUS_MOVE_ID
, ML.MEANING
FROM MST_EXCEPTION_DETAILS MED
, MFG_LOOKUPS ML
WHERE ML.LOOKUP_TYPE = 'MST_EXCEPTION_TYPE'
AND MED.EXCEPTION_TYPE = ML.LOOKUP_CODE