FUN_SERVICE_PROVIDER_BU_V

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

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

Query

SQL_Statement

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