APPS.AST_OFL_ACCESSES_REPORT SQL Statements

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

Line: 21

    SELECT  to_char(SYSDATE,'DD-MON-YYYY')
      INTO  v_date_time
      FROM  dual;

Line: 39

    htp.tableData('' || htf.bold( 'Please specify the criteria and select OK.  ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');

Line: 57

  select grpd.group_id sgi,
            decode(grpd.group_id, grpd.parent_group_id,
            decode(topgrp.manager_flag, 'Y', grptl.group_name,
			    ' *'||grptl.group_name),
            decode(topgrp.manager_flag, 'Y',
            decode(grpd.immediate_parent_flag, 'Y',
			    '-'||grptl.group_name, '--'||grptl.group_name),
            decode(grpd.immediate_parent_flag, 'Y',
			    '  -'||grptl.group_name, '  --'||grptl.group_name))) name
  from jtf_rs_groups_denorm grpd,
       jtf_rs_groups_tl grptl,
       (select distinct grpb.group_id, rrb2.manager_flag
          from jtf_rs_groups_b grpb,
               jtf_rs_role_relations rrel2,
               jtf_rs_roles_b rrb2,
               jtf_rs_resource_extns rsc2,
               jtf_rs_group_members mem,
               fnd_user fnu
         where grpb.group_id = mem.group_id
           and trunc(sysdate) between grpb.start_date_active
                                  and nvl(grpb.end_date_active, trunc(sysdate))
           and rrb2.role_type_code in ('SALES','TELESALES')
           and (rrb2.manager_flag = 'Y' or rrb2.admin_flag = 'Y')
           and rrel2.role_id = rrb2.role_id
           and trunc(sysdate) between rrel2.start_date_active
                                  and nvl(rrel2.end_date_active, trunc(sysdate))
           and rrel2.role_resource_type = 'RS_GROUP_MEMBER'
           and rrel2.role_resource_id = mem.group_member_id
           and mem.resource_id = rsc2.resource_id
           and mem.delete_flag='N'
           and rsc2.source_id = fnu.employee_id
           and fnu.user_id = p_userid) topgrp
 where grptl.group_id = grpd.group_id
   and grpd.parent_group_id = topgrp.group_id
   and trunc(sysdate) between grpd.start_date_active
   and nvl(grpd.end_date_active, trunc(sysdate))
order by 2 desc;

Line: 98

     select distinct rsc.source_id pid,
                     rsc.source_name flname
      from jtf_rs_resource_extns rsc,
           jtf_rs_group_members gmem,
           jtf_rs_role_relations rrel,
           jtf_rs_roles_b rrb,
           (select distinct grpd.group_id
              from jtf_rs_groups_denorm grpd,
                   jtf_rs_role_relations rrel2,
                   jtf_rs_roles_b rrb2,
                   jtf_rs_resource_extns rsc2,
                   jtf_rs_group_members mem,
                   fnd_user fnu
             where grpd.parent_group_id = mem.group_id
               and nvl(grpd.end_date_active, trunc(sysdate)) >= trunc(sysdate)
		     and rrb2.role_type_code in ('SALES','TELESALES')
               and (rrb2.admin_flag = 'Y' or rrb2.manager_flag = 'Y')
               and rrel2.role_id = rrb2.role_id
               and trunc(sysdate) between rrel2.start_date_active
                   and nvl(rrel2.end_date_active, trunc(sysdate))
               and rrel2.role_resource_type = 'RS_GROUP_MEMBER'
               and rrel2.role_resource_id = mem.group_member_id
               and mem.resource_id = rsc2.resource_id
               and mem.delete_flag='N'
               and rsc2.source_id = fnu.employee_id
               and fnu.user_id = fnd_global.user_id) grps
     where gmem.group_id = grps.group_id
       and rsc.resource_id = gmem.resource_id
       and rrel.role_resource_id = gmem.group_member_id
       and trunc(sysdate) between rrel.start_date_active
              and nvl(rrel.end_date_active, trunc(sysdate))
       and rrb.role_type_code in ('SALES','TELESALES')
       and rrb.admin_flag = 'N'
       and rrel.role_id = rrb.role_id
       and rrel.role_resource_type = 'RS_GROUP_MEMBER'
       and gmem.delete_flag='N'
   UNION
   select distinct rsc.source_id pid,
           rsc.source_name flname
      from jtf_rs_resource_extns rsc,
           fnd_user fnu
      where rsc.source_id = fnu.employee_id
      and fnu.user_id = fnd_global.user_id
      order by 2;

Line: 171

        htp.p('Select Output Format');

Line: 173

        htp.p('');

Line: 174

        htp.formSelectOption('Excel');

Line: 175

        htp.formSelectOption('HTML',cSelected => 'TRUE');

Line: 176

        htp.formSelectClose;

Line: 182

        htp.p('');

            htp.formSelectOption(rec_sales_group.name, cAttributes => ' value= ' || rec_sales_group.sgi);

        htp.formSelectClose;

        htp.p('');

Line: 201

           htp.formSelectOption('ALL', cAttributes => ' value= -999', cSelected
=> 'TRUE');

Line: 205

              htp.formSelectOption(rec_sales_rep.flname,
                               cAttributes => ' value= ' || rec_sales_rep.pid);

Line: 210

           SELECT rsc.source_name, rsc.source_id
             INTO l_flname, l_pid
             FROM jtf_rs_resource_extns rsc,
                  fnd_user fnu
            WHERE rsc.source_id = fnu.employee_id
              AND fnu.user_id = fnd_global.user_id;

Line: 216

              htp.formSelectOption(l_flname,
                               cAttributes => ' value= ' || l_pid);

Line: 225

                htp.formSelectOption(rec_sales_rep.flname,
                               cAttributes => ' value= ' || rec_sales_rep.pid,
                               cSelected => 'TRUE');

Line: 229

                htp.formSelectOption(rec_sales_rep.flname,
                               cAttributes => ' value= ' || rec_sales_rep.pid);

Line: 233

        htp.formSelectClose;

Line: 240

        htp.p('');

        htp.formSelectOption('Account',cSelected => 'TRUE');

        htp.formSelectOption('Opportunity');

        htp.formSelectOption('Lead');

        htp.formSelectClose;