CSE_METER_DEFINITIONS

Details

Schema: FUSION
Object owner: CSE
Object type: VIEW

Columns

Name
METER_DEFINITION_ID OBJECT_VERSION_NUMBER TEMPLATE_USAGE_CODE METER_CODE METER_NAME METER_DESCRIPTION LANGUAGE SOURCE_LANG METER_TYPE_CODE READING_TYPE_CODE UOM_CODE READING_DIRECTION INITIAL_READING_VALUE READING_MIN_VALUE READING_MAX_VALUE RESET_ALLOWED_FLAG RESET_VALUE ROLLOVER_ALLOWED_FLAG ROLLOVER_MAX_VALUE ROLLOVER_RESET_VALUE ACTIVE_START_DATE ACTIVE_END_DATE RECORD_AT_WO_COMPL_CODE ALLOW_IN_MAINT_PROGRAM_FLAG DAILY_UTILIZATION_RATE UTILIZATION_RATE_COMPUTED_AT FORECAST_USING_DAILY_RATE_FLAG CURRENCY_CODE CORP_CURRENCY_CODE CURCY_CONV_RATE_TYPE ATTRIBUTE_CATEGORY EXTN_ATTRIBUTE_CHAR001 EXTN_ATTRIBUTE_CHAR002 EXTN_ATTRIBUTE_CHAR003 EXTN_ATTRIBUTE_CHAR004 EXTN_ATTRIBUTE_CHAR005 EXTN_ATTRIBUTE_CHAR006 EXTN_ATTRIBUTE_CHAR007 EXTN_ATTRIBUTE_CHAR008 EXTN_ATTRIBUTE_CHAR009 EXTN_ATTRIBUTE_CHAR010 EXTN_ATTRIBUTE_CHAR011 EXTN_ATTRIBUTE_CHAR012 EXTN_ATTRIBUTE_CHAR013 EXTN_ATTRIBUTE_CHAR014 EXTN_ATTRIBUTE_CHAR015 EXTN_ATTRIBUTE_CHAR016 EXTN_ATTRIBUTE_CHAR017 EXTN_ATTRIBUTE_CHAR018 EXTN_ATTRIBUTE_CHAR019 EXTN_ATTRIBUTE_CHAR020 EXTN_ATTRIBUTE_CHAR021 EXTN_ATTRIBUTE_CHAR022 EXTN_ATTRIBUTE_CHAR023 EXTN_ATTRIBUTE_CHAR024 EXTN_ATTRIBUTE_CHAR025 EXTN_ATTRIBUTE_CHAR026 EXTN_ATTRIBUTE_CHAR027 EXTN_ATTRIBUTE_CHAR028 EXTN_ATTRIBUTE_CHAR029 EXTN_ATTRIBUTE_CHAR030 EXTN_ATTRIBUTE_CHAR031 EXTN_ATTRIBUTE_CHAR032 EXTN_ATTRIBUTE_CHAR033 EXTN_ATTRIBUTE_CHAR034 EXTN_ATTRIBUTE_CHAR035 EXTN_ATTRIBUTE_CHAR036 EXTN_ATTRIBUTE_CHAR037 EXTN_ATTRIBUTE_CHAR038 EXTN_ATTRIBUTE_CHAR039 EXTN_ATTRIBUTE_CHAR040 EXTN_ATTRIBUTE_CHAR041 EXTN_ATTRIBUTE_CHAR042 EXTN_ATTRIBUTE_CHAR043 EXTN_ATTRIBUTE_CHAR044 EXTN_ATTRIBUTE_CHAR045 EXTN_ATTRIBUTE_CHAR046 EXTN_ATTRIBUTE_CHAR047 EXTN_ATTRIBUTE_CHAR048 EXTN_ATTRIBUTE_CHAR049 EXTN_ATTRIBUTE_CHAR050 EXTN_ATTRIBUTE_CHAR051 EXTN_ATTRIBUTE_CHAR052 EXTN_ATTRIBUTE_CHAR053 EXTN_ATTRIBUTE_CHAR054 EXTN_ATTRIBUTE_CHAR055 EXTN_ATTRIBUTE_CHAR056 EXTN_ATTRIBUTE_CHAR057 EXTN_ATTRIBUTE_CHAR058 EXTN_ATTRIBUTE_CHAR059 EXTN_ATTRIBUTE_CHAR060 EXTN_ATTRIBUTE_CHAR061 EXTN_ATTRIBUTE_CHAR062 EXTN_ATTRIBUTE_CHAR063 EXTN_ATTRIBUTE_CHAR064 EXTN_ATTRIBUTE_CHAR065 EXTN_ATTRIBUTE_CHAR066 EXTN_ATTRIBUTE_CHAR067 EXTN_ATTRIBUTE_CHAR068 EXTN_ATTRIBUTE_CHAR069 EXTN_ATTRIBUTE_CHAR070 EXTN_ATTRIBUTE_CHAR071 EXTN_ATTRIBUTE_CHAR072 EXTN_ATTRIBUTE_CHAR073 EXTN_ATTRIBUTE_CHAR074 EXTN_ATTRIBUTE_CHAR075 EXTN_ATTRIBUTE_CHAR076 EXTN_ATTRIBUTE_CHAR077 EXTN_ATTRIBUTE_CHAR078 EXTN_ATTRIBUTE_CHAR079 EXTN_ATTRIBUTE_CHAR080 EXTN_ATTRIBUTE_CHAR081 EXTN_ATTRIBUTE_CHAR082 EXTN_ATTRIBUTE_CHAR083 EXTN_ATTRIBUTE_CHAR084 EXTN_ATTRIBUTE_CHAR085 EXTN_ATTRIBUTE_CHAR086 EXTN_ATTRIBUTE_CHAR087 EXTN_ATTRIBUTE_CHAR088 EXTN_ATTRIBUTE_CHAR089 EXTN_ATTRIBUTE_CHAR090 EXTN_ATTRIBUTE_CHAR091 EXTN_ATTRIBUTE_CHAR092 EXTN_ATTRIBUTE_CHAR093 EXTN_ATTRIBUTE_CHAR094 EXTN_ATTRIBUTE_CHAR095 EXTN_ATTRIBUTE_CHAR096 EXTN_ATTRIBUTE_CHAR097 EXTN_ATTRIBUTE_CHAR098 EXTN_ATTRIBUTE_CHAR099 EXTN_ATTRIBUTE_CHAR100 EXTN_ATTRIBUTE_NUMBER001 EXTN_ATTRIBUTE_NUMBER002 EXTN_ATTRIBUTE_NUMBER003 EXTN_ATTRIBUTE_NUMBER004 EXTN_ATTRIBUTE_NUMBER005 EXTN_ATTRIBUTE_NUMBER006 EXTN_ATTRIBUTE_NUMBER007 EXTN_ATTRIBUTE_NUMBER008 EXTN_ATTRIBUTE_NUMBER009 EXTN_ATTRIBUTE_NUMBER010 EXTN_ATTRIBUTE_NUMBER011 EXTN_ATTRIBUTE_NUMBER012 EXTN_ATTRIBUTE_NUMBER013 EXTN_ATTRIBUTE_NUMBER014 EXTN_ATTRIBUTE_NUMBER015 EXTN_ATTRIBUTE_NUMBER016 EXTN_ATTRIBUTE_NUMBER017 EXTN_ATTRIBUTE_NUMBER018 EXTN_ATTRIBUTE_NUMBER019 EXTN_ATTRIBUTE_NUMBER020 EXTN_ATTRIBUTE_NUMBER021 EXTN_ATTRIBUTE_NUMBER022 EXTN_ATTRIBUTE_NUMBER023 EXTN_ATTRIBUTE_NUMBER024 EXTN_ATTRIBUTE_NUMBER025 EXTN_ATTRIBUTE_NUMBER026 EXTN_ATTRIBUTE_NUMBER027 EXTN_ATTRIBUTE_NUMBER028 EXTN_ATTRIBUTE_NUMBER029 EXTN_ATTRIBUTE_NUMBER030 EXTN_ATTRIBUTE_NUMBER031 EXTN_ATTRIBUTE_NUMBER032 EXTN_ATTRIBUTE_NUMBER033 EXTN_ATTRIBUTE_NUMBER034 EXTN_ATTRIBUTE_NUMBER035 EXTN_ATTRIBUTE_NUMBER036 EXTN_ATTRIBUTE_NUMBER037 EXTN_ATTRIBUTE_NUMBER038 EXTN_ATTRIBUTE_NUMBER039 EXTN_ATTRIBUTE_NUMBER040 EXTN_ATTRIBUTE_NUMBER041 EXTN_ATTRIBUTE_NUMBER042 EXTN_ATTRIBUTE_NUMBER043 EXTN_ATTRIBUTE_NUMBER044 EXTN_ATTRIBUTE_NUMBER045 EXTN_ATTRIBUTE_NUMBER046 EXTN_ATTRIBUTE_NUMBER047 EXTN_ATTRIBUTE_NUMBER048 EXTN_ATTRIBUTE_NUMBER049 EXTN_ATTRIBUTE_NUMBER050 EXTN_ATTRIBUTE_TIMESTAMP001 EXTN_ATTRIBUTE_TIMESTAMP002 EXTN_ATTRIBUTE_TIMESTAMP003 EXTN_ATTRIBUTE_TIMESTAMP004 EXTN_ATTRIBUTE_TIMESTAMP005 EXTN_ATTRIBUTE_TIMESTAMP006 EXTN_ATTRIBUTE_TIMESTAMP007 EXTN_ATTRIBUTE_TIMESTAMP008 EXTN_ATTRIBUTE_TIMESTAMP009 EXTN_ATTRIBUTE_TIMESTAMP010 EXTN_ATTRIBUTE_CLOB001 EXTN_ATTRIBUTE_CLOB002 EXTN_ATTRIBUTE_CLOB003 EXTN_ATTRIBUTE_CLOB004 EXTN_ATTRIBUTE_CLOB005 CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE

