INV_UNITS_OF_MEASURE_ALL_VL

Details

• Schema: FUSION

• Object owner: RCS

• Object type: VIEW

Columns

Name

UNIT_OF_MEASURE_ID ROW_ID OBJECT_VERSION_NUMBER ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE UOM_CODE UOM_CLASS BASE_UOM_FLAG STANDARD_PACK_FLAG UNIT_OF_MEASURE DISABLE_DATE DESCRIPTION DERIVED_UNIT_PARENT_CODE UOM_RECIPROCAL_DESC UOM_PLURAL_DESC HAS_GENERATED_CODE GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE_NUMBER1 GLOBAL_ATTRIBUTE_NUMBER2 GLOBAL_ATTRIBUTE_NUMBER3 GLOBAL_ATTRIBUTE_NUMBER4 GLOBAL_ATTRIBUTE_NUMBER5 GLOBAL_ATTRIBUTE_DATE1 GLOBAL_ATTRIBUTE_DATE2 GLOBAL_ATTRIBUTE_DATE3 GLOBAL_ATTRIBUTE_DATE4 GLOBAL_ATTRIBUTE_DATE5

Query

SQL_Statement

SELECT B.UNIT_OF_MEASURE_ID, B.ROWID ROW_ID, B.OBJECT_VERSION_NUMBER, B.ATTRIBUTE_CATEGORY, B.ATTRIBUTE1, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6, B.ATTRIBUTE7, B.ATTRIBUTE8, B.ATTRIBUTE9, B.ATTRIBUTE10, B.ATTRIBUTE11, B.ATTRIBUTE12, B.ATTRIBUTE13, B.ATTRIBUTE14, B.ATTRIBUTE15, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_LOGIN, B.REQUEST_ID, B.JOB_DEFINITION_NAME, B.JOB_DEFINITION_PACKAGE, B.UOM_CODE, B.UOM_CLASS, B.BASE_UOM_FLAG, B.STANDARD_PACK_FLAG, T.UNIT_OF_MEASURE, B.DISABLE_DATE, T.DESCRIPTION, B.DERIVED_UNIT_PARENT_CODE, T.UOM_RECIPROCAL_DESC, T.UOM_PLURAL_DESC, B.HAS_GENERATED_CODE, B.GLOBAL_ATTRIBUTE_CATEGORY, B.GLOBAL_ATTRIBUTE1, B.GLOBAL_ATTRIBUTE2, B.GLOBAL_ATTRIBUTE3, B.GLOBAL_ATTRIBUTE4, B.GLOBAL_ATTRIBUTE5, B.GLOBAL_ATTRIBUTE6, B.GLOBAL_ATTRIBUTE7, B.GLOBAL_ATTRIBUTE8, B.GLOBAL_ATTRIBUTE9, B.GLOBAL_ATTRIBUTE10, B.GLOBAL_ATTRIBUTE11, B.GLOBAL_ATTRIBUTE12, B.GLOBAL_ATTRIBUTE13, B.GLOBAL_ATTRIBUTE14, B.GLOBAL_ATTRIBUTE15, B.GLOBAL_ATTRIBUTE16, B.GLOBAL_ATTRIBUTE17, B.GLOBAL_ATTRIBUTE18, B.GLOBAL_ATTRIBUTE19, B.GLOBAL_ATTRIBUTE20, B.GLOBAL_ATTRIBUTE_NUMBER1, B.GLOBAL_ATTRIBUTE_NUMBER2, B.GLOBAL_ATTRIBUTE_NUMBER3, B.GLOBAL_ATTRIBUTE_NUMBER4, B.GLOBAL_ATTRIBUTE_NUMBER5, B.GLOBAL_ATTRIBUTE_DATE1, B.GLOBAL_ATTRIBUTE_DATE2, B.GLOBAL_ATTRIBUTE_DATE3, B.GLOBAL_ATTRIBUTE_DATE4, B.GLOBAL_ATTRIBUTE_DATE5 FROM INV_UNITS_OF_MEASURE_B B, INV_UNITS_OF_MEASURE_TL T WHERE B.UNIT_OF_MEASURE_ID = T.UNIT_OF_MEASURE_ID AND T.LANGUAGE = USERENV('LANG')