View: XDP_FE_SUMMARY_V

Product:	XDP - Provisioning
Description:	View representing summary information of all Fulfillment Elements. Indicates the Fulfillment Element name, the application mode for all adapters defined for the Fulfillment Element, the number of adapters defined for the Fulfillment Eleme
Implementation/DBA Data:	APPS.XDP_FE_SUMMARY_V

View Text

SELECT XFE.FE_ID FE_ID
, XFE.FULFILLMENT_ELEMENT_NAME FE_NAME
, XAT.APPLICATION_MODE APPL_MODE
, XAT.INBOUND_REQUIRED_FLAG INBOUND_REQUIRED_FLAG
, XFE.DISPLAY_NAME DISPLAY_NAME
, COUNT(XAR.FE_ID) NUM_OF_ADAPTERS
FROM XDP_FES_VL XFE
, XDP_ADAPTER_REG XAR
, XDP_ADAPTER_TYPES_B XAT
WHERE XAR.ADAPTER_TYPE = XAT.ADAPTER_TYPE
AND XFE.FE_ID = XAR.FE_ID GROUP BY XFE.FE_ID
, XAT.APPLICATION_MODE
, XAT.INBOUND_REQUIRED_FLAG
, XFE.FULFILLMENT_ELEMENT_NAME
, XFE.DISPLAY_NAME

Columns