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

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

3130: END IF;
3131:
3132: dbms_session.free_unused_user_memory;
3133:
3134: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
3135: WHERE st.STATISTIC# = sn.STATISTIC#
3136: AND sn.NAME in ('session pga memory max');
3137: log_message('Session pga memory max = ' || to_char(v_dummy) );
3138:

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

3135: WHERE st.STATISTIC# = sn.STATISTIC#
3136: AND sn.NAME in ('session pga memory max');
3137: log_message('Session pga memory max = ' || to_char(v_dummy) );
3138:
3139: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
3140: where st.STATISTIC# = sn.STATISTIC#
3141: and sn.NAME in ('session pga memory');
3142: log_message('Session pga memory = ' || TO_CHAR(v_dummy) );
3143:

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

6316: LOG_MESSAGE('Extract_items : organization_id: ' || gmp_item_aps_rec.organization_id);
6317: end if;
6318: */
6319:
6320: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
6321: where st.STATISTIC# = sn.STATISTIC#
6322: and sn.NAME in ('session pga memory');
6323: log_message('After Item Cursor Session pga memory = ' || TO_CHAR(v_dummy) );
6324:

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

8820: log_message('Batches size is = '|| to_char(gprod_size) );
8821: time_stamp ;
8822:
8823: -- Bug: 6030499
8824: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
8825: where st.STATISTIC# = sn.STATISTIC#
8826: and sn.NAME in ('session pga memory');
8827: log_message('Session pga memory = ' || TO_CHAR(v_dummy) );
8828:

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

8974: log_message('Batches Resource size is = '|| to_char(grsrc_size) );
8975: time_stamp ;
8976:
8977: -- Bug: 6030499 Vpedarla
8978: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
8979: where st.STATISTIC# = sn.STATISTIC#
8980: and sn.NAME in ('session pga memory');
8981: log_message('Session pga memory = ' || TO_CHAR(v_dummy) );
8982:

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

9044: log_message('Batch Step charge size is = '|| to_char(stp_chg_count) );
9045: time_stamp ;
9046:
9047: -- Bug:6030499 Vpedarla
9048: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
9049: where st.STATISTIC# = sn.STATISTIC#
9050: and sn.NAME in ('session pga memory');
9051: log_message('Session pga memory = ' || TO_CHAR(v_dummy) );
9052:

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

10161: rr_index := 0 ;
10162:
10163:
10164: -- Bug:6030499 Vpedarla
10165: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
10166: where st.STATISTIC# = sn.STATISTIC#
10167: and sn.NAME in ('session pga memory');
10168: log_message('Session pga memory production END = ' || TO_CHAR(v_dummy) );
10169:

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

11133: log_message('No lot on hand fetches : '|| to_char(gonhand_balance_size) );
11134: time_stamp ;
11135:
11136: -- Bug:6030499 Vpedarla
11137: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
11138: where st.STATISTIC# = sn.STATISTIC#
11139: and sn.NAME in ('session pga memory');
11140: log_message('Session pga memory = ' || TO_CHAR(v_dummy) );
11141:

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

11219: log_message('Lot on hand fetches : '|| to_char(gonhand_balance_size) );
11220: time_stamp ;
11221:
11222: -- Bug:6030499 Vpedarla
11223: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
11224: where st.STATISTIC# = sn.STATISTIC#
11225: and sn.NAME in ('session pga memory');
11226: log_message('Session pga memory = ' || TO_CHAR(v_dummy) );
11227:

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

11347: log_message('Lot and status on hand fetches : '|| to_char(gonhand_balance_size) );
11348: time_stamp ;
11349:
11350: -- Bug: 6030499 Vpedarla
11351: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
11352: where st.STATISTIC# = sn.STATISTIC#
11353: and sn.NAME in ('session pga memory');
11354: log_message('Session pga memory = ' || TO_CHAR(v_dummy) );
11355:

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

12281: time_stamp ;
12282: log_message('Schedule Items size is = ' || to_char(gitem_size)) ;
12283:
12284: -- Bug: 6030499 Vpedarla
12285: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
12286: where st.STATISTIC# = sn.STATISTIC#
12287: and sn.NAME in ('session pga memory');
12288: log_message('Session pga memory = ' || TO_CHAR(v_dummy) );
12289:

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

