VIEW: APPS.FUN_INTERFACE_GROUP_ID_V

Source

View Text - Preformatted

select b.source, b.group_id 
 , (case when count(*) = 1 then min(nvl(b.batch_number,'(no batches)')) 
    else '(' || count(*) || ' batches)' end) 
    as batches 
 from fun_interface_batches b  
 group by b.source, b.group_id 

View Text - HTML Formatted

SELECT B.SOURCE
, B.GROUP_ID
, (CASE WHEN COUNT(*) = 1 THEN MIN(NVL(B.BATCH_NUMBER
, '(NO BATCHES)')) ELSE '(' || COUNT(*) || ' BATCHES)' END) AS BATCHES
FROM FUN_INTERFACE_BATCHES B GROUP BY B.SOURCE
, B.GROUP_ID