DBA Data[Home] [Help]

APPS.AHL_COMPLETIONS_PVT dependencies on CSI_COUNTER_ASSOCIATIONS

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 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