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.CSI_COUNTER_READINGS_PUB dependencies on CSI_COUNTERS_B

Line 77: CSI_COUNTERS_B ccv

73: --
74: CURSOR TARGET_CUR(p_src_ctr_id IN NUMBER,p_value_timestamp IN DATE) IS
75: select ccr.object_counter_id
76: from CSI_COUNTER_RELATIONSHIPS ccr,
77: CSI_COUNTERS_B ccv
78: where ccr.source_counter_id = p_src_ctr_id
79: and ccr.relationship_type_code = l_target_rel_type
80: and nvl(ccr.active_start_date,sysdate) <= p_value_timestamp
81: and nvl(ccr.active_end_date,(sysdate+1)) > p_value_timestamp

Line 88: CSI_COUNTERS_B ccv

84: CURSOR UPD_TARGET_CUR(p_ctr_value_id IN NUMBER,p_src_ctr_id IN NUMBER) IS
85: SELECT crg.counter_id
86: from CSI_COUNTER_READINGS crg,
87: CSI_COUNTER_RELATIONSHIPS ccr,
88: CSI_COUNTERS_B ccv
89: where crg.source_counter_value_id = p_ctr_value_id
90: and ccr.object_counter_id = crg.counter_id
91: and ccr.source_counter_id = p_src_ctr_id
92: and ccr.relationship_type_code = l_target_rel_type

Line 97: FROM CSI_COUNTERS_B ctr, CSI_COUNTER_READINGS cv

93: and ccv.counter_id = crg.counter_id;
94: --
95: CURSOR DERIVE_CUR(p_ctr_value_id IN NUMBER) IS
96: SELECT ctr.counter_id
97: FROM CSI_COUNTERS_B ctr, CSI_COUNTER_READINGS cv
98: WHERE cv.counter_value_id = p_ctr_value_id
99: AND ctr.derive_counter_id = cv.counter_id
100: AND NVL(ctr.start_date_active,sysdate) <= cv.value_timestamp
101: AND NVL(ctr.end_date_active,(sysdate+1)) > cv.value_timestamp;

Line 792: CSI_COUNTERS_B ccv

788: --
789: CURSOR TARGET_CUR(p_src_ctr_id IN NUMBER,p_value_timestamp IN DATE) IS
790: select ccr.object_counter_id
791: from CSI_COUNTER_RELATIONSHIPS ccr,
792: CSI_COUNTERS_B ccv
793: where ccr.source_counter_id = p_src_ctr_id
794: and ccr.relationship_type_code = l_target_rel_type
795: and nvl(ccr.active_start_date,sysdate) <= p_value_timestamp
796: and nvl(ccr.active_end_date,(sysdate+1)) > p_value_timestamp

Line 803: CSI_COUNTERS_B ccv

799: CURSOR UPD_TARGET_CUR(p_ctr_value_id IN NUMBER,p_src_ctr_id IN NUMBER) IS
800: SELECT crg.counter_id
801: from CSI_COUNTER_READINGS crg,
802: CSI_COUNTER_RELATIONSHIPS ccr,
803: CSI_COUNTERS_B ccv
804: where crg.source_counter_value_id = p_ctr_value_id
805: and ccr.object_counter_id = crg.counter_id
806: and ccr.source_counter_id = p_src_ctr_id
807: and ccr.relationship_type_code = l_target_rel_type

Line 812: FROM CSI_COUNTERS_B ctr, CSI_COUNTER_READINGS cv

808: and ccv.counter_id = crg.counter_id;
809: --
810: CURSOR DERIVE_CUR(p_ctr_value_id IN NUMBER) IS
811: SELECT ctr.counter_id
812: FROM CSI_COUNTERS_B ctr, CSI_COUNTER_READINGS cv
813: WHERE cv.counter_value_id = p_ctr_value_id
814: AND ctr.derive_counter_id = cv.counter_id
815: AND NVL(ctr.start_date_active,sysdate) <= cv.value_timestamp
816: AND NVL(ctr.end_date_active,(sysdate+1)) > cv.value_timestamp;