Name

METER_DEFINITION_ID

OBJECT_VERSION_NUMBER

TEMPLATE_USAGE_CODE

METER_CODE

METER_NAME

METER_DESCRIPTION

LANGUAGE

SOURCE_LANG

METER_TYPE_CODE

READING_TYPE_CODE

UOM_CODE

READING_DIRECTION

INITIAL_READING_VALUE

READING_MIN_VALUE

READING_MAX_VALUE

RESET_ALLOWED_FLAG

RESET_VALUE

ROLLOVER_ALLOWED_FLAG

ROLLOVER_MAX_VALUE

ROLLOVER_RESET_VALUE

ACTIVE_START_DATE

ACTIVE_END_DATE

RECORD_AT_WO_COMPL_CODE

ALLOW_IN_MAINT_PROGRAM_FLAG

DAILY_UTILIZATION_RATE

UTILIZATION_RATE_COMPUTED_AT

FORECAST_USING_DAILY_RATE_FLAG

CURRENCY_CODE

CORP_CURRENCY_CODE

CURCY_CONV_RATE_TYPE

ATTRIBUTE_CATEGORY

EXTN_ATTRIBUTE_CHAR001

EXTN_ATTRIBUTE_CHAR002

EXTN_ATTRIBUTE_CHAR003

EXTN_ATTRIBUTE_CHAR004

EXTN_ATTRIBUTE_CHAR005

EXTN_ATTRIBUTE_CHAR006

EXTN_ATTRIBUTE_CHAR007

EXTN_ATTRIBUTE_CHAR008

EXTN_ATTRIBUTE_CHAR009

EXTN_ATTRIBUTE_CHAR010

EXTN_ATTRIBUTE_CHAR011

EXTN_ATTRIBUTE_CHAR012

EXTN_ATTRIBUTE_CHAR013

EXTN_ATTRIBUTE_CHAR014

EXTN_ATTRIBUTE_CHAR015

EXTN_ATTRIBUTE_CHAR016

EXTN_ATTRIBUTE_CHAR017

EXTN_ATTRIBUTE_CHAR018

EXTN_ATTRIBUTE_CHAR019

EXTN_ATTRIBUTE_CHAR020

EXTN_ATTRIBUTE_CHAR021

EXTN_ATTRIBUTE_CHAR022

EXTN_ATTRIBUTE_CHAR023

EXTN_ATTRIBUTE_CHAR024

EXTN_ATTRIBUTE_CHAR025

EXTN_ATTRIBUTE_CHAR026

EXTN_ATTRIBUTE_CHAR027

EXTN_ATTRIBUTE_CHAR028

EXTN_ATTRIBUTE_CHAR029

EXTN_ATTRIBUTE_CHAR030

EXTN_ATTRIBUTE_CHAR031

EXTN_ATTRIBUTE_CHAR032

EXTN_ATTRIBUTE_CHAR033

EXTN_ATTRIBUTE_CHAR034

EXTN_ATTRIBUTE_CHAR035

EXTN_ATTRIBUTE_CHAR036

EXTN_ATTRIBUTE_CHAR037

EXTN_ATTRIBUTE_CHAR038

EXTN_ATTRIBUTE_CHAR039

EXTN_ATTRIBUTE_CHAR040

EXTN_ATTRIBUTE_CHAR041

EXTN_ATTRIBUTE_CHAR042

EXTN_ATTRIBUTE_CHAR043

EXTN_ATTRIBUTE_CHAR044

EXTN_ATTRIBUTE_CHAR045

EXTN_ATTRIBUTE_CHAR046

EXTN_ATTRIBUTE_CHAR047

EXTN_ATTRIBUTE_CHAR048

EXTN_ATTRIBUTE_CHAR049

EXTN_ATTRIBUTE_CHAR050

EXTN_ATTRIBUTE_CHAR051

EXTN_ATTRIBUTE_CHAR052

EXTN_ATTRIBUTE_CHAR053

EXTN_ATTRIBUTE_CHAR054

EXTN_ATTRIBUTE_CHAR055

EXTN_ATTRIBUTE_CHAR056

EXTN_ATTRIBUTE_CHAR057

EXTN_ATTRIBUTE_CHAR058

EXTN_ATTRIBUTE_CHAR059

EXTN_ATTRIBUTE_CHAR060

EXTN_ATTRIBUTE_CHAR061

EXTN_ATTRIBUTE_CHAR062

EXTN_ATTRIBUTE_CHAR063

EXTN_ATTRIBUTE_CHAR064

EXTN_ATTRIBUTE_CHAR065

EXTN_ATTRIBUTE_CHAR066

EXTN_ATTRIBUTE_CHAR067

EXTN_ATTRIBUTE_CHAR068

EXTN_ATTRIBUTE_CHAR069

EXTN_ATTRIBUTE_CHAR070

EXTN_ATTRIBUTE_CHAR071

EXTN_ATTRIBUTE_CHAR072

EXTN_ATTRIBUTE_CHAR073

EXTN_ATTRIBUTE_CHAR074

EXTN_ATTRIBUTE_CHAR075

EXTN_ATTRIBUTE_CHAR076

EXTN_ATTRIBUTE_CHAR077

EXTN_ATTRIBUTE_CHAR078

EXTN_ATTRIBUTE_CHAR079

EXTN_ATTRIBUTE_CHAR080

EXTN_ATTRIBUTE_CHAR081

EXTN_ATTRIBUTE_CHAR082

EXTN_ATTRIBUTE_CHAR083

EXTN_ATTRIBUTE_CHAR084

EXTN_ATTRIBUTE_CHAR085

EXTN_ATTRIBUTE_CHAR086

EXTN_ATTRIBUTE_CHAR087

EXTN_ATTRIBUTE_CHAR088

EXTN_ATTRIBUTE_CHAR089

EXTN_ATTRIBUTE_CHAR090

EXTN_ATTRIBUTE_CHAR091

EXTN_ATTRIBUTE_CHAR092

EXTN_ATTRIBUTE_CHAR093

EXTN_ATTRIBUTE_CHAR094

EXTN_ATTRIBUTE_CHAR095

EXTN_ATTRIBUTE_CHAR096

EXTN_ATTRIBUTE_CHAR097

EXTN_ATTRIBUTE_CHAR098

