[Home] [Help]
97: SELECT acc.user_id
98: FROM CSI_COUNTERS_B counters
99: , CS_CSI_COUNTER_GROUPS counter_groups
100: , csm_item_instances_acc acc
101: , CSI_COUNTER_ASSOCIATIONS ass
102: WHERE counters.counter_id = ass.counter_id
103: AND ass.source_object_code = 'CP'
104: AND counters.counter_type = 'REGULAR'
105: AND ass.source_object_id = acc.instance_id
213: IS
214: SELECT cval.counter_value_id
215: FROM CSI_COUNTERS_B cntrs,
216: CSI_COUNTER_READINGS cval,
217: CSI_COUNTER_ASSOCIATIONS cas,
218: csm_item_instances_acc acc
219: WHERE cntrs.counter_id = cas.counter_id
220: AND cas.source_object_code = 'CP'
221: AND cas.source_object_id = p_instance_id
356: SELECT acc.user_id
357: FROM CSI_COUNTERS_B ctr
358: , CS_CSI_COUNTER_GROUPS cgrp
359: , csm_item_instances_acc acc
360: , CSI_COUNTER_ASSOCIATIONS cas
361: WHERE ctr.counter_id = cas.counter_id
362: AND cas.source_object_code = 'CP'
363: AND ctr.counter_type = 'REGULAR'
364: AND cgrp.counter_group_id(+)= ctr.group_id
426: cval.counter_value_id,
427: ctr.counter_id,
428: acc.instance_id
429: FROM CSI_COUNTER_READINGS cval,
430: csi_counter_associations cas,
431: csi_counters_b ctr,
432: csm_counters_acc cnt_acc,
433: csm_item_instances_acc acc
434: WHERE cval.transaction_id = p_counter_grp_log_id
448: SELECT cval.counter_value_id,
449: cval.value_timestamp
450: FROM CSI_COUNTERS_B cntrs,
451: CSI_COUNTER_READINGS cval,
452: CSI_COUNTER_ASSOCIATIONS cas,
453: csm_item_instances_acc iacc,
454: csm_counters_acc acc
455: WHERE acc.user_id = p_user_id
456: AND acc.counter_id = p_counter_id
692: SELECT cval.value_timestamp,
693: cval.counter_value_id
694: FROM CSI_COUNTERS_B cntrs,
695: CSI_COUNTER_READINGS cval,
696: CSI_COUNTER_ASSOCIATIONS cas,
697: csm_counters_acc cnt_acc,
698: csm_item_instances_acc acc
699: WHERE cntrs.counter_id = cas.counter_id
700: AND cas.source_object_code = 'CP'