DBA Data[Home] [Help]

VIEW: APPS.SO_REPORT_NAMES_V

Source

View Text - Preformatted

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

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