View: PSP_ER_STATUS_V

Product:	PSP - Labor Distribution
Description:	Show Effort Report Error Status Summary
Implementation/DBA Data:	APPS.PSP_ER_STATUS_V

View Text

SELECT 1 ROWIDENT
, REQUEST_ID
, FNM.MESSAGE_TEXT ER_STATUS
, COUNT(*) ER_COUNT FROM PSP_EFF_REPORTS PER
, FND_NEW_MESSAGES FNM WHERE FNM.MESSAGE_NAME = 'PSP_ER_INITIATOR_PROCESSED' GROUP BY REQUEST_ID
, FNM.MESSAGE_TEXT UNION SELECT 2 ROWIDENT
, REQUEST_ID
, FNM.MESSAGE_TEXT ER_STATUS
, COUNT(DISTINCT MESSAGE_LEVEL || TO_CHAR(SOURCE_ID) || ERROR_MESSAGE) ER_COUNT FROM PSP_REPORT_ERRORS
, FND_NEW_MESSAGES FNM WHERE FNM.MESSAGE_NAME = 'PSP_ER_INITIATOR_NOT_PROCESSED' GROUP BY REQUEST_ID
, FNM.MESSAGE_TEXT ORDER BY ROWIDENT

Columns