APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on CSI_COUNTER_ASSOCIATIONS

Line 2331: from csi_counter_associations cca, csi_counters_vl cc

2327: ORDER BY uom_code;
2328:
2329: SELECT cc.counter_id, cc.uom_code,
2330: cc.counter_template_name counter_name
2331: from csi_counter_associations cca, csi_counters_vl cc
2332: where cca.counter_id = cc.counter_id
2333: AND source_object_code = 'CP'
2334: AND source_object_id = p_csi_instance_id;
2335: */

Line 2346: FROM csi_counter_associations cca, csi_counters_vl cc

2342: where ccr.counter_id = cc.counter_id
2343: and value_timestamp = (select max(value_timestamp) from csi_counter_readings rd
2344: where counter_id = cc.counter_id
2345: and nvl(disabled_flag,'N') = 'N')) net_reading
2346: FROM csi_counter_associations cca, csi_counters_vl cc
2347: WHERE cca.counter_id = cc.counter_id
2348: AND source_object_code = 'CP'
2349: AND source_object_id = p_csi_item_instance_id;
2350: */

Line 2359: FROM csi_counter_associations cca, csi_counters_vl cc

2355: (select ccr.net_reading
2356: from csi_counter_readings ccr
2357: where ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
2358: and nvl(ccr.disabled_flag,'N') = 'N')
2359: FROM csi_counter_associations cca, csi_counters_vl cc
2360: WHERE cca.counter_id = cc.counter_id
2361: AND source_object_code = 'CP'
2362: AND source_object_id = p_csi_instance_id;
2363:

Line 2521: from csi_counter_associations cca, csi_counters_vl cc

2517: ORDER BY uom_code;
2518: */
2519: SELECT cc.counter_id, cc.uom_code,
2520: cc.counter_template_name counter_name
2521: from csi_counter_associations cca, csi_counters_vl cc
2522: where cca.counter_id = cc.counter_id
2523: AND source_object_code = 'CP'
2524: AND source_object_id = p_csi_instance_id;
2525:

Line 8147: from csi_counter_associations cca

8143: SELECT nvl(cv.net_reading,0) net_reading
8144: FROM csi_counter_values_v cv
8145: WHERE cv.counter_id = p_counter_id
8146: AND cv.counter_id IN (select counter_id
8147: from csi_counter_associations cca
8148: where source_object_code = 'CP'
8149: AND source_object_id = p_csi_item_instance_id
8150: AND cca.counter_id = cv.counter_id)
8151: AND rownum < 2;