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


  select DEFINE_PARTY_RUNNING_LEVEL,DEFINE_OU_RUNNING_LEVEL
  from IEX_QUESTIONNAIRE_ITEMS;

Line: 116


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


             ' 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: 156


             ' 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: 168


             ' 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: 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, ' ||
          ' 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: 192


  ' 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: 197


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


    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 || '.customer_id and NVL(BKR.DISPOSITION_CODE,''GRANTED'') in (''GRANTED'',''NEGOTIATION'') ) ' ;

Line: 214


    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 and NVL(BKR.DISPOSITION_CODE,''GRANTED'') in (''GRANTED'',''NEGOTIATION'') ) ' ;

Line: 224


      	             ' 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: 394


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

Line: 398


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

Line: 405


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


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

Line: 441


        select source_id
        from jtf_rs_resource_extns
        where resource_id = p_resource_id;

Line: 448


      SELECT PREFERENCE_VALUE
  	FROM IEX_APP_PREFERENCES_B
      WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL'
      and org_id is null
      and enabled_flag='Y';

Line: 459


  is select lookup_code
  from iex_lookups_v
  where lookup_type='IEX_RUNNING_LEVEL'
  and lookup_code= 'CUSTOMER'
  and  iex_utilities.validate_running_level(LOOKUP_CODE)='Y';

Line: 477


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


  select count(1)
  into l_level_count
  from iex_lookups_v
  where lookup_type='IEX_RUNNING_LEVEL'
  and  iex_utilities.validate_running_level(LOOKUP_CODE)='Y';

Line: 759


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

Line: 763


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

Line: 770


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


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

Line: 804


      select source_id
      from jtf_rs_resource_extns
      where resource_id = p_resource_id;

Line: 809


    SELECT PREFERENCE_VALUE
    FROM IEX_APP_PREFERENCES_B
    WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL'
    and org_id is null
    and enabled_flag='Y';

Line: 820


  is select lookup_code
  from iex_lookups_v
  where lookup_type='IEX_RUNNING_LEVEL'
  and lookup_code= 'ACCOUNT'
  and  iex_utilities.validate_running_level(LOOKUP_CODE)='Y';

Line: 865


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


  select count(1)
  into l_level_count
  from iex_lookups_v
  where lookup_type='IEX_RUNNING_LEVEL'
  and  iex_utilities.validate_running_level(LOOKUP_CODE)='Y';

Line: 1154


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

Line: 1158


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

Line: 1165


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


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

Line: 1199


      select source_id
      from jtf_rs_resource_extns
      where resource_id = p_resource_id;

Line: 1204


    SELECT PREFERENCE_VALUE
	FROM IEX_APP_PREFERENCES_B
    WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL'
    and org_id is null
    and enabled_flag='Y';

Line: 1215


  is select lookup_code
  from iex_lookups_v
  where lookup_type='IEX_RUNNING_LEVEL'
  and lookup_code= 'BILL_TO'
  and  iex_utilities.validate_running_level(LOOKUP_CODE)='Y';

Line: 1250


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


  select count(1)
  into l_level_count
  from iex_lookups_v
  where lookup_type='IEX_RUNNING_LEVEL'
  and  iex_utilities.validate_running_level(LOOKUP_CODE)='Y';

Line: 1537


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


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


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


                ' 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: 1567


                ' 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 ';