EXTN_ATTRIBUTE_CHAR099

EXTN_ATTRIBUTE_CHAR100

EXTN_ATTRIBUTE_NUMBER001

EXTN_ATTRIBUTE_NUMBER002

EXTN_ATTRIBUTE_NUMBER003

EXTN_ATTRIBUTE_NUMBER004

EXTN_ATTRIBUTE_NUMBER005

EXTN_ATTRIBUTE_NUMBER006

EXTN_ATTRIBUTE_NUMBER007

EXTN_ATTRIBUTE_NUMBER008

EXTN_ATTRIBUTE_NUMBER009

EXTN_ATTRIBUTE_NUMBER010

EXTN_ATTRIBUTE_NUMBER011

EXTN_ATTRIBUTE_NUMBER012

EXTN_ATTRIBUTE_NUMBER013

EXTN_ATTRIBUTE_NUMBER014

EXTN_ATTRIBUTE_NUMBER015

EXTN_ATTRIBUTE_NUMBER016

EXTN_ATTRIBUTE_NUMBER017

EXTN_ATTRIBUTE_NUMBER018

EXTN_ATTRIBUTE_NUMBER019

EXTN_ATTRIBUTE_NUMBER020

EXTN_ATTRIBUTE_NUMBER021

EXTN_ATTRIBUTE_NUMBER022

EXTN_ATTRIBUTE_NUMBER023

EXTN_ATTRIBUTE_NUMBER024

EXTN_ATTRIBUTE_NUMBER025

EXTN_ATTRIBUTE_NUMBER026

EXTN_ATTRIBUTE_NUMBER027

EXTN_ATTRIBUTE_NUMBER028

EXTN_ATTRIBUTE_NUMBER029

EXTN_ATTRIBUTE_NUMBER030

EXTN_ATTRIBUTE_NUMBER031

EXTN_ATTRIBUTE_NUMBER032

EXTN_ATTRIBUTE_NUMBER033

EXTN_ATTRIBUTE_NUMBER034

EXTN_ATTRIBUTE_NUMBER035

EXTN_ATTRIBUTE_NUMBER036

EXTN_ATTRIBUTE_NUMBER037

EXTN_ATTRIBUTE_NUMBER038

EXTN_ATTRIBUTE_NUMBER039

EXTN_ATTRIBUTE_NUMBER040

EXTN_ATTRIBUTE_NUMBER041

EXTN_ATTRIBUTE_NUMBER042

EXTN_ATTRIBUTE_NUMBER043

EXTN_ATTRIBUTE_NUMBER044

EXTN_ATTRIBUTE_NUMBER045

EXTN_ATTRIBUTE_NUMBER046

EXTN_ATTRIBUTE_NUMBER047

EXTN_ATTRIBUTE_NUMBER048

EXTN_ATTRIBUTE_NUMBER049

EXTN_ATTRIBUTE_NUMBER050

EXTN_ATTRIBUTE_TIMESTAMP001

EXTN_ATTRIBUTE_TIMESTAMP002

EXTN_ATTRIBUTE_TIMESTAMP003

EXTN_ATTRIBUTE_TIMESTAMP004

EXTN_ATTRIBUTE_TIMESTAMP005

EXTN_ATTRIBUTE_TIMESTAMP006

EXTN_ATTRIBUTE_TIMESTAMP007

EXTN_ATTRIBUTE_TIMESTAMP008

EXTN_ATTRIBUTE_TIMESTAMP009

EXTN_ATTRIBUTE_TIMESTAMP010

EXTN_ATTRIBUTE_CLOB001

EXTN_ATTRIBUTE_CLOB002

EXTN_ATTRIBUTE_CLOB003

EXTN_ATTRIBUTE_CLOB004

EXTN_ATTRIBUTE_CLOB005

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

REQUEST_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

Query

