eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UC_UTILIZATION_PVT dependencies on CSI_CP_COUNTERS_V

Line 779: FROM csi_cp_counters_v

775: -- and also to ignore disabled counter readings
776: /*
777: SELECT nvl(counter_reading,0) counter_reading,
778: counter_group_id
779: FROM csi_cp_counters_v
780: WHERE counter_id = c_counter_id
781: -- order by added by jaramana on June 13, 2007 to fix bug 6123549
782: -- Since csi_cp_counters_v was modified by CSI in R12 to get all
783: -- counter readings and not just the most recent one.

Line 782: -- Since csi_cp_counters_v was modified by CSI in R12 to get all

778: counter_group_id
779: FROM csi_cp_counters_v
780: WHERE counter_id = c_counter_id
781: -- order by added by jaramana on June 13, 2007 to fix bug 6123549
782: -- Since csi_cp_counters_v was modified by CSI in R12 to get all
783: -- counter readings and not just the most recent one.
784: ORDER BY value_timestamp desc;
785: */
786: SELECT (select ccr.net_reading

Line 945: FROM csi_cp_counters_v

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

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

946: WHERE counter_id = c_counter_id;
947: ***/
948: -- Get current counter reading values based on the counter_name
949: -- Cursor changed by jaramana on 03-DEC-2008 for bug 7426643 (FP of 7263702)
950: -- Removed the use of csi_cp_counters_v and uptook
951: -- changes made via Counters bug 7561677 (FP of 7374316)
952: CURSOR get_current_value_name(c_instance_id NUMBER,
953: c_counter_name VARCHAR2) IS
954: /*

Line 961: FROM csi_cp_counters_v

957: counter_id,
958: start_date_active,
959: end_date_active,
960: uom_code
961: FROM csi_cp_counters_v
962: WHERE customer_product_id = c_instance_id
963: AND counter_template_name = c_counter_name
964: AND trunc(nvl(start_date_active, sysdate)) <= trunc(sysdate)
965: AND trunc(nvl(end_date_active, sysdate+1)) > trunc(sysdate)

Line 1209: -- Removed the use of csi_cp_counters_v

1205: TYPE instance_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1206: /** Begin changes by jaramana on October 29, 2007 for bug 6513576
1207: Cannot use cs_counters and cs_counter_groups anymore **/
1208: -- Cursor changed by jaramana on 03-DEC-2008 for bug 7426643 (FP of 7263702)
1209: -- Removed the use of csi_cp_counters_v
1210: CURSOR get_components_counter(c_instance_id NUMBER, c_counter_name VARCHAR2) IS
1211: SELECT CI.subject_id
1212: FROM csi_ii_relationships CI
1213: WHERE EXISTS (SELECT 'X'

Line 1225: FROM CSI_CP_COUNTERS_V CCCV

1221: AND trunc(nvl(CC.start_date_active,sysdate)) <= trunc(sysdate)
1222: AND trunc(nvl(CC.end_date_active,sysdate+1)) > trunc(sysdate))
1223: */
1224: /*
1225: FROM CSI_CP_COUNTERS_V CCCV
1226: WHERE CCCV.CUSTOMER_PRODUCT_ID = CI.subject_id
1227: AND CCCV.COUNTER_TEMPLATE_NAME = c_counter_name
1228: AND trunc(nvl(CCCV.start_date_active, sysdate)) <= trunc(sysdate)
1229: AND trunc(nvl(CCCV.end_date_active, sysdate+1)) > trunc(sysdate))

Line 1277: FROM CSI_CP_COUNTERS_V CCCV

1273: AND trunc(sysdate) >= trunc(nvl(ctr.start_date_active,sysdate))
1274: AND trunc(sysdate) <= trunc(nvl(ctr.end_date_active,sysdate+1));
1275: */
1276: SELECT CCCV.COUNTER_TEMPLATE_NAME counter_name, CCCV.counter_id, CCCV.uom_code, CCCV.counter_group_id
1277: FROM CSI_CP_COUNTERS_V CCCV
1278: WHERE CCCV.CUSTOMER_PRODUCT_ID = c_csi_item_instance_id
1279: AND CCCV.COUNTER_TEMPLATE_NAME = c_name
1280: AND trunc(nvl(CCCV.start_date_active, sysdate)) <= trunc(sysdate)
1281: AND trunc(nvl(CCCV.end_date_active, sysdate+1)) > trunc(sysdate);

Line 1293: FROM csi_cp_counters_v

1289: CURSOR get_current_value_id(c_counter_id NUMBER) IS
1290: SELECT nvl(counter_reading,0) counter_reading,
1291: counter_group_id,
1292: uom_code
1293: FROM csi_cp_counters_v
1294: WHERE counter_id = c_counter_id;
1295: ***/
1296:
1297: l_utilization_rec utilization_rec_type;

Line 1454: FROM CSI_CP_COUNTERS_V CCCV

1450: AND trunc(nvl(CC.start_date_active, sysdate)) <= trunc(sysdate)
1451: AND trunc(nvl(CC.end_date_active, sysdate+1)) > trunc(sysdate);
1452: */
1453: SELECT DISTINCT CCCV.COUNTER_TEMPLATE_NAME counter_name
1454: FROM CSI_CP_COUNTERS_V CCCV
1455: WHERE CCCV.UOM_CODE = c_uom_code
1456: AND CCCV.CUSTOMER_PRODUCT_ID = c_instance_id
1457: AND trunc(nvl(CCCV.start_date_active, sysdate)) <= trunc(sysdate)
1458: AND trunc(nvl(CCCV.end_date_active, sysdate+1)) > trunc(sysdate);

Line 1463: -- Removed the use of csi_cp_counters_v

1459:
1460: --Given start instance_id and uom_code, this cursor is used to get all of the distinct
1461: --counters this start instance and all of its components have
1462: -- Cursor changed by jaramana on 03-DEC-2008 for bug 7426643 (FP of 7263702)
1463: -- Removed the use of csi_cp_counters_v
1464: CURSOR get_all_counters(c_instance_id NUMBER, c_uom_code VARCHAR2) IS
1465: SELECT DISTINCT C.COUNTER_TEMPLATE_NAME counter_name
1466: FROM CSI_COUNTERS_VL C, CSI_COUNTER_ASSOCIATIONS CCA
1467: WHERE C.UOM_CODE = c_uom_code

Line 1475: FROM CSI_CP_COUNTERS_V CCCV

1471: AND CCA.SOURCE_OBJECT_CODE = 'CP'
1472: AND CCA.SOURCE_OBJECT_ID IN (SELECT c_instance_id
1473: /*
1474: SELECT DISTINCT CCCV.COUNTER_TEMPLATE_NAME counter_name
1475: FROM CSI_CP_COUNTERS_V CCCV
1476: WHERE CCCV.UOM_CODE = c_uom_code
1477: AND trunc(nvl(CCCV.start_date_active, sysdate)) <= trunc(sysdate)
1478: AND trunc(nvl(CCCV.end_date_active, sysdate+1)) > trunc(sysdate)
1479: AND CCCV.CUSTOMER_PRODUCT_ID IN (SELECT c_instance_id