FND Design Data [Home] [Help]

View: FUN_INTERFACE_GROUP_ID_V

Product: FND - Application Object Library
Description:
Implementation/DBA Data: ViewAPPS.FUN_INTERFACE_GROUP_ID_V
View Text

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