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.QP_PREQ_PUB dependencies on V$MYSTAT

Line 13101: FROM v$mystat, v$statname

13097: -- l_pricing_start_time := dbms_utility.get_time;
13098: --added to note redo generation
13099: BEGIN
13100: SELECT VALUE INTO l_pricing_start_redo
13101: FROM v$mystat, v$statname
13102: WHERE v$mystat.statistic# = v$statname.statistic#
13103: AND v$statname.name = 'redo size';
13104: EXCEPTION
13105: WHEN OTHERS THEN

Line 13102: WHERE v$mystat.statistic# = v$statname.statistic#

13098: --added to note redo generation
13099: BEGIN
13100: SELECT VALUE INTO l_pricing_start_redo
13101: FROM v$mystat, v$statname
13102: WHERE v$mystat.statistic# = v$statname.statistic#
13103: AND v$statname.name = 'redo size';
13104: EXCEPTION
13105: WHEN OTHERS THEN
13106: IF l_debug = FND_API.G_TRUE THEN

Line 14246: FROM v$mystat, v$statname

14242: IF G_QP_DEBUG = G_ENGINE_TIME_TRACE_ON THEN --3085171
14243: --added to note redo log
14244: BEGIN
14245: SELECT VALUE INTO l_pricing_end_redo
14246: FROM v$mystat, v$statname
14247: WHERE v$mystat.statistic# = v$statname.statistic#
14248: AND v$statname.name = 'redo size';
14249: EXCEPTION
14250: WHEN OTHERS THEN

Line 14247: WHERE v$mystat.statistic# = v$statname.statistic#

14243: --added to note redo log
14244: BEGIN
14245: SELECT VALUE INTO l_pricing_end_redo
14246: FROM v$mystat, v$statname
14247: WHERE v$mystat.statistic# = v$statname.statistic#
14248: AND v$statname.name = 'redo size';
14249: EXCEPTION
14250: WHEN OTHERS THEN
14251: IF l_debug = FND_API.G_TRUE THEN