VIEW: APPS.MSC_SELECTED_EXCEPTIONS_V

Source

View Text - Preformatted

SELECT M.ROWID ROW_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, MSC_PLAN_EXCP_TYPES e1 WHERE ml.lookup_type = 'MRP_EXCEPTION_CODE_TYPE' and ml.lookup_code = m.EXCEPTION_TYPE(+) and e1.EXCP_TYPE = ml.lookup_code and e1.in_srp_plan = 1 order by 4

View Text - HTML Formatted

SELECT M.ROWID ROW_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
, MSC_PLAN_EXCP_TYPES E1
WHERE ML.LOOKUP_TYPE = 'MRP_EXCEPTION_CODE_TYPE'
AND ML.LOOKUP_CODE = M.EXCEPTION_TYPE(+)
AND E1.EXCP_TYPE = ML.LOOKUP_CODE
AND E1.IN_SRP_PLAN = 1 ORDER BY 4