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.IEX_UWQ_PROM_ENUMS_PVT SQL Statements

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

Line: 10


CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
    WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';

Line: 22


     'SELECT  GLSOB.CURRENCY_CODE CURRENCY from GL_SETS_OF_BOOKS GLSOB, AR_SYSTEM_PARAMETERS ARSYS WHERE ARSYS.SET_OF_BOOKS_ID ' ||
     ' = GLSOB.SET_OF_BOOKS_ID');

Line: 24


  L := IEX_UTILITIES.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE'||I_ORG.ORGANIZATION_ID, 'SELECT DEFAULT_EXCHANGE_RATE_TYPE FROM AR_CMGT_SETUP_OPTIONS');

Line: 50


    select source_id
    from jtf_rs_resource_extns
    where resource_id = p_resource_id;

Line: 55


    select lookup_code, meaning from fnd_lookup_values
    where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');

Line: 59


    SELECT meaning
    FROM fnd_lookup_values
    WHERE lookup_type = in_lookup_type
    AND lookup_code = in_lookup_code
    AND LANGUAGE = userenv('LANG');

Line: 66


    SELECT work_q_view_for_primary_node, work_q_label_lu_type, work_q_label_lu_code
    FROM ieu_uwq_sel_enumerators
    WHERE sel_enum_id = in_sel_enum_id;

Line: 110


   SELECT count(*) into l_check from iex_assignments where
   alt_resource_id =  p_RESOURCE_ID
   AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
   AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
   AND NVL(DELETED_FLAG,'N') = 'N';

Line: 132


             ' IN  (select iea.alt_resource_id '||
             ' FROM  iex_assignments iea ' ||
             ' WHERE  nvl(iea.deleted_flag,''N'') = ''N'' ' ||
             ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
             ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >=  TRUNC(SYSDATE) ' ||
	     ' AND iea.alt_resource_id = :RESOURCE_ID ' ||
	     ' AND iea.resource_id =  ' ||  l_sel_enum_rec.work_q_view_for_primary_node ||'.RESOURCE_ID )) ' ||
  	     ' AND ' ||      ' (UWQ_STATUS IS NULL or  UWQ_STATUS = :UWQ_STATUS or ' ||
             ' (trunc(UWQ_ACTIVE_DATE) <= trunc(SYSDATE) and UWQ_STATUS = ''PENDING'' )) ';

Line: 145


             ' IN  (select iea.alt_resource_id '||
             ' FROM  iex_assignments iea ' ||
             ' WHERE  nvl(iea.deleted_flag,''N'') = ''N'' ' ||
             ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
             ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >=  TRUNC(SYSDATE) ' ||
	     ' AND iea.alt_resource_id = :RESOURCE_ID ' ||
	     ' AND iea.resource_id =  ' ||  l_sel_enum_rec.work_q_view_for_primary_node ||'.RESOURCE_ID )) ' ||
             ' AND' || ' (UWQ_STATUS = :UWQ_STATUS and (trunc(UWQ_ACTIVE_DATE) > trunc(SYSDATE))) ';

Line: 157


             ' IN  (select iea.alt_resource_id '||
             ' FROM  iex_assignments iea ' ||
             ' WHERE  nvl(iea.deleted_flag,''N'') = ''N'' ' ||
             ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
             ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >=  TRUNC(SYSDATE) ' ||
	     ' AND iea.alt_resource_id = :RESOURCE_ID ' ||
	     ' AND iea.resource_id =  ' ||  l_sel_enum_rec.work_q_view_for_primary_node ||'.RESOURCE_ID )) ' ||
	     ' AND ' ||
	     ' (UWQ_STATUS = :UWQ_STATUS and (trunc(UWQ_COMPLETE_DATE) + ' || l_Complete_Days || ' >  trunc(SYSDATE))) ';

Line: 170


 ' OR  ' || l_sel_enum_rec.work_q_view_for_primary_node || '.PARTY_ID' || ' IN (SELECT distinct hp.party_id ' ||
          ' FROM hz_customer_profiles hp,ar_collectors ac, ' ||
          ' iex_assignments iea ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_id = iea.resource_id ' ||
          ' AND  iea.alt_employee_id = :PERSON_ID ' ||
          ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
          ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >=  TRUNC(SYSDATE) )';

Line: 181


  ' OR  ' || l_sel_enum_rec.work_q_view_for_primary_node || '.PARTY_ID' || ' IN (SELECT distinct hp.party_id ' ||
           ' FROM hz_customer_profiles hp,ar_collectors ac ' ||
           ' WHERE hp.collector_id = ac.collector_id ' ||
           ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
           ' AND ac.employee_id = :PERSON_ID ';

Line: 186


  l_str2 := ' UNION ALL SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND ac.employee_id = :PERSON_ID ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ) ' ;

Line: 200


  l_str_bkr := ' AND NOT EXISTS (SELECT 1 FROM iex_bankruptcies bkr WHERE bkr.party_id = ' || l_sel_enum_rec.work_q_view_for_primary_node || '.party_id) ';

