SELECT BIS_COMMON_PARAMETERS.GET_BIS_CUST_CLASS_TYPE CLASS_CATEGORY , LOOKUP_CODE CLASS_CODE , MEANING CLASS FROM AR_LOOKUPS WHERE LOOKUP_TYPE =BIS_COMMON_PARAMETERS.GET_BIS_CUST_CLASS_TYPE UNION ALL SELECT BIS_COMMON_PARAMETERS.GET_BIS_CUST_CLASS_TYPE CLASS_CATEGORY , '-1' CLASS_CODE , MESSAGE_TEXT CLASS FROM FND_NEW_MESSAGES M , FND_APPLICATION A WHERE 'EDW_UNASSIGNED' = M.MESSAGE_NAME AND M.LANGUAGE_CODE = USERENV('LANG') AND 'BIS' = A.APPLICATION_SHORT_NAME AND M.APPLICATION_ID = A.APPLICATION_ID