IBY_VALIDATION_PARAMS

Details

Schema: FUSION
Object owner: IBY
Object type: VIEW

Columns

Name
ROW_ID VALIDATION_SET_CODE VALIDATION_PARAMETER_CODE VALIDATION_PARAMETER_TYPE VALIDATION_PARAM_DISPLAY_ORDER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER VALIDATION_PARAM_DISPLAY_NAME

Name

ROW_ID

VALIDATION_SET_CODE

VALIDATION_PARAMETER_CODE

VALIDATION_PARAMETER_TYPE

VALIDATION_PARAM_DISPLAY_ORDER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

VALIDATION_PARAM_DISPLAY_NAME

Query

SQL_Statement
SELECT B.ROWID ROW_ID, B.VALIDATION_SET_CODE, B.VALIDATION_PARAMETER_CODE, B.VALIDATION_PARAMETER_TYPE, B.VALIDATION_PARAM_DISPLAY_ORDER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, T.VALIDATION_PARAM_DISPLAY_NAME FROM IBY_VALIDATION_PARAMS_TL T,IBY_VALIDATION_PARAMS_B B WHERE B.VALIDATION_PARAMETER_CODE = T.VALIDATION_PARAMETER_CODE and T.VALIDATION_SET_CODE = B.VALIDATION_SET_CODE and T.LANGUAGE = userenv('LANG')

SQL_Statement

SELECT B.ROWID ROW_ID, B.VALIDATION_SET_CODE, B.VALIDATION_PARAMETER_CODE, B.VALIDATION_PARAMETER_TYPE, B.VALIDATION_PARAM_DISPLAY_ORDER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, T.VALIDATION_PARAM_DISPLAY_NAME FROM IBY_VALIDATION_PARAMS_TL T,IBY_VALIDATION_PARAMS_B B WHERE B.VALIDATION_PARAMETER_CODE = T.VALIDATION_PARAMETER_CODE and T.VALIDATION_SET_CODE = B.VALIDATION_SET_CODE and T.LANGUAGE = userenv('LANG')