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_PVT dependencies on CSI_COUNTERS_B

Line 58: FROM csi_counters_b

54: --Modified function for bug 7563117
55: BEGIN
56: SELECT ctr_val_max_seq_no
57: INTO l_counter_value_id
58: FROM csi_counters_b
59: WHERE counter_id = p_counter_id
60: AND EXISTS(SELECT 'Y' FROM csi_counter_readings WHERE counter_value_id=ctr_val_max_seq_no);
61: EXCEPTION
62: WHEN NO_DATA_FOUND THEN

Line 426: CSI_COUNTERS_B ccv

422: CURSOR OBJECT_CTR_CUR IS
423: select ccr.object_counter_id,nvl(ccr.factor,1) factor,
424: ccv.direction,ccv.reading_type, ccv.uom_code object_uom_code
425: from CSI_COUNTER_RELATIONSHIPS ccr,
426: CSI_COUNTERS_B ccv
427: where ccr.source_counter_id = p_ctr_rdg_rec.counter_id
428: and ccr.relationship_type_code =l_rel_type
429: and nvl(ccr.active_start_date,sysdate) <= p_ctr_rdg_rec.value_timestamp
430: and nvl(ccr.active_end_date,(sysdate+1)) > p_ctr_rdg_rec.value_timestamp

Line 522: FROM CSI_COUNTERS_B WHERE COUNTER_ID = obj_cur.object_counter_id;

518: -- Get the last reading for this counter
519: -- Bug 8214848
520: BEGIN
521: SELECT CTR_VAL_MAX_SEQ_NO INTO l_ctr_val_max
522: FROM CSI_COUNTERS_B WHERE COUNTER_ID = obj_cur.object_counter_id;
523:
524: SELECT COUNTER_READING,NET_READING,LIFE_TO_DATE_READING
525: INTO l_prev_ctr_max_reading,
526: l_prev_net_max_reading,

Line 627: FROM csi_counters_b

623: /* Check reset factor */
624: BEGIN
625: SELECT uom_code, direction, reading_type
626: INTO l_source_uom_code, l_source_direction, l_src_reading_type
627: FROM csi_counters_b
628: WHERE counter_id = p_ctr_rdg_rec.counter_id;
629: EXCEPTION
630: WHEN OTHERS THEN
631: NULL;

Line 1181: CSI_COUNTERS_B ccv,

1177: select ccr.object_counter_id,nvl(ccr.factor,1) factor,
1178: ccv.direction,ccv.reading_type, ccv.uom_code object_uom_code,
1179: cct.name object_counter_name
1180: from CSI_COUNTER_RELATIONSHIPS ccr,
1181: CSI_COUNTERS_B ccv,
1182: CSI_COUNTERS_TL cct
1183: where ccr.source_counter_id = p_ctr_rdg_rec.counter_id
1184: and ccr.relationship_type_code = 'CONFIGURATION'
1185: and nvl(ccr.active_start_date,sysdate) <= p_ctr_rdg_rec.value_timestamp

Line 1676: FROM CSI_COUNTERS_B WHERE COUNTER_ID = p_ctr_rdg_rec.counter_id;

1672: -- Get the last reading for this counter
1673: -- Bug 8214848
1674: BEGIN
1675: SELECT CTR_VAL_MAX_SEQ_NO INTO l_ctr_val_max
1676: FROM CSI_COUNTERS_B WHERE COUNTER_ID = p_ctr_rdg_rec.counter_id;
1677:
1678: SELECT COUNTER_READING,NET_READING,LIFE_TO_DATE_READING,
1679: VALUE_TIMESTAMP
1680: INTO l_prev_ctr_max_reading,

Line 2334: CSI_COUNTERS_B ccv,

2330: BEGIN
2331: select 'Y'
2332: into l_target_ctr_exist
2333: from CSI_COUNTER_RELATIONSHIPS ccr,
2334: CSI_COUNTERS_B ccv,
2335: CSI_COUNTERS_TL cct
2336: where ccr.source_counter_id = p_ctr_rdg_rec.counter_id
2337: and ccr.relationship_type_code = 'CONFIGURATION'
2338: and nvl(ccr.active_start_date,sysdate) <= p_ctr_rdg_rec.value_timestamp

