FUN_TAXONOMY_BF_V

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Query

SQL_Statement

SELECT PF.USER_MODULE_NAME PRODUCT_FAMILY, PF.MODULE_ID PRODUCT_FAMILY_ID, PF.MODULE_KEY PRODUCT_FAMILY_CODE, PF.DESCRIPTION PRODUCT_FAMILY_DESCR, BF.MODULE_KEY BUSINESS_FUNCTION_CODE, BF.MODULE_ID BUSINESS_FUNCTION_ID, BF.USER_MODULE_NAME BUSINESS_FUNCTION_NAME, BF.DESCRIPTION FROM FND_APPL_TAXONOMY_VL PF, FND_APPL_TAXONOMY_VL BF, FND_APPL_TAXONOMY_HIERARCHY BF_Hierarchy WHERE BF.MODULE_TYPE = 'BUSINESS_FUNCTION' AND BF.MODULE_ID = BF_Hierarchy.SOURCE_MODULE_ID AND BF_Hierarchy.TARGET_MODULE_ID = PF.MODULE_ID AND PF.MODULE_TYPE = 'FAMILY'