VIEW: APPS.RLM_MESSAGE_CATEGORY_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'