VIEW: APPS.FND_SVC_COMPONENTS_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)