APPS.ETRM_PNAV dependencies on FND_APPLICATION

Line 491: , fnd_application a

487: select a.application_short_name
488: , a.application_id
489: , t.table_id
490: from fnd_tables t
491: , fnd_application a
492: where table_name = c_name
493: and t.application_id = a.application_id
494: order by a.application_short_name;
495:

Line 503: , fnd_application a

499: select a.application_short_name
500: , a.application_id
501: , t.view_id
502: from fnd_views t
503: , fnd_application a
504: where view_name = c_name
505: and t.application_id = a.application_id
506: order by a.application_short_name;
507:

Line 1944: and table_name = 'FND_APPLICATION';

1940: is
1941: select count(table_name) app_count
1942: from dba_tables
1943: where owner = 'APPLSYS'
1944: and table_name = 'FND_APPLICATION';
1945:
1946: cursor cur_schema
1947: is select username
1948: from dba_users

Line 1966: from fnd_application app

1962: 'select decode(app.application_short_name, ''SQLAP'', ''AP''
1963: , ''SQLGL'', ''GL''
1964: , app.application_short_name) application_short_name
1965: , tl.application_name
1966: from fnd_application app
1967: , fnd_application_tl tl
1968: where tl.application_id = app.application_id
1969: order by decode(app.application_short_name, ''SQLAP'', ''AP''
1970: , ''SQLGL'', ''GL''

Line 1967: , fnd_application_tl tl

1963: , ''SQLGL'', ''GL''
1964: , app.application_short_name) application_short_name
1965: , tl.application_name
1966: from fnd_application app
1967: , fnd_application_tl tl
1968: where tl.application_id = app.application_id
1969: order by decode(app.application_short_name, ''SQLAP'', ''AP''
1970: , ''SQLGL'', ''GL''
1971: , app.application_short_name)';