INV_UNITS_OF_MEASURE_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 V.UNIT_OF_MEASURE_ID, V.ROWID ROW_ID, V.OBJECT_VERSION_NUMBER, V.ATTRIBUTE_CATEGORY, V.ATTRIBUTE1, V.ATTRIBUTE2, V.ATTRIBUTE3, V.ATTRIBUTE4, V.ATTRIBUTE5, V.ATTRIBUTE6, V.ATTRIBUTE7, V.ATTRIBUTE8, V.ATTRIBUTE9, V.ATTRIBUTE10, V.ATTRIBUTE11, V.ATTRIBUTE12, V.ATTRIBUTE13, V.ATTRIBUTE14, V.ATTRIBUTE15, V.LAST_UPDATE_DATE, V.LAST_UPDATED_BY, V.CREATION_DATE, V.CREATED_BY, V.LAST_UPDATE_LOGIN, V.REQUEST_ID, V.JOB_DEFINITION_NAME, V.JOB_DEFINITION_PACKAGE, V.UOM_CODE, V.UOM_CLASS, V.BASE_UOM_FLAG, V.STANDARD_PACK_FLAG, V.UNIT_OF_MEASURE, V.DISABLE_DATE, V.DESCRIPTION, V.DERIVED_UNIT_PARENT_CODE, V.UOM_RECIPROCAL_DESC, V.UOM_PLURAL_DESC, V.HAS_GENERATED_CODE, V.GLOBAL_ATTRIBUTE_CATEGORY, V.GLOBAL_ATTRIBUTE1, V.GLOBAL_ATTRIBUTE2, V.GLOBAL_ATTRIBUTE3, V.GLOBAL_ATTRIBUTE4, V.GLOBAL_ATTRIBUTE5, V.GLOBAL_ATTRIBUTE6, V.GLOBAL_ATTRIBUTE7, V.GLOBAL_ATTRIBUTE8, V.GLOBAL_ATTRIBUTE9, V.GLOBAL_ATTRIBUTE10, V.GLOBAL_ATTRIBUTE11, V.GLOBAL_ATTRIBUTE12, V.GLOBAL_ATTRIBUTE13, V.GLOBAL_ATTRIBUTE14, V.GLOBAL_ATTRIBUTE15, V.GLOBAL_ATTRIBUTE16, V.GLOBAL_ATTRIBUTE17, V.GLOBAL_ATTRIBUTE18, V.GLOBAL_ATTRIBUTE19, V.GLOBAL_ATTRIBUTE20, V.GLOBAL_ATTRIBUTE_NUMBER1, V.GLOBAL_ATTRIBUTE_NUMBER2, V.GLOBAL_ATTRIBUTE_NUMBER3, V.GLOBAL_ATTRIBUTE_NUMBER4, V.GLOBAL_ATTRIBUTE_NUMBER5, V.GLOBAL_ATTRIBUTE_DATE1, V.GLOBAL_ATTRIBUTE_DATE2, V.GLOBAL_ATTRIBUTE_DATE3, V.GLOBAL_ATTRIBUTE_DATE4, V.GLOBAL_ATTRIBUTE_DATE5 FROM INV_UNITS_OF_MEASURE_ALL_VL V WHERE V.DERIVED_UNIT_PARENT_CODE IS NULL |