<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>
<LOVS>
<!-- loader xml for Enginatics Blitz Report lov: FND Application Name -->
 <LOVS_ROW>
  <GUID>8E2FF36EDE9879D2E0530100007F1FF2</GUID>
  <LOV_NAME>FND Application Name</LOV_NAME>
  <VALIDATE_FROM_LIST>Y</VALIDATE_FROM_LIST>
  <LOV_QUERY>select
fav.application_name value,
fav.application_short_name description
from
fnd_application_vl fav
order by
fav.application_name</LOV_QUERY>
  <LOV_TRANSLATIONS>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
   </LOV_TRANSLATIONS_ROW>
  </LOV_TRANSLATIONS>
 </LOVS_ROW>
<!-- loader xml for Enginatics Blitz Report lov: FND Concurrent Program Name -->
 <LOVS_ROW>
  <GUID>8E2FF36EDE9D79D2E0530100007F1FF2</GUID>
  <LOV_NAME>FND Concurrent Program Name</LOV_NAME>
  <VALIDATE_FROM_LIST>Y</VALIDATE_FROM_LIST>
  <LOV_QUERY>select
fcpt.user_concurrent_program_name value,
fav.application_name||nvl2(fcpt.description,&apos;: &apos;,null)||fcpt.description description
from
fnd_application_vl fav,
fnd_concurrent_programs_tl fcpt
where
fcpt.language=userenv(&apos;lang&apos;) and
fcpt.application_id=fav.application_id
order by
fcpt.user_concurrent_program_name</LOV_QUERY>
  <LOV_TRANSLATIONS>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <DESCRIPTION>اسم البرنامج المتزامن FND</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <DESCRIPTION>FND gleichzeitiger Programmname</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>E</LANGUAGE>
    <DESCRIPTION>Nombre del programa concurrente FND</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <DESCRIPTION>Nom du programme concurrent du FND</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>I</LANGUAGE>
    <DESCRIPTION>Nome del programma concorrente FND</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>JA</LANGUAGE>
    <DESCRIPTION>FND 同時進行プログラム名</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>KO</LANGUAGE>
    <DESCRIPTION>FND 동시 작업 프로그램 이름</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>PTB</LANGUAGE>
    <DESCRIPTION>FND nome do programa concorrente</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>RU</LANGUAGE>
    <DESCRIPTION>одновременное имя программы FND</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>S</LANGUAGE>
    <DESCRIPTION>FND-samtidiga programnamn</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>TR</LANGUAGE>
    <DESCRIPTION>FND eşzamanlı program adı</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <DESCRIPTION>FND concurrent program name</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <DESCRIPTION>FND并发程序名称</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
  </LOV_TRANSLATIONS>
 </LOVS_ROW>
<!-- loader xml for Enginatics Blitz Report lov: FND Concurrent Program Short Name -->
 <LOVS_ROW>
  <GUID>8E2FF36EDEA179D2E0530100007F1FF2</GUID>
  <LOV_NAME>FND Concurrent Program Short Name</LOV_NAME>
  <VALIDATE_FROM_LIST>Y</VALIDATE_FROM_LIST>
  <LOV_QUERY>select
fcpv.concurrent_program_name value,
fav.application_name||&apos;: &apos;||fcpv.user_concurrent_program_name description
from
fnd_application_vl fav,
fnd_concurrent_programs_vl fcpv
where
fav.application_id=fcpv.application_id
order by
fcpv.concurrent_program_name</LOV_QUERY>
  <LOV_TRANSLATIONS>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
   </LOV_TRANSLATIONS_ROW>
  </LOV_TRANSLATIONS>
 </LOVS_ROW>
</LOVS>
<REPORTS>
<!-- loader xml for Enginatics Blitz Report: Blitz Report RDF Import Validation -->
 <REPORTS_ROW>
  <GUID>006A171D9E8F1965E0636AFB09054F9F</GUID>
  <SQL_TEXT>select
fcpv.user_concurrent_program_name,
fcpv.concurrent_program_name,
fav.application_name,
fav.application_short_name,
fav.basepath application_top,
fe.execution_file_name,
fcpv2.concurrent_program_name bip_concurrent_program,
fcpv2.user_concurrent_program_name bip_concurrent_program_name,
xxen_util.user_name(fcpv2.created_by) bip_created_by,
xxen_util.client_time(fcpv2.creation_date) bip_creation_date,
uo.object_name db_package_name,
uo.status,
uo.created,
uo.last_ddl_time,
xrv.report_name,
xrv.category,
xxen_util.user_name(xrv.created_by) xrv_created_by,
xxen_util.client_time(xrv.creation_date) xrv_creation_date,
fcpv.application_id,
fcpv.concurrent_program_id
from
fnd_concurrent_programs_vl fcpv,
fnd_concurrent_programs_vl fcpv2,
fnd_application_vl fav,
fnd_executables fe,
(
select
regexp_substr(xrv.description,chr(10)||&apos;Short Name: (.+)&apos;,1,1,null,1) short_name,
regexp_substr(xrv.description,chr(10)||&apos;DB package: (.+)&apos;,1,1,null,1) bip_package,
xrv.*
from
xxen_reports_v xrv
where
xrv.description like &apos;Imported from BI Publisher%&apos;
) xrv,
user_objects uo
where
1=1 and
fcpv.execution_method_code=&apos;P&apos; and
fcpv.executable_application_id=fav.application_id and
fcpv.executable_id=fe.executable_id and
fcpv.executable_application_id=fe.application_id and
fcpv.concurrent_program_name||&apos;_XML&apos;=fcpv2.concurrent_program_name(+) and
fcpv.concurrent_program_name||&apos;_XML&apos;=xrv.short_name(+) and
fcpv.concurrent_program_name=uo.object_name(+) and
uo.object_type(+)=&apos;PACKAGE&apos;
order by
fcpv2.creation_date desc,
fav.application_short_name</SQL_TEXT>
  <ENABLED>Y</ENABLED>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>Blitz Report RDF Import Validation</REPORT_NAME>
    <DESCRIPTION>Validates the import of RDF concurrent programs</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>Enginatics</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
  </CATEGORY_ASSIGNMENTS>
  <ANCHORS>
   <ANCHORS_ROW>
    <ANCHOR>1=1</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>fav.application_name=:application_name</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>FND Application Name</LOV_NAME>
    <LOV_GUID>8E2FF36EDE9879D2E0530100007F1FF2</LOV_GUID>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
