DBA Data[Home] [Help]

APPS.AHL_COMPLETIONS_PVT dependencies on AHL_MR_INTERVALS_V

Line 2232: --FROM CSI_CP_COUNTERS_V CTR, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE

2228: CTR.DEFAULTED_GROUP_ID COUNTER_GROUP_ID,
2229: --NVL(CTR.net_reading, 0) net_reading,
2230: CTR.COUNTER_TYPE type,
2231: MRI.reset_value reset_value
2232: --FROM CSI_CP_COUNTERS_V CTR, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE
2233: FROM csi_counter_associations CCA, csi_counters_vl CTR, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE
2234: WHERE CCA.counter_id = CTR.counter_id
2235: AND CCA.source_object_id = c_item_instance_id
2236: AND CCA.source_object_code = 'CP'

Line 2233: FROM csi_counter_associations CCA, csi_counters_vl CTR, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE

2229: --NVL(CTR.net_reading, 0) net_reading,
2230: CTR.COUNTER_TYPE type,
2231: MRI.reset_value reset_value
2232: --FROM CSI_CP_COUNTERS_V CTR, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE
2233: FROM csi_counter_associations CCA, csi_counters_vl CTR, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE
2234: WHERE CCA.counter_id = CTR.counter_id
2235: AND CCA.source_object_id = c_item_instance_id
2236: AND CCA.source_object_code = 'CP'
2237: --AND CTR.counter_name = MRI.counter_name