<ROOT>
 <APPS_INITIALIZE_DATA>
  <USER_NAME>ENGINATICS</USER_NAME>
  <RESPONSIBILITY_KEY>SYSTEM_ADMINISTRATOR</RESPONSIBILITY_KEY>
  <APPLICATION_SHORT_NAME>SYSADMIN</APPLICATION_SHORT_NAME>
 </APPS_INITIALIZE_DATA>
<REPORTS>
<!-- loader xml for Enginatics Blitz Report: PSB Flexfield Mapping -->
 <REPORTS_ROW>
  <GUID>82288223F4233869E053B46B63588994</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>select distinct a.code_combination_id in_ccid, 
	PSB_PSBRPFLX_XMLP_PKG.cf_accountformula(a.code_combination_id) CF_ACCOUNT
from psb_ws_account_lines a,gl_code_combinations cc
where a.currency_code &lt;&gt; &apos;STAT&apos; and
a.code_combination_id = cc.code_combination_id and
cc.summary_flag &lt;&gt; &apos;Y&apos; and
exists
(select 1 from psb_ws_lines b
where b.account_line_id = a.account_line_id and
b.worksheet_id =:p_global_worksheet_id )
order by a.code_combination_id
</SQL_TEXT>
  <XDO_APPLICATION_SHORT_NAME>PSB</XDO_APPLICATION_SHORT_NAME>
  <XDO_DATA_SOURCE_CODE>PSBRPFLX_XML</XDO_DATA_SOURCE_CODE>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>PSB Flexfield Mapping</REPORT_NAME>
    <DESCRIPTION>Application: Public Sector Budgeting (Obsolete)
Source: Flexfield Mapping Report (XML)
Short Name: PSBRPFLX_XML
DB package: PSB_PSBRPFLX_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>BI Publisher</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
  </CATEGORY_ASSIGNMENTS>
  <ANCHORS>
   <ANCHORS_ROW>
    <ANCHOR>:p_global_worksheet_id</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>:p_global_worksheet_id</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>PSB_SRS_WS_FLEX</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
worksheet_id id,
worksheet_id value,
name description
from
psb_worksheets
where flex_mapping_set_id is not null
order by value,description</LOV_QUERY_DSP>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Worksheet</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <TEMPLATES>
  </TEMPLATES>
  <DEFAULT_TEMPLATES>
  </DEFAULT_TEMPLATES>
  <UPLOAD_COLUMNS>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
  </UPLOAD_PARAMETERS>
  <UPLOAD_SQLS>
  </UPLOAD_SQLS>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
