1. Tables and Views for SCM
  2. SCH_REC_PARAMETERS_VL

SCH_REC_PARAMETERS_VL

Details

  • Schema: FUSION

  • Object owner: SCH

  • Object type: VIEW

Columns

Name

PARAMETER_ID

PARAMETER_CODE

NAME

DESCRIPTION

PARAMETER_LEVEL_CODE

SEED_DATA_SOURCE

OBJECT_VERSION_NUMBER

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

B.PARAMETER_ID ,

B.PARAMETER_CODE ,

T.NAME,

T.DESCRIPTION ,

B.PARAMETER_LEVEL_CODE,

B.SEED_DATA_SOURCE ,

B.OBJECT_VERSION_NUMBER ,

B.CREATION_DATE,

B.CREATED_BY ,

B.LAST_UPDATE_DATE,

B.LAST_UPDATED_BY ,

B.LAST_UPDATE_LOGIN

FROM

SCH_REC_PARAMETERS_B B,

SCH_REC_PARAMETERS_TL T

WHERE

B.PARAMETER_ID = T.PARAMETER_ID AND T.LANGUAGE = USERENV('LANG')