DBA Data[Home] [Help]

VIEW: APPS.BIS_APPL_NAMES_KPI_RPTS_V

Source

View Text - Preformatted

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