Query to retieve KFF's in Oracle E-Business Suite

SELECT COUNT(*),
FAT.APPLICATION_NAME
FROM FND_ID_FLEXS FIF,
FND_APPLICATION_TL FAT
WHERE FAT.APPLICATION_ID = FIF.APPLICATION_ID
AND FAT.LANGUAGE = 'US'
GROUP BY FAT.APPLICATION_NAME
ORDER BY FAT.APPLICATION_NAME

SELECT FA.APPLICATION_SHORT_NAME,
FAT.APPLICATION_NAME,
FIF.ID_FLEX_CODE,
FIF.ID_FLEX_NAMEFROM FND_ID_FLEXS FIF,
FND_APPLICATION FA,
FND_APPLICATION_TL FAT
WHERE FA.APPLICATION_ID = FIF.APPLICATION_ID
AND FAT.APPLICATION_ID = FA.APPLICATION_ID
AND FAT.LANGUAGE = 'US'
ORDER BY FAT.APPLICATION_NAME,
FIF.ID_FLEX_NAME