SELECT A.MESSAGE_CATEGORY_ID , A.MESSAGE_CATEGORY , A.MESSAGE_CATEGORY_DESC , A.MESSAGE_NAME , B.MESSAGE_NUMBER , B.MESSAGE_TEXT , A.LAST_UPDATE_DATE , A.LAST_UPDATED_BY , A.LAST_UPDATE_LOGIN , A.CREATION_DATE , A.CREATED_BY FROM RLM_MESSAGE_CATEGORY A , FND_NEW_MESSAGES B , FND_APPLICATION C WHERE A.MESSAGE_NAME = B.MESSAGE_NAME AND B.LANGUAGE_CODE = USERENV('LANG') AND B.APPLICATION_ID = C.APPLICATION_ID AND C.APPLICATION_SHORT_NAME ='RLM' UNION SELECT DISTINCT -1 , TO_NUMBER(B.LOOKUP_CODE) , B.MEANING , A.MESSAGE_NAME , A.MESSAGE_NUMBER , A.MESSAGE_TEXT , A.LAST_UPDATE_DATE , A.LAST_UPDATED_BY , A.LAST_UPDATE_LOGIN , A.CREATION_DATE , A.CREATED_BY FROM FND_NEW_MESSAGES A , FND_LOOKUPS B , FND_APPLICATION C WHERE A.MESSAGE_NAME LIKE 'RLM%' AND A.MESSAGE_NAME NOT IN (SELECT MESSAGE_NAME FROM RLM_MESSAGE_CATEGORY) AND A.LANGUAGE_CODE = USERENV('LANG') AND 'RLM' = C.APPLICATION_SHORT_NAME AND A.APPLICATION_ID = C.APPLICATION_ID AND B.LOOKUP_TYPE ='RLM_MESSAGE_CATEGORY' AND B.LOOKUP_CODE ='1'