VIEW: APPS.EAM_CFR_COUNTER_READINGS_V

Source

View Text - Preformatted

SELECT ccrv.counter_value_id, ccrv.counter_name, ccrv.counter_description, ccrv.initial_reading, ccrv.reading_type, CLK.MEANING READING_TYPE, ccrv.uom_code, ccrv.direction, CLK2.MEANING DIRECTION, ccrv.counter_type, ccrv.rollover_last_reading, ccrv.rollover_first_reading, ccrv.customer_view, ccrv.filter_type, ccrv.filter_time_uom, ccrv.group_id, ccrv.counter_id, ccrv.value_timestamp, ccrv.counter_reading, ccrv.reset_mode, ccrv.reset_reason, ccrv.adjustment_type, ccrv.adjustment_reading, ccrv.object_version_number, ccrv.last_update_date, ccrv.last_updated_by, ccrv.creation_date, ccrv.created_by, ccrv.last_update_login, ccrv.attribute1, ccrv.attribute2, ccrv.attribute3, ccrv.attribute4, ccrv.attribute5, ccrv.attribute6, ccrv.attribute7, ccrv.attribute8, ccrv.attribute9, ccrv.attribute10, ccrv.attribute11, ccrv.attribute12, ccrv.attribute13, ccrv.attribute14, ccrv.attribute15, ccrv.attribute16, ccrv.attribute17, ccrv.attribute18, ccrv.attribute19, ccrv.attribute20, ccrv.attribute21, ccrv.attribute22, ccrv.attribute23, ccrv.attribute24, ccrv.attribute25, ccrv.attribute26, ccrv.attribute27, ccrv.attribute28, ccrv.attribute29, ccrv.attribute30, ccrv.attribute_category, ccrv.migrated_flag, ccrv.comments, ccrv.life_to_date_reading, ccrv.net_reading, ccrv.disabled_flag, ccrv.automatic_rollover_flag, ccrv.transaction_id, ccrv.include_target_resets, ccrv.source_counter_value_id, ccrv.reading_before_reset, ccrv.reading_after_reset FROM csi_counter_readings_v ccrv, CSI_LOOKUPS CLK2, CSI_LOOKUPS CLK WHERE to_char(ccrv.reading_type)=to_char(clk.lookup_code) AND clk.lookup_type='CSI_COUNTER_READING_TYPE' AND nvl(ccrv.direction,'B')=clk2.lookup_code AND clk2.lookup_type='CSI_COUNTER_DIRECTION_TYPE'

View Text - HTML Formatted

SELECT CCRV.COUNTER_VALUE_ID
, CCRV.COUNTER_NAME
, CCRV.COUNTER_DESCRIPTION
, CCRV.INITIAL_READING
, CCRV.READING_TYPE
, CLK.MEANING READING_TYPE
, CCRV.UOM_CODE
, CCRV.DIRECTION
, CLK2.MEANING DIRECTION
, CCRV.COUNTER_TYPE
, CCRV.ROLLOVER_LAST_READING
, CCRV.ROLLOVER_FIRST_READING
, CCRV.CUSTOMER_VIEW
, CCRV.FILTER_TYPE
, CCRV.FILTER_TIME_UOM
, CCRV.GROUP_ID
, CCRV.COUNTER_ID
, CCRV.VALUE_TIMESTAMP
, CCRV.COUNTER_READING
, CCRV.RESET_MODE
, CCRV.RESET_REASON
, CCRV.ADJUSTMENT_TYPE
, CCRV.ADJUSTMENT_READING
, CCRV.OBJECT_VERSION_NUMBER
, CCRV.LAST_UPDATE_DATE
, CCRV.LAST_UPDATED_BY
, CCRV.CREATION_DATE
, CCRV.CREATED_BY
, CCRV.LAST_UPDATE_LOGIN
, CCRV.ATTRIBUTE1
, CCRV.ATTRIBUTE2
, CCRV.ATTRIBUTE3
, CCRV.ATTRIBUTE4
, CCRV.ATTRIBUTE5
, CCRV.ATTRIBUTE6
, CCRV.ATTRIBUTE7
, CCRV.ATTRIBUTE8
, CCRV.ATTRIBUTE9
, CCRV.ATTRIBUTE10
, CCRV.ATTRIBUTE11
, CCRV.ATTRIBUTE12
, CCRV.ATTRIBUTE13
, CCRV.ATTRIBUTE14
, CCRV.ATTRIBUTE15
, CCRV.ATTRIBUTE16
, CCRV.ATTRIBUTE17
, CCRV.ATTRIBUTE18
, CCRV.ATTRIBUTE19
, CCRV.ATTRIBUTE20
, CCRV.ATTRIBUTE21
, CCRV.ATTRIBUTE22
, CCRV.ATTRIBUTE23
, CCRV.ATTRIBUTE24
, CCRV.ATTRIBUTE25
, CCRV.ATTRIBUTE26
, CCRV.ATTRIBUTE27
, CCRV.ATTRIBUTE28
, CCRV.ATTRIBUTE29
, CCRV.ATTRIBUTE30
, CCRV.ATTRIBUTE_CATEGORY
, CCRV.MIGRATED_FLAG
, CCRV.COMMENTS
, CCRV.LIFE_TO_DATE_READING
, CCRV.NET_READING
, CCRV.DISABLED_FLAG
, CCRV.AUTOMATIC_ROLLOVER_FLAG
, CCRV.TRANSACTION_ID
, CCRV.INCLUDE_TARGET_RESETS
, CCRV.SOURCE_COUNTER_VALUE_ID
, CCRV.READING_BEFORE_RESET
, CCRV.READING_AFTER_RESET
FROM CSI_COUNTER_READINGS_V CCRV
, CSI_LOOKUPS CLK2
, CSI_LOOKUPS CLK
WHERE TO_CHAR(CCRV.READING_TYPE)=TO_CHAR(CLK.LOOKUP_CODE)
AND CLK.LOOKUP_TYPE='CSI_COUNTER_READING_TYPE'
AND NVL(CCRV.DIRECTION
, 'B')=CLK2.LOOKUP_CODE
AND CLK2.LOOKUP_TYPE='CSI_COUNTER_DIRECTION_TYPE'