12300: log_message('Fcst size is = '|| to_char(gfcst_size) );
12301:
12302:
12303: -- Bug: 6030499 Vpedarla
12304: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
12305: where st.STATISTIC# = sn.STATISTIC#
12306: and sn.NAME in ('session pga memory');
12307: log_message('Session pga memory = ' || TO_CHAR(v_dummy) );
12308:

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

12317: time_stamp ;
12318: log_message ('SO size is = '||to_char(gso_size));
12319:
12320: -- Bug: 6030499 Vpedarla
12321: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
12322: where st.STATISTIC# = sn.STATISTIC#
12323: and sn.NAME in ('session pga memory');
12324: log_message('Session pga memory = ' || TO_CHAR(v_dummy) );
12325:

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

12334: time_stamp ;
12335: log_message('Schedule Forecast Assoc size is ='||to_char(gschd_fcst_size));
12336:
12337: -- Bug: 6030499 Vpedarla
12338: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
12339: where st.STATISTIC# = sn.STATISTIC#
12340: and sn.NAME in ('session pga memory');
12341: log_message('Session pga memory = ' || TO_CHAR(v_dummy) );
12342:

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

13179: END LOOP ;
13180: CLOSE fcst_hdr ;
13181:
13182: --Bug: 6030499
13183: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
13184: where st.STATISTIC# = sn.STATISTIC#
13185: and sn.NAME in ('session pga memory');
13186: log_message('fcst_hdr Session pga memory = ' || TO_CHAR(v_dummy) );
13187:

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

15545: CLOSE cal_cur;
15546:
15547: /*Bug: 6030499 Vpedarla added session pga memory */
15548:
15549: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
15550: where st.STATISTIC# = sn.STATISTIC#
15551: and sn.NAME in ('session pga memory');
15552: log_message('Cal Cur Session pga memory = ' || TO_CHAR(v_dummy) );
15553:

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

16724: END IF; /* Only if any resource */
16725:
16726: /* Bug: 6030499 Vpedarla added session pga memory */
16727:
16728: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
16729: where st.STATISTIC# = sn.STATISTIC#
16730: and sn.NAME in ('session pga memory');
16731: log_message('ri_shift_interval Session pga memory = ' || TO_CHAR(v_dummy) );
16732:

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

17117: END LOOP; /* End loop for Main Cursor */
17118: CLOSE union_cal_ref;
17119:
17120: /* Bug: 6030499 */
17121: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
17122: where st.STATISTIC# = sn.STATISTIC#
17123: and sn.NAME in ('session pga memory');
17124: log_message('union_cal_ref Session pga memory = ' || TO_CHAR(v_dummy) );
17125:

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

17417: stmt_no := 79;
17418:
17419: /* Bug: 6030499 added session pga memory */
17420:
17421: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
17422: where st.STATISTIC# = sn.STATISTIC#
17423: and sn.NAME in ('session pga memory');
17424: log_message('ri_assembly Session pga memory = ' || TO_CHAR(v_dummy) );
17425:

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

17777: END LOOP ;
17778: CLOSE cur_get_cal ;
17779:
17780: -- Bug: 6030499
17781: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
17782: where st.STATISTIC# = sn.STATISTIC#
17783: and sn.NAME in ('session pga memory');
17784: log_message('cur_get_cal Session pga memory = ' || TO_CHAR(v_dummy) );
17785:

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

18595: END LOOP ;
18596: CLOSE ri_shift_interval;
18597:
18598: -- Bug: 6030499
18599: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
18600: where st.STATISTIC# = sn.STATISTIC#
18601: and sn.NAME in ('session pga memory');
18602: log_message('Session pga memory = ' || TO_CHAR(v_dummy) );
18603:

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

18802: END LOOP;
18803: CLOSE ri_assembly;
18804:
18805: -- Bug: 6030499
18806: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
18807: where st.STATISTIC# = sn.STATISTIC#
18808: and sn.NAME in ('session pga memory');
18809: log_message('ri_assembly Session pga memory = ' || TO_CHAR(v_dummy) );
18810: