DBA Data[Home] [Help]

APPS.MSC_ANALYSE_TABLES_PK dependencies on ALL_TABLES

Line 12: FROM all_tables

8:
9: CURSOR tab_list(p_owner varchar2) is
10: SELECT table_name,
11: partitioned
12: FROM all_tables
13: where owner=p_owner
14: and table_name like 'MSC%'
15: and temporary <> 'Y';
16:

Line 58: FROM all_tables

54:
55: CURSOR tab_list( cv_table_name IN VARCHAR2, cv_owner IN VARCHAR2) is
56: SELECT table_name,
57: partitioned
58: FROM all_tables
59: where owner=cv_owner
60: and table_name= UPPER(cv_table_name)
61: and temporary <> 'Y';
62: