MSC_SP_MASS_UPDATE_COLUMNS_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
TABLE_NAME COLUMN_NAME FIELD_NAME VALUE_TYPE OPERATION_LOV_SQL VALUE_LOV_NAME DEFAULT_FLAG OBJECT_VERSION_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN VALUE_DATE VALUE_STRING VALUE_STRING_ID VALUE_NUMBER VALUE_NUMBER_WITH_LOV VALUE_STRING_AND_ID VALUE_STRING_ID2 OPERATION_CODE

Query

SQL_Statement

select b.table_name as table_name, b.column_name as column_name, t.field_name as field_name, b.value_type as value_type, b.operation_lov_sql as operation_lov_sql, b.value_lov_name as value_lov_name, b.default_flag as default_flag, b.object_version_number as object_version_number, b.last_update_date as last_update_date, b.last_updated_by as last_updated_by, b.creation_date as creation_date, b.created_by as created_by, b.last_update_login as last_update_login, to_date(null) as value_date, to_char(null) as value_string, to_number(null) as value_string_id, to_number(null) as value_number, to_number(null) as value_number_with_lov, to_char(null) as value_string_and_id, to_number(null) as value_string_id2, to_number(2) as operation_code from msc_sp_mass_update_columns_b b, msc_sp_mass_update_columns_tl t where b.table_name = t.table_name and b.column_name = t.column_name and T.LANGUAGE = userenv('LANG')