Query to Get Fusion Application Short Name Details

by admin

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

Comments |0|

Legend *) Required fields are marked
**) You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
Category: Uncategorized