The following lines contain the word 'select', 'insert', 'update' or 'delete':
select decode(app.application_short_name, 'SQLAP', 'AP'
, 'SQLGL', 'GL'
, app.application_short_name)
|| ' - '|| tl.application_name product_name
from APPLSYS.FND_APPLICATION_TL tl
, APPLSYS.FND_APPLICATION app
where app.application_id = tl.application_id
and app.application_id = n_appid
and tl.language = userenv('LANG');
select table_name
from applsys.fnd_tables
where application_id = n_appid
and table_id = n_tabid;
select t.meaning
from fnd_lookup_values t
, fnd_lookup_types l
where l.lookup_type = c_lookup_type
and t.lookup_code = c_lookup_code
and l.lookup_type = t.lookup_type
and l.security_group_id = t.security_group_id
and l.view_application_id = t.view_application_id
and t.language = userenv('LANG');
, c_state => 'SELECTED');
, b_prior_selected => TRUE);
select release_name
from fnd_product_groups
order by release_name;
select app.application_id
, decode(app.application_short_name, 'SQLAP', 'AP'
, 'SQLGL', 'GL'
, app.application_short_name)
|| ' - '|| tl.application_name product_name
from FND_APPLICATION_TL tl
, FND_APPLICATION app
where app.application_id = tl.application_id
and tl.language = userenv('LANG')
order by decode(app.application_short_name, 'SQLAP', 'AP'
, 'SQLGL', 'GL'
, app.application_short_name);
htp.p('');
Line: 208
htp.p('');
Line: 242
select count(t.table_id) id_count
from fnd_tables t
where t.application_id = n_appid
and t.table_name like c_name ESCAPE '\';
Line: 250
select count(f.file_id) id_count
from fnd_etrm_files f
where f.application_id = n_appid
and upper(f.file_name) like c_name ESCAPE '\';
Line: 257
select count(v.view_id) id_count
from fnd_views v
where v.application_id = n_appid
and v.view_name like c_name ESCAPE '\';
Line: 264
select count(c.application_id) id_count
from fnd_concurrent_programs c
where c.application_id = n_appid
and c.concurrent_program_name like c_name ESCAPE '\';
Line: 271
select count(c.application_id) id_count
from fnd_lookup_types c
where c.application_id = n_appid
and c.lookup_type like c_name ESCAPE '\';
Line: 278
select count(e.name) id_count
from wf_events e
, fnd_application a
where a.application_id = n_appid
and e.owner_tag = a.application_short_name
and e.name like c_name ESCAPE '\';
Line: 422
select application_id
from fnd_application
order by decode(application_short_name, 'SQLAP', 'AP'
, 'SQLGL', 'GL'
, application_short_name);
Line: 481
select t.table_id id
, t.table_name name
from fnd_tables t
where t.application_id = n_appid
and t.table_name like c_name ESCAPE '\'
order by table_name;
Line: 491
select v.view_id id
, v.view_name name
from fnd_views v
where v.application_id = n_appid
and v.view_name like c_name ESCAPE '\'
order by view_name;
Line: 500
select f.file_id id
, f.file_name name
from fnd_etrm_files f
where f.application_id = n_appid
and upper(f.file_name) like c_name ESCAPE '\'
order by file_name;
Line: 509
select c.concurrent_program_id id
, c.concurrent_program_name name
from fnd_concurrent_programs c
where c.application_id = n_appid
and c.concurrent_program_name like c_name ESCAPE '\'
order by c.concurrent_program_name;
Line: 518
select v.lookup_type id
, v.lookup_type name
from fnd_lookup_types v
where v.application_id = n_appid
and v.lookup_type like c_name ESCAPE '\'
order by lookup_type;
Line: 527
select e.name
, e.guid id
from wf_events e
, fnd_application a
where a.application_id = n_appid
and e.owner_tag = a.application_short_name
and e.name like c_name ESCAPE '\';
Line: 538
select t.table_id id
, t.table_name name
, 'TABLE' o_type
from applsys.fnd_tables t
where t.application_id = n_appid
and t.table_name like c_name ESCAPE '\'
UNION
select v.view_id id
, v.view_name name
, 'VIEW' o_type
from applsys.fnd_views v
where v.application_id = n_appid
and v.view_name like c_name ESCAPE '\'
order by 2;
Line: 701
IS select table_name
, INITIAL_EXTENT
, NEXT_EXTENT
, MIN_EXTENTS
, MAX_EXTENTS
, PCT_INCREASE
, INI_TRANS
, MAX_TRANS
, PCT_FREE
, PCT_USED
, description
from applsys.fnd_tables
where application_id = n_appid
and table_id = n_tabid
order by table_name;
Line: 721
is select ind.index_name
, ind.index_id
, decode(ind.uniqueness, 'N', 'Non Unique'
, 'Y', 'Unique') uniqueness
, ind.description
from fnd_indexes ind
where ind.application_id = n_appid
and ind.table_id = n_tabid
order by ind.uniqueness desc, ind.index_name;
Line: 735
is select c.column_name
from fnd_index_columns i
, fnd_columns c
where i.application_id = n_appid
and i.table_id = n_tabid
and i.index_id = n_index
and c.application_id = i.application_id
and c.table_id = i.table_id
and c.column_id = i.column_id
order by i.column_sequence;
Line: 749
is SELECT PRIMARY_KEY_ID
, PRIMARY_KEY_NAME
, PRIMARY_KEY_TYPE
, ENABLED_FLAG
FROM APPLSYS.FND_PRIMARY_KEYS
where table_id = n_tabid
and application_id = n_appid
order by primary_key_name;
Line: 761
SELECT c.column_name
from applsys.fnd_columns c
, applsys.fnd_primary_key_columns k
where k.table_id = c.table_id
and k.application_id = c.application_id
and k.column_id = c.column_id
and k.table_id = n_tabid
and k.application_id = n_appid
and k.primary_key_id = n_keyid
order by primary_key_sequence;
Line: 777
is SELECT PRIMARY_KEY_APPLICATION_ID
, PRIMARY_KEY_TABLE_ID
, PRIMARY_KEY_ID
, foreign_key_id
, foreign_key_name
FROM APPLSYS.FND_FOREIGN_KEYS
where table_id = n_tabid
and application_id = n_appid
order by foreign_key_name;
Line: 790
is SELECT PRIMARY_KEY_ID
, table_id
, application_id
, foreign_key_id
, foreign_key_name
FROM APPLSYS.FND_FOREIGN_KEYS
where primary_key_table_id = n_tabid
and primary_key_application_id = n_appid
order by foreign_key_name;
Line: 803
SELECT c.column_name
from applsys.fnd_columns c
, applsys.fnd_foreign_key_columns k
where k.table_id = c.table_id
and k.application_id = c.application_id
and k.column_id = c.column_id
and k.table_id = n_tabid
and k.application_id = n_appid
and k.foreign_key_id = n_keyid
order by foreign_key_sequence;
Line: 817
is select col.column_name
, decode(col.column_type, 'N', 'Number'
, 'D', 'Date'
, 'V', 'Varchar2'
, 'L', 'Long'
, 'R', 'Raw'
, 'X', 'Long Raw'
, 'I', 'RowID'
, 'A', 'N-Clob'
, 'B', 'BLOB'
, 'E', 'CLOB'
, 'F', 'B-File'
, 'W', 'N-Char'
, 'M', 'MLS-Label'
, 'Z', 'Raw MLS-Label'
, 'U', 'Unknown', 'Unknown') data_type
, col.width data_length
, nvl(to_char(col.precision), '
') data_precision
, nvl(decode(col.null_allowed_flag, 'N', 'NOT_NULL'
, 'Y', '
'), '
') nullable
, nvl(description, '
') description
from applsys.fnd_columns col
where col.table_id = n_tabid
and col.application_id = n_appid
order by col.column_sequence;
Line: 1131
IS select view_name
, description
, text
from applsys.fnd_views
where view_id = n_tabid
and application_id = n_appid
order by view_name;
Line: 1142
is select col.column_name
from applsys.fnd_view_columns col
where col.view_id = n_tabid
and col.application_id = n_appid
order by col.column_sequence;
Line: 1186
v_viewtext := replace(v_viewtext , 'SELECT ', 'SELECT ');
Line: 1231
select t.user_concurrent_program_name long_name
, t.description
, c.concurrent_program_name name
, c.execution_method_code
, c.argument_method_code
, c.queue_control_flag
, c.queue_method_code
, c.request_set_flag
, c.enabled_flag
, c.print_flag
, c.run_alone_flag
, c.srs_flag
, c.save_output_flag
, c.required_style
from fnd_concurrent_programs_tl t
, fnd_concurrent_programs c
where c.application_id = n_appid
and c.concurrent_program_id = n_tabid
and c.concurrent_program_id = t.concurrent_program_id
and c.application_id = t.application_id
and t.language = userenv('LANG');
Line: 1255
select e.executable_name name
, e.execution_method_code
, e.execution_file_name
, e.subroutine_name
, t.user_executable_name
, t.description
from fnd_executables e
, fnd_concurrent_programs c
, fnd_executables_tl t
where e.application_id = n_appid
and c.concurrent_program_id = n_tabid
and c.executable_id = e.executable_id
and e.application_id = t.application_id
and e.executable_id = t.executable_id
and t.language = userenv('LANG');
Line: 1273
SELECT a.DESCRIPTIVE_FLEX_APPL_ID
, a.DESCRIPTIVE_FLEXFIELD_NAME
, a.APPLICATION_COLUMN_NAME
, a.DISPLAY_FLAG
, a.INSERT_FLAG
, a.UPDATE_FLAG
, a.DEFAULT_TYPE
, a.DEFAULT_VALUE
, a.SHARED_PARAMETER_NAME
FROM APPLSYS.FND_REQUEST_SET_PROGRAMS p
, APPLSYS.FND_REQUEST_SET_PROGRAM_ARGS a
where p.PROGRAM_APPLICATION_ID = n_appid
and p.CONCURRENT_PROGRAM_ID = n_progid
and a.APPLICATION_ID = p.SET_APPLICATION_ID
and a.REQUEST_SET_ID = p.REQUEST_SET_ID
and a.REQUEST_SET_PROGRAM_ID = p.REQUEST_SET_PROGRAM_ID
order by application_column_name;
Line: 1363
htp.p('Insert ');
Line: 1364
htp.p('Update ');
Line: 1381
htp.prn(a_rec.insert_flag);
Line: 1384
htp.prn(a_rec.update_flag);
Line: 1409
select t.meaning
, t.description
from fnd_lookup_types_tl t
, fnd_lookup_types l
where l.application_id = n_appid
and l.lookup_type = c_lookup_type
and l.lookup_type = t.lookup_type
and t.language = userenv('LANG');
Line: 1421
select t.lookup_code
, t.meaning
, t.description
from fnd_lookup_values t
, fnd_lookup_types l
where l.application_id = n_appid
and l.lookup_type = c_lookup_type
and l.lookup_type = t.lookup_type
and l.security_group_id = t.security_group_id
and l.view_application_id = t.view_application_id
and t.language = userenv('LANG')
order by t.lookup_code;
Line: 1491
SELECT NAME
, TYPE
, STATUS
, GENERATE_FUNCTION
, OWNER_NAME
, OWNER_TAG
FROM WF_EVENTS
where GUID = c_guid;
Line: 1501
select s.wf_process_name
, s.wf_process_type
, s.rule_function
, s.source_type
, s.description
from wf_event_subscriptions s
where s.event_filter_guid = c_guid
order by source_type;
Line: 1576
select APPLICATION_ID
, FILE_NAME
, FILE_TYPE
, DESCRIPTION
, dbms_lob.getlength(FILE_CONTENT) file_length
from fnd_etrm_files
where file_id = n_fileid;
Line: 1645
select file_content
, file_name
, file_content_type
from fnd_etrm_files
where file_id = n_file_id;
Line: 1703
select app.application_id
, decode(app.application_short_name, 'SQLAP', 'AP'
, 'SQLGL', 'GL'
, app.application_short_name)
|| ' - '|| tl.application_name product_name
from APPLSYS.FND_APPLICATION_TL tl
, APPLSYS.FND_APPLICATION app
where app.application_id = tl.application_id
and tl.language = userenv('LANG')
order by decode(app.application_short_name, 'SQLAP', 'AP'
, 'SQLGL', 'GL'
, app.application_short_name);
Line: 1856
select decode(app.application_short_name, 'SQLAP', 'AP'
, 'SQLGL', 'GL'
, app.application_short_name) application_short_name
from fnd_tables t
, fnd_application app
where table_name = c_name
and t.application_id = app.application_id;
Line: 1867
select decode(app.application_short_name, 'SQLAP', 'AP'
, 'SQLGL', 'GL'
, app.application_short_name) application_short_name
from fnd_views t
, fnd_application app
where view_name = c_name
and t.application_id = app.application_id;