VIEW: APPS.FND_APP_COMPONENTS_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')