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
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
|
|
|