APPS.AHL_COMPLETIONS_PVT dependencies on CSI_COUNTERS_VL

Line 2006: FROM csi_counter_associations CCA, csi_counters_vl CTR

2002: --CTR.type type
2003: CTR.COUNTER_TYPE type
2004: --FROM CSI_CP_COUNTERS_V CTR
2005: --WHERE CTR.customer_product_id = c_item_instance_id
2006: FROM csi_counter_associations CCA, csi_counters_vl CTR
2007: WHERE CCA.counter_id = CTR.counter_id
2008: AND CCA.source_object_id = c_item_instance_id
2009: AND CCA.source_object_code = 'CP'
2010: ORDER BY CTR.counter_id;

Line 2043: CSI_COUNTERS_VL CC,

2039: SELECT
2040: nvl(CCR.NET_READING,0) net_reading,
2041: ccr.counter_value_id
2042: FROM
2043: CSI_COUNTERS_VL CC,
2044: CSI_COUNTER_READINGS CCR
2045: WHERE
2046: CCR.COUNTER_ID = CC.COUNTER_ID
2047: AND CC.COUNTER_ID = c_counter_id

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

Line 2175: CSI_COUNTERS_VL CC,

2171: /*
2172: SELECT
2173: nvl(CCR.NET_READING,0) net_reading
2174: FROM
2175: CSI_COUNTERS_VL CC,
2176: CSI_COUNTER_READINGS CCR
2177: WHERE
2178: CCR.COUNTER_ID = CC.COUNTER_ID
2179: AND CC.COUNTER_ID = c_counter_id

Line 2207: CSI_COUNTERS_VL CC,

2203: /*
2204: SELECT
2205: nvl(CCR.NET_READING,0) net_reading
2206: FROM
2207: CSI_COUNTERS_VL CC,
2208: CSI_COUNTER_READINGS CCR
2209: WHERE
2210: CCR.COUNTER_ID = CC.COUNTER_ID
2211: AND CC.COUNTER_ID = c_counter_id