View: XDP_ADAPTER_TYPE_V

Product:	XDP - Provisioning
Description:	View representing the type of Adapters which have been defined for the Fulfillment Element. Indicates the Fulfillment Element identifier, the type of usage for the Adapter and the total count of each Adapter grouped by usage type
Implementation/DBA Data:	APPS.XDP_ADAPTER_TYPE_V

View Text

SELECT XAR.FE_ID
, XAR.USAGE_CODE USAGE_CODE
, FL.MEANING DISPLAY_NAME
, COUNT(*) USAGE_COUNT
FROM XDP_ADAPTER_REG XAR
, FND_LOOKUPS FL
WHERE XAR.USAGE_CODE = FL.LOOKUP_CODE
AND LOOKUP_TYPE = 'XDP_ADAPTER_USAGE_CODE' GROUP BY XAR.FE_ID
, XAR.USAGE_CODE
, FL.MEANING

Columns