OSS_METER_INSTANCE

Details

Name
PRODUCT_NUMBER PRODUCT_NAME METER_NAME METER_CODE METER_TYPE_CODE READING_TYPE_CODE METER_ID INITIAL_READING_VALUE METER_DEFINITION_ID DEFINITION_START_DATE DEFINITION_END_DATE SUBSCRIPTION_NUMBER SUBSCRIPTION_ID SUBSCRIPTION_PRODUCT_ID

Name

PRODUCT_NUMBER

PRODUCT_NAME

METER_NAME

METER_CODE

METER_TYPE_CODE

READING_TYPE_CODE

METER_ID

INITIAL_READING_VALUE

METER_DEFINITION_ID

DEFINITION_START_DATE

DEFINITION_END_DATE

SUBSCRIPTION_NUMBER

SUBSCRIPTION_ID

SUBSCRIPTION_PRODUCT_ID

SQL_Statement
select p.product_number, p.product_name, d.meter_name, d.meter_code, d.meter_type_code, d.reading_type_code, m.meter_id, m.initial_reading_value, d.meter_definition_id, d.active_start_date as definition_start_date, d.active_end_date as definition_end_date, s.subscription_number, s.subscription_id, p.subscription_product_id from oss_products p , oss_subscriptions s, cse_meters m ,cse_meter_definitions_vl d where p.subscription_id = s.subscription_id and NVL(s.usage_capture,'ORA_THIRD_PARTY') = 'ORA_FUSION' and p.subscription_product_id = m.meter_object_id and m.meter_usage_code = 'ORA_CONTRACT_LINE' and m.meter_definition_id = d.meter_definition_id order by s.subscription_number, p.product_name, m.meter_id

SQL_Statement

select

p.product_number,

p.product_name,

d.meter_name,

d.meter_code,

d.meter_type_code,

d.reading_type_code,

m.meter_id,

m.initial_reading_value,

d.meter_definition_id,

d.active_start_date as definition_start_date,

d.active_end_date as definition_end_date,

s.subscription_number,

s.subscription_id,

p.subscription_product_id

from oss_products p , oss_subscriptions s, cse_meters m ,cse_meter_definitions_vl d

where p.subscription_id = s.subscription_id

and NVL(s.usage_capture,'ORA_THIRD_PARTY') = 'ORA_FUSION'

and p.subscription_product_id = m.meter_object_id

and m.meter_usage_code = 'ORA_CONTRACT_LINE'

and m.meter_definition_id = d.meter_definition_id

order by s.subscription_number, p.product_name, m.meter_id