APPS.AHL_UC_UTILIZATION_PVT dependencies on CSI_CP_COUNTERS_V

Line 941: FROM csi_cp_counters_v

937: CURSOR get_current_value_id(c_counter_id NUMBER) IS
938: SELECT nvl(counter_reading,0) counter_reading,
939: counter_group_id,
940: uom_code
941: FROM csi_cp_counters_v
942: WHERE counter_id = c_counter_id;
943: ***/
944: -- Get current counter reading values based on the counter_name
945: -- Cursor changed by jaramana on 03-DEC-2008 for bug 7426643 (FP of 7263702)

Line 946: -- Removed the use of csi_cp_counters_v and uptook

942: WHERE counter_id = c_counter_id;
943: ***/
944: -- Get current counter reading values based on the counter_name
945: -- Cursor changed by jaramana on 03-DEC-2008 for bug 7426643 (FP of 7263702)
946: -- Removed the use of csi_cp_counters_v and uptook
947: -- changes made via Counters bug 7561677 (FP of 7374316)
948: CURSOR get_current_value_name(c_instance_id NUMBER,
949: c_counter_name VARCHAR2) IS
950: -- SATHAPLI::Bug 8765956, 07-Aug-2009, re-introducing NVL usage.

Line 1197: -- Removed the use of csi_cp_counters_v

1193: TYPE instance_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1194: /** Begin changes by jaramana on October 29, 2007 for bug 6513576
1195: Cannot use cs_counters and cs_counter_groups anymore **/
1196: -- Cursor changed by jaramana on 03-DEC-2008 for bug 7426643 (FP of 7263702)
1197: -- Removed the use of csi_cp_counters_v
1198: CURSOR get_components_counter(c_instance_id NUMBER, c_counter_name VARCHAR2) IS
1199: SELECT CI.subject_id
1200: FROM csi_ii_relationships CI
1201: WHERE EXISTS (SELECT 'X'

Line 1213: FROM CSI_CP_COUNTERS_V CCCV

1209: AND trunc(nvl(CC.start_date_active,sysdate)) <= trunc(sysdate)
1210: AND trunc(nvl(CC.end_date_active,sysdate+1)) > trunc(sysdate))
1211: */
1212: /*
1213: FROM CSI_CP_COUNTERS_V CCCV
1214: WHERE CCCV.CUSTOMER_PRODUCT_ID = CI.subject_id
1215: AND CCCV.COUNTER_TEMPLATE_NAME = c_counter_name
1216: AND trunc(nvl(CCCV.start_date_active, sysdate)) <= trunc(sysdate)
1217: AND trunc(nvl(CCCV.end_date_active, sysdate+1)) > trunc(sysdate))

Line 1265: FROM CSI_CP_COUNTERS_V CCCV

1261: AND trunc(sysdate) >= trunc(nvl(ctr.start_date_active,sysdate))
1262: AND trunc(sysdate) <= trunc(nvl(ctr.end_date_active,sysdate+1));
1263: */
1264: SELECT CCCV.COUNTER_TEMPLATE_NAME counter_name, CCCV.counter_id, CCCV.uom_code, CCCV.counter_group_id
1265: FROM CSI_CP_COUNTERS_V CCCV
1266: WHERE CCCV.CUSTOMER_PRODUCT_ID = c_csi_item_instance_id
1267: AND CCCV.COUNTER_TEMPLATE_NAME = c_name
1268: AND trunc(nvl(CCCV.start_date_active, sysdate)) <= trunc(sysdate)
1269: AND trunc(nvl(CCCV.end_date_active, sysdate+1)) > trunc(sysdate);

Line 1281: FROM csi_cp_counters_v

1277: CURSOR get_current_value_id(c_counter_id NUMBER) IS
1278: SELECT nvl(counter_reading,0) counter_reading,
1279: counter_group_id,
1280: uom_code
1281: FROM csi_cp_counters_v
1282: WHERE counter_id = c_counter_id;
1283: ***/
1284:
1285: l_utilization_rec utilization_rec_type;

Line 1431: FROM CSI_CP_COUNTERS_V CCCV

1427: --Given start instance_id and uom_code, this cursor is used to get all of the distinct
1428: --counters this start instance has
1429: CURSOR get_inst_counters(c_instance_id NUMBER, c_uom_code VARCHAR2) IS
1430: SELECT DISTINCT CCCV.COUNTER_TEMPLATE_NAME counter_name
1431: FROM CSI_CP_COUNTERS_V CCCV
1432: WHERE CCCV.UOM_CODE = c_uom_code
1433: AND CCCV.CUSTOMER_PRODUCT_ID = c_instance_id
1434: AND trunc(nvl(CCCV.start_date_active, sysdate)) <= trunc(sysdate)
1435: AND trunc(nvl(CCCV.end_date_active, sysdate+1)) > trunc(sysdate);

Line 1440: -- Removed the use of csi_cp_counters_v

1436:
1437: --Given start instance_id and uom_code, this cursor is used to get all of the distinct
1438: --counters this start instance and all of its components have
1439: -- Cursor changed by jaramana on 03-DEC-2008 for bug 7426643 (FP of 7263702)
1440: -- Removed the use of csi_cp_counters_v
1441: CURSOR get_all_counters(c_instance_id NUMBER, c_uom_code VARCHAR2) IS
1442: SELECT DISTINCT C.COUNTER_TEMPLATE_NAME counter_name
1443: FROM CSI_COUNTERS_VL C, CSI_COUNTER_ASSOCIATIONS CCA
1444: WHERE C.UOM_CODE = c_uom_code