View: HR_DTR_APPLICATION_LIST_V

Product:	PER - Human Resources
Description:	Downtime Reduction application list view
Implementation/DBA Data:	APPS.HR_DTR_APPLICATION_LIST_V

View Text

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

Columns