1. Tables and Views for Financials
  2. FUN_BUSINESS_FUNCTIONS_VL

FUN_BUSINESS_FUNCTIONS_VL

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: VIEW

Columns

Name

BUSINESS_FUNCTION_ID

BUSINESS_FUNCTION_CODE

BUSINESS_FUNCTION_NAME

DESCRIPTION

GENERATE_FIN_TXN_FLAG

SETUP_API

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

FUN_BUSINESS_FUNCTIONS_B.BUSINESS_FUNCTION_ID,

FUN_BUSINESS_FUNCTIONS_B.BUSINESS_FUNCTION_CODE,

FUN_BUSINESS_FUNCTIONS_TL.BUSINESS_FUNCTION_NAME,

FUN_BUSINESS_FUNCTIONS_TL.DESCRIPTION,

FUN_BUSINESS_FUNCTIONS_B.GENERATE_FIN_TXN_FLAG,

FUN_BUSINESS_FUNCTIONS_B.SETUP_API,

FUN_BUSINESS_FUNCTIONS_B.OBJECT_VERSION_NUMBER,

FUN_BUSINESS_FUNCTIONS_B.CREATED_BY,

FUN_BUSINESS_FUNCTIONS_B.CREATION_DATE,

FUN_BUSINESS_FUNCTIONS_B.LAST_UPDATED_BY,

FUN_BUSINESS_FUNCTIONS_B.LAST_UPDATE_DATE,

FUN_BUSINESS_FUNCTIONS_B.LAST_UPDATE_LOGIN

FROM

FUN_BUSINESS_FUNCTIONS_B,

FUN_BUSINESS_FUNCTIONS_TL

WHERE

FUN_BUSINESS_FUNCTIONS_B.BUSINESS_FUNCTION_ID = FUN_BUSINESS_FUNCTIONS_TL.BUSINESS_FUNCTION_ID AND FUN_BUSINESS_FUNCTIONS_TL.LANGUAGE = USERENV('LANG')