SELECT LOOKUP_CODE ID , MEANING VALUE FROM AR_LOOKUPS WHERE LOOKUP_TYPE =BIS_COMMON_PARAMETERS.GET_BIS_CUST_CLASS_TYPE UNION SELECT TO_CHAR('-1') ID , MESSAGE_TEXT VALUE 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