View: XDP_ADAPTER_SUMMARY_V

Product:	XDP - Provisioning
Description:	View representing summary information of all Adapters defined for a Fulfillment Element. Indicates the Fulfillment Element name, the number of adapters defined for the Fulfillment Element and the number of jobs which are currently queued f
Implementation/DBA Data:	APPS.XDP_ADAPTER_SUMMARY_V

View Text

SELECT XFE.FE_ID FE_ID
, XFE.FULFILLMENT_ELEMENT_NAME FE_NAME
, XFE.DISPLAY_NAME DISPLAY_NAME
, COUNT(XAR.FE_ID) NUM_OF_ADAPTERS
, NVL(AVG(XAJQ.NUM_OF_JOBS)
, 0) NUM_OF_JOBS
FROM XDP_FES_VL XFE
, XDP_ADAPTER_REG XAR
, (SELECT FE_ID FE_ID
, COUNT(FE_ID) NUM_OF_JOBS
FROM XDP_ADAPTER_JOB_QUEUE GROUP BY FE_ID) XAJQ
, XDP_FE_GENERIC_CONFIG XFGC
, XDP_FE_TYPES XFET
, XDP_FE_SW_GEN_LOOKUP XFSGL
WHERE XAR.FE_ID = XAJQ.FE_ID(+)
AND XFE.FE_ID = XAR.FE_ID (+)
AND XFE.FE_ID = XFGC.FE_ID
AND XFE.FETYPE_ID = XFET.FETYPE_ID
AND XFGC.FE_SW_GEN_LOOKUP_ID = XFSGL.FE_SW_GEN_LOOKUP_ID
AND XFGC.START_DATE = (SELECT MAX( A.START_DATE )
FROM XDP_FE_GENERIC_CONFIG A
WHERE A.FE_ID = XFE.FE_ID
AND SYSDATE >= A.START_DATE
AND SYSDATE <= NVL(A.END_DATE
, SYSDATE)) GROUP BY XFE.FE_ID
, XFE.FULFILLMENT_ELEMENT_NAME
, XFE.DISPLAY_NAME

Columns