SQL_Statement
SELECT MDB.METER_DEFINITION_ID METER_DEFINITION_ID, MDB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, MDB.TEMPLATE_USAGE_CODE TEMPLATE_USAGE_CODE, MDB.METER_CODE METER_CODE, MDT.METER_NAME METER_NAME, MDT.METER_DESCRIPTION METER_DESCRIPTION, MDT.LANGUAGE LANGUAGE, MDT.SOURCE_LANG SOURCE_LANG, MDB.METER_TYPE_CODE METER_TYPE_CODE, MDB.READING_TYPE_CODE READING_TYPE_CODE, MDB.UOM_CODE UOM_CODE, MDB.READING_DIRECTION READING_DIRECTION, MDB.INITIAL_READING_VALUE INITIAL_READING_VALUE, MDB.READING_MIN_VALUE READING_MIN_VALUE, MDB.READING_MAX_VALUE READING_MAX_VALUE, MDB.RESET_ALLOWED_FLAG RESET_ALLOWED_FLAG, MDB.RESET_VALUE RESET_VALUE, MDB.ROLLOVER_ALLOWED_FLAG ROLLOVER_ALLOWED_FLAG, MDB.ROLLOVER_MAX_VALUE ROLLOVER_MAX_VALUE, MDB.ROLLOVER_RESET_VALUE ROLLOVER_RESET_VALUE, MDB.ACTIVE_START_DATE ACTIVE_START_DATE, MDB.ACTIVE_END_DATE ACTIVE_END_DATE, MDB.RECORD_AT_WO_COMPL_CODE RECORD_AT_WO_COMPL_CODE, MDB.ALLOW_IN_MAINT_PROGRAM_FLAG ALLOW_IN_MAINT_PROGRAM_FLAG, MDB.DAILY_UTILIZATION_RATE DAILY_UTILIZATION_RATE, MDB.UTILIZATION_RATE_COMPUTED_AT UTILIZATION_RATE_COMPUTED_AT, MDB.FORECAST_USING_DAILY_RATE_FLAG FORECAST_USING_DAILY_RATE_FLAG, MDB.CURRENCY_CODE CURRENCY_CODE, MDB.CORP_CURRENCY_CODE CORP_CURRENCY_CODE, MDB.CURCY_CONV_RATE_TYPE CURCY_CONV_RATE_TYPE, MDB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, MDB.EXTN_ATTRIBUTE_CHAR001 EXTN_ATTRIBUTE_CHAR001, MDB.EXTN_ATTRIBUTE_CHAR002 EXTN_ATTRIBUTE_CHAR002, MDB.EXTN_ATTRIBUTE_CHAR003 EXTN_ATTRIBUTE_CHAR003, MDB.EXTN_ATTRIBUTE_CHAR004 EXTN_ATTRIBUTE_CHAR004, MDB.EXTN_ATTRIBUTE_CHAR005 EXTN_ATTRIBUTE_CHAR005, MDB.EXTN_ATTRIBUTE_CHAR006 EXTN_ATTRIBUTE_CHAR006, MDB.EXTN_ATTRIBUTE_CHAR007 EXTN_ATTRIBUTE_CHAR007, MDB.EXTN_ATTRIBUTE_CHAR008 EXTN_ATTRIBUTE_CHAR008, MDB.EXTN_ATTRIBUTE_CHAR009 EXTN_ATTRIBUTE_CHAR009, MDB.EXTN_ATTRIBUTE_CHAR010 EXTN_ATTRIBUTE_CHAR010, MDB.EXTN_ATTRIBUTE_CHAR011 EXTN_ATTRIBUTE_CHAR011, MDB.EXTN_ATTRIBUTE_CHAR012 EXTN_ATTRIBUTE_CHAR012, MDB.EXTN_ATTRIBUTE_CHAR013 EXTN_ATTRIBUTE_CHAR013, MDB.EXTN_ATTRIBUTE_CHAR014 EXTN_ATTRIBUTE_CHAR014, MDB.EXTN_ATTRIBUTE_CHAR015 EXTN_ATTRIBUTE_CHAR015, MDB.EXTN_ATTRIBUTE_CHAR016 EXTN_ATTRIBUTE_CHAR016, MDB.EXTN_ATTRIBUTE_CHAR017 EXTN_ATTRIBUTE_CHAR017, MDB.EXTN_ATTRIBUTE_CHAR018 EXTN_ATTRIBUTE_CHAR018, MDB.EXTN_ATTRIBUTE_CHAR019 EXTN_ATTRIBUTE_CHAR019, MDB.EXTN_ATTRIBUTE_CHAR020 EXTN_ATTRIBUTE_CHAR020, MDB.EXTN_ATTRIBUTE_CHAR021 EXTN_ATTRIBUTE_CHAR021, MDB.EXTN_ATTRIBUTE_CHAR022 EXTN_ATTRIBUTE_CHAR022, MDB.EXTN_ATTRIBUTE_CHAR023 EXTN_ATTRIBUTE_CHAR023, MDB.EXTN_ATTRIBUTE_CHAR024 EXTN_ATTRIBUTE_CHAR024, MDB.EXTN_ATTRIBUTE_CHAR025 EXTN_ATTRIBUTE_CHAR025, MDB.EXTN_ATTRIBUTE_CHAR026 EXTN_ATTRIBUTE_CHAR026, MDB.EXTN_ATTRIBUTE_CHAR027 EXTN_ATTRIBUTE_CHAR027, MDB.EXTN_ATTRIBUTE_CHAR028 EXTN_ATTRIBUTE_CHAR028, MDB.EXTN_ATTRIBUTE_CHAR029 EXTN_ATTRIBUTE_CHAR029, MDB.EXTN_ATTRIBUTE_CHAR030 EXTN_ATTRIBUTE_CHAR030, MDB.EXTN_ATTRIBUTE_CHAR031 EXTN_ATTRIBUTE_CHAR031, MDB.EXTN_ATTRIBUTE_CHAR032 EXTN_ATTRIBUTE_CHAR032, MDB.EXTN_ATTRIBUTE_CHAR033 EXTN_ATTRIBUTE_CHAR033, MDB.EXTN_ATTRIBUTE_CHAR034 EXTN_ATTRIBUTE_CHAR034, MDB.EXTN_ATTRIBUTE_CHAR035 EXTN_ATTRIBUTE_CHAR035, MDB.EXTN_ATTRIBUTE_CHAR036 EXTN_ATTRIBUTE_CHAR036, MDB.EXTN_ATTRIBUTE_CHAR037 EXTN_ATTRIBUTE_CHAR037, MDB.EXTN_ATTRIBUTE_CHAR038 EXTN_ATTRIBUTE_CHAR038, MDB.EXTN_ATTRIBUTE_CHAR039 EXTN_ATTRIBUTE_CHAR039, MDB.EXTN_ATTRIBUTE_CHAR040 EXTN_ATTRIBUTE_CHAR040, MDB.EXTN_ATTRIBUTE_CHAR041 EXTN_ATTRIBUTE_CHAR041, MDB.EXTN_ATTRIBUTE_CHAR042 EXTN_ATTRIBUTE_CHAR042, MDB.EXTN_ATTRIBUTE_CHAR043 EXTN_ATTRIBUTE_CHAR043, MDB.EXTN_ATTRIBUTE_CHAR044 EXTN_ATTRIBUTE_CHAR044, MDB.EXTN_ATTRIBUTE_CHAR045 EXTN_ATTRIBUTE_CHAR045, MDB.EXTN_ATTRIBUTE_CHAR046 EXTN_ATTRIBUTE_CHAR046, MDB.EXTN_ATTRIBUTE_CHAR047 EXTN_ATTRIBUTE_CHAR047, MDB.EXTN_ATTRIBUTE_CHAR048 EXTN_ATTRIBUTE_CHAR048, MDB.EXTN_ATTRIBUTE_CHAR049 EXTN_ATTRIBUTE_CHAR049, MDB.EXTN_ATTRIBUTE_CHAR050 EXTN_ATTRIBUTE_CHAR050, MDB.EXTN_ATTRIBUTE_CHAR051 EXTN_ATTRIBUTE_CHAR051, MDB.EXTN_ATTRIBUTE_CHAR052 EXTN_ATTRIBUTE_CHAR052, MDB.EXTN_ATTRIBUTE_CHAR053 EXTN_ATTRIBUTE_CHAR053, MDB.EXTN_ATTRIBUTE_CHAR054 EXTN_ATTRIBUTE_CHAR054, MDB.EXTN_ATTRIBUTE_CHAR055 EXTN_ATTRIBUTE_CHAR055, MDB.EXTN_ATTRIBUTE_CHAR056 EXTN_ATTRIBUTE_CHAR056, MDB.EXTN_ATTRIBUTE_CHAR057 EXTN_ATTRIBUTE_CHAR057, MDB.EXTN_ATTRIBUTE_CHAR058 EXTN_ATTRIBUTE_CHAR058, MDB.EXTN_ATTRIBUTE_CHAR059 EXTN_ATTRIBUTE_CHAR059, MDB.EXTN_ATTRIBUTE_CHAR060 EXTN_ATTRIBUTE_CHAR060, MDB.EXTN_ATTRIBUTE_CHAR061 EXTN_ATTRIBUTE_CHAR061, MDB.EXTN_ATTRIBUTE_CHAR062 EXTN_ATTRIBUTE_CHAR062, MDB.EXTN_ATTRIBUTE_CHAR063 EXTN_ATTRIBUTE_CHAR063, MDB.EXTN_ATTRIBUTE_CHAR064 EXTN_ATTRIBUTE_CHAR064, MDB.EXTN_ATTRIBUTE_CHAR065 EXTN_ATTRIBUTE_CHAR065, MDB.EXTN_ATTRIBUTE_CHAR066 EXTN_ATTRIBUTE_CHAR066, MDB.EXTN_ATTRIBUTE_CHAR067 EXTN_ATTRIBUTE_CHAR067, MDB.EXTN_ATTRIBUTE_CHAR068 EXTN_ATTRIBUTE_CHAR068, MDB.EXTN_ATTRIBUTE_CHAR069 EXTN_ATTRIBUTE_CHAR069, MDB.EXTN_ATTRIBUTE_CHAR070 EXTN_ATTRIBUTE_CHAR070, MDB.EXTN_ATTRIBUTE_CHAR071 EXTN_ATTRIBUTE_CHAR071, MDB.EXTN_ATTRIBUTE_CHAR072 EXTN_ATTRIBUTE_CHAR072, MDB.EXTN_ATTRIBUTE_CHAR073 EXTN_ATTRIBUTE_CHAR073, MDB.EXTN_ATTRIBUTE_CHAR074 EXTN_ATTRIBUTE_CHAR074, MDB.EXTN_ATTRIBUTE_CHAR075 EXTN_ATTRIBUTE_CHAR075, MDB.EXTN_ATTRIBUTE_CHAR076 EXTN_ATTRIBUTE_CHAR076, MDB.EXTN_ATTRIBUTE_CHAR077 EXTN_ATTRIBUTE_CHAR077, MDB.EXTN_ATTRIBUTE_CHAR078 EXTN_ATTRIBUTE_CHAR078, MDB.EXTN_ATTRIBUTE_CHAR079 EXTN_ATTRIBUTE_CHAR079, MDB.EXTN_ATTRIBUTE_CHAR080 EXTN_ATTRIBUTE_CHAR080, MDB.EXTN_ATTRIBUTE_CHAR081 EXTN_ATTRIBUTE_CHAR081, MDB.EXTN_ATTRIBUTE_CHAR082 EXTN_ATTRIBUTE_CHAR082, MDB.EXTN_ATTRIBUTE_CHAR083 EXTN_ATTRIBUTE_CHAR083, MDB.EXTN_ATTRIBUTE_CHAR084 EXTN_ATTRIBUTE_CHAR084, MDB.EXTN_ATTRIBUTE_CHAR085 EXTN_ATTRIBUTE_CHAR085, MDB.EXTN_ATTRIBUTE_CHAR086 EXTN_ATTRIBUTE_CHAR086, MDB.EXTN_ATTRIBUTE_CHAR087 EXTN_ATTRIBUTE_CHAR087, MDB.EXTN_ATTRIBUTE_CHAR088 EXTN_ATTRIBUTE_CHAR088, MDB.EXTN_ATTRIBUTE_CHAR089 EXTN_ATTRIBUTE_CHAR089, MDB.EXTN_ATTRIBUTE_CHAR090 EXTN_ATTRIBUTE_CHAR090, MDB.EXTN_ATTRIBUTE_CHAR091 EXTN_ATTRIBUTE_CHAR091, MDB.EXTN_ATTRIBUTE_CHAR092 EXTN_ATTRIBUTE_CHAR092, MDB.EXTN_ATTRIBUTE_CHAR093 EXTN_ATTRIBUTE_CHAR093, MDB.EXTN_ATTRIBUTE_CHAR094 EXTN_ATTRIBUTE_CHAR094, MDB.EXTN_ATTRIBUTE_CHAR095 EXTN_ATTRIBUTE_CHAR095, MDB.EXTN_ATTRIBUTE_CHAR096 EXTN_ATTRIBUTE_CHAR096, MDB.EXTN_ATTRIBUTE_CHAR097 EXTN_ATTRIBUTE_CHAR097, MDB.EXTN_ATTRIBUTE_CHAR098 EXTN_ATTRIBUTE_CHAR098, MDB.EXTN_ATTRIBUTE_CHAR099 EXTN_ATTRIBUTE_CHAR099, MDB.EXTN_ATTRIBUTE_CHAR100 EXTN_ATTRIBUTE_CHAR100, MDB.EXTN_ATTRIBUTE_NUMBER001 EXTN_ATTRIBUTE_NUMBER001, MDB.EXTN_ATTRIBUTE_NUMBER002 EXTN_ATTRIBUTE_NUMBER002, MDB.EXTN_ATTRIBUTE_NUMBER003 EXTN_ATTRIBUTE_NUMBER003, MDB.EXTN_ATTRIBUTE_NUMBER004 EXTN_ATTRIBUTE_NUMBER004, MDB.EXTN_ATTRIBUTE_NUMBER005 EXTN_ATTRIBUTE_NUMBER005, MDB.EXTN_ATTRIBUTE_NUMBER006 EXTN_ATTRIBUTE_NUMBER006, MDB.EXTN_ATTRIBUTE_NUMBER007 EXTN_ATTRIBUTE_NUMBER007, MDB.EXTN_ATTRIBUTE_NUMBER008 EXTN_ATTRIBUTE_NUMBER008, MDB.EXTN_ATTRIBUTE_NUMBER009 EXTN_ATTRIBUTE_NUMBER009, MDB.EXTN_ATTRIBUTE_NUMBER010 EXTN_ATTRIBUTE_NUMBER010, MDB.EXTN_ATTRIBUTE_NUMBER011 EXTN_ATTRIBUTE_NUMBER011, MDB.EXTN_ATTRIBUTE_NUMBER012 EXTN_ATTRIBUTE_NUMBER012, MDB.EXTN_ATTRIBUTE_NUMBER013 EXTN_ATTRIBUTE_NUMBER013, MDB.EXTN_ATTRIBUTE_NUMBER014 EXTN_ATTRIBUTE_NUMBER014, MDB.EXTN_ATTRIBUTE_NUMBER015 EXTN_ATTRIBUTE_NUMBER015, MDB.EXTN_ATTRIBUTE_NUMBER016 EXTN_ATTRIBUTE_NUMBER016, MDB.EXTN_ATTRIBUTE_NUMBER017 EXTN_ATTRIBUTE_NUMBER017, MDB.EXTN_ATTRIBUTE_NUMBER018 EXTN_ATTRIBUTE_NUMBER018, MDB.EXTN_ATTRIBUTE_NUMBER019 EXTN_ATTRIBUTE_NUMBER019, MDB.EXTN_ATTRIBUTE_NUMBER020 EXTN_ATTRIBUTE_NUMBER020, MDB.EXTN_ATTRIBUTE_NUMBER021 EXTN_ATTRIBUTE_NUMBER021, MDB.EXTN_ATTRIBUTE_NUMBER022 EXTN_ATTRIBUTE_NUMBER022, MDB.EXTN_ATTRIBUTE_NUMBER023 EXTN_ATTRIBUTE_NUMBER023, MDB.EXTN_ATTRIBUTE_NUMBER024 EXTN_ATTRIBUTE_NUMBER024, MDB.EXTN_ATTRIBUTE_NUMBER025 EXTN_ATTRIBUTE_NUMBER025, MDB.EXTN_ATTRIBUTE_NUMBER026 EXTN_ATTRIBUTE_NUMBER026, MDB.EXTN_ATTRIBUTE_NUMBER027 EXTN_ATTRIBUTE_NUMBER027, MDB.EXTN_ATTRIBUTE_NUMBER028 EXTN_ATTRIBUTE_NUMBER028, MDB.EXTN_ATTRIBUTE_NUMBER029 EXTN_ATTRIBUTE_NUMBER029, MDB.EXTN_ATTRIBUTE_NUMBER030 EXTN_ATTRIBUTE_NUMBER030, MDB.EXTN_ATTRIBUTE_NUMBER031 EXTN_ATTRIBUTE_NUMBER031, MDB.EXTN_ATTRIBUTE_NUMBER032 EXTN_ATTRIBUTE_NUMBER032, MDB.EXTN_ATTRIBUTE_NUMBER033 EXTN_ATTRIBUTE_NUMBER033, MDB.EXTN_ATTRIBUTE_NUMBER034 EXTN_ATTRIBUTE_NUMBER034, MDB.EXTN_ATTRIBUTE_NUMBER035 EXTN_ATTRIBUTE_NUMBER035, MDB.EXTN_ATTRIBUTE_NUMBER036 EXTN_ATTRIBUTE_NUMBER036, MDB.EXTN_ATTRIBUTE_NUMBER037 EXTN_ATTRIBUTE_NUMBER037, MDB.EXTN_ATTRIBUTE_NUMBER038 EXTN_ATTRIBUTE_NUMBER038, MDB.EXTN_ATTRIBUTE_NUMBER039 EXTN_ATTRIBUTE_NUMBER039, MDB.EXTN_ATTRIBUTE_NUMBER040 EXTN_ATTRIBUTE_NUMBER040, MDB.EXTN_ATTRIBUTE_NUMBER041 EXTN_ATTRIBUTE_NUMBER041, MDB.EXTN_ATTRIBUTE_NUMBER042 EXTN_ATTRIBUTE_NUMBER042, MDB.EXTN_ATTRIBUTE_NUMBER043 EXTN_ATTRIBUTE_NUMBER043, MDB.EXTN_ATTRIBUTE_NUMBER044 EXTN_ATTRIBUTE_NUMBER044, MDB.EXTN_ATTRIBUTE_NUMBER045 EXTN_ATTRIBUTE_NUMBER045, MDB.EXTN_ATTRIBUTE_NUMBER046 EXTN_ATTRIBUTE_NUMBER046, MDB.EXTN_ATTRIBUTE_NUMBER047 EXTN_ATTRIBUTE_NUMBER047, MDB.EXTN_ATTRIBUTE_NUMBER048 EXTN_ATTRIBUTE_NUMBER048, MDB.EXTN_ATTRIBUTE_NUMBER049 EXTN_ATTRIBUTE_NUMBER049, MDB.EXTN_ATTRIBUTE_NUMBER050 EXTN_ATTRIBUTE_NUMBER050, MDB.EXTN_ATTRIBUTE_TIMESTAMP001 EXTN_ATTRIBUTE_TIMESTAMP001, MDB.EXTN_ATTRIBUTE_TIMESTAMP002 EXTN_ATTRIBUTE_TIMESTAMP002, MDB.EXTN_ATTRIBUTE_TIMESTAMP003 EXTN_ATTRIBUTE_TIMESTAMP003, MDB.EXTN_ATTRIBUTE_TIMESTAMP004 EXTN_ATTRIBUTE_TIMESTAMP004, MDB.EXTN_ATTRIBUTE_TIMESTAMP005 EXTN_ATTRIBUTE_TIMESTAMP005, MDB.EXTN_ATTRIBUTE_TIMESTAMP006 EXTN_ATTRIBUTE_TIMESTAMP006, MDB.EXTN_ATTRIBUTE_TIMESTAMP007 EXTN_ATTRIBUTE_TIMESTAMP007, MDB.EXTN_ATTRIBUTE_TIMESTAMP008 EXTN_ATTRIBUTE_TIMESTAMP008, MDB.EXTN_ATTRIBUTE_TIMESTAMP009 EXTN_ATTRIBUTE_TIMESTAMP009, MDB.EXTN_ATTRIBUTE_TIMESTAMP010 EXTN_ATTRIBUTE_TIMESTAMP010, MDB.EXTN_ATTRIBUTE_CLOB001 EXTN_ATTRIBUTE_CLOB001, MDB.EXTN_ATTRIBUTE_CLOB002 EXTN_ATTRIBUTE_CLOB002, MDB.EXTN_ATTRIBUTE_CLOB003 EXTN_ATTRIBUTE_CLOB003, MDB.EXTN_ATTRIBUTE_CLOB004 EXTN_ATTRIBUTE_CLOB004, MDB.EXTN_ATTRIBUTE_CLOB005 EXTN_ATTRIBUTE_CLOB005, MDB.CREATED_BY CREATED_BY, MDB.CREATION_DATE CREATION_DATE, MDB.LAST_UPDATED_BY LAST_UPDATED_BY, MDB.LAST_UPDATE_DATE LAST_UPDATE_DATE, MDB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MDB.REQUEST_ID REQUEST_ID, MDB.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, MDB.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE FROM CSE_METER_DEFINITIONS_B MDB, CSE_METER_DEFINITIONS_TL MDT WHERE MDT.METER_DEFINITION_ID = MDB.METER_DEFINITION_ID AND MDT.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

