APPS.WF_ITEM_DEFINITION SQL Statements

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

Line: 52

  SELECT display_name, name
  FROM   wf_item_types_vl
  ORDER BY 1;

Line: 60

  SELECT distinct wit.display_name, wit.name
  FROM   wf_item_types_vl wit, wf_items wik
  WHERE  wik.owner_role = l_username
  AND    wik.item_type = wit.name
  ORDER BY 1;

Line: 67

  SELECT distinct wik.owner_role owner_role
  FROM   wf_items wik
  ORDER BY 1;

Line: 143

   htp.formSelectOpen(cname=>'p_item_type',cattributes=>'id="i_item_type"');

Line: 158

       htp.formSelectOption(cvalue=>it.display_name,
                            cattributes=>'value='||REPLACE(it.name,' ', '+'));

Line: 171

       htp.formSelectOption(cvalue=>it.display_name,
                            cattributes=>'value='||REPLACE(it.name,' ', '+'));

Line: 178

   htp.formSelectClose;