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: