View: FND_APP_COMPONENTS_VL

Product:	FND - Application Object Library
Description:	FND_APP_COMPONENTS_VL
Implementation/DBA Data:	APPS.FND_APP_COMPONENTS_VL

View Text

SELECT 'CONCURRENT_PROGRAM'
, B.CONCURRENT_PROGRAM_NAME
, T.USER_CONCURRENT_PROGRAM_NAME
, B.APPLICATION_ID
, B.CONCURRENT_PROGRAM_ID
, T.DESCRIPTION
FROM FND_CONCURRENT_PROGRAMS B
, FND_CONCURRENT_PROGRAMS_TL T
WHERE B.APPLICATION_ID = T.APPLICATION_ID
AND B.CONCURRENT_PROGRAM_ID = T.CONCURRENT_PROGRAM_ID
AND T.LANGUAGE = USERENV('LANG') UNION ALL SELECT 'FORM'
, B.FORM_NAME
, T.USER_FORM_NAME
, B.APPLICATION_ID
, B.FORM_ID
, T.DESCRIPTION
FROM FND_FORM B
, FND_FORM_TL T
WHERE B.APPLICATION_ID = T.APPLICATION_ID
AND B.FORM_ID = T.FORM_ID
AND T.LANGUAGE = USERENV('LANG') UNION ALL SELECT 'SERVICE_INSTANCE'
, B.CONCURRENT_QUEUE_NAME
, T.USER_CONCURRENT_QUEUE_NAME
, B.APPLICATION_ID
, B.CONCURRENT_QUEUE_ID
, T.DESCRIPTION
FROM FND_CONCURRENT_QUEUES B
, FND_CONCURRENT_QUEUES_TL T
WHERE B.APPLICATION_ID = T.APPLICATION_ID
AND B.CONCURRENT_QUEUE_ID = T.CONCURRENT_QUEUE_ID
AND T.LANGUAGE = USERENV('LANG') UNION ALL SELECT 'FUNCTION'
, B.FUNCTION_NAME
, T.USER_FUNCTION_NAME
, -1
, B.FUNCTION_ID
, T.DESCRIPTION
FROM FND_FORM_FUNCTIONS B
, FND_FORM_FUNCTIONS_TL T
WHERE B.FUNCTION_ID = T.FUNCTION_ID
AND T.LANGUAGE = USERENV('LANG')
AND B.TYPE IN ('WWW'
, 'WWK'
, 'JSP'
, 'SERVLET')

Columns