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.FND_STATS dependencies on DBMS_DB_VERSION

Line 940: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN

936: FROM dba_external_tables de
937: WHERE de.table_name=dt.table_name
938: AND de.owner =dt.owner
939: );-- added this to avoid externale tables being selected
940: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN
941: $ELSE
942: CURSOR nomon_tab_lt(schemaname VARCHAR2) -- this is for locking stats on table
943: IS
944: SELECT owner,

Line 1038: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN

1034: owner,
1035: name ;
1036:
1037: $END
1038: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN
1039: $ELSE
1040: CURSOR lock_stats_tab(schemaname VARCHAR2)
1041: IS -- cursor added by saleem to display the warning message for tables with locked stats
1042: SELECT table_name

Line 1083: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN --checkingf or dbversion for lock stats

1079: -- backup the existing schema stats
1080: IF ( (upper(internal_flag) = 'BACKUP') ) THEN
1081: FND_STATS.BACKUP_SCHEMA_STATS( schemaname );
1082: END IF;
1083: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN --checkingf or dbversion for lock stats
1084: --If db_versn < 100 THEN
1085: IF(upper(OPTIONS)='GATHER') THEN
1086: SELECT table_name ,
1087: partitioned BULK COLLECT

Line 1847: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN

1843: FROM dba_external_tables de
1844: WHERE de.table_name=dt.table_name
1845: AND de.owner =dt.owner
1846: );-- added this to avoid externale tables being selected
1847: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN
1848: $ELSE
1849: CURSOR nomon_tab_lt(schemaname VARCHAR2) -- this is for locking stats on table
1850: IS
1851: SELECT owner,

Line 1944: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN

1940: ORDER BY type ,
1941: owner,
1942: name ;
1943: $END
1944: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN
1945: $ELSE
1946: CURSOR lock_stats_tab(schemaname VARCHAR2)
1947: IS -- cursor added by saleem to display the warning message for tables with locked stats
1948: SELECT table_name

Line 1995: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN --checkingf or dbversion for lock stats

1991: -- backup the existing schema stats
1992: IF ( (upper(internal_flag) = 'BACKUP') ) THEN
1993: FND_STATS.BACKUP_SCHEMA_STATS( schemaname );
1994: END IF;
1995: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN --checkingf or dbversion for lock stats
1996: IF(upper(OPTIONS)='GATHER') THEN
1997: SELECT table_name ,
1998: partitioned BULK COLLECT
1999: INTO names,

Line 2732: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN

2728: WHERE table_name = upper(tabname)
2729: AND table_owner= upper(ownname)
2730: ORDER BY index_name;
2731: -- New cursor for 11g extended stats
2732: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN
2733: $ELSE
2734: $IF DBMS_DB_VERSION.VER_LE_10_2 $THEN
2735: $ELSE
2736: CURSOR extenstats_cursor (ownname VARCHAR2, tabname VARCHAR2, partname VARCHAR2)

Line 2734: $IF DBMS_DB_VERSION.VER_LE_10_2 $THEN

2730: ORDER BY index_name;
2731: -- New cursor for 11g extended stats
2732: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN
2733: $ELSE
2734: $IF DBMS_DB_VERSION.VER_LE_10_2 $THEN
2735: $ELSE
2736: CURSOR extenstats_cursor (ownname VARCHAR2, tabname VARCHAR2, partname VARCHAR2)
2737: IS
2738: SELECT a.COLUMN_NAME1,

Line 2830: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN

2826: || c_rec.hsize ;
2827: END LOOP;
2828: dbms_output.put_line(method);
2829: -- code from this line to next 55lines is for building method_opt for extnstats
2830: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN
2831: NULL;
2832: $ELSE
2833: $IF DBMS_DB_VERSION.VER_LE_10_2 $THEN
2834: NULL;

Line 2833: $IF DBMS_DB_VERSION.VER_LE_10_2 $THEN

2829: -- code from this line to next 55lines is for building method_opt for extnstats
2830: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN
2831: NULL;
2832: $ELSE
2833: $IF DBMS_DB_VERSION.VER_LE_10_2 $THEN
2834: NULL;
2835: $ELSE
2836: --IF (db_versn >= 110) THEN
2837: dbms_output.put_line('getting into extended stats');

Line 2976: -- $IF DBMS_DB_VERSION.VER_LE_11 $THEN

2972: END;
2973: END IF;
2974: END IF; -- db_versn is 8i
2975: /* -- changes for 11g optimizer
2976: -- $IF DBMS_DB_VERSION.VER_LE_11 $THEN
2977: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN
2978: NULL;
2979: $ELSE
2980: $IF DBMS_DB_VERSION.VER_LE_10_2 $THEN

Line 2977: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN

2973: END IF;
2974: END IF; -- db_versn is 8i
2975: /* -- changes for 11g optimizer
2976: -- $IF DBMS_DB_VERSION.VER_LE_11 $THEN
2977: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN
2978: NULL;
2979: $ELSE
2980: $IF DBMS_DB_VERSION.VER_LE_10_2 $THEN
2981: NULL;

Line 2980: $IF DBMS_DB_VERSION.VER_LE_10_2 $THEN

2976: -- $IF DBMS_DB_VERSION.VER_LE_11 $THEN
2977: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN
2978: NULL;
2979: $ELSE
2980: $IF DBMS_DB_VERSION.VER_LE_10_2 $THEN
2981: NULL;
2982: $ELSE
2983: --IF (db_versn >= 110) THEN
2984: --Build up the method_opt if extended stats cols are present

Line 4572: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN

4568: l_cg_name VARCHAR2(30) := NULL;
4569: --owner varchar2(30) := NULL;
4570: extntn varchar2(50);
4571: BEGIN
4572: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN
4573: NULL;
4574: $ELSE
4575: $IF DBMS_DB_VERSION.VER_LE_10_2 $THEN
4576: NULL;

Line 4575: $IF DBMS_DB_VERSION.VER_LE_10_2 $THEN

4571: BEGIN
4572: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN
4573: NULL;
4574: $ELSE
4575: $IF DBMS_DB_VERSION.VER_LE_10_2 $THEN
4576: NULL;
4577: $ELSE
4578: If upper(colname3) is not null and upper(colname4) is null THEN
4579: extntn := '(' || upper(colname1) || ',' || upper(colname2) || ',' || upper(colname3) || ')' ;