MDB.METER_DEFINITION_ID METER_DEFINITION_ID,

MDB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

MDB.TEMPLATE_USAGE_CODE TEMPLATE_USAGE_CODE,

MDB.METER_CODE METER_CODE,

MDT.METER_NAME METER_NAME,

MDT.METER_DESCRIPTION METER_DESCRIPTION,

MDT.LANGUAGE LANGUAGE,

MDT.SOURCE_LANG SOURCE_LANG,

MDB.METER_TYPE_CODE METER_TYPE_CODE,

MDB.READING_TYPE_CODE READING_TYPE_CODE,

MDB.UOM_CODE UOM_CODE,

MDB.READING_DIRECTION READING_DIRECTION,

MDB.INITIAL_READING_VALUE INITIAL_READING_VALUE,

MDB.READING_MIN_VALUE READING_MIN_VALUE,

MDB.READING_MAX_VALUE READING_MAX_VALUE,

MDB.RESET_ALLOWED_FLAG RESET_ALLOWED_FLAG,

MDB.RESET_VALUE RESET_VALUE,

MDB.ROLLOVER_ALLOWED_FLAG ROLLOVER_ALLOWED_FLAG,

MDB.ROLLOVER_MAX_VALUE ROLLOVER_MAX_VALUE,

MDB.ROLLOVER_RESET_VALUE ROLLOVER_RESET_VALUE,