fav.application_name value,
fav.application_short_name description
from
fnd_application_vl fav
order by
fav.application_name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Application Name</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>2</SORT_ORDER>
    <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>fav.application_name like :application_name_like</SQL_TEXT>
    <PARAMETER_TYPE_DSP>Char</PARAMETER_TYPE_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Application Name Like</PARAMETER_NAME>
      <DESCRIPTION>Application Name Like</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>3</SORT_ORDER>
    <DISPLAY_SEQUENCE>30</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>fav.application_short_name like :application_short_name_like</SQL_TEXT>
    <PARAMETER_TYPE_DSP>Char</PARAMETER_TYPE_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Application Short Name Like</PARAMETER_NAME>
      <DESCRIPTION>Application Short Name Like</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>4</SORT_ORDER>
    <DISPLAY_SEQUENCE>35</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>fcpv.user_concurrent_program_name=:user_concurrent_program_name</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>FND Concurrent Program Name</LOV_NAME>
    <LOV_GUID>8E2FF36EDE9D79D2E0530100007F1FF2</LOV_GUID>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
fcpt.user_concurrent_program_name value,
fav.application_name||nvl2(fcpt.description,&apos;: &apos;,null)||fcpt.description description
from
fnd_application_vl fav,
fnd_concurrent_programs_tl fcpt
where
fcpt.language=userenv(&apos;lang&apos;) and
fcpt.application_id=fav.application_id
order by
fcpt.user_concurrent_program_name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Concurrent Program Name</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>5</SORT_ORDER>
    <DISPLAY_SEQUENCE>37</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>fcpv.user_concurrent_program_name like :user_concurrent_program_name_like</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <LOV_QUERY_DSP>select
fcpt.user_concurrent_program_name value,
fav.application_name||nvl2(fcpt.description,&apos;: &apos;,null)||fcpt.description description
from
fnd_application_vl fav,
fnd_concurrent_programs_tl fcpt
where
fcpt.language=userenv(&apos;lang&apos;) and
fcpt.application_id=fav.application_id
order by
fcpt.user_concurrent_program_name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Concurrent Program Name Like</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>6</SORT_ORDER>
    <DISPLAY_SEQUENCE>40</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>fcpv.concurrent_program_name=:concurrent_program_name</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>FND Concurrent Program Short Name</LOV_NAME>
    <LOV_GUID>8E2FF36EDEA179D2E0530100007F1FF2</LOV_GUID>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
fcpv.concurrent_program_name value,
fav.application_name||&apos;: &apos;||fcpv.user_concurrent_program_name description
from
fnd_application_vl fav,
fnd_concurrent_programs_vl fcpv
where
fav.application_id=fcpv.application_id
order by
fcpv.concurrent_program_name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Program Short Name</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>7</SORT_ORDER>
    <DISPLAY_SEQUENCE>50</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>fcpv.concurrent_program_name like :concurrent_program_name_like</SQL_TEXT>
    <PARAMETER_TYPE_DSP>Char</PARAMETER_TYPE_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Program Short Name Like</PARAMETER_NAME>
      <DESCRIPTION>Concurrent Program Name Like</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>8</SORT_ORDER>
    <DISPLAY_SEQUENCE>60</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>exists (select null from fnd_concurrent_requests fcr where fcpv.concurrent_program_id=fcr.concurrent_program_id and fcpv.application_id=fcr.program_application_id and fcr.request_date&gt;=:p_last_run_date)</SQL_TEXT>
    <PARAMETER_TYPE_DSP>Date</PARAMETER_TYPE_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Last Run Date</PARAMETER_NAME>
      <DESCRIPTION>Last Run Date</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <PARAMETER_DEPENDENCIES>
  </PARAMETER_DEPENDENCIES>
  <TEMPLATES>
  </TEMPLATES>
  <DEFAULT_TEMPLATES>
  </DEFAULT_TEMPLATES>
  <UPLOAD_COLUMNS>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
  </UPLOAD_PARAMETERS>
  <UPLOAD_SQLS>
  </UPLOAD_SQLS>
  <UPLOAD_DEPENDENCIES>
  </UPLOAD_DEPENDENCIES>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
