DBA Data[Home] [Help]

APPS.RRS_SITE_INFO dependencies on FND_NEW_MESSAGES

Line 2357: decode(d.FILE_NAME, null, (select message_text from fnd_new_messages

2353: ad.pk1_value,
2354: d.DATATYPE_ID,
2355: d.DATATYPE_NAME,
2356: d.DESCRIPTION,
2357: decode(d.FILE_NAME, null, (select message_text from fnd_new_messages
2358: where message_name = 'FND_UNDEFINED' and application_id = 0
2359: and language_code = userenv('LANG')), d.FILE_NAME) FILE_NAME,
2360: d.dm_type,
2361: d.dm_node,

Line 2372: decode(d.datatype_id, 6, nvl(d.title, d.file_name), decode(D.TITLE, null, (select message_text from fnd_new_messages where

2368: cl.user_name attachment_category_name,
2369: ad.status,
2370: (select u1.user_name from fnd_user u1 where u1.user_id=ad.CREATED_BY) ATTACHED_BY_NAME,
2371: decode(d.datatype_id, 5, nvl(d.title,d.description)||'('||substr(d.URL, 1, least(length(d.URL),15))||'...)',
2372: decode(d.datatype_id, 6, nvl(d.title, d.file_name), decode(D.TITLE, null, (select message_text from fnd_new_messages where
2373: message_name = 'FND_UNDEFINED' and application_id = 0 and language_code = userenv('LANG')), D.TITLE))) FILE_NAME_SORT,
2374: d.usage_type,
2375: d.security_type,
2376: d.publish_flag,