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

Line 2994: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn

2990: END IF;
2991:
2992: dbms_session.free_unused_user_memory;
2993:
2994: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
2995: WHERE st.STATISTIC# = sn.STATISTIC#
2996: AND sn.NAME in ('session pga memory max');
2997: log_message('Session pga memory max = ' || to_char(v_dummy) );
2998:

Line 2999: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn

2995: WHERE st.STATISTIC# = sn.STATISTIC#
2996: AND sn.NAME in ('session pga memory max');
2997: log_message('Session pga memory max = ' || to_char(v_dummy) );
2998:
2999: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
3000: where st.STATISTIC# = sn.STATISTIC#
3001: and sn.NAME in ('session pga memory');
3002: log_message('Session pga memory = ' || TO_CHAR(v_dummy) );
3003:

Line 7155: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn

7151: END IF;
7152:
7153: -- Vpedarla Bug: 8230710
7154:
7155: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
7156: WHERE st.STATISTIC# = sn.STATISTIC#
7157: AND sn.NAME in ('session pga memory max');
7158: log_message('MSC_INSERTS-Before Freeing up. Session pga memory max = ' || to_char(v_dummy) );
7159:

Line 7160: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn

7156: WHERE st.STATISTIC# = sn.STATISTIC#
7157: AND sn.NAME in ('session pga memory max');
7158: log_message('MSC_INSERTS-Before Freeing up. Session pga memory max = ' || to_char(v_dummy) );
7159:
7160: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
7161: where st.STATISTIC# = sn.STATISTIC#
7162: and sn.NAME in ('session pga memory');
7163: log_message('MSC_INSERTS-Before Freeing up. Session pga memory = ' || TO_CHAR(v_dummy) );
7164:

Line 7319: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn

7315:
7316: dbms_session.free_unused_user_memory;
7317:
7318: -- Vpedarla Bug: 8230710
7319: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
7320: WHERE st.STATISTIC# = sn.STATISTIC#
7321: AND sn.NAME in ('session pga memory max');
7322: log_message('MSC_INSERTS-After Freeing up2. Session pga memory max = ' || to_char(v_dummy) );
7323:

Line 7324: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn

7320: WHERE st.STATISTIC# = sn.STATISTIC#
7321: AND sn.NAME in ('session pga memory max');
7322: log_message('MSC_INSERTS-After Freeing up2. Session pga memory max = ' || to_char(v_dummy) );
7323:
7324: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
7325: where st.STATISTIC# = sn.STATISTIC#
7326: and sn.NAME in ('session pga memory');
7327: log_message('MSC_INSERTS-After Freeing up2. Session pga memory = ' || TO_CHAR(v_dummy) );
7328: