DBA Data[Home] [Help]

VIEW: APPS.WSH_REPORT_NAMES_V

Source

View Text - Preformatted

SELECT DISTINCT R.CONCURRENT_PROGRAM_ID , F.USER_CONCURRENT_PROGRAM_NAME REPORT_NAME , R.APPLICATION_ID FROM FND_CONCURRENT_PROGRAMS_VL F, WSH_REPORT_SET_LINES R WHERE R.APPLICATION_ID = F.APPLICATION_ID AND F.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID
View Text - HTML Formatted

SELECT DISTINCT R.CONCURRENT_PROGRAM_ID
, F.USER_CONCURRENT_PROGRAM_NAME REPORT_NAME
, R.APPLICATION_ID
FROM FND_CONCURRENT_PROGRAMS_VL F
, WSH_REPORT_SET_LINES R
WHERE R.APPLICATION_ID = F.APPLICATION_ID
AND F.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID