RCS_QS_UOM_TEMPLATES_VL

Details

• Schema: FUSION

• Object owner: RCS

• Object type: VIEW

Columns

Name
UNIT_OF_MEASURE_ID OBJECT_VERSION_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN UOM_CODE UOM_CLASS BASE_UOM_FLAG UNIT_OF_MEASURE DISABLE_DATE DESCRIPTION UOM_RECIPROCAL_DESC UOM_PLURAL_DESC OKEI_CODE

Query

SQL_Statement

SELECT B.UNIT_OF_MEASURE_ID, B.OBJECT_VERSION_NUMBER, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_LOGIN, B.UOM_CODE, B.UOM_CLASS, B.BASE_UOM_FLAG, T.UNIT_OF_MEASURE, B.DISABLE_DATE, T.DESCRIPTION, T.UOM_RECIPROCAL_DESC, T.UOM_PLURAL_DESC, B.OKEI_CODE FROM RCS_QS_UOM_TEMPLATES_B B, RCS_QS_UOM_TEMPLATES_TL T WHERE B.UNIT_OF_MEASURE_ID = T.UNIT_OF_MEASURE_ID AND T.LANGUAGE = USERENV('LANG')