FUN_CLIENT_BU_V

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name
SERVICE_PROVIDER_BU_ID DOWNSTREAM_FUNCTION_ID DOWNSTREAM_MODULE_KEY DOWNSTREAM_MODULE_NAME UPSTREAM_FUNCTION_ID UPSTREAM_MODULE_KEY UPSTREAM_MODULE_NAME CLIENT_BU_ID SHORT_CODE BU_NAME ACTIVE_FLAG

Query

SQL_Statement

SELECT BF.BUSINESS_UNIT_ID SERVICE_PROVIDER_BU_ID, SP.DOWNSTREAM_FUNCTION_ID DOWNSTREAM_FUNCTION_ID, DN.BUSINESS_FUNCTION_CODE DOWNSTREAM_MODULE_KEY, DN.BUSINESS_FUNCTION_NAME DOWNSTREAM_MODULE_NAME, SP.UPSTREAM_FUNCTION_ID UPSTREAM_FUNCTION_ID, UP.BUSINESS_FUNCTION_CODE UPSTREAM_MODULE_KEY, UP.BUSINESS_FUNCTION_NAME UPSTREAM_MODULE_NAME, BU.BU_ID CLIENT_BU_ID, BU.SHORT_CODE SHORT_CODE, BU.BU_NAME BU_NAME, SP.ACTIVE_FLAG ACTIVE_FLAG FROM FUN_BU_SERVICE_PROVIDERS SP, FUN_ALL_BUSINESS_UNITS_V BU, FUN_BU_USAGES BF, FUN_BUSINESS_FUNCTIONS_VL UP, FUN_BUSINESS_FUNCTIONS_VL DN WHERE SP.CLIENT_BU_ORG_ID = BU.BU_ID AND SP.DOWNSTREAM_FUNCTION_ID = BF.MODULE_ID AND UP.BUSINESS_FUNCTION_ID = SP.UPSTREAM_FUNCTION_ID AND DN.BUSINESS_FUNCTION_ID = SP.DOWNSTREAM_FUNCTION_ID AND (SP.PROVIDER_BU_ORG_ID = BF.BUSINESS_UNIT_ID OR SP.ANY_PROVIDERS_FLAG = 'Y')