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') |