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

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

Line: 31


	select  NAME,PRIMARY_REGION_APPL_ID,PRIMARY_REGION_CODE
	into    l_page_title,l_region_appl_id,l_region_code
	from    AK_FLOW_PAGES_VL
	where   PAGE_CODE = p_page_code
	and     PAGE_APPLICATION_ID = p_page_appl_id
	and     FLOW_CODE = p_flow_code
	and     FLOW_APPLICATION_ID = p_flow_appl_id;

Line: 40


	select  NAME
	into    l_page_title
	from    AK_REGIONS_VL
	where   REGION_CODE = p_region_code
	and     REGION_APPLICATION_ID = p_region_appl_id;

Line: 205


        select  d.COLUMN_NAME,b.DATA_TYPE,a.ATTRIBUTE_LABEL_LONG,e.ICX_CUSTOM_CALL
        from    AK_ATTRIBUTES b,
                AK_REGIONS c,
                AK_OBJECT_ATTRIBUTES d,
		AK_REGION_ITEMS e,
		AK_REGION_ITEMS_VL a
        where   a.REGION_APPLICATION_ID = p_region_appl_id
        and     a.REGION_CODE = l_region_code
        and     a.NODE_QUERY_FLAG = 'Y'
        and     a.REGION_APPLICATION_ID = c.REGION_APPLICATION_ID
        and     a.REGION_CODE = c.REGION_CODE
        and     c.DATABASE_OBJECT_NAME = d.DATABASE_OBJECT_NAME
        and     a.ATTRIBUTE_APPLICATION_ID = d.ATTRIBUTE_APPLICATION_ID
        and     a.ATTRIBUTE_CODE = d.ATTRIBUTE_CODE
	and	a.ATTRIBUTE_APPLICATION_ID = b.ATTRIBUTE_APPLICATION_ID
	and	a.ATTRIBUTE_CODE = b.ATTRIBUTE_CODE
	and	a.REGION_APPLICATION_ID = e.REGION_APPLICATION_ID
	and	a.REGION_CODE = e.REGION_CODE
	and     a.ATTRIBUTE_APPLICATION_ID = e.ATTRIBUTE_APPLICATION_ID
	and     a.ATTRIBUTE_CODE = e.ATTRIBUTE_CODE
	and	not exists     (select  'X'
				from 	AK_EXCLUDED_ITEMS
				where	RESPONSIBILITY_ID = l_responsibility_id
				and	ATTRIBUTE_CODE = a.ATTRIBUTE_CODE
				and	ATTRIBUTE_APPLICATION_ID = a.ATTRIBUTE_APPLICATION_ID)
        order by a.DISPLAY_SEQUENCE;

Line: 278


c_attributes(0) := htf.formSelectOption(' ');

Line: 312


        c_attributes(i) := '

Line: 317


c_attributes(i) := c_attributes(i)||htf.formSelectClose;

Line: 320


c_condition(0) := htf.formSelectOption(' ');

Line: 326


	c_condition(x) := c_condition(x)||'

Line: 329


	c_condition(x) := c_condition(x)||'

Line: 334


c_condition(x) := c_condition(x)||htf.formSelectClose;

Line: 342


select  icx_custom_call
into    l_icx_custom_call
from    ak_regions
where   REGION_APPLICATION_ID = p_region_appl_id
and     REGION_CODE = l_region_code;

Line: 361


                        var temp=document.findForm.a_1.selectedIndex;

Line: 363


                        var temp=document.findForm.c_1.selectedIndex;

Line: 386


                        var temp=document.findForm.a_1.selectedIndex;

Line: 388


                        var temp=document.findForm.c_1.selectedIndex;

Line: 392


                        var temp=document.findForm.a_2.selectedIndex;

Line: 394


                        var temp=document.findForm.c_2.selectedIndex;

Line: 398


                        var temp=document.findForm.a_3.selectedIndex;

Line: 400


                        var temp=document.findForm.c_3.selectedIndex;

Line: 404


                        var temp=document.findForm.a_4.selectedIndex;

Line: 406


                        var temp=document.findForm.c_4.selectedIndex;

Line: 410


                        var temp=document.findForm.a_5.selectedIndex;

Line: 412


                        var temp=document.findForm.c_5.selectedIndex;

Line: 436


                        var temp=document.findForm.a_1.selectedIndex;

Line: 438


                        var temp=document.findForm.c_1.selectedIndex;

Line: 450


                        var temp=document.findForm.a_1.selectedIndex;

Line: 452


                        var temp=document.findForm.c_1.selectedIndex;

Line: 472


                        var temp=document.findForm.a_1.selectedIndex;

Line: 474


                        var temp=document.findForm.c_1.selectedIndex;

Line: 478


                        var temp=document.findForm.a_2.selectedIndex;

Line: 480


                        var temp=document.findForm.c_2.selectedIndex;

Line: 484


                        var temp=document.findForm.a_3.selectedIndex;

Line: 486


                        var temp=document.findForm.c_3.selectedIndex;

Line: 490


                        var temp=document.findForm.a_4.selectedIndex;

Line: 492


                        var temp=document.findForm.c_4.selectedIndex;

Line: 496


                        var temp=document.findForm.a_5.selectedIndex;

Line: 498


                        var temp=document.findForm.c_5.selectedIndex;

Line: 512


                        var temp=document.findForm.a_1.selectedIndex;

Line: 514


                        var temp=document.findForm.c_1.selectedIndex;

Line: 518


                        var temp=document.findForm.a_2.selectedIndex;

Line: 520


                        var temp=document.findForm.c_2.selectedIndex;

Line: 524


                        var temp=document.findForm.a_3.selectedIndex;

Line: 526


                        var temp=document.findForm.c_3.selectedIndex;

Line: 530


                        var temp=document.findForm.a_4.selectedIndex;

Line: 532


                        var temp=document.findForm.c_4.selectedIndex;

Line: 536


                        var temp=document.findForm.a_5.selectedIndex;

Line: 538


                        var temp=document.findForm.c_5.selectedIndex;

Line: 615


        select  NAME,DESCRIPTION
        into    l_page_title,l_page_description
        from    AK_FLOW_PAGES_VL
        where   PAGE_CODE = p_page_code
        and     PAGE_APPLICATION_ID = p_page_appl_id
        and     FLOW_CODE = p_flow_code
        and     FLOW_APPLICATION_ID = p_flow_appl_id;

Line: 625


select  NAME,DESCRIPTION
into    l_region_title,l_region_description
from    AK_REGIONS_VL
where   REGION_CODE = l_region_code
and     REGION_APPLICATION_ID = p_region_appl_id;

Line: 727


                htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(1));

Line: 728


        	htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(1));

Line: 730


                htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(0));

Line: 731


        	htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(0));

Line: 853


        select  REGION_APPLICATION_ID,REGION_CODE,ICX_CUSTOM_CALL
        from    AK_FLOW_PAGE_REGIONS
        where   FLOW_CODE = l_flow_code
        and     FLOW_APPLICATION_ID = l_flow_appl_id
        and     PAGE_CODE = c_to_page_code
        and     PAGE_APPLICATION_ID = c_to_page_appl_id
        order by DISPLAY_SEQUENCE;

Line: 919


        select  FLOW_APPLICATION_ID,FLOW_CODE,
                TO_PAGE_APPL_ID,TO_PAGE_CODE
        into    l_flow_appl_id,l_flow_code,
                c_to_page_appl_id,c_to_page_code
        from    AK_FLOW_REGION_RELATIONS
        where   ROWID = c_rowid;

Line: 1001


select	count(*)
into	l_row_count
from    AK_FLOW_REGION_RELATIONS a,
        AK_FOREIGN_KEYS b
where   a.FROM_REGION_CODE = c_from_region_code
and     a.FROM_REGION_APPL_ID = c_from_region_appl_id
and     a.FROM_PAGE_CODE = c_to_page_code
and     a.FROM_PAGE_APPL_ID = c_to_page_appl_id
and     a.FLOW_CODE = l_flow_code
and     a.FLOW_APPLICATION_ID = l_flow_appl_id
and     a.FOREIGN_KEY_NAME = b.FOREIGN_KEY_NAME;

Line: 1016


select  a.ROWID,b.UNIQUE_KEY_NAME,
	a.TO_PAGE_APPL_ID,a.TO_PAGE_CODE
into    c_rowid,c_unique_key_name,
	c_to_page_appl_id,c_to_page_code
from    AK_FLOW_REGION_RELATIONS a,
        AK_FOREIGN_KEYS b
where   a.FROM_REGION_CODE = c_from_region_code
and     a.FROM_REGION_APPL_ID = c_from_region_appl_id
and     a.FROM_PAGE_CODE = c_to_page_code
and     a.FROM_PAGE_APPL_ID = c_to_page_appl_id
and     a.FLOW_CODE = l_flow_code
and     a.FLOW_APPLICATION_ID = l_flow_appl_id
and     a.FOREIGN_KEY_NAME = b.FOREIGN_KEY_NAME;

Line: 1069


select  QUERY_SET, MAX_ROWS
into    l_query_set, l_max_rows
from    ICX_PARAMETERS;

Line: 1133


       	select  FROM_PAGE_APPL_ID,FROM_PAGE_CODE,
               	FROM_REGION_APPL_ID,FROM_REGION_CODE
       	into    c_from_page_appl_id,c_from_page_code,
               	c_from_region_appl_id,c_from_region_code
       	from    AK_FLOW_REGION_RELATIONS
       	where   ROWID = c_rowid;

Line: 1239


select  NAME,DESCRIPTION
into    l_page_title,l_page_description
from    AK_FLOW_PAGES_VL
where   PAGE_CODE = l_page_code
and	PAGE_APPLICATION_ID = l_page_appl_id
and	FLOW_CODE = l_flow_code
and	FLOW_APPLICATION_ID = l_flow_appl_id;

Line: 1349


      select	DESCRIPTION
      into	l_region_description
      from	AK_REGIONS_VL
      where	REGION_APPLICATION_ID = ak_query_pkg.g_regions_table(r).region_application_id
      and	REGION_CODE = ak_query_pkg.g_regions_table(r).region_code;

Line: 1557


	    select  ICX_CONTEXT_RESULTS_TEMP_S.nextval
            into    l_query_id
            from    sys.dual;

Line: 2111


select  to_date(p_date,icx_sec.g_date_format)
into    l_dummy_date
from    sys.dual;

Line: 2118


	select to_date(p_date,'XX-XXX-XXXX')
	into l_dummy_date
	from sys.dual;