Query to Get Fusion Application Short Name Details

SELECT  
       ApplTaxonomyPEO.MODULE_NAME, 
       ApplTaxonomyPEO.USER_MODULE_NAME, 
       ApplTaxonomyPEO.MODULE_TYPE, 
       ApplTaxonomyPEO.MODULE_KEY, 
       ApplTaxonomyPEO.PRODUCT_CODE, 
       ApplTaxonomyPEO.ALTERNATIVE_ID, 
       ApplTaxonomyPEO.IS_SEED_DATA_ALLOWED, 
       ApplTaxonomyPEO.PRODUCT_LINE, 
       ApplTaxonomyPEO.DESCRIPTION, 
       ApplTaxonomyPEO.USAGE_TYPE, 
       ApplTaxonomyRfPEO.DISTANCE, 
       ApplTaxonomyRfPEO.IS_LEAF
FROM  FND_APPL_TAXONOMY_VL ApplTaxonomyPEO,
      FND_APPL_TAXONOMY_RF ApplTaxonomyRfPEO,
	  FND_APPL_TAXONOMY_VL ApplTaxonomyPEO1
WHERE ApplTaxonomyPEO.MODULE_ID =  ApplTaxonomyRfPEO.CHILD_MODULE_ID 
AND ApplTaxonomyPEO1.MODULE_ID =  ApplTaxonomyRfPEO.ANCESTOR_MODULE_ID 
AND  ApplTaxonomyPEO.IS_SEED_DATA_ALLOWED = 'Y' 
AND ApplTaxonomyPEO.PRODUCT_LINE = 1 
AND ApplTaxonomyPEO1.PRODUCT_LINE = 1