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 DBA_TABLES

Line 75: TABLE OF dba_tables.table_name%TYPE;

71: schemaname IN VARCHAR2)
72: IS
73: TYPE name_tab
74: IS
75: TABLE OF dba_tables.table_name%TYPE;
76: tmp_str VARCHAR2(200);
77: names name_tab;
78: num_tables NUMBER := 0;
79: modeval VARCHAR2(5);

Line 105: FROM dba_tables

101: /* schema_cur */
102: ELSE -- schemaname<>'ALL'
103: SELECT table_name BULK COLLECT
104: INTO names
105: FROM dba_tables
106: WHERE owner = upper(schemaname)
107: AND
108: (
109: iot_type <> 'IOT_OVERFLOW'

Line 839: TABLE OF dba_tables.table_name%TYPE;

835: invalidate IN VARCHAR2 DEFAULT 'Y' )
836: IS
837: TYPE name_tab
838: IS
839: TABLE OF dba_tables.table_name%TYPE;
840: TYPE partition_tab
841: IS
842: TABLE OF sys.dba_tab_modifications.partition_name%TYPE;
843: TYPE partition_type_tab

Line 845: TABLE OF dba_tables.partitioned%TYPE;

841: IS
842: TABLE OF sys.dba_tab_modifications.partition_name%TYPE;
843: TYPE partition_type_tab
844: IS
845: TABLE OF dba_tables.partitioned%TYPE;
846: part_flag partition_type_tab;
847: names name_tab;
848: pnames partition_tab;
849: num_tables NUMBER := 0;

Line 867: FROM dba_tables

