SELECT fa.application_id as id , fa.application_name as value FROM fnd_application_vl fa, bis_application_measures bam WHERE fa.application_id = bam.application_id GROUP BY fa.application_id, fa.application_name
View Text - HTML Formatted
SELECT FA.APPLICATION_ID AS ID , FA.APPLICATION_NAME AS VALUE FROM FND_APPLICATION_VL FA , BIS_APPLICATION_MEASURES BAM WHERE FA.APPLICATION_ID = BAM.APPLICATION_ID GROUP BY FA.APPLICATION_ID , FA.APPLICATION_NAME