DBA Data[Home] [Help]

APPS.RRS_SITE_INFO dependencies on FND_NEW_MESSAGES

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

2280: ad.pk1_value,
2281: d.DATATYPE_ID,
2282: d.DATATYPE_NAME,
2283: d.DESCRIPTION,
2284: decode(d.FILE_NAME, null, (select message_text from fnd_new_messages
2285: where message_name = 'FND_UNDEFINED' and application_id = 0
2286: and language_code = userenv('LANG')), d.FILE_NAME) FILE_NAME,
2287: d.dm_type,
2288: d.dm_node,

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

2295: cl.user_name attachment_category_name,
2296: ad.status,
2297: (select u1.user_name from fnd_user u1 where u1.user_id=ad.CREATED_BY) ATTACHED_BY_NAME,
2298: decode(d.datatype_id, 5, nvl(d.title,d.description)||'('||substr(d.URL, 1, least(length(d.URL),15))||'...)',
2299: decode(d.datatype_id, 6, nvl(d.title, d.file_name), decode(D.TITLE, null, (select message_text from fnd_new_messages where
2300: message_name = 'FND_UNDEFINED' and application_id = 0 and language_code = userenv('LANG')), D.TITLE))) FILE_NAME_SORT,
2301: d.usage_type,
2302: d.security_type,
2303: d.publish_flag,