VIEW: APPS.MST_KPIPREFS_V

Source

View Text - Preformatted

SELECT mkp.user_id as user_id, ml.meaning as kpi, ml.lookup_code as kpi_id, mkp.rank as rank from mfg_lookups ml, mst_kpi_preferences mkp WHERE ml.lookup_type='MST_KPI_TYPE' and mkp.kpi_code (+)= ml.lookup_code and ml.enabled_flag = 'Y'

View Text - HTML Formatted

SELECT MKP.USER_ID AS USER_ID
, ML.MEANING AS KPI
, ML.LOOKUP_CODE AS KPI_ID
, MKP.RANK AS RANK
FROM MFG_LOOKUPS ML
, MST_KPI_PREFERENCES MKP
WHERE ML.LOOKUP_TYPE='MST_KPI_TYPE'
AND MKP.KPI_CODE (+)= ML.LOOKUP_CODE
AND ML.ENABLED_FLAG = 'Y'