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
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
|
|
|