Line 2962: l_formula_text CSI_COUNTERS_B.formula_text%TYPE;

2958: l_msg_data VARCHAR2(2000);
2959: l_msg_index NUMBER;
2960: l_msg_count NUMBER;
2961: l_rel_type VARCHAR2(30) := 'FORMULA';
2962: l_formula_text CSI_COUNTERS_B.formula_text%TYPE;
2963: l_cursor_handle INTEGER; --Dynamic SQL cursor handler
2964: l_n_temp INTEGER;
2965: l_counter_reading NUMBER;
2966: l_bind_var_value NUMBER;

Line 3087: from CSI_COUNTERS_B -- Need to be changed

3083: l_formula_text := NULL;
3084: Begin
3085: select formula_text
3086: into l_formula_text
3087: from CSI_COUNTERS_B -- Need to be changed
3088: where counter_id = obj_cur.object_counter_id
3089: and nvl(end_date_active,(sysdate+1)) > sysdate;
3090: Exception
3091: when no_data_found then

Line 3155: FROM CSI_COUNTERS_B WHERE COUNTER_ID = sub_cur.source_counter_id;

3151: CLOSE GET_NET_RDG_CUR;
3152: */
3153: BEGIN
3154: SELECT CTR_VAL_MAX_SEQ_NO INTO l_ctr_val_max
3155: FROM CSI_COUNTERS_B WHERE COUNTER_ID = sub_cur.source_counter_id;
3156: SELECT NET_READING, VALUE_TIMESTAMP
3157: INTO l_net_max_reading,
3158: l_value_max_timestamp
3159: FROM CSI_COUNTER_READINGS WHERE COUNTER_VALUE_ID = NVL(l_ctr_val_max,-1);

Line 3424: FROM CSI_COUNTERS_B WHERE COUNTER_ID = l_src_ctr_tbl(src_rec).source_counter_id;

3420: FETCH GET_NET_RDG_CUR INTO l_bind_var_value;
3421: CLOSE GET_NET_RDG_CUR;*/
3422: BEGIN
3423: SELECT CTR_VAL_MAX_SEQ_NO INTO l_ctr_val_max
3424: FROM CSI_COUNTERS_B WHERE COUNTER_ID = l_src_ctr_tbl(src_rec).source_counter_id;
3425: SELECT NET_READING, VALUE_TIMESTAMP
3426: INTO l_net_max_reading,
3427: l_value_max_timestamp
3428: FROM CSI_COUNTER_READINGS WHERE COUNTER_VALUE_ID = NVL(l_ctr_val_max,-1);

Line 3550: FROM csi_counters_b

