DBA Data[Home] [Help]

APPS.AHL_COMPLETIONS_PVT dependencies on AHL_MR_EFFECTIVITIES

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

2150: CTR.DEFAULTED_GROUP_ID COUNTER_GROUP_ID,
2151: --NVL(CTR.net_reading, 0) net_reading,
2152: CTR.COUNTER_TYPE type,
2153: MRI.reset_value reset_value
2154: --FROM CSI_CP_COUNTERS_V CTR, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE
2155: FROM csi_counter_associations CCA, csi_counters_vl CTR, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE
2156: WHERE CCA.counter_id = CTR.counter_id
2157: AND CCA.source_object_id = c_item_instance_id
2158: AND CCA.source_object_code = 'CP'

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

2151: --NVL(CTR.net_reading, 0) net_reading,
2152: CTR.COUNTER_TYPE type,
2153: MRI.reset_value reset_value
2154: --FROM CSI_CP_COUNTERS_V CTR, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE
2155: FROM csi_counter_associations CCA, csi_counters_vl CTR, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE
2156: WHERE CCA.counter_id = CTR.counter_id
2157: AND CCA.source_object_id = c_item_instance_id
2158: AND CCA.source_object_code = 'CP'
2159: --AND CTR.counter_name = MRI.counter_name