VIEW: APPS.MSC_SELECTED_EXCEPTIONS_V

Source

View Text - Preformatted

SELECT M.ROWID ROW_ID, M.EXCEP_GROUP_ID, ml.LOOKUP_cODE EXCEPTION_CODE, DECODE(nvl(M.SELECTED_flag,2),2,2,1) SELECTED_FLAG, ML.MEANING EXCEPTION_NAME, M.CREATED_BY , M.CREATION_DATE , M.LAST_UPDATE_DATE , M.LAST_UPDATED_BY , M.LAST_UPDATE_LOGIN FROM MSC_SELECTED_EXCEPTIONS m, mfg_lookups ml WHERE ml.lookup_type = 'MRP_EXCEPTION_CODE_TYPE' and ml.lookup_code = m.EXCEPTION_TYPE(+) order by 4,5

View Text - HTML Formatted

SELECT M.ROWID ROW_ID
, M.EXCEP_GROUP_ID
, ML.LOOKUP_CODE EXCEPTION_CODE
, DECODE(NVL(M.SELECTED_FLAG
, 2)
, 2
, 2
, 1) SELECTED_FLAG
, ML.MEANING EXCEPTION_NAME
, M.CREATED_BY
, M.CREATION_DATE
, M.LAST_UPDATE_DATE
, M.LAST_UPDATED_BY
, M.LAST_UPDATE_LOGIN
FROM MSC_SELECTED_EXCEPTIONS M
, MFG_LOOKUPS ML
WHERE ML.LOOKUP_TYPE = 'MRP_EXCEPTION_CODE_TYPE'
AND ML.LOOKUP_CODE = M.EXCEPTION_TYPE(+) ORDER BY 4
, 5