APPS.ETRM_FNDNAV dependencies on FND_VIEWS

Line 258: from fnd_views v

254:
255: cursor cur_views(c_name in dba_objects.object_name%type := '%'
256: , n_appid in number) is
257: select count(v.view_id) id_count
258: from fnd_views v
259: where v.application_id = n_appid
260: and v.view_name like c_name ESCAPE '\';
261:
262: cursor cur_concurrent(c_name in dba_objects.object_name%type := '%'

Line 493: from fnd_views v

489: cursor cur_views(c_name in dba_objects.object_name%type := '%'
490: , n_appid in number) is
491: select v.view_id id
492: , v.view_name name
493: from fnd_views v
494: where v.application_id = n_appid
495: and v.view_name like c_name ESCAPE '\'
496: order by view_name;
497:

Line 548: from applsys.fnd_views v

544: UNION
545: select v.view_id id
546: , v.view_name name
547: , 'VIEW' o_type
548: from applsys.fnd_views v
549: where v.application_id = n_appid
550: and v.view_name like c_name ESCAPE '\'
551: order by 2;
552:

Line 1134: from applsys.fnd_views

1130: -- List view details
1131: IS select view_name
1132: , description
1133: , text
1134: from applsys.fnd_views
1135: where view_id = n_tabid
1136: and application_id = n_appid
1137: order by view_name;
1138: --

Line 1870: from fnd_views t

1866: is
1867: select decode(app.application_short_name, 'SQLAP', 'AP'
1868: , 'SQLGL', 'GL'
1869: , app.application_short_name) application_short_name
1870: from fnd_views t
1871: , fnd_application app
1872: where view_name = c_name
1873: and t.application_id = app.application_id;
1874: