VIEW: APPS.CSF_M_COUNTER_VALUES_V

Source

View Text - Preformatted

SELECT CSM_UTIL_PKG.GET_NUMBER(acc.access_id) , CSM_UTIL_PKG.GET_NUMBER(acc.user_id) , counters.group_id AS COUNTER_GROUP_ID, CSM_UTIL_PKG.GET_NUMBER(ass.source_object_id) , CSM_UTIL_PKG.GET_DATE(counter_value.value_timestamp) , CSM_UTIL_PKG.GET_NUMBER(counter_value.counter_reading) , counter_value.reset_flag , counter_value.reset_reason , counter_value.pre_reset_last_rdg , counter_value.post_reset_first_rdg , counter_value.misc_reading_type , counter_value.misc_reading , counter_value.counter_value_id , CSM_UTIL_PKG.GET_NUMBER(counters.counter_id), CSM_UTIL_PKG.GET_DATE(counter_value.last_update_date), counter_value.source_transaction_code, counter_value.source_transaction_id, counter_value.context, counter_value.attribute1, counter_value.attribute2, counter_value.attribute3, counter_value.attribute4, counter_value.attribute5, counter_value.attribute6, counter_value.attribute7, counter_value.attribute8, counter_value.attribute9, counter_value.attribute10, counter_value.attribute11, counter_value.attribute12, counter_value.attribute13, counter_value.attribute14, counter_value.attribute15, CSM_UTIL_PKG.get_number(cntr_reading.net_reading), CSM_UTIL_PKG.get_number(cntr_reading.life_to_date_reading), cntr_reading.adjustment_type, cntr_reading.adjustment_reading, cntr_reading.disabled_flag, cntr_reading.reset_mode, CSM_UTIL_PKG.get_number(cntr_reading.object_version_number), cntr_reading.include_target_resets, cntr_reading.source_code, cntr_reading.source_line_id, cntr_reading.comments, cntr_reading.automatic_rollover_flag, cntr_reading.migrated_flag, ctr_reading_int.reset_counter_reading, CSM_UTIL_PKG.GET_NUMBER(counter_value.created_by) AS CREATED_BY, CSM_UTIL_PKG.GET_NUMBER(counter_value.last_updated_by) AS LAST_UPDATED_BY, CSM_UTIL_PKG.GET_DATE(counter_value.last_update_date) AS SERVER_LAST_UPDATE_DATE FROM CSI_COUNTERS_B counters , CSI_COUNTER_ASSOCIATIONS ass, CS_CTR_COUNTER_VALUES_V counter_value , csm_counter_values_acc acc, csi_counter_readings cntr_reading, csi_ctr_readings_interface ctr_reading_int WHERE acc.counter_value_id = counter_value.counter_value_id AND acc.user_id = asg_base.get_user_id AND counter_value.counter_id = counters.counter_id AND counters.counter_id = ass.counter_id AND ass.source_object_code = 'CP' AND counters.counter_type = 'REGULAR' AND counter_value.counter_id = cntr_reading.counter_id AND counter_value.counter_value_id = cntr_reading.counter_value_id AND ctr_reading_int.counter_id(+)= counter_value.counter_id and ctr_reading_int.counter_value_id (+)= counter_value.counter_value_id

View Text - HTML Formatted

