APPS.FND_WEB SQL Statements

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

Line: 24

  select to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') into val from dual;

Line: 30

  select banner into val from v$version where rownum=1;

Line: 49

  select user into val from dual;

Line: 55

  select product_version into val
  from   fnd_product_installations
  where  application_id=0;

Line: 64

    select pov.profile_option_value
    into   val
    from   fnd_profile_options po,
           fnd_profile_option_values pov
    where  po.profile_option_name = 'APPS_WEB_AGENT'
    and    pov.application_id = po.application_id
    and    pov.profile_option_id = po.profile_option_id
    and    pov.level_id = 10001;

Line: 98

    select US.NAME NAME,
	   US.TYPE TYPE,
	   substr(US.TEXT, instr(US.TEXT, '$Header')+9,
		  instr(substr(US.TEXT, instr(US.TEXT, '$Header')+9),
			' ', 1, 2)-1) VERSION
    from   USER_SOURCE US
    where  US.NAME like header_filter
    and    US.TYPE in ('PACKAGE', 'PACKAGE BODY')
    and    US.TEXT like '%$Header: %'
    order by 1, 2;