OKC_TIME_CODE_UNITS_VL

Details

• Schema: FUSION

• Object owner: OKC

• Object type: VIEW

Columns

Name
CONVERSION_ID USER_UOM_CODE BASE_UOM_CODE CONVERSION_RATE ACTIVE_FLAG CONVERSION_CODE DESCRIPTION OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement
select tb.conversion_id, tb.user_uom_code, tb.base_uom_code, tb.conversion_rate, tb.active_flag, tb.conversion_code, tl.description, tb.object_version_number, tb.created_by, tb.creation_date, tb.last_updated_by, tb.last_update_date, tb.last_update_login from okc_time_code_units_b tb , okc_time_code_units_tl tl where tb.conversion_id = tl.conversion_id and tl.language = userenv('LANG')