863: FROM
864: ( SELECT 'TABLE' type,
865: owner ,
866: table_name name
867: FROM dba_tables
868: WHERE owner=upper(schemaname)
869: AND
870: (
871: iot_type <> 'IOT_OVERFLOW'

Line 901: FROM dba_tables dt

897: CURSOR nomon_tab(schemaname VARCHAR2)
898: IS
899: SELECT owner,
900: table_name
901: FROM dba_tables dt
902: WHERE owner=upper(schemaname)
903: AND
904: (
905: iot_type <> 'IOT_OVERFLOW'

Line 968: FROM dba_tables dt

964: SELECT table_name ,
965: partitioned BULK COLLECT
966: INTO names,
967: part_flag
968: FROM dba_tables dt
969: WHERE owner = upper(schemaname)
970: AND
971: (
972: iot_type <> 'IOT_OVERFLOW'

Line 1079: FROM dba_tables dt

1075: WHERE dtm.table_owner = upper(schemaname)
1076: AND dtm.partition_name IS NULL
1077: AND EXISTS
1078: ( SELECT NULL
1079: FROM dba_tables dt
1080: WHERE dt.owner =dtm.table_owner
1081: AND dt.table_name=dtm.table_name
1082: AND
1083: (

Line 1306: TABLE OF dba_tables.table_name%TYPE;

1302: invalidate IN VARCHAR2 DEFAULT 'Y' )
1303: IS
1304: TYPE name_tab
1305: IS
1306: TABLE OF dba_tables.table_name%TYPE;
1307: TYPE partition_tab
1308: IS
1309: TABLE OF sys.dba_tab_modifications.partition_name%TYPE;
1310: TYPE partition_type_tab

Line 1312: TABLE OF dba_tables.partitioned%TYPE;

1308: IS
1309: TABLE OF sys.dba_tab_modifications.partition_name%TYPE;
1310: TYPE partition_type_tab
1311: IS
1312: TABLE OF dba_tables.partitioned%TYPE;
1313: part_flag partition_type_tab;
1314: names name_tab;
1315: pnames partition_tab;
1316: num_tables NUMBER := 0;

Line 1334: FROM dba_tables dt

1330: FROM
1331: ( SELECT 'TABLE' type,
1332: owner ,
1333: table_name name
1334: FROM dba_tables dt
1335: WHERE owner=upper(schemaname)
1336: AND
1337: (
1338: iot_type <> 'IOT_OVERFLOW'

Line 1388: FROM dba_tables dt

1384: CURSOR nomon_tab(schemaname VARCHAR2)
1385: IS
1386: SELECT owner,
1387: table_name
1388: FROM dba_tables dt
1389: WHERE owner=upper(schemaname)
1390: AND
1391: (
1392: iot_type <> 'IOT_OVERFLOW'

Line 1457: FROM dba_tables dt

1453: SELECT table_name ,
1454: partitioned BULK COLLECT
1455: INTO names,
1456: part_flag
1457: FROM dba_tables dt
1458: WHERE owner = upper(schemaname)
1459: AND
1460: (
1461: iot_type <> 'IOT_OVERFLOW'

Line 1568: FROM dba_tables dt

1564: WHERE dtm.table_owner = upper(schemaname)
1565: AND dtm.partition_name IS NULL
1566: AND EXISTS
1567: ( SELECT NULL
1568: FROM dba_tables dt
1569: WHERE dt.owner =dtm.table_owner
1570: AND dt.table_name =dtm.table_name
1571: AND dt.partitioned='NO'
1572: AND

Line 2599: FROM dba_tables

2595: WHEN no_data_found THEN
2596: BEGIN
2597: SELECT 'EXIST'
2598: INTO exist_flag
2599: FROM dba_tables
2600: WHERE table_name = upper(tabname)
2601: AND owner =
2602: ( SELECT b.oracle_username
2603: FROM fnd_product_installations a,

Line 2613: || ' does not exist in fnd_tables/dba_tables for the

2609: EXCEPTION
2610: WHEN no_data_found THEN
2611: raise_application_error(-20000, 'Table '
2612: || tabname
2613: || ' does not exist in fnd_tables/dba_tables for the
2614: given application ');
2615: END;
2616: END;
2617: -- Now insert

Line 3352: last_analyzed dba_tables.last_analyzed%type;

3348: /************************************************************************/
3349: PROCEDURE table_stats(schema VARCHAR2,
3350: tableName VARCHAR2)
3351: IS
3352: last_analyzed dba_tables.last_analyzed%type;
3353: sample_size dba_tables.sample_size%type;
3354: num_rows dba_tables.num_rows%type;
3355: blocks dba_tables.blocks%type;
3356: BEGIN

Line 3353: sample_size dba_tables.sample_size%type;

3349: PROCEDURE table_stats(schema VARCHAR2,
3350: tableName VARCHAR2)
3351: IS
3352: last_analyzed dba_tables.last_analyzed%type;
3353: sample_size dba_tables.sample_size%type;
3354: num_rows dba_tables.num_rows%type;
3355: blocks dba_tables.blocks%type;
3356: BEGIN
3357: SELECT last_analyzed ,

Line 3354: num_rows dba_tables.num_rows%type;

3350: tableName VARCHAR2)
3351: IS
3352: last_analyzed dba_tables.last_analyzed%type;
3353: sample_size dba_tables.sample_size%type;
3354: num_rows dba_tables.num_rows%type;
3355: blocks dba_tables.blocks%type;
3356: BEGIN
3357: SELECT last_analyzed ,
3358: sample_size ,

Line 3355: blocks dba_tables.blocks%type;

3351: IS
3352: last_analyzed dba_tables.last_analyzed%type;
3353: sample_size dba_tables.sample_size%type;
3354: num_rows dba_tables.num_rows%type;
3355: blocks dba_tables.blocks%type;
3356: BEGIN
3357: SELECT last_analyzed ,
3358: sample_size ,
3359: TRUNC(num_rows),

Line 3365: FROM dba_tables

3361: INTO last_analyzed,
3362: sample_size ,
3363: num_rows ,
3364: blocks
3365: FROM dba_tables
3366: WHERE table_name = tableName
3367: AND owner = schema;
3368:
3369: dbms_output.put_line('===================================================================================================');

Line 3612: FROM dba_tables dt

3608: CURSOR all_tables(schema VARCHAR2)
3609: IS
3610: SELECT table_name,
3611: owner
3612: FROM dba_tables dt
3613: WHERE owner = schema
3614: AND
3615: (
3616: iot_type <> 'IOT_OVERFLOW'