APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on CSI_COUNTER_ASSOCIATIONS

Line 2960: from csi_counter_associations cca, csi_counters_vl cc

2956: ORDER BY uom_code;
2957:
2958: SELECT cc.counter_id, cc.uom_code,
2959: cc.counter_template_name counter_name
2960: from csi_counter_associations cca, csi_counters_vl cc
2961: where cca.counter_id = cc.counter_id
2962: AND source_object_code = 'CP'
2963: AND source_object_id = p_csi_instance_id;
2964: */

Line 2975: FROM csi_counter_associations cca, csi_counters_vl cc

2971: where ccr.counter_id = cc.counter_id
2972: and value_timestamp = (select max(value_timestamp) from csi_counter_readings rd
2973: where counter_id = cc.counter_id
2974: and nvl(disabled_flag,'N') = 'N')) net_reading
2975: FROM csi_counter_associations cca, csi_counters_vl cc
2976: WHERE cca.counter_id = cc.counter_id
2977: AND source_object_code = 'CP'
2978: AND source_object_id = p_csi_item_instance_id;
2979: */

Line 2988: FROM csi_counter_associations cca, csi_counters_vl cc

2984: (select ccr.net_reading
2985: from csi_counter_readings ccr
2986: where ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
2987: and nvl(ccr.disabled_flag,'N') = 'N')
2988: FROM csi_counter_associations cca, csi_counters_vl cc
2989: WHERE cca.counter_id = cc.counter_id
2990: AND source_object_code = 'CP'
2991: AND source_object_id = p_csi_instance_id;
2992:

Line 3153: from csi_counter_associations cca, csi_counters_vl cc

3149: ORDER BY uom_code;
3150: */
3151: SELECT cc.counter_id, cc.uom_code,
3152: cc.counter_template_name counter_name
3153: from csi_counter_associations cca, csi_counters_vl cc
3154: where cca.counter_id = cc.counter_id
3155: AND source_object_code = 'CP'
3156: AND source_object_id = p_csi_instance_id;
3157:

Line 9627: from csi_counter_associations cca

9623: SELECT nvl(cv.net_reading,0) net_reading
9624: FROM csi_counter_values_v cv
9625: WHERE cv.counter_id = p_counter_id
9626: AND cv.counter_id IN (select counter_id
9627: from csi_counter_associations cca
9628: where source_object_code = 'CP'
9629: AND source_object_id = p_csi_item_instance_id
9630: AND cca.counter_id = cv.counter_id)
9631: AND rownum < 2;

Line 15976: from csi_counter_associations cca, csi_counters_vl cc

15972: -- Get instance counter details.
15973: CURSOR csi_cp_counters_csr (p_csi_instance_id IN NUMBER) IS
15974: SELECT cc.counter_id, cc.uom_code,
15975: cc.counter_template_name counter_name
15976: from csi_counter_associations cca, csi_counters_vl cc
15977: where cca.counter_id = cc.counter_id
15978: AND source_object_code = 'CP'
15979: AND source_object_id = p_csi_instance_id;
15980: