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.

[Home] [Help]

APPS.ICX_DATATEMPLATE_PKG SQL Statements

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

Line: 73


    SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP,
          AG.ATTR_GROUP_ID ATTR_GROUP_ID,
          AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,
          AG.MULTI_ROW MULTI_ROW
    FROM EGO_FND_DSC_FLX_CTX_EXT AG,
         PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
    WHERE POT.TEMPLATE_ID = POTU.TEMPLATE_ID
    AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
    AND AG.ATTR_GROUP_ID  = POTU.ATTRIBUTE_GROUP_ID
    AND potu.attribute_group_id in (select distinct attr_group_id
                                    from po_req_headers_ext_b
                                    where requisition_header_id = reqHeaderId
                                    and uda_template_id = potu.template_id
                                    and attr_group_id = potu.attribute_group_id)
    ORDER BY POTU.ATTRIBUTE_GROUP_SEQUENCE;

Line: 90


    SELECT   EFDFCE.ATTR_ID                ,
    EFDFCE.APPLICATION_COLUMN_NAME      ,
    FCU.END_USER_COLUMN_NAME,
    fcu.flex_value_set_id,
    EFDFCE.data_type
    FROM
      EGO_FND_DF_COL_USGS_EXT EFDFCE,
      FND_DESCR_FLEX_COLUMN_USAGES FCU
    WHERE EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME = P_DESC_FLEXFLD_NAME
    AND EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE  = P_ATTR_GROUP
    AND FCU.DESCRIPTIVE_FLEX_CONTEXT_CODE = EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE
    AND FCU.DESCRIPTIVE_FLEXFIELD_NAME = EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME
    AND FCU.APPLICATION_COLUMN_NAME = EFDFCE.APPLICATION_COLUMN_NAME
    AND FCU.DISPLAY_FLAG <> 'H';

Line: 117


        L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
                 || '", XMLAgg(XMLForest(' ;

Line: 120


        L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '", XMLAgg(XMLForest(';

Line: 124


        L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
                  || '", XMLForest(' ;

Line: 127


        L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '", XMLForest(';

Line: 161


  l_op := ' select XMLConcat(' || l_sql || ') from dual';

Line: 179


    SELECT 	ag.attr_group_id,
            efdfce.application_column_name
    into   l_attr_grp_id, l_col_name
    FROM ego_fnd_dsc_flx_ctx_ext ag,
         ego_fnd_df_col_usgs_ext efdfce,
         fnd_descr_flex_column_usages fcu
    WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
    and efdfce.descriptive_flex_context_code  = ag.descriptive_flex_context_code
    and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
    and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name
    and fcu.application_column_name = efdfce.application_column_name
    and  ag.DESCRIPTIVE_FLEXFIELD_NAME = 'PO_REQ_HEADER_EXT_ATTRS'
    and upper(ag.descriptive_flex_context_code) = upper('addresses')
    and upper(fcu.end_user_column_name) = upper('addressdtlsxml');

Line: 196


    l_addr_sql := 'select ' || l_col_name || ' as address ' ;

Line: 235


    SELECT 	ag.attr_group_id,
            efdfce.application_column_name
    into   l_attr_grp_id, l_col_name
    FROM ego_fnd_dsc_flx_ctx_ext ag,
         ego_fnd_df_col_usgs_ext efdfce,
         fnd_descr_flex_column_usages fcu
    WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
    and efdfce.descriptive_flex_context_code  = ag.descriptive_flex_context_code
    and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
    and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name
    and fcu.application_column_name = efdfce.application_column_name
    and  ag.DESCRIPTIVE_FLEXFIELD_NAME = 'PO_REQ_HEADER_EXT_ATTRS'
    and upper(ag.descriptive_flex_context_code) = upper('addresses')
    and upper(fcu.end_user_column_name) = upper('contactdtlsxml');

Line: 252


    l_cnt_sql := 'select ' || l_col_name || ' as contacts ' ;

Line: 295


    SELECT 	ag.attr_group_id,
            efdfce.application_column_name
    into   l_attr_grp_id, l_col_name
    FROM ego_fnd_dsc_flx_ctx_ext ag,
         ego_fnd_df_col_usgs_ext efdfce,
         fnd_descr_flex_column_usages fcu
    WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
    and efdfce.descriptive_flex_context_code  = ag.descriptive_flex_context_code
    and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
    and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name
    and fcu.application_column_name = efdfce.application_column_name
    and  ag.DESCRIPTIVE_FLEXFIELD_NAME = 'PO_REQ_HEADER_EXT_ATTRS'
    and upper(ag.descriptive_flex_context_code) = upper('MIPR_ACC_INFO')
    and upper(fcu.end_user_column_name) IN ('AUTH_OFFICER') ;

Line: 312


    l_auth_sql := 'select ' || l_col_name || ' as AUTH_OFFICER_ID ' ;

Line: 325


    l_auth_sql_1 := 'select nvl(hr_general.decode_position_latest_name (pa.position_id),jbt.name)
from per_all_assignments_f pa, per_jobs_tl jbt
where jbt.job_id(+) =pa.job_id and  jbt.language=userenv(''LANG'')
and sysdate between nvl(pa.effective_start_date,sysdate) and  nvl(pa.effective_end_date,sysdate)
and pa.person_id =:1';

Line: 387


  select  decode(l_address_line_1,null,'',l_address_line_1||' ')||
          decode(l_address_line_2,null,'',l_address_line_2||' ')||
          decode(l_address_line_3,null,'',l_address_line_3||' ')||
          decode(l_town_or_city,null,'',l_town_or_city||',')||
          decode(l_state_or_province,null,'',l_state_or_province||',')||
          decode(l_territory_short_name, null,'',l_territory_short_name||',')||
          l_postal_code
  into address_string
  from dual;

Line: 404


SELECT  ag.attr_group_id as attr_grp_id,
	 	efdfce.application_column_name as appl_col_name,
	 	fcu.end_user_column_name as end_user_col_name
FROM ego_fnd_dsc_flx_ctx_ext ag,
     ego_fnd_df_col_usgs_ext efdfce,
     fnd_descr_flex_column_usages fcu
WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
and efdfce.descriptive_flex_context_code  = ag.descriptive_flex_context_code
and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name
and fcu.application_column_name = efdfce.application_column_name
and  ag.DESCRIPTIVE_FLEXFIELD_NAME = 'PO_REQ_HEADER_EXT_ATTRS'
and upper(ag.descriptive_flex_context_code) = upper('MIPR_ACC_INFO')
and upper(fcu.end_user_column_name) IN ('FUNDS_INFO', 'AMOUNT') ;

Line: 435


  		l_auth_sql :=  'select ' || rec.appl_col_name || ' as ' || rec.end_user_col_name;

Line: 462


  l_op := ' select XMLConcat( ' || l_xml_sql || ') from dual';

Line: 471


  SELECT count(*), clm_mipr_obligation_type
  FROM po_requisition_lines_all
  WHERE requisition_header_id = reqHeaderId
  GROUP BY clm_mipr_obligation_type
  HAVING clm_mipr_obligation_type is not null;

Line: 507


  l_sql := 'SELECT XMLCONCAT(XMLELEMENT(REIMBURSEMENT_FLAG, '''
   					|| l_reimbursement_flag || '''),
  					XMLELEMENT(DIRECT_CITATION_FLAG, '''
  					|| l_direct_citation_flag||'''), XMLELEMENT(OBLG_BOTH_FLAG,'''
  					|| l_both_flag ||''')) FROM DUAL';

Line: 526


  SELECT data_source_code INTO x_datadef
  FROM XDO_TEMPLATES_VL
  WHERE template_code = 'ICXMIPRDD448';

Line: 540


  SELECT data_source_code INTO x_datadef
  FROM XDO_TEMPLATES_VL
  WHERE template_code = 'ICXMIPRDD4482';

Line: 563


    SELECT 	ag.attr_group_id,
          LISTAGG (efdfce.application_column_name, ',')
          WITHIN GROUP
          (ORDER BY efdfce.application_column_name) cols
    INTO l_attr_group_id, l_col_names
    FROM ego_fnd_dsc_flx_ctx_ext ag,
          ego_fnd_df_col_usgs_ext efdfce,
          fnd_descr_flex_column_usages fcu
    WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
    and efdfce.descriptive_flex_context_code  = ag.descriptive_flex_context_code
    and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
    and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name
    and fcu.application_column_name = efdfce.application_column_name
    and  ag.DESCRIPTIVE_FLEXFIELD_NAME = 'PO_REQ_HEADER_EXT_ATTRS'
    and upper(ag.descriptive_flex_context_code) = upper('addresses')
    AND upper(fcu.end_user_column_name) IN (upper(p_col_name), upper('addresstype'))
    GROUP BY ag.attr_group_id;

Line: 581


    SELECT substr(l_col_names, 1, InStr(l_col_names, ',')-1), substr(l_col_names, InStr(l_col_names, ',')+1) INTO  l_addresstype, l_address_det FROM dual;

Line: 583


    l_sql := 'select ' || l_col_names || ' from po_req_headers_ext_vl where requisition_header_id = :1  and attr_group_id = :2 and ' ||
              l_addresstype || ' = :3';

Line: 615


  SELECT  ag.attr_group_id,
	 	      efdfce.application_column_name
  INTO    l_attr_grp_id, l_col_name
  FROM ego_fnd_dsc_flx_ctx_ext ag,
      ego_fnd_df_col_usgs_ext efdfce,
      fnd_descr_flex_column_usages fcu
  WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
  and efdfce.descriptive_flex_context_code  = ag.descriptive_flex_context_code
  and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
  and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name
  and fcu.application_column_name = efdfce.application_column_name
  and  ag.DESCRIPTIVE_FLEXFIELD_NAME = 'PO_REQ_HEADER_EXT_ATTRS'
  and upper(ag.descriptive_flex_context_code) = upper('MIPR_ACC_INFO')
  and upper(fcu.end_user_column_name) = 'MIPR_ACC_STAT';

Line: 630


  l_acc_sql := 'select ' || l_col_name || ' as CLM_MIPR_ACCEPTANCE_STATUS ' ;