APPS.CSI_COUNTER_READINGS_PVT dependencies on CSI_COUNTER_RELATIONSHIPS

Line 157: from CSI_COUNTER_RELATIONSHIPS

153: select '1'
154: into l_exists
155: from dual
156: where exists (select 'x'
157: from CSI_COUNTER_RELATIONSHIPS
158: where object_counter_id = p_counter_id
159: and relationship_type_code = l_rel_type);
160: l_return_value := TRUE;
161: Exception

Line 180: from CSI_COUNTER_RELATIONSHIPS

176: select '1'
177: into l_exists
178: from dual
179: where exists (select 'x'
180: from CSI_COUNTER_RELATIONSHIPS
181: where object_counter_id = p_counter_id
182: and relationship_type_code = l_rel_type
183: and nvl(active_end_date,(sysdate+1)) > sysdate);
184: l_return_value := TRUE;

Line 425: from CSI_COUNTER_RELATIONSHIPS ccr,

421: --
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

Line 1180: from CSI_COUNTER_RELATIONSHIPS ccr,

1176: CURSOR OBJECT_CTR_CUR IS
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'

Line 1648: CSI_COUNTER_RELATIONSHIPS WHERE SOURCE_COUNTER_ID = p_ctr_rdg_rec.counter_id AND

1644: SELECT MAX(READING_LOCK_DATE)
1645: INTO l_rdg_lock_date
1646: FROM CSI_COUNTER_READING_LOCKS
1647: WHERE COUNTER_ID IN (SELECT OBJECT_COUNTER_ID FROM
1648: CSI_COUNTER_RELATIONSHIPS WHERE SOURCE_COUNTER_ID = p_ctr_rdg_rec.counter_id AND
1649: NVL(ACTIVE_END_DATE,(p_ctr_rdg_rec.value_timestamp + 1)) > p_ctr_rdg_rec.value_timestamp
1650: UNION ALL SELECT p_ctr_rdg_rec.counter_id FROM DUAL);
1651: End;
1652: --

Line 2333: from CSI_COUNTER_RELATIONSHIPS ccr,

2329: --
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'

Line 2996: from csi_counter_relationships

2992: l_tmp_ctr_value_id NUMBER;
2993: --
2994: CURSOR OBJECT_CTR_CUR(p_src_ctr_id IN NUMBER) IS
2995: select distinct object_counter_id
2996: from csi_counter_relationships
2997: where source_counter_id = p_src_ctr_id
2998: and relationship_type_code = l_rel_type
2999: and nvl(active_end_date,(sysdate+1)) > sysdate;
3000: --

Line 3003: from csi_counter_relationships

2999: and nvl(active_end_date,(sysdate+1)) > sysdate;
3000: --
3001: CURSOR SOURCE_CTR_CUR(p_obj_ctr_id IN NUMBER) IS
3002: select source_counter_id,bind_variable_name
3003: from csi_counter_relationships
3004: where object_counter_id = p_obj_ctr_id
3005: and relationship_type_code = l_rel_type
3006: and nvl(active_end_date,(sysdate+1)) > sysdate;
3007: --

Line 4067: from CSI_COUNTER_RELATIONSHIPS ccr,

4063: CURSOR OBJECT_CTR_CUR IS
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

Line 4084: CSI_COUNTER_RELATIONSHIPS ccr,

4080: crg.adjustment_reading,crg.counter_reading,nvl(ccr.factor,1) factor,
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

Line 5377: CSI_COUNTER_RELATIONSHIPS WHERE SOURCE_COUNTER_ID = l_curr_ctr_rdg_rec.counter_id AND

5373: SELECT MAX(READING_LOCK_DATE)
5374: INTO l_rdg_lock_date
5375: FROM CSI_COUNTER_READING_LOCKS
5376: WHERE COUNTER_ID IN (SELECT OBJECT_COUNTER_ID FROM
5377: CSI_COUNTER_RELATIONSHIPS WHERE SOURCE_COUNTER_ID = l_curr_ctr_rdg_rec.counter_id AND
5378: NVL(ACTIVE_END_DATE,(l_curr_ctr_rdg_rec.value_timestamp + 1)) > l_curr_ctr_rdg_rec.value_timestamp
5379: UNION ALL SELECT l_curr_ctr_rdg_rec.counter_id FROM DUAL);
5380: End;
5381: --