APPS.AHL_COMPLETIONS_PVT dependencies on CSI_COUNTERS_VL

Line 2084: FROM csi_counter_associations CCA, csi_counters_vl CTR

2080: --CTR.type type
2081: CTR.COUNTER_TYPE type
2082: --FROM CSI_CP_COUNTERS_V CTR
2083: --WHERE CTR.customer_product_id = c_item_instance_id
2084: FROM csi_counter_associations CCA, csi_counters_vl CTR
2085: WHERE CCA.counter_id = CTR.counter_id
2086: AND CCA.source_object_id = c_item_instance_id
2087: AND CCA.source_object_code = 'CP'
2088: ORDER BY CTR.counter_id;

Line 2121: CSI_COUNTERS_VL CC,

2117: SELECT
2118: nvl(CCR.NET_READING,0) net_reading,
2119: ccr.counter_value_id
2120: FROM
2121: CSI_COUNTERS_VL CC,
2122: CSI_COUNTER_READINGS CCR
2123: WHERE
2124: CCR.COUNTER_ID = CC.COUNTER_ID
2125: AND CC.COUNTER_ID = c_counter_id

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

Line 2253: CSI_COUNTERS_VL CC,

2249: /*
2250: SELECT
2251: nvl(CCR.NET_READING,0) net_reading
2252: FROM
2253: CSI_COUNTERS_VL CC,
2254: CSI_COUNTER_READINGS CCR
2255: WHERE
2256: CCR.COUNTER_ID = CC.COUNTER_ID
2257: AND CC.COUNTER_ID = c_counter_id

Line 2285: CSI_COUNTERS_VL CC,

2281: /*
2282: SELECT
2283: nvl(CCR.NET_READING,0) net_reading
2284: FROM
2285: CSI_COUNTERS_VL CC,
2286: CSI_COUNTER_READINGS CCR
2287: WHERE
2288: CCR.COUNTER_ID = CC.COUNTER_ID
2289: AND CC.COUNTER_ID = c_counter_id