MDB.ACTIVE_START_DATE ACTIVE_START_DATE,

MDB.ACTIVE_END_DATE ACTIVE_END_DATE,

MDB.RECORD_AT_WO_COMPL_CODE RECORD_AT_WO_COMPL_CODE,

MDB.ALLOW_IN_MAINT_PROGRAM_FLAG ALLOW_IN_MAINT_PROGRAM_FLAG,

MDB.DAILY_UTILIZATION_RATE DAILY_UTILIZATION_RATE,

MDB.UTILIZATION_RATE_COMPUTED_AT UTILIZATION_RATE_COMPUTED_AT,

MDB.FORECAST_USING_DAILY_RATE_FLAG FORECAST_USING_DAILY_RATE_FLAG,

MDB.CURRENCY_CODE CURRENCY_CODE,

MDB.CORP_CURRENCY_CODE CORP_CURRENCY_CODE,

MDB.CURCY_CONV_RATE_TYPE CURCY_CONV_RATE_TYPE,

MDB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

MDB.EXTN_ATTRIBUTE_CHAR001 EXTN_ATTRIBUTE_CHAR001,

MDB.EXTN_ATTRIBUTE_CHAR002 EXTN_ATTRIBUTE_CHAR002,

MDB.EXTN_ATTRIBUTE_CHAR003 EXTN_ATTRIBUTE_CHAR003,

MDB.EXTN_ATTRIBUTE_CHAR004 EXTN_ATTRIBUTE_CHAR004,

MDB.EXTN_ATTRIBUTE_CHAR005 EXTN_ATTRIBUTE_CHAR005,

MDB.EXTN_ATTRIBUTE_CHAR006 EXTN_ATTRIBUTE_CHAR006,

MDB.EXTN_ATTRIBUTE_CHAR007 EXTN_ATTRIBUTE_CHAR007,

MDB.EXTN_ATTRIBUTE_CHAR008 EXTN_ATTRIBUTE_CHAR008,

MDB.EXTN_ATTRIBUTE_CHAR009 EXTN_ATTRIBUTE_CHAR009,

MDB.EXTN_ATTRIBUTE_CHAR010 EXTN_ATTRIBUTE_CHAR010,

MDB.EXTN_ATTRIBUTE_CHAR011 EXTN_ATTRIBUTE_CHAR011,

MDB.EXTN_ATTRIBUTE_CHAR012 EXTN_ATTRIBUTE_CHAR012,

MDB.EXTN_ATTRIBUTE_CHAR013 EXTN_ATTRIBUTE_CHAR013,

MDB.EXTN_ATTRIBUTE_CHAR014 EXTN_ATTRIBUTE_CHAR014,

MDB.EXTN_ATTRIBUTE_CHAR015 EXTN_ATTRIBUTE_CHAR015,

MDB.EXTN_ATTRIBUTE_CHAR016 EXTN_ATTRIBUTE_CHAR016,

MDB.EXTN_ATTRIBUTE_CHAR017 EXTN_ATTRIBUTE_CHAR017,

MDB.EXTN_ATTRIBUTE_CHAR018 EXTN_ATTRIBUTE_CHAR018,

MDB.EXTN_ATTRIBUTE_CHAR019 EXTN_ATTRIBUTE_CHAR019,

MDB.EXTN_ATTRIBUTE_CHAR020 EXTN_ATTRIBUTE_CHAR020,

MDB.EXTN_ATTRIBUTE_CHAR021 EXTN_ATTRIBUTE_CHAR021,

MDB.EXTN_ATTRIBUTE_CHAR022 EXTN_ATTRIBUTE_CHAR022,

MDB.EXTN_ATTRIBUTE_CHAR023 EXTN_ATTRIBUTE_CHAR023,

MDB.EXTN_ATTRIBUTE_CHAR024 EXTN_ATTRIBUTE_CHAR024,

MDB.EXTN_ATTRIBUTE_CHAR025 EXTN_ATTRIBUTE_CHAR025,

MDB.EXTN_ATTRIBUTE_CHAR026 EXTN_ATTRIBUTE_CHAR026,

MDB.EXTN_ATTRIBUTE_CHAR027 EXTN_ATTRIBUTE_CHAR027,

MDB.EXTN_ATTRIBUTE_CHAR028 EXTN_ATTRIBUTE_CHAR028,

MDB.EXTN_ATTRIBUTE_CHAR029 EXTN_ATTRIBUTE_CHAR029,

MDB.EXTN_ATTRIBUTE_CHAR030 EXTN_ATTRIBUTE_CHAR030,

MDB.EXTN_ATTRIBUTE_CHAR031 EXTN_ATTRIBUTE_CHAR031,

MDB.EXTN_ATTRIBUTE_CHAR032 EXTN_ATTRIBUTE_CHAR032,

MDB.EXTN_ATTRIBUTE_CHAR033 EXTN_ATTRIBUTE_CHAR033,

MDB.EXTN_ATTRIBUTE_CHAR034 EXTN_ATTRIBUTE_CHAR034,

MDB.EXTN_ATTRIBUTE_CHAR035 EXTN_ATTRIBUTE_CHAR035,

MDB.EXTN_ATTRIBUTE_CHAR036 EXTN_ATTRIBUTE_CHAR036,

