1. Tables and Views for Financials
  2. FUN_RELATED_FUNCTIONS_V

FUN_RELATED_FUNCTIONS_V

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: VIEW

Columns

Name

UPSTREAM_FUNCTION_ID

DOWNSTREAM_FUNCTION_ID

OUTSOURCING_POLICY_CODE

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

DOWNSTREAM_BF_CODE

DOWNSTREAM_MODULE_ID

UPSTREAM_BF_CODE

UPSTREAM_MODULE_ID

Query

SQL_Statement

SELECT BFRelatedFunctionEO.UPSTREAM_FUNCTION_ID,

BFRelatedFunctionEO.DOWNSTREAM_FUNCTION_ID,

BFRelatedFunctionEO.OUTSOURCING_POLICY_CODE,

BFRelatedFunctionEO.OBJECT_VERSION_NUMBER,

BFRelatedFunctionEO.CREATED_BY,

BFRelatedFunctionEO.CREATION_DATE,

BFRelatedFunctionEO.LAST_UPDATED_BY,

BFRelatedFunctionEO.LAST_UPDATE_DATE,

BFRelatedFunctionEO.LAST_UPDATE_LOGIN,

Downstream.BUSINESS_FUNCTION_CODE DOWNSTREAM_BF_CODE,

Downstream.BUSINESS_FUNCTION_ID DOWNSTREAM_MODULE_ID,

Upstream.BUSINESS_FUNCTION_CODE UPSTREAM_BF_CODE,

Upstream.BUSINESS_FUNCTION_ID UPSTREAM_MODULE_ID

FROM FUN_RELATED_FUNCTIONS BFRelatedFunctionEO

, FUN_BUSINESS_FUNCTIONS_VL Downstream

, FUN_BUSINESS_FUNCTIONS_VL Upstream

WHERE (BFRelatedFunctionEO.DOWNSTREAM_FUNCTION_ID = Downstream.BUSINESS_FUNCTION_ID)

AND (BFRelatedFunctionEO.UPSTREAM_FUNCTION_ID = Upstream.BUSINESS_FUNCTION_ID)