VIEW: APPS.HR_DTR_APPLICATION_LIST_V

Source

View Text - Preformatted

SELECT fnd.application_name, fnd.application_short_name from fnd_application_vl fnd, pay_upgrade_definitions pud, pay_upgrade_definitions_tl pudt WHERE fnd.application_id = pud.owner_application_id and pudt.upgrade_definition_id = pud.upgrade_definition_id and fnd.application_id not in (800,801,805,8301,8302,8403) union select substr(message_text,1,240), 'HR_PF' from fnd_new_messages where message_number = 52382

View Text - HTML Formatted

SELECT FND.APPLICATION_NAME
, FND.APPLICATION_SHORT_NAME
FROM FND_APPLICATION_VL FND
, PAY_UPGRADE_DEFINITIONS PUD
, PAY_UPGRADE_DEFINITIONS_TL PUDT
WHERE FND.APPLICATION_ID = PUD.OWNER_APPLICATION_ID
AND PUDT.UPGRADE_DEFINITION_ID = PUD.UPGRADE_DEFINITION_ID
AND FND.APPLICATION_ID NOT IN (800
, 801
, 805
, 8301
, 8302
, 8403) UNION SELECT SUBSTR(MESSAGE_TEXT
, 1
, 240)
, 'HR_PF'
FROM FND_NEW_MESSAGES
WHERE MESSAGE_NUMBER = 52382