DBA Data[Home] [Help]

APPS.CSI_COUNTER_READINGS_PVT dependencies on CSI_COUNTERS_TL

Line 1974: CSI_COUNTERS_TL cct

1970: select 'Y'
1971: into l_target_ctr_exist
1972: from CSI_COUNTER_RELATIONSHIPS ccr,
1973: CSI_COUNTERS_B ccv,
1974: CSI_COUNTERS_TL cct
1975: where ccr.source_counter_id = p_ctr_rdg_rec.counter_id
1976: and ccr.relationship_type_code = 'CONFIGURATION'
1977: and nvl(ccr.active_start_date,sysdate) <= p_ctr_rdg_rec.value_timestamp
1978: and nvl(ccr.active_end_date,(sysdate+1)) > p_ctr_rdg_rec.value_timestamp

Line 3531: CSI_COUNTERS_TL cct

3527: ccv.direction,ccv.reading_type, ccv.uom_code object_uom_code,
3528: cct.name object_counter_name
3529: from CSI_COUNTER_RELATIONSHIPS ccr,
3530: CSI_COUNTERS_B ccv,
3531: CSI_COUNTERS_TL cct
3532: where ccr.source_counter_id = p_ctr_rdg_rec.counter_id
3533: and ccr.relationship_type_code = l_rel_type
3534: and nvl(ccr.active_start_date,sysdate) <= p_ctr_rdg_rec.value_timestamp
3535: and nvl(ccr.active_end_date,(sysdate+1)) > p_ctr_rdg_rec.value_timestamp

Line 3548: CSI_COUNTERS_TL cct

3544: ccv.uom_code object_uom_code, cct.name object_counter_name
3545: from CSI_COUNTER_READINGS crg,
3546: CSI_COUNTER_RELATIONSHIPS ccr,
3547: CSI_COUNTERS_B ccv,
3548: CSI_COUNTERS_TL cct
3549: where crg.source_counter_value_id = p_ctr_rdg_rec.counter_value_id
3550: and ccr.object_counter_id = crg.counter_id
3551: and ccr.source_counter_id = p_ctr_rdg_rec.counter_id
3552: and ccr.relationship_type_code = l_rel_type