eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_COUNTER_EVENT_PKG dependencies on CSM_ITEM_INSTANCES_ACC

Line 100: , csm_item_instances_acc acc

96: IS
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'

Line 218: csm_item_instances_acc acc

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
222: AND cntrs.counter_id = cval.counter_id

Line 359: , csm_item_instances_acc acc

355: IS
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'

Line 433: csm_item_instances_acc acc

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
435: AND cas.source_object_code = 'CP'
436: AND ctr.counter_id = cas.counter_id
437: AND acc.instance_id = cas.source_object_id

Line 453: csm_item_instances_acc iacc,

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
457: AND iacc.user_id = acc.user_id

Line 698: csm_item_instances_acc acc

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'
701: AND cas.source_object_id = p_instance_id
702: AND cntrs.counter_id = cval.counter_id