View: RLM_MESSAGE_CATEGORY_V

Product:	RLM - Release Management
Description:
Implementation/DBA Data:	APPS.RLM_MESSAGE_CATEGORY_V

View Text

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'

Columns