View: FND_SVC_COMPONENTS_V

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

View Text

SELECT CQV.APPLICATION_ID
, CTV.COMPONENT_CLASS_NAME
, C.COMPONENT_ID
, C.COMPONENT_NAME
, C.COMPONENT_STATUS
, (SELECT MEANING
FROM WF_LOOKUPS
WHERE LOOKUP_CODE = C.COMPONENT_STATUS
AND LOOKUP_TYPE='WF_SVC_COMP_STATUS') COMPONENT_STATUS_DISPLAY_NAME
, C.COMPONENT_STATUS_INFO
, C.COMPONENT_TYPE
, CTV.DISPLAY_NAME COMPONENT_TYPE_DISPLAY_NAME
, CQV.USER_CONCURRENT_QUEUE_NAME CONCURRENT_QUEUE_DISPLAY_NAME
, C.CONCURRENT_QUEUE_ID
, CQV.CONCURRENT_QUEUE_NAME
, C.CONTAINER_TYPE
, (SELECT MEANING
FROM WF_LOOKUPS
WHERE LOOKUP_CODE = C.CONTAINER_TYPE
AND LOOKUP_TYPE='WF_SVC_CONTAINER_TYPE') CONTAINER_TYPE_DISPLAY_NAME
, C.CORRELATION_ID
, C.CREATED_BY
, C.CUSTOMIZATION_LEVEL
, (SELECT DISPLAY_NAME
FROM WF_AGENTS
WHERE NAME = C.INBOUND_AGENT_NAME
AND SYSTEM_GUID = WF_CORE.TRANSLATE('WF_SYSTEM_GUID')) INBOUND_AGENT_DISPLAY_NAME
, C.INBOUND_AGENT_NAME
, C.MAX_IDLE_TIME
, (SELECT DISPLAY_NAME
FROM WF_AGENTS
WHERE NAME = C.OUTBOUND_AGENT_NAME
AND SYSTEM_GUID = WF_CORE.TRANSLATE('WF_SYSTEM_GUID')) OUTBOUND_AGENT_DISPLAY_NAME
, C.OBJECT_VERSION_NUMBER
, C.OUTBOUND_AGENT_NAME
, C.STANDALONE_CONTAINER_NAME
, C.STARTUP_MODE
, (SELECT MEANING
FROM WF_LOOKUPS
WHERE LOOKUP_CODE = C.STARTUP_MODE
AND LOOKUP_TYPE='WF_SVC_COMP_STARTUP_MODE') STARTUP_MODE_DISPLAY_NAME
FROM FND_SVC_COMPONENTS C
, FND_SVC_COMP_TYPES_VL CTV
, FND_CONCURRENT_QUEUES_VL CQV
WHERE C.COMPONENT_TYPE =CTV.COMPONENT_TYPE
AND C.CONCURRENT_QUEUE_ID = CQV.CONCURRENT_QUEUE_ID (+)
AND C.APPLICATION_ID = CQV.APPLICATION_ID (+)

Columns