FUN_BU_USAGES_V

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name
BUSINESS_UNIT_ID BU_NAME SHORT_CODE STATUS MODULE_ID MODULE_KEY MODULE_NAME CONFIGURATION_STATUS

Query

SQL_Statement

SELECT US.BUSINESS_UNIT_ID BUSINESS_UNIT_ID, BU.BU_NAME BU_NAME, BU.SHORT_CODE SHORT_CODE, BU.STATUS STATUS, US.MODULE_ID MODULE_ID, BF.BUSINESS_FUNCTION_CODE MODULE_KEY, BF.BUSINESS_FUNCTION_NAME MODULE_NAME, US.CONFIGURATION_STATUS CONFIGURATION_STATUS FROM FUN_BU_USAGES US, FUN_ALL_BUSINESS_UNITS_V BU, FUN_BUSINESS_FUNCTIONS_VL BF WHERE US.BUSINESS_UNIT_ID = BU.BU_ID AND US.MODULE_ID = BF.BUSINESS_FUNCTION_ID