eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AST_OFL_LEAD_ASSIGN_PARAM SQL Statements

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

Line: 34


    SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY')
    INTO v_date_time
    FROM DUAL;

Line: 54


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

Line: 70


    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
		  -- Begin Mod Raam on 02.27.2001
            AND mem.delete_flag = 'N'
		  -- End Mod.
            AND mem.resource_id = rsc2.resource_id
            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: 123


	select distinct source_id pid, source_name flname
	from JTF_RS_RESOURCE_EXTNS
	where source_id in (
	    select distinct b.person_id
	    from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a
	    where b.manager_person_id = a.source_id
	    and a.user_id = iUserID
	);

Line: 133


     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: 207


      htp.p('    var s_day = objform.p_sd_date.selectedIndex;');

Line: 208


      htp.p('    var s_month = objform.p_sm_date.selectedIndex;');

Line: 209


      htp.p('    var s_year = objform.p_sy_date.selectedIndex;');

Line: 210


      htp.p('    var e_day = objform.p_ed_date.selectedIndex;');

Line: 211


      htp.p('    var e_month = objform.p_em_date.selectedIndex;');

Line: 212


      htp.p('    var e_year = objform.p_ey_date.selectedIndex;');

Line: 275


      htp.p('Select Output Format');

Line: 277


      htp.p('');

Line: 288


        htp.formSelectOption(day_data(i),
		cAttributes => ' value= ' || day_data(i),
		cSelected => 'TRUE' );

Line: 292


      htp.formSelectClose;

Line: 294


      htp.p('');

Line: 310


          htp.formSelectOption(year_data(i),
		  cAttributes => ' value= ' || year_data(i),
		  cSelected => 'TRUE');

Line: 314


          htp.formSelectOption(year_data(i),
		  cAttributes => ' value= ' || year_data(i));

Line: 318


      htp.formSelectClose;

Line: 324


      htp.p('');

Line: 335


          htp.formSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),
		  cAttributes => ' value=' || LPAD(TO_CHAR(i), 2, '0'),
		  cSelected => 'TRUE');

Line: 339


          htp.formSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),
		  cAttributes => ' value=' || LPAD(TO_CHAR(i), 2, '0'));

Line: 343


      htp.formSelectClose;

Line: 345


      htp.p ('');

Line: 388


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

Line: 390


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

Line: 393


	htp.formSelectOption('ALL', cAttributes => ' value= -1');

Line: 394


	htp.formSelectOption('All My Team', cAttributes => ' value= -2');

Line: 395


	htp.formSelectClose;