SELECT CSM_UTIL_PKG.GET_NUMBER(ACC.ACCESS_ID)
, CSM_UTIL_PKG.GET_NUMBER(ACC.USER_ID)
, COUNTERS.GROUP_ID AS COUNTER_GROUP_ID
, CSM_UTIL_PKG.GET_NUMBER(ASS.SOURCE_OBJECT_ID)
, CSM_UTIL_PKG.GET_DATE(COUNTER_VALUE.VALUE_TIMESTAMP)
, CSM_UTIL_PKG.GET_NUMBER(COUNTER_VALUE.COUNTER_READING)
, COUNTER_VALUE.RESET_FLAG
, COUNTER_VALUE.RESET_REASON
, COUNTER_VALUE.PRE_RESET_LAST_RDG
, COUNTER_VALUE.POST_RESET_FIRST_RDG
, COUNTER_VALUE.MISC_READING_TYPE
, COUNTER_VALUE.MISC_READING
, COUNTER_VALUE.COUNTER_VALUE_ID
, CSM_UTIL_PKG.GET_NUMBER(COUNTERS.COUNTER_ID)
, CSM_UTIL_PKG.GET_DATE(COUNTER_VALUE.LAST_UPDATE_DATE)
, COUNTER_VALUE.SOURCE_TRANSACTION_CODE
, COUNTER_VALUE.SOURCE_TRANSACTION_ID
, COUNTER_VALUE.CONTEXT
, COUNTER_VALUE.ATTRIBUTE1
, COUNTER_VALUE.ATTRIBUTE2
, COUNTER_VALUE.ATTRIBUTE3
, COUNTER_VALUE.ATTRIBUTE4
, COUNTER_VALUE.ATTRIBUTE5
, COUNTER_VALUE.ATTRIBUTE6
, COUNTER_VALUE.ATTRIBUTE7
, COUNTER_VALUE.ATTRIBUTE8
, COUNTER_VALUE.ATTRIBUTE9
, COUNTER_VALUE.ATTRIBUTE10
, COUNTER_VALUE.ATTRIBUTE11
, COUNTER_VALUE.ATTRIBUTE12
, COUNTER_VALUE.ATTRIBUTE13
, COUNTER_VALUE.ATTRIBUTE14
, COUNTER_VALUE.ATTRIBUTE15
, CSM_UTIL_PKG.GET_NUMBER(CNTR_READING.NET_READING)
, CSM_UTIL_PKG.GET_NUMBER(CNTR_READING.LIFE_TO_DATE_READING)
, CNTR_READING.ADJUSTMENT_TYPE
, CNTR_READING.ADJUSTMENT_READING
, CNTR_READING.DISABLED_FLAG
, CNTR_READING.RESET_MODE
, CSM_UTIL_PKG.GET_NUMBER(CNTR_READING.OBJECT_VERSION_NUMBER)
, CNTR_READING.INCLUDE_TARGET_RESETS
, CNTR_READING.SOURCE_CODE
, CNTR_READING.SOURCE_LINE_ID
, CNTR_READING.COMMENTS
, CNTR_READING.AUTOMATIC_ROLLOVER_FLAG
, CNTR_READING.MIGRATED_FLAG
, CTR_READING_INT.RESET_COUNTER_READING
, CSM_UTIL_PKG.GET_NUMBER(COUNTER_VALUE.CREATED_BY) AS CREATED_BY
, CSM_UTIL_PKG.GET_NUMBER(COUNTER_VALUE.LAST_UPDATED_BY) AS LAST_UPDATED_BY
, CSM_UTIL_PKG.GET_DATE(COUNTER_VALUE.LAST_UPDATE_DATE) AS SERVER_LAST_UPDATE_DATE
FROM CSI_COUNTERS_B COUNTERS
, CSI_COUNTER_ASSOCIATIONS ASS
, CS_CTR_COUNTER_VALUES_V COUNTER_VALUE
, CSM_COUNTER_VALUES_ACC ACC
, CSI_COUNTER_READINGS CNTR_READING
, CSI_CTR_READINGS_INTERFACE CTR_READING_INT
WHERE ACC.COUNTER_VALUE_ID = COUNTER_VALUE.COUNTER_VALUE_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID
AND COUNTER_VALUE.COUNTER_ID = COUNTERS.COUNTER_ID
AND COUNTERS.COUNTER_ID = ASS.COUNTER_ID
AND ASS.SOURCE_OBJECT_CODE = 'CP'
AND COUNTERS.COUNTER_TYPE = 'REGULAR'
AND COUNTER_VALUE.COUNTER_ID = CNTR_READING.COUNTER_ID
AND COUNTER_VALUE.COUNTER_VALUE_ID = CNTR_READING.COUNTER_VALUE_ID
AND CTR_READING_INT.COUNTER_ID(+)= COUNTER_VALUE.COUNTER_ID
AND CTR_READING_INT.COUNTER_VALUE_ID (+)= COUNTER_VALUE.COUNTER_VALUE_ID