MDB.EXTN_ATTRIBUTE_CHAR037 EXTN_ATTRIBUTE_CHAR037,

MDB.EXTN_ATTRIBUTE_CHAR038 EXTN_ATTRIBUTE_CHAR038,

MDB.EXTN_ATTRIBUTE_CHAR039 EXTN_ATTRIBUTE_CHAR039,

MDB.EXTN_ATTRIBUTE_CHAR040 EXTN_ATTRIBUTE_CHAR040,

MDB.EXTN_ATTRIBUTE_CHAR041 EXTN_ATTRIBUTE_CHAR041,

MDB.EXTN_ATTRIBUTE_CHAR042 EXTN_ATTRIBUTE_CHAR042,

MDB.EXTN_ATTRIBUTE_CHAR043 EXTN_ATTRIBUTE_CHAR043,

MDB.EXTN_ATTRIBUTE_CHAR044 EXTN_ATTRIBUTE_CHAR044,

MDB.EXTN_ATTRIBUTE_CHAR045 EXTN_ATTRIBUTE_CHAR045,

MDB.EXTN_ATTRIBUTE_CHAR046 EXTN_ATTRIBUTE_CHAR046,

MDB.EXTN_ATTRIBUTE_CHAR047 EXTN_ATTRIBUTE_CHAR047,

MDB.EXTN_ATTRIBUTE_CHAR048 EXTN_ATTRIBUTE_CHAR048,

MDB.EXTN_ATTRIBUTE_CHAR049 EXTN_ATTRIBUTE_CHAR049,

MDB.EXTN_ATTRIBUTE_CHAR050 EXTN_ATTRIBUTE_CHAR050,

MDB.EXTN_ATTRIBUTE_CHAR051 EXTN_ATTRIBUTE_CHAR051,

MDB.EXTN_ATTRIBUTE_CHAR052 EXTN_ATTRIBUTE_CHAR052,

MDB.EXTN_ATTRIBUTE_CHAR053 EXTN_ATTRIBUTE_CHAR053,

MDB.EXTN_ATTRIBUTE_CHAR054 EXTN_ATTRIBUTE_CHAR054,

MDB.EXTN_ATTRIBUTE_CHAR055 EXTN_ATTRIBUTE_CHAR055,

MDB.EXTN_ATTRIBUTE_CHAR056 EXTN_ATTRIBUTE_CHAR056,

MDB.EXTN_ATTRIBUTE_CHAR057 EXTN_ATTRIBUTE_CHAR057,

MDB.EXTN_ATTRIBUTE_CHAR058 EXTN_ATTRIBUTE_CHAR058,

MDB.EXTN_ATTRIBUTE_CHAR059 EXTN_ATTRIBUTE_CHAR059,

MDB.EXTN_ATTRIBUTE_CHAR060 EXTN_ATTRIBUTE_CHAR060,

MDB.EXTN_ATTRIBUTE_CHAR061 EXTN_ATTRIBUTE_CHAR061,

MDB.EXTN_ATTRIBUTE_CHAR062 EXTN_ATTRIBUTE_CHAR062,

MDB.EXTN_ATTRIBUTE_CHAR063 EXTN_ATTRIBUTE_CHAR063,

MDB.EXTN_ATTRIBUTE_CHAR064 EXTN_ATTRIBUTE_CHAR064,

MDB.EXTN_ATTRIBUTE_CHAR065 EXTN_ATTRIBUTE_CHAR065,

MDB.EXTN_ATTRIBUTE_CHAR066 EXTN_ATTRIBUTE_CHAR066,

MDB.EXTN_ATTRIBUTE_CHAR067 EXTN_ATTRIBUTE_CHAR067,

MDB.EXTN_ATTRIBUTE_CHAR068 EXTN_ATTRIBUTE_CHAR068,

MDB.EXTN_ATTRIBUTE_CHAR069 EXTN_ATTRIBUTE_CHAR069,

MDB.EXTN_ATTRIBUTE_CHAR070 EXTN_ATTRIBUTE_CHAR070,

MDB.EXTN_ATTRIBUTE_CHAR071 EXTN_ATTRIBUTE_CHAR071,

MDB.EXTN_ATTRIBUTE_CHAR072 EXTN_ATTRIBUTE_CHAR072,

MDB.EXTN_ATTRIBUTE_CHAR073 EXTN_ATTRIBUTE_CHAR073,

MDB.EXTN_ATTRIBUTE_CHAR074 EXTN_ATTRIBUTE_CHAR074,

MDB.EXTN_ATTRIBUTE_CHAR075 EXTN_ATTRIBUTE_CHAR075,

MDB.EXTN_ATTRIBUTE_CHAR076 EXTN_ATTRIBUTE_CHAR076,

MDB.EXTN_ATTRIBUTE_CHAR077 EXTN_ATTRIBUTE_CHAR077,

MDB.EXTN_ATTRIBUTE_CHAR078 EXTN_ATTRIBUTE_CHAR078,

MDB.EXTN_ATTRIBUTE_CHAR079 EXTN_ATTRIBUTE_CHAR079,

MDB.EXTN_ATTRIBUTE_CHAR080 EXTN_ATTRIBUTE_CHAR080,

MDB.EXTN_ATTRIBUTE_CHAR081 EXTN_ATTRIBUTE_CHAR081,

MDB.EXTN_ATTRIBUTE_CHAR082 EXTN_ATTRIBUTE_CHAR082,

MDB.EXTN_ATTRIBUTE_CHAR083 EXTN_ATTRIBUTE_CHAR083,

MDB.EXTN_ATTRIBUTE_CHAR084 EXTN_ATTRIBUTE_CHAR084,

MDB.EXTN_ATTRIBUTE_CHAR085 EXTN_ATTRIBUTE_CHAR085,

MDB.EXTN_ATTRIBUTE_CHAR086 EXTN_ATTRIBUTE_CHAR086,

MDB.EXTN_ATTRIBUTE_CHAR087 EXTN_ATTRIBUTE_CHAR087,

MDB.EXTN_ATTRIBUTE_CHAR088 EXTN_ATTRIBUTE_CHAR088,

MDB.EXTN_ATTRIBUTE_CHAR089 EXTN_ATTRIBUTE_CHAR089,

MDB.EXTN_ATTRIBUTE_CHAR090 EXTN_ATTRIBUTE_CHAR090,

MDB.EXTN_ATTRIBUTE_CHAR091 EXTN_ATTRIBUTE_CHAR091,

MDB.EXTN_ATTRIBUTE_CHAR092 EXTN_ATTRIBUTE_CHAR092,

MDB.EXTN_ATTRIBUTE_CHAR093 EXTN_ATTRIBUTE_CHAR093,

MDB.EXTN_ATTRIBUTE_CHAR094 EXTN_ATTRIBUTE_CHAR094,

MDB.EXTN_ATTRIBUTE_CHAR095 EXTN_ATTRIBUTE_CHAR095,

MDB.EXTN_ATTRIBUTE_CHAR096 EXTN_ATTRIBUTE_CHAR096,

MDB.EXTN_ATTRIBUTE_CHAR097 EXTN_ATTRIBUTE_CHAR097,

MDB.EXTN_ATTRIBUTE_CHAR098 EXTN_ATTRIBUTE_CHAR098,

MDB.EXTN_ATTRIBUTE_CHAR099 EXTN_ATTRIBUTE_CHAR099,

MDB.EXTN_ATTRIBUTE_CHAR100 EXTN_ATTRIBUTE_CHAR100,

MDB.EXTN_ATTRIBUTE_NUMBER001 EXTN_ATTRIBUTE_NUMBER001,

MDB.EXTN_ATTRIBUTE_NUMBER002 EXTN_ATTRIBUTE_NUMBER002,

MDB.EXTN_ATTRIBUTE_NUMBER003 EXTN_ATTRIBUTE_NUMBER003,

MDB.EXTN_ATTRIBUTE_NUMBER004 EXTN_ATTRIBUTE_NUMBER004,

MDB.EXTN_ATTRIBUTE_NUMBER005 EXTN_ATTRIBUTE_NUMBER005,

