OSS_METER_READINGS

Details

Schema: FUSION
Object owner: OSS
Object type: VIEW

Columns

Name
PRODUCT_NUMBER PRODUCT_NAME CHARGE_NAME METER_NAME METER_CODE METER_TYPE_CODE AGGREGATION_METHOD READING_DATE READING_TYPE_CODE READING_VALUE READING_NET_CHANGE DISPLAYED_VALUE NET_VALUE INITIAL_READING INITIAL_FLAG METER_READING_ID SUBSCRIPTION_NUMBER SUBSCRIPTION_ID SUBSCRIPTION_PRODUCT_ID METER_ID INITIAL_METER_READING_ID

Name

PRODUCT_NUMBER

PRODUCT_NAME

CHARGE_NAME

METER_NAME

METER_CODE

METER_TYPE_CODE

AGGREGATION_METHOD

READING_DATE

READING_TYPE_CODE

READING_VALUE

READING_NET_CHANGE

DISPLAYED_VALUE

NET_VALUE

INITIAL_READING

INITIAL_FLAG

METER_READING_ID

SUBSCRIPTION_NUMBER

SUBSCRIPTION_ID

SUBSCRIPTION_PRODUCT_ID

METER_ID

INITIAL_METER_READING_ID

Query

SQL_Statement
select p.product_number, p.product_name, c.charge_name, d.meter_name, d.meter_code, c.meter_type_code, c.aggregation_method, h.reading_date, h.reading_type_code, h.reading_value, h.reading_net_change, h.displayed_value, h.net_value, (select i.reading_value from cse_meter_readings i where i.meter_reading_id = c.initial_meter_reading_id ) as initial_reading, h.initial_flag, h.meter_reading_id, s.subscription_number, s.subscription_id, p.subscription_product_id, c.meter_id, c.initial_meter_reading_id from oss_charges c , oss_products p , oss_subscriptions s, cse_meters m ,cse_meter_definitions_vl d, cse_meter_readings h where c.subscription_id = s.subscription_id and NVL(s.usage_capture,'ORA_THIRD_PARTY') = 'ORA_FUSION' and c.subscription_product_id = p.subscription_product_id and c.meter_id = m.meter_id and m.meter_definition_id = d.meter_definition_id and m.meter_id = h.meter_id(+) and c.meter_id is not null order by s.subscription_number, p.product_name, h.reading_date

SQL_Statement

select

p.product_number,

p.product_name,

c.charge_name,

d.meter_name,

d.meter_code,

c.meter_type_code,

c.aggregation_method,

h.reading_date,

h.reading_type_code,

h.reading_value,

h.reading_net_change,

h.displayed_value,

h.net_value,

(select i.reading_value from cse_meter_readings i where i.meter_reading_id = c.initial_meter_reading_id ) as initial_reading,

h.initial_flag,

h.meter_reading_id,

s.subscription_number,

s.subscription_id,

p.subscription_product_id,

c.meter_id,

c.initial_meter_reading_id

from oss_charges c , oss_products p , oss_subscriptions s, cse_meters m ,cse_meter_definitions_vl d, cse_meter_readings h

where c.subscription_id = s.subscription_id

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

and c.subscription_product_id = p.subscription_product_id

and c.meter_id = m.meter_id

and m.meter_definition_id = d.meter_definition_id

and m.meter_id = h.meter_id(+)

and c.meter_id is not null

order by s.subscription_number, p.product_name, h.reading_date