<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: Blitz Report Parameter DFF Table Validation -->
 <REPORTS_ROW>
  <GUID>1CE00E514456E4AFE0630100007F242E</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>select
y.*
from
(
select
xrpv.report_name,
xrpv.display_sequence,
xrpv.parameter_name,
dbms_lob.substr(regexp_substr(xrpv.sql_text,&apos;xxen_util\.dff_columns\((p_table_name=&gt;)?&apos;&apos;(\w+)&apos;&apos;&apos;,1,x.column_value,&apos;i&apos;,2)) dff_table_name,
dbms_lob.substr(xrpv.sql_text) sql_text,
xxen_util.user_name(xrpv.created_by) created_by,
xxen_util.client_time(xrpv.creation_date) creation_date,
xxen_util.user_name(xrpv.last_updated_by) last_updated_by,
xxen_util.client_time(xrpv.last_update_date) last_update_date,
xrpv.sort_order
from
xxen_report_parameters_v xrpv,
table(xxen_util.rowgen(regexp_count(xrpv.sql_text,&apos;xxen_util\.dff_columns\((p_table_name=&gt;)?&apos;&apos;(\w+)&apos;&apos;&apos;))) x
where
lower(xrpv.sql_text) like &apos;%xxen_util.dff_columns%&apos;
) y
where
upper(y.dff_table_name) not in (select fdfv.application_table_name from fnd_descriptive_flexs_vl fdfv where fdfv.descriptive_flexfield_name not like &apos;$SRS$%&apos;)
order by
y.report_name,
y.parameter_name,
y.sort_order</SQL_TEXT>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter DFF Table Validation</REPORT_NAME>
    <DESCRIPTION>Shows any parameters using the xxen_util.dff_columns function, which reference an incorrect DFF table name.</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>Enginatics</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
  </CATEGORY_ASSIGNMENTS>
  <ANCHORS>
  </ANCHORS>
  <PARAMETERS>
  </PARAMETERS>
  <TEMPLATES>
  </TEMPLATES>
  <DEFAULT_TEMPLATES>
  </DEFAULT_TEMPLATES>
  <UPLOAD_COLUMNS>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
  </UPLOAD_PARAMETERS>
  <UPLOAD_SQLS>
  </UPLOAD_SQLS>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