MDB.EXTN_ATTRIBUTE_NUMBER006 EXTN_ATTRIBUTE_NUMBER006,

MDB.EXTN_ATTRIBUTE_NUMBER007 EXTN_ATTRIBUTE_NUMBER007,

MDB.EXTN_ATTRIBUTE_NUMBER008 EXTN_ATTRIBUTE_NUMBER008,

MDB.EXTN_ATTRIBUTE_NUMBER009 EXTN_ATTRIBUTE_NUMBER009,

MDB.EXTN_ATTRIBUTE_NUMBER010 EXTN_ATTRIBUTE_NUMBER010,

MDB.EXTN_ATTRIBUTE_NUMBER011 EXTN_ATTRIBUTE_NUMBER011,

MDB.EXTN_ATTRIBUTE_NUMBER012 EXTN_ATTRIBUTE_NUMBER012,

MDB.EXTN_ATTRIBUTE_NUMBER013 EXTN_ATTRIBUTE_NUMBER013,

MDB.EXTN_ATTRIBUTE_NUMBER014 EXTN_ATTRIBUTE_NUMBER014,

MDB.EXTN_ATTRIBUTE_NUMBER015 EXTN_ATTRIBUTE_NUMBER015,

MDB.EXTN_ATTRIBUTE_NUMBER016 EXTN_ATTRIBUTE_NUMBER016,

MDB.EXTN_ATTRIBUTE_NUMBER017 EXTN_ATTRIBUTE_NUMBER017,

MDB.EXTN_ATTRIBUTE_NUMBER018 EXTN_ATTRIBUTE_NUMBER018,

MDB.EXTN_ATTRIBUTE_NUMBER019 EXTN_ATTRIBUTE_NUMBER019,

MDB.EXTN_ATTRIBUTE_NUMBER020 EXTN_ATTRIBUTE_NUMBER020,

MDB.EXTN_ATTRIBUTE_NUMBER021 EXTN_ATTRIBUTE_NUMBER021,

MDB.EXTN_ATTRIBUTE_NUMBER022 EXTN_ATTRIBUTE_NUMBER022,

MDB.EXTN_ATTRIBUTE_NUMBER023 EXTN_ATTRIBUTE_NUMBER023,

MDB.EXTN_ATTRIBUTE_NUMBER024 EXTN_ATTRIBUTE_NUMBER024,

MDB.EXTN_ATTRIBUTE_NUMBER025 EXTN_ATTRIBUTE_NUMBER025,

MDB.EXTN_ATTRIBUTE_NUMBER026 EXTN_ATTRIBUTE_NUMBER026,

MDB.EXTN_ATTRIBUTE_NUMBER027 EXTN_ATTRIBUTE_NUMBER027,

MDB.EXTN_ATTRIBUTE_NUMBER028 EXTN_ATTRIBUTE_NUMBER028,

MDB.EXTN_ATTRIBUTE_NUMBER029 EXTN_ATTRIBUTE_NUMBER029,

MDB.EXTN_ATTRIBUTE_NUMBER030 EXTN_ATTRIBUTE_NUMBER030,

MDB.EXTN_ATTRIBUTE_NUMBER031 EXTN_ATTRIBUTE_NUMBER031,

MDB.EXTN_ATTRIBUTE_NUMBER032 EXTN_ATTRIBUTE_NUMBER032,

MDB.EXTN_ATTRIBUTE_NUMBER033 EXTN_ATTRIBUTE_NUMBER033,

MDB.EXTN_ATTRIBUTE_NUMBER034 EXTN_ATTRIBUTE_NUMBER034,

MDB.EXTN_ATTRIBUTE_NUMBER035 EXTN_ATTRIBUTE_NUMBER035,

MDB.EXTN_ATTRIBUTE_NUMBER036 EXTN_ATTRIBUTE_NUMBER036,

MDB.EXTN_ATTRIBUTE_NUMBER037 EXTN_ATTRIBUTE_NUMBER037,

MDB.EXTN_ATTRIBUTE_NUMBER038 EXTN_ATTRIBUTE_NUMBER038,

MDB.EXTN_ATTRIBUTE_NUMBER039 EXTN_ATTRIBUTE_NUMBER039,

MDB.EXTN_ATTRIBUTE_NUMBER040 EXTN_ATTRIBUTE_NUMBER040,

MDB.EXTN_ATTRIBUTE_NUMBER041 EXTN_ATTRIBUTE_NUMBER041,

MDB.EXTN_ATTRIBUTE_NUMBER042 EXTN_ATTRIBUTE_NUMBER042,

MDB.EXTN_ATTRIBUTE_NUMBER043 EXTN_ATTRIBUTE_NUMBER043,

MDB.EXTN_ATTRIBUTE_NUMBER044 EXTN_ATTRIBUTE_NUMBER044,

MDB.EXTN_ATTRIBUTE_NUMBER045 EXTN_ATTRIBUTE_NUMBER045,

MDB.EXTN_ATTRIBUTE_NUMBER046 EXTN_ATTRIBUTE_NUMBER046,

MDB.EXTN_ATTRIBUTE_NUMBER047 EXTN_ATTRIBUTE_NUMBER047,

MDB.EXTN_ATTRIBUTE_NUMBER048 EXTN_ATTRIBUTE_NUMBER048,

MDB.EXTN_ATTRIBUTE_NUMBER049 EXTN_ATTRIBUTE_NUMBER049,

MDB.EXTN_ATTRIBUTE_NUMBER050 EXTN_ATTRIBUTE_NUMBER050,

MDB.EXTN_ATTRIBUTE_TIMESTAMP001 EXTN_ATTRIBUTE_TIMESTAMP001,

MDB.EXTN_ATTRIBUTE_TIMESTAMP002 EXTN_ATTRIBUTE_TIMESTAMP002,

MDB.EXTN_ATTRIBUTE_TIMESTAMP003 EXTN_ATTRIBUTE_TIMESTAMP003,

MDB.EXTN_ATTRIBUTE_TIMESTAMP004 EXTN_ATTRIBUTE_TIMESTAMP004,

MDB.EXTN_ATTRIBUTE_TIMESTAMP005 EXTN_ATTRIBUTE_TIMESTAMP005,

MDB.EXTN_ATTRIBUTE_TIMESTAMP006 EXTN_ATTRIBUTE_TIMESTAMP006,

MDB.EXTN_ATTRIBUTE_TIMESTAMP007 EXTN_ATTRIBUTE_TIMESTAMP007,

MDB.EXTN_ATTRIBUTE_TIMESTAMP008 EXTN_ATTRIBUTE_TIMESTAMP008,

MDB.EXTN_ATTRIBUTE_TIMESTAMP009 EXTN_ATTRIBUTE_TIMESTAMP009,

MDB.EXTN_ATTRIBUTE_TIMESTAMP010 EXTN_ATTRIBUTE_TIMESTAMP010,

MDB.EXTN_ATTRIBUTE_CLOB001 EXTN_ATTRIBUTE_CLOB001,

MDB.EXTN_ATTRIBUTE_CLOB002 EXTN_ATTRIBUTE_CLOB002,

MDB.EXTN_ATTRIBUTE_CLOB003 EXTN_ATTRIBUTE_CLOB003,

MDB.EXTN_ATTRIBUTE_CLOB004 EXTN_ATTRIBUTE_CLOB004,

MDB.EXTN_ATTRIBUTE_CLOB005 EXTN_ATTRIBUTE_CLOB005,

MDB.CREATED_BY CREATED_BY,

MDB.CREATION_DATE CREATION_DATE,

MDB.LAST_UPDATED_BY LAST_UPDATED_BY,

MDB.LAST_UPDATE_DATE LAST_UPDATE_DATE,

MDB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

MDB.REQUEST_ID REQUEST_ID,

MDB.JOB_DEFINITION_NAME JOB_DEFINITION_NAME,

MDB.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE

FROM

CSE_METER_DEFINITIONS_B MDB,

CSE_METER_DEFINITIONS_TL MDT

WHERE

MDT.METER_DEFINITION_ID = MDB.METER_DEFINITION_ID AND MDT.LANGUAGE = USERENV('LANG')