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_UMP_UNITMAINT_PVT dependencies on CSI_COUNTER_READINGS

Line 1800: CSI_COUNTER_READINGS CCR

1796: CURSOR get_ctr_reading_csr(p_counter_id IN NUMBER) IS
1797: SELECT NVL(CCR.net_reading, 0)
1798: FROM
1799: CSI_COUNTERS_VL CC,
1800: CSI_COUNTER_READINGS CCR
1801: WHERE
1802: CCR.COUNTER_ID = CC.COUNTER_ID
1803: AND CC.COUNTER_ID = p_counter_id
1804: ORDER BY

Line 1983: CSI_COUNTER_READINGS CCR

1979: p_accomplishment_date IN DATE) IS
1980: SELECT NVL(CCR.net_reading, 0)
1981: FROM
1982: CSI_COUNTERS_VL CC,
1983: CSI_COUNTER_READINGS CCR
1984: WHERE
1985: CCR.COUNTER_ID = CC.COUNTER_ID
1986: AND CC.COUNTER_ID = p_counter_id
1987: AND CCR.VALUE_TIMESTAMP <= p_accomplishment_date

Line 1997: CSI_COUNTER_READINGS CCR

1993: p_accomplishment_date IN DATE) IS
1994: SELECT NVL(CCR.net_reading, 0)
1995: FROM
1996: CSI_COUNTERS_VL CC,
1997: CSI_COUNTER_READINGS CCR
1998: WHERE
1999: CCR.COUNTER_ID = CC.COUNTER_ID
2000: AND CC.COUNTER_ID = p_counter_id
2001: AND trunc(CCR.VALUE_TIMESTAMP) <= trunc(p_accomplishment_date)

Line 2010: CSI_COUNTER_READINGS CCR

2006: CURSOR get_nxt_max_ctr_reading_csr(p_counter_id IN NUMBER,
2007: p_accomplishment_date IN DATE) IS
2008: SELECT NVL(CCR.net_reading, 0)
2009: FROM
2010: CSI_COUNTER_READINGS CCR
2011: WHERE
2012: CCR.COUNTER_ID = p_counter_id
2013: -- fix for bug# 7016783. pick next highest counter value.
2014: AND trunc(CCR.VALUE_TIMESTAMP) > trunc(p_accomplishment_date)