APPS.ETRM_FNDNAV dependencies on FND_TABLES

Line 43: from applsys.fnd_tables

39: cursor cur_name(n_appid in number
40: , n_tabid in number)
41: is
42: select table_name
43: from applsys.fnd_tables
44: where application_id = n_appid
45: and table_id = n_tabid;
46:
47: vreturn_value varchar2(512) := '%';

Line 176: htp.p('

Browse the FND Tables in an Applications database

');

172:
173: if (n_appid is null
174: and c_name = '%'
175: and c_type = '%') then
176: htp.p('

Browse the FND Tables in an Applications database

FND Navigator Home');
180: end if;

Line 243: from fnd_tables t

239:
240: cursor cur_tables(c_name in dba_objects.object_name%type := '%'
241: , n_appid in number) is
242: select count(t.table_id) id_count
243: from fnd_tables t
244: where t.application_id = n_appid
245: and t.table_name like c_name ESCAPE '\';
246:
247:

Line 483: from fnd_tables t

479: cursor cur_tables(c_name in dba_objects.object_name%type := '%'
480: , n_appid in number) is
481: select t.table_id id
482: , t.table_name name
483: from fnd_tables t
484: where t.application_id = n_appid
485: and t.table_name like c_name ESCAPE '\'
486: order by table_name;
487:

Line 541: from applsys.fnd_tables t

537: , n_appid in number) is
538: select t.table_id id
539: , t.table_name name
540: , 'TABLE' o_type
541: from applsys.fnd_tables t
542: where t.application_id = n_appid
543: and t.table_name like c_name ESCAPE '\'
544: UNION
545: select v.view_id id

Line 712: from applsys.fnd_tables

708: , MAX_TRANS
709: , PCT_FREE
710: , PCT_USED
711: , description
712: from applsys.fnd_tables
713: where application_id = n_appid
714: and table_id = n_tabid
715: order by table_name;
716: --

Line 1859: from fnd_tables t

1855: is
1856: select decode(app.application_short_name, 'SQLAP', 'AP'
1857: , 'SQLGL', 'GL'
1858: , app.application_short_name) application_short_name
1859: from fnd_tables t
1860: , fnd_application app
1861: where table_name = c_name
1862: and t.application_id = app.application_id;
1863: