APPS.FND_AUDIT_REPORT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 86

  select g.group_name
  from fnd_audit_groups g
  where g.group_name = nvl(p_group_name, g.group_name);

Line: 91

  select g.group_name, b.table_name, g.audit_group_id, t.table_id, a.application_short_name
  from fnd_audit_groups g, fnd_audit_tables t, fnd_tables b, fnd_application a
  where g.audit_group_id = t.audit_group_id
  and t.table_id = b.table_id
  and g.group_name = p_group_name
  and t.table_app_id = a.application_id;

Line: 99

  select o.object_name, o.status
  from dba_objects o
  where object_name =  p_table_name||'_A'
  and object_type = 'TABLE'
  and owner = p_appl_short_name;

Line: 106

  select o.object_name, o.status
  from dba_objects o
  where object_name = p_table_name||'_AI'
  and object_type = 'TRIGGER'
  and owner = p_appl_short_name;

Line: 113

  select o.object_name, o.status
  from dba_objects o
  where object_name = p_table_name||'_AU'
  and object_type = 'TRIGGER'
  and owner = p_appl_short_name;

Line: 120

  select o.object_name, o.status
  from dba_objects o
  where object_name = p_table_name||'_AD'
  and object_type = 'TRIGGER'
  and owner = p_appl_short_name;

Line: 127

  select o.object_name, o.status
  from dba_objects o
  where object_name = p_table_name||'_AIP'
  and object_type = 'PROCEDURE'
  and owner = p_appl_short_name;

Line: 134

  select o.object_name, o.status
  from dba_objects o
  where object_name = p_table_name||'_AUP'
  and object_type = 'PROCEDURE'
  and owner = p_appl_short_name;

Line: 141

  select o.object_name, o.status
  from dba_objects o
  where object_name = p_table_name||'_ADP'
  and object_type = 'PROCEDURE'
  and owner = p_appl_short_name;

Line: 148

  select o.object_name, o.status
  from dba_objects o
  where object_name like p_table_name||'_AV%'
  and object_type = 'VIEW'
  and owner = p_appl_short_name;

Line: 155

  select o.object_name, o.status
  from dba_objects o
  where object_name like p_table_name||'_AC%'
  and object_type = 'VIEW'
  and owner = p_appl_short_name;

Line: 162

  select column_name
  from dba_tab_columns c
  where table_name = p_table_name||'_A'
  and column_name not like 'AUDIT%'
  and column_name not like 'ROW_KEY%'
  and column_name not in (
  select column_name
  from dba_tab_columns
  where table_name = p_table_name
  and owner = p_appl_short_name)
  and owner = p_appl_short_name;

Line: 176

  select g.group_name, b.table_name,
  decode(g.state,
  'R','Enable Requested',
  'N','Disable - Interrupt Audit',
  'G','Disable - Prepare for Archive',
  'D','Disable - Purge Table',
  'E','Enabled',
  g.state) state
  from fnd_audit_groups g, fnd_audit_tables t , fnd_tables b
  where t.audit_group_id = g.audit_group_id
  and t.table_id = b.table_id
  and t.table_id in (
  select t2.table_id
  from fnd_audit_tables t2
  where t2.table_id = t.table_id
  and t2.audit_group_id <> t.audit_group_id)
  and g.group_name <> p_group_name
  and b.table_name = p_table_name;

Line: 196

  select user from dual;

Line: 199

  select o.object_name, o.status
  from dba_objects o
  where object_name = p_table_name
  and object_type = 'TABLE'
  and owner = p_appl_short_name;

Line: 206

  select o.object_name, o.status
  from dba_objects o
  where object_name =  p_table_name
  and owner = p_appl_short_name
  and object_type = 'SYNONYM';

Line: 213

  select o.object_name, o.status
  from dba_objects o
  where object_name =  p_table_name||'_A'
  and owner = p_appl_short_name
  and object_type = 'SYNONYM';

Line: 220

  select u.oracle_username, decode(d.state,'R','Audit Enabled',
  'X','Audit Disabled', d.state) state
  from fnd_audit_tables t, sys.dba_tables a, fnd_tables b,
  fnd_audit_schemas d, fnd_oracle_userid u
  where u.oracle_id  = d.oracle_id
  and a.owner = u.oracle_username
  and t.table_id = b.table_id
  and d.oracle_id = u.oracle_id
  and b.table_name=a.table_name
  and t.table_id = p_table_id
  and t.audit_group_id = p_audit_group_id;

Line: 233

  select count(*)+1 cnt
  from fnd_audit_columns c,
  fnd_tables b
  where c.state = 'N'
  and c.table_id = b.table_id
  and c.schema_id <> -1
  and b.table_name = p_table_name;