Line: 209


      	             ' IN  (select iea.alt_resource_id '||
                     ' FROM  iex_assignments iea ' ||
                     ' WHERE  nvl(iea.deleted_flag,''N'') = ''N'' ' ||
                     ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
                     ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >=  TRUNC(SYSDATE) ' ||
		     ' AND iea.alt_resource_id = :RESOURCE_ID ' ||
		     ' AND iea.resource_id =  ' ||  l_sel_enum_rec.work_q_view_for_primary_node ||'.RESOURCE_ID )) ';

Line: 374


    select lookup_code, meaning from fnd_lookup_values
    where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');

Line: 378


    SELECT meaning
    FROM fnd_lookup_values
    WHERE lookup_type = in_lookup_type
    AND lookup_code = in_lookup_code
    AND LANGUAGE = userenv('LANG');

Line: 385


    SELECT work_q_view_for_primary_node, work_q_label_lu_type, work_q_label_lu_code
    FROM ieu_uwq_sel_enumerators
    WHERE sel_enum_id = in_sel_enum_id;

Line: 417


        SELECT collector_id from AR_COLLECTORS where resource_id = p_resource_id
          and resource_type = 'RS_RESOURCE';

Line: 421


        select source_id
        from jtf_rs_resource_extns
        where resource_id = p_resource_id;

Line: 428


      SELECT PREFERENCE_VALUE
  	FROM IEX_APP_PREFERENCES_B
      WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL';

Line: 445


   SELECT count(*) INTO l_check FROM iex_assignments where
   alt_resource_id = p_RESOURCE_ID
   AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
   AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
   AND NVL(DELETED_FLAG,'N') = 'N';

Line: 694


    select lookup_code, meaning from fnd_lookup_values
    where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');

Line: 698


    SELECT meaning
    FROM fnd_lookup_values
    WHERE lookup_type = in_lookup_type
    AND lookup_code = in_lookup_code
    AND LANGUAGE = userenv('LANG');

Line: 705


    SELECT work_q_view_for_primary_node, work_q_label_lu_type, work_q_label_lu_code
    FROM ieu_uwq_sel_enumerators
    WHERE sel_enum_id = in_sel_enum_id;

Line: 735


      SELECT collector_id from AR_COLLECTORS where resource_id = p_resource_id
        and resource_type = 'RS_RESOURCE';

Line: 739


      select source_id
      from jtf_rs_resource_extns
      where resource_id = p_resource_id;

Line: 744


    SELECT PREFERENCE_VALUE
    FROM IEX_APP_PREFERENCES_B
    WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL';

Line: 788


   SELECT count(*) INTO l_check FROM iex_assignments where
   alt_resource_id =  P_RESOURCE_ID
   AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
   AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
   AND NVL(DELETED_FLAG,'N') = 'N';

Line: 1044


    select lookup_code, meaning from fnd_lookup_values
    where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');

Line: 1048


    SELECT meaning
    FROM fnd_lookup_values
    WHERE lookup_type = in_lookup_type
    AND lookup_code = in_lookup_code
    AND LANGUAGE = userenv('LANG');

Line: 1055


    SELECT work_q_view_for_primary_node, work_q_label_lu_type, work_q_label_lu_code
    FROM ieu_uwq_sel_enumerators
    WHERE sel_enum_id = in_sel_enum_id;

Line: 1085


      SELECT collector_id from AR_COLLECTORS where resource_id = p_resource_id
        and resource_type = 'RS_RESOURCE';

Line: 1089


      select source_id
      from jtf_rs_resource_extns
      where resource_id = p_resource_id;

Line: 1094


    SELECT PREFERENCE_VALUE
	FROM IEX_APP_PREFERENCES_B
    WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL';

Line: 1128


   SELECT count(*) INTO l_check FROM iex_assignments where
   alt_resource_id =  p_RESOURCE_ID
   AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
   AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
   AND NVL(DELETED_FLAG,'N') = 'N';

Line: 1380


      SELECT count(*) INTO l_check FROM iex_assignments where
      alt_resource_id = p_RESOURCE_ID
      AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
      AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
      AND NVL(DELETED_FLAG,'N') = 'N';

Line: 1386


      select count(1) into l_group_check
      from ar_collectors where status='A' and
      nvl(inactive_date,sysdate)>=sysdate and resource_type='RS_GROUP';

Line: 1392


        l_security_where := ' :person_id = :person_id and collector_resource_id in (select resource_id from ar_collectors where resource_type = ''RS_RESOURCE'' and resource_id = :COLLECTOR_RESOURCE_ID ';

Line: 1399


                ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||
                ' iea.alt_employee_id = :PERSON_ID '||
                ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
                ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
                ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' '||
                ' and ac.resource_id=iea.resource_id '||
                ' and ac.resource_type in (''RS_RESOURCE'',''RS_GROUP'') ';

Line: 1410


                ' union all SELECT ac.resource_ID '||
			    ' FROM ar_collectors ac , jtf_rs_group_members jtgrp '||
			    ' WHERE ac.resource_ID = jtgrp.group_id '||
			    ' AND ac.resource_type = ''RS_GROUP'''||
			    ' AND NVL(jtgrp.delete_flag,''N'') = ''N'''||
			    ' AND jtgrp.resource_ID = :COLLECTOR_RESOURCE_ID ';