WIS_CONFORMANCE_PARAMETERS_VL

Details

• Schema: FUSION

• Object owner: WIS

• Object type: VIEW

Columns

Name
CONFORMANCE_PARAMETER_ID OBJECT_VERSION_NUMBER PARAMETER_CODE PARAMETER_DESCRIPTION ORGANIZATION_ID DATA_TYPE DECIMAL_PRECISION UOM_CODE MIN_VALUE MAX_VALUE ENABLED_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT WCPB.CONFORMANCE_PARAMETER_ID CONFORMANCE_PARAMETER_ID, WCPB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, WCPB.PARAMETER_CODE PARAMETER_CODE, WCPTL.PARAMETER_DESCRIPTION PARAMETER_DESCRIPTION, WCPB.ORGANIZATION_ID ORGANIZATION_ID, WCPB.DATA_TYPE DATA_TYPE, WCPB.DECIMAL_PRECISION DECIMAL_PRECISION, WCPB.UOM_CODE UOM_CODE, WCPB.MIN_VALUE MIN_VALUE, WCPB.MAX_VALUE MAX_VALUE, WCPB.ENABLED_FLAG ENABLED_FLAG, WCPB.CREATED_BY CREATED_BY, WCPB.CREATION_DATE CREATION_DATE, WCPB.LAST_UPDATED_BY LAST_UPDATED_BY, WCPB.LAST_UPDATE_DATE LAST_UPDATE_DATE, WCPB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM WIS_CONFORMANCE_PARAMETERS_B WCPB, WIS_CONFORMANCE_PARAMETERS_TL WCPTL WHERE WCPB.CONFORMANCE_PARAMETER_ID = WCPTL.CONFORMANCE_PARAMETER_ID AND WCPTL.LANGUAGE = USERENV('LANG')