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
Comments |0|
Category: Uncategorized