3546: derive_property_id,
3547: filter_reading_count,
3548: filter_type,
3549: filter_time_uom
3550: FROM csi_counters_b
3551: WHERE derive_counter_id = base_ctr_id
3552: AND NVL(start_date_active, base_ctr_timestamp) <= base_ctr_timestamp
3553: AND NVL(end_date_active, (base_ctr_timestamp + 1)) > base_ctr_timestamp;
3554: /*

Line 3559: FROM CSI_COUNTERS_B ctr, CSI_COUNTER_READINGS cv

3555: CURSOR CTRS_TO_BE_CALC IS
3556: SELECT ctr.counter_id, ctr.derive_function,
3557: ctr.derive_counter_id, ctr.derive_property_id,ctr.filter_reading_count,ctr.filter_type,
3558: ctr.filter_time_uom, cv.value_timestamp as new_rdg_dt, cv.counter_id as base_ctr_id
3559: FROM CSI_COUNTERS_B ctr, CSI_COUNTER_READINGS cv
3560: WHERE cv.counter_value_id = p_ctr_rdg_rec.counter_value_id
3561: AND ctr.derive_counter_id = cv.counter_id
3562: AND NVL(ctr.start_date_active,cv.value_timestamp) <= cv.value_timestamp
3563: AND NVL(ctr.end_date_active,(cv.value_timestamp+1)) > cv.value_timestamp;

Line 4068: CSI_COUNTERS_B ccv,

4064: select ccr.object_counter_id,nvl(ccr.factor,1) factor,
4065: ccv.direction,ccv.reading_type, ccv.uom_code object_uom_code,
4066: cct.name object_counter_name
4067: from CSI_COUNTER_RELATIONSHIPS ccr,
4068: CSI_COUNTERS_B ccv,
4069: CSI_COUNTERS_TL cct
4070: where ccr.source_counter_id = p_ctr_rdg_rec.counter_id
4071: and ccr.relationship_type_code = l_rel_type
4072: and nvl(ccr.active_start_date,sysdate) <= p_ctr_rdg_rec.value_timestamp

Line 4085: CSI_COUNTERS_B ccv,

4081: ccv.direction,ccv.reading_type,crg.reset_mode,
4082: ccv.uom_code object_uom_code, cct.name object_counter_name
4083: from CSI_COUNTER_READINGS crg,
4084: CSI_COUNTER_RELATIONSHIPS ccr,
4085: CSI_COUNTERS_B ccv,
4086: CSI_COUNTERS_TL cct
4087: where crg.source_counter_value_id = p_ctr_rdg_rec.counter_value_id
4088: and ccr.object_counter_id = crg.counter_id
4089: and ccr.source_counter_id = p_ctr_rdg_rec.counter_id

Line 4196: FROM csi_counters_b

4192: --
4193: BEGIN
4194: SELECT uom_code, direction, reading_type
4195: INTO l_source_uom_code, l_source_direction, l_src_reading_type
4196: FROM csi_counters_b
4197: WHERE counter_id = p_ctr_rdg_rec.counter_id;
4198: EXCEPTION
4199: WHEN OTHERS THEN
4200: NULL;

Line 4269: FROM CSI_COUNTERS_B WHERE COUNTER_ID = obj_cur.object_counter_id;

4265: -- Get the last reading for this counter
4266: -- Bug 8214848
4267: BEGIN
4268: SELECT CTR_VAL_MAX_SEQ_NO INTO l_ctr_val_max
4269: FROM CSI_COUNTERS_B WHERE COUNTER_ID = obj_cur.object_counter_id;
4270:
4271: SELECT COUNTER_READING,NET_READING,LIFE_TO_DATE_READING,
4272: VALUE_TIMESTAMP
4273: INTO l_prev_ctr_max_reading,

Line 4467: FROM csi_counters_b

4463: --
4464: BEGIN
4465: SELECT uom_code, direction, reading_type
4466: INTO l_source_uom_code, l_source_direction, l_src_reading_type
4467: FROM csi_counters_b
4468: WHERE counter_id = p_ctr_rdg_rec.counter_id;
4469: EXCEPTION
4470: WHEN OTHERS THEN
4471: NULL;

Line 4553: FROM CSI_COUNTERS_B WHERE COUNTER_ID = obj_cur.object_counter_id;

4549: -- Get the last reading for this counter
4550: -- Bug 8214848
4551: BEGIN
4552: SELECT CTR_VAL_MAX_SEQ_NO INTO l_ctr_val_max
4553: FROM CSI_COUNTERS_B WHERE COUNTER_ID = obj_cur.object_counter_id;
4554:
4555: SELECT COUNTER_READING,NET_READING,LIFE_TO_DATE_READING,
4556: VALUE_TIMESTAMP
4557: INTO l_prev_ctr_max_reading,

Line 5403: FROM CSI_COUNTERS_B WHERE COUNTER_ID = l_curr_ctr_rdg_rec.counter_id;

5399: -- Get the last reading for this counter
5400: -- Bug 8214848
5401: BEGIN
5402: SELECT CTR_VAL_MAX_SEQ_NO INTO l_ctr_val_max
5403: FROM CSI_COUNTERS_B WHERE COUNTER_ID = l_curr_ctr_rdg_rec.counter_id;
5404:
5405: SELECT COUNTER_READING,NET_READING,LIFE_TO_DATE_READING,
5406: VALUE_TIMESTAMP
5407: INTO l_prev_ctr_max_reading,

Line 6383: from CSI_COUNTERS_B

6379: l_first_rdg_date DATE;
6380: --
6381: CURSOR CTR_START_DATE(b_counter_id NUMBER) IS
6382: select nvl(start_date_active,creation_date) "ctr_start_date"
6383: from CSI_COUNTERS_B
6384: where counter_id = b_counter_id;
6385:
6386: CURSOR CTR_DIRECTION(b_counter_id NUMBER) IS
6387: select direction

Line 6388: from CSI_COUNTERS_B

6384: where counter_id = b_counter_id;
6385:
6386: CURSOR CTR_DIRECTION(b_counter_id NUMBER) IS
6387: select direction
6388: from CSI_COUNTERS_B
6389: where counter_id = b_counter_id;
6390: --
6391: l_ctr_direction VARCHAR2(1);
6392: --

Line 6591: from CSI_COUNTERS_B

6587: l_first_rdg_date DATE;
6588:
6589: CURSOR ctr_start_date(b_counter_id NUMBER) IS
6590: select nvl(start_date_active,creation_date) "ctr_start_date"
6591: from CSI_COUNTERS_B
6592: where counter_id = b_counter_id;
6593:
6594: CURSOR CTR_DIRECTION(b_counter_id NUMBER) IS
6595: select direction

Line 6596: from CSI_COUNTERS_B

6592: where counter_id = b_counter_id;
6593:
6594: CURSOR CTR_DIRECTION(b_counter_id NUMBER) IS
6595: select direction
6596: from CSI_COUNTERS_B
6597: where counter_id = b_counter_id;
6598:
6599: l_ctr_direction VARCHAR2(1);
6600:

Line 6874: from CSI_COUNTERS_B

6870: l_first_rdg_date DATE;
6871:
6872: CURSOR ctr_start_date(b_counter_id NUMBER) IS
6873: select nvl(start_date_active,creation_date) "ctr_start_date"
6874: from CSI_COUNTERS_B
6875: where counter_id = b_counter_id;
6876: --
6877: CURSOR CTR_DIRECTION(b_counter_id NUMBER) IS
6878: select direction

Line 6879: from CSI_COUNTERS_B

6875: where counter_id = b_counter_id;
6876: --
6877: CURSOR CTR_DIRECTION(b_counter_id NUMBER) IS
6878: select direction
6879: from CSI_COUNTERS_B
6880: where counter_id = b_counter_id;
6881: --
6882: l_ctr_direction VARCHAR2(1);
6883: --

Line 7287: from CSI_COUNTERS_B

7283: l_process_flag BOOLEAN := TRUE;
7284: --
7285: CURSOR CTREST_REC IS
7286: select group_id counter_group_id,estimation_id
7287: from CSI_COUNTERS_B
7288: where counter_id = p_counter_id;
7289: --
7290: l_counter_group_id NUMBER;
7291: l_estimation_id NUMBER;

Line 7303: from CSI_COUNTERS_B -- Need to change

7299: l_est_rec est_rec%rowtype;
7300: --
7301: CURSOR REF_COUNTER(b_counter_group_id NUMBER,b_counter_id NUMBER) IS
7302: select counter_id
7303: from CSI_COUNTERS_B -- Need to change
7304: where group_id = b_counter_group_id
7305: and created_from_counter_tmpl_id =b_counter_id;
7306: --
7307: l_ref_counter_id NUMBER;

Line 7397: from CSI_COUNTERS_B

7393: END IF;
7394: --
7395: BEGIN
7396: select 'X' into l_dummy
7397: from CSI_COUNTERS_B
7398: where counter_id = p_Counter_id;
7399: EXCEPTION
7400: when no_data_found then
7401: csi_ctr_gen_utility_pvt.ExitWithErrMsg