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